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