|
CITY OF PEQUOT LAKES
<br />EXPENDITURES WITH COMPARISON TO BUDGET
<br />FOR THE 11 MONTHS ENDING NOVEMBER 30, 2012
<br />WATER FUND
<br />MTD BUDGET MTD ACTUAL MTD VARIANCE YTD BUDGET YTD ACTUAL
<br />WATER
<br />ANNUAL
<br />YTD VARIANCE ANNUAL BUDGET % OF BUD
<br />601 -49400 -100
<br />WAGES
<br />1,372.00
<br />1,889.54 {
<br />517.54}
<br />15,092.00
<br />15,017.47
<br />74.53
<br />16,470.00
<br />91%
<br />601- 49400 -121
<br />EMPLOYER SHARE - PERA
<br />99.00
<br />136.31 (
<br />37.31)
<br />1,089.00
<br />1,081.43
<br />7,57
<br />1,190,00
<br />91%
<br />601 -49400 -122
<br />EMPLOYER SHARE - FICA
<br />85.00
<br />113.05 (
<br />28.05)
<br />935.00
<br />885.34
<br />49.66
<br />1,030,00
<br />86%
<br />60149400 -125
<br />EMPLOYER SHARE - MEDICARE
<br />20.00
<br />26.44 (
<br />6.44)
<br />220,00
<br />210.14
<br />9.86
<br />240.00
<br />88%
<br />601 -49400 -131
<br />EMPLOYER SHARE - HEALTH INSURA
<br />271.00
<br />271.52 (
<br />.52)
<br />2,981.00
<br />2,98672
<br />( 5.72)
<br />3,260.00
<br />92%
<br />601 -49400 -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 />601 - 49400 -200
<br />OFFICE SUPPLIES
<br />41.00
<br />3.44
<br />37.56
<br />451.00
<br />261.60
<br />189.40
<br />500.00
<br />52%
<br />601 -49400 -210
<br />OPERATING SUPPLIES
<br />542.00
<br />188.43
<br />353.57
<br />5,962.00
<br />13,025.84
<br />( 7,063.84)
<br />6,500.00
<br />200%
<br />601- 49400 -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 />601 -49400 -303
<br />ENGINEERING FEES
<br />417.00
<br />.00
<br />417.00
<br />4,587.00
<br />.00
<br />4,587.00
<br />5,000.00
<br />%q
<br />601 -49400 -304
<br />LEGAL FEES
<br />125.00
<br />71.75
<br />53.25
<br />1,375.00
<br />8,259.55
<br />( 6,884.55)
<br />1,500.00
<br />551%
<br />601- 49400 -305
<br />MEDICAL
<br />17.00
<br />.00
<br />17.00
<br />187.00
<br />.00
<br />187.00
<br />200.00
<br />%
<br />601- 49400 -308
<br />TRAVELICONFERENCESISCHOOLS
<br />42.00
<br />.00
<br />42.00
<br />462.00
<br />.00
<br />462.00
<br />500.00
<br />%
<br />601 - 49400 -310
<br />SALES & USE TAX
<br />.00
<br />.00
<br />.00
<br />3,225.00
<br />3,143.00
<br />82.00
<br />4,300,00
<br />73%
<br />601 -49400 -311
<br />RISK MANAGEMENT
<br />17.00
<br />.00
<br />17.00
<br />187.00
<br />151.01
<br />35.99
<br />200.00
<br />76%
<br />601- 49400 -313
<br />CONTRACT SERVICES
<br />2,525.00
<br />2,049.73
<br />575.27
<br />28,875.00
<br />49,551.77
<br />( 20,676.77)
<br />31,500.00
<br />157%
<br />601 - 49400 -321
<br />TELEPHONE
<br />91,00
<br />76.24
<br />14.76
<br />1,001.00
<br />822.74
<br />178.26
<br />1,100.00
<br />75%
<br />601- 49400 -322
<br />POSTAGE
<br />100,00
<br />279.51 {
<br />179.51)
<br />1,100.00
<br />1,591.51
<br />( 491..51)
<br />1,200,00
<br />133%
<br />601- 49400 -334
<br />FUEL
<br />145.00
<br />85.41
<br />59.59
<br />1,595.00
<br />892.95
<br />702.05
<br />1,750.00
<br />51%
<br />601- 49400 -350
<br />PUBLISHING
<br />25.00
<br />.00
<br />25.00
<br />275.00
<br />637.25
<br />( 362.25)
<br />300.00
<br />212%
<br />601 -49400 -360
<br />INSURANCE
<br />.00
<br />.00
<br />.00
<br />6,500.00
<br />3,707.80
<br />2,792.20
<br />6,500.00
<br />57%
<br />601159400 -381
<br />ELECTRICITY
<br />1,000.00
<br />923.06
<br />76.94
<br />11,000.00
<br />9,444.76
<br />1,555.24
<br />12,000.00
<br />79%
<br />601- 49400 -383
<br />HEATING
<br />208.00
<br />116.01
<br />91.99
<br />2,288.00
<br />1,130.14
<br />1,157.86
<br />2,500.00
<br />45%
<br />601 -49400 -384
<br />SANITATION
<br />17.00
<br />.00
<br />17.00
<br />187.00
<br />.00
<br />187.00
<br />200.00
<br />%
<br />601119400 -386
<br />WELLHEAD PROTECTION
<br />167.00
<br />.00
<br />167.00
<br />1,837.00
<br />.00
<br />1,837.00
<br />2,000.00
<br />%
<br />601- 49400 -400
<br />REPAIR /MAINTENANCEISERVICES
<br />1,250.00
<br />4,246.41 {
<br />2,998.41)
<br />13,750.00
<br />7,161.47
<br />6,588.53
<br />15,000.00
<br />48%
<br />601 -49400 -433
<br />DUES/LICENSING/SUBSCRIPTIONS
<br />500.00
<br />591.00 {
<br />91.00)
<br />5,500,00
<br />4,409.00
<br />1,091.00
<br />6,000.00
<br />73%
<br />501- 49400 -500
<br />CAPITAL OUTLAY
<br />417.00
<br />.00
<br />417.00
<br />4,587.00
<br />3,420.15
<br />1,166.65
<br />5,000.00
<br />68%
<br />601 -49400 -601
<br />DEBTSERVICE - PRINCIPAL
<br />00
<br />.00
<br />.00
<br />24,880.00
<br />1,428,198.53
<br />{ 1,403,318,53)
<br />24,880,00
<br />5,740%
<br />601 -49400 -610
<br />DEBT SERVICE - INTEREST
<br />00
<br />.00
<br />.00
<br />64,270.00
<br />110,993.82
<br />( 46,723.82)
<br />64,270.00
<br />173%
<br />TOTAL WATER
<br />9,602.00
<br />11,071.47 {
<br />1,469.47)
<br />204,497.00
<br />1,667,001.81
<br />( 1,462,504.81)
<br />215,210.00
<br />775%
<br />FOR ADMINISTRATION USE ONLY 92 % OF THE FISCAL YEAR HAS ELAPSED 01/0212013 01:51 PM PAGE: 44
<br />
|