Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need assistance with the remaining portion. Thank You!! The budget director of Jupiter Ilelmets Inc. with the assistance of the controller, treasurer, production manager,

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

I need assistance with the remaining portion. Thank You!!

The budget director of Jupiter Ilelmets Inc. with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in devel- oping the budgeted inome statement for May: a. Estimated sales for May Bicycle helmet Motorcycle helmet 7 500 units at 524 per unit 5.000 units at $175 per unit 1. Estimated inventories at May 1: Direct materials: Plastic Foam lining 1480 lbs. 520 lbs. Finished products Bicycle helmet Motorcycle helmet 200 units at $15 per unit 100 units at $90 per unit C Desired inventories at May 31: 400 units at $15 per unit 300 units at $100 per unit Direct materials: Finished products Plastic 2.000 lbs Bicycle helmet Foam lining 800 lbs. Motorcycle helmet d. Direct materials used in production: In manufacture of bicycle helmet: Plastic 0.90 lb, per unit of product Foam lining 0.20 ib. per unit of product In manufacture of motorcycle helmet Plastic 3.50 lbs. per unit of product Foam lining 140 lbs. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic $440 perib Foam lining $0.90 per lib. f Direct labor requirements: Bicycle helmet Molding Department Assembly Department Motorcycle helmet Molding Department Assembly Department 0:30 hr. at $15 per hr. 0.10 hr. at $14 per hr. 0.50 hr. at $15 per hr 0.40 hr at $14 per hr 8. Estimated factory owerhead costs for May Indirect factory wages Depreciation of plant and equipment $125,000 45,000 Power and light Insurance and property tax roperty w $28.00 11,000 h. Estimated operating expenses for May $175.000 120 000 92.000 Sales salaries expense Advertising experie Office salaries expense Depreciation expense-office equipment Miscellaneous expense selling Utilities experie administrative Travel expense-selling Ohce supplies expense Miscellaneous administrative expense 3.000 50 000 2.500 1,500 Estimated other income and expense for May Interest revenue Interest expense $14,560 3,000 Estimated tax rate: 25% Instructions JUPITER HELMETS INC. Sales Budget For the Month Ending May 31 Unit Sales Unit Selling Volume Price Total Sales Bicycle helmet Motorcycle helmet Total revenue from sales 7,500 5,000 $24.00 $175.00 $ 180,000 875,000 $ 1,055,000 JUPITER HELMETS INC. Production Budget For the Month Ending May 31 Bicycle Helmet Units Motorcycle Helmet Expected units to be sold Plus desired inventory, May 31 Total Less estimated inventory, May 1 Total units to be produced 7,500 400 7,900 5,000 300 5,300 (100) 5,200 12001 7,700 Total JUPITER HELMETS INC. Direct Materials Purchases Budget For the Month Ending May 31 Plastic Foam Lining Required units for production: Bicycle helmet 6,930 1,540 Motorcycle helmet 18,200 7,280 Plus desired inventory, May 31 2,000 800 Total 27.130 9,620 Less estimated inventory, May 1 (1,480) (520) Total units to be purchased 25,650 9,100 Multiply by unit price $4.40 $0.90 Total direct materials to be purchased $112,860 $8,190 $121,050 JUPITER HELMETS INC. Direct Labor Cost Budget For the Month Ending May 31 Molding Department Assembly Department Total Hours required for production: Bicycle helmet Motorcycle helmet Total Multiply by hourly rate Toral direct labor cost 2,310 2,600 4,910 $15.00 $73,650 770 2,080 2,850 $14.00 $39,900 $113,550 JUPITER HELHETS INC. Factory Overhead Cost Budget For the Month Ending May 31 Indirect factory wages Depreciation of plant and equipment Power and light Insurance and property tax Total $125,000 45,000 23,000 11,000 $204,000 JUPITER HELMETS INC Cost of Goods Sold Budget For the Month Ending May 31 $ 6980 121050 19520 Finished goods inventory, May 1 Work in process inventory May 1 Direct materials Direct materials inventory, May 1 Direct materiais purchases Cost of direct materials available for use Less direct materials inventory, May 31 Cost of direct materiais placed in production Direct labor Factory overhead Total manufacturing costs Total work in process during the period Less work in process inventory, May 31 Cost of goods manufactured Cost of finished goods available for sale Less finished goods inventory, May 31 Cost of goods sold 113.550 204 000 JUPITER HELMETS INC. Selling and Administrative Expenses Budget For the Month Ending May 31 Seling expenses Sales salaries expense Advertising expense Travel expense - seling Miscelaneous expense - selling Total selling expenses Administrative expenses Omce salaries expense Depreciation expense - office equipment Utilities expense - administrative Omce supplies expense Miscelaneous administrative expense Total administrative expenses Total operating expenses JUPITER HELMETS INC Budgeted Income Statement For the Month Ending May 31 Revenue from sales Cost of goods sold Gross profit Operating expenses Selling expenses Administrative expenses Total operating expenses income from operations Other income Interest revenue Other expenses Interest expense Income before income tax Income tax expense Met income

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions