Reduce Stockouts with a 10–20 SKU Min/Max Pilot for Maintenance Teams

Stock mínimo is the inventory level that triggers a reorder, and stock máximo is the ceiling you reorder up to. The immediate rule: when stock reaches or falls below the minimum, place an order that brings the position back towards the maximum, sized using a reorder point formula such as daily demand multiplied by lead time, plus safety stock.

TL;DR:

• Static min-max levels work best for stable-demand SKUs like maintenance spares and consumables, but fail during seasonal spikes or promotions.
• Reorder point calculations should include demand, lead time, and safety stock, which must be regularly reviewed and adjusted based on demand variability.
• Safety stock needs depend heavily on lead-time variability and demand fluctuation, with statistical approaches preferred for critical or erratic SKUs.
• Applying the same thresholds across all SKUs causes frequent stockouts or overstocks; segmentation and tailored review cadences improve accuracy.
• Regular recalibration of thresholds, especially for high-criticality items, helps prevent drift caused by changes in demand, lead time, or supplier conditions.

Table of Contents

• What stock mínimo and stock máximo actually mean
• Formulas and a worked example you can replicate in Excel
• How much safety stock you really need
• Setting min and max across your catalogue without drowning in exceptions
• Where min-max breaks down in practice
• Configuring min-max in your software and reconciling with the books
• Practical maintenance inventory tactics worth testing
• Treat your thresholds as living numbers, not settings you configure once
• Running min-max pilots with FullyOps
• FAQ
• Sources

What stock mínimo and stock máximo actually mean

Stock mínimo, in most systems, is used interchangeably with the reorder point: the quantity on hand (plus anything on order) at which you must trigger replenishment. Stock máximo is the order-up-to level, the ceiling you restock to so you avoid tying up capital or warehouse space in excess parts. These are not the same as safety stock, which is the buffer built into the minimum to absorb demand spikes or late deliveries rather than a trigger point itself.

A min-max system suits SKUs with reasonably stable, predictable demand: maintenance spares, consumables and mid-velocity items where a fixed reorder quantity makes sense. It is a poor fit for highly seasonal lines or fast-moving consumer goods with sharp demand swings, where dynamic forecasting usually outperforms fixed thresholds.

The appeal is simplicity: staff can act on a single trigger without recalculating demand forecasts daily. The trade-off is rigidity.

• Min-max works well for stable-demand spares and consumables with predictable lead times.
• It struggles with seasonal or promotional spikes unless thresholds are updated frequently.
• It reduces decision fatigue for buyers but can mask shifts in real demand if left static too long.

Formulas and a worked example you can replicate in Excel

The reorder point formula is the backbone of any min-max setup:

1. Reorder point (ROP) = (average daily demand × lead time in days) + safety stock. This gives you the minimum.
2. Safety stock, heuristic approach = (maximum daily demand × maximum lead time) − (average daily demand × average lead time). Simple, conservative, no statistics required.
3. Safety stock, statistical approach = k × standard deviation of demand during lead time, where k is the safety factor tied to your target cycle service level.
4. Stock máximo = ROP + order quantity (often an economic order quantity, a fixed lot size or a capacity constraint, whichever is lowest).

Worked example: say a maintenance spare has average daily demand of 4 units, lead time of 10 days, and a safety stock of 15 units calculated heuristically. The reorder point is (4 × 10) + 15 = 55 units. If your order quantity is sized accordingly, the maximum becomes the reorder point plus the order quantity, here 135 units.

Now add a supplier constraint: if the minimum order quantity is 100 units, you round the order up, which pushes the practical máximo to 155 units rather than 135. Modified order-up-to policies that explicitly account for minimum and maximum order quantity constraints perform well against far more complex optimal models, according to research on stochastic inventory systems, so building this rounding logic into your system from the outset avoids constant manual correction.

How much safety stock you really need

Safety stock exists to protect your target cycle service level, the probability of not stocking out during a replenishment cycle, and your fill rate, the proportion of demand met directly from stock. Both depend heavily on how variable your lead times are, not just how long they average.

