city manager’s 2020 preliminary budget - springfield, ohio · table of contents (continued)-2-the...

61
City Manager’s 2020 Preliminary Budget November 1, 2019

Upload: others

Post on 22-Jul-2020

1 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

City Manager’s 2020 Preliminary Budget November 1, 2019

Page 2: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

City Manager's Budget Message 4

Income Tax Fund

Receipts Summary 8

General Fund

Revenues over Expenditures 10Revenue Summary 11Operating Expenditures 12

Permanent Improvement Fund

Revenues over Expenditures 23Capital Expenditures 24

Special Revenue Funds:

Combined Street Funds

Revenues over Expenditures 30Operating Expenditures 31

Special Police Levy Fund

Revenues over Expenditures 33Operating Expenditures 34

Fire Division Service Enhancement Fund

Revenues over Expenditures 35Operating Expenditures 36

City Manager's 2020 Preliminary Budget

The City of Springfield, Ohio

Table of Contents

-1-

Page 3: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

City Manager's 2020 Preliminary Budget

The City of Springfield, Ohio

Enterprise Funds:

Airport Fund

Revenues over Expenditures 38Operating Expenditures 39

Water Fund

Revenues over Expenditures 40Operating Expenditures 41Capital Expenditures 44

Sewer Fund

Revenues over Expenditures 46Operating Expenditures 47Capital Expenditures 50

Stormwater Fund

Revenues over Expenditures 52Operating Expenditures 53

Internal Service Funds:

Central Stores Fund

Revenues over Expenditures 56Operating Expenditures 57

Service Facility Fund

Revenues over Expenditures 59Operating Expenditures 60

Table of Contents (continued)

-2-

Page 4: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

The City of Springfield, Ohio

Budget Message

City Manager's

-3-

Page 5: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

76 East High Street • Springfield, Ohio 45502 • www.springfieldohio.gov

Equal Opportunity Employer

November 1, 2019 Honorable Mayor and City Commissioners, We are presenting the 2020 Preliminary Budget for your review. The General Fund portion of the budget is presented with a $2,457,346 operating deficit for 2020. This is mostly due to the fact that there are 27 payrolls in 2020 rather than the usual 26. This is consistent with the 5 year forecasts that were presented to City Commission during recent Commission Retreats. We are also recommending transferring additional money from the General Fund to the Permanent Improvement Fund, in an effort to continue to invest in necessary infrastructure and equipment improvements. The estimated reserve at the end of 2020 is 14.3% of 2020’s budgeted expenditures which is less than the Government Finance Officers Association (GFOA) recommended minimum goal of 16%, but is above the Commission goal of 10%. On May 2nd, 2017, the citizens of Springfield voted for a five and a half year, 0.4% additional income tax. The issue passed by a margin of 2­1. The levy continues to provide in excess of $6 million of new revenue annually. In the course of the levy campaign, the City made a number of commitments to our citizens. In keeping with those commitments, the City undertook a Neighborhood Streets paving program of over $2,000,000 in 2019 to pave and repair streets in our residential neighborhoods and will do so again in 2020. The City activated a "Safe Streets Task Force" in 2018 and 2019 by authorizing additional funding for six new police officer positions to address drugs, crime and policing services at the street level. Police staffing levels continue to remain a concern, as we currently sit at 116 sworn officers. The City has made hiring police officers and getting to the authorized strength of 131 a top priority over the last two years and will continue into 2020. The City also reopened the Police Community Substation on Johnny Lytle Avenue and Fire Station #5 on Commerce Road, as promised. Finally, as pledged, this budget is balanced and reserves are rebuilding to prudent levels. This budget continues to be consistent with every one of our commitments. General Fund Revenues For 2020, Income Tax revenues are expected to be $37,520,000. The 2020 budgeted increase over the revised 2019 forecast is $1.1 million which represents an increase of 3.0%. The income tax revenue increase budgeted for 2020 is nearly 22% above the 2017 Actual. It is expected that the revenues from employment gains at both Topre America Corp. and Silfex, Inc. and general improvement in the Springfield economy will continue into 2020. As stressed in previous budget presentations, the largest source of revenue for the General Fund continues to be income tax. It accounts for 79% of the General Fund’s revenue. The Local Government Fund (LGF) and other state shared taxes now only account for 4% of the General Fund revenues. Services & Charges and Fines & Forfeitures account for 4% and 3%, respectively. The remainder of the revenue is made up mostly of reimbursements for administrative services provided to various funds. The fact that the percentage of total revenue derived from income tax continues to increase is concerning because it makes the General Fund’s financial health extremely vulnerable to downturns in the local economy.

-4-

Page 6: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

76 East High Street • Springfield, Ohio 45502 • www.springfieldohio.gov

Equal Opportunity Employer

The total revenue for the General Fund is budgeted at $47,532,184. This is a $1,155,668 increase over the revised 2019 budget and $1.8 million above the original 2019 budget. Please note, these General Fund numbers do not include the 10% income tax set aside for the Permanent Improvement Fund.

General Fund Expenditures General Fund expenditures reflect our efforts to meet our commitments to align City operations with the City Commission’s 2019­2020 Goals and Objectives, keep promises made to our citizens during the 2017 levy campaign, continue providing quality municipal services, and maintain ongoing control of expenses. Personal services accounts for just less than 80% of the City’s total expenses. It should be noted that 2020 contains 27 bi­weekly payrolls as opposed to the normal 26. This is an unusual occurrence that happens approximately every 11 years. A significant driver of personal service costs is Health Care. We have worked closely with our various employee groups to control this employee benefit cost. By the second quarter of 2019, all employees have been sharing in the cost of health insurance by contributing 15% of the premium. As of July 1, 2018, the City joined the Jefferson Health Plan, thus the City is now participating in a self­insured model in an effort to control future costs. This effort was successful in the first year as our first renewal came with only a 2% increase. We continue to work with our bargaining units to add wellness benchmarks to our plan in an effort to further address rising health care costs. After taking these efforts into account, a 5% increase for health care is budgeted in 2020. Staffing in the Police Division is authorized at 131 sworn positions in 2020. This includes continued funding for 6 police officer positions added in 2018 to staff the reactivated Safe Streets Task Force designed to combat the opioid epidemic and violent crimes. The budget also includes a recently added diversion officer specifically committed to the opioid epidemic. As mentioned previously, staffing in the Police Division remains a concern, and has been a top priority of the organization and will continue to be a priority in 2020. The Johnny Lytle Avenue police substation was reopened in July of 2017 and this budget reflects its continued operation and presence in the local community. Fire Division staffing is authorized at 127 positions, matching the Charter required minimum, and in 2019 we were able to hire 17 new firefighters to get above the 127. Fire Station #5, which was closed during the City’s financial crisis, was reopened in July of 2017. This budget also reflects its continued operation. General Fund staffing for the City in 2020 is budgeted to be 389 full­time equivalents (FTEs). Total staffing is budgeted at 584.6 FTEs, which includes 57 statutory employees at municipal court. This continues to be a substantial reduction over years past when the City had over 700 FTEs. The Police Levy Fund and Fire Enhancement Fund are projected to have insufficient revenue to sustain the expenses currently budgeted. In total, General Fund support of $1,350,000 is necessary to balance these funds. Finally, the City’s funding and support for National Trail Parks & Recreation District (NTPRD) is recommended at $1,225,000 for 2020. Of this amount, $750,000 will come from the General Fund, $300,000 from a contract with NTPRD to maintain Stormwater mitigation for green space throughout the park system, and $175,000 will be from the Permanent Improvement Fund for infrastructure improvements. The City believes that continued significant funding is necessary for the preservation of valuable park assets and to support the programming of NTPRD.

Permanent Improvement Fund In 2019, the Permanent Improvement (PI) Fund is budgeted with $6,713,890 in revenue. As previously indicated, the City will spend a minimum of $2,000,000 on neighborhood streets next year. In addition, there are several other significant road projects budgeted for the City including the paving of Broadway Road, Gateway Boulevard and signal upgrades on existing streets. The total amount of money to be spent on all Springfield roads will exceed $7.0 million for 2020. In addition to the road program, the PI Fund will continue to replace aging and obsolete rolling stock and infrastructure. Some of the more significant replacements include; 2 new snow plows, 9 new police cruisers, and much needed repairs and maintenance to City Hall. This budget includes $1,145,145 for debt service and, as previously stated, $175,000 to NTPRD for capital projects.

-5-

Page 7: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

76 East High Street • Springfield, Ohio 45502 • www.springfieldohio.gov Equal Opportunity Employer

Utility Funds

As we have mentioned in previous budgets, one of the most significant issues facing the City is the United States Environmental Protection Agency (USEPA) mandate to address the Combined Sewer Overflows (CSOs). Improvements to the Waste Water Treatment Plant, which are paid for through the Sewer and Stormwater utilities, were completed in 2015. Debt service for the $60 million High Rate Clarifier at the Waste Water Treatment Plant has begun to significantly impact this fund. The USEPA mandated Erie Express Sewer debt service of $23 million has also impacted the Sewer Fund negatively. City staff has worked very hard to limit costs associated with USEPA’s ongoing mandates in the immediate future. City Commission took action and approved three rate increases in the Sewer utility to address these issues. The first increase of 17% went into effect on January 1, 2018. A second rate increase of 16% went into effect on January 1, 2019. A third increase will be implemented January 1, 2020. This budget reflects those current approved and implemented rate increases. It is projected that by the end of 2019, the Sewer Fund’s cash balances will dip below recommended minimums. Our rate models and this budget suggest that they will recover to acceptable levels in 2020. Future rate increases for this fund are anticipated.

Both the Water Fund and Stormwater Fund will end 2019 with acceptable positive cash balances, however, a number of operational and regulatory factors are now impacting the future of the Water Fund. Significant capital spending will be required to address regulatory mandates regarding Lead Service rules, Disruption of Service rules and Capital Asset Management reporting. On May 4, 2019, City Commission passed rate increases of 10% effective July 1, 2019, January 1, 2020 and 2021.

Even with these anticipated increases, Springfield's total utility rates remain among the lower half of rates in comparison to other communities throughout the Miami Valley.

Our Many Successes

2019 has seen many successes and much momentum throughout our community as City staff has worked diligently towards meeting the City Commission’s 2019­2020 Goals and Objectives and keeping the promises made to our citizens during the 2017 levy campaign. New projects throughout the community are underway, including the downtown parking garage and associated retail, Center Street Townes, Bridgewater subdivision, as well as multiple expansions of businesses throughout Springfield. A focus on housing and the revitalization of our neighborhoods has taken center stage through the development of a comprehensive housing market analysis and engaged neighborhood plan, which culminates in November through Springfield’s first housing conference. The City has also made great strides in keeping the commitments made during the levy campaign by continuing the Neighborhood Streets Paving Program, Safe Streets Task Force, and investing in equipment for our first responders. We still face several challenges as an organization moving into 2020, including staffing levels in the Police Division, creating more competitive compensation packages for our employees, and continuing to improve overall morale throughout the organization; but I am confident that we are moving in the right direction and will continue to face our challenges head­on as an organization in an effort to move our community forward.

Respectfully submitted,

Bryan Heck City Manager

-6-

Page 8: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

15,000,000

20,000,000

25,000,000

30,000,000

35,000,000

40,000,000

45,000,000

2011 2012 2013 2014 2015 2016 2017 2018 2019RevisedBudget

2020Prelim.Budget

Income Tax ReceiptsSpringfield's Income Tax is the primary source of revenue for the City's General Fund and Permanent Improvement

Fund.

-7-

Page 9: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019

Original Revised

Budget Budget

Income Tax ReceiptsWithholding $ 29,775,022 33,549,415 12.7% 34,560,000 34,600,000 3.1% 36,350,000 5.1%Net Profit 6,060,520 5,906,414 -2.5% 6,500,000 6,810,969 15.3% 6,500,000 -4.6%

Subtotal $ 35,835,542 39,455,829 10.1% 41,060,000 41,410,969 5.0% 42,850,000 3.5%

State Intergovernmental(Electric Utility) $ 16,520 332,155 1910.6% 100,000 355,698 7.1% 338,890 -4.7%

Less Refunds $ (966,146) (1,321,028) 36.7% (1,000,000) (1,300,000) -1.6% (1,500,000) 15.4%

NET INCOME TAXPROCEEDS $ 34,885,916 38,466,956 10.3% 40,160,000 40,466,667 5.2% 41,688,890 3.0%

GENERAL FUND $ 30,600,000 35,417,585 36,144,000 36,420,000 37,520,000

PERMANENTIMPROVEMENT FUND 3,400,000 3,935,287 4,016,000 4,046,667 4,168,890

NET INCOME TAXDISTRIBUTIONS $ 34,000,000 * 39,352,872 * 40,160,000 40,466,667 41,688,890

* Due to appropriation limitations, the City was unable to distribute $885,916 in net income tax proceeds in 2017. The funds were distributed on

January 2, 2018.

BudgetCategory Actual Actual Actual Budget Budget

2017 2018 2018 2019 Rev. Preliminary 2020 Req.

Actual Budget

/ / 2020 /

Actual

INCOME TAX RECEIPTS

2017 2018 2019 Rev.

-8-

Page 10: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

GENERAL FUND2020 PRELIMINARY BUDGET

EXPENDITURES

REVENUES

Income Tax 79%

Local Govt Fund & State Shared Taxes

4%

All Other 11%

Services & Charges

3%

Fines & Forfeitures 3%

Neighborhood Services

9%Municipal Court

11%

Public Safety57%

NTPRD & SCAT

2%

All Other21%

-9-

Page 11: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesIncome Tax $ 36,144,000 36,420,000 37,520,000 1,100,000 Hotel / Motel Tax 505,000 505,000 560,000 55,000 Local Government Fund 1,668,820 1,668,815 1,735,004 66,189 State Shared Taxes 88,000 88,000 88,000 - Intergovernmental 336,940 316,936 324,980 8,044 Services and Charges 1,621,950 1,722,290 1,668,000 (54,290) Interest Earnings 325,000 500,000 450,000 (50,000) Fines and Forfeitures 1,468,000 1,466,600 1,466,100 (500) Miscellaneous 112,500 117,000 122,500 5,500 Refunds / Reimbursements 3,437,220 3,571,875 3,597,600 25,725

Total Revenues $ 45,707,430 46,376,516 47,532,184 1,155,668

ExpendituresPersonal Services (excl. Med. Ins.) $ 29,839,330 30,295,970 33,011,950 2,715,980 Medical Insurance 6,211,440 6,036,880 6,655,940 619,060 Education 184,050 208,400 289,580 81,180 Utilities 520,300 544,100 550,360 6,260 Street Lighting 660,000 700,000 714,000 14,000 Contractual Services 3,356,310 3,534,530 3,365,670 (168,860) Materials / Supplies 948,280 949,770 967,830 18,060 Refunds / Reimbursements 41,300 41,300 54,200 12,900 Reimb. - Neighborhood Streets Paving 1,000,000 1,000,000 1,000,000 - Transfers - Airport Fund - - 120,000 120,000 Transfers - Police Levy Fund 900,000 900,000 1,150,000 250,000 Transfers - Fire Enhancement Fund 600,000 300,000 200,000 (100,000) Transfers - Permanent Improvement Fund - 1,000,000 750,000 (250,000) Transfers - Other 210,000 1,110,000 210,000 (900,000) NTPRD Funding 650,000 650,000 750,000 100,000 Transit Funding 200,000 200,000 200,000 -

Total Expenditures $ 45,321,010 47,470,950 49,989,530 2,518,580

Excess Rev. Over (Under) Exp. $ 386,420 (1,094,434) (2,457,346) (1,362,912)

Fund Balance as of Jan. 1 10,498,691 10,685,659 9,591,225 (1,094,434)

Estimated Fund Balance as of Dec. 31 $ 10,885,111 9,591,225 7,133,879 (2,457,346)

Fund Balance as a Percent of Budget 24.02% 20.20% 14.27%

GENERAL FUND

Category

-10-

Page 12: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020

2018 Original Revised Preliminary

Actual Budget Budget Budget

RevenuesIncome Taxes $ 35,417,585 76.6% 36,144,000 36,420,000 78.5% 37,520,000 78.9%Hotel / Motel Taxes 498,135 1.1% 505,000 505,000 1.1% 560,000 1.2%Local Government Fund 1,644,477 3.5% 1,668,820 1,668,815 3.6% 1,735,004 3.6%Shared State Taxes 88,545 0.2% 88,000 88,000 0.2% 88,000 0.2%Intergovernmental 364,435 0.8% 336,940 316,936 0.7% 324,980 0.7%Services and Charges 1,885,872 4.1% 1,621,950 1,722,290 3.7% 1,668,000 3.5%Interest Earnings 359,995 0.8% 325,000 500,000 1.1% 450,000 0.9%Fines and Forfeitures 1,434,790 3.1% 1,468,000 1,466,600 3.1% 1,466,100 3.1%Miscellaneous 868,938 1.9% 112,500 117,000 0.3% 122,500 0.3%Refunds / Reimbursements 3,688,098 7.9% 3,437,220 3,571,875 7.7% 3,597,600 7.6%

Total Revenues $ 46,250,870 100.0% 45,707,430 46,376,516 100.0% 47,532,184 100.0%

Percent

of Total

GENERAL FUND

Category of Total

Percent Percent

of Total

-11-

Page 13: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

City Services

City Commission / ClerkPersonal Svcs. (excl. Med. Ins.) $ 174,130 135,153 143,080 143,080 153,310 10,230 Medical Insurance 54,838 48,313 80,740 80,740 103,000 22,260 Education 1,347 1,957 2,500 2,500 7,000 4,500 Contractual Services 17,129 22,508 32,460 32,460 36,735 4,275 Materials / Supplies 1,872 1,965 1,950 1,950 2,250 300

Total City Commission / Clerk $ 249,316 209,896 260,730 260,730 302,295 41,565

City ManagerPersonal Svcs. (excl. Med. Ins.) $ 291,185 330,482 328,300 331,405 329,000 (2,405) Medical Insurance 27,500 33,264 34,000 34,000 51,000 17,000 Education 4,413 5,402 6,000 8,500 8,500 - Utilities 2,401 2,189 2,700 2,300 2,300 - Contractual Services 4,157 8,344 8,300 8,370 5,300 (3,070) Materials / Supplies 6,169 5,875 6,900 7,290 7,770 480

Total City Manager's Office $ 335,825 385,556 386,200 391,865 403,870 12,005

GENERAL FUND

Department / Division

-12-

Page 14: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

GENERAL FUND

Department / Division

Finance Department

AccountingPersonal Svcs. (excl. Med. Ins.) $ 657,788 801,063 902,870 907,120 986,550 79,430 Medical Insurance 136,344 163,741 195,000 195,000 191,000 (4,000) Education 1,488 5,991 14,400 14,400 14,000 (400) Utilities 858 1,543 800 750 750 - Contractual Services 85,769 91,521 111,700 111,700 113,000 1,300 Materials / Supplies 14,337 12,216 15,000 15,000 15,000 -

Total Accounting $ 896,584 1,076,075 1,239,770 1,243,970 1,320,300 76,330

Income TaxPersonal Svcs. (excl. Med. Ins.) $ 368,056 406,388 454,460 454,460 489,750 35,290 Medical Insurance 66,684 102,816 119,740 119,740 135,000 15,260 Education 2,145 1,281 2,500 2,500 2,500 - Contractual Services 16,788 14,864 18,680 18,680 18,680 - Materials / Supplies 24,427 16,319 19,000 19,000 19,000 -

Total Income Tax $ 478,100 541,668 614,380 614,380 664,930 50,550

PurchasingPersonal Svcs. (excl. Med. Ins.) $ 180,077 177,668 187,300 187,300 204,590 17,290 Medical Insurance 53,504 50,127 51,360 51,360 52,000 640 Education - - 1,500 1,500 1,500 - Contractual Services 647 1,677 1,970 1,970 2,000 30 Materials / Supplies 3,463 2,841 3,000 3,000 2,000 (1,000)

Total Purchasing $ 237,691 232,313 245,130 245,130 262,090 16,960

-13-

Page 15: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

GENERAL FUND

Department / Division

Finance Department (cont.)

Revenue CollectionsPersonal Svcs. (excl. Med. Ins.) $ 25,273 24,526 41,870 12,750 45,510 32,760 Medical Insurance 8,918 3,960 21,980 4,000 18,000 14,000 Education - - - - 500 500 Utilities 411 446 500 400 400 - Contractual Services 49,974 23,482 52,500 52,500 8,100 (44,400) Materials / Supplies 1,018 1,142 2,000 2,000 2,000 -

Total Revenue Collections $ 85,594 53,556 118,850 71,650 74,510 2,860

Total Finance Department $ 1,697,969 1,903,612 2,218,130 2,175,130 2,321,830 146,700

PersonnelPersonal Svcs. (excl. Med. Ins.) $ 269,711 281,848 297,270 322,270 356,980 34,710 Medical Insurance 23,805 26,048 29,190 29,190 45,000 15,810 Education 2,610 6,586 61,000 61,000 71,000 10,000 Contractual Services 113,800 95,305 105,300 105,300 100,950 (4,350) Materials / Supplies 3,152 3,506 3,500 3,500 3,500 -

Total Personnel $ 413,078 413,293 496,260 521,260 577,430 56,170

-14-

Page 16: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

GENERAL FUND

Department / Division

Legal Department

CivilPersonal Svcs. (excl. Med. Ins.) $ 324,205 336,913 547,250 547,250 314,800 (232,450) Medical Insurance 53,504 58,680 65,920 65,920 64,440 (1,480) Education 3,417 2,942 6,500 5,700 6,500 800 Utilities - - - 1,300 1,300 - Contractual Services 9,112 10,841 27,700 27,300 27,000 (300) Materials / Supplies 3,008 3,032 4,000 4,000 4,000 -

Total Civil $ 393,246 412,408 651,370 651,470 418,040 (233,430)

CriminalPersonal Svcs. (excl. Med. Ins.) $ 442,639 472,992 549,640 549,640 544,520 (5,120) Medical Insurance 97,442 110,776 124,290 124,290 125,000 710 Education 866 1,930 3,000 3,000 4,000 1,000 Utilities 1,449 - - - - - Contractual Services 3,940 2,656 5,200 5,850 3,950 (1,900) Materials / Supplies 5,648 5,533 5,000 4,350 6,250 1,900

Total Criminal $ 551,984 593,887 687,130 687,130 683,720 (3,410)

Total Legal Department $ 945,230 1,006,295 1,338,500 1,338,600 1,101,760 (236,840)

-15-

Page 17: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

GENERAL FUND

Department / Division

Service Department

FacilitiesPersonal Svcs. (excl. Med. Ins.) $ 377,957 408,826 468,240 473,240 541,010 67,770 Medical Insurance 95,342 101,261 130,000 130,000 130,000 - Education 2,145 1,366 1,800 1,800 1,800 - Utilities 4,171 4,997 4,900 5,000 5,000 - Contractual Services 85,169 81,888 102,100 102,960 122,470 19,510 Materials / Supplies 108,668 112,217 104,400 125,000 119,315 (5,685)

Total Facilities $ 673,452 710,555 811,440 838,000 919,595 81,595

AdministrationPersonal Svcs. (excl. Med. Ins.) $ 4,950 5,776 - - - - Medical Insurance 597 1,199 - - - -

Total Administration $ 5,547 6,975 - - - -

Fleet MaintenancePersonal Svcs. (excl. Med. Ins.) $ 423,894 425,793 499,790 529,790 590,980 61,190 Medical Insurance 69,146 83,580 87,600 87,600 139,000 51,400

Total Fleet Maintenance $ 493,040 509,373 587,390 617,390 729,980 112,590

Total Service Department $ 1,172,039 1,226,903 1,398,830 1,455,390 1,649,575 194,185

Information TechnologyPersonal Svcs. (excl. Med. Ins.) $ 358,192 368,753 441,050 391,100 487,670 96,570 Medical Insurance 32,379 32,037 54,070 54,070 85,000 30,930 Education 700 3,003 10,000 10,000 25,000 15,000 Utilities 1,175 1,228 1,000 1,300 1,300 - Contractual Services 352,942 396,835 364,800 389,473 415,780 26,307 Materials / Supplies 738 1,315 2,800 2,550 2,600 50

Total Information Technology $ 746,126 803,171 873,720 848,493 1,017,350 168,857

-16-

Page 18: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

GENERAL FUND

Department / Division

EngineeringPersonal Svcs. (excl. Med. Ins.) $ 524,094 478,892 602,200 607,200 763,270 156,070 Medical Insurance 109,091 97,333 153,770 153,770 140,000 (13,770) Education 930 776 1,500 1,500 2,000 500 Utilities 4,235 4,205 3,400 4,200 4,200 - Contractual Services 9,858 7,908 6,700 5,622 9,775 4,153 Materials / Supplies 19,130 22,788 18,300 21,200 25,955 4,755 Reimb. - Neighborhood St. Paving - 1,000,000 1,000,000 1,000,000 1,000,000 -

Total Engineering $ 667,338 1,611,902 1,785,870 1,793,492 1,945,200 151,708

Development Department

Planning / DevelopmentPersonal Svcs. (excl. Med. Ins.) $ 130,067 187,006 218,490 231,770 332,310 100,540 Medical Insurance 41,640 29,937 29,190 29,190 62,000 32,810 Education - 99 500 800 2,000 1,200 Utilities - 132 300 500 600 100 Contractual Services 338 338 500 70,500 61,000 (9,500) Materials / Supplies 1,466 1,947 2,000 3,000 2,400 (600)

Total Planning / Development $ 173,511 219,459 250,980 335,760 460,310 124,550

InspectionsPersonal Svcs. (excl. Med. Ins.) $ 225,181 247,574 335,230 335,230 453,520 118,290 Medical Insurance 52,784 57,960 94,140 94,140 103,000 8,860 Education 1,356 1,288 1,000 1,500 2,000 500 Utilities 2,349 2,324 1,900 1,900 1,900 - Contractual Services 31,338 25,645 43,300 54,448 54,750 302 Materials / Supplies 4,242 8,246 2,300 9,200 9,790 590

Total Inspections $ 317,250 343,037 477,870 496,418 624,960 128,542

-17-

Page 19: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

GENERAL FUND

Department / Division

Development Department (cont.)

Code EnforcementPersonal Svcs. (excl. Med. Ins.) $ 102,994 242,015 332,490 332,490 311,580 (20,910) Medical Insurance 17,760 37,002 50,850 50,850 86,000 35,150 Education 1,215 5,818 5,000 3,000 3,500 500 Contractual Services 52,493 304,589 375,500 380,304 251,800 (128,504) Materials / Supplies - 427 750 1,000 2,000 1,000

Total Code Enforcement $ 174,462 589,851 764,590 767,644 654,880 (112,764)

Human RelationsPersonal Svcs. (excl. Med. Ins.) $ 90,758 159,510 185,260 194,160 208,540 14,380 Medical Insurance 5,971 15,414 7,220 23,220 41,500 18,280 Education - 50 500 200 3,000 Contractual Services 42,200 37,959 42,700 46,110 47,900 1,790 Materials / Supplies 1,788 2,738 3,000 3,500 4,200 700

Total Human Relations $ 140,717 215,671 238,680 267,190 305,140 35,150

Housing RehabPersonal Svcs. (excl. Med. Ins.) $ 120,617 308,716 459,400 459,400 331,300 (128,100) Medical Insurance 59,475 80,840 95,110 95,110 70,000 (25,110) Education - - - - 1,500 1,500 Contractual Services 2,316 2,360 29,000 30,000 32,500 2,500 Materials / Supplies - - 1,500 1,500 - (1,500)

Total Housing Rehab $ 182,408 391,916 585,010 586,010 435,300 (150,710)

Total Development Department $ 988,348 1,759,934 2,317,130 2,453,022 2,480,590 24,768

-18-

Page 20: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

GENERAL FUND

Department / Division

Public Safety

PolicePersonal Svcs. (excl. Med. Ins.) $ 7,974,456 8,088,589 8,849,850 9,104,485 10,077,740 973,255 Medical Insurance 1,324,732 1,502,521 1,862,780 1,862,780 1,990,000 127,220 Education 13,216 18,574 34,000 34,000 35,000 1,000 Utilities 89,871 83,388 85,500 88,000 88,960 960 Contractual Services 223,440 235,795 481,760 445,558 387,120 (58,438) Materials / Supplies 284,015 325,752 358,250 328,000 335,500 7,500 Refunds / Reimbursements - - - - - -

Total Police $ 9,909,730 10,254,619 11,672,140 11,862,823 12,914,320 1,051,497

FirePersonal Svcs. (excl. Med. Ins.) $ 8,185,130 8,841,656 9,416,490 9,545,615 10,287,040 741,425 Medical Insurance 1,441,660 1,673,939 1,809,870 1,809,870 1,850,000 40,130 Education 13,623 11,303 18,270 36,270 84,200 47,930 Utilities 114,332 122,952 118,800 128,500 130,150 1,650 Contractual Services 243,316 261,537 308,270 340,417 311,750 (28,667) Materials / Supplies 105,320 135,935 136,660 136,160 144,510 8,350

Total Fire $ 10,103,381 11,047,322 11,808,360 11,996,832 12,807,650 810,818

Consolidated DispatchPersonal Svcs. (excl. Med. Ins.) $ 959,365 1,097,862 1,142,250 1,228,575 1,249,760 21,185 Medical Insurance 208,242 215,702 300,530 210,000 305,000 95,000 Education 7,499 9,039 6,500 6,500 6,500 - Utilities 15,321 15,077 15,400 19,350 19,500 150 Contractual Services 26,276 28,091 12,500 66,095 96,440 30,345 Materials / Supplies 3,014 5,049 4,000 4,000 4,500 500

Total Consolidated Dispatch $ 1,219,717 1,370,820 1,481,180 1,534,520 1,681,700 147,180

Total Public Safety $ 21,232,828 22,672,761 24,961,680 25,394,175 27,403,670 2,009,495

-19-

Page 21: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

GENERAL FUND

Department / Division

Misc. Non-DepartmentalPersonal Svcs. (excl. Med. Ins.) $ 36,162 12,140 37,800 37,960 38,000 40 Medical Insurance - - - - - - Utilities 229,533 241,769 249,500 255,000 258,400 3,400 Street Lighting 702,947 694,706 660,000 700,000 714,000 14,000 Contractual Services 698,369 843,682 940,250 960,170 961,920 1,750 Materials / Supplies 41,541 55,997 73,450 73,450 74,000 550 Transfers / Subsidies 2,106,563 3,025,104 1,710,000 3,310,000 2,430,000 (880,000) Refunds / Reimbursements 31,890 32,540 41,300 41,300 54,200 12,900

Total Misc. Non-Departmental $ 3,847,005 4,905,938 3,712,300 5,377,880 4,530,520 (847,360)

NTPRD Funding $ 450,000 450,000 650,000 650,000 750,000 100,000

Transit Funding $ 200,000 200,000 200,000 200,000 200,000 -

