Following information is available from the purchase books of a company: Cost of placing a purchase order - 10,000Number of units to be purchased…

CA Intermediate · Cost and Management Accounting · MTP · January 2025
Following information is available from the purchase books of a company: Cost of placing a purchase order - 10,000Number of units to be purchased during the year 12,50,000Purchase price per unit - 125Annual cost of storage per unit - 62.50 Details of lead time: Maximum 20 days Minimum 10 days Rate of consumption: Average 1,500 units per day Maximum 2,000 units per day From the details given above, you are required to CALCULATE: (i) Re-ordering level (ii) Maximum level (iii) Minimum level (iv) Danger level

Suggested Answer and Working Notes:

(i) Re-ordering level = Maximum usage per period × Maximum lead time (ROL) = 2,000 units per day × 20 days = 40,000 units (ii) Maximum level= ROL+ROQ–[Min. rate of consumption× Min. lead time] (Refer to working notes 1 and 2) = 40,000 units + 20,000 units – [1,000 units per day x 10 days] = 50,000 units (iii) Minimum level = ROL – Average rate of consumption × Average re-order-period = 40,000 units – (1,500 units per day × 15 days) = 17,500 units (iv) Danger level = Average consumption × Lead time for emergency purchases = 1,500 units per day × 3 days = 4,500 units Working Notes: 1. Minimum rate of consumption per day Average rate of consumption = (Minimum rate of consumption + Maximum rate of consumption) / 2 1,500 units per day = (X units per day + 2,000 units per day) / 2 Or, X = 1,000 units per day 2. Re-order Quantity (ROQ) = √(2 x 12,50,000 units x 10,000) / 62.50 = 20,000 units

Topics: Material Cost

Open in Interactive Practice Hub · Full Practice Hub · Chapter Weightage · More in this subject

Related Questions in this Topic