Lead-time variability does not always behave the way intuition suggests. Research on lead-time uncertainty shows that reducing lead-time variability can be a more effective lever for lowering safety stock than reducing mean lead time, but at many practical cycle service levels, roughly 50 to 70%, reducing the mean lead time is often the more reliable way to cut inventory. The relationship flips depending on your target service level, which is why a single rule of thumb rarely survives contact with a diverse catalogue.

For critical spares or SKUs with erratic demand, a statistical approach using the safety factor k tied to your desired service level gives you more control than a flat heuristic. For high-volume, low-variability lines, the heuristic formula is usually accurate enough and far quicker to maintain.

Run simulation or probabilistic forecasting instead of a single-number method when lead times fluctuate widely, when a stockout carries a high operational cost, such as a critical machine spare, or when historical demand data is thin. Review your safety factor k at least quarterly, and more often for your highest-criticality items, adjusting it as actual service levels drift from target.

Setting min and max across your catalogue without drowning in exceptions

Trying to apply the same formula to every SKU is how min-max systems collapse under their own maintenance burden. Segment first, then decide how much manual attention each group deserves.

ABC-XYZ segmentation combines value (A, B, C by consumption value) with demand variability (X, Y, Z by predictability). Hybrid approaches that combine service-level safety stock formulas with ABC-XYZ segmentation, and occasionally Theory of Constraints heuristics, tend to outperform a single blanket min-max rule, particularly for the SKUs that matter most, according to research on safety-stock strategies.

• AX items (high value, predictable demand): automate min-max with statistical safety stock, review monthly.
• CZ items (low value, erratic demand): simpler heuristic rules or even manual reorder, reviewed less often.
• Critical spares regardless of value: treat as a separate category with higher service-level targets.

Assign a named owner to each segment’s review cadence, not just a system alert, and track fill rate, stockout frequency and days of cover as your core KPIs.

Pro Tip: Recalibrate thresholds whenever lead time, supplier terms or demand patterns shift materially, not just on a fixed annual schedule.

Our inventory management tips for operations teams walk through review cadence and governance in more depth.

Where min-max breaks down in practice

Static thresholds age badly. A few recurring failure patterns account for most of the stockouts and overstocks we see reported in maintenance and retail operations alike.

• Supplier minimum order quantities and case-pack sizes distort your calculated máximo, forcing rounding that either overshoots capacity or undershoots safety margins.
• A sudden lead-time spike or an unplanned promotional uplift renders a static minimum obsolete within days, not months.
• Mismatches between system stock and physical stock, caused by unlogged transactions or miscounts, quietly erode the accuracy of every formula built on top of them.
• Infrequent buffer updates leave thresholds chasing last year’s demand pattern rather than this year’s.

A Portuguese retail case study on replenishment and stockouts found that monthly buffer recalculation, rather than annual review, combined with clear classification of stockout causes (master data errors, supplier service failures, warehouse delays, promotions and forecasting gaps) materially reduced repeat stockouts. The practice also commonly excludes promotional weeks from demand averages to avoid distorting the baseline.

Configuring min-max in your software and reconciling with the books

Your MRP or inventory system needs several parameters set correctly for min-max to hold up: minimum level, maximum level, lead time, lot size, safety stock and any supplier MinOQ or MaxOQ. Presence of minimum and maximum order quantity constraints makes an exactly optimal ordering policy far harder to compute, which is why most practical systems rely on heuristic, modified order-up-to rules instead.

1. Configure MinOQ and MaxOQ as hard constraints so the system rounds orders to the nearest feasible quantity rather than flagging an exception every cycle.
2. Reconcile daily transaction records against physical counts regularly, not only at year-end, since guidance on year-end stocktakes notes that statutory reconciliation obligations create audit risk when system and physical stock drift apart.
3. Run a pilot on a limited SKU set before rolling thresholds out catalogue-wide.

