Most optimization textbooks start with equations. This book starts with a business problem.
Every chapter drops you into an industry scenario with named stakeholders, quantified pain points, complete data tables, and competing objectives. You solve each problem end-to-end using the same 23-step consulting framework that professional analytics consultants use in the field — from the first client meeting to the deployed model and its measured KPI impact.
Every model is implemented twice: in Excel Solver (for intuition and accessibility) and in Python (PuLP, OR-Tools, Pyomo — for scalability and production deployment). Every solution includes sensitivity analysis, deployment guidance, and a pitfall register drawn from real consulting experience.
Each case includes: complete data tables, mathematical formulation, Excel + Python code, sensitivity analysis, deployment plan, and pitfall register.