Around The World with Santa

Plan an Around the World Sleigh Ride with Santa


You and a partner and Santa are to plan an around the world trip. You will determine your route and calculate the distance plus all costs associated with the trip. You will decide where you eat, in which countries you spend the night and how many miles to travel each day, you must stay within your budget. The elf’s have given you $2,500 to spend on the trip. You will need to be back home in 12 days.

Transportation
Sleigh +6 reindeer $25.0/day…………………………… 330 m.p.h.
Sleigh + 8 reindeer $35.00/day……………………….. 440 m.p.h.
Sleigh + 10 reindeer $ 45.00/day………………………550 m.p.h.

Hotel
Economy (no pool) $55.00/day
Mid-range (pool) $85.00/day
Luxury (pool + room service) $150.00/day


Food
Fast Food (McDonalds) $5.00/ meal/per person
Mid-Range (Denny’s) $10.00/meal/per person
Luxury (Black Angus) $25.00/meal/per person

Constraints
You must be back in 12 days. You can only travel 10 hours per day. You must stay in your budget.

Think About
How many miles must Santa cover per day? Show your work. At what speed must Santa travel? Organize your thoughts before you begin, what are the most important things to think about first, next, and last?

Your Work
You will need to produce 4 cumulative graphs.

One showing the miles you traveled each day
One showing the amount of money spent on reindeer each day
One showing the total spent each day
One showing the amount of money you have left each day.
This is a great time to learn how to do graphs in Excel.