|
CITY OF PEQUOT LAKES Budget Worksheet - 2012 Preliminary Budget
<br />Period: 09/11
<br />Oct 17, 2011
<br />Page: 6
<br />01:14PM
<br />01/11-09/11
<br />2011
<br />2012
<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 Variance%
<br />ROADS & STREETS
<br />101 -43100 -100 WAGES
<br />90,860
<br />95,350
<br />119,320
<br />23,970
<br />20.09%
<br />Budget notes:
<br />2012 1.25% INCREASE, 50 OT HRS FOR EA EMPLOYEE, JOB PT CHANGES FOR MAINT WORKERS
<br />101 -43100 -121 EMPLOYER SHARE - PERA
<br />6,589
<br />6,920
<br />8,650
<br />1,730
<br />20.00%
<br />101 - 43100 -122 EMPLOYER SHARE - FICA
<br />5,309
<br />5,920
<br />7,400
<br />1,480
<br />20.00%
<br />101 -43100 -125 EMPLOYER SHARE - MEDICARE
<br />1,278
<br />1,390
<br />1,730
<br />340
<br />19.65%
<br />101 -43100 -131 EMPLOYER SHARE - HEALTH INSURA
<br />26,422
<br />27,640
<br />29,640
<br />2,000
<br />6.75%
<br />Budget notes:
<br />-2012 0% INCREASE
<br />101 - 43100 -133 EMPLOYER SHARE - LIFE INSURANC
<br />108
<br />130
<br />140
<br />10
<br />7.14%
<br />101 -43100 -200 OFFICE SUPPLIES
<br />39
<br />200
<br />200
<br />.00
<br />.00
<br />101 -43100 -210 OPERATING SUPPLIES
<br />11,172
<br />6,200
<br />9,000
<br />2,800
<br />31.11%
<br />Budget notes:
<br />-2012 GRAVEL, SALT, SAND, POTHOLE PATCH, REPAIR PARTS
<br />101 -43100 -217 CLOTHING ALLOWANCE
<br />32
<br />600
<br />400
<br />( 200)
<br />- 50.00%
<br />101 -43100 -303 ENGINEERING FEES
<br />25,579
<br />22,000
<br />20,000
<br />( 2,000)
<br />- 10.00%
<br />101 -43100 -304 LEGAL FEES
<br />367
<br />3,000
<br />1,600
<br />( 1,400)
<br />- 87.50%
<br />101 - 43100 -305 MEDICAL
<br />.00
<br />250
<br />250
<br />.00
<br />.00
<br />101 -43100 -308 TRAVEL/CONFERENCES /SCHOOLS
<br />110
<br />300
<br />300
<br />.00
<br />.00
<br />101 - 43100 -311 RISK MANAGEMENT
<br />134
<br />1,500
<br />465
<br />( 1,035)
<br />- 222.58%
<br />101 - 43100 -313 CONTRACT SERVICES
<br />10,058
<br />19,500
<br />18,000
<br />( 1,500)
<br />-8.33%
<br />Budget notes:
<br />-2012 PAINTING LINES, CALCIUM CHLORIDE, STREET SWEEPING, CRACKFILLING
<br />01 -43100 -321 TELEPHONE
<br />875
<br />1,200
<br />1,200
<br />.00
<br />.00
<br />`
<br />.1►t01 -43100 -322 POSTAGE
<br />.00
<br />100
<br />100
<br />.00
<br />.00
<br />101 - 43100 -334 FUEL
<br />9,003
<br />9,000
<br />10,000
<br />1,000
<br />10.00%
<br />101 -43100 -350 PUBLISHING
<br />40
<br />1,000
<br />500
<br />( 500)
<br />- 100.00%
<br />101- 43100 -360 INSURANCE
<br />230
<br />.00
<br />.00
<br />.00
<br />.00
<br />101 - 43100 -384 SANITATION
<br />1,150
<br />1,600
<br />1,200
<br />( 400)
<br />- 33.33%
<br />101 - 43100400 REPAIR/MAINTENANCE /SERVICES
<br />10,535
<br />15,000
<br />12,000
<br />( 3,000)
<br />- 25.00%
<br />Budget notes:
<br />-2012 ALL R &S VEHICLE & EQUIPMENT REPAIRS
<br />101 - 43100 -433 DUES /LICENSING /SUBSCRIPTIONS
<br />142
<br />300
<br />300
<br />.00
<br />.00
<br />101 - 43100 -500 CAPITAL OUTLAY
<br />.00
<br />250,000
<br />247,000
<br />( 3,000)
<br />-1.21%
<br />Budget notes:
<br />-2012 OVERLAY GOVERNMENT DR &/OR RE -BUILD OLD HWY 371
<br />101-43100-501 CAPITAL OUTLAY CARRYOVER
<br />.00
<br />10,000
<br />10,000
<br />.00
<br />.00
<br />Budget notes:
<br />2012 TRACTOR/MOWER/BLOWER/BROOM COMBO UNIT
<br />Total ROADS & STREETS:
<br />200,032
<br />479,100
<br />499,395
<br />20,295
<br />4.06%
<br />STREET LIGHTING
<br />101-43160-381 ELECTRICITY
<br />8,696
<br />13,750
<br />13,750
<br />.00
<br />.00
<br />10143160 -400 REPAIR/MAINTENANCE /SERVICES
<br />271
<br />650
<br />650
<br />.00
<br />.00
<br />Total STREET LIGHTING:
<br />8,966
<br />14,400
<br />14,400
<br />.00
<br />.00
<br />SIGNAL & SIGNS
<br />101 -43161 -210 OPERATING SUPPLIES
<br />2,711
<br />3,500
<br />2,500
<br />( 1,000)
<br />- 40.00%
<br />Budget notes:
<br />-2012 UPDATE STREET & TRAFFIC SIGNS PER STATUTE
<br />X01 -43161 -381 ELECTRICITY
<br />1,620
<br />2,800
<br />2,800
<br />.00
<br />.00
<br />101- 43161 -400 REPAIR/MAINTENANCE /SERVICES
<br />355
<br />750
<br />750
<br />.00
<br />.00
<br />
|