PAGE

PAGE

2

HUDUTILITYMODELINSTRUCTIONS

I. Introduction

TheHUDUtilityScheduleModelhasbeendevelopedtoprovideaconsistentbasisfordeterminingutilityschedules,usingformHUD-52667,throughouttheU.S.ThisspreadsheetmodelisorganizedintoseveraltabsandwasdesignedtoworkwithMicrosoftExcel2000and2003althoughitmayalsoworkwithotherspreadsheetsincludingolderversionsofExcel.

Eachfirsttimeusermustcompletetheentriesonthe“Location”tabandthe“Tariffs”tabofthespreadsheetmodel.Entriesareshownascellswithawhitebackgroundandaresurroundedbycellswithagreybackground.Theresultingformsareontabswith“52667”aspartoftheirname.Whenyouprintfromthe“52667”tabs,theentirepageisnotprinted,onlytheutilityschedule.Fourdifferent“52667”formsareincludedbutyoucanaddmoreorremoveanythatyoudon’twant.Nochangestothe“52667”tabsareneededexceptforselectingtheUnitType,thetypeofElectricTariff,kindofElectricHeating,andAgeofDwelling.Valuescannotbeentereddirectlyontheform.Theyarebasedonthecalculationsshowntotherightandbelowtheform.

Thesummarytabshowsthetotalallowancesforalargenumberofcommoncases.Itcanbeusedtoseetheoverallimpactofaratechange.

Almostallthecalculationsareperformedonthe“52667”tabs.Themainformisintheupperlefthandcorneroftheworksheettabbutbelowitandtotherightarethecalculations.Theyareshowninastep-by-stepfashiontomakeitclearhowthecalculationswereperformed.Thesecalculationscannotbechanged,theytakethevaluesyouhaveenteredonthe“Location”and“Tariffs”tabsandsimplyperformthecalculations.

II. DetailedInstructions

ThefollowingsectionsarerelatedtothesectionsoneachofthetabsoftheHUDUtilityScheduleModel.Remember,theinputisonthe“Location”tab,“Tariffs”tab,andjustfourplacesatthetopofthe“52667”tabs.Nootherinputsorchangesarepermitted.

HelpontheLocationTab

Thefirsttimeyouusethespreadsheetyouwillneedtoentersomevaluesonthe“Location”tab,butafterthatmostofthevalueswillnotneedtochangeexceptforthe“FormDate.”The“FormDate”isthedatethatyouwantshownonthe“52667”forms.

1.GeneralInformationontheLocationTab–Thefirstsectionofthe“Location”tabisfor“GeneralInformation”andcontainsitemsthatapplytoallHUD-52667formsinthespreadsheet.

NameofHousingAuthority-enterthenamethatyouwanttoappearontheHUD-52667forms.ThiscaneithersignifyaHousingAuthority,ahousingprojectname,oranareaname.Thisentrywillbeautomaticallyputoneachcopyoftheformunderthework“Locality”.Unlessthenamechanges,itisunlikelythatyouwillneedtoalterthisvalue.

FormDate–enterthedatethatyouwanttoappearonthecompletedforms.Thisdateisoftenthedatetheformgoesintoeffect,orthedatetheformwaslastchanged.Thisentryislikelytochangeeverytimethespreadsheetisupdated.

IncludeAllowanceforAirConditioning–checktheboxifyourhousingauthoritynormallyincludesanallowancefortheelectricityconsumptionassociatedwithprovidingairconditioning.Dependingonthelocationandtheclimate,thisisnormallychecked.

2.ClimateDataontheLocationTab–The“ClimateDataontheLocationtabcanbequicklygatheredfromthecompanionspreadsheettoolcalledZipCodeToDegreeDays.Selectthelocationclosesttoyourhousingauthorityusingzipcodeinformation.Attimesmultipleweathermonitoringsiteswillbeavailable;selectthesitethatisclosesttothepopulationservedbythehousingauthorityorthemostwellknownmonitoringlocation.DatafromtheZipCodeToDegreeDaysspreadsheetcanbecopiedandpasteddirectlyontothe“Location”tabusingthe[Edit][PasteSpecial][Values]menuiteminExcel.

