|
� C �
<br />CITY OF PEQUOT LAKES
<br />EXPENDITURES WITH COMPARISON TO BUDGET
<br />FOR THE 3 MONTHS ENDING MARCH 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 TRAVEUCONFERENCES/SCHOOLS
<br />601�9400-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-49400-36 0 I N S U RA N C 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 />WATER FUND
<br />MTD BUDGET MTD ACTUAL MTD VARIANCE YTD BUDGET YTD ACTUAL
<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 />1,075.00
<br />17.00
<br />2,625.00
<br />91.00
<br />100.00
<br />145.00
<br />25.00
<br />.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 />10,677.00
<br />1,232.46
<br />88.68
<br />72.54
<br />16.97
<br />271.52 (
<br />1.62 (
<br />.00
<br />13.65
<br />.00
<br />.00
<br />397.80 (
<br />.00
<br />.00
<br />589.00
<br />.00
<br />2, 019.73
<br />74.10
<br />378.34 (
<br />107.17
<br />.00
<br />.00
<br />889.64
<br />156.10
<br />.00
<br />.00
<br />.00
<br />1,230.00 (
<br />.00
<br />.00
<br />00
<br />7,539.32
<br />139.54
<br />10.32
<br />12.46
<br />3.03
<br />.52)
<br />62)
<br />41.00
<br />528.35
<br />8.00
<br />417.00
<br />272.80)
<br />17.00
<br />42.00
<br />486.00
<br />17.00
<br />605.27
<br />16.90
<br />278.34)
<br />37.83
<br />25.00
<br />.00
<br />110.36
<br />51.90
<br />17.00
<br />167.00
<br />1, 250.00
<br />730.00)
<br />417.00
<br />.00
<br />.00
<br />3,137.68
<br />FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED
<br />4,116.00
<br />297.00
<br />255.00
<br />60.00
<br />813.00
<br />3.00
<br />123.00
<br />1,626.00
<br />24.00
<br />1,251.00
<br />375.00
<br />51.00
<br />126.00
<br />1, 075.00
<br />51.00
<br />7,875.00
<br />273.00
<br />300.00
<br />435.00
<br />75.00
<br />1, 850.00
<br />3,000.00
<br />624.00
<br />51.00
<br />501.00
<br />3,750.00
<br />1, 500.00
<br />1, 251.00
<br />24,880.00
<br />64,270.00
<br />120, 881.00
<br />ANNUAL
<br />YTD VARIANCE ANNUAL BUDGET % OF BUD
<br />3,520.43
<br />253.32
<br />204.00
<br />50.77
<br />814.56 (
<br />4.86 (
<br />20.30
<br />871.83
<br />.00
<br />.00
<br />687.80 (
<br />.00
<br />.00
<br />589.00
<br />48.98
<br />7,244.06
<br />220.38
<br />465.85 (
<br />248.05
<br />.00
<br />.00
<br />1,683.41
<br />704.94 (
<br />.00
<br />.00
<br />4.00
<br />2,311.00 (
<br />3,420.15 (
<br />24,871.54
<br />64,268.92
<br />595.57
<br />43.68
<br />51.00
<br />9.23
<br />1.56)
<br />1.86)
<br />102.70
<br />754.17
<br />24.00
<br />1,251.00
<br />312.80)
<br />51.00
<br />126.00
<br />486.00
<br />2.02
<br />630.84
<br />52.62
<br />165.85)
<br />186.95
<br />75.00
<br />1, 850.00
<br />1, 316.59
<br />80.94)
<br />51.00
<br />501.00
<br />3,746.00
<br />811.00)
<br />2,169.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 />100.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 />20�.��
<br />2,0��.�0
<br />15,000.00
<br />6,000.00
<br />5,000.00
<br />24,880.00
<br />64,270.00
<br />21%
<br />21%
<br />20%
<br />21%
<br />25%
<br />24%
<br />4%
<br />13%
<br />%
<br />%
<br />46%
<br />%
<br />o�a
<br />14%
<br />24%
<br />23%
<br />20%
<br />39%
<br />14%
<br />%
<br />%
<br />14%
<br />28%
<br />%
<br />%
<br />%
<br />39%
<br />68%
<br />100%
<br />100%
<br />112,508.15 8,372.85 215,210.00 52%
<br />04/25/2012 04:35PM PAGE:43
<br />
|