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
Get step-by-step solutions from verified subject matter experts
