These first two sections were to be filled in per figures 6-1 and 6-2 on page 113. This is just directly entered data (no calculations required at this point with one exception C16, D16 and E16 should reference cells =C25, D25 and E25 for the additional mail campaign for those months for the scenarios to run later):
Formula view of campaign volumes section showing the three cells that use a reference rather than directly input data:
Nothing is required in the inputs until you run the scenarios:
The summary of key results section simply echoes results calculated elsewhere in the sheet (formula view shown here):
The calculations section will be filled in per details provided on pages 114-116 (formula view shown here for most of this section):
And finally we have some grand totals (formula view shown here):
Assignment 2: Scenario Manager
Once you’ve completed the Mohopo Collections worksheet, you will run the scenario summary using scenario manager per details provided on the four scenarios on page 116. Refer to pages 97-101 for a detailed presentation of using scenario manager.