please help me solve these problems and show work on how to do so. I need to insert the answers as formulas in excel. thank uuuuu

Budgeting 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 4,900 $294 B. Estimated Inventories at April 1: Direct materials: Work in process: Amount $25.930 Pounds 130 70 Finished helmets: Quantity Unit cost 360 $179 Plastic Foam lining C. Desired/anticipated inventories at April 30: Direct materials: Work in process: Amount $19,400 Pounds 150 50 Finished helmets: Quantity Unit cost 600 $179 Plastic Foam lining D. Direct materials used to produce each helmet: Pounds Plastic 25 Foam lining 0.5 E. Anticipated cost per pound of purchases and inventory amounts of direct materials: Cost per ID Plastic $29 Foam lining $19 F. Anticipated direct labor requirements to produce each helmet: Hours Hourly cost Molding Department 2.0 $30 Assembly Department 0.5 20 Finishing Department 0.25 16 Packing Department 0.25 12 G. Estimated factory overhead costs for April: Indirect factory wages Depreciation of plant and equipment Utilities Insurance Property tax Amount $90,800 15,800 10.200 5.200 3.900 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