In this video, we solve problems and interpret results involving Linear Programming Sensitivity Analysis, based on Excel Solver output, focusing on how changes in various parameters impact optimal production decisions. We explore key questions regarding profit calculations, resource utilization, and the feasibility of introducing new products.
00:00-Introduction
01:12-Q1 a) & b)-Finding Optimal Solution, Reduced Cost
02:11-Q1 c), d) & e)-Finding RHS, Shadow Price, Final Value
03:48-Q2&3-Calculating the Objective Function Value, Z
04:34-Q4&5-Calculating Slack & Surplus (Amount Unused & Excess)
05:39-Q6-Impact of changing an objective function coefficient
06:39-Q7&8-Impact of Changing constraint RHS
08:38-Q10-Should you accept the offer?
09:16-Q11-How much should you charge for resources
09:54-Q12-Interpreting & Calculating Reduced Cost
11:50-Q13-Introducing a new Product
