|
CITY OF PEQUOT LAKES
<br />Budget Worksheet - 2010 Year End Report
<br />Period: 14/10
<br />Account Number Account Title
<br />WATER FUND
<br />INTERGOVERNMENTAL REVENUES
<br />601 -33401 -000
<br />PERA AID
<br />Total INTERGOVERNMENTAL REVENUES:
<br />ASSESSMENTS /PRINCIPAL/INTEREST
<br />601 - 36101 -000
<br />SPECIAL ASSESSMENTS
<br />601 - 36203 -000
<br />MISCELLANEOUS REVENUE
<br />601 - 36210 -000
<br />INTEREST EARNINGS
<br />Total ASSESSMENTS /PRINCIPAL/INTEREST:
<br />7,977
<br />WATER SALES
<br />23
<br />601 - 37110 -000
<br />WATER SALES
<br />601 - 37171 -000
<br />STATE SALES TAX COLLECTED
<br />601 - 37172 -000
<br />WATER METER FEES
<br />Total WATER SALES:
<br />8
<br />OTHER FINANCING SOURCES
<br />707
<br />601 - 39990 -000
<br />REFUNDS & REIMBURSEMENTS
<br />Account notes:
<br />8,110
<br />insurance dividend, state test fees
<br />Total OTHER FINANCING
<br />SOURCES:
<br />WATER
<br />100 (
<br />601 -49400 -100
<br />WAGES
<br />601 -49400 -121
<br />EMPLOYER SHARE - PERA
<br />601 -49400 -122
<br />EMPLOYER SHARE - FICA
<br />601 -49400 -125
<br />EMPLOYER SHARE - MEDICARE
<br />601 -49400 -131
<br />EMPLOYER SHARE - HEALTH INSURA
<br />601 -49400 -133
<br />EMPLOYER SHARE - LIFE INSURANC
<br />601 -49400 -200
<br />OFFICE SUPPLIES
<br />601 -49400 -210
<br />OPERATING SUPPLIES
<br />Account notes:
<br />126.91%
<br />extra water repairs & water meter supplies
<br />601 -49400 -217
<br />CLOTHING ALLOWANCE
<br />601 -49400 -303
<br />ENGINEERING FEES
<br />601 -49400 -304
<br />LEGAL FEES
<br />601 -49400 -305
<br />MEDICAL
<br />601 -49400 -308
<br />TRAVEL/CONFERENCES /SCHOOLS
<br />Account notes:
<br />1,099
<br />extra training for operator
<br />601 -49400 -310
<br />SALES & USE TAX
<br />601 -49400 -311
<br />RISK MANAGEMENT
<br />601 -49400 -313
<br />CONTRACT SERVICES
<br />601 -49400 -321
<br />TELEPHONE
<br />601 -49400 -322
<br />POSTAGE
<br />601 -49400 -334
<br />FUEL
<br />601 -49400 -350
<br />PUBLISHING
<br />601 -49400 -360
<br />INSURANCE
<br />601 -49400 -381
<br />ELECTRICITY
<br />601 49400 -383
<br />HEATING
<br />601 -49400 -386
<br />WELLHEAD PROTECTION
<br />Page: 26
<br />May 24, 2011 10:31AM
<br />2010 2010 Budget Budget
<br />Actual Budget Variance Variance%
<br />76 .00 ( 76) .00
<br />76 .00 ( 76) .00
<br />( 438)
<br />.00
<br />438
<br />.00
<br />130
<br />.00 (
<br />130)
<br />.00
<br />8,285
<br />8,000 (
<br />285)
<br />103.56%
<br />7,977
<br />8,000
<br />23
<br />99.72%
<br />214,494 216,670 2,176 99.00%
<br />19 .00 ( 19) .00
<br />13,051 10,270 ( 2,781) 127.08%
<br />227,564
<br />226,940 (
<br />624)
<br />100.27%
<br />2,968
<br />.00 (
<br />2,968)
<br />.00
<br />2,968 .00 ( 2,968) .00
<br />50,253
<br />47,150 (
<br />3,103)
<br />106.58%
<br />3,034
<br />3,140
<br />106
<br />96.63%
<br />2,779
<br />2,930
<br />151
<br />94.85%
<br />640
<br />690
<br />50
<br />92.82%
<br />5,448
<br />5,450
<br />2
<br />99.96%
<br />52
<br />60
<br />8
<br />87.00%
<br />707
<br />500 (
<br />207)
<br />141.49%
<br />8,110
<br />2,700 (
<br />5,410)
<br />300.37%
<br />102
<br />100 (
<br />2)
<br />101.97%
<br />247
<br />2,000
<br />1,753
<br />12.33%
<br />30
<br />500
<br />470
<br />6.00%
<br />.00
<br />200
<br />200
<br />.00
<br />635
<br />500 (
<br />135)
<br />126.91%
<br />128
<br />300
<br />172
<br />42.67%
<br />111
<br />350
<br />239
<br />31.67%
<br />4,988
<br />6,160
<br />1,172
<br />80.97%
<br />1,099
<br />1,000 (
<br />99)
<br />109.93%
<br />1,080
<br />1,500
<br />420
<br />72.01%
<br />1,533
<br />800 (
<br />733)
<br />191.61%
<br />292
<br />350
<br />58
<br />83.31%
<br />5,284
<br />6,600
<br />1,316
<br />80.06%
<br />10,369
<br />10,000 (
<br />369)
<br />103.69%
<br />1,668
<br />2,500
<br />832
<br />66.74%
<br />.00
<br />500
<br />500
<br />.00
<br />
|