Question
The following are given the schedule of budget for a company: Sales Budget For the Year Ended December 31, 2018 Quarter 1 Quarter 2 Quarter
The following are given the schedule of budget for a company:
Sales Budget
For the Year Ended December 31, 2018
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |
Expected sales (unis) | 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 December 31, 2018
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Q1 Year 2 | |
Expected sales (unis) | 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 |
Less: beginning inventory | 1,500 | 1,650 | 1,750 | 1,800 | 1,600 |
Required production | 7,650 | 8,350 | 8,800 | ? | 7,300 |
Direct Material Budget
For the Year Ended December 31, 2018
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |
Unites to be produced | 7,650 | 8,350 | 8,800 | 8,800 | 33,600 |
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 | 4,175 | 4,400 | 4,400 | 0 |
Pounds of D. material purchase requirement | 19,475 | 16,925 | 17,600 | 16,850 | 70,850 |
Cost per pound | $1.59 | $1.59 | $1.59 | $1.59 | $1.59 |
Total cost of direct material purchase | $29,213 | $25,388 | $26,400 | $25,275 | $106,275 |
Total | ? | $106,275 |
Direct Labor Budget
For the Year Ended December 31, 2018
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |
Unites to be produced | 7,650 | 8,350 | 8,800 | ? | ? |
Direct labor cost per unit | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 |
Total required direct labor hours | 5,738 | 6,263 | 6,600 | 6,600 | ? |
Labor cost per hour | $25 | $25 | $25 | $25 | $25 |
Total direct labor cost | $143,438 | $156,563 | $165,000 | ? | $630,000 |
Required
Fill in the missing information (marked with a "?" sign) from the above schedules
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