Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sales Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Expected sales (units) 7,600 8,200 8,600 8,900
Sales Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Expected sales (units) 7,600 8,200 8,600 8,900 $44 $51 $51 Sales price per unit Total sales revenue $334,400 $418,200 $438,600 $ Production Budget For the Year Ending Dec. 31, 2018 $56 | Quarter 1 Quarter 2 Quarter 3 Quarter 4 Q1, Year 2 Expected sales 7,600 8,200 8,600 8,900 8,000 Desired ending inventory 1,640 1,720 1,780 900 Total required units 9,240 9,920 10,380 10,500 8,900 Less: Beginning inventory 1,520 1,640 1,720 1,780 1,600 Required production 7,720 8,280 8,660 7,300 Total Direct Materials Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced Direct material per unit 7,720 8,280 8,660 8,720 33,380 2 2 2 2 2 Total pounds needed for production 15,440 16,560 17,320 17,440 66,760 Add: Desired ending inventory 4,140 4,330 4,360 3,650 3,650 Total material required 19,580 20,890 21,680 21,090 70,410 Less: Beginning inventory 0 4,140 4,330 4,360 Pounds of direct material purchase requirements 19,580 16,750 17,350 16,730 70,410 Cost per pound $1.50 $1.50 Total cost of direct material purchase $29,370 $25,125 $1.50 $26,025 $1.50 $1.50 $25,095 $105,615 Total $105,615 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,720 8,280 8,660 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,790 6,210 6,495 6,540 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $144,750 $155,250 $162,375 $ $625,875
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