Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started