Total City Services $ 32,945,102 37,549,261 40,599,350 42,860,037 44,684,090 1,821,253

-20-

Page 22: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

GENERAL FUND

Department / Division

Statutory Funded Services

Municipal Court / ClerkPersonal Svcs. (excl. Med. Ins.) $ 1,112,410 1,112,225 1,295,210 1,244,890 1,421,220 176,330 Medical Insurance 224,152 215,217 332,050 250,000 350,000 100,000 Education 918 1,486 4,500 4,500 4,500 - Contractual Services 182,051 179,766 205,500 205,500 216,000 10,500 Materials / Supplies 119,614 122,435 140,000 140,000 140,000 -

Total Municipal Court / Clerk $ 1,639,145 1,631,129 1,977,260 1,844,890 2,131,720 286,830

Municipal Court / JudicialPersonal Svcs. (excl. Med. Ins.) $ 2,007,701 2,015,409 2,103,540 2,124,790 2,493,000 368,210 Medical Insurance 403,628 424,971 482,040 482,040 520,000 37,960 Education 2,425 6,336 3,080 9,230 3,080 (6,150) Utilities 33,738 35,318 35,600 35,600 35,600 - Contractual Services 66,901 84,253 79,620 73,243 80,750 7,507 Materials / Supplies 36,140 41,229 40,520 41,120 41,290 170

Total Municipal Court / Judicial $ 2,550,533 2,607,516 2,744,400 2,766,023 3,173,720 407,697

Total Statutory Funded Services $ 4,189,678 4,238,645 4,721,660 4,610,913 5,305,440 694,527

TOTAL GENERAL FUND $ 37,134,780 41,787,906 45,321,010 47,470,950 49,989,530 2,515,780

-21-

Page 23: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

REVENUES

PERMANENTIMPROVEMENT

FUND - CAPITAL2020 PRELIMINARY BUDGET

EXPENDITURES

Permanent Improvement

Fund37%

Grant Funds 34%

Other Funds 3%

Debt Financed17%

General Fund6%

Street Fund

3%

Public Works projects

16%

Debt Service12%

Public Safety projects

15%NTPRD projects

2%

All Other projects

9%

Engineering projects

21%

Neighborhood Streets Paving

25%

-22-

Page 24: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesIncome Tax $ 4,016,000 4,046,667 4,168,890 122,223 Intergovernmental 35,000 20,000 20,000 - Transfer In (General Fund) - 1,000,000 750,000 (250,000) Transfer In (Combined Street Fund) - - 250,000 250,000 Sale of Assets 25,000 37,950 25,000 (12,950) Reimb. - Neighborhood Streets Paving 1,500,000 1,500,000 1,500,000 - Miscellaneous - 3,690 - (3,690)

Total Revenues $ 5,576,000 6,608,307 6,713,890 105,583

ExpendituresContingencies $ 100,000 55,000 100,000 45,000 Capital 2,794,301 3,783,625 4,526,233 742,608 Capital - Neighborhood Streets Paving 2,000,000 2,000,000 2,000,000 - Capital Contribution - NTPRD 175,000 225,000 175,000 (50,000) Debt Service 883,130 878,670 1,145,145 266,475

Total Expenditures $ 5,952,431 6,942,295 7,946,378 1,004,083

Excess Rev. Over (Under) Exp. $ (376,431) (333,988) (1,232,488) (898,500)

Fund Balance as of Jan. 1 2,240,014 2,275,327 1,941,339 (333,988)

Estimated Fund Balance as of Dec. 31 $ 1,863,583 1,941,339 708,851 (1,232,488)

PERMANENT IMPROVEMENT FUND

Category

-23-

Page 25: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

PERMANENT OTHERIMPROVEMENT FUNDING

DESCRIPTION OF REQUEST FUND SOURCES TOTAL

AirportCrack Seal for Runways and Taxiways $ 32,500 142,500 175,000 Obstacle Removal RWY 15 & 06 Ends 835 15,835 16,670 Perimeter Fencing 25,000 475,000 500,000 Rehab Runway 1533 - Design 8,335 158,335 166,670 Taxiway Charlie - Hotel 111,441 1,002,969 1,114,410 Terminal Updates: Flooring, Lighting, Furniture 30,000 - 30,000 Vehicle Transfer (Airport Manager) 5,000 - 5,000

213,111 1,794,639 2,007,750

City ManagerConference Room / Office Furniture 5,500 - 5,500

5,500 - 5,500

Community DevelopmentVan 25,000 - 25,000

25,000 - 25,000

DispatchRelocation 240,000 - 240,000 Netclock 12,000 - 12,000

252,000 - 252,000

EngineeringNeighborhood Streets Paving Program 2,000,000 - 2,000,000 Broadway - Street Lights 60,000 - 60,000 Broadway Reconstruction 979,582 950,000 1,929,582 Burnett Rd (RR to Columbus Ave) - Construction 150,000 - 150,000 CLA - Sidewalk R/W, PID 109478 - 75,000 75,000 CLA - SR72 Limestone PE - 300,000 300,000 CLA - Trail Maintenance, PID 109480 60,000 240,000 300,000 Derr Rd - Design 75,000 - 75,000 Derr Rd - R/W - 125,000 125,000

PERMANENT IMPROVEMENT FUND - CAPITAL

-24-

Page 26: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

PERMANENT OTHERIMPROVEMENT FUNDING

DESCRIPTION OF REQUEST FUND SOURCES TOTAL

PERMANENT IMPROVEMENT FUND - CAPITAL

Engineering (continued)Gateway Blvd Paving $ - 800,000 800,000 Main & Western - Street Lights 7,500 - 7,500 Main & Western Signal Replacement - 255,000 255,000 McCreight Ave, PID 104831 - 2,165,974 2,165,974 McCreight Ave - Street Lights 5,000 - 5,000 Pumphouse Rd Bridge Repairs 50,000 - 50,000 Sidewalk, Curb & Gutter Program 100,000 - 100,000 Testing ODOT Projects 40,000 - 40,000 1/2 Ton Pickup Truck 35,000 - 35,000 Vehicle Transfers 20,000 - 20,000

3,582,082 4,910,974 8,493,056

Economic DevelopmentLand - 90,000 90,000 Parking Lot Paving - 40,000 40,000

- 130,000 130,000 Finance

Accounting - Miscellaneous Equipment 5,000 - 5,000 5,000 - 5,000

FireAssistant Chief Vehicle 40,000 - 40,000 Battalion Chief Vehicle 45,000 - 45,000 Clothing Extractor and Commercial Dryer 16,000 - 16,000 Personal Protective Equipment / Turnout Gear 96,000 - 96,000 Replace Engine 3 94,100 376,400 470,500 Sheds for Fire Stations (qty: 2) 14,000 - 14,000 Miscellaneous Equipment 43,000 - 43,000

348,100 376,400 724,500

PolicePolice Cruisers with Light Bars and Accessories (qty: 8) 360,150 - 360,150 Ballistic Vests (qty: 20) 20,715 - 20,715 Prisoner Transport Van 45,675 - 45,675

-25-

Page 27: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

PERMANENT OTHERIMPROVEMENT FUNDING

DESCRIPTION OF REQUEST FUND SOURCES TOTAL

PERMANENT IMPROVEMENT FUND - CAPITAL

Police (continued)Parking Control Vehicle $ 35,000 - 35,000 Mobile Laptops (qty: 10) 25,000 - 25,000 Tasers (qty: 30) 63,000 - 63,000 Undercover Vehicle - 15,000 15,000 Miscellaneous Equipment - 33,500 33,500

549,540 48,500 598,040

Information TechnologyCentral Square (HTE) Replacement - 800,000 800,000 Computer Equipment - Hardware / Software 50,000 68,000 118,000 Cyber Security Enhancements 40,000 40,000 80,000 Public Safety System Migration 75,000 - 75,000 Public Wireless - City Hall 25,000 - 25,000 Replace Channel 5 Broadcasting Equipment 25,000 - 25,000 Training Room Refurbish - City Hall 15,000 - 15,000 Virtual Server Infrastructure Refresh 62,500 62,500 125,000

292,500 970,500 1,263,000 Service - All Divisions

Service Administration - Computer and Media Upgrades 1,500 1,500 3,000 Service Administration - Furniture Replacements 5,000 5,000 10,000 Service Administration - Service Center Asphalt Repairs 12,500 12,500 25,000 Service Administration - Bird Netting 10,000 10,000 20,000 Street Maintenance - 1/2 Ton Pickup Truck 35,000 - 35,000 Street Maintenance - 6 yd Dump Truck w/Snow Package (qty: 2) 69,000 276,000 345,000 Street Maintenance - Air Compressor 20,000 - 20,000 Street Maintenance - Air Hammer Replacements 2,000 - 2,000 Street Maintenance - Case 590 Turbo SM #3367 43,900 175,600 219,500 Street Maintenance - Portable Signals 60,000 - 60,000 Street Maintenance - Vehicle Transfers from Utilities 5,000 - 5,000 Traffic Control - Battery Backup for Traffic Signals 30,000 - 30,000 Traffic Control - Battery Backup Unit Replacement Program 8,000 - 8,000 Traffic Control - Burnett and Sunset Signal Replacement 300,000 - 300,000 Traffic Control - LED Christmas Lights 8,000 - 8,000 Traffic Control - LED Street Light Conversion 15,000 - 15,000 Traffic Control - Mast Arm Pole Painting Program 20,000 - 20,000

-26-

Page 28: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

PERMANENT OTHERIMPROVEMENT FUNDING

DESCRIPTION OF REQUEST FUND SOURCES TOTAL

PERMANENT IMPROVEMENT FUND - CAPITAL

