|
CITY OF PEQUOT LAKES Budget Worksheet - 2011 Year End Report Page: 26
<br />Period: 14/11 May 22, 2012 11:10AM
<br />�
<br />2011 2011 Budget Budget
<br />Account Number Account Title Actual Budget Variance Variance%
<br />WATER FUND
<br />INTERGOVERNMENTAL REVENUES
<br />601-33401-000 PERA AID 21 .00 ( 21) .00
<br />Total INTERGOVERNMENTAL REVENUES: 21 .00 ( 21) .00
<br />ASS ES S M E NTS/P RI N C I PAL/I N T E REST
<br />601-36101-000 SPECIALASSESSMENTS 25 .00 ( 25) .00
<br />601-36203-000 MISCELLANEOUS REVENUE 217 .00 ( 217) .00
<br />601-36210-000 INTEREST EARNINGS 5,433 8,800 3,367 61.74%
<br />Total ASSESSMENTS/PRINCIPAUINTEREST: 5,675 8,800 3,125 64.49%
<br />WATER SALES
<br />601-37110-000 WATER SALES 220,254 221,980 1,726 99.22%
<br />601-37171-000 STATE SALES TAX COLLECTED 4,126 .00 ( 4,126) .00
<br />601-37172-000 WATER METER FEES 12,154 10,750 ( 1,404) 113.06%
<br />Total WATER SALES: 236,534 232,730 ( 3,804) 101.63%
<br />OTHER FINANCING SOURCES
<br />601-39990-000 REFUNDS & REIMBURSEMENTS 4,059 .00 ( 4,059) .00
<br />Account notes:
<br />state test fees, insurance dividend
<br />�
<br />Total OTHER FINANCING SOURCES: 4,059 .00 ( 4,059) .00
<br />TRANSFERS TO OTHER FUNDS
<br />601-49350-720 TRANSFERS 2,938 .00 ( 2,938) .00
<br />Account notes:
<br />transfers to General Fund for maint dept wages/benefits
<br />Total TRANSFERS TO OTHER FUNDS: 2,938 .00 ( 2,938) .00
<br />WATER
<br />601-49400-100 WAGES 18,258 47,700 29,442 38.28%
<br />601-09400-121 EMPLOYER SHARE - PERA 1,344 3,290 1,946 40.84%
<br />601-49400-122 EMPLOYER SHARE - FICA 1,223 2,960 1,737 41.33%
<br />601-49400-125 EMPLOYER SHARE - MEDICARE 298 700 402 42.63%
<br />601-49400-131 EMPLOYER SHARE - HEALTH INSURA 3,356 6,200 2,844 54.13%
<br />601-49400-133 EMPLOYER SHARE - LIFE INSURANC 26 70 44 37.80%
<br />601-49400-200 OFFICE SUPPLIES 358 350 ( 8) 102.39%
<br />601-49400-210 OPERATING SUPPLIES 10,934 6,500 ( 4,434) 168.21%
<br />Account notes:
<br />supplies, water meter supplies, locator gun, chemicals
<br />601-49400-217 CLOTHING ALLOWANCE .00 100 100 .00
<br />601-49400-303 ENGINEERING FEES 1,509 1,000 ( 509) 150.90%
<br />601-49400-304 LEGAL FEES 525 500 ( 25) 105.00%
<br />601-49400-305 MEDICAL .00 200 200 .00
<br />601-49400-308 TRAVEUCONFERENCES/SCHOOLS 208 500 292 41.55%
<br />601-49400-310 SALES & USE TAX 4,123 300 ( 3,823) 1374.33%
<br />Account notes:
<br />MN Revenue sales tax pymts "�
<br />601-49400-311 RISK MANAGEMENT 98 200 102 48.98%
<br />601-49400-313 CONTRACT SERVICES 21,755 6,400 ( 15,355) 339.93%
<br />Account notes:
<br />software support fees, computer service, sealing valve vault, dig up frozen curb stops, PRASD contract, annual inspections,
<br />
|