Required informetion The following information applies to the questions displayed below Vista Electronics, Inc. manufactures two different types of coils used in electric motors. In the fall Part 6 of 6 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 Heavy coil 58,688 $288 . Raw-material prices and inventory levels Raw Material Sheet metal Copper wire Platform Expected Inventories January 1, 2Bre 28,000 1b 25,888 1 Desired Inventories December 31, 28x8 2,900 1b 28,000 1b Anticipated Purchase Price $17 5,000 units 6,808 units .Use of raw material: Anount Used per Unit Raw Material Light Coil Heavy Coil Sheet metal Copper wire 1lb Platform 3 1b 4 1b 2 lb 2 unit . Direct-labor requirements and rates Hours per Unit Product Light coil Heavy coi1 15 .Finished-goods inventories (in units) Expected January 1, 28xe Desired December 31, Light co1l Heavy coil 28x8 29,000 9,588 15,000 8,588 . Production overhead. Overhead Cast Item Activity Based Budget Rate per pound of sheet metal and copper wire purchased Purchasing and material handling 8.60 Depreciation, utilities, and inspection Shipping General production overhead $5.88 per coil produced (either type) 51.60 per coil shipped (either type) 53.88 per direct-labor hour 6. Prepare the production-overheed budget (in dollars) for 20x0. (Round "Cost Driver Rate" to 2 decimal d Budgst for Cost Driver Cost Driver Budgeted Purchasing and material handing Depreciafon, uiites and inspection Shipping Total producton overhead