Question
A single product company estimated its sales for the next year quarter wise as under: Quarter Sales units 1 30000 2 37500 3 41250 4
A single product company estimated its sales for the next year quarter wise as under:
Quarter Sales units
1 30000
2 37500
3 41250
4 45000
The opening stock of finished goods is 10000 units and the company expects to maintain the closing stock of finished goods at 16250 units at the end of the year. The production pattern in each quarter is based on 80% sales of the current quarter and 20% of the sales of the next quarter.
The opening stock of raw material in the beginning of the year is 10000 kg and the closing stock of the raw material is required to be maintained at 5000 kg. Each units of finished output requires 2 kg of raw material.
The company proposes to purchase the entire annual requirement of raw material in the first three quarters in the proportion and the prices given below:
Quarter | Purchase of raw material % to total annual requirement in quantity | Price per kg in Rs. |
1 | 30% | 2 |
2 | 50% | 3 |
3 | 20% | 4 |
The value of the opening stock of raw material in the beginning of the year is Rs.20000.
Required: Present the following for the next year, quarter wise:
Production budget in units
Raw material usage budget in quantity
Raw material purchase budget in quantity and value
Step by Step Solution
There are 3 Steps involved in it
Step: 1
1 Production Budget in Units We are given the sales estimates for each quarter and ...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