How does the material-consuming asset management system work? Batch life and early warning of consumption
The idea of a system for the management of waste materials is to be used in real terms, with three things at its core: whether batch numbers and effective periods are written into the system when it enters the bank; whether they are automatically approved first-in-first-out (FIFO, which prioritizes the first-in-the-bank) and whether the rules of warning are running every day. These three steps are complete, and the most common pits, such as expired and stock cut-off, are basically blocked.
Point 1: Batch and validity periods are written into the system at the entry point
Batch numbers and validity dates are not ex post facto fields, but rather hard data for the system when they are received. A standard inventory contains at least four elements: material code, batch number, production date, and valid until. Batch recommendations are in a uniform naming format, such as using "material code-manufacturing year-flow" (e.g. GL-202403-001) to follow up with a visual look at the source.
The most easily pedals in the operation are "one-yard multiple" -- different batches of the same material are mixed in a single inventory, and the system has no idea which batch is expired. When we land on such projects, we suggest that the batch numbers be filled with a unique index, and that they be eliminated from the source.
Element 2: Three-tier rule for effective early warning
The QEO is not just a "faster" reminder, but a slotting management.
- 90 days: yellow light alarm, hint for planned use;
- 60 days from the end of the evaporation period: Orange light warning, faster turnaround or coordinated redeployment;
- 30 days: Red light emergency, priority must be given to consumption or isolation.
The three-stage equivalent recipients also need to distinguish between yellow lights being pushed to the warehousekeeper, orange light being pushed to the procurement and supervisor, and red light being given directly to the head of the user department and quality post.
Element 3: Consumption warning is based on average monthly usage x safety factor
A consumption alert should warn you before stock runs out, so set the lower threshold carefully. A common method is to multiply average monthly usage over the past three to six months by a safety factor, generally between 1.5 and 2. For example, if you've used an average of 30 bottles of a reagent per month over the last six months and use a factor of 1.5, set the threshold at 45 bottles. Below that, the system recommends a purchase.
The safety factor for different materials cannot be applied in one way or the other. High-value consumables (unit price, low amount) can be placed at 2 or even 3 to avoid disruptions; low-value, easy-to-use coefficients can be pressed to 1.2, and too much pressure is spent on money. After early warning has been triggered, the system automatically generates a single purchase proposal that is put to the procurement position, and the buyer confirms the number and supplier.
Point 4: Use chain to force "Bent first" to pick up.
The core principle of batch management is FIFO - the first use of a first-in-the-reposit system. This takes two steps: automatic recommendation of a batch in the order of the life-cycle at the time of inventory release, as confirmed by a warehousekeeper's scan; and a "overvalid material bank" set up for a system hard-to-stop, with no normal access to any obsolete material, which can only be used as a dead end or quarantine process.
In highly regulated sectors such as healthcare, food, and cosmetics, FIFO is an audit requirement. Keep traceable system records of blocked transactions for at least three years.
Element 5: Dynamic inventory + full, double-layer verification quarterly
Even accurate system data needs physical verification. Two parallel count schedules are more reliable: monthly cycle counts for high-value consumables and stock close to expiry, one category at a time, and a quarterly full inventory across all categories. Check for mismatches, expiry exceptions, and mixed batches. After posting results to the system, discrepancies above the set threshold, such as ±2%, should generate shortage or surplus documents for approval.
Point 6: Focus on three core indicators in the statements
After the system has run, it's enough to look at three indicators on a daily basis:
- (a) The proportion of recent stocks: the amount of material in the 90-day period is a percentage of total inventory, and the sector health line generally ranges between 8 per cent and 15 per cent;
- (a) Early warning response time limits: the average number of days from early warning to completion of the purchase order is recommended to be contained within 3 days;
- Batch accuracy: The proportion of the batch that matches at the time of inventory is stable at 99 per cent or more.
Any of these three indicators that continue to deviate from the target line indicates a gap in process or configuration, requiring back-checking of system rules and on-site implementation.
Point 7: Several areas that are easy to step on.
Finally, several questions arise from the actual project:
- The batch numbers are checked on the supplier ' s delivery order and re-recording at the warehouse is prone to error;
- The valuing format must be uniform to yyyy-mm-dd, and the mixing of 2024/3/1 and 2024-03-01 would render the system match ineffective;
- Early warning recipients should not be accompanied by one person, and the post-employment rule would cease, at least with a proper back-up;
- Once the safety factor is set, it is repeated every six months and the failure to adjust when material use changes significantly will be distorted.
The value of the material management system is not much or much more functional, but whether the three types of data -- batch, life, inventory -- can be transferred in an accurate and continuous manner. Rules are well-set, processes are smooth and people are on track, and it is almost impossible to resolve the two main issues: expiry and cut-off.

Ms. Lei
Mr. Pang