Service - All Divisions (continued)Traffic Control - Opticom Pre-emption System Replacements $ 15,000 - 15,000 Traffic Control - Traffic Signal Design 40,000 - 40,000 Traffic Control - Traffic Signal Equipment 60,000 - 60,000 Traffic Control - TS1 Control Upgrades 35,000 - 35,000 Traffic Control - 1/2 Ton Pickup Truck 35,000 - 35,000 Fleet - Air Conditioning Reclamation Unit 10,000 - 10,000 Fleet - Heavy Vehicle Scan Tool 10,000 - 10,000 Fleet - Light Vehicle Scan Tool 3,500 - 3,500 Fleet - Miscellaneous Equipment 3,000 3,000 6,000 Fleet - Vehicle Lift Lighting Upgrades 4,000 - 4,000 Facilities - Card Access Replacement / Upgrade 100,000 50,000 150,000 Facilities - City Hall Alarm Replacement 13,000 - 13,000 Facilities - City Hall Chiller #2 Replacement 100,000 - 100,000 Facilities - City Hall General Maintenance 25,000 - 25,000 Facilities - City Hall Restroom Upgrades 30,000 - 30,000 Facilities - City Service Center Alarm Replacement 4,750 4,750 9,500 Facilities - City Service Center Maintenance and Improvements 12,500 12,500 25,000 Facilities - City Service Center Salt Barn Roof 20,000 20,000 40,000 Facilities - Core Block Concrete Maintenance 5,000 - 5,000 Facilities - Fire Station 1 Hot Water Boiler 8,000 - 8,000 Facilities - Fire Station 1 Roof Upgrade - 94,000 94,000 Facilities - Fire Station Radio Speaker System Upgrade 80,000 - 80,000 Facilities - Fire Station Replace Asphalt and Concrete Apron 25,000 - 25,000 Facilities - Fire Station Window Replacement Program 15,000 - 15,000 Facilities - Fire Stations General Maintenance 25,000 - 25,000 Facilities - Public Safety Building General Maintenance 15,000 - 15,000 Facilities - Safety Services Center Alarm Replacement 6,000 - 6,000 Facilities - Safety Services Center Maintenance 10,000 - 10,000 Facilities - Plaza / Parking Garage Rehab - 600,000 600,000 Facilities - Floor Scrubbing / Stripping Machine 3,500 3,500 7,000 Facilities - Scissors Lift and Trailer 22,500 - 22,500 Facilities - 5/8" Drain Cleaning Machine 1,750 1,750 3,500 Facilities - Service Van #937 34,000 - 34,000 Facilities - Service Van #938 34,000 - 34,000

-27-

Page 29: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

PERMANENT OTHERIMPROVEMENT FUNDING

DESCRIPTION OF REQUEST FUND SOURCES TOTAL

PERMANENT IMPROVEMENT FUND - CAPITAL

Service - All Divisions (continued)Facilities - Vehicle Transfers $ 10,000 - 10,000

1,460,400 1,270,100 2,730,500

National Trail Parks and Recreation District 175,000 - 175,000 175,000 - 175,000

Contingency 100,000 - 100,000 100,000 - 100,000

Debt ServiceMisc.: Hospital ODOD Loan 293,870 - 293,870 Misc.: Parking Garage (2019) Interest Payment 40,000 - 40,000 Fire: Ambulances (3) Lease Payments (2018) 122,920 - 122,920 Fire: Rescue Engine Lease Payment (2018) 120,505 - 120,505 Fire: Ambulances (2) Lease Payments (2019) 76,165 - 76,165 Dispatch / Fire / Police / Service: Communications Pckg (2018) 284,685 - 284,685

938,145 - 938,145

GRAND TOTAL $ 7,946,378 9,501,113 17,447,491

PERCENTAGE OF TOTAL FUNDING 45.5% 54.5%

-28-

Page 30: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

The City of Springfield, Ohio

Special Revenue

Funds

-29-

Page 31: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesShared State Taxes $ 1,990,000 2,305,500 3,026,000 720,500 Interest Earnings 20,000 32,400 40,000 7,600 Transfer In (St. Hwy. Improvement Fund) 160,140 170,960 233,610 62,650 Transfer In (Mun. Rd. Improvement Fund) 595,000 615,980 841,740 225,760 Miscellaneous 223,500 224,500 206,000 (18,500) Refunds / Reimbursements 2,000 2,000 - (2,000)

Total Revenues $ 2,990,640 3,351,340 4,347,350 996,010

ExpendituresPersonal Services (excl. Med. Ins.) $ 1,146,720 1,167,620 1,290,520 122,900 Medical Insurance 347,530 347,530 340,000 (7,530) Education 1,300 1,300 1,000 (300) Utilities 4,300 4,200 4,200 - Street Lighting 74,000 73,000 74,460 1,460 Contractual Services 332,800 297,260 297,190 (70) Materials / Supplies 911,300 959,340 946,320 (13,020) Refunds / Reimbursements 478,550 478,550 780,950 302,400 Reimb. - Neighborhood Streets Paving 500,000 500,000 500,000 -

Total Expenditures $ 3,796,500 3,828,800 4,234,640 405,840

Excess Rev. Over (Under) Exp. $ (805,860) (477,460) 112,710 590,170

Fund Balance as of Jan. 1 1,941,249 1,947,034 1,469,574 (477,460)

Estimated Fund Balance as of Dec. 31 $ 1,135,389 1,469,574 1,582,284 112,710

COMBINED STREET FUNDS

Category

-30-

Page 32: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

Service Department

AdministrationPersonal Svcs. (excl. Med. Ins.) $ 4,950 5,776 - - - - Medical Insurance 597 1,199 - - - - Refunds / Reimbursements 466,000 471,756 478,550 478,550 780,950 302,400

Total Administration $ 471,547 478,731 478,550 478,550 780,950 302,400

Street MaintenancePersonal Svcs. (excl. Med. Ins.) $ 562,966 591,996 633,380 650,080 723,010 72,930 Medical Insurance 165,315 175,795 202,180 202,180 200,000 (2,180) Education 284 767 500 500 500 - Utilities 1,182 1,290 1,300 1,200 1,200 - Contractual Services 96,921 108,955 246,200 206,240 210,270 4,030 Materials / Supplies 530,701 571,699 769,000 823,065 807,320 (15,745)

Total Street Maintenance $ 1,357,369 1,450,502 1,852,560 1,883,265 1,942,300 59,035

Traffic ControlPersonal Svcs. (excl. Med. Ins.) $ 499,130 458,589 513,340 517,540 567,510 49,970 Medical Insurance 111,772 108,109 145,350 145,350 140,000 (5,350) Education 145 559 800 800 500 (300) Utilities 3,062 2,881 3,000 3,000 3,000 - Street Lighting 67,028 72,136 74,000 73,000 74,460 1,460 Contractual Services 28,266 20,438 46,600 51,020 46,920 (4,100) Materials / Supplies 107,472 150,621 142,300 136,275 139,000 2,725

Total Traffic Control $ 816,875 813,333 925,390 926,985 971,390 44,405

Total Service Department $ 2,645,791 2,742,566 3,256,500 3,288,800 3,694,640 405,840

COMBINED STREET FUNDS

Department / Division

-31-

Page 33: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

COMBINED STREET FUNDS

Department / Division

EngineeringContractual Services $ 40,000 40,000 40,000 40,000 40,000 - Reimb. - Neighborhood St. Paving - 500,000 500,000 500,000 500,000 -

Total Engineering $ 40,000 540,000 540,000 540,000 540,000 -

TOTAL COMBINEDSTREET FUNDS $ 2,685,791 3,282,566 3,796,500 3,828,800 4,234,640 405,840

-32-

Page 34: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesProperty Taxes $ 2,065,000 2,065,000 2,105,600 40,600 Intergovernmental 268,160 269,300 274,810 5,510 Interest Earnings 7,000 6,500 6,500 - Transfer In (General Fund) 900,000 900,000 1,150,000 250,000 Refunds / Reimbursements 40,000 30,000 30,000 -

Total Revenues $ 3,280,160 3,270,800 3,566,910 296,110

ExpendituresPersonal Services (excl. Med. Ins.) $ 2,558,810 2,622,590 2,971,170 348,580 Medical Insurance 576,110 536,110 585,000 48,890 Education 7,000 7,000 7,000 - Utilities 22,500 22,900 23,140 240 Contractual Services 112,870 112,130 98,560 (13,570) Materials / Supplies 37,150 31,150 33,130 1,980

Total Expenditures $ 3,314,440 3,331,880 3,718,000 386,120

Excess Rev. Over (Under) Exp. $ (34,280) (61,080) (151,090) (90,010)

Fund Balance as of Jan. 1 272,537 275,276 214,196 (61,080)

Estimated Fund Balance as of Dec. 31 $ 238,257 214,196 63,106 (151,090)

SPECIAL POLICE LEVY FUND

Category

-33-

Page 35: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

PolicePersonal Svcs. (excl. Med. Ins.) $ 2,069,963 2,322,075 2,290,600 2,374,200 2,679,630 305,430 Medical Insurance 405,640 448,876 524,860 484,860 525,000 40,140 Education 1,063 4,881 7,000 7,000 7,000 - Utilities 23,228 21,417 22,500 22,900 23,140 240 Contractual Services 67,858 72,038 112,870 112,130 98,560 (13,570) Materials / Supplies 28,659 30,842 37,150 31,150 33,130 1,980

Total Police $ 2,596,411 2,900,129 2,994,980 3,032,240 3,366,460 334,220

Consolidated DispatchPersonal Svcs. (excl. Med. Ins.) $ 274,607 274,663 268,210 248,390 291,540 43,150 Medical Insurance 47,336 31,054 51,250 51,250 60,000 8,750

Total Consolidated Dispatch $ 321,943 305,717 319,460 299,640 351,540 51,900

TOTAL SPECIAL POLICELEVY FUND $ 2,918,354 3,205,846 3,314,440 3,331,880 3,718,000 386,120

SPECIAL POLICE LEVY FUND

Department / Division

-34-

Page 36: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesCharges for Services $ 2,250,000 2,300,000 2,300,000 - Transfer In (General Fund) 600,000 300,000 200,000 (100,000) Intergovernmental Revenues - 3,790 - (3,790) Miscellaneous - 310 - (310)

Total Revenues $ 2,850,000 2,604,100 2,500,000 (104,100)

ExpendituresPersonal Services (excl. Med. Ins.) $ 2,088,590 1,994,550 2,051,890 57,340 Medical Insurance 422,750 382,750 420,000 37,250 Education 2,030 4,030 9,355 5,325 Utilities 14,500 14,800 14,996 196 Contractual Services 246,130 256,490 226,177 (30,313) Materials / Supplies 109,020 105,820 109,662 3,842 Transfers Out - - - - Refunds / Reimbursements 5,000 5,000 - (5,000)

Total Expenditures $ 2,888,020 2,763,440 2,832,080 68,640

Excess Rev. Over (Under) Exp. $ (38,020) (159,340) (332,080) (172,740)

Fund Balance as of Jan. 1 829,798 832,317 672,977 (159,340)

Estimated Fund Balance as of Dec. 31 $ 791,778 672,977 340,897 (332,080)

FIRE DIVISION SERVICE ENHANCEMENT FUND

Category

-35-

Page 37: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

