Insert Home Page Layout Formulas Data View Review Help Tell me what you want to do Cibi 11 - AA Wrap Text General Peste X Cut Copy Format Painter powd BIU .A Merge & Center - $ . % 008 FO Toet Aliment Number A22 A F G 2 D H K 1 Caribbean Caf Sensitivity Analysis 3 Given Sepment/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% 6. Average number of visits per customer per year 3 70% 2 10 11 Scenario 2 12 Percentage of Market that visits cafe 11 Average number of visits per customer per year 14 15 16 Scenario 17 Percentage of Market that it caf 18 Average number of visits per customer per year 19 20 Hint 21 You will need to calculate Fed costs for year 1 and 2 50X 23 24 15 O ! Format Painter Clipboard Merge & Center - % Font Aliment C50 f (Make an assumption) D Year 1 Year 2 B 1 2 3 Inputs 4 Market Data 5 6 7 & Foot Traffic per Year 9 10 Customer X usage rates 11 12 13 14 15 16 Variable Costs Per Avg. Customer 18 19 20 Average Variable Cost per Avg. Customer 21 22 Price Per Customer 23 24 25 26 27 Average Revenue per Customer 28 29 Average Contribution Margin per Customer 30 Contribution Margin Ratio 31 32 Fixed Costs 33 Start up Costs 34 0 0 0 0 0 NDIV/01 #DIV/0! 10 Sheet I Esc Dil 3 Wate Review View Help & Cut Tell m Calibri 11 Copy Paste ' ' A. ab Wrap Text BIU Format Painter Clipboard Merge & Center - Font Alignment CSO (Make an assumption) D 0 0 0 0 #DIV/0! #DIV/0! A B 25 26 27 Average Revenue per Customer 28 29 Average Contribution Margin per Customer 30 Contribution Margin Ratio 31 32 Fixed Costs 33 Start up Costs 34 35 36 37 38 Sustained Fixed Costs Monthly 39 40 Annual 42 43 44 45 46 47 48 49 Depreciation 50 51 52 53 Total Depreciation 54 55 56 Cost Lifelyears) Annual Depr. (Make an assumption) (Make an assumption) (Make an assumption) 58 59 60 Sheet1 Tell me what you want to do at General 1 AutoSum - 47 O Conter $ 93 . Insert Delete Format Conditional Format as a Formatting Table Styles Style Clear Sort & Find & Filter. Select - Editing Number Cells F G H An Yes Year Sales 0 0 SS33 SS8 Sales Total Los expenses 0 50 30 TO 50 0 30 Con Margin Con Margin Statio OTVO IV/ Start Cats 30 0 0 so Total Start 10 so 30 SU 0 Sustained dute 0 30 WV/01 25 30 90 10 10 10 30 DEFE 100 10:34 PM Prisen FE Home End 1952 PgD De Number Styles Clear Styles Sort & Find & Filter Select Editing Cells M N 0 Contribution Margin Contribution Margin Ratio 30 0 0 #DIV/ #DIV/01 Start Up Costs 0 0 SO $0 0 50 50 50 Total Start Up Costs $0 10 $0 Sustained Costs 0 0 0 30 BISS 33 O 0 0 50 50 0 0 Der toed te Opening 10 30 SO 30 NO 10 KEVINE PTTV/ DIV son #DIV/OF Provide Excel Spreadsheet detailing the the calculations of Year 1 and Year 2 Total Contribution Margin and Net Protoss di do Presco 14 A & Badespace 9 6 5 0 Y R O U Insert Home Page Layout Formulas Data View Review Help Tell me what you want to do Cibi 11 - AA Wrap Text General Peste X Cut Copy Format Painter powd BIU .A Merge & Center - $ . % 008 FO Toet Aliment Number A22 A F G 2 D H K 1 Caribbean Caf Sensitivity Analysis 3 Given Sepment/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% 6. Average number of visits per customer per year 3 70% 2 10 11 Scenario 2 12 Percentage of Market that visits cafe 11 Average number of visits per customer per year 14 15 16 Scenario 17 Percentage of Market that it caf 18 Average number of visits per customer per year 19 20 Hint 21 You will need to calculate Fed costs for year 1 and 2 50X 23 24 15 O ! Format Painter Clipboard Merge & Center - % Font Aliment C50 f (Make an assumption) D Year 1 Year 2 B 1 2 3 Inputs 4 Market Data 5 6 7 & Foot Traffic per Year 9 10 Customer X usage rates 11 12 13 14 15 16 Variable Costs Per Avg. Customer 18 19 20 Average Variable Cost per Avg. Customer 21 22 Price Per Customer 23 24 25 26 27 Average Revenue per Customer 28 29 Average Contribution Margin per Customer 30 Contribution Margin Ratio 31 32 Fixed Costs 33 Start up Costs 34 0 0 0 0 0 NDIV/01 #DIV/0! 10 Sheet I Esc Dil 3 Wate Review View Help & Cut Tell m Calibri 11 Copy Paste ' ' A. ab Wrap Text BIU Format Painter Clipboard Merge & Center - Font Alignment CSO (Make an assumption) D 0 0 0 0 #DIV/0! #DIV/0! A B 25 26 27 Average Revenue per Customer 28 29 Average Contribution Margin per Customer 30 Contribution Margin Ratio 31 32 Fixed Costs 33 Start up Costs 34 35 36 37 38 Sustained Fixed Costs Monthly 39 40 Annual 42 43 44 45 46 47 48 49 Depreciation 50 51 52 53 Total Depreciation 54 55 56 Cost Lifelyears) Annual Depr. (Make an assumption) (Make an assumption) (Make an assumption) 58 59 60 Sheet1 Tell me what you want to do at General 1 AutoSum - 47 O Conter $ 93 . Insert Delete Format Conditional Format as a Formatting Table Styles Style Clear Sort & Find & Filter. Select - Editing Number Cells F G H An Yes Year Sales 0 0 SS33 SS8 Sales Total Los expenses 0 50 30 TO 50 0 30 Con Margin Con Margin Statio OTVO IV/ Start Cats 30 0 0 so Total Start 10 so 30 SU 0 Sustained dute 0 30 WV/01 25 30 90 10 10 10 30 DEFE 100 10:34 PM Prisen FE Home End 1952 PgD De Number Styles Clear Styles Sort & Find & Filter Select Editing Cells M N 0 Contribution Margin Contribution Margin Ratio 30 0 0 #DIV/ #DIV/01 Start Up Costs 0 0 SO $0 0 50 50 50 Total Start Up Costs $0 10 $0 Sustained Costs 0 0 0 30 BISS 33 O 0 0 50 50 0 0 Der toed te Opening 10 30 SO 30 NO 10 KEVINE PTTV/ DIV son #DIV/OF Provide Excel Spreadsheet detailing the the calculations of Year 1 and Year 2 Total Contribution Margin and Net Protoss di do Presco 14 A & Badespace 9 6 5 0 Y R O U