|
WATER
<br />MTDBUDGET
<br />CITY OF PEQUOT LAKES
<br />EXPENDITURES WITH COMPARISON TO BUDGET
<br />FOR THE 1 MONTHS ENDING JANUARY 31. 2013
<br />WATER FUND
<br />ANNUAL
<br />MTD ACTUAL MTD VARIANCE YTD BUDGET YTD ACTUAL YTD VARIANCE ANNUAL BUDGET % OF BUD
<br />60149400 -100
<br />WAGES
<br />1,246.00
<br />1,084.63
<br />161.37
<br />1,246.00
<br />1,084.63
<br />161.37
<br />14,950.00
<br />7%
<br />601 -49400 -121
<br />EMPLOYER SHARE - PERA
<br />90.00
<br />77.94
<br />12.06.
<br />90.00
<br />77.94
<br />12.06
<br />1,080.00
<br />7%
<br />601 -49400 -122
<br />EMPLOYER SHARE -FICA
<br />78.00
<br />64.84
<br />1316
<br />78.00
<br />64.84
<br />13.16
<br />930.00
<br />7%
<br />601- 49400 -125
<br />EMPLOYER SHARE- MEDICARE
<br />18.00
<br />15.17
<br />2.83
<br />18.00
<br />15.17
<br />2.83
<br />220.00
<br />7%
<br />601 -49400 -131
<br />EMPLOYER SHARE - HEALTH INSURA
<br />299.00
<br />107.76
<br />191.24
<br />299.00
<br />107.76
<br />191.24
<br />3,590.00
<br />3%
<br />60149400 -133
<br />EMPLOYER SHARE - LIFE INSURANC
<br />3.00
<br />.59
<br />2.41
<br />3.00
<br />.59
<br />2.41
<br />30.00
<br />2%
<br />60149400 -200
<br />OFFICE SUPPLIES
<br />21.00
<br />.00
<br />21,00
<br />21.00
<br />.00
<br />21,00
<br />250.00
<br />%
<br />60149400 -210
<br />OPERATING SUPPLIES
<br />558.00
<br />34.13
<br />523.87
<br />558.00
<br />34.13
<br />523.87
<br />6,700.00
<br />1%
<br />60149400.303
<br />ENGINEERING FEES
<br />208.00
<br />201.00
<br />7.00
<br />208.00
<br />201.00
<br />7.00
<br />2,500.00
<br />8%
<br />60149400 -304
<br />LEGALFEES
<br />125.00
<br />315.00 (
<br />190.00)
<br />125.00
<br />315.00 (
<br />190.00)
<br />1,500.00
<br />21%
<br />60149400 -305
<br />MEDICAL
<br />17.00
<br />.00
<br />17.00
<br />17.00
<br />.00
<br />17.00
<br />200.00
<br />%
<br />60149400 -310
<br />SALES & USE TAX
<br />.00
<br />.00
<br />.00
<br />.00
<br />.00
<br />.00
<br />4,300.00
<br />%
<br />60149400 -311
<br />RISK MANAGEMENT
<br />17.00
<br />.00
<br />17.00
<br />17.00
<br />.00
<br />17.00
<br />200.00
<br />%
<br />60149400 -313
<br />CONTRACT SERVICES
<br />2,625.00
<br />1,644.64
<br />980.36
<br />2,625.00
<br />1,644.64
<br />980.36
<br />31,500.00
<br />5%
<br />60149400 -321
<br />TELEPHONE -
<br />67.00
<br />76.19 (
<br />9.19)
<br />67.00
<br />76.19 (
<br />9.19)
<br />800.00
<br />10%
<br />60149400 -322
<br />POSTAGE
<br />118.00
<br />67.62
<br />50.38
<br />118.00
<br />67.62
<br />50.38
<br />1,420.00
<br />5%
<br />60149400 -334
<br />FUEL
<br />100.00
<br />40.30
<br />59.70
<br />100,00
<br />40.30
<br />59.70
<br />1,200.00
<br />3%
<br />60149400.350
<br />PUBLISHING
<br />25.00
<br />.00
<br />25.00
<br />25.00
<br />.00
<br />25.00
<br />300.00
<br />%
<br />60149400 -360
<br />INSURANCE
<br />1,375.00
<br />737.60
<br />637.40
<br />1,375.00
<br />737.60
<br />637.40
<br />5,500.00
<br />13%
<br />60149400 -381
<br />ELECTRICITY
<br />1,000.00
<br />.00
<br />1,000.00
<br />1,000.00
<br />.00
<br />1,000.00
<br />12,000.00
<br />%
<br />60149400 -383
<br />HEATING
<br />208.00
<br />285.92 (
<br />77.92)
<br />208.00
<br />285.92 (
<br />77.92)
<br />2,500.00
<br />11%
<br />60149400 -384
<br />SANITATION
<br />17.00
<br />.00
<br />17.00
<br />17.00
<br />.00
<br />17.00
<br />200.00
<br />%
<br />60149400 -386
<br />WELLHEAD PROTECTION
<br />167.00
<br />18,62
<br />148.38
<br />167.00
<br />18,62
<br />148.38
<br />2,000.00
<br />1%
<br />601- 49400400
<br />REPAIR/MAINTENANCE/SERVICES
<br />1,333.00
<br />4.00
<br />1,329.00
<br />1,333.00
<br />4.00
<br />1,329.00
<br />16,000.00
<br />%
<br />60149400433
<br />DUES /LICENSING /SUBSCRIPTIONS
<br />500.00
<br />391.80
<br />108.20
<br />500.00
<br />391.80
<br />108.20
<br />6,000.00
<br />7%
<br />60149400 -500
<br />CAPITAL OUTLAY
<br />417.00
<br />.00
<br />417.00
<br />417.00
<br />.00
<br />417.00
<br />5,000.00
<br />%
<br />60149400 -601
<br />DEBT SERVICE - PRINCIPAL
<br />70,000.00
<br />70,000.00
<br />.00
<br />70,000.00
<br />70,000.00
<br />.00
<br />70,000.00
<br />100%
<br />60149400 -610
<br />DEBT SERVICE - INTEREST
<br />12,935.00
<br />12,935.00
<br />.00
<br />12,935.00
<br />12,935.00
<br />.00
<br />25,660.00
<br />50%
<br />TOTAL WATER
<br />93,567.00
<br />88,102.75
<br />5,464.25
<br />93,567.00
<br />88,102.75
<br />5,464.25
<br />216,530.00
<br />41%
<br />FOR ADMINISTRATION USE ONLY 8 % OF THE FISCAL YEAR HAS ELAPSED 02/28/2013 11:02AM PAGE: 38
<br />
|