# 12. Calculate Model Outputs

Overview

In this lesson, we complete the model-building process by calculating the outputs in our control panel.

Summary

1. Setting up the Workbook (00:04)

Before we perform the final calculations in our dataset, we make a few changes and additions to the workbook. In our data set, we freeze panes, using the shortcut Alt W, F, F, in order to ensure the first four columns are always visible as we scroll through the data set. We also add several new columns, representing the final values we need to calculate.

2. Calculating Values (01:06)

We calculate the following additional values for each flight in our data set:

• Total additional revenue: This is the number of extra bookings multiplied by the price per ticket.
• Total additional cost from low cost bumped passengers: This is the number of low cost bumped passengers multiplied by the cost of bumping a low cost passenger.
• Total additional cost from high cost bumped passengers: This is the number of high cost bumped passengers multiplied by the cost of bumping a high cost passenger.
3. Adding Outputs to the Control Panel (02:07)

On the control panel, we want to calculate the total additional revenue, total additional cost, and total additional profit for the whole dataset. We calculate these by taking the sum of the relevant columns we created in the dataset. This completes our model. We can adjust the input cells, and immediately see the impact on the total additional profit for our data set.

Transcript

Contents

02:54

03:06

03:56

02:29

03:11

04:59

04:02

02:31

05:56

05:33

04:13

03:23

05:33

04:40

04:44

06:51

03:33

#### 18. Limitations of the Model

02:03

My Notes

You can take notes as you view lessons.

Sign in or start a free trial to avail of this feature.