Days on Hand
This is calculated based on the GENERATE_OP_SL_OUTSTOCK_DAYS global setting.
• When the global setting is set to false, the Days On Hand value is calculated by Stock Levels process as
(On Hand New + On Hand Fixed)/ Average Daily Demand Rate)
• When the global setting is set to true, the Days on Hand value is calculated as follows:
◦ For customers using Stock Levels process,
Interactive Plan will still calculate the Days On Hand value as:
(On Hand New + On Hand Fixed)/ Average Daily Demand Rate)
◦ For Time Phased SKUs: Days on Hand is based on when the planned on hand Good goes below zero. It relies on the Planned On Hand Good goes below 0 review reason.
◦ For Trigger SKUs, Days On Hand is calculated as:
(On Hand New + On Hand Fixed)/ Average Daily Demand Rate)
When Forecast is zero, then Days on Hand is displayed as a blank
• Where Average Daily Demand Rate is defined as:
◦ If level source is MEO/SIO (Inventory Optimization) then the Average Daily Demand Rate is equal to IPCS_STOCK_LEVEL.OptDailyDmdRate
◦ If level source is Levels then the Average Daily Demand Rate is equal to IPCS_STOCK_LEVEL.SLDemandPerDay
Appears on these pages