|
CITY OF PEQUOT LAKES Budget Worksheet-2015 Year End Report Page: 24
<br /> Period: 14/15 May 28,2016 10:43AM
<br /> 2015 2015 Budget Budget
<br /> Account Number Account Title Actual Budget Variance Variance%
<br /> WATER FUND
<br /> INTERGOVERNMENTAL REVENUES
<br /> 601-33401-000 PERA AID 32 .00 ( 32) .00
<br /> Total INTERGOVERNMENTAL REVENUES: 32 .00 ( 32) .00
<br /> ASSESSMENTS/PRINCIPAL/INTEREST
<br /> 601-36101-000 SPECIAL ASSESSMENTS 333 .00 ( 333) .00
<br /> 601-36203-000 MISCELLANEOUS REVENUE 116 .00 ( 116) .00
<br /> 601-36210-000 INTEREST EARNINGS 4,613 9,000 4,387 51%
<br /> Total ASSESSMENTS/PRINCIPAL/INTEREST: 5,062 9,000 3,938 56%
<br /> WATER SALES
<br /> 601-37110-000 WATER SALES 240,889 227,540 ( 13,349) 106%
<br /> 601-37171-000 STATE SALES TAX COLLECTED 4,518 4,000 ( 518) 113%
<br /> 601-37172-000 WATER METER FEES 16,539 12,300 ( 4,239) 134%
<br /> Total WATER SALES: 261,945 243,840 ( 18,105) 107%
<br /> OTHER FINANCING SOURCES
<br /> 601-39990-000 REFUNDS&REIMBURSEMENTS 3,083 2,900 ( 183) 106%
<br /> Account notes:
<br /> State test fees, insurance dividends, reimb for thermometers
<br /> Total OTHER FINANCING SOURCES: 3,083 2,900 ( 183) 106%
<br /> WATER
<br /> 601-49400-100 WAGES 16,314 16,180 ( 134) 101%
<br /> 601-49400-121 EMPLOYER SHARE-PERA 1,588 1,230 ( 358) 129%
<br /> 601-49400-122 EMPLOYER SHARE-FICA 900 1,010 110 89%
<br /> 601-49400-125 EMPLOYER SHARE-MEDICARE 210 240 30 87%
<br /> 601-49400-131 EMPLOYER SHARE-HEALTH INSURA 3,992 4,360 368 92%
<br /> 601-49400-133 EMPLOYER SHARE-LIFE INSURANC 17 20 3 85%
<br /> 601-49400-200 OFFICE SUPPLIES 629 250 ( 379) 251%
<br /> 601-49400-210 OPERATING SUPPLIES 24,945 7,400 ( 17,545) 337%
<br /> Account notes:
<br /> MXUs, chemicals, meter parts, misc supplies, patch by Dairy Queen,thermometers,hydrant meter gate&check valve
<br /> 601-49400-300 PROFESSIONAL SERVICES 1,192 .00 ( 1,192) .00
<br /> Account notes:
<br /> Wells Fargo bank fees
<br /> 601-49400-303 ENGINEERING FEES 1,200 .00 ( 1,200) .00
<br /> 601-49400-304 LEGAL FEES .00 1,500 1,500 .00
<br /> 601-49400-305 MEDICAL .00 200 200 .00
<br /> 601-49400-310 SALES&USE TAX 4,541 4,000 ( 541) 114%
<br /> 601-49400-311 RISK MANAGEMENT .00 200 200 .00
<br /> 601-49400-313 CONTRACT SERVICES 40,161 34,000 ( 6,161) 118%
<br /> Account notes:
<br /> Computer service,software support, lab analysis,copier lease, PRASD service, pumps&wells inspection,water plant
<br /> exterior power treatment,fire ext certifications, RPZ testing
<br /> 601-49400-321 TELEPHONE 831 850 19 98%
<br /> 601-49400-322 POSTAGE 1,547 1,400 ( 147) 110%
<br /> 601-49400-334 FUEL 734 1,300 566 56%
<br /> 601-49400-350 PUBLISHING 58 300 242 19%
<br /> 601-49400-360 INSURANCE 2,464 4,000 1,536 62%
<br /> 601-49400-381 ELECTRICITY 11,117 12,000 883 93%
<br />
|