Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i. Estimated other income and expense for May: Interest revenue $14,500 Interest expens $3,000 INSTRUCTIONS 1. Prepare a sales budget for May 2. Prepare a

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
i. Estimated other income and expense for May: Interest revenue $14,500 Interest expens $3,000 INSTRUCTIONS 1. Prepare a sales budget for May 2. Prepare a production budget for May 3. Prepare a direct materials budget for May 4. Prepare a direct labor cost budget for May 5. Prepare a factory overhead cost budget for May 6. Prepare a cost of goods sold budget for May. Work in process at the beginning of May is estimated to be $4,200, and work in process at the end of May is desired to be $3,800 7. Prepare a selling and administrative budget for May 8. Prepare a budgeted income statement for MayInstructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear immediately to the right of an incorrect answer. 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 2. JUPITER HELMETS INC. Production Budget For the Month Ending May 31 Units Bicycle Motorcycle Helmet Helmet Expected units to be sold Plus desired inventory, May 31 Total Less estimated inventory, May 1 Total units to be produced 3. JUPITER HELMETS INC. Direct Materials Purchases Budget For the Month Ending May 31 Plastic Foam Lining Total Required units for production: Bicycle helmet Motorcycle helmet Plus desired inventory, May 31 Total Less estimated inventory, May 1 Total units to be purchased Multiply by unit price Total direct materialsJUPITER HELMETS INC. Direct Labor Cost Budget For the Month Ending May 31 Molding Assembly Department Department Total Hours required for production: Bicycle helmet Motorcycle helmet Total Multiply by hourly rate Toral direct labor cost 5. JUPITER HELMETS 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 6 JUPITER HELMETS INC. Cost of Goods Sold Budget For the Month Ending May 31 Finished goods inventory, May 1 Work in process inventory, May 1 Direct materials: Direct materials inventory, May 1 Direct materials purchases Cost of direct materials available for use Less: direct materials inventory, May 31 Cost of direct materials 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 sold7. JUPITER HELMETS INC. Selling and Administrative Expenses Budget For the Month Ending May 31 Selling expenses: Sales salaries expense Advertising expense Travel expense - selling Miscellaneous expense - selling Total selling expenses Administrative expenses: Office salaries expense Depreciation expense - office equipment Utilities expense - administrative Office supplies expense Miscellaneous 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 Net income

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Computer Accounting

Authors: Donna Kay

15th Edition

0077826841, 9780077826840

More Books

Students also viewed these Accounting questions

Question

=+What are the states of nature?

Answered: 1 week ago

Question

Describe the factors influencing of performance appraisal.

Answered: 1 week ago

Question

What is quality of work life ?

Answered: 1 week ago

Question

1. To understand how to set goals in a communication process

Answered: 1 week ago