|
CITY OF PEQUOT LAKES Budget Worksheet - 2012 Preliminary Budget
<br />Period: 07/11
<br />Aug 04, 2011
<br />Page: 6
<br />09:51AM
<br />01/11 -07/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 />66,564
<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
<br />FOR MAINT WORKERS
<br />101 -43100 -121 EMPLOYER SHARE - PERA
<br />4,831
<br />6,920
<br />8,650
<br />1,730
<br />20.00%
<br />101 - 43100 -122 EMPLOYER SHARE - FICA
<br />3,886
<br />5,920
<br />7,400
<br />1,480
<br />20.00%
<br />101 -43100 -125 EMPLOYER SHARE - MEDICARE
<br />945
<br />1,390
<br />1,730
<br />340
<br />19.65%
<br />101 -43100 -131 EMPLOYER SHARE - HEALTH INSURA
<br />22,234
<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 />84
<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 />10,376
<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,195
<br />22,000
<br />22,000
<br />.00
<br />.00
<br />101 - 43100 -304 LEGAL FEES
<br />367
<br />3,000
<br />2,000
<br />( 1,000)
<br />- 50.00%
<br />101 -43100 -305 MEDICAL
<br />.00
<br />250
<br />250
<br />.00
<br />.00
<br />101-43100-308 TRAVEL/CONFERENCES /SCHOOLS
<br />70
<br />300
<br />300
<br />.00
<br />.00
<br />101 - 43100 -311 RISK MANAGEMENT
<br />110
<br />1,500
<br />1,000
<br />( 500)
<br />- 50.00%
<br />101 -43100 -313 CONTRACT SERVICES
<br />9,618
<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 />750
<br />1,200
<br />1,200
<br />.00
<br />.00
<br />x101- 43100 -322 POSTAGE
<br />.00
<br />100
<br />100
<br />.00
<br />.00
<br />101 -43100 -334 FUEL
<br />7,257
<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 />728
<br />1,600
<br />1,200
<br />( 400)
<br />- 33.33%
<br />101 - 43100 -400 REPAIR/MAINTENANCE /SERVICES
<br />6,518
<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 />265,000
<br />15,000
<br />5.66%
<br />Budget notes:
<br />-2012 OVERLAY GOVERNMENT DR WOR 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 />160,015
<br />479,100
<br />520,330
<br />41,230
<br />7.92%
<br />STREET LIGHTING
<br />101 -43160 -381 ELECTRICITY
<br />6,446
<br />13,750
<br />13,750
<br />.00
<br />.00
<br />101 - 43160 -400 REPAIR/MAINTENANCE /SERVICES
<br />271
<br />650
<br />650
<br />.00
<br />.00
<br />Total STREET LIGHTING:
<br />6,717
<br />14,400
<br />14,400
<br />.00
<br />.00
<br />SIGNAL & SIGNS
<br />101 -43161 -210 OPERATING SUPPLIES
<br />2,047
<br />3,500
<br />4,500
<br />1,000
<br />22.22%
<br />Budget notes:
<br />-2012 UPDATE STREET & TRAFFIC SIGNS PER STATUTE
<br />`,01 -43161 -381 ELECTRICITY
<br />1,207
<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 />
|