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 Expected sales (units) 7,600 8,200 8,800 8,900 Sales price per unit $50 $50 $54 Total sales revenue $349,600 $410,000 $440,000 Total $46 Production Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 7,600 8,200 8,800 8,900 Q1, Year 2 7,900 1,640 1,760 1,780 900 9,240 9,960 10,580 10,480 8,800 Expected sales Desired ending inventory Total required units Less: Beginning inventory Required production Total 1,520 1,640 1,760 1.780 1,580 7,720 8,320 8,820 7,220 Quarter 4 Total 8,700 33,560 2 2 17,400 67,120 Direct Materials Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Units to be produced 7,720 8,320 8,820 Direct material per unit 2 2 2 Total pounds needed for production 15,440 16,640 17,640 Add: Desired ending inventory 4,160 4,410 4,350 Total material required 19,600 21,050 21,990 Less: Beginning inventory 4,160 4,410 Pounds of direct material purchase requirements 19,600 16,890 17,580 Cost per pound $1.50 $1.50 $1.50 Total cost of direct material purchase $29,400 $25,335 $26,370 Total 3,610 3,610 21,010 70,730 0 4,350 16,660 70,730 $1.50 $1.50 $24,990 5106,095 $106,095 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 7,720 8,320 8,820 Total 0.75 0.75 0.75 0.75 0.75 Units to be produced Direct labor hours per unit Total required direct labor hours Labor cost per hour Total direct labor cost 5,790 6,240 6,615 6,525 S25 S25 $25 $25 $25 $144,750 S156,000 $165,375 S $629,250
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