P22-2B Prepare flexible budget, budget report, and graph for manufacturing overhead. (LO 3),E Gonzalez 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. Master Budget Actual in July Overhead Costs (annual) Variable Indirect labor Indirect materials Utilitics Maintenance 300,000 150,000 90,000 60,000 $26,000 11,350 8,050 5,400 Fixed Supervision Depreciation Insurance and taxes 144,000 96,000 60,000 $900,000 12,000 8,000 5,000 $75,800 Total Instructions (a) Prepare a monthly flexible overhead budget for the year ending December 31,2014, assuming monthly production levels range from 22,500 to 30,000 direct labor hours. Use increments of 2,500 direct labor hours. Total costs: 22,500 DLH $70,000; 30,000 DLH $85,000 (b) Prepare a budget report for the month of July 2014, comparing actual results with budget data based on the flexible budget. Budget $80,000 Actual $75,800