CITY OF FLORENCE, SC Monthly Financial Report August 2015
City of Florence Finance Department
City of Florence, SC Monthly Financial Report Table of Contents For the Month Ended August 31, 2015 General Fund………………………………………………………………………………………… 2 Water & Sewer Operations Fund……………….………………………………………………… 4 Stormwater Operations Fund……………………………………………………………………… 6 Hospitality Fund……………………………………………………………………………………… 8 Water & Sewer Construction Fund…………………………………………………………………10 Stormwater Construction Fund……………………………..………………………………………12
1
City of Florence, SC General Fund Schedule of Revenues and Expenditures For the Month Ended August 31, 2015
Current Budget Revenues: Property Taxes Licenses and Fees Governmental Reimbursements Charges for Services Fines and Forfeitures Investment Earnings Miscellaneous Other Funding Sources Transfers Total Revenues
$ 9,304,200 11,870,000 3,021,300 2,096,000 635,000 22,000 285,000 150,000 4,736,500 $ 32,120,000
Current Budget Expenditures: City Council City Court City Manager Finance & Accounting HR/Risk Management Community Services Police Fire Beautification & Facilities Sanitation Equipment Maintenance Recreation Programs Athletic Programs Planning Research & Development Other Employee Benefits General Insurance/Claims Community Programs Non Departmental Total Expenditures Target year-to-date percentage
$
284,080 640,000 392,900 812,070 541,040 310,300 10,142,070 5,405,620 2,532,980 3,298,100 461,890 1,216,660 1,279,840 362,500 542,650 530,000 260,000 3,107,300 $ 32,120,000
16.67%
2
Year-to-date Total $
Current Month
955,702 495,009 261,304 327,886 49,370 5,060 59,464 770,352 $ 2,924,147
955,702 117,330 226,304 150,649 16,018 2,872 17,392 383,918 $ 1,870,184
Year-to-date Total
Current Month
$
43,006 97,229 71,043 141,310 95,714 57,282 1,578,499 989,654 504,667 493,108 58,491 228,263 240,652 61,141 79,956 212,636 53,501 920,549 $ 5,926,701
$
$
21,213 39,186 28,338 54,165 39,462 22,901 640,700 404,174 255,978 326,265 24,339 83,867 105,715 22,756 51,976 11,910 3,501 509,584 $ 2,646,034
Percent of Budget 10.27% 4.17 8.65 15.64 7.77 23.00 20.86 0.00 16.26 9.10%
Percent of Budget 15.14% 15.19 18.08 17.40 17.69 18.46 15.56 18.31 19.92 14.95 12.66 18.76 18.80 16.87 14.73 40.12 20.58 29.63 18.45%
General Fund Revenues $35,000
$32,120
Thousands of Dollars
$30,000 $25,000 $20,000
Current Month Year-to-date Total
$15,000
Current Budget
$10,000 $5,000
$1,870
$2,924
$0 August 2015
General Fund Expenditures $35,000
$32,120
Thousands of Dollars
$30,000 $25,000 $20,000
Current Month Year-to-date Total
$15,000
Current Budget
$10,000 $5,927
$5,000
$2,646
$0 August 2015
3
City of Florence, SC Water & Sewer Utility Schedule of Revenues and Expenses For the Month Ended August 31, 2015
Revenues: Water Charges Sewer Charges Sewer Surcharges Reconnection Fees Water Tap Fees Customer Service Fees Sewer Tap Fees Investment Earnings Miscellaneous Interdepartmental Transfer Total Revenues
Expenses: Utilities & Licensing Engineering Waste Water Treatment Surface Water Production Ground Water Production Distribution Operations Collection Operations Debt Service Other Employee Benefits General Insurance/Claims Non Departmental Total Expenses Target year-to-date percentage
Current Budget
Year-to-date Total
Current Month
$ 15,942,000 16,506,000 20,000 185,000 405,000 240,000 165,000 18,000 1,903,000 (3,184,000) $ 32,200,000
$ 2,825,112 2,870,366 4,131 27,920 83,867 47,294 27,167 4,507 830,680 (460,347) $ 6,260,697
$ 1,478,259 1,512,498 2,344 18,670 54,181 23,329 17,358 2,285 738,045 (265,300) $ 3,581,668
Current Budget
Year-to-date Total
Current Month
$ 1,837,720 1,268,950 4,227,910 1,784,070 1,874,950 1,739,290 1,275,880 11,012,000 182,230 322,000 6,675,000 $ 32,200,000
$
243,008 187,769 559,872 240,451 311,152 266,133 194,413 1,821,303 14,294 129,091 1,192,453 $ 5,159,938
16.67%
4
$
109,535 66,991 280,489 126,364 136,709 114,246 83,030 940,383 8,766 11,577 416,737 $ 2,294,826
Percent of Budget 17.72% 17.39 20.66 15.09 20.71 19.71 16.46 25.04 43.65 14.46 19.44%
Percent of Budget 13.22% 14.80 13.24 13.48 16.60 15.30 15.24 16.54 7.84 40.09 17.86 16.02%
Water & Sewer Utility Revenues
Thousands of Dollars
$35,000
$32,200
$30,000 $25,000 Current Month
$20,000
Year-to-date Total Current Budget
$15,000 $10,000 $6,261
$5,000
$3,582
$0 August 2015
Water & Sewer Utility Expenses $35,000
$32,200
Thousands of Dollars
$30,000 $25,000 Current Month
$20,000
Year-to-date Total
$15,000
Current Budget
$10,000 $5,000
$5,160 $2,295
$0 August 2015
5
City of Florence, SC Stormwater Utility Schedule of Revenues and Expenses For the Month Ended August 31, 2015
Current Budget Revenues: Charges for Services Investment Earnings Miscellaneous Transfers Total Revenues
$ 1,286,000 2,000 2,000 60,000 $ 1,350,000
Current Budget Expenses: Stormwater Operations Debt Service Other Employee Benefits General Insurance/Claims Non Departmental Total Expenses Target year-to-date percentage
$
696,030 339,400 14,570 9,000 291,000 $ 1,350,000 16.67%
6
Year-to-date Total $
$
215,087 335 2,935 60,000 278,357
Current Month $
$
Year-to-date Total $
$
126,585 59,292 1,414 3,981 45,000 236,272
108,163 174 515 108,852
Current Month $
$
47,377 27,946 937 23,000 99,260
Percent of Budget 16.73% 16.76 146.75 100.00 20.62%
Percent of Budget 18.19% 17.47 9.70 44.24 15.46 17.50%
Stormwater Utility Revenues $1,600 $1,350
Thousands of Dollars
$1,400 $1,200 $1,000
Current Month Year-to-date Total
$800
Current Budget
$600 $400 $200
$278 $109
$0 August 2015
Stormwater Utility Expenses $1,600 $1,350
Thousands of Dollars
$1,400 $1,200 $1,000
Current Month Year-to-date Total
$800
Current Budget
$600 $400 $200
$236 $99
$0 August 2015
7
City of Florence, SC Hospitality Fund Schedule of Revenues and Expenditures For the Month Ended August 31, 2015
Current Budget Revenues: Hospitality Fees Investment Earnings Total Revenues
$ 3,595,000 5,000 $ 3,600,000
Current Budget Expenditures: Contingency Fund Freedom Florence/Tennis Center Florence Museum Coastal Plain League Florence Downtown Develop. Corporation Florence Downtown Develop. Incentives Downtown Promotions Downtown Improvements Radio Drive/Veteran's Park Debt Service Tennis Center Debt Service Rec Facility/Gym Debt Service Florence Historic District Lighting Florence Civic Center Total Expenditures Target year-to-date percentage
$
75,500 960,000 40,000 35,000 79,600 80,000 30,000 231,500 538,700 257,700 30,000 1,242,000 $ 3,600,000 16.67%
8
Year-to-date Total $ $
632,613 212 632,825
Current Month $ $
Year-to-date Total $
$
160,000 35,000 19,900 80,000 3,326 5,000 104,000 407,226
304,185 118 304,303
Current Month $
$
80,000 3,326 2,500 52,100 137,926
Percent of Budget 17.60% 4.23 17.58%
Percent of Budget 0.00% 16.67 0.00 100.00 25.00 100.00 0.00 100.00 0.00 0.00 0.00 16.67 8.37 11.31%
Hospitality Fund Revenues $4,000 $3,600
Thousands of Dollars
$3,500 $3,000 $2,500
Current Month Year-to-date Total
$2,000
Current Budget
$1,500 $1,000 $500
$633 $304
$0 August 2015
Hospitality Fund Expenditures $4,000 $3,600
Thousands of Dollars
$3,500 $3,000 $2,500
Current Month
$2,000
Year-to-date Total Current Budget
$1,500 $1,000 $407
$500 $138
$0 August 2015
9
City of Florence, SC Water & Sewer Construction Schedule of Revenues and Expenses For the Month Ended August 31, 2015 Current Budget Revenues: From Unappropriated Reserves EDA Grant Highway 76 Transfer From Water and Sewer Fund Utility Relocation Reimb for Hwy Projects Florence County Infrastucture Reimb. Investment Earnings Total Revenues
$ 1,513,000 $ 345,000 2,300,000 1,211,000 120,000 25,000 $ 5,514,000
Current Budget
Expenses: Country Creek Sewer Extension Oakdale Area Water Pressure Improvement Revise Land Subdivion Codes (UDO) Elevated Water Tank Inspection/Maint Jeffries Creek Beaver Management Water Line Ext. Requests - Florence County SCDOT Road Widening - Pamplico Hwy S Cashua Utility Relocation WWMF Access Road Pee Dee Commerce Park Water/Sewer Hoffmeyer Rd Sewer Ext. Downtown Street Resurface National Cemetery Rd Sewer Ext Sewer Line Easment Clearing Chase St. Sewer Repair McCown St Water Plant Vessel Replace. Gulley Branch Sewer Relocate Florence Crossing Lift Station Florence County EMS Lift Station Wren Creek Water Line Replacement Sumter St Sewer Improvement Indigo Pointe Sewer Relocation City Center Emergency Operations System Utility Line Engineering/Legal Reserve For Other Projects Total Expenses
$
5,000 250,000 6,000 300,000 7,000 100,000 912,000 355,000 235,000 200,000 190,000 137,000 40,000 200,000 30,000 650,000 50,000 300,000 15,000 40,000 250,000 100,000 150,000 992,000 $ 5,514,000
10
Year-to-date Total $ $
$
1,513,000 383,000 159,112 1,660 2,056,771
Current Month $ 1,513,000 $ 191,700 159,112 861 $ 1,864,672
Year-to-date Total $
$
107,212 107,212
Current Month $
$
107,212 107,212
Percent of Budget 100.00% 0.00 16.65 13.14 0.00 6.64% 37.30%
Percent of Budget 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 53.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.94%
Water & Sewer Utility Construction Revenues
Thousands of Dollars
$6,000
$5,514
$5,000 $4,000
Current Month Year-to-date Total
$3,000 $2,000
$1,865
Current Budget
$2,057
$1,000 $0 August 2015
Water & Sewer Utility Construction Expenses
Thousands of Dollars
$6,000
$5,514
$5,000 $4,000
Current Month Year-to-date Total
$3,000
Current Budget
$2,000 $1,000 $0
$107
$107
August 2015
11
City of Florence, SC Stormwater Construction Schedule of Revenues and Expenses For the Month Ended August 31, 2015
Current Budget Revenues: From Unappropriated Reserves Transfer from Stormwater Fund Investment Earnings Total Revenues
$
$
643,000 100,000 5,000 748,000
Current Budget Expenses: Division Pipe Projects End-of-Pipe Water Quality Enhancement Double-Barrell Pipe Repair Timrod Park Pipe Outfall Improvement NPDES Phase II Compliance Malden-Damon Strom Drainage Imp Walden St/Washington St. Storm Drain Edisto/Jackson Storm Drain Edisto/Madison Storm Drain 612 Marion St Storm Drain Pipe Stormwater Engineering Reserved For Other Projects Total Expenses
$
$
10,000 5,000 10,000 65,000 50,000 100,000 25,000 40,000 25,000 25,000 25,000 368,000 748,000
12
Year-to-date Total $
$
643,000 16,000 310 659,310
Current Month $
$
Year-to-date Total $
$
8,931 8,931
643,000 8,400 160 651,560
Current Month $
$
8,931 8,931
Percent of Budget 100.00% 16.00 6.19 88.14%
Percent of Budget 0.00% 0.00 0.00 13.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.19%
Stormwater Utility Construction Revenues $760
$748
Thousands of Dollars
$740 $720 $700
Current Month
$680
Year-to-date Total
$660
$659
Current Budget
$652
$640 $620 $600 August 2015
Stormwater Utility Construction Expenses $800
$748
Thousands of Dollars
$700 $600 $500
Current Month
$400
Year-to-date Total Current Budget
$300 $200 $100 $9
$0
$9
August 2015
13