|
� � �
<br />CITY OF PEQUOT LAKES
<br />EXPENDITURES WITH COMPARISON TO BUDGET
<br />FOR THE 7 MONTHS ENDING JULY 31, 2012
<br />WATER
<br />601-49400-100 WAGES
<br />601-49400-121 EMPLOYER SHARE - PERA
<br />601-49400-122 EMPLOYER SHARE - FICA
<br />601-49400-125 EMPLOYER SHARE - MEDICARE
<br />601-49400-131 EMPLOYER SHARE - HEALTH INSURA
<br />601-49400-133 EMPLOYER SHARE - LIFE INSURANC
<br />601-49400-200 OFFICE SUPPLIES
<br />601-49400-210 OPERATING SUPPLIES
<br />601-49400-217 CLOTHING ALLOWANCE
<br />601-49400-303 ENGINEERING FEES
<br />601-49400-304 LEGAL FEES
<br />601-49400-305 MEDICAL
<br />601-49400-308 TRAVEUCONFERENCESlSCHOOLS
<br />601-49400-310 SALES & USE TAX
<br />601-49400-311 RISK MANAGEMENT
<br />601-49400-313 CONTRACT SERVICES
<br />601-49400-321 TELEPHONE
<br />601-49400-322 POSTAGE
<br />601-49400-334 FUEL
<br />601-49400-350 PUBLISHING
<br />601-49400360 I NSU RANC E
<br />601-49400-381 ELECTRICITY
<br />601-49400-383 HEATING
<br />601-49400-384 SANITATION
<br />601-49400-386 WELLHEAD PROTECTION
<br />601-49400-400 REPAIR/MAINTENANCE/SERVICES
<br />601-49400-433 DUES/LICENSING/SUBSCRIPTIONS
<br />601-49400-500 CAPITAL OUTLAY
<br />601-49400-601 DEBT SERVICE - PRINCIPAL
<br />601-49400-610 DEBT SERVICE - INTEREST
<br />TOTAL WATER
<br />FOR ADMINISTRATION USE ONLY
<br />MTD BUDGET
<br />1, 372.00
<br />99.00
<br />85.00
<br />20.00
<br />271.00
<br />1.00
<br />41.00
<br />542.00
<br />8.00
<br />417.00
<br />125.00
<br />17.00
<br />42.00
<br />00
<br />17.00
<br />2,625.00
<br />91.00
<br />100.00
<br />145.00
<br />25.00
<br />1, 850.00
<br />1, 000.00
<br />208.00
<br />17.00
<br />167.00
<br />1,250.00
<br />500.00
<br />417.00
<br />.00
<br />.00
<br />WATERFUND
<br />MTD ACTUAL MTD VARIANCE YTD BUDGET YTD ACTUAL
<br />1,420.83 (
<br />102.33 (
<br />84.21
<br />19.70
<br />271.52 (
<br />1.62 (
<br />24.65
<br />932.72 (
<br />00
<br />.00
<br />.00
<br />.00
<br />.00
<br />.00
<br />36.73 (
<br />25,175.20 (
<br />75.41
<br />337.51 (
<br />82.22
<br />.00
<br />.00
<br />1,065.76 (
<br />29.08
<br />.00
<br />.00
<br />1,243.30
<br />.00
<br />.00
<br />.00
<br />.00
<br />48.83)
<br />3.33)
<br />.79
<br />.30
<br />.52)
<br />.62)
<br />16.35
<br />390.72)
<br />8.00
<br />417.00
<br />125.00
<br />17.00
<br />42.00
<br />.00
<br />19.73)
<br />22,550.20)
<br />15.59
<br />237.51)
<br />62.78
<br />25.00
<br />1, 850.00
<br />65.76)
<br />178.92
<br />17.00
<br />167.00
<br />6.70
<br />500.00
<br />417.00
<br />00
<br />.00
<br />9,604.00
<br />693.00
<br />595.00
<br />140.00
<br />1, 897.00
<br />7.00
<br />287.00
<br />3,794.00
<br />56.00
<br />2,919.00
<br />875.00
<br />119.00
<br />294.00
<br />2,150.00
<br />119.00
<br />18,375.00
<br />637.00
<br />700.00
<br />1, 015.00
<br />175.00
<br />5,100.00
<br />7,000.00
<br />1,456.00
<br />119.00
<br />1,169.00
<br />8,750.00
<br />3,500.00
<br />2,919.00
<br />24, 880.00
<br />64,270.00
<br />11,452.00 30,902.79 ( 19,450.79) 163,614.00
<br />58 % OF THE FISCAL YEAR HAS ELAPSED
<br />ANNUAL
<br />YTD VARIANCE ANNUAL BUDGET % OF BUD
<br />9,250.24
<br />666.03
<br />543.53
<br />130.20
<br />1,900.64 (
<br />11.34 (
<br />258.16
<br />4,583.88 (
<br />.OQ
<br />.00
<br />687.80
<br />.00
<br />.00
<br />1,442.00
<br />114.28
<br />39,235.39 (
<br />518.00
<br />890.87 (
<br />589.94
<br />449.75 (
<br />2,505.50
<br />5,278.92
<br />903.56
<br />.00
<br />.00
<br />2,175.06
<br />3,002.00
<br />3,420.15 (
<br />24,871.54
<br />64,268.92
<br />353.76
<br />26.97
<br />51.47
<br />9.80
<br />3.64)
<br />4.34)
<br />28.84
<br />789.88)
<br />56.��
<br />2,919.00
<br />187.20
<br />119.00
<br />294.00
<br />708.00
<br />4.72
<br />20,860.39)
<br />119.00
<br />190.87)
<br />425.06
<br />274.75)
<br />2,594.50
<br />1,721.08
<br />552.44
<br />119.00
<br />1,169.00
<br />6,574.94
<br />496.00
<br />501.15)
<br />8.46
<br />1.08
<br />16,470.00
<br />1,190.00
<br />1,030.00
<br />240.00
<br />3,260.00
<br />20.00
<br />500.00
<br />6,500.00
<br />� Q0.00
<br />5,000.00
<br />1, 500.00
<br />200.00
<br />500.00
<br />4,300.00
<br />200.00
<br />31,500.00
<br />1,100.00
<br />1,200.00
<br />1,750.00
<br />300.00
<br />6,500.00
<br />12,000.00
<br />2,500.00
<br />200.00
<br />2, 000.00
<br />15,000.00
<br />6,000.00
<br />5,000.00
<br />24,880.00
<br />64,270.00
<br />�
<br />56%
<br />56%
<br />53%
<br />54%
<br />58%
<br />57%
<br />52%
<br />71%
<br />%
<br />%
<br />46%
<br />%
<br />%
<br />34%
<br />57%
<br />125%
<br />47%
<br />74%
<br />34%
<br />150%
<br />39%
<br />44%
<br />36%
<br />%
<br />o�a
<br />15%
<br />50%
<br />68%
<br />100%
<br />100%
<br />167,697.70 ( 4,083.70) 215,210.00 78%
<br />08/29/2012 02:51PM PAGE:44
<br />
|