Parcells Manufacturing Company produces one product, Olpe. Because of wide fluctuations in demand for Olpe, the Assembly Department experiences significant variations in monthly production levels.

The annual master manufacturing overhead budget is based on 300,000 direct labor hours. In July 27,500 labor hours were worked. The master manufacturing overhead budget for the year and the actual overhead costs incurred in July are as follows.

Instructions(a) Prepare a monthly overhead flexible budget for the year ending December 31, 2010, assuming monthly production levels range from 22,500 to 30,000 direct labor hours. Use increments of 2,500 direct labor hours.(b) Prepare a budget report for the month of July 2010 comparing actual results with budget data based on the flexible budget.(c) Were costs effectively controlled? Explain.(d) State the formula for computing the total monthly budgeted costs in the Parcells Manufacturing Company.(e) Prepare the flexible budget graph showing total budgeted costs at 25,000 and 27,500 direct labor hours. Use increments of 5,000 on the horizontal axis and increments of $10,000 on the verticalaxis.

Transcribed Image Text:

Master Budget (annual) Actual in July Overhead Costs Variable Indirect labor Indirect materials $330,000 180,000 90,000 60,000 $29,000 14,000 Utilities 8,100 Maintenance 5,400 Fixed Supervision Depreciation 150,000 96,000 12,500 8,000 Insurance and taxes 60,000 5,000 $82,000 Total $966,000