Calculate reorder levels and suggested quantities
AI Inventory uses a transparent, auditable set of formulas to convert the AI-forecast of daily usage into four actionable numbers: the reorder level, days of stock cover, target stock, and suggested order quantity. Understanding these formulas helps you verify why a product triggered a reorder alert, how its suggested quantity was reached, and what you can change to influence future calculations.
Audience: Center managers and inventory administrators who review AI Inventory recommendations and want to verify or explain the numbers before creating purchase orders.
Availability: AI Inventory is available as a Beta module. Contact your Zenoti representative to enable it for your organization.
Before you begin
Permission: Add or Edit (on the Inventory security object) β required to view the action grid and its calculated columns.
- AI Inventory must be activated for your organization and center. See Set up AI Inventory Manager.
- Confirm that Reorder coverage, Lead time, and Safety days are configured at the organization level or overridden at the center or product level. See Configure AI Inventory Manager settings.
- To view the action grid and its calculated columns, you need Add or Edit permission on the Inventory security object.
- All formulas run during a nightly refresh. Setting changes take effect at the next nightly refresh, not immediately after you save.
Steps
The system runs the four formulas below in sequence during each nightly refresh. The results populate the Predicted daily usage, Stock / Reorder level, Days of stock left, Target stock, Suggested order quantity, and Pack size adjustment columns in the action grid.
Step 1: Calculate safety stock
Safety stock is the buffer quantity the system holds to protect against late deliveries or unexpected demand spikes.
Formula:
Safety stock = β safety days Γ predicted daily usage β
The result is always rounded up (ceiling) to the nearest whole unit.
Example: If Safety days is 2 and Predicted daily usage is 4.3 units per day:
Safety stock = β 2 Γ 4.3 β = β 8.6 β = 9 units
Step 2: Calculate the reorder level (Dynamic Reorder Point)
The reorder level is the on-hand stock quantity at which the system triggers a reorder alert. It answers: "How low can stock fall before you need to order to cover the delivery window plus your safety buffer?"
Standard formula:
Reorder level = β predicted daily usage Γ (lead time + safety days) β
When lead time is zero (same-day delivery):
Reorder level = safety stock
The result is always rounded up (ceiling). When on-hand stock falls below the reorder level, the product's status changes to Low or Critical and a reorder alert fires.
Note: When a manual alert level has been set for a product, it overrides the system-calculated reorder level for that product. The explainability panel notes when an override is active.
Note: When Predicted daily usage is zero, the reorder level is set to zero and no reorder alert fires. The product is flagged as Slow Moving instead.
The explainability panel's Calculations part breaks down the formula using the labels below. For a product with daily usage of 5 units, lead time of 3 days, and safety days of 2 days, the panel displays:
- Daily usage: 5
- Γ Lead time: 3 days β =Needed during delivery: 15
- + Buffer (5/day Γ 2 days): 10
- =Reorder level: 25
Step 3: Calculate days of stock cover
Days of stock cover shows how many complete days the current inventory β on-hand plus incoming β will last at the current usage rate. This column appears in the action grid as Days of stock left.
Formula:
Days of stock cover = β (on-hand quantity + incoming quantity) Γ· predicted daily usage β
The result is always rounded down (floor) to the nearest whole day, because a partial day of cover does not constitute a full safe day.
Note: When Predicted daily usage is zero, this calculation does not run and the product is shown as Slow Moving.
Example: On-hand quantity = 40 units, incoming quantity = 10 units, daily usage = 5 units per day:
Days of stock cover = β (40 + 10) Γ· 5 β = β 10 β = 10 days
Step 4: Calculate target stock and suggested order quantity
These two formulas determine how much to order.
Target stock formula:
Target stock = predicted daily usage Γ (lead time + reorder coverage + safety days)
This order-up-to horizon covers three components: demand consumed while the order is in transit (lead time), the coverage the delivered order is meant to last (reorder coverage), and the safety buffer (safety days).
Raw suggested order quantity formula:
Raw SOQ = max( β target stock β on-hand quantity β incoming quantity β, 0 )
The raw figure is floored at zero so the system never produces a negative order quantity when stock is already above target.
Final suggested order quantity (after vendor adjustments):
The raw SOQ is rounded up to the nearest whole unit and then rounded up again to the next whole multiple of the vendor's pack size. The action grid displays the result as Suggested qty; the Pack size adjustment column shows how many units were added by rounding. The system rounds to the vendor's pack size only β it does not apply a separate vendor minimum order quantity (MOQ); if your vendor has an MOQ, verify manually that the rounded quantity meets it before sending the purchase order.
Note: The system always rounds the final order quantity up β it never rounds down and leaves you short.
Worked example β full calculation
A product with the following inputs:
Input Value Predicted daily usage 5 units/day Lead time 3 days Safety days 2 days Reorder coverage 30 days On-hand stock 18 units Incoming stock 0 units Vendor pack size 12 units
Metric Calculation Result Safety stock β 2 Γ 5 β 10 units Reorder level β 5 Γ (3 + 2) β 25 units Days of stock cover β (18 + 0) Γ· 5 β 3 days Target stock 5 Γ (3 + 30 + 2) 175 units Raw SOQ max( β 175 β 18 β 0 β, 0 ) 157 units Final SOQ (pack-size adjusted) β 157 Γ· 12 β Γ 12 = 14 Γ 12 168 units Because 18 < 25 (reorder level), a reorder alert fires. Days of stock cover (3) is less than lead time + safety days (5) but not less than lead time alone (3), so the product's status is Low. The Pack size adjustment column shows 11 units added by rounding.
Tips
- Verify inputs in the explainability panel before adjusting settings. The Calculations part of the panel shows the live Predicted daily usage, Lead time, and Safety days values that fed every formula for that specific product. Open it by selecting a product row and tapping Why this? See Review the explainability panel for a recommendation.
- Adjust Reorder coverage to match your ordering cadence. The default Reorder coverage is 30 days. If you order weekly, reducing it lowers target stock and suggested quantities. If lead times are long or supply is unreliable, increasing it builds a larger forward buffer. Changes take effect at the next nightly refresh.
- Use a manual alert level for products with atypical lead times. When a single SKU has a vendor lead time that differs substantially from your center default β such as a specialty import β set a manual alert level to override the calculated reorder level for that product only. The override is visible in the explainability panel.
- Monitor Slow Moving products on a regular schedule. Products with zero Predicted daily usage are excluded from all reorder alerts. Review these periodically in the action grid by filtering Stock status to see which products have stopped moving, and decide whether to discount, return, or discontinue them.
- Check Days of stock left before a long closure. Because days of stock cover counts full days at the current daily usage rate, a product showing 3 days of cover on the last working day before a multi-day holiday warrants an immediate review of the suggested order quantity.
Troubleshooting
- The reorder level seems higher than my actual delivery window warrants. The reorder level combines both lead time and safety days. If the total is larger than your risk exposure requires, reduce Safety days in settings. If the lead time value itself is wrong, check whether Lead time mode for the center is set to system-learned or a manual override, and correct the value accordingly. See Configure AI Inventory Manager settings. Changes take effect at the next nightly refresh.
- The suggested quantity is far larger than I expected. Check the Reorder coverage value in effect for this product. The target stock formula multiplies daily usage by lead time plus reorder coverage plus safety days, so a high reorder coverage setting produces a large target β and therefore a large gap between target and current stock. Also confirm that On-hand stock and Incoming stock in the action grid reflect current reality; stale inventory records inflate the order gap. If pack-size rounding is adding significant units, see Check pack size rounding.
- A product shows zero days of stock cover but is not triggering a reorder alert. Confirm that the product has a non-zero Predicted daily usage. When daily usage is zero, the reorder level is set to zero, no alert fires, and the system flags the product as Slow Moving instead. The days-of-stock-cover calculation does not run for Slow Moving products. See Check stock status and risk levels.
- Settings I changed today are not reflected in the action grid. Setting changes take effect at the next nightly refresh, not immediately on save. Check the grid again the following day. If values appear unchanged after 24 hours, contact your Zenoti administrator to confirm the nightly refresh completed successfully.
- A product has a manual alert level configured, but the reorder alert fires at the wrong quantity. Open the explainability panel for the product and check the Calculations part. When a manual alert level is active, the panel notes the override and shows the effective reorder level being used. Verify the override value is set correctly, then save and wait for the next nightly refresh to see updated status.
- Days of stock cover is lower than expected even though a large transfer is in transit. The incoming quantity included in the days-of-stock-cover formula reflects stock in confirmed incoming orders recorded in Zenoti. If a transfer or purchase order has not been recorded yet, that stock does not count toward the incoming total. Record the inbound order so it is included in the next nightly recalculation.