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

  • Complex unfamiliar
  • Technology active

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 yy years is Cold=192.72yC_{\text{old}} = 192.72y, and that the total cost of buying and running the new fridge is Cnew=1450+108.405yC_{\text{new}} = 1450 + 108.405y.

(b) Construct a table of values of both costs for y=0,5,10,15y = 0, 5, 10, 15 and 2020.

(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.

1 of 5 steps
  1. Step 1: (a) Build the old fridge's formula

    Cost per year =1.6 kWh×365×$0.33=$192.72= 1.6 \text{ kWh} \times 365 \times \$0.33 = \$192.72, so Cold=192.72yC_{\text{old}} = 192.72y.

Try a similar one

A fresh question of the same kind, checked as you answer, with hints and a full solution.

Method

  1. Build each total-cost formula as a fixed amount plus a rate per year.

  2. Tabulate both to see roughly where they cross.

  3. Set the formulas equal and solve for the crossover.

  4. 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.

Save your progress with a free account