PURPOSE: TIM 302 TOURISM SPREADSHEET 25 points: Due November 28, 2023 The purpose of this assignment...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
For the year ending December 31, Orion, Inc. mistakenly omitted adjusting entries for $1,500 of supplies that were used, (2) unearned revenue of $4,200 that was earned, and (3) insurance of $5,000...
-
What is a junk bond?
-
The Brown and Brinkley Brokerage firm is organized into two major sales divisions: institutional clients and retail clients. The firm also has two support departments: research and administration....
-
A countercurrent extraction system extracts furfural from water into methyl-isobutyl ketone (MIBK) at \(25^{\circ} \mathrm{C}\). Aqueous feed contains 0.0011 wt. fraction furfural and has a feed rate...
-
The following list identifies several potential cost drivers for a manufacturing company that makes eight products. The company uses a JIT production system so it stores finished products for a very...
-
Journal entry for 151,000 common shares were issued in exchange for machinery with a fair market value of 2767,000 the shares were actively trading on this date at 17,000 per share
-
A bank offers you two rates. The first is a 5% rate on a 30 year self liquidating mortgage for 75% of the 400,000 value.The second option is 7.5% for 90% financing also on 30 year amortization.What...
-
Measuring GDP (6pts): A simple economy has four industries: The agricultural industry sells $45 million in food products directly to households as well as $35 million to the steel industry, which...
-
Ratliff Appliances Company makes a household appliance with model number RM16. The goal for 2020 is to reduce direct materials usage per unit. No defective units are currently produced. Manufacturing...
-
Sweet Catering completed the following selected transactions during May 2016: May 1: Prepaid rent for three months, $1,800 May 5: Received and paid electricity bill, $120 May 9: Received cash for...
-
The purpose of this reflection assignment is to use the experience of working in your group to explain some of the group concepts examined this week. Instructions Using the information from your...
-
What are some issues facing developing nations? What kind of assistance is the United States providing to developing nations? What is your assessment of the effectiveness of these actions? Should the...
-
Prepare summary journal entries to record the following transactions for a company in its first month of operations. a. Raw materials purchased on account, $88,000. b. Direct materials used in...
-
Evaluate each logarithm to four decimal places. log 0.257
-
Fraudulent financial reporting usually occurs as the result of environmental, institutional, or individual pressures and opportune situations. These pressures and opportu nities, present to some...
-
It was a typical Wednesday on the UCLA campus when everything began going wrong in the student computer lab. The computer lab was filled to capacity as the end of the semester neared. Nearly 70...
-
The auditor of a bank is called to a meeting with a senior operations manager because of a customers report that an auto loan payment was not credited. According to the customer, the payment was made...
Study smarter with the SolutionInn App