Inventory Allocation Model
Scenario Names
Scenarios
Vendor Inputs
Vendor Fill Rate Avg (%)
Vendor Fill Rate Std Dev (%)
Average Inbound Lead Time (wkly)
Std Dev of Inbound Lead Time
Review Periods (weeks)
Inventory Carrying Cost (%)
Purchase Cost (per Unit) $
Warehouse Inputs
Cross Dock (No Buffering)
TRUE
FALSE
TRUE
FALSE
TRUE
FALSE
TRUE
FALSE
TRUE
FALSE
Warehousesing (Create Buffers)
TRUE
FALSE
TRUE
FALSE
TRUE
FALSE
TRUE
FALSE
TRUE
FALSE
Store Inputs
Avg Wkly Demand
Std Dev of Demand
Desired Cycle Service Level (%)
Sale Price $
% of Out of stocks Resulting in Lost Sales
Outputs- If Store Buffers Supplier Performance
Average Cycle Stock ($)
Average Safety Stock ($)
Average Inventory buffer Supplier ($)
Approximate Fill Rate
Expected Lost Profit Buffer Supplier ($)
Outputs- If Store Doesn't Buffer Supplier Performance
Average Cycle Stock ($)
Average Safety Stock ($)
Average Inventory Don't Buffer Supplier ($)
Approximate Fill Rate
Expected Lost Profit Supplier ($)
Average Inventory Buffer Supplier ($)
Average Inventory Don't Supplier ($)
Expected Lost Profit Buffer Supplier ($)
Expected Lost Profit Supplier ($)