IfyouprefertoenterdatadirectlyintotheClimateDataareaofthe“l(fā)ocation”tab,youcandothatalso.Youonlyneedtoenterdataintothefieldsshowas“required”sincetheyaretheonlyonesintheClimateDataSectionthatareusedbytherestofthespreadsheet.Ifyoudoenterthemonthlydegreedaydataandannualdegreedaydata,thecalculatedfieldsatthebottomoftheentryarea“checkofHDD”and“checkofCDD”willindicateifthemonthlyvaluesadduptotheannualvaluebyshowingazerodifference.

HelponTariffsTab

Amajorityoftheeffortinusingthismodelistoupdatetheratespaidforutilities.Thisisthepurposeofthe“Tariffs”tab.The“Tariffs”taballowsyoutoupdatethetariffsforelectricity,naturalgasfueloil,liquefiedpetroleumgas(LPG),water,sewer,trashandcertainappliancefees.ThetabhascolumnsfortheCurrentandPreviousvaluesforalmostalloftheentries.OnlytheentriesundertheCurrentcolumnareusedintherestofthespreadsheetandgetusedincalculatingthevaluesthatappearontheforms.TheentriesinthePreviouscolumnareignoredandarethereonlyforreferenceandtodeterminehowmuchthetariffhaschanged.Allenergyandnon-energyrelatedcostsareaenteredonthistab.Mostutilitiesallowyoutodownloadatarifforratebookfromtheirwebsite.Afteryoudothis,getabilltouseasanexampleanddetermineallofthecomponentsthatmakeupthebill.Attimesthetariffisbrokenintoamaintariffandmanyriders.Someutilitiesdescribetaxesintheratebookandsomedonot,sochecktheexamplebill.

Insomelocations,utilitieshavebecomederegulatedandmultiplecompaniesmaybeinvolvedinprovidingthisservice.Thisisespeciallylikelyfornaturalgasandelectricutilities.Whilethespreadsheetdoesnothaveanyspecificentriesforderegulatedutilities,itiseasytousethespreadsheetwiththem.Toenterderegulatedutilities,simplyaddupthechargesforeachkWhorotherunitofmeasureandenterthecombinedtotal.Forexample,ifanelectricgeneratingcompanycharges4centsperkWhandtheelectricdistributioncompanycharges3centsperkWh,simplyaddthetwochargestogetherfor7centsperkWh.Ifthecompanieshavemultipleblockrates,thesechargesneedtobecombinedforeachrateblock.

1.StandardElectricUtilityTariff–

UtilityNameandRateName–enterthenameoranabbreviationofthenamefortheutilitythatprovideselectricityandforthespecificratetobeusedinthecalculations.Manyutilitieshavemultipleratesthatcouldbeusedbyresidentialcustomersandyoushouldchooseonethatisthemosttypical.

RateEffectiveDate–oftenutilitieswillusethesamenameforatariffeventhoughtheymaychangethevalues.Enteringaneffectivedateherewillallowyoutounderstandwhatversionofthetariffyouareusing.

FirstMonthofSummerandLastMonthofSummer–selectfromthepulldownliststhemonthsthatarethefirstandlastmonthsofthesummerperiodasdefinedintheelectrictariff.Ifthetariffdoesnotvarybyseason,useonlythe“summer”blocksandsetthesummerperiodfromJanuarythroughDecember.Ifthetariffisseasonalbutstartsmid-month,makesurethenumberofmonthsinthetariffthataresummerandthenumberofmonthshereareequivalentsincethenumberofmonthsismoreimportantthanexactlywhenineachmonththetariffchanges.IfyourspreadsheetprogramisnotExcel,youmaynotseethedropdownlistofchoices.Ifthatisthecase,justenterthemonthnumberintherowsbeloweachinput.

