MODULE 3 MATERIAL
MODULE 3 MATERIAL
MODULE 3 MATERIAL
(iv) Maximum level: This is the level above which stocks should not normally be allowed
to rise. The maximum level may, however, be exceeded in certain cases. E.g. when
unusually favourable purchasing conditions arise. Maximum level is calculated by the
following formula:
Maximum Level = Re-order level (ROL) + Reorder quantity (ROQ) –
{Min. Consumption x Min. Reorder period}
The idea of setting maximum stock level is to ensure that capital is not unnecessarily
blocked in stores and also to avoid loss due to obsolescence and deterioration.
(v) Minimum level: It is that level below which stock should not normally be allowed to
fall. This is essentially a safety stock and is not normally touched.
Minimum level = Re-order level – {Normal consumption x normal re-order period}
Note: Normal consumption means Average consumption.
Average consumption = (Maximum consumption + Minimum consumption) ÷ 2
3) Economic order quantity (EOQ):
Example for understanding Economic order quantity
Annual Consumption = 2,400 units. Ordering Cost per order = Rs. 10.
Holding Cost = Re. 0.30 per unit
(A) (B) (C) (D) (E) (F)
Number of units per Average
Ordering Holding Cost Total
No. of order Inventory
cost = (C) x Re. Cost
Orders (Annual consumption ÷ (In units)
= (A) x Rs. 10 0.30 (D) + ( E)
No. of orders) = (B) ÷ 2
1 2,400 1,200 10 360 370
2 1,200 600 20 180 200
3 800 400 30 120 150
4 600 300 40 90 130
5 480 240 50 72 122
6 400 200 60* 60* 120
7 343 172 70 52 122
8 300 150 80 45 125
* Generally, at EOQ level ordering cost and storage will be equal.
✓ Re-order quantity is the quantity for which order is placed when stock reaches re-order
level. By fixing this quantity the purchaser doesn’t have to recalculate the quantity to
be purchased each time when he places order for materials.
✓ Ordering cost is the cost incurred for placing one order.
✓ Carrying costs are the cost for holding / carrying of inventories in the store such as the
cost of fund invested in inventories, cost of storage, insurance cost, obsolescence etc.
✓ Economic Order Quantity is also known as Re-order quantity because it is the quantity
which is most economical to order. In other words, EOQ is the level at which the total
cost (ordering cost + carrying cost) is minimum.
NMIMS (Deemed to be University) 3|Page
F.Y.Bcom (Hons) – Semester I – Cost Accounting [Academic Year 2024-25]
PRACTICAL QUESTIONS
Example 1: (Stock levels)
Two materials A and B are used as follows:
Minimum usage 5,000 units per week each
Maximum usage 15,000 units per week each
Normal usage 10,000 units per week each
Re-order quantity A – 60,000 units; B – 100,000 units
Delivery period A – 4 to 6 weeks; B – 2-4 weeks
Calculate the various stock levels.
“You need to battle with fear of failure to achieve your goals in life.”
Example 19:
The following were the receipts and issues of material ZED during March 2005.
March Particulars
1 Opening balance – 1100 units Rs. 60 per unit
3 Issue – 140 units
4 Issue – 250 units
8 Issue – 210 units
13 Received from vendor 400 units at Rs. 59 per unit
14 Refund of surplus from a work order 30 units at Rs. 58 p.u.
16 Issue 350 units
20 Received from vendor 480 units at Rs. 62 per unit
24 Issue 608 units
25 Received from vendor 640 units at Rs. 60 per unit
26 Issue 524 units
28 Refund of surplus from a work order 24 units (issued on March 3)
31 Received from vendor 150 units at Rs. 64 per unit
From the above, write the Stores Ledger Account on FIFO and weighted Average Basis.
“Just when the caterpillar thought the world was ending, he turned into a butterfly.”