|
CITY OF PEQUOT LAKES Budget Worksheet-2016 Year End Report Page: 23
<br /> Period: 14/16 May 23,2017 03:15PM
<br /> 2016 2016 Budget Budget
<br /> Account Number Account Title Actual Budget Variance Variance%
<br /> WATER FUND
<br /> INTERGOVERNMENTAL REVENUES
<br /> 601-33401-000 PERA AID 17 .00 ( 17) .00
<br /> Total INTERGOVERNMENTAL REVENUES: 17 .00 ( 17) .00
<br /> ASSESSMENTS/PRINCI PAUI NTEREST
<br /> 601-36101-000 SPECIAL ASSESSMENTS 950 .00 ( 950) .00
<br /> 601-36203-000 MISCELLANEOUS REVENUE 189 .00 ( 189) .00
<br /> 601-36210-000 INTEREST EARNINGS 1,874 8,000 6,126 23%
<br /> Total ASSESSMENTS/PRINCIPAUINTEREST: 3,012 8,000 4,988 38%
<br /> WATER SALES
<br /> 601-37110-000 WATER SALES 254,228 233,800 ( 20,428) 109%
<br /> 601-37171-000 STATE SALES TAX COLLECTED 5,224 4,000 ( 1,224) 131%
<br /> 601-37172-000 WATER METER FEES 14,136 12,760 ( 1,376) 111%
<br /> Total WATER SALES: 273,588 250,560 ( 23,028) 109%
<br /> OTHER FINANCING SOURCES
<br /> 601-39990-000 REFUNDS&REIMBURSEMENTS 4,473 2,800 ( 1,673) 160%
<br /> Account notes:
<br /> State test fees,insurance dividends,reimb for water meters
<br /> Total OTHER FINANCING SOURCES: 4,473 2,800 ( 1,673) 160%
<br /> WATER
<br /> 601-49400-100 WAGES 12,151 17,220 5,069 71%
<br /> 601-49400-121 EMPLOYER SHARE-PERA ( 3,492) 1,290 4,782 -271%
<br /> 601-49400-122 EMPLOYER SHARE-FICA 645 1,070 425 60%
<br /> 601-49400-125 EMPLOYER SHARE-MEDICARE 148 250 102 59%
<br /> 601-49400-131 EMPLOYER SHARE-HEALTH INSURA 2,409 4,710 2,301 51%
<br /> 601-49400-133 EMPLOYER SHARE-LIFE INSURANC 10 20 10 52%
<br /> 601-49400-200 OFFICE SUPPLIES 437 250 ( 187) 175%
<br /> 601-49400-210 OPERATING SUPPLIES 22,562 8,000 ( 14,562) 282%
<br /> Account notes:
<br /> MXUs,chemicals,meter parts,misc supplies
<br /> 601-49400-300 PROFESSIONAL SERVICES 1,488 1,000 ( 488) 149%
<br /> Account notes:
<br /> Wells Fargo bank fees
<br /> 601-49400-303 ENGINEERING FEES .00 2,500 2,500 .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-308 TRAVEUCONFERENCES/SCHOOLS 166 .00 ( 166) .00
<br /> 601-49400-310 SALES&USE TAX 5,073 4,000 ( 1,073) 127%
<br /> 601-49400-311 RISK MANAGEMENT .00 200 200 .00
<br /> 601-49400-313 CONTRACT SERVICES 27,856 34,000 6,144 82%
<br /> 601-49400-321 TELEPHONE 858 860 2 100%
<br /> 601-49400-322 POSTAGE 1,531 1,500 ( 31) 102%
<br /> 601-49400-334 FUEL 686 1,300 614 53%
<br /> 601-49400-350 PUBLISHING 225 300 75 75%
<br /> 601-49400-360 INSURANCE 2,241 3,000 759 75%
<br /> 601-49400-381 ELECTRICITY 13,825 12,500 ( 1,325) 111%
<br /> 601-49400-383 HEATING 1,071 2,800 1,729 38%
<br /> 601-49400-384 SANITATION .00 200 200 .00
<br />
|