. Directlabor requirements and rates: Product Hours per Unit Rate per Hour Light coil 6 $ 18 Heavy coil 8 15 - Finishedgoods inventories [in units): Expected Desired Product January 1J 28x8 December 31J 28x8 Light coil 39,999 35,999 Heavy coil 9,888 19,888 - Production overhead: Overhead Cost Item Activity-Based Budget Rate Purchasing and material handling $8.98 per pound of sheet metal and copper wire purchased DepreciationJ utilitiesJ and inspection $8.88 per coil produced (either type) Shipping $2.88 per coil shipped (either type} General production overhead $6.99 per directlabor hour Required: 1. Prepare the sales budget (in dollars) for 20x0. Light COIIS Projected sales 2. Prepare the production budget (in units) for 20x0. Projected sales Total requirements Production required {units} 3. Prepare the rawr material purchases budget (in quantities) for 20x0. Light coils Heavy coils Production requirements Purchase requirements (units) 4. Prepare the raw material purchases budget (in dollars) for 20x0. Sheet metal Copper wire 6. Prepare the productionoverhead budget [in dollars) for 20x0. [Round "Cost Driver Rate" to 2 decimal places.) Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Total production overhead 5. Prepare the directlabor budget (in dollars] for 20x0. Light coils Heavy coils Total Required information [T he following information applies to the questions displayed below. ] Vista Electronics, Inc., manufactures two different types of coils used in electric motors. In the fall of the current year. Erica Becker, the controller, compiled the following data. . Sales forecast for 20x0 [all units to be shipped in 20x0): Product Units Price Light coil 61866 $ 359 Heavy coil 451996 459 . Rawmaterial prices and inventory levels: Expected Inventories, Desired Inventories, Anticipated Raw Material January 1, 28x6 December 31J 26x8 Purchase Price Sheet metal 43,933 lb. 47,998 lb. $ 13 Copper wire 49,999 lb. 43,998 lb. 8 Platform 6J 593 units 7, 599 units 4 . Use of raw material: Amount Used per Unit Raw Material Light Coil Heavy Coil Sheet metal 4 lb. 5 lb. Copper wire 2 lb. 3 lb. Platform 1 unit