• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  • Level: GCSE
  • Subject: Maths
  • Word count: 7547

For this task we were required to create a model that can be used to economise on my quarterly household electricity bill.

Extracts from this document...


Coursework modelling 1B - Write Up

For this task we were required to create a model that can be used to economise on my quarterly household electricity bill. My family quarterly electricity bill may be too high. I need to try and devise a method to bring the bill down to an acceptable level. There are lots of aspects of an electricity model that need to be known. Some of the important ones are:

  • Unit- these are kilowatt-hours, which are the amount of hours an appliance uses multiplied by the kilowatts the appliance has.
  • Tariff- the rate at which a company charges a unit.
  • Two-tier tariff- this can also be called a split rate. There are two different costs per unit. There is usually a cost for the first units up to a certain value, sometimes known as a split value, and a different cost per unit for any units after the split value. My bill uses a two-tier tariff. I have named it a split rate model throughout this write – up.
  • Value added tax (VAT)- this is usually a percentage and is added on to a price.
  • Standing charge- a value of money that is added onto a price. It is normally a value without percentages, and is added on to a price just for using a supplier.  

There are many different types of bills. The bills are usually paid quarterly. There is a standard model, which is simply calculated by multiplying the unit amount by the cost per unit. A unit can also be called a kilowatt- hour (kWhr). By multiplying the kilowatt of an electrical appliance by the time the appliance is used, in hours, we can obtain a value which is measured in kWHr. For example, a 0.1kW bulb is switched on for 20 hours.

...read more.


After working out the IF formulae, I then had to type in the data for the cost before and after the split value. I then worked out a total cost for the units by multiplying the cost of the first 182 units by the first IF formulae cell, and then adding this to the cost of the units after 182 units multiplied by the second IF cell. This gave a total cost for the units. All that needed to be worked out after that was the VAT amount and the standing charge. However, my bill didn’t have a standing charge, so I typed zero pounds, so that if a standing charge is introduced to an npower bill, the model can apply it to the total cost. VAT for my bill was at 5%. To work out the VAT, I multiplied the cell containing the 5% data by the total of the standing charge and the cost of the units. I then used a SUM formula to calculate the total of the bill. The formula totalled the VAT cost, the total cost for the units, and the standing charge, if there is one. For the total cost of the units I used “custom number formatting.” This meant that I was able to write “TOTAL COST FOR WEEK IS” and then the total cost, in one cell, and the spreadsheet treats it as if it is just the formula for the total cost. I did after the formula worked out the total cost. I then highlighted the result and went on to format cells. I then went on to the number tab and clicked on custom. I typed in what I wanted before the result, and placed speech marks either side of the text. The number was referred to as ‘general.

...read more.


Overall, I have learnt a lot of things from my ‘what if’ questions. My predictions weren’t much off. VAT was usually the cause of this. I created a chart after finding out results to my ‘what if’ questions so that it can easily be seen which prices are more expensive than others. The chart is easy to understand and can be interpreted by most people. The chart shows that economy 7 split rate (British Gas) was the most expensive by a considerable amount. This is probably because of the split value that British Gas use. Economy 7 split rate would be more efficient to my family if we use more units of electricity. Otherwise the best model to use for my family is the standard model. Economy 7 could be better for my family, but only if I make changes to the way I use my electricity. It would be more efficient if more of our electrical units could be used at night. Therefore these units would be priced at a low cost. It is possible for my family to adjust and change our electrical usage. I think my mother could start to iron her clothes more during the night. My dad could start vacuuming at night so that these units could be priced lower. I could also make my family have a suitable night period, to work with my electrical usage.

A chart is given below to show how my ‘what if’ questions compare to my normal model.


I created this chart so that it can be seen easily which ‘what if’ is cheaper than my normal model. It can be seen from my chart that economy 7 split rate (British Gas) is the most expensive for me. There are many changes my family can make to ensure the cheapest bill possible. Using less T.V. for example is a great possibility.

...read more.

This student written piece of work is one of many that can be found in our GCSE T-Total section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE T-Total essays

  1. The T-Total Mathematics Coursework Task.

    Bottom of L-shape L-total All numbers in L-shape added 10 20 46 200 11 25 47 205 12 30 48 210 13 35 49 215 14 40 50 220 15 45 51 225 19 65 55 245 20 70 56 250 21 75 57 255 22 80 58 260 23

  2. T totals - translations and rotations

    My T-total is 19+12+5+4+6= 46. The number in my T-shape directly above my T-number is 7 places back on my grid so it is represented as N-7. The number directly above this is also 7 places back on my grid so it is represented as N-7-7= N-14.

  1. Maths Coursework T-Totals

    + (v - 2) + (v + 1) + (v + 4) t = 2v-1 + 3v + 3 t = 5v + 2 CHECK YOUR RULE WITH EXAMPLES We can see the formula is the same as for a 3x3 grid. 1 2 3 4 5 6 7 8 9 10 11 12

  2. T-Total. I will take steps to find formulae for changing the position of the ...

    51 52 53 54 55 56 57 58 59 60 61 62 63 64 I used the same method for the 8 x 8 grid above as I did for the 9 x 9 grid. The T is in the same place but the numbers have changed.

  1. ICT Coursework: Data Management Systems

    The software I require is Microsoft Excel, a spreadsheet package. I am going to use this as it can be used to do many calculations automatically, and I am familiar with the package. The sources of input data for this product are as follows: * The price the customer buys

  2. Investigation in to How many tiles and borders is needed for each pattern

    Formula to calculate the number of tiles is 2n +2n+1 For example: When n=3 (3 ) 2=18 2 3=6 +1 =18+6+1 =25 So then for the 3rd pattern you will get 25 tiles. 3. Formula to calculate the total tiles for each pattern is 2n +6n+5 For example: When n=4 (4 )

  1. Urban Settlements have much greater accessibility than rural settlements. Is this so?

    Pedestrian Counts Much the same as traffic counts, the data was in a tally chart. They were taken on each side of the road for 5 minutes each. There were not many problems with this, but in S Darenth, there was hardly anyone around!

  2. T-Total Course Work

    + (T-18) + (T-17) + (T-9) + (T) = 5T - 63 Let T-number = T Let T-total = n T n 20 21 22 37 +(5) = 42 +(5) = 47 Formula = 5T - 63 I tested that when: T = 80 n = 337 337 = 5T - 63 337 = (5 x 80)

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work