FirePersonal Svcs. (excl. Med. Ins.) $ 2,100,312 1,903,732 2,088,590 1,994,550 2,051,890 57,340 Medical Insurance 374,260 357,406 422,750 382,750 420,000 37,250 Education 1,791 1,256 2,030 4,030 9,355 5,325 Utilities 13,697 14,352 14,500 14,800 14,996 196 Contractual Services 267,751 238,029 246,130 256,490 226,177 (30,313) Materials / Supplies 86,557 132,468 109,020 105,820 109,662 3,842 Transfers Out - 15,000 - - - - Refunds / Reimbursements 3,261 6,224 5,000 5,000 - (5,000)

Total Fire $ 2,847,629 2,668,467 2,888,020 2,763,440 2,832,080 68,640

TOTAL FIRE DIVISION SERVICEENHANCEMENT FUND $ 2,847,629 2,668,467 2,888,020 2,763,440 2,832,080 68,640

FIRE DIVISION SERVICE ENHANCEMENT FUND

Department / Division

-36-

Page 38: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

The City of Springfield, Ohio

Enterprise

Funds

-37-

Page 39: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesCharges for Services $ 188,000 185,000 203,000 18,000 Transfer In (General Fund) - - 120,000 120,000 Miscellaneous 129,700 117,200 117,000 (200) Refunds / Reimbursements 223,000 215,200 222,000 6,800

Total Revenues $ 540,700 517,400 662,000 144,600

ExpendituresPersonal Services (excl. Med. Ins.) $ 207,150 202,000 221,950 19,950 Medical Insurance 29,200 29,200 50,000 20,800 Education 2,200 2,450 3,120 670 Utilities 41,300 39,000 39,650 650 Street Lighting 3,200 3,050 3,110 60 Contractual Services 292,540 288,590 279,320 (9,270) Materials / Supplies 51,000 33,700 60,950 27,250 Transfers Out - 53,760 55,000 1,240 Refunds / Reimbursements - 220 - (220)

Total Expenditures $ 626,590 651,970 713,100 61,130

Excess Rev. Over (Under) Exp. $ (85,890) (134,570) (51,100) 83,470

Fund Balance as of Jan. 1 230,754 237,744 103,174 (134,570)

Estimated Fund Balance as of Dec. 31 $ 144,864 103,174 52,074 (51,100)

AIRPORT FUND

Category

-38-

Page 40: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

AirportPersonal Svcs. (excl. Med. Ins.) $ 151,093 152,412 165,460 161,100 176,870 15,770 Medical Insurance 19,785 21,032 23,360 23,360 40,000 16,640 Education 923 2,240 2,000 2,000 2,500 500 Utilities 32,148 30,495 33,500 31,600 32,110 510 Street Lighting 2,010 2,010 2,600 2,500 2,550 50 Contractual Services 137,065 175,987 165,140 165,460 178,230 12,770 Materials / Supplies 19,782 21,875 43,800 25,500 48,350 22,850 Transfers Out - 45,484 - 53,760 55,000 1,240 Refunds / Reimbursements 60 149 - 220 - (220)

Total Airport $ 362,866 451,684 435,860 465,500 535,610 70,110

Airpark OhioPersonal Svcs. (excl. Med. Ins.) $ 37,775 38,103 41,690 40,900 45,080 4,180 Medical Insurance 4,946 5,258 5,840 5,840 10,000 4,160 Education 231 560 200 450 620 170 Utilities 7,751 6,932 7,800 7,400 7,540 140 Street Lighting 503 503 600 550 560 10 Contractual Services 113,691 111,846 127,400 123,130 101,090 (22,040) Materials / Supplies 4,944 5,533 7,200 8,200 12,600 4,400

Total Airpark Ohio $ 169,841 168,735 190,730 186,470 177,490 (8,980)

TOTAL AIRPORT FUND $ 532,707 620,419 626,590 651,970 713,100 61,130

AIRPORT FUND

Department / Division

-39-

Page 41: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesCharges for Services $ 6,889,590 7,100,000 7,750,000 650,000 Interest Earnings 125,000 175,000 160,000 (15,000) Miscellaneous 328,000 343,350 343,000 (350) Refunds / Reimbursements 651,000 602,150 708,000 105,850

Total Revenues $ 7,993,590 8,220,500 8,961,000 740,500

Operating ExpendituresPersonal Services (excl. Med. Ins.) $ 2,976,235 2,848,910 3,222,900 373,990 Medical Insurance 771,300 629,150 785,000 155,850 Education 7,500 8,200 7,500 (700) Utilities 449,500 471,800 450,320 (21,480) Contractual Services 971,380 981,205 1,094,060 112,855 Materials / Supplies 1,319,110 1,306,730 1,470,430 163,700 Contingencies 20,000 20,000 20,000 - Capital 54,000 135,250 86,000 (49,250) Refunds / Reimbursements 744,520 744,520 813,270 68,750

Total Operating Expenditures $ 7,313,545 7,145,765 7,949,480 803,715

Operating Income (Loss) $ 680,045 1,074,735 1,011,520 (63,215)

Beginning Unencumbered Cash Balance 9,434,384 9,535,870 8,044,920 (1,490,950)

Ending Unencumbered Cash BalanceAvailable for Capital $ 10,114,429 10,610,605 9,056,440 (1,554,165)

Capital ExpendituresWater Capital Projects $ 1,373,750 1,588,750 1,188,500 (400,250) Capital Contingencies / Reimb. 100,000 100,000 105,000 5,000 Debt Service 876,930 876,935 1,093,750 216,815

Net Cash Used for Capital $ 2,350,680 2,565,685 2,387,250 (178,435)

Ending Unencumbered Cash Balance $ 7,763,749 8,044,920 6,669,190 (1,375,730)

WATER FUND

Category

-40-

Page 42: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

Water Administration

Water AdministrationPersonal Svcs. (excl. Med. Ins.) $ 181,801 205,816 131,470 132,525 130,790 (1,735) Medical Insurance 33,772 46,081 40,320 40,320 21,000 (19,320) Education 854 783 3,000 3,000 3,000 - Utilities 249 349 500 350 350 - Contractual Services 110,667 104,366 142,030 143,430 126,280 (17,150) Materials / Supplies 2,133 2,737 4,200 3,700 3,755 55 Contingencies - - 20,000 20,000 20,000 - Refunds / Reimbursements 535,559 567,109 594,520 594,520 663,270 68,750

Subtotal $ 865,035 927,241 936,040 937,845 968,445 30,600

Water Capital Projects $ 897,375 1,070,750 1,373,750 1,588,750 1,188,500 (400,250) Capital Contingencies / Reimb. 20,194 93,300 100,000 100,000 105,000 5,000 Debt Service 87,615 842,555 876,930 876,935 1,093,750 216,815 Subtotal $ 1,005,184 2,006,605 2,350,680 2,565,685 2,387,250 (178,435)

Total Water Administration $ 1,870,219 2,933,846 3,286,720 3,503,530 3,355,695 (147,835)

Water Treatment PlantPersonal Svcs. (excl. Med. Ins.) $ 996,848 894,770 1,099,695 1,000,210 1,156,200 155,990 Medical Insurance 207,017 162,225 251,900 185,000 232,000 47,000 Education 1,902 2,877 2,500 3,200 2,500 (700) Utilities 522,166 393,649 441,200 465,000 443,520 (21,480) Contractual Services 406,963 509,405 500,440 511,050 621,990 110,940 Materials / Supplies 565,351 671,510 691,300 678,000 763,480 85,480

Total Water Treatment Plant $ 2,700,247 2,634,436 2,987,035 2,842,460 3,219,690 377,230

WATER FUND

Department / Division

-41-

Page 43: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

WATER FUND

Department / Division

Water DistributionPersonal Svcs. (excl. Med. Ins.) $ 820,207 769,236 945,530 916,380 1,030,770 114,390 Medical Insurance 211,340 215,868 275,250 200,000 275,000 75,000 Education 60 514 1,500 1,500 1,500 - Utilities 2,337 3,007 5,200 4,000 4,000 - Contractual Services 127,465 172,025 166,600 165,705 186,120 20,415 Materials / Supplies 423,551 398,331 468,010 468,730 546,495 77,765

Total Water Distribution $ 1,584,960 1,558,981 1,862,090 1,756,315 2,043,885 287,570

City Mgr. / Econ. Dev.Personal Svcs. (excl. Med. Ins.) $ - 8,780 20,790 21,045 22,550 1,505 Medical Insurance - 650 1,810 1,810 2,000 190 Refunds / Reimbursements 150,000 150,000 150,000 150,000 150,000 -

Total City Mgr. / Econ. Dev. $ 150,000 159,430 172,600 172,855 174,550 1,695

Information TechnologyContractual Services $ 35,876 40,916 44,000 44,000 41,300 (2,700) Capital 72,188 26,285 54,000 135,250 86,000 (49,250)

Total Information Technology $ 108,064 67,201 98,000 179,250 127,300 (51,950)

-42-

Page 44: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

WATER FUND

Department / Division

Finance Department

Utility BillingPersonal Svcs. (excl. Med. Ins.) $ 570,396 575,605 604,260 604,260 691,670 87,410 Medical Insurance 111,398 102,622 153,680 153,680 200,000 46,320 Education 141 26 500 500 500 - Utilities 1,803 1,974 2,000 2,000 2,000 - Contractual Services 104,523 99,918 115,810 114,520 115,770 1,250 Materials / Supplies 143,566 141,248 153,600 154,300 154,700 400

Total Utility Billing $ 931,827 921,393 1,029,850 1,029,260 1,164,640 135,380

Revenue CollectionsPersonal Svcs. (excl. Med. Ins.) $ 189,413 181,644 174,490 174,490 190,920 16,430 Medical Insurance 32,523 27,509 48,340 48,340 55,000 6,660 Utilities 411 446 600 450 450 - Contractual Services 5,283 1,981 2,500 2,500 2,600 100 Materials / Supplies 1,012 1,142 2,000 2,000 2,000 -

Total Revenue Coll. $ 228,642 212,722 227,930 227,780 250,970 23,190

Total Finance Department $ 1,160,469 1,134,115 1,257,780 1,257,040 1,415,610 158,570

TOTAL WATER FUND $ 7,573,959 8,488,009 9,664,225 9,711,450 10,336,730 625,280

-43-

Page 45: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

WATER OTHERCAPITAL FUNDING

DESCRIPTION OF REQUEST PROJECTS SOURCES TOTAL

