CITY OF PEQUOT LAKES 2018 PRELIMINARY BUDGET Page: 20
<br /> Period:10/17 Oct 29,2017 12:08PM
<br /> 01/17-10/17 2017 2018
<br /> Current year Current year Preliminary Budget Budget
<br /> Account Number Account Title Actuai Budget Budget Variance Variance%
<br /> WATER FUND
<br /> INTERGOVERNMENTAL REVENUES
<br /> 601-33401-000 PERA AID 18 0 0 0 .00
<br /> Total INTERGOVERNMENTAL REVENUES: 18 0 0 0 0
<br /> ASSESSMENTS/PRINCIPAUINTEREST
<br /> 601-36101-000 SPECIALASSESSMENTS ( 290) 0 0 0 .00
<br /> 601-36203-000 MISCELLANEOUS REVENUE 105 0 0 0 .00
<br /> 601-36210-000 INTEREST EARNINGS 5,032 15,000 7,000 ( 8,000) -53.33%
<br /> Total ASSESSMENTS/PRINCIPAUINTEREST: 4,847 15,000 7,000 ( 8,000) -53.33%
<br /> WATER SALES
<br /> 601-37110-000 WATER SALES 199,481 260,490 261,600 1,110 0.43%
<br /> 601-37171-000 STATE SALES TAX COLLECTED 3,863 4,200 5,000 800 19.05°/a
<br /> 601-37172-000 WATER METER FEES 10,952 13,270 13,490 220 1.66%
<br /> Total WATER SALES: 214,296 277,960 280,090 2,130 0.77%
<br /> OTHER FINANCING SOURCES
<br /> 601-39990-000 REFUNDS&REIMBURSEMENTS 2,502 2,800 2,800 0 .00
<br /> Budget notes:
<br /> �2018 P&C INSURANCE DIVIDEND$400,STATE TEST FEES$2,400
<br /> Total OTHER FINANCING SOURCES: 2,502 2,800 2,800 0 0
<br /> WATER
<br /> 601-49400-100 WAGES 13,521 17,440 18,330 890 5.10%
<br /> Budget notes:
<br /> ^�2018 3.5%INCREASE,ALLOCATIONS=12%FOR PUBLIC WORKS SUPERVISOR,5%FOR CITY CLERK,25%FOR ADMIN ASST
<br /> 601-49400-121 EMPLOYER SHARE-PERA 1,057 1,310 1,380 70 5.34%
<br /> 601-49400-122 EMPLOYER SHARE-FICA 760 1,090 1,140 50 4.59%
<br /> 601-49400-125 EMPLOYER SHARE-MEDICARE 189 260 270 10 3.85%
<br /> 601-49400-131 EMPLOYER SHARE-HEALTH INSURA 3,242 4,040 4,100 60 1.49%
<br /> 601-49400-133 EMPLOYER SHARE-LIFE INSURANC 17 30 30 0 .00
<br /> 601-49400-200 OFFICE SUPPLIES 1,207 500 250 ( 250) -50.00%
<br /> Budget notes:
<br /> �2018 MISC
<br /> 601-49400-210 OPERATING SUPPLIES 15,731 8,000 10,000 2,000 25.00%
<br /> Budget notes:
<br /> �2018 WATER EQUIP,REPAIR PARTS,CHEMICALS
<br /> 601-49400-300 PROFESSIONAL SERVICES 1,068 1,000 1,000 0 .00
<br /> Budget notes:
<br /> �2018 ASSET PORTFOLIO BANK FEES
<br /> 601-49400-303 ENGINEERING FEES 0 2,500 2,500 0 .00
<br /> Budget notes:
<br /> �2018 STREET QUADRANT PROJECT
<br /> 601-49400-304 LEGAL FEES 0 1,500 1,500 0 .00
<br /> 601-49400-305 MEDICAL 0 200 200 0 .00
<br /> 601-49400-310 SALES&USE TAX 4,196 4,000 5,000 1,000 25.00%
<br /> 601-49400-311 RISK MANAGEMENT 0 200 200 0 .00
<br /> 601-49400-313 CONTRACT SERVICES 26,235 38,000 35,930 ( 2,070) -5.45%
<br /> Budget notes:
<br /> �2018 TESTING,CASELLE SOFTWARE SUPPORT, PRASD CONTRACT, EQUIP SERVICES,COPY MACHINE LEASE,CREDIT
<br />
|