Key points
- Calculate using usable parts and complete replenishment lead time.
- Subtract firm allocations before proposing an order.
- Assess rare critical parts separately from average consumption.
Classify items before calculating
Regularly consumed parts and seldom-replaced components need different controls. The engineering manager separates predictable consumables, critical spares and items that a dependable supplier can provide quickly. Record compatible models, storage location, pack size and any manufacturer-defined storage limitations. Do not assume two visually similar components are interchangeable simply because they fit the same shelf description.
Criticality depends on the service affected and available alternatives, not just purchase price. A cheap part can immobilise essential equipment. Conversely, an expensive component covered by a confirmed replacement service may be managed through supplier availability. This analysis supports efforts to reduce hotel operational downtime, without suggesting that a larger stock can eliminate every failure or delay.
Define the calculation inputs
For a regularly used item, let c be average consumption in units per day. Let L be the complete time until replenishment becomes usable: detecting the need, approval, delivery and receipt checks. Include possible delay between stock reviews instead of using the carrier's transit time alone. The safety allowance s, in units, is an explicit decision informed by observed variation.
The proposed minimum is c × L + s, rounded up. The maximum is c × (L + C) + s, rounded up, where C is the additional coverage selected between purchases. Inventory position equals usable on-hand stock plus confirmed orders available before they are needed, minus firm allocations not already covered by consumption c. If an allocation is included in the demand forecast, remove it from that forecast before subtracting it from stock: the same requirement must not be counted twice. When that position reaches or falls below the minimum, the proposed order is maximum minus position, with a floor of zero.
| Input | Unit | Check before calculating |
|---|---|---|
| c: average consumption | Parts per day | Same period and item reference |
| L: complete lead time | Days | Include approval, receipt and review delay |
| s: selected allowance | Parts | Visible, reviewable justification |
| C: additional coverage | Days | Consistent with storage and purchasing |
| Inventory position | Parts | Exclude held goods and late orders; avoid counting the same demand twice |
Follow a fictional ordering example
A fictional compatible part is consumed at 0.4 units per day. Complete lead time L is ten days, the allowance is three parts and C is fifteen days. Minimum stock is 0.4 × 10 + 3 = 7 parts. Maximum stock is 0.4 × 25 + 3 = 13 parts. These parameters illustrate the method; they are not thresholds recommended for every hotel.
The store has eight usable parts, two on a confirmed order available before the need and four firmly allocated outside consumption c. Position is 8 + 2 − 4 = 6 parts. This is below the minimum, so the theoretical order is 13 − 6 = 7 parts. If the supplier sells packs of four, the proposed purchase becomes eight. The resulting position would be fourteen, with the excess explained by pack size.
Add an exception matrix
| Situation | Decision to assess | Evidence required |
|---|---|---|
| Regular consumption | Calculated minimum/maximum with review | Issue history and observed lead times |
| Rare part, major outage consequence | Dedicated spare or contractual cover | Technical advice and confirmed availability |
| Manufacturer supersedes the part | Compatibility review before purchase | Written supplier confirmation |
| Part awaiting checking | Exclude from usable stock | Check result or return decision |
An average is unreliable when issues reflect a one-off campaign or the equipment fleet has changed. Separate those events and document the assumption selected. Zero consumption does not establish that no spare is needed; it may simply reflect a short period without failure. In that case, backup provision requires an argued technical and operational decision rather than a mechanical average.
Review after meaningful changes
The store records issues, returns and allocations; engineering confirms their destination; purchasing updates lead times and orders. After a stockout, urgent purchase or model change, investigate why the parameters failed to cover the need. Correct the underlying cause rather than increasing every safety allowance. A late approval, for example, needs a different response from an incompatible part arriving.
The record is current when physical quantities, commitments and compatibility agree. Retain earlier parameter values with their change dates. The calculation can live in a spreadsheet or suitable stock system. It does not assume that RoomChecking automatically calculates thresholds or maintains a spare-parts inventory. Review the operating method separately from the software capabilities used to support it.
Frequently asked questions
How should an uncertain supplier order be treated?
Do not treat it as assured availability. Show it separately, test the position without those units and confirm timing before relying on the shipment.
Should every part have the same safety allowance?
No. Variation, lead time and alternatives differ. Rare critical parts need a dedicated decision rather than an identical percentage applied to every reference.
