Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Expected sales (units) 7,400 8,400 8,600 9,000 Sales price
For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Expected sales (units) 7,400 8,400 8,600 9,000 Sales price per unit $45 $51 $51 $54 Total sales revenue $333,000 $428,400 $438,600 $ Production Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Q1, Year 2 Expected sales 7,400 8,400 8,600 9,000 7,900 Desired ending inventory 1,680 1,720 1,800 900 Total required units 9,080 10,120 10,400 10,580 8,800 Less: Beginning inventory 1,480 1,680 1,720 1,800 1,580 Required production 7,600 8,440 8,680 7,220 Total Direct Materials Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,600 8,440 8,680 8,780 33,500 2 2 2 2 2 15,200 16,880 17,360 17,560 67,000 Direct material per unit Total pounds needed for production Add: Desired ending inventory Total material required 4,220 4,340 4,390 3,610 3,610 19,420 21,220 21,750 21,170 70,610 0 4,220 4,340 4,390 Less: Beginning inventory Pounds of direct material purchase requirements 19,420 17,000 17,410 16,780 70,610 Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50 Total cost of direct material purchase $29,130 $25,500 $26,115 $25,170 $105,915 Total $105,915 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,600 8,440 8,680 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,700 6,330 6,510 6,585 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $142,500 $158,250 $162,750 $ $628,125
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