Inventory Simulator

📊

Click to upload or drag and drop your Excel file here

Accepts .xlsx files with sheets: Calendar · Demand · ProductionRates · OnHand · Arrivals · Cost

Required sheets: Calendar (FY_Quarter, Month) · Demand (BusinessUnit, DemandPriority, Portfolio, Model, Gen, …months) · ProductionRates (Month, FA_L6_UNW, FA_L6_FCZ, FA_L10) · OnHand (SankeyGroup, ProductParent, ProductFamily, Model, Gen, ReturnOH, L6_FGI, L10_FGI, L10_POC_FGI) · Arrivals (Model, Gen, …months) · Cost (CostElement, BusinessUnit, Value)

Use L10-POC-FGI for EG1 (when L10-FGI depleted)

📊 Quarter Summary

📅 Monthly Summary

🔍 Monthly Allocation Trace

📈 Cumulative Trends

📊 Quarterly Overview

🌊 Supply Flow — Sankey Diagram

📆 Annual Summary

📦 Unused Inventory

🎛 Scenario Controls

🔀 Discrete Optimization

Redirect excess Return-OH to build products with unmet supply demand — only available when L6 capacity is not fully utilized

↔️ Push / Pull Optimization

Shift all demand for a BU from one quarter to another by qty or %

🔄 Strategic Demand Shift

Shift demand for a BU+Model from one Gen to another within a time window