Please create a table (using the data in the scenario summary table) that highlights the tradeoffs between fixed and variable cost (cost structure). You will need to use the passanger combinations of scenario two and three. You do not need to create a pivot table or a data table, just a simple table on Excel that illustrates the tradeoffs.

Insert Page Layout Formulas Data Review View Arial . Arial em insert As .. Wrap Text General Merge & Center, S. % , o Cordt onal Format Cea formatting s Table Styles Format Cument Value Oigina BE Oniginal Scenarie Two Scenarie Thrse BE Scenario BE Scenario 4000 Scenarie 2000 Scenanio 4000 Scenar 2000 Scenanio Sicenario One Changing Cels 45 1,440 45 2.000 Variable Rat 45 1.5 1440 2500 1440 2.867 4,000 Fixed Cost 15.00 Result Cels 2960 12960 2o0 932019320 22500 22500 0 12960 20000 24000 22160 2000024000 28000 24000 0001000 230001952 8000700 1000 Notes Cument Values oolume represents values of changing cels a tme Scenato Summary Report was created Changing cels for each scenaro are highighted in gray 15 25 26 27 30 32 36 Scenario SummarySheets Sheet+