PURPOSE: TIM 302 TOURISM SPREADSHEET 25 points: Due November 28, 2023 The purpose of this assignment is to reinforce your knowledge of spreadsheet construction and layout and show you how they may be used in a tourism destination setting. This assignment must be done using Microsoft Excel, Google Docs & Spreadsheets or Open Office. When you have completed it please name your file (with a name unique to you) and submit it via Laulima. You need not send the graph section. Please also print out a hard copy of the spreadsheet, and the graphs and turn them in at the beginning of class on Tuesday, November 28. ASSIGNMENT: 1. You are given the following data for outbound travel from Hawaii to eight destinations. For each destination the figures represent information about travelers from Hawaii to the destination for the month of September 2022. Destination No. Travelers Avg. Daily Expend/person Avg. Length of Avg. party size stay New York 12,110 $305 7 days 1.5 Hong Kong 15,843 $262 5 days 1.8 San Francisco 21,153 $194 6 days 3.1 Singapore 12,347 $162 5 days 2.8 Bali, Indonesia 8,980 $ 84 9 days 2.0 New Zealand 9,140 $113 14 days 2.2 Los Angeles 17,211 $179 5 days 2.3 Las Vegas 22,385 $222 8 days 3.6 2. Create new columns as follows: 3. Number of visitor-days spent in each destination by visitors from Hawaii Average spending per party in each destination Percentage of international visitors to Singapore coming from Hawaii (you will have to research to find the Singapore statistics). Please note your source. You are also told the following facts: Assume there are 3 flights per day to the domestic destinations and 2 per day to the foreign destinations. assume that each aircraft has 300 seats on board assume that 30% of travelers to foreign destinations are business travelers and 55% of travelers to domestic destinations are business travelers. 4. 5. 6. 7. CALCULATE the following statistics in your spreadsheet for each destination. Use a formula in each case so that the spreadsheet calculates the numbers for you: . the number of business travelers to each destination. b. C. d. c. the average load factor for flights to each destination (check your TIM 101 notes or other book to be sure that you know what 'load factor' means). the revenue (in dollars) that each destination receives from tourists from Hawai'i for the month of September. approximate number of parties to each destination during the whole of 2022 (assume figures for all other months are the same as September). Average Daily Census (i.e., the number of tourists from Hawai'i in each destination on an average day (for the formula for average daily census check your TIM 101 notes or other source to figure this out). Design your spreadsheet to contain the information given and the required statistics in Q. 3. Plan it carefully and use titles, fonts, underlining etc. as appropriate to make it look professional. Format the cells appropriately. Use formulae and copy them wherever possible. I will be giving grades for professionally presented, logically elegant and easy-to-read spreadsheets. Graph the following two data series each with an appropriate type of graph. Number of travelers to each destination in September Average daily expenditures per party in each destination. Turn in a hard copy of your spreadsheet and graphs. Also submit your spreadsheet files via Laulima so that I can see the cell formats. There is no need to send the graphs.