Percent 6 Normal Bad God Check Cell Explanatory... Inp Styles Home Cut Copy Format Painter board Insert Page Layout Formulas Data Review View V Tell me what you Ariel BIU- 10 AA Wap Text General A Merge & Center 5-% + Conditional Format as Calculation Formatting Table Fant Alignment Number E S N P Q R S F U V W X Y 2 AA AB BUDGET PROBLEM Instructions AE AF AG Sonick 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 6,200 $293 B. Estimated inventories at April 1: Enter formulas analor functions in the yellow calls for questions #1 through 7 that result in various budget-related amounts for April a Use variables/cell references rather than typing numbers into the formulas b. Only reference cells where data is given or where you entered a prestous answer Do not use helper cells c Use the SUM and SUMPRODUCT functions at least once each All items except #2 are asking for dollar amounts 1 Estimated sales 2 Number of units to produce Direct materials Pounds Plastic 110 Foam lining 70 3 Total direct materials to be purchased Work in process Amount Finished helmets: 1 Quantity Unit cost 4 Total direct labor cost 5 Total factory overhead $32,700 420 $167 6 Total manufacturing costs 7 Cost of goods manufactured C. Desired/anticipated inventories at April 30: Direct materials: Posta Plastic 130 Foam lining 60 Work in process: Amount $24,500 Finished helmets: Quantity Unt.cost 700 $167 D. Direct materials used to produce each helmet Pounda Plastic 25 Foam lining 05 E. Anticipated cost per pound of purchases and inventory amounts of direct materials: Goat perb Plastic Foam lining $28 $12 F. Anticipated direct labor requirements to produce each helmet: rady Hours Hourly seat Molding Department 20 $28 Assembly Department 05 20 Finishing Department 0.25 12 Packing Department 025 G. Estimated factory overhead costs for April: Indirect factory wages Depreciation of plant and equipment Amount $114,400 20,000 Utides Inpuranra Test Type here to search 12.900 100 ii Z AA AB BIU- A Merge & Center Format Painter Clipboard Fonti Alignment Formatting Table- E Number L MN 0 P Q R S U V W Pounds Amount Plastic 110 $32,700 Quantity Unit cost 420 5 Total factory overhead $167 6. Total manufacturing costs Foam lining 70 7. Cost of goods manufactured C. Desired/anticipated inventories at April 30: Direct materials: 2 Pounds Plastic 130 Foam lining 60 Work in process: Finished helmets: Amount $24,500 Quantity Unit cost 700 $167 D. Direct materials used to produce each helmet: Plastic Foam lining Pounds 25 0.5 E. Anticipated cost per pound of purchases and inventory amounts of direct materials: Plastic Foam lining Cost per lb $28 $12 F. Anticipated direct labor requirements to produce each helmet: Hours Hourly cost Molding Department 20 $28 Assembly Department 0.5 20 Finishing Department 0.25 12 Packing Department 0.25 8 35 46 47 48 Utilities G. Estimated factory overhead costs for April: Indirect factory wages Depreciation of plant and equipment Amount $114,400 20,000 12,900 49 Insurance 50 Property tax 6,500 4,900 51 52 53 54 55 56 57 58 59 60 61 Ready Test Type here to search + C IT Format Painter Clipboard Font Alignment A1 X M N fx P BUDGET PR EM 4 6 S T 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: U Instructions Enter formulas and/or a. Use variables/cell b. Only reference cell c. Use the SUM and All items except #2 are 7 8 9 10 11 Quantity Unit price 6,200 $293 12 13 14 15 B. Estimated inventories at April 1: Direct materials: 16 Pounds Plastic 110 Foam lining 70 Work in process: Finished helmets: Amount $32,700 Quantity 420 Unit cost $167 19 20 21 222222 C. Desired/anticipated inventories at April 30: Direct materials: 23 Pounds 24 Plastic 130 Work in process: Amount $24,500 Finished helmets: Quantity Unit cost 700 $167 25 Foam lining 60 26 27 D. Direct materials used to produce each helmet: 28 29 30 Pounds Plastic Foam lining 2.5 0.5 311 32 E. Anticipated cost per pound of purchases and inventory amounts of direct materials: 33 34 35 Cost per lb Plastic Foam lining $28 $12 36 37 F. Anticipated direct labor requirements to produce each helmet: 38 39 40 41 42 43 44 Molding Department Hours 20 Hourly cost $28 Assembly Department 0.5 20 Finishing Department 0.25 12 Packing Department 0.25 8 220 G. Estimated factory overhead costs for April: Ready Test Type here to search i 51 52 43 43 44 G. Estimated factory overhead costs for April: Amount 45 46 Indirect factory wages $114,400 47 Depreciation of plant and equipment 20,000 48 Utilities 12,900 49 Insurance 6,500 50 Property tax 4,900 U Instructions W X Y Z AA AB AE AF Enter formulas and/or functions in the yellow cells for questions #1 through 7 that result in various budget-related amounts for A a. Use variables/cell references rather than typing numbers into the formulas. b. Only reference cells where data is given or where you entered a previous answer. Do not use "helper cells". c. Use the SUM and SUMPRODUCT functions at least once each. All items except #2 are asking for dollar amounts. 1. Estimated sales Number of units to produce Total direct materials to be purchased 2. 3. hed helmets: 4. Total direct labor cost ity Unit cost 5. Total factory overhead $167 6. Total manufacturing costs 7. Cost of goods manufactured hed helmets: tity Unit cost $167