Formulas Data Review View Help Tell me what you want to do Calibri - 111 Paste X Cut Copy Format Painter Clipboard ' ' S.A. Wrap Text BIU General Merge & Center - $ - % Font 00 Alignment A22 Number B D E F G H 1 Caribbean Caf Sensitivity Analysis 2 3 Given Segment/Market Site is 20,000 Calculate Year 1 and Year 2 Total Contribution Margin and Net Profit/(Loss) 4 in the following scenarios 5 6 Scenario 1 7 Percentage of Market that visits caf 30% 8 Average number of visits per customer per year 3 9 10 11 Scenario 2 12 Percentage of Market that visits caf 70% 13 Average number of visits per customer per year 2 14 15 16 Scenario 3 17 Percentage of Market that visits cat 50% 18 Average number of visits per customer per year 19 20 Hint 21 You will need to calculate Foxed costs for year 1 and 2 22 23 24 25 26 30 32 34 35 36 Sheets Esc Formulas Data Review View Help Tell me what you want to do Calibri - 111 Paste X Cut Copy Format Painter Clipboard ' ' S.A. Wrap Text BIU General Merge & Center - $ - % Font 00 Alignment A22 Number B D E F G H 1 Caribbean Caf Sensitivity Analysis 2 3 Given Segment/Market Site is 20,000 Calculate Year 1 and Year 2 Total Contribution Margin and Net Profit/(Loss) 4 in the following scenarios 5 6 Scenario 1 7 Percentage of Market that visits caf 30% 8 Average number of visits per customer per year 3 9 10 11 Scenario 2 12 Percentage of Market that visits caf 70% 13 Average number of visits per customer per year 2 14 15 16 Scenario 3 17 Percentage of Market that visits cat 50% 18 Average number of visits per customer per year 19 20 Hint 21 You will need to calculate Foxed costs for year 1 and 2 22 23 24 25 26 30 32 34 35 36 Sheets Esc