Short-Term Decision-Making
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