|
CITY OF PEQUOT LAKES Budget Worksheet - Preliminary Budget Page: 17
<br />Period: 08/12 Aug 15, 2012 10:36AM
<br />� 01/12-OSl12 2012 2013
<br />Current year Current year Preliminary Budget Budget
<br />Account Number Account Title Actual Budget Budget Variance Variance%
<br />WATER FUND
<br />INTERGOVERNMENTAL REVENUES
<br />601-33401-000 PERA AID 3 .00 .00 .00 .00
<br />Total INTERGOVERNMENTAL REVENUES: 3 .00 .00 .00 .00
<br />ASSESSMENTS/PRINCIPAUINTEREST
<br />601-36101-000 SPECIALASSESSMENTS 210 .00 .00 .00 .00
<br />601-36203-000 MISCELLANEOUS REVENUE 397 .00 .00 .00 .00
<br />601-36210-000 INTEREST EARNINGS 2,227 5,500 3,400 ( 2,100) -61.76%
<br />Total ASSESSMENTS/PRINCIPAUINTEREST: 2,833 5,500 3,400 ( 2,100) -61.76%
<br />WATER SALES
<br />601-37110-000 WATER SALES 128,502 214,970 223,500 8,530 3.82%
<br />Budget notes:
<br />-2013 RATE INCREASES PER RATE STUDY
<br />601-37171-000 STATE SALES TAX COLLECTED 2,285 4,000 4,000 .00 .00
<br />601-37172-000 WATER METER FEES 7,135 11,220 11,500 280 2.43%
<br />Budget notes:
<br />-2013 RATE INCREASES PER RATE STUDY
<br />Total WATER SALES: 137,922 230,190 239,000 8,810 3.69%
<br />�--OTHER FINANCING SOURCES
<br />60139310-000 G O BOND PROCEEDS 12,685 .00 .00 .00 .00
<br />601-39990-000 REFUNDS & REIMBURSEMENTS 2,711 .00 .00 .00 .00
<br />Total OTHER FINANCING SOURCES: 15,396 .00 .00 .00 .00
<br />WATER
<br />601-49400-100 WAGES 9,871 16,470 19,040 2,570 13.50%
<br />Budget notes:
<br />�2013 2.5% INCREASE, 12% OF PW SUPERVISOR'S WAGES, 2.5% OF FINANCE ADMIN WAGES, 33% OF OFFICE ASST WAGES
<br />601-49400-121 EMPLOYER SHARE - PERA 710 1,190 1,380 190 13.77%
<br />601-49400-122 EMPLOYER SHARE - FICA 580 1,030 1,190 160 13.45%
<br />601-49400-125 EMPLOYER SHARE - MEDICARE 139 240 280 40 14.29%
<br />601-49400-131 EMPLOYER SHARE - HEALTH INSURA 1,963 3,260 3,820 560 14.66%
<br />Budget notes:
<br />�2013 0% INCREASE
<br />601-49400-133 EMPLOYER SHARE - LIFE INSURANC 11 20 30 10 33.33%
<br />601-49400-200 OFFICE SUPPLIES 258 500 250 ( 250) -100.00%
<br />601-49400-210 OPERATING SUPPLIES 4,020 6,500 6,700 200 2.99%
<br />Budget notes:
<br />�2013 WATER EQUIP, MACHINE REPAIR PARTS, CHEMICALS, TRUCK TIRES
<br />601-49400-217 CLOTHING ALLOWANCE .00 100 .00 ( 100) .00
<br />601-49400-303 ENGINEERING FEES .00 5,000 2,500 ( 2,500) -100.00%
<br />601-49400-304 LEGAL FEES 688 1,500 1,500 .00 .00
<br />601-49400-305 MEDICAL .00 200 200 .00 .00
<br />601-49400-308 TRAVEUCONFERENCES/SCHOOLS .00 500 .00 ( 500) .00
<br />601-49400-310 SALES 8� USE TAX 1,442 4,300 4,300 .00 .00
<br />�01-49400-311 RISK MANAGEMENT 114 200 200 .00 .00
<br />�, Budget notes:
<br />�2013 SAFETY SUPPL - GOGGLES, GLOVES, ETC...
<br />601-49400-313 CONTRACT SERVICES 23,569 31,500 31,500 .00 .00
<br />Budget notes:
<br />
|