Service Level Calculator

A supply chain calculator covers the three pillars of inventory management: Economic Order Quantity (EOQ) to minimise total ordering and holding costs, safety stock and reorder point to prevent stockouts during lead time, and seasonal demand forecasting using seasonal indices. These techniques are standard tools in operations management, procurement, and supply chain planning for businesses of all sizes.

The EOQ model (Wilson formula) finds the optimal order quantity that balances the cost of ordering too often (high ordering cost) against the cost of holding too much inventory (high holding cost). Safety stock adds a buffer above the average lead-time demand to absorb variability in demand or lead time. Seasonal indices decompose annual demand into quarterly or monthly patterns to guide procurement planning.

1. EOQ / Ordering tab: enter annual demand, cost per order, and annual holding cost per unit. The calculator finds the optimal order quantity, number of orders per year, and total annual inventory cost.
2. Safety Stock and ROP tab: enter average daily demand, lead time, daily demand standard deviation, and target service level. The calculator computes safety stock (Z × σ × √LT) and reorder point (average lead-time demand + safety stock).
3. Seasonal Forecast tab: enter quarterly demand figures. The calculator computes seasonal indices for each quarter to multiply next year's forecast by when building a quarterly plan.

Supply chain inventory formulas

Economic Order Quantity (Wilson/Harris): EOQ = √(2DS/H), where D = annual demand, S = cost per order, H = annual holding cost per unit. Total annual cost = (D/EOQ)S + (EOQ/2)H.

Safety stock: SS = Z × σ_d × √(LT), where Z is the service-level z-score (90% → 1.282; 95% → 1.645; 99% → 2.326), σ_d = standard deviation of daily demand, LT = lead time in days. Reorder point: ROP = d̄ × LT + SS.

Seasonal index = quarter demand / quarterly average. Next year's quarterly forecast = annual forecast × seasonal index / 4.

Understanding supply chain results

Trade-offs in EOQ and service levels

EOQ minimises total inventory cost — but only under its simplifying assumptions (constant demand, fixed lead time, no volume discounts). In practice, MOQ constraints, supplier lead-time variability, and perishability all require adjustments. A 95% service level means you will have stock available in 95 out of 100 order cycles; the remaining 5% risk a stockout. Increasing to 99% roughly doubles safety stock due to the non-linear increase in z-score. For low-value, high-demand items, a lower service level (90%) may be cost-effective; for critical or expensive items, 99%+ is standard.

Business tips and best practices

• EOQ assumes constant, known demand. For intermittent or lumpy demand (e.g. spare parts), use a periodic review or min/max system instead.
• Holding cost typically includes warehousing, insurance, obsolescence, and opportunity cost — often estimated at 20–30% of unit value per year for physical goods.
• Reorder point assumes lead time is deterministic. If lead time also varies, use the combined formula: SS = Z × √(LT × σ_d² + d̄² × σ_LT²).
• Seasonal indices above 1.3 or below 0.7 suggest strongly seasonal demand — plan purchasing 6–8 weeks before the peak to account for supplier lead times.

EOQ and safety stock formulas are standard operations research models. The z-scores used are based on the standard normal distribution. Seasonal index calculations assume additive seasonality and equal-length periods. This calculator is for planning and estimation purposes only; actual procurement decisions should account for supplier constraints, contractual minimum order quantities, and business-specific risk tolerances.

Related Calculators

• Profit Margin Calculator
• Markup Calculator
• Business Break Even Calculator
• Revenue Growth Calculator