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,200 | 8,800 | 9,100 | ___ |
Sales price per unit | $45 | $49 | $49 | $55 | |
Total sales revenue | $342,000 | $401,800 | $431,200 | $___ | $___ |
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,200 | 8,800 | 9,100 | 8,100 |
Desired ending inventory | 1,640 | 1,760 | 1,820 | ___ | 880 |
Total required units | 9,240 | 9,960 | 10,620 | 10,720 | 8,980 |
Less: Beginning inventory | 1,520 | 1,640 | 1,760 | 1,820 | 1,620 |
Required production | 7,720 | 8,320 | 8,860 | ___ | 7,360 |
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,720 | 8,320 | 8,860 | 8,900 | 33,800 |
Direct material per unit | 2 | 2 | 2 | 2 | 2 |
Total pounds needed for production | 15,440 | 16,640 | 17,720 | 17,800 | 67,600 |
Add: Desired ending inventory | 4,160 | 4,430 | 4,450 | 3,680 | 3,680 |
Total material required | 19,600 | 21,070 | 22,170 | 21,480 | 71,280 |
Less: Beginning inventory | 0 | 4,160 | 4,430 | 4,450 | - |
Pounds of direct material purchase requirements | 19,600 | 16,910 | 17,740 | 17,030 | 71,280 |
Cost per pound | $1.50 | $1.50 | $1.50 | $1.50 | $1.50 |
Total cost of direct material purchase | $29,400 | $25,365 | $26,610 | $25,545 | $106,920 |
Total | $___ | $106,920 |
Direct Labor Budget | |||||
For the Year Ending Dec. 31, 2018 | |||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |
Units to be produced | 7,720 | 8,320 | 8,860 | ___ | ___ |
Direct labor hours per unit | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 |
Total required direct labor hours | 5,790 | 6,240 | 6,645 | 6,675 | ___ |
Labor cost per hour | $25 | $25 | $25 | $25 | $25 |
Total direct labor cost | $144,750 | $156,000 | $166,125 | $___ | $633,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