CITY OF PEQUOT LAKES
<br />EXPENDITURES WITH COMPARISON TO BUDGET
<br />FOR THE 11 MONTHS ENDING NOVEMBER 30, 2012
<br />SEWER FUND
<br />MTD BUDGET MTD ACTUAL MTD VARIANCE YTD BUDGET YTD ACTUAL
<br />SEWER
<br />ANNUAL
<br />YTD VARIANCE ANNUAL BUDGET % OF BUD
<br />602 -49450 -100
<br />WAGES
<br />1,372.00
<br />1,889.55 (
<br />517.55)
<br />15,092.00
<br />15,017.34
<br />74.66
<br />16,470.00
<br />91%
<br />602-49450-121
<br />EMPLOYER SHARE • PERA
<br />99.00
<br />136.31 {
<br />37,$1)
<br />1,089.00
<br />1,081.29
<br />7.71
<br />1,190.00
<br />91°%
<br />602 -49450 -122
<br />EMPLOYER SHARE - FICA
<br />85.00
<br />113.04 (
<br />28.04)
<br />935.00
<br />865.06
<br />49.94
<br />1,030.00
<br />86%
<br />602 - 49450 -125
<br />EMPLOYER SHARE - MEDICARE
<br />20.00
<br />26.43 {
<br />6.43)
<br />220.00
<br />209.84
<br />1016
<br />240.00
<br />87%
<br />602 -49450 -131
<br />EMPLOYER SHARE - HEALTH INSURA
<br />271.00
<br />271.52 {
<br />.52)
<br />2,981.00
<br />2,986.72 (
<br />5.72)
<br />3,260.00
<br />92%
<br />602 -49450 -133
<br />EMPLOYER SHARE - LIFE INSURANC
<br />1.00
<br />1.62 {
<br />.62)
<br />11.00
<br />17.82 (
<br />6.82)
<br />20.00
<br />89%
<br />602 -49450 -200
<br />OFFICE SUPPLIES
<br />41.00
<br />.00
<br />41.00
<br />451.00
<br />25815
<br />192.85
<br />500.00
<br />52 %
<br />60249450 -210
<br />OPERATING SUPPLIES
<br />333.00
<br />82.79
<br />250.21
<br />3,663.00
<br />5,173.24 (
<br />1,510.24)
<br />4,000.00
<br />129%
<br />602 -49450 -217
<br />CLOTHING ALLOWANCE
<br />8.00
<br />.00
<br />8.00
<br />88.00
<br />.00
<br />88.00
<br />100,00
<br />%
<br />602 -49450 -303
<br />ENGINEERING FEES
<br />1,250.00
<br />.00
<br />1,250.00
<br />13,750.00
<br />.00
<br />13,750.00
<br />15,000.00
<br />602 -49450 -304
<br />LEGAL FEES
<br />125.00
<br />56.25
<br />68.75
<br />1,375.00
<br />56.25
<br />1,318.75
<br />1,500.00
<br />4%
<br />602 -49450 -305
<br />MEDICAL
<br />17.00
<br />.00
<br />17.00
<br />187.00
<br />.00
<br />187.00
<br />200.00
<br />%
<br />602 -49450 -308
<br />TRAVEL/CONFERENCES/SCHOOLS
<br />42.00
<br />.00
<br />42.00
<br />462.00
<br />.00
<br />462.00
<br />500.00
<br />%
<br />602 -49450 -310
<br />SALES & USE TAX
<br />00
<br />.00
<br />.00
<br />111.00
<br />19.00
<br />92,00
<br />150.00
<br />13%
<br />602 -49450 -311
<br />RISK MANAGEMENT
<br />16.00
<br />.00
<br />16.00
<br />176.00
<br />151.02
<br />24.98
<br />200,00
<br />75%
<br />602 -49450 -313
<br />CONTRACT SERVICES
<br />2,541.00
<br />2,049.72
<br />491.28
<br />27,951.00
<br />26,065.60
<br />1,885.40
<br />30,500.00
<br />85%
<br />60249450 -321
<br />TELEPHONE
<br />41.00
<br />24.50
<br />16.50
<br />451.00
<br />269.46
<br />181.54
<br />500.00
<br />54°%
<br />602- 49450 -322
<br />POSTAGE
<br />125.00
<br />257.51 (
<br />132.51)
<br />1,375.00
<br />1,443.92 {
<br />68.92)
<br />1,500.00
<br />96%
<br />602-49450 -334
<br />FUEL
<br />145.00
<br />141.31
<br />3.69
<br />1,595.00
<br />1,288.82
<br />306.18
<br />1,750.00
<br />74%
<br />602 - 49450 -350
<br />PUBLISHING
<br />25.00
<br />.00
<br />25.00
<br />275.00
<br />187.50
<br />87.50
<br />300.00
<br />63%
<br />602 -49450 -360
<br />INSURANCE
<br />.00
<br />.00
<br />.00
<br />6,100.00
<br />4,326.20
<br />1,773.80
<br />6,19(.00
<br />71°%
<br />602- 49450 -381
<br />ELECTRICITY
<br />1,166.00
<br />601.60
<br />564.40
<br />12,826.00
<br />11,977.73
<br />848.27
<br />14,000.00
<br />66°%
<br />602 -49450 -383
<br />HEATING
<br />3100
<br />1311
<br />19.89
<br />363.00
<br />131.49
<br />231.51
<br />400,00
<br />33%
<br />602- 49450 -384
<br />SANITATION
<br />17.00
<br />.00
<br />17.00
<br />187.00
<br />.00
<br />187.00
<br />200.00
<br />%
<br />602- 49450 -400
<br />REPAIRRNAINTENANCE /SERVICES
<br />1,667.00
<br />11,910.82 (
<br />10,243.82)
<br />18,337.00
<br />40,839.11 {
<br />22,502.11)
<br />20,000.00
<br />204°%
<br />602- 49450 -433
<br />DUES /LICENSING /SUBSCRIPTIONS
<br />167.00
<br />.00
<br />167,00
<br />1,837.00
<br />2,718.00 {
<br />881.00)
<br />2,000.00
<br />136%
<br />602- 49450 -500
<br />CAPITAL OUTLAY
<br />833.00
<br />.00
<br />833.00
<br />9,163.00
<br />3,420.12
<br />5,742.88
<br />10,000.00
<br />34°%
<br />TOTAL SEWER
<br />10,440.00
<br />17,576.08 (
<br />7,136.08)
<br />121,051.00
<br />118,523.68
<br />2,527.32
<br />131,610,00
<br />90%
<br />FOR ADMINISTRATION USE ONLY 92 % OF THE FISCAL YEAR HAS ELAPSED 01/02/2013 01:51 PM PAGE: 47
<br />
|