Material Cost Questions
Material Cost Questions
Material Cost Questions
Weekly production varies from 225 to 325 units, averaging 250 units of the said product. What would be
the following quantities:
(i) Minimum Stock of A? (ii) Maximum Stock of B?
(iii) Re-order level of C (iv) Average Stock level of A? {10}
Q.2 RST Limited has received an offer of quantity discount on its order of materials as under:
Price per tone Tonnes number
Rs. 9,600 Less than 50
Rs. 9,360 50 and less than 100
Rs. 9,120 100 and less than 200
Rs. 8,880 200 and less than 300
Rs. 8,640 300 and above
The annual requirement for the material is 600 tonnes. The ordering cost per order is Rs.12,500 and the
stock holding cost is estimated at 25% of the material cost per annum. Required:
(i) Compute the most economical purchase level.
(ii) Compute EOQ if there are no quantity discounts and the price per tonne is Rs. 10,500. {6+2}
Q.3 G Ltd. produces a product which has a monthly demand of 4,000 units. The product requires a component
X which is purchased at Rs.40. For every finished product, two units of component X is required. The
ordering cost is Rs. 120 per order and the holding cost is 20% p.a. You are required to calculate:
Economic order quantity. {3+3}
If the minimum lot size to be supplied is 20,000 units, what is the extra cost the company has to incur?
Q.4 P Limited, manufacturer of a special product, follows the policy of EOQ (Economics Order Quantity) for
one of its components. The components details are as follows:
Purchase Price Per Component Rs. 200
Cost of an order 100
Annual Cost of Carrying one Unit in Inventory 10% of Purchase Price
Total Cost of Inventory and Ordering Per Annum Rs.4,000
The company has been offered a discount of 5% on the price of the component provided the lot size is 2,000
components at a time. You are required to:
Compute the EOQ.
Advise whether the quantity discount offer can be accepted.
(Assume that the inventory carrying cost does not vary according to the discount policy)
Would your advice differ if the company is offered 10% discount on a single order? {3+2+2}
Q.5 A manufacturer of Surat purchased three Chemicals A, B and C from Bombay. The invoice gave the
following information:
Chemical A 3,000 kg. @ Rs.4.20 per kg. Rs.12,600
Chemical B 5,000 kg. @ Rs. 3.80 per kg. 19,000
Chemical C 2,000 kg. @ Rs. 4.75 per kg. 9,500
Sales Tax 2,466
Railway Freight 2,000
Total Cost 45,566
A shortage of 200 kg. in Chemical A, of 180 kg. in Chemical B and of 150 kg. in Chemical C was noticed due to
breakages. At Surat, the manufacturer paid Octroi Duty @ Re.1.50 per kg. He also paid cartage Rs.252 for
Chemical A, Rs. 635 for Chemical B and Rs 352 for Chemical C. Calculate the stock rate that you would suggest
for pricing issue of chemicals assuming a provision of 8% towards further deterioration. {6}
Q.6 The annual demand for a product is Rs.38,400 and inventory carrying cost per unit per annum is 25% of
the average inventory cost. If the cost of procurement is Rs. 75, the unit cost is Rs. 6. Determine-
(i) Economic order quantity (EOQ);
(ii) Number of orders per annum; and
(iii) Time between two consecutive orders. {3+1+1}
Q.7 Oil India is a bulk distributor of high octane petrol. A periodic inventory of petrol on hand is
taken when books are closed at the end of each month. The following summary of
information is available for the month.
SSP CA. Gautam Sethi CA. IPCC
Systematic Studies for Professionals
(Where your quest for quality education ends)
Sales `60,45,000
General administration cost `275,000
Opening stock: 1,00,000 litres @ `35 per litre `35,00,000
Purchases (including freight inward)
June 1 2,00,000 litres @ `28.85 per litre
June 25 1,00,000 litres @ `34.03 per litre
June 30 Closing stock 1,40,000 litres.
Compute the following data by the FIFO, Weighted Average Method and LIFO method
of inventory costing:
(a) Value of inventory on June 30.
(b) Amount of cost of goods sold for June.
(c) Profit or loss for June. {3+2+2}
Q.8 IPL Limited uses a small casting in one of the finished products. The castings are purchased
from a foundry. JPL Limited purchases 43,200 castings per year at a cost of `900 per casting.
The castings are used evenly throughout the year in the production process on a 360 – day –
per – year basis. The company estimates that it costs `8,000 to place a single purchase
order and about `350 to carry one casting in inventory for a year. The high carrying costs
result from the need to keep the castings in carefully controlled temperature and humidity
conditions, and from the high cost of insurance.
Delivery from the foundry generally takes 5 days, but it can take as much as 10 days.
The days of delivery time and percentage of their occurrence are shown in the following
tabulation:
Delivery time (days) 5 6 7 8 9 10
Percentage of occurrence 65 10 8 7 5 5
Required:
(i) Compute the economic order quantity (EOQ).
(ii) Assuming the company is willing to assume a 25% risk of being out of stock. What
would be the safety stock? The re-order point?
(iii) Assume the company is willing to assume a 10% risk of being out of stock. What would
be the safety stock: The re- order point?
(iv) Assume 10% stock–out risk. What would be the total cost of ordering and carrying
inventory for one year? {8}
Q.9 The Stock Control Policy of a company is that, each stock is ordered twice a year. The quantum of each
order being one-half of the year’s forecast demand.
The materials manager, however, wishes to introduce a policy in which for each item of stock, reorder
levels and EOQ is calculated.
For one of the items X, the following information is available:
Forecast annual demand 3,600 units
Cost /unit ` 100
Cost of placing an order ` 40
Stock holding cost 20% of average stock value
Lead time 1 month
It is estimated by the materials manager that for item X, a buffer stock of additional 100 units should be
provided to cover fluctuations in demand.
If the new policy is adopted, calculate for stock item X.
1) The reorder level & EOQ that should be set by the material manager:
2) The anticipated reduction in the value of the average stock investment.
3) The anticipated reduction in total inventory costs in the first and subsequent years. {9}
Q.10 The annual demand for an item of raw material is 4,000 units and the purchase price is expected to be
` 90 per unit. The incremental cost of processing an order is ` 135 and the cost of storage is estimated
to be ` 12 per unit. What is the optimal order quantity and total relevant cost of this order quantity?
Suppose that `135 as estimated to be the incremental cost of processing an order is incorrect and
should have been ` 80. All other estimates are correct. What is the difference in cost on account of this
error ?
Assume at the commencement of the period that a supplier offers 4,000 units at a price of `86. The
materials will be delivered immediately and placed in the stores. Assume that the incremental cost of
placing the order is zero and original estimated of `135 placing an order for the economic batch is
correct. Should the order be accepted? {9}