CITY OF PEQUOT LAKES
<br />Budget Worksheet - 2010 Year End Report
<br />Period: 14/10
<br />May 24, 2011
<br />Page: 3
<br />10:31AM
<br />101 -41410 -100
<br />2010
<br />2010
<br />Budget
<br />Budget
<br />Account Number
<br />Account Title
<br />Actual
<br />Budget
<br />Variance Variance%
<br />10141400 -121
<br />EMPLOYER SHARE - PERA
<br />6,921
<br />7,110
<br />189
<br />97.35%
<br />101 -41400 -122
<br />EMPLOYER SHARE - FICA
<br />6,150
<br />6,560
<br />410
<br />93.75%
<br />101 -41400 -125
<br />EMPLOYER SHARE - MEDICARE
<br />1,432
<br />1,540
<br />108
<br />93.01%
<br />101 -41400 -131
<br />EMPLOYER SHARE - HEALTH INSURA
<br />12,984
<br />12,990
<br />6
<br />99.96%
<br />101-41400-133
<br />EMPLOYER SHARE - LIFE INSURANC
<br />108
<br />130
<br />22
<br />82.71%
<br />101 - 41400 -200
<br />OFFICE SUPPLIES
<br />6,156
<br />7,000
<br />844
<br />87.95%
<br />101 -41400 -210
<br />OPERATING SUPPLIES
<br />1,076
<br />1,000
<br />( 76)
<br />107.63%
<br />101 - 41400 -300
<br />PROFESSIONAL SERVICES
<br />95
<br />.00
<br />( 95)
<br />.00
<br />Account notes:
<br />.00
<br />101 - 41410 -321
<br />TELEPHONE
<br />.00
<br />50
<br />Oppidan abatement
<br />.00
<br />101 -41410 -322
<br />POSTAGE
<br />30
<br />50
<br />101 -41400 -304
<br />LEGAL FEES
<br />6,528
<br />4,000
<br />( 2,528)
<br />163.21%
<br />Account notes:
<br />134.87%
<br />Total ELECTIONS:
<br />12,046
<br />12,500
<br />ordinances, Oasis dev, SuperValu dev, audit, police dept, city code amendments, wildlife trail
<br />96.37%
<br />SALES & USE TAX
<br />10141400 -308
<br />TRAVEL/CONFERENCES /SCHOOLS
<br />1,276
<br />2,000
<br />724
<br />63.80%
<br />101- 41400 -311
<br />RISK MANAGEMENT
<br />213
<br />500
<br />287
<br />42.64%
<br />101 -41400 -313
<br />CONTRACT SERVICES
<br />37,150
<br />37,880
<br />730
<br />98.07%
<br />101 -41400 -321
<br />TELEPHONE
<br />2,398
<br />2,500
<br />102
<br />95.92%
<br />10141400 -322
<br />POSTAGE
<br />998
<br />1,500
<br />502
<br />66.53%
<br />101 -41400 -350
<br />PUBLISHING
<br />767
<br />700
<br />( 67)
<br />109.56%
<br />101 - 41400400
<br />REPAIR/MAINTENANCE /SERVICES
<br />100
<br />500
<br />400
<br />20.00%
<br />101 - 41400 -433
<br />DUES /LICENSING /SUBSCRIPTIONS
<br />2,677
<br />2,490
<br />( 187)
<br />107.51%
<br />Account notes:
<br />9,023
<br />11,340
<br />2,317
<br />79.57%
<br />101-41910-133
<br />notary renewals, e-mail acct fees, membership dues, web domain fee, newspaper subscription
<br />49
<br />60
<br />Total CLERK:
<br />81.00%
<br />189,964
<br />194,200
<br />4,236
<br />97.82%
<br />�...- ELECTIONS
<br />101 -41410 -100
<br />WAGES
<br />8,703
<br />8,140 (
<br />563)
<br />106.91%
<br />101 - 41410 -121
<br />EMPLOYER SHARE - PERA
<br />411
<br />420
<br />9
<br />97.78%
<br />101 -41410 -122
<br />EMPLOYER SHARE - FICA
<br />340
<br />370
<br />30
<br />91.91%
<br />101 -41410 -125
<br />EMPLOYER SHARE - MEDICARE
<br />78
<br />90
<br />13
<br />86.11%
<br />101 -41410 -131
<br />EMPLOYER SHARE - HEALTH INSURA
<br />1,312
<br />1,320
<br />8
<br />99.36%
<br />101 -41410 -133
<br />EMPLOYER SHARE - LIFE INSURANC
<br />7
<br />10
<br />3
<br />67.20%
<br />101 - 41410 -200
<br />OFFICE SUPPLIES
<br />11
<br />.00 (
<br />11)
<br />.00
<br />101 -41410 -210
<br />OPERATING SUPPLIES
<br />677
<br />1,100
<br />423
<br />61.54%
<br />101 - 41410 -308
<br />TRAVEL/CONFERENCES /SCHOOLS
<br />277
<br />400
<br />123
<br />69.25%
<br />101 -41410 -313
<br />CONTRACT SERVICES
<br />.00
<br />400
<br />400
<br />.00
<br />101 - 41410 -321
<br />TELEPHONE
<br />.00
<br />50
<br />50
<br />.00
<br />101 -41410 -322
<br />POSTAGE
<br />30
<br />50
<br />20
<br />60.00%
<br />101 -41410 -350
<br />PUBLISHING
<br />202
<br />150 (
<br />52)
<br />134.87%
<br />Total ELECTIONS:
<br />12,046
<br />12,500
<br />454
<br />96.37%
<br />SALES & USE TAX
<br />101 -41420 -310
<br />SALES & USE TAX
<br />286
<br />800
<br />514
<br />35.75%
<br />Total SALES & USE TAX:
<br />286
<br />800
<br />514
<br />35.75%
<br />PLANNING & ZONING
<br />101 -41910 -100
<br />WAGES
<br />51,543
<br />51,190 (
<br />353)
<br />100.69%
<br />101 -41910 -121
<br />EMPLOYER SHARE - PERA
<br />3,022
<br />3,010 (
<br />12)
<br />100.41%
<br />101 -41910 -122
<br />EMPLOYER SHARE - FICA
<br />3,061
<br />3,180
<br />119
<br />96.27%
<br />101 -41910 -125
<br />EMPLOYER SHARE - MEDICARE
<br />713
<br />750
<br />37
<br />95.02%
<br />101 -41910 -131
<br />EMPLOYER SHARE - HEALTH INSURA
<br />9,023
<br />11,340
<br />2,317
<br />79.57%
<br />101-41910-133
<br />EMPLOYER SHARE - LIFE INSURANC
<br />49
<br />60
<br />11
<br />81.00%
<br />101 -41910 -200
<br />OFFICE SUPPLIES
<br />786
<br />2,600
<br />1,814
<br />30.22%
<br />101 -41910 -210
<br />OPERATING SUPPLIES
<br />503
<br />260 (
<br />243)
<br />193.57%
<br />Account notes:
<br />
|