Page 63 - Dalworthington Gardens FY20 Approved Budget
P. 63
ENTERPRISE FUND P&L DETAILS 2017-18 2018-19 2018-19 2019-20
% of
Projected
Account Number Account Description ACTUAL Amended Budget Projected % of Budget Proposed Budget FY 2018-19
00.4300 Water Sales: Billed 1,026,453 929,678 $ 894,220 96% $ 1,061,668 119%
00.4301 Water Sales: Non-Billed 8,565 - $ - 0% $ - 0%
00.4305 Sewer Sales: Billed 550,528 511,468 $ 518,560 101% $ 623,380 120%
00.4315 Permits & Fees:Connection Fees 2,524 2,276 $ 2,713 119% $ 2,600 96%
00.4318 Permits & Fees:Sewer Tap Fee 260 - $ 390 0% $ - 0%
00.4320 Permits & Fees:Meter & Tap Fee (1,096) - $ 1,525 0% $ - 0%
00.4400 Impact Fees: DWG Water (2,943) - $ - 0% $ - 0%
00.4405 Impact Fees: Sewer (356) - $ - 0% $ - 0%
Total Water/Sewer Sales & Fees 1,583,936 1,443,422 $ 1,417,408 98% $ 1,687,648 119%
00.4465 Chrg for Serv:Refuse Collectio 168,481 172,733 $ 172,852 100% $ 177,172 102%
00.4470 Chrg for Serv:Haz Waste Collection Fee - 2,571 $ 2,601 101% $ 10,416 400%
Total Charges for Service 168,481 175,304 $ 175,453 100% $ 187,588 107%
00.4800 Other Rev:Int from Investments 2,401 4,327 $ 4,289 99% $ 4,500 105%
00.4805 Other Rev:Delinquent Charge 23,854 21,484 $ 19,718 92% $ 21,000 107%
00.4810 Other Rev:Cellular Tower Lease 14,692 14,692 $ 14,692 100% $ 14,692 100%
00.4815 Other Rev:CC Online Payments 1,268 1,424 $ 1,530 107% $ 1,450 95%
00.4816 Other Rev: Sales Tax Discount 69 53 $ 49 94% $ 36 73%
00.4890 Other Rev: Miscellaneous 3,084 140 $ 210 150% $ 150 71%
Total Other Revenue 45,368 42,119 $ 40,488 96% $ 41,828 103%
00.4900 Transfer In 154,563 - $ - 0% $ - 0%
Total Other Uses 154,563 - $ - 0% $ - 0%
TOTAL REVENUES 1,952,347 1,660,845 $ 1,633,349 98% $ 1,917,064 117%
40.6000 Personnel:Salaries Full Time 205,196 188,364 $ 188,306 100% $ 208,743 111%
40.6005 Personnel:Salaries Part Time 13,601 7,810 $ 7,572 97% $ - 0%
40.6015 Personnel:Salaries Standby 8,796 9,579 $ 9,573 100% $ 9,600 100%
40.6020 Personnel:Salaries Overtime 7,648 3,815 $ 3,267 86% $ 3,380 103%
40.6025 Personnel:Salaries Sick Leave 1,274 813 $ 813 100% $ 2,087 257%
40.6036 Personnel:Supplements 10,758 11,089 $ 11,089 100% $ 11,673 105%
40.6050 Personnel:Service Pay-Longevit 1,803 884 $ 884 100% $ 1,041 118%
Total Salaries & Wages 249,076 222,353 $ 221,504 100% $ 236,524 107%
40.6030 Personnel:FICA(SS) & MediCare 18,191 15,993 $ 15,724 98% $ 17,503 111%
40.6031 Personnel: SUTA Taxes 817 34 $ 34 99% $ 34 100%
40.6042 Personnel:ER-Life/AD&D Ins 42 141 $ 141 100% $ 162 115%
40.6043 Personl:AffordableCareActFees 1,219 - $ - 0% $ - 0%
40.6045 Personnel:TMRS 45,391 46,425 $ 45,700 98% $ 50,167 110%
40.6046 Personnel:ER Long Term Disab 691 649 $ 648 100% $ 746 115%
40.6047 Personnel:Employee Health Ins 36,741 27,748 $ 27,803 100% $ 35,151 126%
40.6048 Personnel:Health Savings Acct 2,011 2,974 $ 2,999 101% $ 3,174 106%
40.6049 Personnel:ER Short Term Disab 394 361 $ 361 100% $ 412 114%
40.6099 Personnel:TMRS OPED Supplemental Exp 796 - $ - 0% $ - 0%
Total Taxes & Benefits 106,291 94,325 $ 93,410 99% $ 107,348 115%
