Lesson 6: Tables of values and spreadsheets
Is a new energy-efficient fridge worth it?
SkillsTables of valuesSubstituting into linear formulasFinding an unknown pronumeral
Worked example
The Nguyen family's old fridge uses 1.6 kWh of electricity a day. A new energy-efficient fridge costs $1450 and uses 0.9 kWh a day. Electricity costs 33 cents per kWh.
(a) Show that the total cost, in dollars, of running the old fridge for years is , and that the total cost of buying and running the new fridge is .
(b) Construct a table of values of both costs for and .
(c) Find when the new fridge becomes the cheaper option.
(d) Fridges typically last 10 to 15 years. Evaluate whether buying the new fridge is worthwhile on cost alone.
Step 1: (a) Build the old fridge's formula
Cost per year , so .
Step 2: (a) Build the new fridge's formula
Running cost per year . Add the purchase price: .
Step 3: (b) Table of values
(years) 0 5 10 15 20 ($) 0 963.60 1927.20 2890.80 3854.40 ($) 1450.00 1992.03 2534.05 3076.08 3618.10 The old fridge is cheaper at 15 years but dearer at 20 years, so the costs are equal somewhere between.
Step 4: (c) Set the costs equal and solve
Subtracting from both sides collects the unknown on one side. is the saving per year.
Step 5: (d) Evaluate
The new fridge only pays for itself after about 17.2 years, longer than a fridge usually lasts. On cost alone it is not worthwhile. It may still make sense if the old fridge is about to fail, if electricity prices rise, or for environmental reasons.
Answer
(c) After about 17.2 years. (d) On cost alone, no: the saving of about $84 a year takes longer to repay $1450 than the fridge's likely life, unless the old fridge needs replacing anyway or electricity prices rise.
Try a similar one
A fresh question of the same kind, checked as you answer, with hints and a full solution.
Method
Build each total-cost formula as a fixed amount plus a rate per year.
Tabulate both to see roughly where they cross.
Set the formulas equal and solve for the crossover.
Judge the result against the real-world constraints.
Watch out for
Forgetting to convert 33 cents to $0.33.
Concluding from the table alone that the crossover is at 15 or 20 years. Solve the equation for the exact point.