Tip: The Demantra Local Application replaces Collaborator Workbench. You may see both names in this text.
This appendix covers the following topics:
The following table displays the Levels used by the Consumption-Driven Planning module:
| Category | Level | Parent Level | CDP Only |
|---|---|---|---|
| Product | Item | Item Description | No |
| Product | Item | Product Category | No |
| Product | Item | Product Family | No |
| Location | Site | Account | No |
| Location | Site | Site Type | Yes |
| Location | Account | Customer | No |
| Location | Account | Account Type | Yes |
| Location | Organization | - | No |
| Location | Site | Site Group | Yes |
| Time | Date | Week | No |
| Time | Date | Month | No |
| Time | Date | Year | No |
| General Level | CDP (Item - Org_DC Site_Store Site) | Store | Yes |
| General Level | CDP (Item - Org_DC Site_Store Site) | Store Group | Yes |
| General Level | Launch Management | Launch Mode | Yes |
| General Level | Launch Management | Launch Copy Data | Yes |
| General Level | Launch Management | Launch Status | Yes |
| General Level | Launch Management | Launch Type | Yes |
The following table displays the Series used by the Consumption-Driven Planning module:
| Series Name | Description |
|---|---|
| Account Type | Account Type (Shipment/Consumption). |
| Adjusted History | Final Historical Shipment data including adjustments. Traditionally the Series used to drive the Demand Management process. |
| Available Inventory | Available inventory based on in transit, on hand, and on order. For future buckets, this Series also considers inventory available after meeting the forecast requirements from the previous bucket. |
| Avg Item Site ID | Used in Receipt Requirement, Sell in Forecast, Projected Weeks of Supply, and Target Inventory Weeks of Supply Series. Client expression to prevent system evaluating client expression at aggregation other than the Item, Site, Org and Week. This is an internal Series that supports calculations. |
| Avg Item Store ID | Used in Store Receipt Requirement, Store Target Inventory Days of Supply, Store Sell in Forecast, Final Safety Stock, Store Receipts, and Suggested Replenishment Order Series. Client expression to prevent system evaluating client expression at level other than the Item, Store, and Day level. This is an internal Series that supports calculations. |
| Base Override | Override Series used to adjust Sell in Forecast. |
| Beginning Inventory | Beginning on-hand inventory at the selected location for the current period and target inventory days of supply. |
| Beginning Inventory Load | Current inventory at the location. |
| Consensus Forecast | One-number forecast derived from Demand Review (history and forecast), representing the aggregate of items multiplied by unit prices. This Series is read-only. |
| Date Count | Used in Receipt Requirement, Sell in Forecast, Projected Weeks of Supply, and Target Inventory Weeks of Supply Series. Client expression to prevent system evaluating client expression at aggregation other than the Item, Site, Org and Week. This is an internal Series that supports calculations. |
| Ending Inventory | Ending on-hand inventory at the location. |
| Final Forecast | Final Demantra Forecast. |
| Final Replenishment Order | Final replenishment order including any end-user adjustments and suggested orders. |
| Final Safety Stock | Final safety stock based on safety stock calculation method and any end-user adjustments. |
| Final Safety Stock BLE | Safety stock calculated based on the selected Safety Stock method option and the Safety Stock Override. Used in the BLE Worksheet. Has same Update Field as "Final Safety Stock" Series. |
| Fixed Percent | Fixed Percent. |
| GL Date Count | Used in Store Receipt Requirement, Store Target Inventory Days of Supply, Store Sell in Forecast, Final Safety Stock, Store Receipts, and Suggested Replenishment Order Series. Client expression to prevent system evaluating client expression at level other than the Item, Store, and Day level. This is an internal Series that supports calculations. |
| History | Shipment History. |
| In Transit | Quantity that has been shipped but has yet to arrive at final destination (imported value). |
| Inventory Max | The maximum suggested inventory level at the store (imported value). |
| Inventory Min | The minimum suggested inventory level at the store (imported value). |
| Inventory Objective | The expected on-hand inventory level. Sum of Final Safety Stock and Store Sell through Final Forecast. |
| Lead Time | Lead time to ship from manufacturer's distribution center to retailer distribution center/store. |
| List Price | Price list loaded from EBS. Uses Unit of Measure (UOM). |
| Mean Absolute Pct Err | Engine MAPE. |
| Min GL Item ID | Used in Store Receipt Requirement, Store Target Inventory Days of Supply, Store Sell in Forecast, Final Safety Stock, Store Receipts, and Suggested Replenishment Order Series. Client expression to prevent system evaluating client expression at level other than the Item, Store, and Day level. This is an internal Series that supports calculations. |
| Min Item ID | Used in Receipt Requirement, Sell in Forecast, Projected Weeks of Supply, and Target Inventory Weeks of Supply Series. Client expression to prevent system evaluating client expression at aggregation other than the Item, Site, Org, and Week. This is an internal Series that supports calculations. |
| Min Site ID | Used in Receipt Requirement, Sell in Forecast, Projected Weeks of Supply, and Target Inventory Weeks of Supply Series. Client expression to prevent system evaluating client expression at aggregation other than the Item, Site, Org, and Week. This is an internal Series that supports calculations. |
| Min Stored ID | Used in Store Receipt Requirement, Store Target Inventory Days of Supply, Store Sell in Forecast, Final Safety Stock, Store Receipts, and Suggested Replenishment Order Series. Client expression to prevent system evaluating client expression at level other than the Item, Store, and Day level. This is an internal Series that supports calculations. |
| On Order | Quantity that has been ordered but has yet to arrive at final destination (imported value). |
| Order Approval | Approval flag to approve the order. |
| Projected Inventory Beginning On Hand | Beginning Inventory + Receipt Requirement. |
| Projected Weeks of Supply | Projected Weeks of Supply calculated based on Projected Inventory Beginning On Hand and Sell in Forecast. |
| Receipt Requirement | Shipments required at the store based on Sell through Forecast. |
| Replenishment Order Override | Override Series used to adjust Replenishment Order. |
| Required Inventory | If Inventory objective is equal or below minimum, then this is set to minimum. If inventory objective is equal or above maximum, then this is set to maximum. Otherwise, it is set to the same value as the Inventory Objective Series. |
| Returns | Returns to the manufacturer. |
| Safety Stock Choice | Safety stock method used to calculate safety stock. The following options are available: Statistical/By Lead Time/Time Periods/Fixed Percentage. |
| Safety Stock Override | Override Series used to adjust Safety Stock. |
| Sell in Final Forecast | Final Sell in Forecast including end-user adjustments. |
| Sell in Final Forecast Value | Sell in Forecast value. |
| Sell in Forecast | Shipment forecast for the manufacturer by offsetting the Receipt Requirement based on Lead Time. Used in the BLE Worksheet. Has same update field as "Sell in Forecast" Series. |
| Sell in Forecast BLE | Shipment forecast for the manufacturer by offsetting the Receipt Requirement based on lead time. Used in the BLE Worksheet. Has same update field as "Sell in Forecast" Series. |
| Sell through Adjusted History | Sell through History including any end-user adjustments. |
| Sell through Final Forecast | Final Sell-through forecast including any end-user adjustments. |
| Sell through Forecast | Statistical Forecast generated based on Sell through Adjusted History. |
| Sell through Forecast Override | Override Series used to adjust Sell through Forecast. |
| Sell through Forecast Simulation | Simulation Series for Sell through Forecast. |
| Sell through History | Consumption history (or) DC withdrawals. |
| Sell through History Override | Override Series used to adjust Sell through History. |
| Service Level | Desired service level, displayed as a percentage. Also used when calculating safety stock. |
| SS Days of Supply | Safety Stock Days of Supply. One of the available methods used to calculate Safety Stock. |
| SS Fixed Percent | Safety Stock Fixed Percent. One of the available methods used to calculate Safety Stock. |
| SS Statistical | Safety Stock Statistical. One of the available methods used to calculate Safety Stock. |
| Standard Error | Series containing the Standard Error between Store Sell through Final Forecast Lag 4 and Sell through History. Calculated by the workflow Standard Error Calculation Item Store. |
| Standard Error Item Org | Calculated Standard Error at the Item/Org level. |
| Store Beginning Inventory | Store Beginning on-hand inventory at the location for the current period and target inventory days of supply. |
| Store Beginning Inventory Load | Current Inventory at the location. |
| Store Ending Inventory | Store Ending on-hand inventory at the selected location. |
| Store Inventory Exception | Store High Inventory Exception. Exception generated when Store Inventory is greater than Inventory Maximum Constraint. |
| Store Lead Time | The lead time associated with shipments to the store (imported value). |
| Store Receipt Requirement | Store Shipments required at the store based on Sell through Forecast. |
| Store Receipts | Order calculated based on difference between Projected Inventory and Available Inventory. Has the same update field as "Suggested Replenishment Order" Series. |
| Store Sell in Final Forecast | Final Store Sell in Forecast including any end-user adjustments. |
| Store Sell in Forecast | Store shipment forecast for the manufacturer by offsetting the Store Receipt Requirement based on lead time. |
| Store Sell in Forecast Override | Override Series used to adjust Store Sell in Forecast. |
| Store Sell in Forecast Total | Store shipment forecast for the manufacturer by offsetting the Store Receipt Requirement based on lead time |
| Store Sell through Adjusted History | Sell-through history at store level including any end-user adjustments. Reflects the value specified in the CDP Sell in Forecast Item⁄Store worksheet. |
| Store Sell through Final Forecast | Final store sell-through forecast including any end-user adjustments. Also used when calculating safety stock. |
| Store Sell through Final Forecast Lag 1 | Store sell-through forecast as of 1 week ago. |
| Store Sell through Final Forecast Lag 2 | Store sell-through forecast as of 2 weeks ago. |
| Store Sell through Final Forecast Lag 3 | Store sell-through forecast as of 3 weeks ago. |
| Store Sell through Final Forecast Lag 4 | Store sell-through forecast as of 4 weeks ago. |
| Store Sell through Forecast | Shipment forecast calculated based on the sell-through forecast at the store level. |
| Store Sell through Forecast Lag 1 | Lag Sell through Forecast as of 1 week ago. |
| Store Sell through Forecast Lag 2 | Lag Sell through Forecast as of 2 weeks ago. |
| Store Sell through Forecast Lag 3 | Lag Sell through Forecast as of 3 weeks ago. |
| Store Sell through Forecast Lag 4 | Lag Sell through Forecast as of 4 weeks ago. |
| Store Sell through Forecast Override | Override Series used to adjust Store Sell through Forecast. |
| Store Sell through Forecast Simulation | Simulated Store Sell through Forecast. |
| Store Sell through History | Store consumption history (or) Distribution Center withdrawals. |
| Store Sell through History Override | Override Series used to adjust Store Sell through History. |
| Store Target Days of Supply Final | Final target days of supply at store including any end-user adjustments and days of supply. |
| Store Target Days of Supply Load | Store Target days of supply loaded value. |
| Store Target Days of Supply Override | Override Series used to adjust Store Target Days of Supply. |
| Store Target Inventory Days of Supply | Store Target inventory value based on days of supply. |
| Suggested Replenishment Order | Store receipts offset by lead time. |
| Suggested Replenishment Order BLE | Order calculated based on difference between Projected Inventory and Available Inventory. Used in the BLE Worksheet. Has same update field as "Suggested Replenishment Order" Series. |
| Target Inventory Weeks of Supply | Target inventory value based on weeks of supply |
| Target Weeks of Supply Final | Target Weeks of Supply including end-user adjustments. |
| Target Weeks of Supply Load | Target Weeks of Supply loaded from external system. |
| Target Weeks of Supply Override | Override Series used to adjust Target Weeks of Supply. |