please show work for answers 1-7

Instructions Use the information given and/or your answers to #1 through 6 to determine the following budget-related amounts for April a. Enter answers in the yellow cells for questions #1 through 7 using formulas and/or functions. b. All answers except #2 are asking for dollar amounts. c. Use variables/cell references rather than typing numbers into the formulas. d. Use the SUM and SUMPRODUCT functions at least once each. 1. Estimated sales 2. Number of units to produce 3. Total direct materials to be purchased 4. Total direct labor cost 5. Total factory overhead 6. Total manufacturing costs 7. Cost of goods manufactured BUDGET PROBLEM Jonick Sports, Inc. manufactures a unique type of protective helmet. The following is the company's budget Information for April: A. Estimated sales of helmets for April: Quantity Unit price 7,700 $280 B. Estimated Inventories at April 1: Direct materials: Pounds Plastic 140 Foam lining 90 Work in process: Amount $38,810 Finished helmets: Quantity Unit cost 540 $165 C. Desired/anticipated Inventories at April 30: Finished helmets: Quantity Unit cost 900 $165 Direct materials: Work in process: Pounds Amount Plastic 180 $29,100 Foam lining 70 D. Direct materials used to produce each helmet: Pounds Plastic 2.5 Foam lining 0.5 E. Anticipated cost per pound of purchases and Inventory amounts of direct materials: Cost per lb. Plastic $25 Foam lining $19 F. Anticipated direct labor requirements to produce each helmet: Hours Hourly cost Molding Department 2.0 $28 Assembly Department 0.5 20 Finishing Department 0.25 16 Packing Department 0.25 12 G. Estimated factory overhead costs for April: Amount Indirect factory wages $135,800 Depreciation of plant and equipment 23,700 Utilities 15,300 Insurance 7,800 Property tax 5,800