MonthlyCharges–enterthevaluechargedforelectricservice.Thisissometimescalledamonthlychargeoraservicecharge.

SizeofXXXBlock–Thisentryisrepeatedforthefirst,second,thirdandfourthblocksofthetariffinthesummerandinthewinter.Ifthetariffdoesnothaveblockratesthatvarybyseason,thenonlyentervaluesforthesummerentries.Thesizeofablockisimportantfortariffsthathave“stepped”blocks.AsteppedtariffchargesacertainamountforeachkWhinthefirstgroupofkWh,anddifferentchargesforgreateruse.Theyareoftenexpressedas5centsperkWhforthefirst500kWhand4centsperkWhfortheremainingkWh.Forthiscaseyouwouldenter“500”inthe“SizeofFirstBlock”and“remaining”inthe“SizeoftheSecondBlock”.Youcouldalsoenteralargenumberinsteadoftheword“remaining”inthe“SizeoftheSecondBlock”field,whichwillindicatethattherestofthekWhshouldbechargedatthatprice.Sincesomeutilitieshavemultipleblocksintheirtariffs,uptofourblocksareprovided.Ifmoreblocksarepartofthetariff,averagethecostofsomeoftheblockstogetherandcombinetheirsizes.Iftherateisnotasteppedrate,entervaluesforthefirstblockonly.

CostofXXXBlock–Thisentryisrepeatedforthefirst,second,third,andfourthblocksofthetariffinthesummerandinthewinter.Ifthetariffdoesnothaveblocksthatvarybyseason,onlyentervaluesforthesummerentries.Thecostofablockisimportantfortariffsthathave“stepped”blocks.AsteppedtariffchargesacertainamountforeachkWhinthefirstgroupofkWh,anddifferentchargesforgreateruse.Theyareoftenexpressedas5centsperkWhforthefirst500kWhand4centsperkWhfortheremainingkWh.Forthiscaseyouwouldenter0.05inthe“CostofFirstBlock”a0.04inthe“CostoftheSecondBlock”.Sincesomeutilitieshavemultipleblocksintheirtariffs,uptofourblocksareprovided.Ifmoreblocksarepartofthetariff,averagethecostofsomeoftheblockstogetherandcombinetheirsizes.Iftherateisnotasteppedrate,entervaluesforthefirstblockonly.Ifmultiplecompaniesareinvolvedinprovidingtheutilityservice,suchaswhentheutilitiesarederegulated,thenaddupthecostsforeachcompanyforthatblock.

ExtraCharges–AnextrafeethatischargedbytheutilityforeverykWhthatissold.Thisisoftenexpressedasafuelcostadjustment,anenergycostadjustment,orasurcharge.Creditsareoftenexpressedasafuelcostadjustment,anenergycostadjustmentorasurcharge.CreditsareoftenprovidedonthebasisofeverykWhandcanbeenteredasnegativenumbers.Ifmultipleextrachargesexistinthetariff,thenaddthemup.

Taxes–Thisisexpressedasawholenumberpercent.Don’tformatthecellinExcelasa“percent”format.Fora3%taxsimplyenter3.Thetaxiscalculatedaftercalculatingasubtotalthatincludestheblockcharges,themonthlychargeandtheextracharges.

2.SpecialElectricHeating/AllElectricTariff–

UseElectricHeatTariff–someutilitieshavespecialdiscountedtariffsforcustomersthatheatwithelectricityoruseonlyelectricityandnoothersourceofenergyintheirhomes.Ifthatisthecase,andyouwanttoprovidespecial52667formsforthosecustomers,checkthisbox.Youmayneedtomakemorecopiesofthe52667tabsandspecifythatsomeusethespecialelectricheatingrate.

UtilityNameandRateName–enterthenameoranabbreviationofthenamefortheutilitythatprovideselectricityandforthespecificratetobeusedinthecalculations.Manyutilitieshavemultipleratesthatcouldbeusedbyresidentialcustomersandyoushouldchooseonethatisthemosttypical.

