Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fill in the missing information from the following schedules: Sales Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter

Fill in the missing information from the following schedules: Sales Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Expected sales (units) 7,400 8,300 8,800 8,900 Sales price per unit $45 $50 $50 $55 Total sales revenue $333,000 $415,000 $440,000 Production Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 < Expected sales 7,400 8,300 8,800 8,900 Q1, Year 2 8,000 Desired ending inventory 1,660 1,760 1,780 920 Total required units 9,060 10,060 10,580 10,500 8,920 Less: Beginning inventory 1,480 1,660 1,760 1,780 1,600 Required production 7,580 8,400 8,820 7,320 Total Units to be produced. Direct material per unit Direct Materials Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 7,580 8,400 8,820 8,720 33,520 2 2 2 2 2 Direct Materials Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,580 8,400 8,820 8,720 33,520 Direct material per unit 2 2 2 2 2 Total pounds needed for production 15,160 16,800 17,640 17,440 67,040 Add: Desired ending inventory 4,200 4,410 4,360 3,660 3,660 Total material required 19,360 21,210 22,000 21,100 70,700 Less: Beginning inventory 0 4,200 4,410 4,360 Pounds of direct material purchase requirements 19,360 17,010 17,590 16,740 70,700 Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50 Total cost of direct material purchase $29,040 $25,515 $26,385 $25,110 $106,050 Total $106,050 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,580 8,400 8,820 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,685 6,300 6,615 6,540 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $142,125 $157,500 $165,375 $ $628,500 Units to be produced 7,580 8,400 8,820 8,720 33,520 Direct material per unit 2 2 2 2 Total pounds needed for production 15,160 16,800 17,640 17,440 67,040 Add: Desired ending inventory 4,200 4,410 4,360 3,660 3,660 Total material required 19,360 21,210 22,000 21,100 70,700 Less: Beginning inventory 0 4,200 4,410 4,360 Pounds of direct material purchase requirements 19,360 17,010 17,590 16,740 70,700 Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50 Total cost of direct material purchase $29,040 $25,515 $26,385 $25,110 $106,050 Total $106,050 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,580 8,400 8,820 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,685 6,300 6,615 6,540 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $142,125 $157,500 $165,375 $ $628,500

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

Design And Maintenance Of Accounting Manuals

Authors: Harry L. Brown

3rd Edition

0471253685, 978-0471253686

More Books

Students also viewed these Accounting questions