BUDGET PROBLEM Jonick Sports, Inc. manufactures a unique type of protective helmet. The following is the company's budget information for April: Instructions Use the information given and/or your answers to #1 through to determine the following budget-related amounts for April 1. 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 formules. d. Use the SUM and SUMPRODUCT functions at least once each. . A. Estimated sales of helmets for April: Quantity Unit price 5,000 $311 $1,555,000 $ B. Estimated inventories at April 1: 1,555,000 $158 Direct materials: Pounds Plastic 130 40 Work in process: Amount $27.990 Finished helmets: Quantity Unit cost 360 $177 1. 2. 3. 2 4. 4 5. 6. 7. Estimated sales Number of units to produce Total direct materials to be purchased Total direct labor cost Total factory overhead Total manufacturing costs Cost of goods manufactured Foam lining C. Desired anticipated inventories at April 30: Direct materials: Pounds Plastic 150 Foam lining 20 Work in process Amount $21,000 Finished helmets: Quantity Unit cost 600 $177 D. Direct materials used to produce each helmet: Pounds Plastic 2.5 Foam lining 0.5 S E. Anticipated cost per pound of purchases and inventory amounts of direct materials: Cost per lb. Plastic $27 Foam lining $14 F. Anticipated direct labor requirements to produce each helmet: Hours Hourly cost Molding Department 2.0 $32 Assembly Department 0.5 22 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 $98,000 17,100 11,000 5,600 4,200