|
CITY OF PEQUOT LAKES Budget Worksheet - 2012 Preliminary Budget Page: 6
<br />Period: 07/11 Aug 11, 2011 03:18PM
<br />Budget Budget
<br />Variance Variance%
<br />23,970 20.09%
<br />1,730 20.00%
<br />1,480 20.00%
<br />340 19.65%
<br />2,000 6.75%
<br />10 7.14%
<br />.00 .00
<br />2,800 31.11%
<br />200) - 50.00%
<br />.00 .00
<br />1,000) - 50.00%
<br />.00 .00
<br />.00 .00
<br />500) - 50.00%
<br />1,500) -8.33%
<br />.00 .00
<br />.00 .0G
<br />1,000 10.00%
<br />500) - 100.00%
<br />.00 .00
<br />400) - 33.33%
<br />3,000) - 25.00%
<br />.00 .00
<br />15,000 5.66%
<br />.00 .00
<br />41,230
<br />101 -43160 -381 ELECTRICITY
<br />6,446
<br />01/11-07/11
<br />2011
<br />2012
<br />101 - 43160 -400 REPAIR/MAINTENANCE /SERVICES
<br />271
<br />Current year
<br />Current year
<br />Preliminary
<br />Account Number
<br />Account Title
<br />Actual
<br />Budget
<br />Budget
<br />ROADS & STREETS
<br />101- 43100 -100
<br />WAGES
<br />71,380
<br />95,350
<br />119,320
<br />Budget notes:
<br />-2012 1.25% INCREASE, 50 OT HRS FOR EA EMPLOYEE, JOB PT CHANGES
<br />FOR MAINT WORKERS
<br />101 -43100 -121
<br />EMPLOYER SHARE - PERA
<br />5,179
<br />6,920
<br />8,650
<br />101 -43100 -122
<br />EMPLOYER SHARE - FICA
<br />4,165
<br />5,920
<br />7,400
<br />101 -43100 -125
<br />EMPLOYER SHARE - MEDICARE
<br />1,010
<br />1,390
<br />1,730
<br />101 -43100 -131
<br />EMPLOYER SHARE - HEALTH INSURA
<br />22,234
<br />27,640
<br />29,640
<br />Budget notes:
<br />-2012 0% INCREASE
<br />101-43100-133
<br />EMPLOYER SHARE - LIFE INSURANC
<br />84
<br />130
<br />140
<br />101 - 43100 -200
<br />OFFICE SUPPLIES
<br />39
<br />200
<br />200
<br />101 -43100 -210
<br />OPERATING SUPPLIES
<br />10,376
<br />6,200
<br />9,000
<br />Budget notes:
<br />-2012 GRAVEL, SALT, SAND, POTHOLE PATCH, REPAIR PARTS
<br />101 - 43100 -217
<br />CLOTHING ALLOWANCE
<br />32
<br />600
<br />400
<br />101 -43100 -303
<br />ENGINEERING FEES
<br />25,195
<br />22,000
<br />22,000
<br />101 - 43100 -304
<br />LEGAL FEES
<br />367
<br />3,000
<br />2,000
<br />101 -43100 -305
<br />MEDICAL
<br />.00
<br />250
<br />250
<br />101 -43100 -308
<br />TRAVEL/CONFERENCES /SCHOOLS
<br />70
<br />300
<br />300
<br />101 - 43100 -311
<br />RISK MANAGEMENT
<br />110
<br />1,500
<br />1,000
<br />101-43100-313
<br />CONTRACT SERVICES
<br />9,618
<br />19,500
<br />18,000
<br />Budget notes:
<br />-2012 PAINTING LINES, CALCIUM CHLORIDE, STREET SWEEPING, CRACKFILLING
<br />101-43100-321
<br />TELEPHONE
<br />750
<br />1,200
<br />1,200
<br />101 - 43100 -322
<br />POSTAGE
<br />.00
<br />100
<br />100
<br />101 -43100 -334
<br />FUEL
<br />7,257
<br />9,000
<br />10,000
<br />10143100 -350
<br />PUBLISHING
<br />40
<br />1,000
<br />500
<br />101- 43100 -360
<br />INSURANCE
<br />230
<br />.00
<br />.00
<br />10143100 -384
<br />SANITATION
<br />728
<br />1,600
<br />1,200
<br />101 - 43100 -400
<br />REPAIR/MAINTENANCE /SERVICES
<br />6,518
<br />15,000
<br />12,000
<br />Budget notes:
<br />-2012 ALL
<br />R &S VEHICLE & EQUIPMENT REPAIRS
<br />101 - 43100 -433
<br />DUES /LICENSING /SUBSCRIPTIONS
<br />142
<br />300
<br />300
<br />101 - 43100 -500
<br />CAPITAL OUTLAY
<br />.00
<br />250,000
<br />265,000
<br />Budget notes:
<br />-2012 OVERLAY GOVERNMENT DR &/OR RE -BUILD OLD HWY 371
<br />101 - 43100 -501
<br />CAPITAL OUTLAY CARRYOVER
<br />.00
<br />10,000
<br />10,000
<br />Budget notes:
<br />-2012 TRACTOR/MOWER/BLOWER/BROOM COMBO UNIT
<br />Total ROADS & STREETS:
<br />165,523
<br />479,100
<br />520,330
<br />STREET LIGHTING
<br />Budget Budget
<br />Variance Variance%
<br />23,970 20.09%
<br />1,730 20.00%
<br />1,480 20.00%
<br />340 19.65%
<br />2,000 6.75%
<br />10 7.14%
<br />.00 .00
<br />2,800 31.11%
<br />200) - 50.00%
<br />.00 .00
<br />1,000) - 50.00%
<br />.00 .00
<br />.00 .00
<br />500) - 50.00%
<br />1,500) -8.33%
<br />.00 .00
<br />.00 .0G
<br />1,000 10.00%
<br />500) - 100.00%
<br />.00 .00
<br />400) - 33.33%
<br />3,000) - 25.00%
<br />.00 .00
<br />15,000 5.66%
<br />.00 .00
<br />41,230
<br />101 -43160 -381 ELECTRICITY
<br />6,446
<br />13,750
<br />13,750
<br />.00
<br />101 - 43160 -400 REPAIR/MAINTENANCE /SERVICES
<br />271
<br />650
<br />650
<br />.00
<br />Total STREET LIGHTING:
<br />6,717
<br />14,400
<br />14,400
<br />.00
<br />SIGNAL & SIGNS
<br />101 -43161 -210 OPERATING SUPPLIES 2,047 3,500 4,500
<br />Budget notes:
<br />-2012 UPDATE STREET & TRAFFIC SIGNS PER STATUTE
<br />101 -43161 -381 ELECTRICITY 1,207 2,800 2,800
<br />101 - 43161 -400 REPAIR/MAINTENANCE /SERVICES 355 750 750
<br />7.92%
<br />.00
<br />.00
<br />.00
<br />1,000 22.22%
<br />.00 .0
<br />.00 .00
<br />
|