# Question

The controller for Muir Company’s Salem plant is analyzing overhead in order to determine appropriate drivers for use in flexible budgeting. She decided to concentrate on the past 12 months since that time period was one in which there was little important change in technology, product lines, and so on. Data on overhead costs, number of machine hours, number of setups, and number of purchase orders are in the following table.

Required:

1. Calculate an overhead rate based on machine hours using the total overhead cost and total machine hours. (Round the overhead rate to the nearest cent and predicted overhead to the nearest dollar.) Use this rate to predict overhead for each of the 12 months.

2. Run a regression equation using only machine hours as the independent variable. Prepare a flexible budget for overhead for the 12 months using the results of this regression equation. (Round the intercept and x-coefficient to the nearest cent and predicted overhead to the nearest dollar.) Is this flexible budget better than the budget in Requirement 1? Why or why not?

Required:

1. Calculate an overhead rate based on machine hours using the total overhead cost and total machine hours. (Round the overhead rate to the nearest cent and predicted overhead to the nearest dollar.) Use this rate to predict overhead for each of the 12 months.

2. Run a regression equation using only machine hours as the independent variable. Prepare a flexible budget for overhead for the 12 months using the results of this regression equation. (Round the intercept and x-coefficient to the nearest cent and predicted overhead to the nearest dollar.) Is this flexible budget better than the budget in Requirement 1? Why or why not?

## Answer to relevant Questions

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 ...Green Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative ...Refer to the data in Exercise 9.15. Required: 1. Compute overhead variances using a two-variance analysis. 2. Compute overhead variances using a three-variance analysis. 3. Illustrate how the two- and three-variance ...A company has gathered the following information from a recent production run: Standard variable overhead rate......... $10 Actual variable overhead rate .......... 8 Standard process hours............. 20 Actual process ...Business Specialty, Inc., manufactures two staplers: small and regular. The standard quantities of direct labor and direct materials per unit for the year are as follows: The standard price paid per pound of direct materials ...Post your question

0