1 Caribbean Caf Sensitivity Analysis 2 3 Given Segment/Market Size 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 caf 50% 18 Average number of visits per customer per year 4 19 20 Hint 21 You will need to calculate Fixed costs for year 1 and 2 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Sheet1 F G Leputa 4 Market Data Year 1 Year 2 Anal Tour Sales 9 Foot Traffic per Yew 50 30 0 SSS 30 10 Customer usage rates 11 12 15 14 15 16 Variable Costs Per Avg. Customer 17 18 19 70 Average Variable Cost per Avg Customer 21 22 Price Per Customer 30 CM 11 #DIV/ DIVO Marcus 1 25 Total Startup 10 10 2 Average Reve per Customer 20 Average Cosbution Mwig per to 10 Contribution Margin Ratio 11 13 Coste 11 Mart Costs NOVO! DIV/ 3559 unded Coste Monthly Am 10 Sheet 22 Price Per Customer si 1 SSES Total State 2 25 20 27 Awerage Navenue per Customer 0 0 BB 0 SON/01 HOIVO! 00 29 Average Contribution Margir per Customer 50 Contribution Margin Ratio 21 32 Fixed Costa Startup Costs 14 15 36 31 JU Sustained fred Costa Monthly 19 10 10 iemes 11 ww/ 41 44 45 40 47 48 19 Depreciation 50 Cast Lifefars) Annual Memotion Maksumption Mention 55 Total Depreciation 54 55 90 59 GO Sheet 25 1 Caribbean Caf Sensitivity Analysis 2 3 Given Segment/Market Size 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 caf 50% 18 Average number of visits per customer per year 4 19 20 Hint 21 You will need to calculate Fixed costs for year 1 and 2 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Sheet1 F G Leputa 4 Market Data Year 1 Year 2 Anal Tour Sales 9 Foot Traffic per Yew 50 30 0 SSS 30 10 Customer usage rates 11 12 15 14 15 16 Variable Costs Per Avg. Customer 17 18 19 70 Average Variable Cost per Avg Customer 21 22 Price Per Customer 30 CM 11 #DIV/ DIVO Marcus 1 25 Total Startup 10 10 2 Average Reve per Customer 20 Average Cosbution Mwig per to 10 Contribution Margin Ratio 11 13 Coste 11 Mart Costs NOVO! DIV/ 3559 unded Coste Monthly Am 10 Sheet 22 Price Per Customer si 1 SSES Total State 2 25 20 27 Awerage Navenue per Customer 0 0 BB 0 SON/01 HOIVO! 00 29 Average Contribution Margir per Customer 50 Contribution Margin Ratio 21 32 Fixed Costa Startup Costs 14 15 36 31 JU Sustained fred Costa Monthly 19 10 10 iemes 11 ww/ 41 44 45 40 47 48 19 Depreciation 50 Cast Lifefars) Annual Memotion Maksumption Mention 55 Total Depreciation 54 55 90 59 GO Sheet 25
