Water bill data sheet
Yüklə 413 Kb.
|
- Bu səhifədəki naviqasiya:
- You can call us about your bill Mon – Fri, 7 am – 10 pm.
- ELECTRICITY BILL
- Moving House
- Bill Date: 25 November
- Carbon Monoxide
- Understanding ‘gas used’
- Bills, Bills, Bills Teacher Notes
|
WATER BILL DATA SHEET MR B COZIE 54 SNUG LANE WARMINGTON SB24 3HP
2 February 1999 For enquiries ring 0131 657 453 Customer Reference number 35-239-02-046-254 Your water and wastewater bill Payment by instalments You can call us about your bill Mon – Fri, 7 am – 10 pm. An account for the second instalment of £122.17 (due 1st July) will be sent to you in June.
How to pay
  Payment Slip Please fill in details from your cheque card before sending by post.
ELECTRICITY BILL DATA SHEET 
E  LECTRICITi
from WESTWEB ELECTRICITY BILLThank you for using our service. Your bill is now due for payment. If you have any queries, or need help, Mr. B Cozie 54 Snug Lane Warmington SB24 3HP
please phone us free on 0800 023415 quoting your customer number 640 0300 254 
This bill is estimated. If you want to tell us your meter reading(s), please phone our 24 hour automatic meter reading service free on 0800 023415. Thanks for your help. We aim to give you the best possible service. If you need advice please phone our Helpline free on 0800 023415. We are sure we can sort out any problem to your satisfaction. If you are not satisfied, you can ask the Office of Electricity Regulation (OFFER) to help you. OFFER is an independent body set up be Parliament to protect your interests. Moving House?If you are moving house, please tell us at least two working days before you move so we can arrange to get a meter reading. GAS BILL DATA SHEET 
 MR B COZIE 54 SNUG LANE WARMINGTON SB24 3HP
Heat in your home Bill Date: 25 NovemberCustomer Reference Number: 200 134 226 78653 By paying your quarterly bill within 10 days of the bill date you will receive a prompt payment reduction of £7.50 off your next gas bill. Carbon MonoxideGovernment Consumer Safety Warning. Carbon Monoxide can kill. Get your appliances checked every year. Keep your family safe. Estimated Readings (E) If your reading has been estimated and you would prefer us to use your own reading, please ring our automated service (local call rates). You will be asked for your customer reference number and your current meter reading. The service will tell you how much your new bill will be. Your new bill will be received within 7 days. Understanding ‘gas used’To work out the amount of gas you have been charged for:
Bills, Bills, Bills!          
Bills, Bills, Bills! Exercise Section A You need the water, electricity and gas bill data sheets. 1. Water Bill There are three types of charge:
The water and sewerage charges depend on the rateable value of the house. Show how the total annual charge of £488.68 and the first instalment of £115.67 have been calculated. 2. Electricity Bill Show all the calculations that give the total bill of £37.91. 3. Gas Bill Show all the calculations that give the total bill of £69.69.
You need the Excel spreadsheet, Bills.xls. 4. Water Bill (a) The values in the yellow cells E4, E5, E6, F7 and F9 have been calculated using spreadsheet formulae. Find and write down each of these formulae.
(c) Check by hand all of the values given on the new bill. 5. Electricity Bill (a) The blue cells, A5 and B5 show that the present meter reading is an estimate. Mr Cozie decides to contact Westweb to give them the true reading of 97698. (i) Replace the estimated reading by the true reading and print out the resulting bill. (ii) By comparing the total amount due on the old and new bills, find how much Mr Cozie will save by ringing up Westweb. (iii) Check your answer to part (ii) by comparing the number of units used on the old and new bills. (Don’t forget the extra VAT.) (b) Westweb announce that next quarter they will be increasing the price per unit to 6.6 pence and reducing the daily standing charge to 9.2 pence. Mr Cozie decides to calculate what difference this will make, assuming he uses the same amount of electricity and the number of days is the same. (i) Change the entries in the yellow cells, F5 and F7, to show the new prices and print out the resulting bill. (ii) Compare the total amounts on the bills you produced for parts (a)(i) and (b)(i). How much more or less will Mr. Cozie have to pay for the same amount of electricity? (iii) Check your answer to part (b)(ii) by an alternative method. (c) The values in the green cells D5, H5, H7, H9, H10 and H11 have been calculated using spreadsheet formulae. Find and write down each of the formulae. 6. Gas Bill Before the next bill arrives in the spring Mr Cozie decides to try to work out the cost himself. His new reading is 6928, and the previous reading was 6731. The prices have increased to 13.415 pence per day standing charge and 1.424 pence per kilowatt hour. There were 92 days in the quarter. (a) (i) Use the method given in the box at the bottom of the gas bill data sheet to work out the cost of the gas used.
(iii) Find the total charge including VAT, assuming that Mr Cozie will pay early enough to qualify for the Prompt Payment Reduction.
spreadsheet to show the values given above. Print out the new bill and compare the values given in other cells with your calculations. Section C 7. Write a brief summary of the similarities and differences between the water, gas and electricity bills. Bills, Bills, Bills! Assignment To complete this assignment you will need copies of two different bills or invoices for different goods or services. Possibilities include:
Each bill or invoice should have at least three different elements for which charges have been made (eg. labour, parts, postage and packing, standing charge). At least one of your bills or invoices should include VAT.
1. For each bill write out in full the calculations which have been carried out to arrive at the final amount charged.
Sample Examination Questions
Which Free-Standing Unit does this support?Foundation Level - Managing Money Evidence for Coursework PortfolioThe assignment can be used to satisfy the requirement to explain the calculations involved in bills and invoices. What students need to know
General Notes and Suggestions The Bills package includes Water, Electricity and Gas Data Sheets (pages 1 – 3), a discussion sheet (page 4), an exercise based on the data sheets (pages 5 - 6), an assignment (page 7) and some sample examination questions (pages 8 – 10) based on the data sheets. There are a variety of ways in which these can be used. The discussion sheet and/or the data sheets could be used to introduce the topic. Note that the water bill involves rateable values. These are still used by water companies in some areas. If possible, compare bills from different companies. The exercise requires use of the data sheets and the Excel file, Bills.xls. It is designed to give students practice in explaining bills, checking calculations and using spreadsheets. Students need to be familiar with terms such as standing charge before they begin. The assignment is open-ended, requiring students to provide their own bills and invoices. The sample examination questions, based on the same data sheets, can be used for practice. Answers to Exercise Section B 4. (a) E4 =B4*D4/100 E5 =B5*D5/100 E6 =E3+E4+E5 F7 =E6/4 F9 =F7-F8
5. (a) (i) 
(ii) £3.10 (b) (i) (ii) £0.61 extra (c) D5 =A5-C5 H5 =D5*F5/100 H7 =D7*F7/100 H9 =H5+H7 H10 =0.05*F10 H11 =H9+H10
(b)
(N.B. Minor differences between student calculations and the bills may arise due to rounding.) Answers to Sample Questions 1 a £4 b (i) £164.64 (ii) 78.00 pence per £ of rateable value (iii) £506.40 (iv) £6.75 2 
3 a (iii) b =B18+B19 (or correct alternative eg =1.05*B18)
Mathematics for all post-16 – A project funded by the Nuffield Foundation Yüklə 413 Kb. Dostları ilə paylaş:
|
ection C