RateEffectiveDate–oftenutilitieswillusethesamenameforatariffeventhoughtheymaychangethevalues.Enteringaneffectivedateherewillallowyoutounderstandwhatversionofthetariffyouareusing.

FirstMonthofSummerandLastMonthofSummer–selectfromthepulldownliststhemonthsthatarethefirstandlastmonthsofthesummerperiodasdefinedintheelectrictariff.Ifthetariffdoesnotvarybyseason,useonlythe“summer”blocksandsetthesummerperiodfromJanuarythroughDecember.Ifthetariffisseasonalbutstartsmid-month,makesurethenumberofmonthsinthetariffthataresummerandthenumberofmonthshereareequivalentsincethenumberofmonthsismoreimportantthanexactlywhenineachmonththetariffchanges.IfyourspreadsheetprogramisnotExcel,youmaynotseethedropdownlistofchoices.Ifthatisthecase,justenterthemonthnumberintherowsbeloweachinput.

MonthlyCharges–enterthevaluechargedforelectricservice.Thisissometimescalledamonthlychargeoraservicecharge.

SizeofXXXBlock–Thisentryisrepeatedforthefirst,second,thirdandfourthblocksofthetariffinthesummerandinthewinter.Ifthetariffdoesnothaveblockratesthatvarybyseason,thenonlyentervaluesforthesummerentries.Thesizeofablockisimportantfortariffsthathave“stepped”blocks.AsteppedtariffchargesacertainamountforeachkWhinthefirstgroupofkWh,anddifferentchargesforgreateruse.Theyareoftenexpressedas5centsperkWhforthefirst500kWhand4centsperkWhfortheremainingkWh.Forthiscaseyouwouldenter“500”inthe“SizeofFirstBlock”and“remaining”inthe“SizeoftheSecondBlock”.Youcouldalsoenteralargenumberinsteadoftheword“remaining”inthe“SizeoftheSecondBlock”field,whichwillindicatethattherestofthekWhshouldbechargedatthatprice.Sincesomeutilitieshavemultipleblocksintheirtariffs,uptofourblocksareprovided.Ifmoreblocksarepartofthetariff,averagethecostofsomeoftheblockstogetherandcombinetheirsizes.Iftherateisnotasteppedrate,entervaluesforthefirstblockonly.

CostofXXXBlock–Thisentryisrepeatedforthefirst,second,third,andfourthblocksofthetariffinthesummerandinthewinter.Ifthetariffdoesnothaveblocksthatvarybyseason,onlyentervaluesforthesummerentries.Thecostofablockisimportantfortariffsthathave“stepped”blocks.AsteppedtariffchargesacertainamountforeachkWhinthefirstgroupofkWh,anddifferentchargesforgreateruse.Theyareoftenexpressedas5centsperkWhforthefirst500kWhand4centsperkWhfortheremainingkWh.Forthiscaseyouwouldenter0.05inthe“CostofFirstBlock”a0.04inthe“CostoftheSecondBlock”.Sincesomeutilitieshavemultipleblocksintheirtariffs,uptofourblocksareprovided.Ifmoreblocksarepartofthetariff,averagethecostofsomeoftheblockstogetherandcombinetheirsizes.Iftherateisnotasteppedrate,entervaluesforthefirstblockonly.Ifmultiplecompaniesareinvolvedinprovidingtheutilityservice,suchaswhentheutilitiesarederegulated,thenaddupthecostsforeachcompanyforthatblock.

ExtraCharges–AnextrafeethatischargedbytheutilityforeverykWhthatissold.Thisisoftenexpressedasafuelcostadjustment,anenergycostadjustment,orasurcharge.Creditsareoftenexpressedasafuelcostadjustment,anenergycostadjustmentorasurcharge.CreditsareoftenprovidedonthebasisofeverykWhandcanbeenteredasnegativenumbers.Ifmultipleextrachargesexistinthetariff,thenaddthemup.

Taxes–Thisisexpressedasawholenumberpercent.Don’tformatthecellinExcelasa“percent”format.Fora3%taxsimplyenter3.Thetaxiscalculatedaftercalculatingasubtotalthatincludestheblockcharges,themonthlychargeandtheextracharges.

