ACTIVITY #1

     Complete the following table by finding the cost of renting the car from www.avis.com for 0 to 100 miles in steps of 10 miles.  In addition, find a formula that can be used to calculate the cost for Avis if the car is driven X miles.

ACTIVITY #2

Complete the following table by finding the cost of renting the car from www.hertz.com , and find a formula that can be used to calculate the cost of renting the car from Hertz if it is to be driven X miles.

ACTIVITY #3

Complete the following table by finding the cost of renting the car from  www.budget.com Budget, and find a formula that can be used to calculate the cost of renting the car from Budget if it is to be driven X miles.

ACTIVITY #4

Using the information in the three tables above, draw three(3) separate graphs showing the costs of each company.
Click here for Excel  [Microsoft Excel required]
Click here for directions to use Excel

ACTIVITY #5

Complete the following table using your graphs, formulas and tables.

ACTIVITY #6

Draw a fourth graph showing all the costs for all three companies.
Click here for Excel
Click here for directions to use Excel

ACTIVITY #7

Use the graph in Activity #7 to answer the following questions in complete sentences.

1.  Which company charges the least for a small number of miles?  A large number of miles?

2.  Which company would you rent from if you planned to drive the car 60 miles?    100 miles?  20 miles?

3.  How many miles must you plan to drive before Avis becomes the best deal?  Before Budget becomes the best deal?

4.  How many miles would you need to drive so that the rental cost from Hertz and Avis would be the same?

     a)   Avis and Budget?

     b)  Hertz and Budget?

ACTIVITY #8

Next you're going to help the Green family find the cheapest way to plan their trip.   Look at  Fun and Sun Rent- a -Car below.  Follow the directions and  print or draw out a copy of the graph and table and show it to you teacher.

To the Java Version

The Green family is planning a one-week vacation in Florida and needs to rent a car while there. They researched and found the following options.   

*Weekly Rate 1		$329 per week, unlimited mileage.
*Weekly Rate 2		$219 per week, plus 12 cents per mile.
		*Partial week charged at a full week's price.
**Daily Rate 1		$50 per day, unlimited mileage.
**Daily Rate 2		$40 per day plus 3 cents per mile.
		**Partial days charged at a full day's price.

The Greens don't know exactly how far they will drive but estimate that it will be between 500 and 1000 miles. They must decide which plan to choose. Explore the four options below.  

---

Things to Do

Make a Table (Offline)

Fill in a table like the one below with the costs of each option.

Comparison of Total Rental Car Costs per Week Based on Mileage Driven
Total Miles Driven in Week	500	600	700	800	900	1000
Cost at Weekly Rate 1
Cost at Weekly Rate 2
Cost at Daily Rate 1
Cost at Daily Rate 2

Make a Graph (Offline)

         Draw and compare graphs of the four options on axes like the ones below.

      500           600          700     800        900          1000

                       Total Miles Driven in Week

 

 ACTIVITY #9

Now it's your turn to plan a trip.  Plan a trip to anywhere and determine which company will give you the best deal.  Is it  Hertz, Avis, or Budget?   Compare and show why you choose one company over the other. Show your teacher all your work, like you did in the example above from the Green family. You may use graphs, posters, overhead projector or a written report to share which company is the most cost effective.

 

Return to Course Description