Refer to Problem 8.40 for data.
In exercise

Required:
1. Run a multiple regression equation using machine hours, number of setups, and number of purchase orders as independent variables. Prepare a flexible budget for overhead for the 12 months using the results of this regression equation. (Round the regression coefficients to the nearest cent and predicted overhead to the nearest dollar.) Which flexible budget is better the one based on simple regression (with machine hours as the only independent variable) or the one based on multiple regression? Why?
2. Now, suppose that the controller remembers that the factory throws two big parties each year, one for the 4th of July and the other for Christmas. Rerun the multiple regression with machine hours, number of setups, and number of purchase orders, and add a dummy variable called €œParty.€ (This variable takes the value one for months with a factory-sponsored party, and zero otherwise.) Prepare a flexible budget for the 12 months using the results of this regression. Discuss the implications of using this new regression for decision making.

Transcribed Image Text:

22 300 70 85 220 37 3 21 70 150 71 0 9 121-9 2 5 2 0910. | 2210220 6007 9586 528780287 16667093377|3 he 3 3 3 3 3 3 4 3 3 3 3 22 4 wo