Vacation Trip Choice.xlsx

	A	B	C	D	E	G	H	I
1	Vacation Trip Choice
2
3	Carribean Cruise
4	Description	# persons	# days	Unit Price	Amount
5	Lodging cost	2	1	$ 555.00	$ 1,110.00
6	Air fare rate	2	1	$ 350.00	$ 700.00
7	Total				$ 1,810.00
8
9
10	Orlando Theme Parks
11	Description	# persons	# days	Unit Price	Amount
12	Disneyland ticket	2	1	$ 99.00	$ 198.00
13	Universal Studios	2	1	$ 95.00	$ 190.00
14	Seaworld	2	1	$ 85.00	$ 170.00
15	Busch Gardens	2	1	$ 85.00	$ 170.00
16	Hotel rate	2	5	$ 105.00	$ 1,050.00
17	Food rate	2	5	$ 50.00	$ 500.00
18	Air fare rate	2	1	$ 100.00	$ 200.00
19	Total				$ 2,478.00
20
21	Chicago Museum Tour
22	Description	# persons	# days	Unit Price	Amount
23	Natural History ticket	2	1	$ 18.00	$ 36.00
24	Chicago Museum of Art	2	1	$ 25.00	$ 50.00	Carribean Cruise	Orlando Theme Parks	Chicago Museum Tour
25	Science Museum	2	1	$ 15.00	$ 30.00	$ 1,810.00	$ 2,478.00	$ 2,554.00
26	Museum of broadcast history	2	1	$ 9.00	$ 18.00
27	Hotel rate	2	5	$ 120.00	$ 1,200.00
28	Food rate	2	5	$ 50.00	$ 500.00
29	Air fare rate	2	1	$ 280.00	$ 560.00
30	Car rental	1	4	$ 40.00	$ 160.00
31	Total				$ 2,554.00
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100