P Q R S T U V W x Y Z AA AB AC AD AE...

Transcribed Image Text:

P Q R S T U V W x Y Z AA AB AC AD AE AF AG AH 6 7 BUDGET PROBLEM Instructions 8 9 10 Janick Sports, Inc. manufactures a unique type of protective helmet. The following is the company's budget information for April: 11 12 A. Estimated sales of helmets for April: 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. 13 14 Quantity 7,400 Unit price $278 15 16 B. Estimated inventories at April 1: 17 18 19 20 21 Direct materials: Plastic Pounds 170 Foam lining 60 1. Estimated sales 2. 3. Total direct materials to be purchased Work in process: Amount $37,030 Finished helmets: Quantity 540 4. Total direct labor cost Unit cost 5. Total factory overhead $174 6. Total manufacturing costs 7 Cost of goods manufactured Number of units to produce $2,057,200 7,760 22 23 24 25 C. Desired/anticipated inventories at April 30: Direct materials: 26 27 28 Plastic Foam lining Pounds 210 50 Work in process: Amount $27,800 Finished helmets: Quantity 900 Unit cost $174 29 30 D. Direct materials used to produce each helmet: 31 32 Plastic 33 Pounds 2.5 0.5 34 35 38 Foam lining E. Anticipated cost per pound of purchases and inventory amounts of direct materials: Cost per lb. 37 38 Plastic Foam lining $26 $13 39 40 41 42 43 F. Anticipated direct labor requirements to produce each helmet: Molding Department Assembly Department 44 Finishing Department 45 46 47 48 49 50 Packing Department G. Estimated factory overhead costs for April: Indirect factory wages Depreciation of plant and equipment Hours Hourly cost 2.0 $32 0.5 22 0.25 16 0.25 12 Amount $129,600 51 Uslites 52 Insurance 53 Property tax 22,600 14,600 7,400 5,600 54 55 P Q R S T U V W x Y Z AA AB AC AD AE AF AG AH 6 7 BUDGET PROBLEM Instructions 8 9 10 Janick Sports, Inc. manufactures a unique type of protective helmet. The following is the company's budget information for April: 11 12 A. Estimated sales of helmets for April: 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. 13 14 Quantity 7,400 Unit price $278 15 16 B. Estimated inventories at April 1: 17 18 19 20 21 Direct materials: Plastic Pounds 170 Foam lining 60 1. Estimated sales 2. 3. Total direct materials to be purchased Work in process: Amount $37,030 Finished helmets: Quantity 540 4. Total direct labor cost Unit cost 5. Total factory overhead $174 6. Total manufacturing costs 7 Cost of goods manufactured Number of units to produce $2,057,200 7,760 22 23 24 25 C. Desired/anticipated inventories at April 30: Direct materials: 26 27 28 Plastic Foam lining Pounds 210 50 Work in process: Amount $27,800 Finished helmets: Quantity 900 Unit cost $174 29 30 D. Direct materials used to produce each helmet: 31 32 Plastic 33 Pounds 2.5 0.5 34 35 38 Foam lining E. Anticipated cost per pound of purchases and inventory amounts of direct materials: Cost per lb. 37 38 Plastic Foam lining $26 $13 39 40 41 42 43 F. Anticipated direct labor requirements to produce each helmet: Molding Department Assembly Department 44 Finishing Department 45 46 47 48 49 50 Packing Department G. Estimated factory overhead costs for April: Indirect factory wages Depreciation of plant and equipment Hours Hourly cost 2.0 $32 0.5 22 0.25 16 0.25 12 Amount $129,600 51 Uslites 52 Insurance 53 Property tax 22,600 14,600 7,400 5,600 54 55