Scenario Manager Analysis Set up Scenario Manager and create a Scenario Summary sheet. Your uncle wants to look at the following four possibilities: Retire now, staying in the club ("Loaf-In") Retire now, leaving the club ("Loaf-Out) . Work three more years (that is, do not take any buyout bonuses), staying in the club ("Delay-In") .Work three more years, leaving the club ("Delay-Out") should be the Year 3 End-of-year cash on hand cel in the Summary of Key Results section at your Scenario Summary sheet to see which strategy yields the highest amount sheet appropriately; for example, see Figure C-26 You should enter the noncontiguous input cell ranges as follows: C10:E10, C11. The only output cell Your uncle will choose the option that yields the highest Year 3 End-of-year cash on hand. You must look To check your work, you should attain the values shown in Figure C-26. You should format the Summary Scenario Summary LoafIn Loaf Out Delay In 5 Retired or Working, Year 1 SC$10 6 Retired or Working, Year 2 SDS10 7Retired or Working, Year 3 SES10 8 Stay in Club? 9 Result Cells: 10 End-of year cash, Year 3 SES14 $23,120 SC$11 $58,370 $92,189 $119,489 FIGURE C-26 Scenario Summary Scenario Manager Analysis Set up Scenario Manager and create a Scenario Summary sheet. Your uncle wants to look at the following four possibilities: Retire now, staying in the club ("Loaf-In") Retire now, leaving the club ("Loaf-Out) . Work three more years (that is, do not take any buyout bonuses), staying in the club ("Delay-In") .Work three more years, leaving the club ("Delay-Out") should be the Year 3 End-of-year cash on hand cel in the Summary of Key Results section at your Scenario Summary sheet to see which strategy yields the highest amount sheet appropriately; for example, see Figure C-26 You should enter the noncontiguous input cell ranges as follows: C10:E10, C11. The only output cell Your uncle will choose the option that yields the highest Year 3 End-of-year cash on hand. You must look To check your work, you should attain the values shown in Figure C-26. You should format the Summary Scenario Summary LoafIn Loaf Out Delay In 5 Retired or Working, Year 1 SC$10 6 Retired or Working, Year 2 SDS10 7Retired or Working, Year 3 SES10 8 Stay in Club? 9 Result Cells: 10 End-of year cash, Year 3 SES14 $23,120 SC$11 $58,370 $92,189 $119,489 FIGURE C-26 Scenario Summary