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 Total Expected sales (units) 7,600 8,400 8,600 8,900 Sales price per unit $46 $51 $51 $56 Total sales revenue $349,600 $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,600 8,400 8,600 8,900 7,900 Desired ending inventory 1,680 1,720 1,780 880 Total required units 9,280 10,120 10,380 10,480 8,780 Less: Beginning inventory 1,520 1,680 1,720 1,780 1,580 Required production 7,760 8,440 8,660 7,200 Accounting numeric field 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,760 8,440 8,660 8,700 33,560 Direct material per unit 2 2 2 2 2 Total pounds needed for production 15,520 16,880 17,320 17,400 67,120 Add: Desired ending inventory 4,220 4,330 4,350 3,600 3,600 Total material required 19,740 21,210 21,670 21,000 70,720 Less: Beginning inventory 0 4,220 4,330 4,350 Pounds of direct material purchase requirements 19,740 16,990 17,340 16,650 70,720 Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50 Total cost of direct material purchase $29,610 $25,485 $26,010 $24,975 $ 106,080 Total $106,080 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,760 8,440 8,660 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,820 6,330 6,495 6,525 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $145,500 $ 158,250 $162,375 $ $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