P11-38A High Arctic Manufacturing Company produces one product, Kebo. Because of wide fluctuations in the demand for Kebo, the assembly department has significant variations in its monthly production levels. The annual master manufacturing overhead budget is based on 300,000 direct labour hours. In July, 27,500 labour hours were worked. The master manufacturing overhead budget for the year and the actual overhead costs incurred in July are as follows:? see attached

(SO 2,3) Prepare a flexible budget, budget report, and graph for manu facturing overhead. P11-38A High Arctic Manufacturing Company produces one product, Kebo. Because of wide fluctuations in the demand for Kebo, the assembly department has significant variations in its monthly production levels The annual master manufacturing overhead budget is based on 300,000 direct labour hours. In July, 27,500 labour hours were worked. The master manufacturing overhead budget for the year and the actual overhead costs incurred in July are as follows: Overhead Costs Variable Master Budget (annual Actual in Jul Indirect labour Indirect materials Utilities Maintenance $330,000 180,000 150,000 90,000 $29,000 14,000 13,900 8,350 Fixed Supervision Depreciation Insurance and taxes 150,000 96,000 60,000 $1,056,000 12,500 8,000 5,000 $90,750 Total Instructions (a) Prepare a monthly flexible overhead budget for the year ending December 31, 2016, assuming monthly production (a) Total costs: 22,500 DLH, $81,750; DLH, $100,500 Actual $90,750 levels range from 22,500 to 30,000 direct labour hours. Use increments of 2,500 direct labour hours. (b) Prepare a budget performance report for the month of July 2016, comparing actual results with budgeted data, basedTotal costs: 30,000 on the flexible budget. (b) Budget $94,250; (c) Were costs controlled effectively? Explain (d) State the formula for calculating the total monthly budgeted costs for High Arctic Manufacturing Company (e) Prepare a flexible budget graph showing total budgeted costs at 25,000 and 27,500 direct labour hours. Use increments of 5,000 on the horizontal axis and increments of $10,000 on the vertical axis