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 55, 009 $ 250 Heavy coil 35, 000 350 . Raw-material prices and inventory levels: Expected Inventories, Desired Inventories, Anticipated Raw Material January 1, 20x0 December 31, 20x0 Purchase Price Sheet metal 33,090 1b. 37, 090 1b. $ 14 Copper wire 30, 000 1b. 33, 090 1b. Platform 5,500 units 6, 500 units . Use of raw material: Amount Used per Unit Raw Material Light Coil Heavy Coil Sheet metal 4 1b. 5 1b. Copper wire 2 1b. 3 1b. Platform 1 unit- Directlabor requirements and rates: Light coil 4 $ 16 Heavy coil 6 15 - Finishedgoods inventories {In units]: Light coil 26, 666 2 Heavy coil 8,666 I. ' - Production overhead: Purchasing and material handling $6.56 per pound of sheet metal and copper lwire purchased Depreciation, utilities, and inspection $6.66 per coil produced [either type) Shipping $2.66 per coil shipped (either type) General production overhead $4.66 per directlabor hour Required: 1. Prepare 1he sales budgei [in dollars] for 20:10. \f2. Prepare the production budget (in units) for 20x0. Production Budget (in units) for 20x0 Light Coils Heavy Coils Projected sales Add: Desired inventories, December 31, 20x0 Total requirements Less: Expected inventories, January 1, 20x0 Production required (units)3. Prepare the raw material purchases budget (in quantities) for 20x0. Raw Material Purchases Budget (in Quantities) for 20x0 Raw Material Sheet Metal Copper Wire Platform Light coils Heavy coils Production requirements 0 0 Add: Desired inventories, December 31, 20x0 Total requirements Less: Expected inventories, January 1, 20x0 Purchase requirements (units)4. Prepare the raw material purchases budget (in dollars) for 20x0. Raw Material Purchases Budget for 20x0 Raw Material Raw Material Anticipated Required (units) Purchase Price Total Sheet metal Copper wire Platforms Total5. Prepare the direct-labor budget (in dollars) for 20x0. Direct-Labor Budget for 20x0 Projected Hours per Total Hours Rate Total Cost Production (units) Unit Light coils Heavy coils Total 06. Prepare the productionoverhead budget {in dollars] for 20x0. {Round \"Cost Driver Rate\" 1:0 2 decimal places.) Purchasing and material handling Depreciation, utilities, and inspection m Shipping w General production ova-mead Total production overhead