Download Material Management: Reorder, Max & Min Stock Levels, Danger Stock and more Study notes Accounting in PDF only on Docsity!
LESSON# 8
CONTROL OVER MATERIAL
Control over material is essential for different reasons By and large, materials are the equivalent of cash and therefore pilfering and theft may occur quite often if effective control is not exercised.
Prevention of material from deterioration and waste is also necessary. It is also important to eliminate obsolete stocks with the consequence easing of storage space and storage costs- Moreover, control over materials is necessary to prevent extra expenditure on excessive purchase of materials and improper use of material. And above all, regular supply of materials to the production departments would help production on schedule. It will also ensure preparation of accurate statements of the value of material consumed by each department/job and final statements prepared according to their needs.
From the accounting point of view, the following are some important requirements of the effective material control;
- That no material is purchased without proper authority.
- That the quantity of material purchased is in fact received.
- That there are proper storage facilities.
- That no material is issued without proper authorization and the purpose for which the material is required is recorded.
- That the accounts provide a running balance of the value of the materials on hand.
Replenishment of Stock Materials are received and issued by the storekeeper to different production departments. One important duty of a storekeeper is the restocking of stores in order to ensure efficient functioning of the stores department and steady flow of materials to the production departments. The inflow and outflow of materials has to be regulated in such a manner that neither production is adversely effected due to want of materials nor there unnecessary blocking of capital funds due to overstocking of raw materials. This implies that there is always a limit to the minimum and maximum quantity of materials or stock in the store. The storekeeper is to requisition for stock for replenishment in time so as to ensure honoring of requisition slips from production departments. Replenishment of stock therefore implies as ‘taking steps for the fresh purchase of those stocks which have been exhausted and for which requisitions are to be honored in future’.
In order to ensure that the optimum quantity of materials is purchased and stock—neither less nor more, the storekeeper applies scientific techniques of materials management. Fixing of certain levels for each item of materials is one of such techniques.
The following levels are generally fixed.
- Order level.
- Maximum level.
- Minimum level.
- Danger level.
Order Level
It is also known as Re-ordering level in relation with an item of stock. It is the point at which it becomes essential to initiate purchase orders for its fresh supplies. Normally, re-ordering level is a point between the maximum and the minimum stock levels. Fresh orders must be placed before the actual stocks touch the minimum level, so as to take care of lapse in time the placing of the order and the receipt of materials in stores. Following are the factors that are taken into account for fixing re-order level.
- The maximum consumption.
docsity.com
This is the maximum quantity of the material that is expected to be consumed in a day or in a week or in a month time.
- Lead time. This is the estimated time period in number of days or in weeks or in months, which is necessarily required for placing an order and finally receiving it in the stores. There might be different lead times for different consumptions. For example; more time will be required for maximum consumption comparing with the time required for minimum or average consumption.
- Economic order quantity. Details of the economic order quantity will be covered in the next lesson; here this will be sufficient to learn that it is the level where the ordering quantity will be most economical. Although EOQ is not required while calculating the order/re-order level but one must keep in mind the EOQ of the item for determining the order level. Most of the times where purchases are made according to the EOQ, the order level is half or the EOQ. Formula
Order Level/reorder level /Reorder point = Maximum Consumption x Lead Time
(maximum)
Maximum Stock Level
The maximum stock level indicates the maximum quantity of an item of material which can be held in stock at any time. The maximum stock level is fixed by taking into consideration the following factors:—
- Minimum rates of consumption. This is the minimum quantity of the material that is expected to be consumed in a day or in a week or in a month time.
- The lead time. This is the estimated time period in number of days or in weeks or in months, which is necessarily required for placing an order and finally receiving it in the stores. There might be different lead times for different consumptions. For example; more time will be required for maximum consumption comparing with the time required for minimum or average consumption.
- Economic ordering quantity. Details of the economic order quantity will be covered in the next lesson; here this will be sufficient to learn that it is the level where the ordering quantity will be most economical.
- Availability of funds,
- Availability of storage space.
- Risk of obsolescence, depletion, evaporation and material waste,
- Future fluctuations of price of materials.
- Cost of storage and insurance.
docsity.com
Average usage 50 units per week each Re-order quantity Frame 300 units Vase 500 units Re-order period Frame 4 to 6 weeks Vase 2 to 4 weeks Emergency lead time Frame 2 weeks Vase 1 week
Calculate for each component:
- Re-order level,
- Maximum stock level, and
- Minimum stock level,
- Danger stock level.
Solution Re-order level:
Maximum consumption x Lead Time [maximum]
Frame 75x6 450 units Vase 75x4 300 units Maximum stock level:
Reorder level – (Minimum consumption xLead time [minimum]) + EOQ
Frame 450 + 300 – (25 X4) 650 units Vase 300 + 500 – (25x2) 750 units Minimum stock level:
Reorder level – (Average consumption xlead time [Average])
Average lead time = Maximum + Minimum 2 Frame 450 – (50X5) 200 units Vase 300 – (50X3) 150 units
Danger stock level:
Average consumption xEmergency lead time
Frame 50 x 2 100 units Vase 50 x 1 50 units
Q. 2 From the following information calculate the Maximum stock level, Minimum stock level, Re-ordering level and Danger stock level;- (a) Average consumption 330 units per day (b) Maximum consumption 420 units per day (c) Minimum consumption 240 units per day (d) Re-order quantity 3,600 units (e) Re-order period 10 to 15 days (f) Emergency Re-order period 12 days
Solution : Re-ordering level:
Maximum consumption x Lead Time [maximum]
420x15 6,300 units.
docsity.com
Maximum stock level:
Reorder level – (Minimum consumption xLead time [minimum]) + EOQ
6,300 – (240 x 10) + 3,600 7,500 units
Minimum stock level:
Reorder level – (Average consumption xlead time [Average])
Average lead time = Maximum + Minimum =15+10 =12. 2 2 6,300 - 330 x 12.5 2,175 units
Danger stock level:
Average consumption xEmergency lead time
330 x 12 3,960 units
PROBLEMS
Q. 1
From the following particulars, calculate: — Re-order level, Minimum level, Maximum level, and Danger level. Average usage 400 units per day Minimum usage 60 units per day Maximum usage 130 units per day Economic order quantity 5000 units Re-order period 25 to 30 days
Q. 2 In manufacturing its Products, a Company uses three raw materials. A, B and C, in respect of which the following apply: Raw material
Usage per unit of Product kg.
Re-order Quantity kg.
Price Per kg.
Delivery Period Re-order level kg,
Min Avg Max A 10 10,000 0.10 1 2 3 8, B 4 5,000 0.30 3 4 5 4, C 6 10,000 0.15 2 3 4 2,
Weekly production varies from 175 to 225 units, averaging 200 units. What would you expect the quantities of the following to be: (a) Minimum stock of A (b) Maximum stock of B (c) Re-order level of C (d) Danger stock level of A
Q. 3 Two components of A and B are used as follows:— Normal usage 50 units per week each Minimum usage 25 units per week each
docsity.com
