Скачать или смотреть Advanced Optimization Analysis in Excel | Solver & Blending Oil Product Case Study

#LinearProgramming #SensitivityAnalysis #ExcelSolver #SolverTable #OptimizationModel #BusinessAnalytics #ProductMix #ShadowPrice #ReducedCost #MISLecture #ExcelForBusiness #QuantitativeMethods #OperationsResearch

In this video, we take a deep dive into advanced spreadsheet optimization using Linear Programming (LP) in Excel. Learn how to build and analyze complex models, perform sensitivity analysis, and use tools like Solver and SolverTable to make data-driven decisions.

🔍 Key Topics Covered:

✔ Core Concepts of LP

Decision Variables, Objective Function, and Constraints
Feasible Region, Optimal Solution, and Infeasibility
Proportionality, Additivity, and Divisibility in LP models
✔ Sensitivity Analysis

Using Solver’s Sensitivity Report to analyze:
Objective coefficients
Right-hand side (RHS) constraints
Reduced Costs and Shadow Prices
Understanding allowable increases/decreases and their implications

✔ SolverTable Add-in
Performing what-if analysis on any input variable
Creating two-way data tables to visualize changes in optimal solutions
More flexible and intuitive than Solver’s built-in sensitivity tools

✔ Case Study: Blending Oil Product
📌 Scenario: To develop an optimization model for finding the revenue-maximizing plan that meets quality constraints and stays within limits on crude oil availabilities.

📈 Why Watch?
This video is perfect for business students, analysts, and professionals who want to master real-world optimization techniques and learn how to interpret and act on sensitivity analysis results.

👍 Like, subscribe, and turn on notifications to follow our full series on business analytics, Excel modeling, and decision science!

Reference: Business Analytics
ISBN: 9781305947542
Author: Albright/Winston
Published by: Cengage