- Talk about business opportunity
- History and Comparison
- Consumer and Customer Analytics
- Replenishment: Replenishment Execution System:
- Order Point
- Order Upton Point
- Defining these two points is the key.
- Unknowns and Parameters –> Optimizations
Terms
- Lead time – Time between ordering and getting items avail for sale.
- Order to pickup +
- Pickup to location +
- Warehouse to location
- ROQ – Recommended Order Quantity
- Inventory selling days – No of days of supply desired when replenishment is made.
- Service level: % of customer demand that’s satisfied by by an item being in-stock and available for purchase.
- Lost sales factor: % of lost sales to be included when generating dynamic replenishment recommended order quantities.
- Exempt from Scaling Indicator: check if SKU/location will be eligible for vendor constraint scaling.
- Activate and deactivate date: date on which SKU/location will be active.
- Allowable Order change tolerances: set restriction on amount that POs can be changed on replenishment orders.
Document Provided Summary
Replenishment Attributes
- Review Cycle
- Stock Category
- Primary Replenishment Supplier/ Origin Country
- Replenishment Order Control
- Sourcing Warehouse
- Replenishment Method
- Activate Date
- Deactivate Date
- Presentation Stock
- Demo Stock
- Pickup to Location Lead Time
- Warehouse to Location Lead Time
- Order Change Tolerance percentages
Specific to Replenishment Method:
- Minimum Stock
- Maximum Stock
- Increment Percent
- Minimum Time Supply Days
- Maximum Time Supply Days
- Time Supply Horizon
- Inventory Selling Days
- Service Level
- Lost Sales Factor
- Terminal Stock Quantity
- Season ID and Phase ID
- Exempt from Scaling Indicator and Maximum Scaling Amount
Stock Category:
- Direct to store
- Cross Docked: supplier –> warehouse –> store
- Warehouse stocked: supplier –> warehouse(stocked) –> store
- Warehouse stocked (Store): So, need to take care of warehouses on replenishment in such cases.
Order Control:
- whether to create purchase orders(supplier replenishment) and transfers(warehouse to store replenishment) during replenishment and in what status should they be created ?
- Manual : runs, gives predictions but users test it to have confidence in it to trust the fully automatic process later on.
- Semi automatic: both PO and Transfer will be created. Users need to approve them.
- Automatic: PO created in Approved status, transfers created with approved status with freight code of Normal.
- TODO
Primary Replenishment Supplier and Origin Country
- For same SKU can choose different suppliers/countries.
Review Cycle
- Can be set to multiple times per week, once every 2 weeks and so on.
Replenishment Methods:
- Out of Nine : six are stock oriented methods(one that focus control of on-hand inventory levels without consideration of service level objectives)
-
Stock Oriented Methods:
- Constant : Order placed if inventory below a max stock level. This strategy
does not consider demand trends, future forecasts, or seasonality. However,
it is effective for very slow to slow selling items, or items that are
typically bought in multiples.
- Optional param:
- Increment percent: if user thinks there will be increase or decrease in sales.
- Optional param:
- Min Max Type:
- If falls below Minimum Stock Level [ Order Point ]
- [ Order upto point ] Max stock level
- Effective for slow selling items as well
- Floating Point:
- Order upto point calc using historical data
- Basic trend
- Service levels considered as well.
- Time Supply Forecasting
-
Based on desired days of supply of inventory to be kept.
-
Params:
- max time supply
- min time supply
- time supply horizon
all are in days.
-
- Other methods: Page 19-go on.
- Constant : Order placed if inventory below a max stock level. This strategy
does not consider demand trends, future forecasts, or seasonality. However,
it is effective for very slow to slow selling items, or items that are
typically bought in multiples.
Service level
- Upto 92% inventory investment required is linear.
- After 92% level of inventory increases rapidly. i.e. from 92 to 99 might need to double the investment.
- Rule set for items:
Category Characteristics Service Level Target Sales A Always in stock 98% 50% B Margin 95% 30% C Slow sellers 92% 15% D Very slow 85% 5% E Clearance 70% 0%
Inventory Selling Days
If item has 30 days as ISD; it equals an objective of 12 turns/year. Large Inventory Selling Days values cause larger than desired order levels and thus negatively impact the inventory turn objectives.
Replenishment Calculations
Code Base:
-
Minimum type 1 service level: Max of (service_level, 1 - (1/ord_period)
-
Valid service level: A service level less than minimum can’t be valid given the parameters. Here min_sl = lead_time /avg_ord_period is taken. Then max of min_sl and user defined sl is taken. Note: Lead time here is in weeks.
-
Order Point(Minimum):
- First get valid_sl
- lead_time_sl = 1 + avg_service_period * (-1 + valid_sl)
- Takes lead_time_distribution
- lead_sl passed to lead_time_distribution is the order point.
-
Fill Rate: It’s type II service level.
-
Parameters: lead_dist: Demand distribution during the lead time r: Order Point for the some service level Q: Expected demand during the lead time
fill_rate = 1 - (1 / Q) * getBOOpt(lead_dist, r, Q)
-
-
Inventory Position: r: Order Point Q: Expected Demand during the lead time
ip = (r+r+Q) / 2