|
CITY OF PEQUOT LAKES Budget Worksheet - 2012 Preliminary Budget Page: 17
<br />Period: 09/11 Oct 17, 2011 01:14PM
<br />01/11-09/11 2011 2012
<br />Current year Current year Preliminary Budget Budget
<br />Account Number Account Title Actual Budget Budget Variance Variance%
<br />WATER FUND
<br />INTERGOVERNMENTAL REVENUES
<br />601 - 33401 -000 PERA AID
<br />21
<br />.00
<br />.00
<br />.00
<br />.00
<br />Total INTERGOVERNMENTAL REVENUES:
<br />21
<br />.00
<br />.00
<br />.00
<br />.00
<br />ASSESSMENTS /P RI N C I PALJI N TE REST
<br />601 - 36101 -000 SPECIAL ASSESSMENTS
<br />32
<br />.00
<br />.00
<br />.00
<br />.00
<br />601 - 36203 -000 MISCELLANEOUS REVENUE
<br />217
<br />.00
<br />.00
<br />.00
<br />.00
<br />601 - 36210 -000 INTEREST EARNINGS
<br />4,102
<br />8,800
<br />5,500 (
<br />3,300)
<br />- 60.00%
<br />Total ASSESSMENTS /PRINCIPAUINTEREST:
<br />4,351
<br />8,800
<br />5,500 (
<br />3,300)
<br />- 60.00%
<br />WATER SALES
<br />601 - 37110 -000 WATER SALES
<br />167,771
<br />221,980
<br />214,970 (
<br />7,010)
<br />-3.26%
<br />Budget notes:
<br />-2012 PER RATE STUDY
<br />601 - 37171 -000 STATE SALES TAX COLLECTED
<br />3,362
<br />.00
<br />4,000
<br />4,000
<br />100.00%
<br />601- 37172 -000 WATER METER FEES
<br />9,144
<br />10,750
<br />11,220
<br />470
<br />4.19%
<br />Budget notes:
<br />-2012 PER RATE STUDY
<br />Total WATER SALES:
<br />180,277
<br />232,730
<br />230,190 (
<br />2,540)
<br />-1.10%
<br />`ETHER FINANCING SOURCES
<br />601- 39990 -000 REFUNDS & REIMBURSEMENTS
<br />2,460
<br />.00
<br />.00
<br />.00
<br />.00
<br />Total OTHER FINANCING SOURCES:
<br />2,460
<br />.00
<br />.00
<br />.00
<br />.00
<br />TRANSFERS TO OTHER FUNDS
<br />601 -49350 -720 TRANSFERS
<br />465
<br />.00
<br />.00
<br />.00
<br />.00
<br />Total TRANSFERS TO OTHER FUNDS:
<br />465
<br />.00
<br />.00
<br />.00
<br />.00
<br />WATER
<br />601 -49400 -100 WAGES
<br />18,227
<br />47,700
<br />16,470 (
<br />31,230)
<br />- 189.62%
<br />Budget notes:
<br />•-2012 1.25% INCREASE
<br />601 -49400 -121 EMPLOYER SHARE - PERA
<br />1,185
<br />3,290
<br />1,190 (
<br />2,100)
<br />- 176.47%
<br />601 -49400 -122 EMPLOYER SHARE - FICA
<br />1,089
<br />2,960
<br />1,030 (
<br />1,930)
<br />- 187.38%
<br />601 -49400 -125 EMPLOYER SHARE - MEDICARE
<br />270
<br />700
<br />240 (
<br />460)
<br />- 191.67%
<br />601 -49400 -131 EMPLOYER SHARE - HEALTH INSURA
<br />2,973
<br />6,200
<br />3,260 (
<br />2,940)
<br />- 90.18%
<br />Budget notes:
<br />-2012 0% INCREASE
<br />601 -49400 -133 EMPLOYER SHARE - LIFE INSURANC
<br />23
<br />70
<br />20 (
<br />50)
<br />- 250.00%
<br />601 -49400 -200 OFFICE SUPPLIES
<br />115
<br />350
<br />500
<br />150
<br />30.00%
<br />601 -49400 -210 OPERATING SUPPLIES
<br />5,236
<br />6,500
<br />6,500
<br />.00
<br />.00
<br />Budget notes:
<br />-2012 WATER SERVICE REPAIR PARTS, EQUIP & BLDG MAINT SUPPLIES
<br />601 -49400 -217 CLOTHING ALLOWANCE
<br />.00
<br />100
<br />100
<br />.00
<br />.00
<br />601 -49400 -303 ENGINEERING FEES
<br />736
<br />1,000
<br />5,000
<br />4,000
<br />80.00%
<br />Budget notes:
<br />-2012 GOVERNMENT DR PROJECT
<br />`601
<br />-49400 -304 LEGAL FEES
<br />345
<br />500
<br />1,500
<br />1,000
<br />66.67%
<br />Budget notes:
<br />-2012 GOVERNMENT DR
<br />
|