The main question : What are some recommendations of 'What-if Analysis' in excel ? (please give some points and explain)
I.Procedure details
Step 1
For cells D10, E10 and F10, type "Avg. number of mainland visitor arrival per day", "Mainland visitors' total contribution HK retail sales" and "HK GDP" respectively
A B C D E E 7 hip link centadata comtrilogi e him "Please refer to the hyperlinks above for details of the terms Avg Tourism Income Statement for Hong Kong 2013 number of HIKS mainland visitor Mainland visitors' arrival per total contribution 10 day HK retail sales HK GDP 11 111,507 180,000.043.014 2.022,472.393,412 12 Visitor Information 13 Total visitor arrivals 54.298.804 14 Mainland visitor arrival 40,700,000 15 Mainland visitor as %% of total visitor arrivals 75 16 Number of days in 2013 365 17 Avg. Number of mainland visitor arrival per day 111,507 18 19 Revenue 20 Total HK retail sales 500,000,000,000 21 % HK retail sales contributed by mainland visitors 36 22 Every Mainland visitors' contribution HK retail sales on average 1.614 251 23 Mainland visitors' contribution HK retail sales 180.000.043.014 24 25 Gross Domestic Product (GDP) 26 Mainalnd visitors' contribution as % of HK GDP 8.90 27 HK GOP 2.022,472.393,412A C D E 7 hip link centadata comicirri e him "Please refer to the hyperlinks above for details of the terms Ava number of Tourism Income Statement for Hong Kong 2013 HK'S mainland Mainland visitors' arrival per total contribution 10 day HK retail sales HK GDP 11 12 Visitor Information 13 Total visitor arrivals 54 298,804 14 Mainland visitor arrival 40,700 000 15 Mainland visitor as %% of total visitor arrivals 75 16 Number of days in 2013 365 17 Avg Number of mainland visitor anival per day 111.507 18 19 Revenue 20 Total HK retail sales 500 000 000 000 21 "% HK retail sales contributed by mainland visitors 36 22 Every Mainland visitors' contribution HK retail sales on average 1,614,251 Mainland visitors' contribution HK retail sales 180 000 043 014 24 25 Gross Domestic Product (GDP) 24 Mainand visitors' contribution as % of HK GOP 8.90 27 HK GOP 2 022 472,393,412A B C D E F 7 http://hk centadata.com/cci/cci e.htm 8 *Please refer to the hyperlinks above for details of the terms g Avg. number of Tourism Income Statement for Hong Kong 2013 HK$ mainland visitor Mainland visitors' arrival per total contribution 10 day HK retail sales HK GDP 11 111,507 180000043014 2022472393412 12 Visitor Information 100,000 161425100000 1813765168539 13 Total visitor arrivals 54,298,804 90,000 145282590000 1632388651685 14 Mainland visitor arrival 40,700,000 80,000 129140080000 1451012134831 15 Mainland visitor as % of total visitor arrivals 75 70,000 112997570000 1269635617978 16 Number of days in 2013 365 60,000 96855060000 1088259101124 17 Avg. Number of mainland visitor arrival per day 111,507 50,000 80712550000 906882584270 18 40,000 64570040000 725506067416 19 Revenue 30,000 48427530000 544129550562 20 Total HK retail sales 500,000,000,000 20,000 32285020000 362753033708 21 % HK retail sales contributed by mainland visitors 36 10,000 16142510000 181376516854 22 Every Mainland visitors' contribution HK retail sales on average 1,614,251 23 Mainland visitors' contribution HK retail sales 180,000,043,014 24 25 Gross Domestic Product (GDP) 26 Mainalnd visitors' contribution as % of HK GDP 8.90 27 HK GDP 2,022,472,393,412A B C D E F 7 http://hk.centadata.com/cci/cci e.htm 8 "Please refer to the hyperlinks above for details of the terms 9 Avg. number of Tourism Income Statement for Hong Kong 2013 HKS mainland visitor Mainland visitors' arrival per total contribution 10 day HK retail sales HK GDP 11 111,507 12 Visitor Information 180,000,043,014 2,022,472,393,412 100,000 13 Total visitor arrivals 54,298,804 90,000 14 Mainland visitor arrival 40,700,000 80,000 15 Mainland visitor as % of total visitor arrivals 70,000 16 Number of days in 2013 75 365 60,000 17 Avg. Number of mainland visitor arrival per day 111,507 50,000 18 40,000 19 Revenue 30,000 20 Total HK retail sales 500,000,000,000 20,000 21 % HK retail sales contributed by mainland visitors 36 10,000 22 Every Mainland visitors' contribution HK retail sales on average 1,614,251 23 Mainland visitors' contribution HK retail sales 180,000,043,014 24 25 Gross Domestic Product (GDP) 26 Mainalnd visitors' contribution as % of HK GDP 8.90 27 HK GDP 2,022,472,393,412
