Below, you will find a detailed reference to the cubes and fields of optimised inventory or Inventory Opt and the distribution optimisation or Distribution Opt in order to make it easier for users to interpret and exploit them in the continuous improvement of production and operations processes, in terms of efficiency and automation.

Optimised Inventory Qinvopt: 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
Inventory
Inventory
Number of stocks in the inventories of all warehouses
InTransit
Transit
Quantity of stocks in transit to CeDi
Commited
Committed
Number of items that are set aside for shipment
Location
Country
Identification of location, e.g. channel, point of sale, etc.
AvgLeadTime
Average Leadtime
Average time period from when an order is placed with a supplier to when it is delivered to the customer.
SalesHistory
Sales History
Last month's demand
Suggested Forecast
Suggested Forecast
Number of forecasted orders of the item in units
AvgDailyUsage
Average Daily Use
Average number of units ordered daily one year backwards from present date

(OrdersDay 1 + ... + OrdersDay 120)/120

MaxDailySales
Maximum daily sales value
Maximum number of units ordered daily four months backwards from the present date
MaxLeadTimes
Maximum Leadtime
Maximum value of the time period from when an order is generated from a supplier to when it is delivered to the customer.
Availability
Availability
Available quantity of the item in units considering stock on hand and orders in transit
Inventory+InTransit
SuggestedAvailability
Suggested Availability
Available quantity of the item in units considering the stock in inventory, orders in transit and forecast demand.
Inventory+InTransit-SuggestedForecast
LeadTimeDemand
Leadtime Demand
Average lead time of the item one year backwards from present date
SecurityStock
Stock Seg
Suggested number of units for safety stock, considering sales and leadtimes one year backwards from the present date.
(MaxDailyUsage*MaxLeadtime)-(AvgDailyUsage*AvgLeadtime)
SecurityStockDays
Stock Seg Days
Suggested number of days for safety stock, considering sales and leadtimes one year backwards from the present date.
((MaxDailyUsage*MaxLeadtime)-(AvgDailyUsage*AvgLeadtime))/30
ReordenPoint
Pto Reorden
Minimum number of units suggested by a buy-back order
(AvgDailyUsage*AvgLeadDemand) + SecurityStock
ReorderPointDays
Pto Reorden Days
Minimum number of days suggested by a buy-back order
(AvgDailyUsage*AvgLeadDemand)/30 + SecurityStockDays
SuggestedReorderQty
ReordenSuggested
Suggested purchase taking the next month's forecast, the safety stock of the item and the amount of items to be routed, if the value is negative it is the amount of inventory that would be left in stock, if the value is positive it is the amount that the model suggests needs to be ordered to cope with the next month's demand.
Inventory+InTransit-Committed-SuggestedForecast-SecurityStock
MaxReorderQty
Maximum Suggested Reorder
Suggested purchase taking the NextSuggestedForecast of the next month, the safety stock of the item and the number of items to be routed.
Inventory+InTransit-Committee-NextSuggestedForSecast-SecurityStock
MinReorderQty
Minimum Suggested Reorder
Suggested purchase taking the next month's BackSuggestedForecast, the safety stock of the item and the number of items to be routed.
Inventory+InTransit-Committed-BackSuggestedForecast-SecurityStock
ReorderStatus
Reorder State
Suggested Purchase or Hold action for the item in the quantity set in the SuggestedReorderQty column.
ReorderPointDate
Date of reorder
Date when the reorder point is reached
Today()+(SuggestedPurchase-ReorderPoint)/AvgDailyUsage
StockoutDate
Break Date
Stock out date taking into account current availability, safety stock and average daily consumption of the product.
Today() + (Availability-SafetyStock)/AvgDailyUsage
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

Optimisation of the Qdistopt Distribution: Description and Structure

Consolidates portfolio items related to finished goods. The cubes include fields for identification and characterisation of references, inventory stock locations, determination of priorities for distribution from the main warehouse, quantity to be distributed, quantities pending distribution, and upcoming collection and dispatch dates.

Additionally, it estimates and updates with each change of information the indicators of an optimised inventory: availability, safety inventory, reorder point, inventory days and inventory turnover, the latter as a complement to the information provided by the distribution optimisation.

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
Location
Location
Identification of distribution centre or item location
LocationPriority
Prority Location
Identifies the priority of the warehouse for distribution.
High Priority (1) Low Priority (0)
Forecast
Suggested Forecast
Number of forecasted orders of the item in units
DeliveryLotSize
Qty Delivery
Suggested quantity to be delivered from main warehouse to secondary warehouses
DeliveryLotSizePercent
Pct Delivery
Percentage of distribution according to the priority established in the warehouse.
PendingLotSize
Delivery Pending
Backordered quantity to be delivered from the main warehouse to the outlets
NextPickingDate
Next Picking
Next collection date according to warehouse location
NextDeliverydDate
Next Delivery
Next delivery date according to warehouse location
SecurityStock
Stock Seg
Suggested number of units for safety stock, considering sales and leadtimes one year backwards from the present date.
(MaxDailyUsage*MaxLeadtime)-(AvgDailyUsage*AvgLeadtime)
SecurityStockDays
Stock Seg Days
Suggested number of days for safety stock, considering sales and leadtimes one year backwards from the present date.
((MaxDailyUsage*MaxLeadtime)-(AvgDailyUsage*AvgLeadtime))/30
ReorderPoint
Pto Reorden
Minimum number of units suggested by a buy-back order
(AvgDailyUsage*AvgLeadDemand) + SecurityStock
ReorderPointDays
Pto Reorden Days
Minimum number of days suggested by a buy-back order
(AvgDailyUsage*AvgLeadDemand)/30 + SecurityStockDays
StockoutDate
Break Date
Stock out date taking into account current availability, safety stock and average daily consumption of the product.
Today() + (Availability-SafetyStock)/AvgDailyUsage
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