|
CITY OF PEQUOT LAKES Budget Worksheet - 2011 Preliminary (9 -7 -10)
<br />Page: 20
<br />Period: 08/10
<br />Aug 30, 2010 03:31 PM
<br />01/10 -08/10
<br />2010
<br />2011
<br />Current year
<br />Current year
<br />Preliminary
<br />Budget
<br />Budget
<br />Account Number Account Title
<br />Actual
<br />Budget
<br />Budget
<br />Variance
<br />Variance%
<br />WATER FUND
<br />INTERGOVERNMENTAL REVENUES
<br />601 - 33401 -000 PERA AID
<br />38
<br />.00
<br />.00
<br />.00
<br />.00
<br />Total INTERGOVERNMENTAL REVENUES:
<br />38
<br />.00
<br />.00
<br />.00
<br />.00
<br />ASSESSMENTS/PRINCIPAL/INTEREST
<br />601 - 36101 -000 SPECIAL ASSESSMENTS
<br />197
<br />.00
<br />.00
<br />.00
<br />.00
<br />601 - 36203 -000 MISCELLANEOUS REVENUE
<br />63
<br />.00
<br />.00
<br />.00
<br />.00
<br />601 -36210 -000 INTEREST EARNINGS
<br />5,052
<br />8,000
<br />8,800
<br />800
<br />9.09%
<br />Total ASSESSMENTS /PRINCIPAL/INTEREST:
<br />5,311
<br />8,000
<br />8,800
<br />800
<br />9.09%
<br />WATER SALES
<br />601 - 37110 -000 WATER SALES
<br />126,366
<br />216,670
<br />221,980
<br />5,310
<br />2.39%
<br />601 - 37171 -000 STATE SALES TAX COLLECTED
<br />950
<br />.00
<br />.00
<br />.00
<br />.00
<br />601 - 37172 -000 WATER METER FEES
<br />7,970
<br />10,270
<br />10,750
<br />480
<br />4.47%
<br />Total WATER SALES:
<br />135,286
<br />226,940
<br />232,730
<br />5,790
<br />2.49%
<br />OTHER FINANCING SOURCES
<br />601 - 39990 -000 REFUNDS & REIMBURSEMENTS
<br />2,442
<br />.00
<br />.00
<br />.00
<br />.00
<br />Total OTHER FINANCING SOURCES:
<br />2,442
<br />.00
<br />.00
<br />.00
<br />.00
<br />WATER
<br />601 - 49400 -100 WAGES
<br />25,989
<br />47,150
<br />48,670
<br />1,520
<br />3.12%
<br />Budget notes:
<br />2011
<br />2% WAGE INCREASE, 25 OT HRS FOR WATER OPERATOR,
<br />25 OT HRS FOR PUBLIC WORKS
<br />SUP, REALLOCATION OF OFFICE
<br />ASST WAGES
<br />601 - 49400 -121 EMPLOYER SHARE - PERA
<br />1,910
<br />3,140
<br />3,360
<br />220
<br />6.55%
<br />Budget notes:
<br />-2011
<br />PERA RATE INCREASE
<br />601 -49400 -122 EMPLOYER SHARE - FICA
<br />1,746
<br />2,930
<br />3,020
<br />90
<br />2.98%
<br />601 -49400 -125 EMPLOYER SHARE - MEDICARE
<br />414
<br />690
<br />710
<br />20
<br />2.82%
<br />601 - 49400 -131 EMPLOYER SHARE - HEALTH INSURA
<br />3,632
<br />5,450
<br />6,320
<br />870
<br />13.77%
<br />601 -49400 -133 EMPLOYER SHARE - LIFE INSURANC
<br />35
<br />60
<br />70
<br />10
<br />14.29%
<br />601 - 49400 -200 OFFICE SUPPLIES
<br />123
<br />500
<br />350
<br />( 150)
<br />- 42.86%
<br />601 - 49400 -210 OPERATING SUPPLIES
<br />5,660
<br />2,700
<br />5,400
<br />2,700
<br />50.00%
<br />601 -49400 -217 CLOTHING ALLOWANCE
<br />102
<br />100
<br />100
<br />.00
<br />.00
<br />601 - 49400 -303 ENGINEERING FEES
<br />247
<br />2,000
<br />1,000
<br />( 1,000)
<br />- 100.00%
<br />601 -49400 -304 LEGAL FEES
<br />30
<br />500
<br />500
<br />.00
<br />.00
<br />601 -49400 -305 MEDICAL
<br />.00
<br />200
<br />200
<br />.00
<br />.00
<br />601 -49400 -308 TRAVEL/CONFERENCES /SCHOOLS
<br />387
<br />500
<br />500
<br />.00
<br />.00
<br />601 -49400 -310 SALES & USE TAX
<br />124
<br />300
<br />300
<br />.00
<br />.00
<br />601 -49400 -311 RISK MANAGEMENT
<br />29
<br />350
<br />200
<br />( 150)
<br />- 75.00%
<br />601 -49400 -313 CONTRACT SERVICES
<br />4,037
<br />6,160
<br />6,400
<br />240
<br />3.75%
<br />Budget notes:
<br />-2011
<br />SOFTWARE SUPPORT $900, INFRASTRUCTURE MAPPING $2,500, CIP $3,000
<br />`�i- 49400 -321 TELEPHONE
<br />638
<br />1,000
<br />1,000
<br />.00
<br />.00
<br />601 -49400 -322 POSTAGE
<br />813
<br />1,500
<br />1,200
<br />( 300)
<br />- 25.00%
<br />601 - 49400 -334 FUEL
<br />608
<br />800
<br />800
<br />.00
<br />.00
<br />
|