# Machine Learning for Store Delivery Scheduling

Design Replenishment Strategies to Optimize Inventory and Reduce Number of Deliveries from your Warehouse

Design Replenishment Strategies to Optimize Inventory and Reduce Number of Deliveries from your Warehouse

## I. Replenishment Strategy & Sequence

1. Demand Planning & Delivery Schedule

Scope

- Transactions from
to**2013–01–01****2017–12–31** sales transactions**913,000**unique SKU**50**Stores**10**days or replenishment per week: Monday, Wednesday, Friday, Sunday**4**hours lead-time between order creation and delivery from the warehouse**24**- Store opening from
to**10:00 am****08:00 pm** - Delivery from the warehouse at
**09:00 pm**

Following our lead-time requirements, replenishment orders have to be created by the store the day before after store closing.

Our replenishment algorithm will measure the inventory level

before store opening**10:00 am:**after store closing and before delivery (if replenishment day)**08:00 pm:**

Target: Inventory Day n+1 (10:00 am) = alpha x Capacity (alpha in [0, 1])

**Day n-1: Prepare Replenishment**

Data Input: Inventory Day n-1 (09:00 pm), Sales Forecast Day_n, Day_n+1, Day n +2**Target: Inventory of Day n+2 (08:00 pm)**

Fix inventory level before the following delivery:Day n+ 2**(09:00 pm)****Demand Planning**

Day_n replenishment needs to cover the demand of Day_n, Day_n+1 and Day_n+2 to reach the inventory level target at the end of Day_n+2 before the next delivery.**Constraint**

Inventory after delivery must be lower than the Maximum Capacity

### 2. KPI setting for Simulation of different strategies

**Inventory Shortage Incidents**

Our replenishment strategy will be evaluated on its capacity to accurately estimate replenishment quantity to reach inventory target day n+2. This estimation can be underestimated:

Example

**Day n-1: Prepare Replenishment Orders**

- Warehouse starts preparing orders**Day n: Shipments received at the end of the day**

- Inventory reduced by daily transactions

- Orders received at the end of the day**Day n+1: Inventory Shortage**

- Inventory level inherited from Day n is not enough to meet Day n+2 demand before shipments arrive at the end of the day.

**Average Inventory Level (%)**

By day,

100 x Storage Qty (Pcs) / Storage Maximum Capacity (Pcs)

Inventory Optimization:** **reach the lowest value possible without getting Inventory Shortage Incidents

**Reducing Replenishment Frequency**

Using the sales forecast, a replenishment strategy can reduce the number of replenishments.

The example above shows an example of replenishment day skipped; day n inventory is higher than minimum inventory and enough to meet day n+1 demand.

** Remark:** This KPI is highly dependent on Inventory Level (%); with a low inventory level it is hard to skip a replenishment without risking shortage incidents.

## II. Replenishment Method 1: Full Storage Capacity

We’ll start first with a simple replenishment strategy, replenishment order quantity is calculated based on:

**Day n-1: Replenishment Order at Day n-1**

Input Data: Inventory_Day_n-1 (09:00 pm), Capacity(item)**Order Quantity to reach maximum capacity**

**Initial Data**

Create Sales DataFrame, Inventory Record, Capacity by Item and Replenishment Data

Remark

- Maximum Storage Capacity = 10 x Maximum Daily Sale (can be tuned later)
- Replenishment Days: ‘Monday’, ‘Wednesday’, ‘Friday’, ‘Sunday’

**2. Method 1**

Demand = Capacity_Max - Inventory_Day_n-1 (09:00 pm)

**3. Run Simulation by Day**

Sales Transactions, Inventory Replenishment, Inventory ≥0

Simulation Results

- Capacity = 10 x Maximum Daily Sales
- Replenishment Days: ‘Monday’, ‘Wednesday’, ‘Friday’, ‘Sunday’

Number of Replenishment Skipped: 0

## IV. Conclusion and next steps

1. Conclusion

Method 1 is simple and can be optimized. As expected, we have average storage utilization close to 100% and 0 replenishment days skipped.

The average replenishment quantity graph is also showing us that sales transactions trends are periodic and follow a trend.

### 2. Next steps

target the lowest inventory level ensuring no inventory shortage incidents**Inventory level:**using our forecasting model to reduce replenishment**Order Frequency:**

## References

[1] Store Item Demand Forecasting Challenge (Kaggle), Link

[2] Samir Saci, Machine Learning for Retail Demand Forecasting