Our inventory tracking guide covers transaction-level tracking and reconciliation in more detail.

Practical maintenance inventory tactics worth testing

A Kanban or min-max pilot on 10 to 20 SKUs run over 30 to 90 days tends to surface most implementation issues, lead-time inaccuracies, rounding errors, forgotten MOQs, before you scale up. Asset-linked spare coding ties parts to specific equipment and maintenance schedules, turning replenishment into a demand-driven signal rather than a guess. Automating the chain from work order to parts consumption to reorder alert closes the gap that causes drift between system and shelf.

Treat your thresholds as living numbers, not settings you configure once

The biggest mistake we see is treating min and max as a one-time configuration task rather than an operational habit. Numbers that were accurate in January drift by June as lead times, suppliers and demand shift underneath them.

Start with a 10 to 20 SKU pilot, measure fill rate and days of cover, and let the data argue with your assumptions before you trust either one fully. Tuning min-max is always a negotiation between statistical rigour and the judgement of the person who knows why a supplier always runs three days late. Align your service-level targets with what the business actually needs protected, not with what looks tidy on a spreadsheet.

— Pedro

Running min-max pilots with FullyOps

We built FullyOps around the parts of this problem that are hardest to keep accurate by hand: inventory tracking tied to specific assets, automated alerts when stock crosses a threshold, and reporting that shows fill rate and days of cover without a manual export. For a maintenance team running a pilot, that means parts consumption from work orders feeds straight back into your reorder signals instead of sitting in a spreadsheet nobody updates.

• Asset-linked inventory tracking connects spare parts consumption to the equipment that uses them.
• Automated threshold alerts flag SKUs approaching their minimum before a stockout hits a work order.
• Reporting and analytics surface fill rate, days of cover and recalibration needs by segment.

We offer plans scaled to the size of your technician and admin teams. If you want to see how a pilot would run on your own catalogue, you can explore FullyOps plans and request a demo.

FAQ

What is the difference between stock mínimo and safety stock?

Stock mínimo is the reorder trigger point, the level at which you place a new order. Safety stock is the buffer built into that minimum to absorb demand spikes or late deliveries, so the minimum is typically calculated as expected demand during lead time plus safety stock.

How do you calculate stock máximo?

Stock máximo is usually the reorder point plus your order quantity, whether that quantity comes from an economic order quantity calculation, a fixed lot size or a capacity limit. When a supplier enforces a minimum order quantity, you round the order up, which raises the practical maximum above the theoretical figure.

How often should min and max levels be reviewed?

High-value, high-criticality items are worth reviewing monthly, while stable, low-variability lines can go longer between updates. Retail case study evidence suggests monthly buffer recalculation reduces repeat stockouts compared with annual-only reviews.

Can min-max systems handle seasonal demand?

Static min-max thresholds struggle with seasonality unless updated frequently to reflect the current period’s demand pattern. For strongly seasonal or promotional SKUs, pairing ABC-XYZ segmentation with more frequent recalibration, or shifting to statistical forecasting, tends to perform better than a fixed threshold.

What causes mismatches between system stock and physical stock?

Unlogged transactions, miscounts and delayed data entry are the most common causes, and they erode the accuracy of any formula built on top of the reported stock figure. Reconciling daily transaction records against physical counts, rather than waiting for an annual stocktake, helps catch drift before it affects reorder decisions.

Sources

• The effect of lead time uncertainty on safety stocks
• A simple heuristic policy for stochastic inventory systems with both minimum and maximum order quantity
• Enhancing inventory management through safety-stock strategies—case studies and hybrid models
• Case study: replenishment and stockout analysis in Portuguese retail

Recommended

• Cut Maintenance Stockouts in 90 Days Using Asset Linked Spare Coding
• Maintenance Teams: Research Backed 90 Day Pilot to Cut Spare Parts Use
• Parts Kanban: Size and Run a Pilot for 10–20 SKUs in 30 Days
• Move Your Maintenance Inventory to FullyOps in 60–90 Days