ۥ-1@ -tpGnnnnnnnn nnnnnono5Jo&p(NpNpNpNpNpNpNpPpPpPpPpPpPpnp4p+npnnpnp25Paying for electricity - computer exercise
>>> Do not write on this sheet <<<
SYMBOL 183 \f "Symbol" \s 10 \h Log on using your own name & password, then choose "Science".Double-click "Excel", File, Open, Drive M:, choose "elecbill.xls" and click "OK".
SYMBOL 183 \f "Symbol" \s 10 \h This spreadsheet is a dummy electricity bill. You can adjust the numbers in the green cells to see how it affects the bill.(To do this, click on the number you want to change, type in the new number, and press ENTER)
SYMBOL 183 \f "Symbol" \s 10 \h Remember that a "unit" of electricity is really a "kilowatt-hour" - the amount of energy used by a 1,000 Watt appliance in one hour. So a 2kW heater will use 1 unit in 30 minutes.
How the bill is worked out
SYMBOL 183 \f "Symbol" \s 10 \h You get a bill every 3 months
SYMBOL 183 \f "Symbol" \s 10 \h We subtract the "previous" meter reading from the "present" reading. This tells us how many units we have used.
SYMBOL 183 \f "Symbol" \s 10 \h Multiply this by the "price per unit".
SYMBOL 183 \f "Symbol" \s 10 \h Add on the "standing charge" (think of it as a subscription)
SYMBOL 183 \f "Symbol" \s 10 \h Work out the VAT and add it on. (Note - VAT on fuel bills is a special rate).
SYMBOL 183 \f "Symbol" \s 10 \h Add up the total to pay.
Questions
1. When the file is first opened :-(a) how many units have you used?(b) what is the total bill?
2. Change the "present" meter reading to 51200.(a) Now how many units have you used?(b) What is the cost of the electricity that you have used?(c) What is the total bill now?
3. Check that the "present" reading is 51200, the "previous" reading is 49945, the "price per unit" is 7.37p, the VAT is 8.00%, and the "standing charge" is 8.70.(a) What if there was no VAT an the bill. How much would you have to pay?Set the VAT back to 8.00%.(b) What if the "price per unit" was 10p - what would the total bill become?
Paying for electricity - computer exercise ANSWERS
>>> Do not write on this sheet <<<
SYMBOL 183 \f "Symbol" \s 10 \h Log on using your own name & password, then choose "Science".Double-click "Excel", File, Open, Drive M:, choose "elecbill.xls" and click "OK".
SYMBOL 183 \f "Symbol" \s 10 \h This spreadsheet is a dummy electricity bill. You can adjust the numbers in the green cells to see how it affects the bill.(To do this, click on the number you want to change, type in the new number, and press ENTER)
SYMBOL 183 \f "Symbol" \s 10 \h Remember that a "unit" of electricity is really a "kilowatt-hour" - the amount of energy used by a 1,000 Watt appliance in one hour. So a 2kW heater will use 1 unit in 30 minutes.
How the bill is worked out
SYMBOL 183 \f "Symbol" \s 10 \h You get a bill every 3 months
SYMBOL 183 \f "Symbol" \s 10 \h We subtract the "previous" meter reading from the "present" reading. This tells us how many units we have used.
SYMBOL 183 \f "Symbol" \s 10 \h Multiply this by the "price per unit".
SYMBOL 183 \f "Symbol" \s 10 \h Add on the "standing charge" (think of it as a subscription)
SYMBOL 183 \f "Symbol" \s 10 \h Work out the VAT and add it on. (Note - VAT on fuel bills is a special rate).
SYMBOL 183 \f "Symbol" \s 10 \h Add up the total to pay.
Questions
1. When the file is first opened :-(a) how many units have you used? 555(b) what is the total bill? 53.57
2. Change the "present" meter reading to 51200.(a) Now how many units have you used? 1255(b) What is the cost of the electricity that you have used? 92.49(c) What is the total bill now? 109.29
3. Check that the "present" reading is 51200, the "previous" reading is 49945, the "price per unit" is 7.37p, the VAT is 8.00%, and the "standing charge" is 8.70.(a) What if there was no VAT an the bill. How much would you have to pay? 101.19Set the VAT back to 8.00%.(b) What if the "price per unit" was 10p - what would the total bill become? 144.94
AJD C:\...\filename ELECBILL.DOC TIME \@ "dd/MM/yy"06/10/96
.ASS7stci(:IB"6% ;
e ' ' i ' p -
!C)-2
$.-2
.; !
. !
. ! !)- !,Y-2
$)"- ! !)-2
$.-2
.; !
. !
. !) !-2
@E"- !; !E-2
@E- !E !;-2
@YJ^-2
JY;^ !TJ !^J !T; !^E-2
@YEc- !T; !^E-2
@J-2
J; !J !J !E !;-2
@YEc- !^; !TE-2
$)- !) !-2
@E- !E !;-2
@E- !E !; !@ !CE-2
;E- !; !;- !,l !, !,
- !WE-2
;E- !; !;- !B-2
;YE^- !^; !T;-2
;E- !; !; !@ -'- i Arial--"System-'-- i Arial-Times New Roman---'-- Cd
2
1S>> You can adjust the numbers in the GREEN boxes, and see the effect on the bill <<""+!! !!!!0 !!.+((+ ! !!! ""--'-- p --'-- i Wingdings---'-- d H
2
?X:qArials---'-- H
2
XBSESA<<<---'-- d H
2
?f:q-32
sMFor electricity supplied to :%! --'-- p --'-- i Times New Roman-
:2
J"Broadoak School Electricity Supply!
Arial-
"2
L3, Fictitious Road$--'-
- p --'-
- i -
2
#1Meter Readings :9+ !-
!2
,LWeston-super-Mare2)--'-
- p
!C$--'-
- i Times New Roman-
2
s Present :!-2
r50000-2
s=units-
2
{LNorth Somerset$!(--'-
- p
!C0--'-
- i -
2
Previous :!-2
49945-2
=unitsArialG-2
LFor the period--'-- p --'-- i -
2
Price per unit :!-
2
7.37-2
=pence-
.2
30th Sept 96 - 31st Dec 96!$--'-
- p --'-
- i ---'-- d \
2
[
VAT rate :+*%-
2
Z8.00- 2
[=%262
[MCustomer account number : 50641(//--'-- p --'-- i --'-- p --'-- i -
2
1Quarterly Bill:.!(Times New Roman-
2
}Total*"--'-
- p --'-
- i ---'-- id
2
s55Times New Roman-2
units at ##-
2
j7.372
=pence per unit ! !!-2
= "
2
M4.05--'-- p -2
$")
!" !")--'-- i -
-2
q1Standing quarterly charge!! ! !!-2
r= "-
2
qM8.70--'-- p --'-- i -
2
|Total %2
M12.75--'-- p --'-- i -
2
1Vat on+!-2
u12.75-2
at
2
8.00
2
M% :-2
= "
2
M1.02--'-- p --'-- i -
2
cTotal to Pay = (%"2
cM13.77--'-- p 2
@"E
!"; !"E--'-- i --'-- p --'-- i --'-- p --'-- i --'-- p -
! !@ - !$- !5l2- !C@ !C@2
@cE !Gc; !GcE- !5l-2
@cE !Gc; !GcE-
'HUUzܪMUUMUU}JJif(:IB"6% ;
e ' ' i ' p -
!C)-2
$.-2
.; !
. !
. ! !)- !,Y-2
$)"- ! !)-2
$.-2
.; !
. !
. !) !-2
@E"- !; !E-2
@E- !E !;-2
@YJ^-2
JY;^ !TJ !^J !T; !^E-2
@YEc- !T; !^E-2
@J-2
J; !J !J !E !;-2
@YEc- !^; !TE-2
$)- !) !-2
@E- !E !;-2
@E- !E !; !@ !CE-2
;E- !; !;- !,l !, !,
- !WE-2
;E- !; !;- !B-2
;YE^- !^; !T;-2
;E- !; !; !@ -'- i Arial--"System-'-- i Arial-Times New Roman---'-- Cd
2
1S>> You can adjust the numbers in the GREEN boxes, and see the effect on the bill <<""+!! !!!!0 !!.+((+ ! !!! ""--'-- p --'-- i Wingdings---'-- d H
2
?X:qArials---'-- H
2
XBSESA<<<---'-- d H
2
?f:q-32
sMFor electricity supplied to :%! --'-- p --'-- i Times New Roman-
:2
J"Broadoak School Electricity Supply!
Arial-
"2
L3, Fictitious Road$--'-
- p --'-
- i -
2
#1Meter Readings :9+ !-
!2
,LWeston-super-Mare2)--'-
- p
!C$--'-
- i Times New Roman-
2
s Present :!-2
r50000-2
s=units-
2
{LNorth Somerset$!(--'-
- p
!C0--'-
- i -
2
Previous :!-2
49945-2
=unitsArialG-2
LFor the period--'-- p --'-- i -
2
Price per unit :!-
2
7.37-2
=pence-
.2
30th Sept 96 - 31st Dec 96!$--'-
- p --'-
- i ---'-- d \
2
[
VAT rate :+*%-
2
Z8.00- 2
[=%262
[MCustomer account number : 50641(//--'-- p --'-- i --'-- p --'-- i -
2
1Quarterly Bill:.!(Times New Roman-
2
}Total*"--'-
- p --'-
- i ---'-- id
2
s55Times New Roman-2
units at ##-
2
j7.372
=pence per unit ! !!-2
= "
2
M4.05--'-- p -2
$")
!" !")--'-- i -
-2
q1Standing quarterly charge!! ! !!-2
r= "-
2
qM8.70--'-- p --'-- i -
2
|Total %2
M12.75--'-- p --'-- i -
2
1Vat on+!-2
u12.75-2
at
2
8.00
2
M% :-2
= "
2
M1.02--'-- p --'-- i -
2
cTotal to Pay = (%"2
cM13.77--'-- p 2
@"E
!"; !"E--'-- i --'-- p --'-- i --'-- p --'-- i --'-- p -
! !@ - !$- !5l2- !C@ !C@2
@cE !Gc; !GcE- !5l-2
@cE !Gc; !GcE-
'HUUzܪMUUMUU}JJ' p -
!C)-2
$.BGW_`aiu.fhXYxy"#st#%NS 8 b l
(Pl n
!
)
5
H
J
K
M
O
P
o
p
MOPop&(DEde
8
9
b
c
34STos~ JN
p:R '+67@AMNOPbcklrtJcfhXs#%1 3 5 8 l n H
J
M
O
MO&(ŽztoŽ'T&''h'th'h'th'|h& '8'8't'\h'<h'(h'
'h& ' ( ) '`'\'|&'()/+(D
b
3oqs~)+nprt㺴''T&'h'th'h'th'|h& '\h'8'8't
TNR Normal9$$F 9
tEKl Jc234(t565Times New Roman Symbol&ArialTechnicalTt//$Ee"B4
%Bb999999999999999999"$7@K "h2
3
3
3+Andy DarvillAndy Darvill