Define and display alternative data sets

Open the CreateScenarios workbook in Excel, and then perform the following tasks:

Create a scenario named Overnight that changes the Base Rate value for

Overnight and Priority Overnight packages $($in cells C$6$ and C$7)$ to $$18\mathrm{.}75$

and $$25\mathrm{.}50.$

Apply the Overnight scenario and note its effects on the data.

Press $C$ trl $+Z$ to revert to the original data.

Create a scenario named HighVolume that increases the number of Ground

packages to $17,000,000$ and $3-$Day packages to $14,000,000.$

Create a scenario named NewRates that increases the Ground rate to $$9\mathrm{.}45$

and the $3-$Day rate to $$12.$

Create a scenario summary worksheet that displays the effects of the

three scenarios.

Apply the HighVolume scenario and note its effects on the data.

Apply the NewRates scenario and note the additional changes.