11%.1
<br />CITY OF PEQUOT LAKES 2012 TNT Special Revenue /Enterprise Funds Budget Report
<br />Page: 7
<br />Period: 11/11
<br />Dec 01, 2011 01:15PM
<br />2012
<br />2011
<br />Preliminary
<br />Budget
<br />Budget
<br />Account Number Account Title
<br />Budget
<br />Budget
<br />Variance
<br />Variance%
<br />WATER FUND
<br />ASSESSMENTS/PRINCIPAL/INTEREST
<br />601 - 36210 -000 INTEREST EARNINGS
<br />8,800
<br />5,500
<br />( 3,300)
<br />- 60.00%
<br />Total ASSESSMENTS /PRINCIPAUINTEREST:
<br />8,800
<br />5,500
<br />( 3,300)
<br />- 60.00%
<br />WATER SALES
<br />601 - 37110 -000 WATER SALES
<br />221,980
<br />214,970
<br />( 7,010)
<br />-3.26%
<br />Budget notes:
<br />—2012 PER RATE STUDY
<br />601 - 37171 -000 STATE SALES TAX COLLECTED
<br />.00
<br />4,000
<br />4,000
<br />100.00%
<br />601 - 37172 -000 WATER METER FEES
<br />10,750
<br />11,220
<br />470
<br />4.19%
<br />Budget notes:
<br />—2012 PER RATE STUDY
<br />Total WATER SALES:
<br />232,730
<br />230,190
<br />( 2,540)
<br />-1.10%
<br />WATER
<br />601 - 49400 -100 WAGES
<br />47,700
<br />16,470
<br />( 31,230)
<br />- 189.62%
<br />Budget notes:
<br />—2012 1.25% INCREASE
<br />601 - 49400 -121 EMPLOYER SHARE - PERA
<br />3,290
<br />1,190
<br />( 2,100)
<br />- 176.47%
<br />601 -49400 -122 EMPLOYER SHARE - FICA
<br />2,960
<br />1,030
<br />( 1,930)
<br />- 187.38%
<br />601 -49400 -125 EMPLOYER SHARE - MEDICARE
<br />700
<br />240
<br />( 460)
<br />- 191.67%
<br />601 -49400 -131 EMPLOYER SHARE - HEALTH INSURA
<br />6,200
<br />3,260
<br />( 2,940)
<br />- 90.18%
<br />Budget notes:
<br />—2012 0% INCREASE
<br />601 -49400 -133 EMPLOYER SHARE - LIFE INSURANC
<br />70
<br />20
<br />( 50)
<br />- 250.00%
<br />601 -49400 -200 OFFICE SUPPLIES
<br />350
<br />500
<br />150
<br />30.00%
<br />601 -49400 -210 OPERATING SUPPLIES
<br />6,500
<br />6,500
<br />.00
<br />.00
<br />Budget notes:
<br />2012 WATER SERVICE REPAIR PARTS, EQUIP &
<br />BLDG MAINT SUPPLIES
<br />601 -49400 -217 CLOTHING ALLOWANCE
<br />100
<br />100
<br />.00
<br />.00
<br />601 -49400 -303 ENGINEERING FEES
<br />1,000
<br />5,000
<br />4,000
<br />80.00%
<br />Budget notes:
<br />—2012 GOVERNMENT DR PROJECT
<br />601 -49400 -304 LEGAL FEES
<br />500
<br />1,500
<br />1,000
<br />66.67%
<br />Budget notes:
<br />—2012 GOVERNMENT DR
<br />601 - 49400 -305 MEDICAL
<br />200
<br />200
<br />.00
<br />.00
<br />601 -49400 -308 TRAVEL/CONFERENCES/SCHOOLS
<br />500
<br />500
<br />.00
<br />.00
<br />601 -49400 -310 SALES & USE TAX
<br />300
<br />4,300
<br />4,000
<br />93.02%
<br />601 - 49400 -311 RISK MANAGEMENT
<br />200
<br />200
<br />.00
<br />.00
<br />Budget notes:
<br />2012 SAFETY EQUIP
<br />601 -49400 -313 CONTRACT SERVICES
<br />6,400
<br />31,500
<br />25,100
<br />79.68%
<br />Budget notes:
<br />—2012 SOFTWARE SUPPORT, SERVICE CONTRACTS ON EQUIP, TESTING, PRASD
<br />601 -49400 -321 TELEPHONE
<br />1,000
<br />1,100
<br />100
<br />9.09%
<br />601 -49400 -322 POSTAGE
<br />1,200
<br />1,200
<br />.00
<br />.00
<br />601 -49400 -334 FUEL
<br />1,150
<br />1,750
<br />600
<br />34.29%
<br />601 -49400 -350 PUBLISHING
<br />300
<br />300
<br />.00
<br />.00
<br />601 -49400 -360 INSURANCE
<br />6,600
<br />6,500
<br />( 100)
<br />-1.54%
<br />Budget notes:
<br />^2012 5% INCREASE
<br />
|