Travel Spending Analysis Report

This assignment presents a travel budget analysis comparing expenses across various continents and cities. Students are tasked with evaluating spending patterns, identifying the most and least expensive destinations (Berlin vs. Santiago), and recommending suitable tour packages based on financial considerations. The analysis utilizes data tables, lookup functions, and comparative insights to provide a comprehensive overview of travel costs.

Information Technology

Table of Contents
INTRODUCTION...........................................................................................................................3
Creating a letterhead....................................................................................................................7
Using letterhead to write a short letter to Stephanie....................................................................7
CONCLUSION................................................................................................................................9

INTRODUCTION
Information technology lays high level of emphasis on summarizing data set in an
effectual way. The present report is based on Wombat Travel agency which offers tour packages
to the customers. In this report will provide deeper insight about the manner through which data
can be arranged and summarized in a structured format.
Original Quote
Estimate of
Daily Spending
Money
60
City Contin
ent
Accommod
ation per
night
Daily
Spending
money
Total
per
Day
Days Total
for
Stay
Air
far
e
Total
spendi
ng
Auckl
and
Oceani
a
200 60 260 4 1040 75
00
8600
Beijin
g
Asia 170 60 230 5 1150 75
00
8710
Berlin Europ
e
300 60 360 4 1440 75
00
9000
Cairo Africa 175 60 235 5 1175 75
00
8735
Colu
mbo
Asia 150 60 210 3 630 75
00
8190
Honia
ra
Oceani
a
160 60 220 4 880 75
00
8440
Kath
mand
u
Asia 160 60 220 4 880 75
00
8440
Kerala Asia 170 60 230 3 690 75
00
8250
Nairo
bi
Africa 140 60 200 5 1000 75
00
8560
New
York
North
Ameri
ca
250 60 310 5 1550 75
00
9110
Paris Europ
e
250 60 310 5 1550 75
00
9110
Perth Oceani
a
190 60 250 3 750 75
00
8310

Reykj
avik
Europ
e
225 60 285 4 1140 75
00
8700
Rio de
Janeri
o
South
Ameri
ca
175 60 235 4 940 75
00
8500
Rome Europ
e
200 60 260 4 1040 75
00
8600
Santia
go
South
Ameri
ca
125 60 185 3 555 75
00
8115
Singa
pore
Asia 200 60 260 4 1040 75
00
8600
Tokyo Asia 250 60 310 4 1240 75
00
8800
Vanco
uver
North
Ameri
ca
190 60 250 3 750 75
00
8310
Revised Quote
Estimate of Daily
Spending Money
60
Contine
nt
Accommodat
ion per night
Daily
Spending
money
Total
per
Day
Days Total
for
Stay
Air
far
e
Total
spendin
g
Oceani
a
200 110 310 4 1240 750
0
8740
Asia 170 70 240 5 1200 750
0
8700
Europe 300 120 420 4 1680 750
0
9180
Africa 175 80 255 5 1275 750
0
8775

Asia 150 70 220 3 660 750
0
8160
Oceani
a
160 110 270 4 1080 750
0
8580
Asia 160 70 230 4 920 750
0
8420
Asia 170 70 240 3 720 750
0
8220
Africa 140 80 220 5 1100 750
0
8600
North
Americ
a
250 100 350 5 1750 750
0
9250
Europe 250 120 370 5 1850 750
0
9350
Oceani
a
190 110 300 3 900 750
0
8400
Europe 225 120 345 4 1380 750
0
8880
South
Americ
a
175 60 235 4 940 750
0
8440
Europe 200 120 320 4 1280 750
0
8780
South
Americ
a
125 60 185 3 555 750
0
8055
Asia 200 70 270 4 1080 750 8580

0
Asia 250 70 320 4 1280 750
0
8780
North
Americ
a
190 100 290 3 870 750
0
8370
Auckland
Berlin
Columbo
Kathmandu
Nairobi
Paris
Reykjavik
Rome
Singapore
Vancouver
0
50
100
150
200
250
300
350
400
450
Continent
Accommodation per night
Total per Day
Spending money per day
Continent Per day (in $)
Africa 80
Asia 70
Europe 120
North America 100
Oceania 110
South America 60

Africa Asia Europe North
America Oceania South
America
0
20
40
60
80
100
120
140
Per day spending (in$)
Per day spending (in$)
Particulars Per Day Per Stay
Most Expensive City Berlin Berlin
Least Expensive City Santiago Santiago
Average Vancouver Vancouver
Particulars Selection location
Berlin most expensive
Original itinerary total 9180
Original itinerary total 9000
% increase 2%
Creating a letterhead
17, Canal street, London

Phone: [phone]
www.wombat.com
Using letterhead to write a short letter to Stephanie
17, Canal street, London
Phone: [phone]
www.wombat.com
Dear Stephanie,
From overall evaluation it is reported that expectation level in relation to spending $60 per day is not
highly realistic. Moreover, expenses level is highly varied according to continent. Hence, by considering
the revised sheet it has been assessed that Berlin is the most expensive city in terms of per day expenses
and expenses related to stay. It comes under the Europe continent and recognized as a most expensive
one. Further, by analyzing data set it has been identified that Santiago is the least expensive city for the
purpose of visiting. Hence, to visit such city of South America individual does not require more money.
Besides this, individual require neither too high nor too lower amount for visiting Vancouver city of
North America. Thus, by considering such report of expenses you can select best city for visiting purpose
on the basis of both financial and non-financial aspects.