Problem 268
The Request Club Problem. The following computer spreadsheet shows data foe two fee plans for use of a racquet club. Plan A is a flat rate of 
100 and an play in order for plan B to be the best plan for you? Use a paper-and-pencil table and a calculator-or use a computer if one is available to add as many rows as necessary to solve the problem.
|
A |
B |
C |
|
| 1 |
Number of Hours |
Plan A ( |
|
| 2 |
1 |
18 |
108 |
| 3 |
2 |
36 |
116 |
| 4 |
3 |
54 |
124 |
| 5 |
4 |
72 |
132 |
| 6 |
5 |
90 |
140 |
)
Describe why the spreadsheet can be used effectively to solve the problem.
Solution
| Number of | Plan A ( ) |
|
| 1 | 18 | 108 |
| 2 | 36 | 116 |
| 3 | 54 | 124 |
| 4 | 72 | 132 |
| 5 | 90 | 140 |
| 6 | 108 | 148 |
| 7 | 126 | 156 |
| 8 | 144 | 164 |
| 9 | 162 | 172 |
| 10 | 180 | 180 |
| 11 | 198 | 188 |
11 hours would be the best plan because for 11 hours plan A is much costly then plan B.