Optimization in Excel
Decision Modeling · Tirthal Kothari
Production planning under capacity and demand constraints, with sensitivity analysis to support decisions.
The challenge
The M&D Chemicals coursework case called for minimizing production cost while meeting demand and capacity constraints.
What I did
I formulated the LP model in Excel Solver, defining decision variables, constraints, and the objective. I then interpreted the sensitivity report and ran what-if scenarios on cost and capacity.
The deliverable
An optimized production plan for the coursework case, supported by sensitivity analysis and cost/capacity scenarios.
Tools & methods
- Excel Solver
- Linear Programming
- Sensitivity Analysis
Project context
Decision-modeling coursework. Deliverable: constrained production models in Excel Solver, sensitivity analysis, and cost/capacity scenarios.