3.StandardNaturalGasUtilityTariff–

UtilityNameandRateName–enterthenameoranabbreviationofthenamefortheutilitythatprovidesnaturalgasandforthespecificratetobeusedinthecalculations.Manyutilitieshavemultipleratesthatcouldbeusedbyresidentialcustomersandyoushouldchooseonethatisthemosttypical.

RateEffectiveDate–oftenutilitieswillusethesamenameforatariffeventhoughtheymaychangethevalues.Enteringaneffectivedateherewillallowyoutounderstandwhatversionofthetariffyouareusing.

MeasurementUnits–naturalgasutilitiesprovidenaturalgasonthebasisofoneofseveraldifferentunits.Selecttheunitsusedbytheutilityintherate.Noticethattheunitscorrespondinglychangeonmanyoftheremainingfieldsinthetariff.Changingthemeasurementunitswillnotchangethevaluesenteredintherestoftherate.IfyourspreadsheetprogramisnotExcelandthepulldownlistisnotseen,enter1fortherms,2forCCF,3forMCF,and4forMMBtu.

FirstMonthofSummerandLastMonthofSummer–selectfromthepulldownliststhemonthsthatarethefirstandlastmonthsofthesummerperiodasdefinedinthenaturalgastariff.Ifthetariffdoesnotvarybyseason,useonlythe“summer”blocksandsetthesummerperiodfromJanuarythroughDecember.Ifthetariffisseasonalbutstartsmid-month,makesurethenumberofmonthsinthetariffthataresummerandthenumberofmonthshereareequivalentsincethenumberofmonthsismoreimportantthanexactlywhenineachmonththetariffchanges.IfyourspreadsheetprogramisnotExcel,youmaynotseethedropdownlistofchoices.Ifthatisthecase,justenterthemonthnumberintherowsbeloweachinput.

MonthlyCharges–enterthevaluechargedfornaturalgasservice.Thisissometimescalledamonthlychargeoraservicecharge.

SizeofXXXBlock–Thisentryisrepeatedforthefirst,second,thirdandfourthblocksofthetariffinthesummerandinthewinter.Ifthetariffdoesnothaveblockratesthatvarybyseason,thenonlyentervaluesforthesummerentries.Thesizeofablockisimportantfortariffsthathave“stepped”blocks.Asteppedtariffchargesacertainamountforeachtherminthefirstgroupoftherms,anddifferentchargesforgreateruse.Theyareoftenexpressedas80centsperthermforthefirst10thermsand70centsperthermfortheremainingtherms.Forthiscaseyouwouldenter“10”inthe“SizeofFirstBlock”and“remaining”inthe“SizeoftheSecondBlock”.Youcouldalsoenteralargenumberinsteadoftheword“remaining”inthe“SizeoftheSecondBlock”field,whichwillindicatethattherestofthethermsshouldbechargedatthatprice.Sincesomeutilitieshavemultipleblocksintheirtariffs,uptofourblocksareprovided.Ifmoreblocksarepartofthetariff,averagethecostofsomeoftheblockstogetherandcombinetheirsizes.Iftherateisnotasteppedrate,entervaluesforthefirstblockonly.

CostofXXXBlock–Thisentryisrepeatedforthefirst,second,third,andfourthblocksofthetariffinthesummerandinthewinter.Ifthetariffdoesnothaveblocksthatvarybyseason,onlyentervaluesforthesummerentries.Thecostofablockisimportantfortariffsthathave“stepped”blocks.Asteppedtariffchargesacertainamountforeachtherminthefirstgroupoftherms,anddifferentchargesforgreateruse.Theyareoftenexpressedas80centsperthermforthefirst10thermsand70centsperthermfortheremainingtherms.Forthiscaseyouwouldenter0.80inthe“CostofFirstBlock”a0.70inthe“CostoftheSecondBlock”.Sincesomeutilitieshavemultipleblocksintheirtariffs,uptofourblocksareprovided.Ifmoreblocksarepartofthetariff,averagethecostofsomeoftheblockstogetherandcombinetheirsizes.Iftherateisnotasteppedrate,entervaluesforthefirstblockonly.Ifmultiplecompaniesareinvolvedinprovidingtheutilityservice,suchaswhentheutilitiesarederegulated,thenaddupthecostsforeachcompanyforthatblock.

