Completion requirements
Review this section to be sure you understand variable, fixed, and mixed costs.
Appendix: Performing Regression Analysis with Excel
Review Problem 5.9
Refer to the monthly production cost data for Alta Production, Inc., in Note 5.21 "Review Problem 5.5". Use the four steps of regression analysis described in this appendix to estimate total fixed costs and variable cost per unit. State your results in the equation form Y = f + vX.
Solution to Review Problem 5.9
Regression analysis performed using Excel results in the following output:
Coefficients | |
y-intercept | 703 |
x variable | 1,442.97 |
Thus the total cost equation is:
Y = $703 + $1,442.97X