please show all work for exercises 10-7,10-8,10-9

HAPTER 10 Budgetary Planning and Control EXCEL EXERCISE 10-7. Direct Materials Purchases Budget [LO 2] Rochler Industrial has estimated that production for the next five quarters will be Production Information 1st quartet, 2017 2nd quarter. 2017 3rd quarter, 2017 4th quarter, 2017 Ist quarter, 2018 45,000 units 41,000 units 49,000 units 38,000 units 47,000 units Finished units of production require 6 pounds of raw material per unit. The raw material cost is $7 per pound There is $283,500 of raw materal on hand at the beginning of the first quarter, 2017. Rochler desires to bave 15 percent of next quarters material requirements on hand at the end of each quarter REQUIRED Prepare quarterly direct materials parchases budgets for Rochler Industrial for 2017 EXERCISE 10-a. Direct Labor Budget ILO 1] Prepare quarterly direct labor badgets for Rochler Industrial for 2017, using the production information in Esercise 10-7. It takes 3.0 bours of direct labor to produce each finished unit of product. Direct labor costs are $20 per hour. Each employe can work 470 hours per quarter EXERCISE 10-9. Manufacturing Overhead Budget Lo 21 Prepare quarterly manufacturing overhead budgets for Roehler Industrial for 2017, using the production information from Exercise 10-7. Rochler has overhead costs as follows Variable Costs Fixed Costs per Quarter Indirect material Indirect labor $3.25 per unit Sapervisory salaries $70,000 220 per unit Factory depreciation 37,000 Utilities 0.50 per unit Ocher 6,000