Location
Phoenix, AZ
Budget Total:
Transportation
Item Description Qty Price each Total price
Plane tickets 4 $200 $ 800.00
Rental car- per day 5 $ 45.00 $ 225.00
Gas- Gallons 100 $ 3.10 $ 310.00
Lodging
Item Description Nights Price each night Total price
GCU Hotel 4 $ 89.00 $ 356.00
Flagstaff Hotel 1 $ 128.00 $ 128.00
Food
Item Description Days Price each day Total price
Breakfast budget 5 $ 150.00 $ 750.00
Lunch budget 5 $ 200.00 $ 1,000.00
Dinner budget 5 $ 350.00 $ 1,750.00
Entertainment and Misc.
Item Description Qty Price each ticket Total price
Movie 4 $ 10.50 $ 42.00
Concert 3 $ 45.00 $ 135.00
GCU Basketball game 4 $ 8.50 $ 34.00
Grand Canyon National Park 1 $ 35.00 $ 35.00
Flagstaff Extreme Adventure 4 $ 30.27 $ 121.08
You have finished your degree and are traveling to Phoenix for the GCU graduation
ceremonies with three of your closest friends for a week. You want to visit Phoenix for
graduation and drive to Flagstaff to see the Grand Canyon before returning home. You
have come up with a budget to see how much the trip will cost. Please make the
following adjustments-
1.) You just saw a promotion for $200 round trip flights to Phoenix. Change the ticket
price from $350 to $200.
2.) You decide to stay 1 night in Flagstaff and 4 nights in Phoenix. Change the Flagstaff
Hotel to 1 and the GCU Hotel to 4.
3.) After reviewing the options at GCU Hotel's Canyon 49 Grill, you think you can save
money eating breakfast there and adjust your breakfast budget from $200 to $150.
4.) GCU offers you a discount on your Basketball tickets changing your total from $10
to $8.50 each.
5.) One of your friends cannot attend the concert because she is meeting up with a
cousin in Phoenix. Change the concert number from 4 to 3.
Before you submit this assignment please click the plus sign (+) next to the GCU
Graduation Vacation tab, create a new tab, and type your name in cell A1. Then save
