Laserfiche WebLink
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 />