Investigations with Movie Rentals

Using Excel

 

Karyn Carson

 

You want to join a movie club and there are two in your neighborhood.  However, their rates are different and you canÕt decide which one to join.  Here are the ads for each store:

 

Movies Are Us

 

No Membership Fees

 

$4.50 per rental

                                                                       

 

Look At Us Video

 

$5 Membership Fee

 

$3.50 per rental

 

Where should you take your business?  LetÕs take this information and create an equation (also called a function) so that we can look at this data graphically.  What would the functions be?

 

Movies are Us:  y = 4.5x

 

Look at Us Video:  y = 3.5x + 5

 

LetÕs enter these functions into the spreadsheet program Excel to look at these situations graphically and see if we can determine which store to sign up with.

 

Number of Videos Rented

Videos are Us

Look at Us Videos

1

$             4.50

$                  8.50

2

$             9.00

$                12.00

3

$           13.50

$                15.50

4

$           18.00

$                19.00

5

$           22.50

$                22.50

6

$           27.00

$                26.00

7

$           31.50

$                29.50

8

$           36.00

$                33.00

9

$           40.50

$                36.50

10

$           45.00

$                40.00

11

$           49.50

$                43.50

12

$           54.00

$                47.00

13

$           58.50

$                50.50

14

$           63.00

$                54.00

15

$           67.50

$                57.50

16

$           72.00

$                61.00

17

$           76.50

$                64.50

18

$           81.00

$                68.00

19

$           85.50

$                71.50

20

$           90.00

$                75.00

 

As you can see, once youÕve rented 5 videos, the total cost paid at Look at Us drops below the cost at Videos are Us.

 

 

 

At what point on the graph do you see where it becomes better for us to join Look at Us?

 

 

 

Back to KarynÕs Homepage