Problem:
A single product company estimated its sales for the next quarter as follows:
|
Quarter
|
Sales Units
|
|
I
|
30,000
|
|
II
|
37,500
|
|
III
|
41,250
|
|
IV
|
45,000
|
The opening stock of finished goods is 10,000 units and the company expects to maintain the closing stock of finished goods at 16,250 units at the end of the year. The production pattern in each quarter is based on 80% of the sales of the current quarter and 20% of the sales of the next quarter.
The opening stock of raw materials in the beginning of the year is 10,000 kg and the closing stock at the end of the year is required to be maintained at 5,000 kg. Each unit of the finished output requires 2 kg of raw materials.
The company proposes to purchase the entire annual requirements of raw materials in the first three quarters in the proportion and at the prices given as follows:
|
Quarter
|
Purchase of raw materials in % to total annual requirement in quantity
|
Price per kg Rs.
|
|
I
|
30%
|
2
|
|
II
|
50%
|
3
|
|
III
|
20%
|
4
|
The value of the opening stock of raw materials in the beginning of the year is Rs. 20,000.
You are required to present the following for the next year, quarter-wise:
1. Production budget in units.
2. Raw-material-consumption budget.
3. Raw-material-purchase budget in quantity and value.
4. Priced-stores ledger card of the raw material using FIFO method.