Modeling & Simulation Coursework · Team Model · Data & Algorithms
Restu Mande Inventory Model
Modeling ingredient orders under inventory and capacity constraints.
Background
An inventory-modeling assignment asking when to order ingredients and how much to buy while balancing ordering and holding costs.
Key Decisions
Model Inventory Constraints Explicitly
Use an integer linear program with inventory and capacity constraints, under constant-demand and fixed-lead-time assumptions.
Results
An ordering model with recommendations under constant demand and fixed lead times. Its use depends on those assumptions holding.
Contribution
Our team formulated an integer linear program and solved it in Excel under inventory and capacity constraints.