CITY OF PEQUOT LAKES Budget Worksheet - 2009 Year End Report
<br />Periods: 01/09 -14/09
<br />Page: 6
<br />May 18, 2010 12:35PM
<br />530,200 (
<br />2009 -09
<br />2009 -09
<br />Budget
<br />Budget
<br />Account Number Account Title
<br />Actual
<br />Budget
<br />Variance
<br />Variance%
<br />—2009
<br />105
<br />.00 (
<br />105)
<br />.00
<br />sand, salt, grader blades, UPM mix, misc
<br />ELECTRICITY
<br />13,139
<br />12,500 (
<br />639)
<br />101 -43100 -217 CLOTHING ALLOWANCE
<br />53
<br />600
<br />547
<br />8.80%
<br />101 -43100 -303 ENGINEERING FEES
<br />90,418
<br />16,000
<br />( 74,418)
<br />565.11%
<br />Budget notes:
<br />524)
<br />104.00%
<br />SIGNAL & SIGNS
<br />—2009
<br />101 -43161 -210
<br />additional street projects
<br />1,956
<br />2,000
<br />44
<br />97.79%
<br />101 -43100 -304 LEGAL FEES
<br />1,440
<br />2,000
<br />560
<br />71.98%
<br />101 -43100 -305 MEDICAL
<br />105
<br />.00
<br />( 105)
<br />.00
<br />101 -43100 -308 TRAVEL/CONFERENCES /SCHOOLS
<br />20
<br />50
<br />30
<br />39.90%
<br />101 -43100 -311 RISK MANAGEMENT
<br />1,562
<br />2,500
<br />939
<br />62.46%
<br />101 -43100 -313 CONTRACT SERVICES
<br />11,173
<br />11,850
<br />677
<br />94.29%
<br />101 -43100 -321 TELEPHONE
<br />908
<br />1,800
<br />892
<br />50.46%
<br />101 -43100 -322 POSTAGE
<br />60
<br />100
<br />40
<br />60.00%
<br />101 -43100 -334 FUEL
<br />5,733
<br />16,000
<br />10,267
<br />35.83%
<br />101 -43100 -350 PUBLISHING
<br />1,398
<br />750
<br />( 648)
<br />186.46%
<br />Budget notes:
<br />.00
<br />.00
<br />—2009
<br />Total HRA:
<br />additional street projects
<br />1,163
<br />1,300
<br />137
<br />89.43%
<br />101 -43100 -384 SANITATION
<br />1,001
<br />1,600
<br />599
<br />62.54%
<br />101- 43100 -400 REPAIR/MAINTENANCE /SERVICES
<br />3,888
<br />17,280
<br />13,392
<br />22.50%
<br />101 - 43100 -433 DUES /LICENSING /SUBSCRIPTIONS
<br />123
<br />250
<br />127
<br />49.20%
<br />101 -43100 -500 CAPITAL OUTLAY
<br />309,441
<br />268,620
<br />( 40,821)
<br />115.20%
<br />Budget notes:
<br />—2009
<br />additional street projects
<br />101 -43100 -501 CAPITAL OUTLAY CARRYOVER
<br />166,994
<br />10,000
<br />( 156,994)
<br />1669.94%
<br />Budget notes:
<br />—2009
<br />S. Oak street project
<br />Total ROADS & STREETS:
<br />775,719
<br />530,200 (
<br />245,519)
<br />146.31%
<br />STREET LIGHTING
<br />101 -43160 -210
<br />OPERATING SUPPLIES
<br />105
<br />.00 (
<br />105)
<br />.00
<br />101 -43160 -381
<br />ELECTRICITY
<br />13,139
<br />12,500 (
<br />639)
<br />105.11%
<br />101 - 43160 -400
<br />REPAIR/MAINTENANCE /SERVICES
<br />380
<br />600
<br />220
<br />63.33%
<br />Total STREET LIGHTING:
<br />13,624
<br />13,100 (
<br />524)
<br />104.00%
<br />SIGNAL & SIGNS
<br />101 -43161 -210
<br />OPERATING SUPPLIES
<br />1,956
<br />2,000
<br />44
<br />97.79%
<br />101 -43161 -381
<br />ELECTRICITY
<br />2,083
<br />2,500
<br />417
<br />83.33%
<br />101 - 43161 -400
<br />REPAIR/MAINTENANCE /SERVICES
<br />210
<br />750
<br />540
<br />27.97%
<br />Total SIGNAL & SIGNS:
<br />4,249
<br />5,250
<br />1,001
<br />80.93%
<br />HRA
<br />101 -46330 -100
<br />WAGES
<br />1,080
<br />1,200
<br />120
<br />90.00%
<br />101 -46330 -122
<br />EMPLOYER SHARE - FICA
<br />67
<br />80
<br />13
<br />83.70%
<br />101 -46330 -125
<br />EMPLOYER SHARE - MEDICARE
<br />16
<br />20
<br />4
<br />78.30%
<br />101 -46330 -360
<br />INSURANCE
<br />.00
<br />.00
<br />.00
<br />.00
<br />Total HRA:
<br />1,163
<br />1,300
<br />137
<br />89.43%
<br />
|