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,400 | 8,800 | 9,100 | fill in the blank 1 |
Sales price per unit | $44 | $50 | $50 | $54 | |
Total sales revenue | $330,000 | $420,000 | $440,000 | $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,400 | 8,800 | 9,100 | 7,900 |
Desired ending inventory | 1,680 | 1,760 | 1,820 | fill in the blank 4 | 880 |
Total required units | 9,180 | 10,160 | 10,620 | 10,680 | 8,780 |
Less: Beginning inventory | 1,500 | 1,680 | 1,760 | 1,820 | 1,580 |
Required production | 7,680 | 8,480 | 8,860 | fill in the blank 5 | 7,200 |
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,680 | 8,480 | 8,860 | 8,860 | 33,880 |
Direct material per unit | 2 | 2 | 2 | 2 | 2 |
Total pounds needed for production | 15,360 | 16,960 | 17,720 | 17,720 | 67,760 |
Add: Desired ending inventory | 4,240 | 4,430 | 4,430 | 3,600 | 3,600 |
Total material required | 19,600 | 21,390 | 22,150 | 21,320 | 71,360 |
Less: Beginning inventory | 0 | 4,240 | 4,430 | 4,430 | - |
Pounds of direct material purchase requirements | 19,600 | 17,150 | 17,720 | 16,890 | 71,360 |
Cost per pound | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 |
Total cost of direct material purchase | $29,400 | $25,725 | $26,580 | $25,335 | $107,040 |
Total | $fill in the blank 7 | $107,040 |
Direct Labor Budget | |||||
For the Year Ending Dec. 31, 2018 | |||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |
Units to be produced | 7,680 | 8,480 | 8,860 | 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,760 | 6,360 | 6,645 | 6,645 | fill in the blank 10 |
Labor cost per hour | $25 | $25 | $25 | $25 | $25 |
Total direct labor cost | $144,000 | $159,000 | $166,125 | $fill in the blank 11 | $635,250 |
Feedback Area
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