ExtraCharges–Anextrafeethatischargedbytheutilityforeverythermthatissold.Thisisoftenexpressedasafuelcostadjustment,anenergycostadjustment,orasurcharge.Creditsareoftenexpressedasafuelcostadjustment,anenergycostadjustmentorasurcharge.Creditsareoftenprovidedonthebasisofeverythermandcanbeenteredasnegativenumbers.Ifmultipleextrachargesexistinthetariff,thenaddthemup.

Taxes–Thisisexpressedasawholenumberpercent.Don’tformatthecellinExcelasa“percent”format.Fora3%taxsimplyenter3.Thetaxiscalculatedaftercalculatingasubtotalthatincludestheblockcharges,themonthlychargeandtheextracharges.

4.FuelOilDeliveryContract–

SupplierName–enterthenameoranabbreviationofthenameforthesupplierforfueloil.

EffectiveDate–enteringaneffectivedateherewillallowyoutounderstandwhatversionofthecontractyouareusing.

MonthlyCharges–entertheamountthatthefueloilsupplierchargestoprovideservice.Thisissometimecalledamonthlychargeoraservicecharge.

SizeofXXXBlock–Thisentryisrepeatedforthefirst,second,thirdandfourthblocksofthecontract.Asteppedcontractchargesacertainamountforeachgalloninthefirstgroupofgallons,anddifferentchargesforgreateruse.Theyareoftenexpressedas2.50dollarspergallonforthefirst50gallonsand2.40dollarspergallonfortheremaininggallons.Forthiscaseyouwouldenter“50”inthe“SizeofFirstBlock”and“remaining”inthe“SizeoftheSecondBlock”.Youcouldalsoenteralargenumberinsteadoftheword“remaining”inthe“SizeoftheSecondBlock”field,whichwillindicatethattherestofthegallonsshouldbechargedatthatprice.Uptofourblocksareprovided,ifmoreblocksarepartofthecontract,thenaveragethecostofsomeoftheblockstogetherandcombinetheirsizes.Iftherateisnotasteppedrate,entervaluesforthefirstblockonly.

CostofXXXBlock–Thisentryisrepeatedforthefirst,second,third,andfourthblocksofthecontract.Asteppedcontractchargesacertainamountforeachgalloninthefirstgroupofgallons,anddifferentchargesforgreateruse.Theyareoftenexpressedas2.50dollarspergallonforthefirst50gallonsand2.40dollarspergallonfortheremaininggallons.Forthiscaseyouwouldenter2.50inthe“CostofFirstBlock”a2.40inthe“CostoftheSecondBlock”.Uptofourblocksareprovided,ifmoreblocksarepartofthecontract,thenaveragethecostofsomeoftheblockstogetherandcombinetheirsizes.Iftherateisnotasteppedrate,entervaluesforthefirstblockonly.

ExtraCharges–Anextrafeethatischargedbytheutilityforeverygallonthatissold.Thisisoftenexpressedasafuelcostadjustment,anenergycostadjustment,orasurcharge.Creditsareoftenexpressedasafuelcostadjustment,anenergycostadjustmentorasurcharge.Creditsareoftenprovidedonthebasisofeverygallonandcanbeenteredasnegativenumbers.Ifmultipleextrachargesexistinthecontract,thenaddthemup.

Taxes–Thisisexpressedasawholenumberpercent.Don’tformatthecellinExcelasa“percent”format.Fora3%taxsimplyenter3.Thetaxiscalculatedaftercalculatingasubtotalthatincludestheblockcharges,themonthlychargeandtheextracharges.

