Question: 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
In exercise
.png)
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.
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
Step by Step Solution
3.42 Rating (168 Votes )
There are 3 Steps involved in it
1 The multiple regression for overhead cost gives the following formula Overhead cost 603599 456 machine hours 77110 setups 2994 purchase orders Predicted Actual Month Overhead Overhead Variance Janua... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
493-B-C-A-B (1323).docx
120 KBs Word File