City Service Center Maintenance and Improvements $ 6,250 18,750 25,000 City Service Center Furniture Replacements 2,500 7,500 10,000 City Service Center Asphalt Repairs 6,250 18,750 25,000 City Service Center Alarm Replacement 2,375 7,125 9,500 City Service Center Salt Barn Roof 10,000 30,000 40,000 Bird Netting 5,000 15,000 20,000 Card Access Replacement / Upgrade 25,000 125,000 150,000 Floor Scrubbing / Stripping Machine 1,750 5,250 7,000 5/8" Drain Cleaning Machine 875 2,625 3,500 Water Service Separation Program 20,000 - 20,000 Fire Hydrant Replacement Program 125,000 - 125,000 Miscellaneous Water Improvements 250,000 - 250,000 Meter Radio MXUs 100,000 - 100,000 Street Reconstruction Mains and Services 100,000 - 100,000 Bill Edwards Dr - Water Service Replacements 45,000 - 45,000 Broadway Reconstruction - Water Service Replacements - 450,000 450,000 CLA - McCreight Ave Water Improvements - 625,000 625,000 Eastern Pressure District Water Upgrades Phase III - 9,000,000 9,000,000 Mound St. Waterline Replacement - 100,000 100,000 Mt Joy St Waterline Replacement 65,000 - 65,000 S Light St Waterline Replacement 10,000 - 10,000 W Liberty St Waterline Replacement 3,000 - 3,000 Warder St Waterline Replacement 20,000 - 20,000 Water Admin SUV #302 35,000 - 35,000 WD 36" Valve Replacement 100,000 - 100,000 WD Valve Repair Tool 12,000 - 12,000 WD Plate Compactor (qty: 2) 3,000 - 3,000 WD Tap Machine (qty: 2) 10,000 - 10,000 WTP 4X4 Pickup Truck #413 35,000 - 35,000 WTP 4X4 SUV #411 35,000 - 35,000 WTP Card Access 35,000 - 35,000 WTP Carryall Club Car 16,000 - 16,000 WTP Chemical Feed Building - 250,000 250,000 WTP Concrete Repair - 3,000,000 3,000,000 WTP Controls Master Plan - 150,000 150,000 WTP Elevator Upgrade - 300,000 300,000

WATER FUND - CAPITAL

-44-

Page 46: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

WATER OTHERCAPITAL FUNDING

DESCRIPTION OF REQUEST PROJECTS SOURCES TOTAL

WATER FUND - CAPITAL

(continued)WTP Filter Building Instrument Air Compressor $ 50,000 - 50,000 WTP Lab DI Water Filtration Unit 7,000 - 7,000 WTP Lab Desicator (qty: 2) 3,500 - 3,500 WTP Lab Stir Plate (qty: 2) 1,000 - 1,000 WTP V-Plow for 2 yd Dump Truck 8,000 - 8,000 WTP Portable Sludge/Dewatering Pump Replacement 40,000 - 40,000

TOTAL WATER CAPITAL $ 1,188,500 14,105,000 15,293,500

PERCENTAGE OF TOTAL FUNDING 7.8% 92.2%

-45-

Page 47: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesCharges for Services $ 14,588,270 15,500,000 17,980,000 2,480,000 Interest Earnings 50,000 60,000 60,000 - Miscellaneous 318,000 371,000 372,000 1,000 Refunds / Reimbursements 35,000 - - -

Total Revenues $ 14,991,270 15,931,000 18,412,000 2,481,000

Operating ExpendituresPersonal Services (excl. Med. Ins.) $ 3,446,100 3,463,010 3,728,160 265,150 Medical Insurance 925,650 920,330 941,350 21,020 Education 27,100 28,200 23,000 (5,200) Utilities 743,150 771,400 786,380 14,980 Contractual Services 1,332,010 1,333,550 1,207,430 (126,120) Materials / Supplies 1,159,650 1,108,470 1,197,540 89,070 Contingencies 20,000 20,000 20,000 - Capital 54,000 135,250 86,000 (49,250) Refunds / Reimbursements 1,438,410 1,438,410 1,611,180 172,770

Total Operating Expenditures $ 9,146,070 9,218,620 9,601,040 382,420

Operating Income (Loss) $ 5,845,200 6,712,380 8,810,960 2,098,580

Beginning Unencumbered Cash Balance 2,995,670 3,142,681 2,942,171 (200,510)

Ending Unencumbered Cash BalanceAvailable for Capital $ 8,840,870 9,855,061 11,753,131 1,898,070

Capital ExpendituresSewer Capital Projects $ 1,087,750 929,750 988,750 59,000 Capital Contingencies / Reimb. 175,000 175,000 175,000 - Debt Service 5,650,140 5,808,140 6,340,480 532,340

Net Cash Used for Capital $ 6,912,890 6,912,890 7,504,230 591,340

Ending Unencumbered Cash Balance $ 1,927,980 2,942,171 4,248,901 1,306,730

SEWER FUND

Category

-46-

Page 48: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

Sewer Administration

Sewer AdministrationPersonal Svcs. (excl. Med. Ins.) $ 182,331 205,743 166,080 166,390 130,790 (35,600) Medical Insurance 33,771 46,080 40,320 35,000 25,350 (9,650) Education 8,037 660 7,900 9,000 9,400 400 Utilities 2,638 2,694 2,650 2,400 2,420 20 Contractual Services 416,541 266,610 346,060 361,295 186,510 (174,785) Materials / Supplies 1,573 1,197 1,500 1,220 1,320 100 Contingencies - - 20,000 20,000 20,000 - Refunds / Reimbursements 1,171,780 1,203,285 1,288,410 1,288,410 1,461,180 172,770

Subtotal $ 1,816,671 1,726,269 1,872,920 1,883,715 1,836,970 (46,745)

Sewer Capital Projects $ 801,294 715,975 1,087,750 929,750 988,750 59,000 Capital Contingencies / Reimb. 194,321 149,638 175,000 175,000 175,000 - Debt Service 4,370,171 5,585,491 5,650,140 5,808,140 6,340,480 532,340 Subtotal $ 5,365,786 6,451,104 6,912,890 6,912,890 7,504,230 591,340

Total Sewer Administration $ 7,182,457 8,177,373 8,785,810 8,796,605 9,341,200 544,595

Sewer MaintenancePersonal Svcs. (excl. Med. Ins.) $ 1,128,676 1,099,457 1,280,840 1,282,940 1,456,010 173,070 Medical Insurance 346,218 343,143 412,750 412,750 420,000 7,250 Education 3,898 1,470 11,200 11,200 5,600 (5,600) Utilities 1,934 4,435 4,700 8,000 8,000 - Contractual Services 363,653 284,072 383,600 372,077 376,275 4,198 Materials / Supplies 525,879 518,559 657,450 584,250 642,420 58,170

Total Sewer Maintenance $ 2,370,258 2,251,136 2,750,540 2,671,217 2,908,305 237,088

SEWER FUND

Department / Division

-47-

Page 49: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

SEWER FUND

Department / Division

Wastewater Treatment PlantPersonal Svcs. (excl. Med. Ins.) $ 1,297,039 1,323,848 1,468,710 1,473,210 1,565,020 91,810 Medical Insurance 259,547 310,748 368,450 368,450 390,000 21,550 Education 2,217 4,653 5,000 5,000 5,000 - Utilities 718,530 652,397 734,500 759,600 774,560 14,960 Contractual Services 385,878 305,364 446,000 447,455 446,035 (1,420) Materials / Supplies 336,058 372,035 417,400 418,500 452,300 33,800

Total Wastewater Treatment Plant $ 2,999,269 2,969,045 3,440,060 3,472,215 3,632,915 160,700

City Mgr. / Econ. Dev.Personal Svcs. (excl. Med. Ins.) $ - 8,780 20,790 20,790 22,550 1,760 Medical Insurance - 650 1,810 1,810 2,000 190 Refunds / Reimbursements 150,000 150,000 150,000 150,000 150,000 -

Total City Mgr. / Econ. Dev. $ 150,000 159,430 172,600 172,600 174,550 1,950

Information TechnologyContractual Services $ 31,503 36,450 42,000 42,000 39,500 (2,500) Capital 72,601 16,645 54,000 135,250 86,000 (49,250)

Total Information Technology $ 104,104 53,095 96,000 177,250 125,500 (51,750)

-48-

Page 50: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

SEWER FUND

Department / Division

ForestryPersonal Svcs. (excl. Med. Ins.) $ 449,298 466,450 509,680 519,680 553,790 34,110 Medical Insurance 67,657 85,664 102,320 102,320 104,000 1,680 Education 9,238 2,676 3,000 3,000 3,000 - Utilities 1,226 1,342 1,300 1,400 1,400 - Contractual Services 98,336 101,363 114,350 110,723 159,110 48,387 Materials / Supplies 80,860 89,578 83,300 104,500 101,500 (3,000)

Total Forestry $ 706,615 747,073 813,950 841,623 922,800 81,177

TOTAL SEWER FUND $ 13,512,703 14,357,152 16,058,960 16,131,510 17,105,270 973,760

-49-

Page 51: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

SEWER OTHERCAPITAL FUNDING

DESCRIPTION OF REQUEST PROJECTS SOURCES TOTAL

City Service Center Maintenance and Improvements $ 6,250 18,750 25,000 City Service Center Furniture Replacements 2,500 7,500 10,000 City Service Center Asphalt Repairs 6,250 18,750 25,000 City Service Center Alarm Replacement 2,375 7,125 9,500 City Service Center Salt Barn Roof 10,000 30,000 40,000 Bird Netting 5,000 15,000 20,000 Card Access Replacement / Upgrade 25,000 125,000 150,000 Floor Scrubbing / Stripping Machine 1,750 5,250 7,000 5/8" Drain Cleaning Machine 875 2,625 3,500 Assistance Programs 30,000 - 30,000 I & I Elimination 2020 - 450,000 450,000 Miscellaneous Sewer Improvements 225,000 - 225,000 Bill Edwards Dr Storm Sewer - 175,000 175,000 Broadway Reconstruction - 675,000 675,000 Buck Creek Interceptor Improvements - 2,000,000 2,000,000 Catherine St Sewer Replacement 15,000 - 15,000 CLA - McCreight Ave - 225,000 225,000 CSO Compliance Program 2020 - 150,000 150,000 E Main St Sewer Replacement - 100,000 100,000 W Main St Sewer, CSO #3 - 250,000 250,000 North St Sewer Replacement - Construction - 1,500,000 1,500,000 Oakwood Pl Sewer Replacement 96,250 - 96,250 Forestry Chainsaws and Power Pruners 3,500 - 3,500 Forestry Skid Steer Attachments 20,000 - 20,000 Forestry Riding Mower 25,000 - 25,000 Forestry Tractor #3331 150,000 - 150,000 Rock Saw 3,500 - 3,500 4X4 Pickup Truck #531 35,000 - 35,000 4X4 Pickup Truck #532 35,000 - 35,000 Air Chipping Hammer & Bits 1,500 - 1,500 Brush Cutter 1,400 - 1,400 Confined Space Equipment 5,000 - 5,000 Inspection Truck #547 - 392,000 392,000 Lateral Tapping Drill & Bits 2,500 - 2,500 Lumberjack Cutter 20,000 - 20,000 String Trimmer 600 - 600

