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,500 | 8,200 | 8,700 | 9,000 | fill in the blank 1 |
Sales price per unit | $46 | $51 | $51 | $56 | |
Total sales revenue | $345,000 | $418,200 | $443,700 | $fill in the blank 2 | $fill in the blank 3 |
Production Budget | |||||
For the Year Ending Dec. 31, 2018 | |||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Q1, Year 2 | |
Expected sales | 7,500 | 8,200 | 8,700 | 9,000 | 7,900 |
Desired ending inventory | 1,640 | 1,740 | 1,800 | fill in the blank 4 | 920 |
Total required units | 9,140 | 9,940 | 10,500 | 10,580 | 8,820 |
Less: Beginning inventory | 1,500 | 1,640 | 1,740 | 1,800 | 1,580 |
Required production | 7,640 | 8,300 | 8,760 | fill in the blank 5 | 7,240 |
Total | fill in the blank 6 |
Direct Materials Budget | |||||
For the Year Ending Dec. 31, 2018 | |||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |
Units to be produced | 7,640 | 8,300 | 8,760 | 8,780 | 33,480 |
Direct material per unit | 2 | 2 | 2 | 2 | 2 |
Total pounds needed for production | 15,280 | 16,600 | 17,520 | 17,560 | 66,960 |
Add: Desired ending inventory | 4,150 | 4,380 | 4,390 | 3,620 | 3,620 |
Total material required | 19,430 | 20,980 | 21,910 | 21,180 | 70,580 |
Less: Beginning inventory | 0 | 4,150 | 4,380 | 4,390 | - |
Pounds of direct material purchase requirements | 19,430 | 16,830 | 17,530 | 16,790 | 70,580 |
Cost per pound | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 |
Total cost of direct material purchase | $29,145 | $25,245 | $26,295 | $25,185 | $105,870 |
Total | $fill in the blank 7 | $105,870 |
Direct Labor Budget | |||||
For the Year Ending Dec. 31, 2018 | |||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |
Units to be produced | 7,640 | 8,300 | 8,760 | fill in the blank 8 | fill in the blank 9 |
Direct labor hours per unit | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 |
Total required direct labor hours | 5,730 | 6,225 | 6,570 | 6,585 | fill in the blank 10 |
Labor cost per hour | $25 | $25 | $25 | $25 | $25 |
Total direct labor cost | $143,250 | $155,625 | $164,250 | $fill in the blank 11 | $627,750 |
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