Vista Electronics, Inc., manufactures two different types of coils used in electric motors. In the fall ofthe 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 66,000 $ 360 Heavy coil 46,000 460 - Raw-material prices and inventory levels: Expected Inventories, Desired Inventories, Anticipated Raw Material January 1, 20x0 December 31, 20x0 Purchase Price Sheet metal 44,000 lb. 48,000 lb. $ 16 Copper wire 41,000 lb. 44,000 lb. 10 Platform 6,600 units 7,600 units 6 - Use of raw material: Amount Used per Unit Raw Material Light Coil Heavy Coil Sheet metal 3 lb. 4 lb. Copper wire 1 lb. 2 lb. Platform 2 unit - Directlabor requirements and rates: Product Hours per Unit Rate per Hour Light coil 3 $ 15 Heavy coil 5 20 . Production overhead: Overhead Cost Item ActivityBased Budget Rate Purchasing and material handling $0.40 per pound of sheet metal and copper wire purchased Depreciation, utilities, and inspection $9.00 per coil produced (either type) Shipping $1.00 per coil shipped (either type) General production overhead $7.00 per directlabor hour Problem 9-39 Part 3 3. Prepare the raw material purchases budget (in quantities) for 20x0. _ Add: Desired inventories, December 31, 20x0 _ Total requirements ess: Expected inventories January1, 20x0 Purchase requirements (units) _ Problem 9-39 Part 4 4. Prepare the raw material purchases budget (in dollars) for 20x0. Copper wire Platforms i\"Red text indicates no response was expected in a cell or a formulabased calculation is incorrect; no points deducted