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,300 8,700 9,000 Total Sales price per unit $46 $49 $49 $54 Total sales revenue $349,600 $406,700 $426,300 $ Production Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 7,600 8,300 8,700 1,660 1,740 1,800 Q1, Year 2 9,000 8,000 Expected sales Desired ending inventory 900 Total required units 9,260 10,040 10,600 8,900 10,500 1,740 Less: Beginning inventory 1,520 1,660 1,800 1,600 Required production 7,740 8,380 8,760 7,300 Total Direct Materials Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 7,740 8,380 8,760 2 2 2 Quarter 4 Total Units to be produced 8,800 33,680 Direct material per unit 2 2 67,360 15,480 4,190 16,760 4,380 17,520 4,400 Total pounds needed for production Add: Desired ending inventory Total material required Less: Beginning inventory Pounds of direct material purchase requirements 17,600 3,650 21,250 3,650 19,670 21,920 71,010 21,140 4,190 0 4,380 4,400 19,670 16,950 17,540 16,850 71,010 Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50 Total cost of direct material purchase $29,505 $25,425 $26,310 $25,275 $106,515 Total $106,515 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,740 8,380 8,760 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,805 6,285 6,570 6,600 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $145,125 $157,125 $164,250 $ $631,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