In the following, you will find a detailed reference to the cubes and fields of optimised inventory or Inventory Opt, optimised explosion of materials Explosion Opt or optimised MRP MRP Opt; in order to facilitate the users' interpretation and use in the continuous improvement of the production and operations processes, in terms of efficiency and automation.
Optimised Inventory QInventoryOpt: Description and Structure
Consolidates portfolio items related to finished products. The cubes include the identification and characterisation fields of the references, inventory stock, in transit, historical and forecast demand. Additionally, it estimates and updates with each change of information the indicators of an optimised inventory: availability, safety inventory, reorder point, days of inventory and inventory turnover.
| Column | Column | Description | Parameters |
|---|---|---|---|
|
Item |
Item |
Identification code of the items or references that make up the portfolio. |
|
|
Description |
Description |
Description of items or references facilitating their identification |
|
|
CeDi |
CeDi |
Identification of distribution centre or item location |
|
|
Location |
Channel |
Identification of location, e.g. channel, point of sale, etc. |
|
|
Inventory |
Inventory |
Number of stocks in the inventories of all warehouses |
|
|
StockoutDateInv |
Break Date Inventory |
Inventory break date taking into account inventory, safety stock and average daily consumption of the product. |
Today() + (Inventory-SafetyStock)/AvgDailyUsage |
|
StockoutDaysInv |
Days Breakage Inventory |
Days for stock-outs taking into account inventory, safety stock and average daily consumption of the product. |
StockoutDateInv/AvgDailyUsage |
|
InTransit |
Transit |
Quantities in transit for the following month |
|
|
Availability |
Availability |
Available quantity of the item in units considering stock on hand and orders in transit |
Inventory+InTransit |
|
StockoutDateAvail |
Date Break Dispo |
Stock out date taking into account current availability, safety stock and average daily consumption of the product. |
Today() + (Availability-SafetyStock)/AvgDailyUsage |
|
StockoutDaysAvail |
Days Breakage Dispo |
Days for stock-outs taking into account current availability, safety stock and average daily consumption of the product. |
StockoutDateAvail/AvgDailyUsage |
|
InTransitOther |
Transits Other |
Quantities in transit for all the following periods |
|
|
StockoutDateOther |
Date Break Other |
Stock out date taking into account availability with total transits, safety stock and average daily consumption of the product. |
Today() + (Inventory+InTransitOther-SafetyStock)/AvgDailyUsage |
|
StockoutDaysOther |
Days Break Other |
Days for stock-outs taking into account total availability, safety stock and average daily consumption of the product. |
StockoutDateOther/AvgDailyUsage |
|
ItemLocationShare |
Percentage Item Channel |
Percentage share of item in the channel |
|
|
DemandHistory |
Demand |
Amount of historical demand in the previous period |
|
|
ForecastCollab |
Colab Forecast |
Defined forecast value estimated by the model or adjusted in S&OP for the next period. |
|
|
SuggestedAvailability |
Suggested Availability |
Suggested available quantity of the item in units, considering stock on hand, upcoming orders in transit and forecast demand. |
|
|
SuggestedStockoutDate |
Suggested Break Date |
Forecasted date for stock-outs taking into account current availability, demand forecast, safety stock and average daily consumption of the product. |
Today() + (SuggestedAvailability-SafetyStock)/AvgDailyUsage |
|
SuggestedStockoutDays |
Suggested Break Date Days |
Forecasted days for stock-outs taking into account current availability, forecast demand, safety stock and average daily product consumption |
SuggestedStockoutDate/AvgDailyUsage |
|
AvgDailyUsage |
Average Daily Use |
Average number of units ordered daily four months backward from the present date |
|
|
AvgLeadTime |
Average Leadtime |
Average time period from the time an order is generated from a supplier to the time it is delivered to the customer. |
|
|
LeadTimeDemand |
Leadtime Demand |
The demand that will occur during the period of time in which a product has been ordered and is available in the warehouse. |
AvgLeadTime*AvgDailyUsage |
|
SafetyStock |
Stock Seg |
Suggested number of units for safety stock, considering sales and leadtimes four months backwards from the present date. |
(MaxDailyUsage*MaxLeadtime)-(AvgDailyUsage*AvgLeadtime) |
|
SafetyStockDays |
Stock Seg Days |
Number of days for safety stock, considering sales and leadtimes four months backwards from the present date |
((MaxDailyUsage*MaxLeadtime)-(AvgDailyUsage*AvgLeadtime))/30 |
|
SafetyStockRule |
Stock Seg Regla |
Minimum number of units per business rule for the safety stock |
|
|
SafetyStockDiff |
Stock Seg Gap |
Difference between dynamically estimated safety stock and safety stock set by business rule |
SecurityStock-SecurityStockRule |
|
ReorderPoint |
Pto Reorden |
Minimum number of units suggested by a buy-back order |
(AvgLeadTime*AvgDailyUsage)+SecurityStock |
|
ReorderPointDays |
Pto Reorden Days |
Minimum number of days suggested by a buy-back order |
(AvgLeadTime*AvgDailyUsage)/30 + SecurityStockDays |
|
ReorderPointDate |
Date Pto Reorder |
Date when the reorder point is reached |
Today()+(SuggestedPurchase-ReorderPoint)/AvgDailyUsage |
|
SuggestedReorderQty |
Suggested Reorder |
Suggested purchase, considering inventory and transits, demand forecast, commitments and safety stock. If the value is negative, it corresponds to the quantity required for purchase or production. If the value is positive, it corresponds to surplus inventory and does not require purchase or production unless it is below the reorder point. If the value is zero, current availability and requirements are in balance, see reorder point. |
|
|
ReorderStatus |
Reorder State |
Suggested Purchase or Hold action for the item in the quantity set in the SuggestedReorderQty column. |
|
|
MinOrderQty |
Qty Min Purchase |
Minimum purchase quantity |
|
|
PurchaseFactor |
Multiple Purchase |
Purchase multiple |
|
|
StockoutLifeCycle |
Expiry date |
Expiry date of the product |
|
|
TotalSalesExpired |
Total Sales Expired |
Total equivalent sales of the expired item |
|
|
StockoutDateInRow |
Date Sold out |
Initial sell-out date |
|
|
StockoutDaysInRow |
Days Sold out |
Consecutive days out of stock |
|
|
StockoutQty |
Qty Out of stock |
Quantity in units of out of stock |
|
|
UnitPrice |
Unit Price |
Item unit price |
|
|
TotalSales |
Total Sales |
Total sales for the last month |
|
|
SellType |
Type Sale |
Type of sale sellin: channels, shops, NFCGC channels, NFCGC shops and production |
|
Optimised Materials Explosion QExplosionOpt: Description and Structure
It gathers the references of the sales and production portfolio related to the material explosion. The cube includes the identification and characterisation fields of the references of finished and dependent products. As well as the quantities required, considering current inventory stocks and demand forecasts.
| Column | Column | Description | Parameters |
|---|---|---|---|
|
ItemParent |
Item Father |
Identification code of the finished product |
|
|
DescriptionParent |
Description Father |
Description of the finished product facilitating its identification |
|
|
CeDi |
CeDi |
Distribution centre or item location identification |
|
|
Location |
Channel |
Identification of location, e.g. channel, point of sale, etc. |
|
|
Inventory |
Inventory |
Number of stocks in the inventories of all warehouses |
|
|
InTransit |
Transit |
Amount of stocks in transit for the following month |
|
|
ForecastCollabNow |
Colab Forecast |
Demand forecast for the previous or current period, according to the forecast suggested by the model or by S&OP. |
|
|
ForecastCollabNext |
Colab Prox Forecast |
Demand forecast for the next period, according to the forecast suggested by the model or by S&OP. |
|
|
Safety Stock |
Stock Seg |
Suggested number of units for safety stock, considering sales and leadtimes four months backwards from the present date. |
(MaxDailyUsage*MaxLeadtime)-(AvgDailyUsage*AvgLeadtime) |
|
ItemChild |
Item Child |
Identification code of the product in process or raw material |
|
|
DescriptionChild |
Description Son |
Description of the in-process product or raw material that facilitates its identification |
|
|
RequiredQty |
Qty Required |
Required quantity of material for the unit production of the finished product |
|
|
ShippingQty |
Qty Dispatch |
Minimum quantity of purchase or presentation of the material for the production of the finished product or product in process |
|
|
MeasureUnits |
UM |
Characteristic of the finished product, in-process or raw material associated with its unit of measurement. |
|
|
SuggestedRequiredQtyNow |
Qty Prod Suggested Parent |
Suggested quantity to be purchased or produced of the parent item (finished product), based on demand in the previous or current period. |
Inventory+InTransit-DemandHistory-SafetyStock |
|
SuggestedRequiredQtyNext |
Qty Prod Suggested Prox Parent |
Suggested quantity to be purchased or produced of the parent item (finished product), according to the demand of the next period. |
Inventory+InTransit-ForecastCollabNext-SafetyStock |
|
TotalRequiredQtyNow |
Qty Prod Required Material |
Total required quantity of material, considering the forecast of the previous or current period of the parent item, quantity for unit production and dispatch. |
(SuggestedRequiredQtyNow*
RequiredQty)/ShippingQty |
|
TotalRequiredQtyNext |
Qty Prod Required Material Prox |
Total required quantity of material, considering the forecast of the next period of the parent item, quantity for unit production and dispatch. |
(SuggestedRequiredQtyNext*
RequiredQty)/ShippingQty |
MRP Optimised QMrpOpt: Description and Structure
Consolidates the quantities of raw materials and work-in-process required for the purchase and production of finished products. The cube includes the identification and characterisation fields of the material references. As well as the quantities required, considering current inventory stocks and demand forecasts.
| Column | Column | Description | Parameters |
|---|---|---|---|
|
Item |
Material |
Material identification code |
|
|
Description |
Description |
Description of the material facilitating its identification |
|
|
CeDi |
CeDi |
Identification of the distribution centre or location of the material |
|
|
Inventory |
Inventory |
Amount of stock in inventory |
|
|
InTransit |
Transit |
Quantity of stocks in transit to CeDi |
|
|
InTransitOther |
Transit Other |
Number of stocks of total transits to CeDi |
|
|
TotalRequiredQtyNow |
Qty Prod Required Material |
Total required quantity of material, considering the forecast of the previous or current period of the parent item, quantity for unit production and dispatch. |
(SuggestedRequiredQtyNow*
RequiredQty)/ShippingQty |
|
TotalRequiredQtyNext |
Qty Prod Required Material Prox |
Total required quantity of material, considering the forecast of the next period of the parent item, quantity for unit production and dispatch. |
(SuggestedRequiredQtyNext*
RequiredQty)/ShippingQty |
|
MeasureUnits |
UM |
Material characteristic associated with its unit of measurement |
|
|
LeadTime |
LeadTime |
Average time period from the time an order is generated from a supplier to the time it is delivered to the customer. |
|
|
Availability |
Availability |
Available quantity of the material in units considering stock in inventory and orders in transit |
Inventory+InTransit |
|
SuggestedRequiredQty |
Qty Suggested Production |
Total required quantity of material considering current stocks and demand forecasts |
Inventory+InTransit-TotalRequiredQtyNext |