CITY OF PEQUOT LAKES
<br />Budget Worksheet - 2011 Year End Report
<br />Period: 14/11
<br />2011 2011
<br />Account Number Account Title Actual Budget
<br />SEWERFUND
<br />INTERGOVERNMENTAL REVENUES
<br />602-33401-000 PERAAID 21 .00 (
<br />Total INTERGOVERNMENTAL REVENUES: 21 .00 (
<br />CHARGES FOR SERVICES
<br />602-34101-000 RENT 3,800 3,800
<br />Total CHARGES FOR SERVICES: 3,800 3,800
<br />ASSESSMENTS/PRINCIPAL/INTEREST
<br />602-36101-000 SPECIAL ASSESSMENTS .00 .00
<br />602-36210-000 INTEREST EARNINGS 4,000 5,400
<br />Total ASSESSMENTS/PRINCIPAUINTEREST: 4,001 5,400
<br />SEWER SALES
<br />602-37210-000 SEWER SALES 223,856 217,740 (
<br />Total SEWER SALES: 223,856 217,740 (
<br />OTHER FINANCING SOURCES
<br />602-39990-000 REFUNDS 8� REIMBURSEMENTS 731 .00 (
<br />Account notes:
<br />insurance dividend
<br />Total OTHER FINANCING SOURCES: 731 .00 (
<br />TRANSFERS TO OTHER FUNDS
<br />602-49350-720 TRANSFERS 2,253 .00 (
<br />Account notes:
<br />transfers to General Fund for maint dept wages/benefits
<br />Total TRANSFERS TO OTHER FUNDS: 2,253 .00 (
<br />SEWER .
<br />602-49450-100 WAGES 18,257 47,700
<br />602-49450-121 EMPLOYER SHARE - PERA 1,343 3,290
<br />602-49450-122 EMPLOYER SHARE - FICA 1,223 2,960
<br />602-49450-125 EMPLOYER SHARE - MEDICARE 298 700
<br />602-49450-131 EMPLOYER SHARE - HEALTH INSURA 3,356 6,200
<br />602-49450-133 EMPLOYER SHARE - LIFE INSURANC 26 70
<br />602-49450-200 OFFICE SUPPLIES 319 350
<br />602-49450-210 OPERATING SUPPLIES 10,786 3,000 (
<br />Account notes:
<br />chemicals, radio replacement, supplies, locator gun, safety grates, repl end gune, repl center drive
<br />602-49450-217 CLOTHING ALLOWANCE .00 100
<br />602-49450-303 ENGINEERING FEES 1,857 17,000
<br />602-49450-304 LEGAL FEES 1,612 500 (
<br />Account notes:
<br />PRASD agrmt, spray irrigation lease
<br />602-49450-305 MEDICAL .00 200
<br />602-49450-308 TRAVEUCONFERENCES/SCHOOLS 208 500
<br />602-49450-310 SALES & USE TAX 24 300
<br />602-49450-311 RISK MANAGEMENT 98 200
<br />Page: 28
<br />May 22, 2012 11:10AM
<br />Budget Budget
<br />Variance Variance%
<br />�
<br />21) .00
<br />21) .00
<br />.00 100.00%
<br />.00 100.00%
<br />.00 .00
<br />1,400 74.08%
<br />1,399 74.09%
<br />6,116) 102.81 %
<br />6,116) 102.81 %
<br />731) .00
<br />"'�
<br />731) .00
<br />2,253) .00
<br />2,253) .00
<br />29,443 38.28%
<br />1,947 40.83%
<br />1,737 41.32%
<br />402 42.57%
<br />2,844 54.13%
<br />44 37.69%
<br />31 91.10%
<br />7,786) 359.52%
<br />100 .00
<br />15,143 10.92%
<br />1,112) 322.49%
<br />200
<br />292
<br />276
<br />102
<br />.00 "'�
<br />41.55%
<br />8.00%
<br />48.98%
<br />
|