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 56,000 $ 260 Heavy coil 36,000 360 Raw-material prices and inventory levels: Expected Inversories, Raw Material January 1, 2exe Sheet metal 34,800 lb. Copper wire 31,000 lb Platform 5,600 units Desired Inventories, December 31, 20x8 38,000 lb. 34,000 lb. 6,600 units Anticipated Purchase Price $ 15 4 Use of raw material: Raw Material Sheet metal Copper wire Platform Amount Used per Unit Light Coil Heavy Coil 5 lb. 6 lb. 3 lb. 4 lb. 2 unit Direct-labor requirements and rates: Hours per Unit Product Light coil Heavy coil un w Rate per Hour $ 15 20 Finished-goods inventories (in units); Product Light coil Heavy coil Expected January 1, 2exe 21, 8,5ee Desired December 31, 20x0 26,000 9,500 Required information Overhead Cost Item Purchasing and material handling Depreciation, utilities, and inspection Shipping General production overhead Activity-Based Budget Rate $0.60 per pound of sheet metal and copper wire purchased $5.ee per coil produced (either type) $1.ee per coil shipped (either type) $3.00 per direct-labor hour Required: 1. Prepare the sales budget (in dollars) for 20x0. Sales Budget for 20x0 Total Light coils Heavy coils Projected sales