Question
Brothers Ltd has budgeted the following unit sales: 2018 2019 Quarter Units Quarter Units 1 60,000 1 40000 2 20,000 3 70,000 4 80,000 The
Brothers Ltd has budgeted the following unit sales:
|
|
|
|
|
2018 |
|
| 2019 |
|
Quarter | Units |
| Quarter | Units |
1 | 60,000 |
| 1 | 40000 |
2 | 20,000 |
|
|
|
3 | 70,000 |
|
|
|
4 | 80,000 |
|
|
|
The finished goods inventory on hand on 31 December 2017 was 5,000 units. It is the company's policy to maintain a finished goods inventory at the end of each quarter equal to 15% of the next quarter's anticipated sales.
Required:
Prepare a production budget for 2018. Please type your answers in the table/template below. Marks will be deducted if no workings are shown.
[Answer here]
Brothers LTD |
|
|
|
|
| ||||
Production Budget |
|
|
|
|
| ||||
for the year ended 31 December 2018 |
|
|
|
|
| ||||
|
|
|
|
|
| ||||
|
|
| Quarter |
| |||||
| 1 | 2 | 3 | 4 | |||||
Expected unit sales |
|
|
|
| |||||
Desired ending finished goods units |
|
|
|
| |||||
Total required units |
|
|
|
| |||||
Less: Beginning finished goods units |
|
|
|
| |||||
Required production units |
|
|
|
|
[Show workings here]
|
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