8.2 Airline Revenue Management: An Introduction to Linear Optimization | 8.2 Airline Revenue Management: An Introduction to Linear Optimization | 8 Linear Optimization | The Analytics Edge | Sloan School of Management

<Video 4: Solving the Problem
8.2.1Video 1: Introduction
8.2.2Video 2: A Single Flight
8.2.3Quick Question
8.2.4Video 3: The Problem Formulation
8.2.5Quick Question
8.2.6Video 4: Solving the Problem
8.2.7Quick Question
8.2.8Video 5: Visualizing the Problem
8.2.9Quick Question
8.2.10Video 6: Sensitivity Analysis
8.2.11Quick Question
8.2.12Video 7: Connecting Flights
8.2.13Quick Question
8.2.14Video 8: The Edge of Revenue Management
>Video 5: Visualizing the Problem

Quick Question

In the previous video, we solved our optimization problem in LibreOffice. In your spreadsheet, change the demand for regular seats to 50 (cell D5). Then re-solve the model.

What is the new optimal objective value?

Now change the demand of regular seats to 200. What is the new optimal objective value?

Explanation

For each of these questions, change the value in cell D5 to the new demand. Then select "Solver..." in the "Tools" menu, and hit solve. The problem should re-solve, and the new objective value is in the Objective cell (B8).