Demand Miss Analysis
The Demand Miss Analysis dashboard is a tool to analyze the unfulfilled demand (missed quantity) due to the unavailability of stock. Use this dashboard to analyze the following:
• The time-phased Demand Miss trend along with root cause categories
• The SKUs that contribute the most to Demand Miss
• The quantity of Demand Miss
For example:
◦ 2 Demands (lines) of 5 Units (qty) in a day (Demand Requested (qty) = 10)
◦ Inventory = 7 units
◦ Units Filled (qty) = 7
◦ Demand Miss (qty) =3
• Categorical distribution of Demand Miss across the system
• The Planner Codes that have the most Demand Miss
 |
Things to remember when using this dashboard:
• Only Active SKUs are considered
• The Demand Missed is calculated for external demand only, it is not the total demand, which includes internal demand and external demand
• External demand is identified for non bin locations using the External Forecast streams with demand streams that have the Use In Total field set to Y
• The Fill Rate Calculation is a day-by-day calculation. The remaining On Hand or Unfullfilled Demand (missed demand) is not carried forward to the next day.
• The Past Due Unfulfilled Demand (missed demand) is not considered in the Fill Rate calculation for today. If Backorders are also present together with On Hand in Stock Amount, then the Backorder quantity is subtracted from the On Hand quantity (refer to Fill Rate Calculation for details).
• The smallest Demand Detail quantity is fulfilled first to calculate the Lines Filled.
• A waterfall process is used to determine the Planner Code assigned to each SKU. If a Planner Code assignment exists at the SKU level, that Planner Code is used. If there is no Planner Code assigned at the SKU level, the Planner Code assigned at the Part level is used.
• If a first-time demand has no corresponding On Hand record, it is categorized as First Time Demand in Demand Miss Analysis and SKU Supply Chain History once the demand is available in Demand History.
• A waterfall process is used to determine the Planner Code assigned to each SKU. If a Planner Code assignment exists at the SKU level, that Planner Code is used. If there is no Planner Code assigned at the SKU level, the Planner Code assigned at the Part level is used.
The following filters are available on this dashboard:
• TMR
|
|
|
This dashboard can be filtered using the Days of Excess Supply filter.
|
The following hyperlinks are available on the Demand Miss Analysis dashboard:
|
Widget
|
Description
|
|---|---|
|
By Demand Miss
|
Click a bar on the graph and select Hyperlink to open the SKU Supply Chain History dashboard, populated with the details for the selected SKU.
|
|
SKU with Highest Demand Missed
|
Click a bar on the graph and select Hyperlink to open the SKU Supply Chain History dashboard, populated with the details for the selected SKU.
|
|
By Category
|
The percentage of Demand Missed by Root Cause Category.
|
|
By Planner Code
|
The percentage of Demand Missed by Planner Code.
|