Question
Fill in the missing information from the following schedules: Solution Sales Budget For the Year Ended Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3
-
Fill in the missing information from the following schedules:
Solution
Sales Budget | |||||
For the Year Ended Dec. 31, 2018 | |||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total |
Expected Sales (units) | 7,500 | 8,250 | 8,750 | 9,000 | ????? |
Sales Price per Unit | $45 | $50 | $50 | $55 |
|
Total Sales Revenue | $337,500 | $412,500 | $437,500 | ????? | $??????? |
Production Budget | |||||
For the Year Ended Dec. 31, 2018 | |||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Q1, Year 2 |
Expected Sales | 7,500 | 8,250 | 8,750 | 9,000 | 8,000 |
Desired Ending Inventory | 1,650 | 1,750 | 1,800 | ????? | 900 |
Total Required Units | 9,150 | 10,000 | 10,550 | 10,600 | 8,900 |
Beginning Inventory | (1,500) | (1,650) | (1,750) | (1,800) | (1,600) |
Required Production | 7,650 | 8,350 | 8,800 | ????? | 7,300 |
Total |
|
|
| ????? |
|
Direct Materials Budget For the Year Ended Dec. 31, 2018 | |||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total |
Units to Be Produced | ????? | ????? | ???? | ???? | ???? |
Direct Material per Unit | 2 | 2 | 2 | 2 | 2 |
Total Pounds Needed for Production | 15,300 | 16,700 | 17,600 | 17,600 | 67,200 |
Desired Ending Inventory | 4,175 | 4,400 | 4,400 | 3,650 | 3,650 |
Total Material Required | 19,475 | 21,100 | 22,000 | 21,250 | 70,850 |
Beginning Inventory | 0 | (?????) | (?????) | (?????) |
|
Pounds of Direct Material Purchase Requirements | 19,475 | 16,925 | 17,600 | 16,850 | 70,850 |
Cost per Pound | $1.5 | $1.5 | $1.5 | $1.5 | $1.5 |
Total Cost of Direct Material Purchase | ????? | ????? | ????? | ????? | $106,275 |
|
|
|
|
Direct Labor Budget | |||||
For the Year Ended Dec. 31, 2018 | |||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total |
Units to Be Produced | ????? | ????? | ????? | ????? | ????? |
Direct Labor Hours per Unit | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 |
Total Required Direct Labor Hours | ????? | ????? | ????? | ????? | ????? |
Labor Cost per Hour | $25 | $25 | $25 | $25 | $25 |
Total Direct Labor Cost | ????? | ????? | ????? | ????? | ????? |
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