|
`1
<br />CITY OF PEQUOT LAKES
<br />EXPENDITURES WITH COMPARISON TO BUDGET
<br />FOR THE 7 MONTHS ENDING JULY 31, 2009
<br />WATER FUND
<br />% OF
<br />CURACTUAL YTD ACTUAL BUDGETAMT VARIANCE BUDGET
<br />WATER
<br />601 -49400 -100
<br />WAGES
<br />3,279.36
<br />16,941.43
<br />51,110.00
<br />34,168.57
<br />33.15
<br />601 -49400 -121
<br />EMPLOYER SHARE - PERA
<br />208.09
<br />1,048.23
<br />3,300.00
<br />2,251.77
<br />31.76
<br />601 -49400 -122
<br />EMPLOYER SHARE - FICA
<br />202.36
<br />1,043.55
<br />3,170.00
<br />2,126.45
<br />32.92
<br />601 -49400 -125
<br />EMPLOYER SHARE - MEDICARE
<br />47.33
<br />244.03
<br />750.00
<br />505.97
<br />32.54
<br />601 -49400 -131
<br />EMPLOYER SHARE - HEALTH INSURA
<br />118.23
<br />1,274.47
<br />6,930.00
<br />5,655.53
<br />18.39
<br />601 -49400 -133
<br />EMPLOYER SHARE - LIFE INSURANC
<br />3.48
<br />26.76
<br />80.00
<br />53.24
<br />33.45
<br />601 -49400 -142
<br />UNEMPLOYMENT COMPENSATION
<br />.00
<br />373.52
<br />.00
<br />( 373.52)
<br />.00
<br />601 - 49400 -200
<br />OFFICE SUPPLIES
<br />.00
<br />117.63
<br />700.00
<br />582.37
<br />16.80
<br />601 -49400 -210
<br />OPERATING SUPPLIES
<br />.00
<br />2,870.63
<br />2,500.00
<br />( 370.63)
<br />114.83
<br />601 -49400 -217
<br />CLOTHING ALLOWANCE
<br />.00
<br />.00
<br />350.00
<br />350.00
<br />.00
<br />601 -49400 -303
<br />ENGINEERING FEES
<br />.00
<br />509.90
<br />6,000.00
<br />5,490.10
<br />8.50
<br />601 -49400 -304
<br />LEGAL FEES
<br />.00
<br />217.50
<br />600.00
<br />382.50
<br />36.25
<br />601 -49400 -305
<br />MEDICAL
<br />.00
<br />.00
<br />200.00
<br />200.00
<br />.00
<br />601 -49400 -308
<br />TRAVEUCONFERENCES /SCHOOLS
<br />.00
<br />368.95
<br />500.00
<br />131.05
<br />73.79
<br />601 -49400 -310
<br />SALES & USE TAX
<br />.00
<br />30.00
<br />500.00
<br />470.00
<br />6.00
<br />601 -49400 -311
<br />RISK MANAGEMENT
<br />.00
<br />79.34
<br />500.00
<br />420.66
<br />15.87
<br />601 -49400 -313
<br />CONTRACT SERVICES
<br />.00
<br />4,045.50
<br />4,550.00
<br />504.50
<br />88.91
<br />601 -49400 -321
<br />TELEPHONE
<br />.00
<br />525.62
<br />1,200.00
<br />674.38
<br />43.80
<br />601 -49400 -322
<br />POSTAGE
<br />120.00
<br />932.42
<br />2,300.00
<br />1,367.58
<br />40.54
<br />601 -49400 -334
<br />FUEL
<br />.00
<br />411.38
<br />1,500.00
<br />1,088.62
<br />27.43
<br />601 -49400 -350
<br />PUBLISHING
<br />.00
<br />302.40
<br />250.00
<br />( 52.40)
<br />120.96
<br />601 -49400 -360
<br />INSURANCE
<br />.00
<br />5,159.60
<br />7,000.00
<br />1,840.40
<br />73.71
<br />601 -49400 -381
<br />ELECTRICITY
<br />.00
<br />5,018.59
<br />12,500.00
<br />7,481.41
<br />40.15
<br />601 -49400 -383
<br />HEATING
<br />.00
<br />1,169.20
<br />2,500.00
<br />1,330.80
<br />46.77
<br />601 -49400 -386
<br />WELLHEAD PROTECTION
<br />.00
<br />41.39
<br />500.00
<br />458.61
<br />8.28
<br />601 - 49400 -400
<br />REPAIR/MAINTENANCE /SERVICES
<br />.00
<br />10,669.46
<br />25,000.00
<br />14,330.54
<br />42.68
<br />601 - 49400 -433
<br />DUES /LICENSING /SUBSCRIPTIONS
<br />100.00
<br />3,178.50
<br />4,300.00
<br />1,121.50
<br />73.92
<br />601 -49400 -500
<br />CAPITAL OUTLAY
<br />.00
<br />.00
<br />2,550.00
<br />2,550.00
<br />.00
<br />601 -49400 -501
<br />CAPITAL OUTLAY CARRYOVER
<br />.00
<br />.00
<br />12,500.00
<br />12,500.00
<br />.00
<br />601 - 49400 -601
<br />DEBT SERVICE - PRINCIPAL
<br />.00
<br />21,794.84
<br />21,800.00
<br />5.16
<br />99.98
<br />601 -49400 -610
<br />DEBT SERVICE - INTEREST
<br />.00
<br />67,345.62
<br />67,350.00
<br />4.38
<br />99.99
<br />TOTAL WATER
<br />4,078.85
<br />145,740.46
<br />242,990.00
<br />97,249.54 59.98
<br />TOTAL FUND EXPENDITURES
<br />4,078.85
<br />145,740.46
<br />242,990.00
<br />97,249.54 59.98
<br />NET REVENUE OVER EXPENDITURES
<br />( 4,175.95)
<br />( 37,572.85)
<br />6,210.00
<br />43,782.85
<br />CASH BALANCE
<br />601- 11000 -000 CASH
<br />430,108.22
<br />FOR ADMINISTRATION USE ONLY 68 % OF THE FISCAL YEAR HAS ELAPSED 07/28/2009 03:29PM PAGE: 34
<br />
|