5.LiquefiedPetroleumGasDeliveryContract–

SupplierName–enterthenameoranabbreviationofthenameforthesupplierforliquefiedpetroleumgas(LPG).

EffectiveDate–enteringaneffectivedateherewillallowyoutounderstandwhatversionofthecontractyouareusing.

MonthlyCharges–entertheamountthattheLPGsupplierchargestoprovideservice.Thisissometimecalledamonthlychargeoraservicecharge.

SizeofXXXBlock–Thisentryisrepeatedforthefirst,second,thirdandfourthblocksofthecontract.Asteppedcontractchargesacertainamountforeachpoundinthefirstgroupofpounds,anddifferentchargesforgreateruse.Theyareoftenexpressedas20centsperpoundforthefirst500poundsand18centsperpoundfortheremainingpounds.Forthiscaseyouwouldenter“500”inthe“SizeofFirstBlock”and“remaining”inthe“SizeoftheSecondBlock”.Youcouldalsoenteralargenumberinsteadoftheword“remaining”inthe“SizeoftheSecondBlock”field,whichwillindicatethattherestofthegallonsshouldbechargedatthatprice.Uptofourblocksareprovided,ifmoreblocksarepartofthecontract,thenaveragethecostofsomeoftheblockstogetherandcombinetheirsizes.Iftherateisnotasteppedrate,entervaluesforthefirstblockonly.

CostofXXXBlock–Thisentryisrepeatedforthefirst,second,third,andfourthblocksofthecontract.Asteppedcontractchargesacertainamountforeachpoundinthefirstgroupofpounds,anddifferentchargesforgreateruse.Theyareoftenexpressedas20centsperpoundforthefirst500poundsand18centsperpoundfortheremainingpounds.Forthiscaseyouwouldenter0.20inthe“CostofFirstBlock”a0.18inthe“CostoftheSecondBlock”.Uptofourblocksareprovided,ifmoreblocksarepartofthecontract,thenaveragethecostofsomeoftheblockstogetherandcombinetheirsizes.Iftherateisnotasteppedrate,entervaluesforthefirstblockonly.

ExtraCharges–Anextrafeethatischargedbytheutilityforeverypoundthatissold.Thisisoftenexpressedasasurcharge.Creditsareoftenprovidedonthebasisofeverypoundandcanbeenteredasnegativenumbers.Ifmultipleextrachargesexistinthecontract,thenaddthemup.

Taxes–Thisisexpressedasawholenumberpercent.Don’tformatthecellinExcelasa“percent”format.Fora3%taxsimplyenter3.Thetaxiscalculatedaftercalculatingasubtotalthatincludestheblockcharges,themonthlychargeandtheextracharges.

6.WaterSupplyUtilityTariff–

SupplierName–enterthenameoranabbreviationofthenameforthewatersupplier.

EffectiveDate–enteringaneffectivedateherewillallowyoutounderstandwhatversionofthecontractyouareusing.

MeasurementUnits–utilitiesprovidewateronthebasisofoneofseveraldifferentunits.Selecttheunitsusedbytheutilityintherate.Noticethattheunitscorrespondinglychangeonmanyoftheremainingfieldsinthetariff.Changingthemeasurementunitswillnotchangethevaluesenteredintherestoftherate.IfyourspreadsheetprogramisnotExcelandthepulldownlistisnotseen,enter1forcubicfeetand2forgallons.

MonthlyCharges–entertheamountthatthewatersupplierchargestoprovideservice.Thisissometimecalledamonthlychargeoraservicecharge.

SizeofXXXBlock–Thisentryisrepeatedforthefirst,second,thirdandfourthblocksofthetariff.Thesizeofablockisimportantfortariffsthathave“stepped”blocks.Asteppedtariffchargesacertainamountforeachcubicfootinthefirstgroupofcubicfeet,anddifferentchargesforgreateruse.Theyareoftenexpressedas5centspercubicfootforthefirst500cubicfeetand4centspercubicfootfortheremainingusage.Forthiscase