The controller of Dieppe Corporation has decided to prepare a flexible manufacturing overhead budget ranging from 70% to 100% of capacity for the next year, with 50,000 direct labor hours as the 100% level. For costs that are semivariable in behavior, the fixed amount and the variable rate are determined by the high-low method. The direct labor rate is $9.00 per hour. Additional data for manufacturing overhead is attached. The company also had the attached semivariable costs from the previous five years. REQUIRED: Prepare a flexible manufacturing overhead budget ranging from 80% of capacity to 100% of capacity, in 10% intervals. Round all variable manufacturing overhead rates to two decimal places and all dollar amounts to the nearest whole dollar. S DIEPPE CORPORATION DATA FOR MANUFACTURING OVERHEAD FOR COMING YEAR Fixed Costs Per Year: Depreciation Expense Insurance Expense Maintenance Expense (including payroll taxes and fringe benefits) Property Tax Expense Supervisory Salaries Expense (including payroll taxes and fringe benefits) 10,000 3.200 30,000 1.800 42,000 $ Variable costs: Shop Supplies Expense (per direct labor hour) Indirect Labor (excluding inspection) (per direct labor hour) Payroll Taxes and Fringe Benefits (18% of total direct labor cost) 0.15 0.55 ? Google Year 20X0 20X1 DIEPPE CORPORATION SEMIVARIABLE COSTS FROM PREVIOUS FIVE YEARS Direct Labor Hours Power and Light Inspection Miscellaneous Costs 44,000 $ 15,000 $ 10,500 $ 11.800 40,000 14,000 10,200 11,200 45,000 16,000 11,100 12,200 49,000 16,500 12,000 12,600 50,000 17,000 12,500 13,300 20X2 20X3 20X4