SEWER FUND - CAPITAL

-50-

Page 52: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

SEWER OTHERCAPITAL FUNDING

DESCRIPTION OF REQUEST PROJECTS SOURCES TOTAL

SEWER FUND - CAPITAL

(continued)Stake Bed Truck #544 $ - 126,500 126,500 WWTP 4X4 Pickup Truck #512 35,000 - 35,000 WWTP Chlorine Contact Basin Repairs 30,000 - 30,000 WWTP Deragger at Erie Express Lift Station 100,000 - 100,000 WWTP Lunchroom Kitchenette Upgrade 5,000 - 5,000 WWTP Bar Screen Wash Press Replacements 35,000 - 35,000 WWTP Toro Mower Replacement 24,500 - 24,500 WWTP Lab Equipment 15,000 - 15,000 WWTP Shop Drill Press 15,000 - 15,000

TOTAL SEWER CAPITAL $ 988,750 6,273,500 7,262,250

PERCENTAGE OF TOTAL FUNDING 13.6% 86.4%

-51-

Page 53: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesCharges for Services $ 1,915,000 1,915,000 1,915,000 - Interest Earnings 10,000 10,000 10,000 - Miscellaneous 39,000 27,600 27,600 -

Total Revenues $ 1,964,000 1,952,600 1,952,600 -

Operating ExpendituresPersonal Services (excl. Med. Ins.) $ 99,600 99,600 82,950 (16,650) Medical Insurance 13,810 13,810 14,000 190 Education 1,000 1,000 2,500 1,500 Utilities - - - - Contractual Services 475,850 497,790 541,050 43,260 Materials / Supplies 50 50 1,000 950 Capital 20,000 20,000 20,000 - Refunds / Reimbursements 146,000 146,000 151,090 5,090

Total Operating Expenditures $ 756,310 778,250 812,590 34,340

Operating Income (Loss) $ 1,207,690 1,174,350 1,140,010 (34,340)

Beginning Unencumbered Cash Balance 533,412 534,794 395,822 (138,972)

Ending Unencumbered Cash BalanceAvailable for Capital $ 1,741,102 1,709,144 1,535,832 (173,312)

Capital ExpendituresStormwater Capital Projects $ 10,000 120,000 - (120,000) Debt Service 1,193,322 1,193,322 1,193,330 8

Net Cash Used for Capital $ 1,203,322 1,313,322 1,193,330 (119,992)

Ending Unencumbered Cash Balance $ 537,780 395,822 342,502 (53,320)

STORMWATER FUND

Category

-52-

Page 54: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

Stormwater Administration

Stormwater AdministrationPersonal Svcs. (excl. Med. Ins.) $ 14,373 63,204 78,810 78,810 60,400 (18,410) Medical Insurance 2,305 12,909 12,000 12,000 12,000 - Education 470 - 1,000 1,000 2,500 1,500 Utilities 98 - - - - - Contractual Services 257,411 269,608 255,390 277,330 322,550 45,220 Materials / Supplies 440 200 50 50 1,000 950 Refunds / Reimbursements 148,963 126,009 146,000 146,000 151,090 5,090

Subtotal $ 424,060 471,930 493,250 515,190 549,540 34,350

Stormwater Capital Projects $ - 3,800 10,000 120,000 - (120,000) Debt Service 1,162,694 1,193,321 1,193,322 1,193,322 1,193,330 8 Subtotal $ 1,162,694 1,197,121 1,203,322 1,313,322 1,193,330 (119,992)

Total Stormwater Administration $ 1,586,754 1,669,051 1,696,572 1,828,512 1,742,870 (85,642)

City Mgr. / Econ. Dev.Personal Svcs. (excl. Med. Ins.) $ - 8,780 20,790 20,790 22,550 1,760 Medical Insurance - 650 1,810 1,810 2,000 190

Total City Mgr. / Econ. Dev. $ - 9,430 22,600 22,600 24,550 1,950

Finance / PurchasingPersonal Svcs. (excl. Med. Ins.) $ 308 - - - - - Medical Insurance - - - - - -

Total Finance / Purchasing $ 308 - - - - -

STORMWATER FUND

Department / Division

-53-

Page 55: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

STORMWATER FUND

Department / Division

Service AdministrationContractual Services $ 209,950 211,086 220,460 220,460 218,500 (1,960) Capital 19,872 19,944 20,000 20,000 20,000 -

Total Service Administration $ 229,822 231,030 240,460 240,460 238,500 (1,960)

TOTAL STORMWATER FUND $ 1,816,884 1,909,511 1,959,632 2,091,572 2,005,920 (85,652)

-54-

Page 56: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

The City of Springfield, Ohio

Internal Service

Funds

-55-

Page 57: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesCharges for Services $ 1,718,850 1,550,000 1,700,000 150,000 Miscellaneous 500 5,401 500 (4,901)

Total Revenues $ 1,719,350 1,555,401 1,700,500 145,099

ExpendituresPersonal Services (excl. Med. Ins.) $ 27,530 28,150 29,910 1,760 Medical Insurance - - - - Education 1,700 1,700 2,000 300 Utilities 4,300 4,400 4,400 - Contractual Services 127,700 133,890 139,570 5,680 Materials / Supplies 1,556,700 1,434,694 1,511,200 76,506 Refunds / Reimbursements 64,400 64,400 89,920 25,520

Total Expenditures $ 1,782,330 1,667,234 1,777,000 109,766

Excess Rev. Over (Under) Exp. $ (62,980) (111,833) (76,500) 35,333

Fund Balance as of Jan. 1 151,984 193,103 81,270 (111,833)

Estimated Fund Balance as of Dec. 31 $ 89,004 81,270 4,770 (76,500)

CENTRAL STORES FUND

Category

-56-

Page 58: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

Finance - Purchasing CardMaterials / Supplies $ 700,000 640,000 700,000 640,000 680,000 40,000

Total Finance - Purchasing Card $ 700,000 640,000 700,000 640,000 680,000 40,000

Central ServicesPersonal Svcs. (excl. Med. Ins.) $ 24,743 26,658 27,530 28,150 29,910 1,760 Medical Insurance - - - - - - Utilities 632 759 800 800 800 - Contractual Services 50,966 44,683 50,900 50,880 51,680 800 Materials / Supplies 13,240 14,869 18,200 18,200 18,200 -

Total Central Services $ 89,581 86,969 97,430 98,030 100,590 2,560

CENTRAL STORES FUND

Department / Division

-57-

Page 59: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

CENTRAL STORES FUND

Department / Division

Service Department

Fleet MaintenancePersonal Svcs. (excl. Med. Ins.) $ 4,957 5,774 - - - - Medical Insurance 598 1,198 - - - - Education 16 964 1,700 1,700 2,000 300 Utilities 3,080 3,515 3,500 3,600 3,600 - Contractual Services 61,251 89,664 76,800 83,010 87,890 4,880 Materials / Supplies 624,267 731,430 801,500 739,494 776,000 36,506 Refunds / Reimbursements 60,100 63,180 64,400 64,400 89,920 25,520

Total Fleet Maintenance $ 754,269 895,725 947,900 892,204 959,410 67,206

FacilitiesMaterials / Supplies 33,000 28,500 37,000 37,000 37,000 -

Total Facilities $ 33,000 28,500 37,000 37,000 37,000 -

Total Service Department $ 787,269 924,225 984,900 929,204 996,410 67,206

TOTAL CENTRALSTORES FUND $ 1,576,850 1,651,194 1,782,330 1,667,234 1,777,000 109,766

-58-

Page 60: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 2019 2020 2019 Rev. Budget

Original Revised Preliminary vs.

Budget Budget Budget 2020 Prelim. Budget

RevenuesMiscellaneous $ 2,000 2,000 2,000 - Refunds / Reimbursements 700,000 600,000 998,000 398,000

Total Revenues $ 702,000 602,000 1,000,000 398,000

ExpendituresPersonal Services (excl. Med. Ins.) $ 454,750 404,750 700,730 295,980 Medical Insurance 116,720 166,720 166,470 (250) Education 2,000 2,000 2,700 700 Utilities 96,800 97,000 98,520 1,520 Contractual Services 64,430 64,278 70,368 6,090 Materials / Supplies 15,120 15,008 19,485 4,477

Total Expenditures $ 749,820 749,756 1,058,273 308,517

Excess Rev. Over (Under) Exp. $ (47,820) (147,756) (58,273) 89,483

Fund Balance as of Jan. 1 213,101 219,082 71,326 (147,756)

Estimated Fund Balance as of Dec. 31 $ 165,281 71,326 13,053 (58,273)

SERVICE FACILITY FUND

Category

-59-

Page 61: City Manager’s 2020 Preliminary Budget - Springfield, Ohio · Table of Contents (continued)-2-The City of Springfield, Ohio Budget Message City Manager's-3-76 East High Street •

2019 Rev.

2019 2019 2020 Budget vs.

2017 2018 Original Revised Preliminary 2020 Prelim.

Actual Actual Budget Budget Budget Budget

Service AdministrationPersonal Svcs. (excl. Med. Ins.) $ 308,618 329,341 454,750 404,750 700,730 295,980 Medical Insurance 67,519 76,735 116,720 166,720 166,470 (250) Education 201 755 2,000 2,000 2,700 700 Utilities 101,494 91,928 96,800 97,000 98,520 1,520 Contractual Services 47,350 47,731 64,430 64,278 70,368 6,090 Materials / Supplies 15,557 14,190 15,120 15,008 19,485 4,477

Total Service Administration $ 540,739 560,680 749,820 749,756 1,058,273 308,517

TOTAL SERVICEFACILITY FUND $ 540,739 560,680 749,820 749,756 1,058,273 308,517

SERVICE FACILITY FUND

Department / Division

-60-