Inventory Management for Retail — Deterministic Demand

Build a simple model to simulate the impact of several replenishment rules (Basic, EOQ) on the inventory costs and ordering costs

Inventory Management for Retail — Deterministic Demand

Build a simple model to simulate the impact of several replenishment rules (Basic, EOQ) on the inventory costs and ordering costs

Article originally published on Medium.

For most retailers, inventory management systems take a fixed, rule-based approach to forecast and replenishment order management.

Considering the distribution of the demand, the objective is to build a replenishment policy that will minimize your ordering, holding and shortage costs.

  • Ordering Costs: fixed cost to place an order due to administrative costs, system maintenance or manufacturing costs in (Euros/Order)
  • Holding Costs: all the costs required to hold your inventory (storage, insurance, and capital costs) in (Euros/unit x time)
  • Shortage/Stock-out Costs: the costs of not having enough inventory to meet the customer demand (Lost Sales, Penalty) in (Euros/Unit)

In this article, we will present a simple methodology using a discrete simulation model built with Python to test several inventory management rules based on assuming:

  • Deterministic Constant Demand: D (Units/Year)
  • Lead Time between ordering and replenishment (Days)
  • Cost of shortage and storage (Euros/Unit)

💌 New articles straight in your inbox for free: Newsletter

💡
SUMMARYI. ScenarioProblem StatementAs an Inventory Manager of a mid-size retail chain, you are in charge of setting the replenishment quantity in the ERP.ObjectiveII. Build your ModelEconomic Order Quantity (EOQ)What is the best compromise between ordering and holding costs?1. Visualize the current rule2. Economic Order Quantity: Q = Q*3. Include replenishment lead time4. Real-Time visualization of Cost of Goods Sold (COGS)III. Conclusion & Next Steps

I. Scenario


Problem Statement

As an Inventory Manager of a mid-size retail chain, you are in charge of setting the replenishment quantity in the ERP.

Based on the feedback of the store manager, you start to doubt that the replenishment rules of the ERP are the most optimal especially for the fast runners because your stores are facing lost sales due to stock-outs.

For each SKU, you would like to build a simple simulation model to test several inventory rules and estimate the impact on:

  • Total Costs: how much does it cost to receive, store and sell this product?
  • Shortages: what is the % of lost sales due to stock-out?

In this article, we will build this model for,

💡
# Total Demand (units/year)D = 2000# Number of days of sales per year (days)T_total = 365# Customer demand per day (unit/day)D_day = D/T_total# Purchase cost of the product (Euros/unit)c = 50# Cost of placing an order (/order)c_t = 500# Holding Cost (% unit cost per year)h = .25c_e = h * c# Selling Price (Euros/unit)p = 75# Lead Time between ordering and receivingLD# Cost of shortage (Euros/unit)c_s = 12

To simplify the comprehension, let’s introduce some notations

Equations — (Image by Author)

Objective

In this article, we will

  1. Visualize the current rule used by the store's manager
  2. Calculate the Economic Order Quantity and simulate the impact
  3. Visualize the impact of lead time between ordering and receiving
  4. Real-Time Visualization of COGS for each rule
🔗
You can find the full code in this Github repository: Link.

II. Build Model

Economic Order Quantity (EOQ)

The theory behind the Economic Order Quantity (EOQ) that is used by many Inventory Optimization models is to find the optimal order quantity Q* that will be the best compromise between ordering costs and holding costs.

  • A low order quantity will give you high ordering costs (increase the number of replenishment orders: D/Q) but will reduce your holding cost (reduce the average inventory level: (Q/2))
  • The inverse for a high order quantity
Total Relevant Cost
Minimum of Total Relevant Cost — (Image by Author)

Comments

In the chart above we can see that the Total Relevant Cost (TRC) (total cost without the purchase cost cD) is minimum for Q*=400 units/order.

TRC(Q*) = 5,000 Euros

1. Visualize the current rule

The current rule is to order every 10 days the exact quantity needed to absorb the demand for 10 days.

This quantity is way lower than Q*, we can easily understand that the TRC will be way higher than its optimal value:

TRC(10) = 100,062 Euros

To understand why let’s simulate the rule for a range of 365 days:

Inventory Management with Constant Demand
Current Rule Modelisation — (Image by Author)
Comments
Very short replenishment cycles that multiply the number of replenishment orders.

2. Economic Order Quantity: Q = Q*

For each replenishment cycle, you order Q* = 400 orders and you reorder when the inventory level is zero.

Inventory Management with Deterministic Demand: Economic Ordrer Quantity
Economic Order Quantity — (Image by Author)
Comments
Longer replenishment cycles that reduce the number of orders by 7 times => lower TRC

3. Include replenishment lead time

What would be the stock-out level if we have a replenishment lead time LD = N Days?

Economic Order Quantity with 25 days lead time — (Image by Author)
Comments
With 25 days lead time between ordering and receiving we reach 140 units of stock-out quantity per replenishment cycle.

4. Real-Time visualization of Cost of Goods Sold (COGS)

If you want to convince your commercial team and the store managers; you need to speak their languages.

You can prepare a simple visualization of the potential turnover with the COGS (here we’ll exclude purchase costs COGS = TRC) to understand the impacts throughout the year.

Initial Rule

COGS with initial rule — (Image by Author)
Comments
COGS is mainly driven by the ordering costs because of the high frequency of reordering due to the low replenishment quantity.

EOQ Rule

COGS with Q* (EOQ) — (Image by Author)
Comments
We see here that the Economic Order Quantity is providing a compromise between ordering costs and holding costs that drastically reduce the total COGS.

III. Conclusion & Next Steps


Conclusion

This simple modelisation was the occasion to design a basic simulation model that shows the impact of customer demand and inventory rules on key performance metrics.

It gives you visibility on your ordering frequency, inventory level and the impacts of lead times in your supply chain.

Next Steps

The initial assumption of constant deterministic demand is very optimistic. In the next article, we’ll study the impact of the variability of the demand on the total relevant costs and the lost sales.

About Me

Let’s connect on Linkedin and Twitter, I am a Supply Chain Engineer that is using data analytics to improve logistics operations and reduce costs.

If you’re looking for tailored consulting solutions to optimize your supply chain and meet sustainability goals, feel free to contact me.