finance committee briefing 2016 year-end results general

Finance Committee Briefing 2016 Year-End Results

General, Water/Sewer, Aviation Funds February, 2017 YTD General Fund Results

March 29, 2017

2016 Year End Results Summary 1. In 2016, total General Fund sources fell 0.2% compared

to 2015 (excluding the 27th Pay Fund).

2. Total General Fund uses declined 1.7% ($2.8 million)

when compared to the previous year and were 5% under

the final budget due to savings in the transfer category.

3. Note: The final revised budget included additional

budget margin to ensure that no department would

exceed its final budget. Moreover, the appropriation

included the ability to do additional transfers to capital in

the event of unplanned revenues.

4. While we ended the year with a positive balance, we

saw a decline in our overall revenues.

2

3

Finance Committee Briefing 2016 General Fund Year End Results

2016 Year End Statement Notes 1. Amounts may not sum due to rounding.

2. Does not include special projects, which are reported separately.

3. 2016 Budget includes adopted budget only and does not include prior year's encumbrances.

4. Actual amounts include expenditures against current year appropriation and against prior year's appropriation that carried forward.

5. Other Sources includes interest earnings, special assessments and operating transfers in.

6. Other Uses include debt service and miscellaneous operating transfers out.

7. 2015 Income Tax collections include $312,700 in JEDD distributions that spanned multiple years.

4

2016 Income Tax Revenues 1. Income tax grew 1.2% or $1.3 million in 2016, which was

on target for the revised forecast.

a) Withholding collections were up a significant $2.8M or 3.0%.

b) Taxes on business profits were down for the second year, falling

$1.1M or 9.3%. The tax on corporate profits dropped $1.2M while

partnerships gained $136,000—a reversal from 2015 when the

corporate profits tax realized sizable gains and partnerships

profits sank.

c) The tax paid by individuals climbed $254,400 or 6%.

d) Refunds were up $337,100 or 14% after falling $853,600 or 27%

in 2015. Refunds in 2015 were historically low.

In 2016, Income Tax collections registered their highest

level since 2008.

8

9

2016 Income Tax collections were at their highest level

since 2008

2016 General Fund Revenues 2. Property Tax and Other Tax revenues came in at the

estimate, reflecting a slight increase of 0.5% (or

$28,000)

a) Property values were flat in 2016, growing 0.4% when

compared to the previous year. Total property tax revenue

increased 0.3% in the General Fund due to a higher

collection rate (the highest since 2008).

b) Total property taxes collected in the General Fund were $5.4

million in 2016. (Property tax revenues of $6.8 million went to

the Debt Retirement Fund.)

c) The 2016 millage distribution was maintained at the 2015

levels.

d) Hotel lodging tax receipts totaled $620,000 in 2016, an

increase of 2% over 2015.

10

2016 General Fund Revenues Property Tax Collections – General and Bond Retirement Funds

11

• Values declined 8.1% in 2015 and were flat in 2016

• 2016 realized the highest collection rate since 2008

2016 General Fund Revenues

3. Waste Collection fees for 2016 totaled $8.8 million

and declined 4% or $361,000, just slightly under the

estimate. This reflects the loss of the Riverside

contract ($1.0 million), offset by the $10 fee increase

implemented in 2016.

4. EMS Fees in 2016 are essentially even with 2015

(up 0.2% or $123,000), exceeding the estimate by

$600,000 or 14%. The timing issue we had been

experiencing all year was offset by an accrual entry.

Data from the Fire Department indicates that 2016

transports are up 2.5% compared to 2105.

12


5. Other Charges for Services came in 3%

($400,000) under budget and has declined 4% or

$500,000 in 2016.

6. Local Government Fund revenues also came in at

the revised estimate and declined 8% or $600,000

from 2015. Unfortunately, local cities were hit with

another unanticipated LGF reduction with a two-

thirds cut to the municipal direct allocation.

7. Other Intergovernmental revenues grew 7%,

reflecting $300,000 more revenues largely due to

the Racino payment timing ($250,000 in 2015 to

$500,000 in 2016).

13


8. Fines and Forfeits decreased 73% ($1.8 million)

mostly due to the elimination of public safety photo

enforcement.

9. Revenues from licenses and permits grew 3%

reflecting increased construction activity.

10. Other revenue increased 35% (or $1.2 million)

when compared to 2015. Interest earnings grew

$511,000 (67%) to due higher interest rates.

Miscellaneous transfers in added to this increase

($530,000 retro Fire retro pay set-aside).

14

2016 General Fund Expenditures 1. Personnel costs for 2016 were under budget by 1.7%

or $2.0 million. Personnel costs grew 1% in 2016

compared to 2015. Various factors were at work:

a) Adjusting for the 27th payroll ($2.7 million) in 2015 and the

Fire retro pay ($530,000) expended in 2016, total growth in

personnel costs was 3.0%.

b) A 2% wage increase was given to all employee groups.

Health insurance rates were increased 12% in September to

ensure adequate funding for the self-insurance fund.

c) The average number of employees in the General and Street

Maintenance Funds stayed relatively the same with the

average monthly number of full-time positions totaling 1,199

in 2015 to 1,198 in 2016.

d) Some departments experienced higher than planned vacancy

savings in the budget.

15

2016 General Fund Expenditures

2. Contracts and materials costs declined 11% (or

$4.1 million) from 2015.

Management contract costs declined 19% or

$812,000 due the final phase out of Redflex contract

expenditures

Fuel costs declined 18% ($360,000)

Other transfers declined significantly

3. Capital equipment expenditures incurred in 2016

were $1.2 million higher than the previous year

and reflected planned purchases.

16

2016 General Fund Expenditures

4. The capital improvements transfer totaled $4.7 million

in 2016 well above the planned $1.5 million. Due to

lower than planned spending in other areas of the

budget, additional transfers for various deferred

projects were possible:

Note: Technology funding includes unspent capital equipment

dollars set-aside for IT as well as funding for data

warehousing/dashboard initiatives.

5. The Development Fund transfer totaled $2.8 million,

reflecting the current funding level.

17

2017 Cash Reserve: $23.8 million

18

Note: The 2016 Cash Reserve before Use of Fund Balance was $24.7M. The $1.5M planned Use of the Reserve in 2016 was not used due to favorable budget performance.

General Fund Budget Metric

One of our financial goals is to ensure major tax sources

meet or exceed personnel costs, the major cost center of

the General Fund budget. We have met the goal for five

of the last seven years.

Note: Personnel costs in 2015 exclude the 27th pay costing $2.7 million.

19

Summary of 2016 General Fund Transfers

20

Due to lower than planned costs in other areas of the budget, we were able to set aside $3.1 million for deferred capital project expenditures (including technology) beyond the original budget.

February 2017 General Fund Results

21

Issue 9 Income Tax: • Separately reported for

trend/comparison analysis • Full-year estimate is $11M • First full month for

collections was February • Met February revenue

target

Issue 9 Expenditures: • $2.5 million of proceeds

were used to balance 2017 budget

• The remaining $8.5M for services/investments is reported separately for ease in tracking

February 2017 General Fund Results Summary 1. Revenues increased 2.6% or $700,000 over 2016 due

to Issue 9 and are slightly under budget. 2. Without the inclusion of Issue 9 proceeds, remaining

revenues are flat. 3. Expenditures have increased 6.4% or $1.5M as a

result of the timing of property tax payments. In 2016, payments were made in March rather than February.

4. At the end of February, revenues exceeded expenditures by $2.6 million.

5. The City has been notified of a pending Workers Compensation rebate. Consistent with our budget policy, the one-time funds will be used on non-operating expenditures. 22

Various Updates

1. Health Insurance Fund ended the year

meeting the actuarial target. An increase in

the employer transfer rate of 12% was

implemented in September to ensure

adequate funding levels.

2. Union negotiations will take place later in

the year and will be key in maintaining our

financial stability as we look toward 2018.

3. Federal and State budget proposals

present significant threats to the City’s

budget.

23

Today’s Key Takeaways

24

1. We balanced the budget in 2016 without using the cash reserve.

2. We took advantage of our positive budget variances and allocated dollars toward some critical needs in deferred capital and technology.

3. We still have a long-term budget challenge, particularly in the area of infrastructure maintenance and replacement.

4. Budget actions at the State and Federal level will continue to be significant challenges in managing our resources.

2016 Department Budget Compliance

25


Aviation Operating Fund

March 29, 2017

Aviation Fund Revenue, Expenditures and Other Sources/Uses Statement December 31, 2016

2

Revenues & Other Sources2016 Original

Budget

2016 YTD Original

Budget2016

Actuals

Budget Variance Fav/(Unfav)

Budget Variance Fav/(Unfav)

2015 YTD

Actuals2016

Actuals'15-'16 $ Chg.

'15-'16 % Chg.

Airline Revenue 8.7 8.7 8.5 (0.2) -2.6% 7.3 8.5 1.2 16.0%

Parking 12.3 12.3 11.2 (1.1) -9.0% 11.6 11.2 (0.4) -3.3%

Rental Car Concession 3.3 3.3 3.3 0.0 0.5% 3.7 3.3 (0.4) -10.2%

Concessions 1.6 1.6 1.5 (0.1) -4.8% 1.5 1.5 0.0 0.6%

Other Non-Airline Revenue 5.1 5.1 4.5 (0.6) -11.7% 4.6 4.5 (0.1) -2.2%

Interest and Other Revenue 0.3 0.3 0.3 0.1 25.5% 0.5 0.3 (0.2) -34.5%

Non-Airline Revenue 22.6 22.6 20.9 (1.7) -7.5% 21.9 20.9 (1.0) -4.6%

PFC and CFC Transfer 2.9 2.9 3.2 0.3 9.3% 5.2 3.2 (2.0) -38.5%

Total Revenue 34.2 34.2 32.6 (1.7) -4.9% 34.4 32.6 (1.8) -5.3%

Use of Fund Balance 2.3 2.3 1.8 (0.5) -22.8% 3.5 1.8 (1.7) -48.4%

Total Sources 36.5 36.5 34.3 (2.5) -6.7% 37.9 34.3 (3.5) -9.3%

Expenditures & Other Uses

Personnel 13.8 13.8 13.2 0.6 4.3% 13.4 13.2 (0.1) -1.0%

Contracts, Materials & Other Uses 14.5 14.5 12.9 1.6 10.9% 12.5 12.9 0.5 3.8%

Capital Equipment 0.5 0.5 0.2 0.3 55.4% 1.1 0.2 (0.9) -80.0%

Capital Projects 3.1 3.1 3.1 - 0.0% 4.7 3.1 (1.5) 0.0%

Debt Service - Interest 2.8 2.8 3.0 (0.2) -6.7% 1.9 3.0 1.1 58.4%

Total Uses 34.8 34.8 32.5 2.3 6.5% 33.4 32.5 (0.9) -2.8%

Debt Service - Principal 1.8 1.8 1.8 (0.0) 4.0 1.8 (2.2) -54.6%

Excess/(Shortfall) of Sources over Uses 0.0 0.0 0.0 0.4 0.0

Notes:

1. Amounts may not sum due to rounding.

2. 2016 Budget includes adopted budget only and does not include prior year's encumbrances.

3. Actuals include exp. against current year appropriation and against prior year's appropriation that carried forward.

Aviation Fund Multi-Year Review

3

Revenues & Other Sources

2014

Actuals

2015

Actuals

2016

Actuals

2017

Original

Budget

'16-'17

Budget

$ Chg.

'16-'17

Budget

% Chg.

Airline Revenue 7.6 7.3 8.5 8.9 0.4 4.9%

Parking 12.1 11.6 11.2 10.8 (0.4) -3.4%

Rental Car Concession 3.6 3.7 3.3 3.1 (0.2) -5.7%

Concessions 1.6 1.5 1.5 1.4 (0.1) -8.1%

Other Non-Airline Revenue 3.9 4.6 4.5 6.9 2.3 50.9%

Interest and Other Revenue 0.4 0.5 0.3 0.3 (0.0) -13.7%

Non-Airline Revenue 21.7 21.9 20.9 22.5 1.6 7.5%

PFC and CFC Transfer 2.9 5.2 3.2 4.5 1.4 43.2%

Total Sources 32.2 34.4 32.6 35.9 4.9 10.3%

Use of Cash Reserve 1.3 3.5 1.8 - (1.8) -100.0%

Total Sources & App. Fund Balance 33.4 37.9 34.3 35.9 1.6 4.6%

Expenditures & Other Uses

Personnel 12.6 13.4 13.2 13.7 0.5 3.6%

Contracts, Materials & Other Uses 12.5 12.5 12.9 13.5 0.6 4.5%

Capital Equipment 0.6 1.1 0.2 0.2 0.0 1.6%

Capital Projects 3.5 4.7 3.1 1.7 (1.5) -47.5%

Debt Service - Interest 2.5 1.9 3.0 3.4 0.4 13.7%

Debt Service - Principal 1.5 4.0 1.8 3.4 1.6 88.7%

Total Uses 33.2 37.4 34.3 35.9 1.6 4.6%

Excess/(Shortfall) of SourcesOver Uses 0.3 0.4 0.0 (0.0)

Notes:1. Amounts may not sum due to rounding.2. 2017 Budget includes adopted budget only and does not include prior year's encumbrances.

3. Actuals include exp. against current year appropriation and against prior year's appropriation that carried forward.

Aviation Fund Highlights 1. Total revenue was down $1.8 million or 5.3% lower than last year.

This was a result of a one time transfer in PFC’s (Passenger Facility

Charges) in 2015 of $2.4 million to defease the Series 2005A

Bonds. Revenue is $1.7 million or 4.9% below the 2016 projected

revenue.

2. Airline revenue was 2.6% below projection. Landing fees were

$118,100 below projection. Airline revenue is $1.2 million higher

than in 2015 due to no Airline settlement being recorded in the first

quarter of 2016 and a rate increase in the landing fee from

$1.71/1,000 lbs. gross landed weight to $2.53/1,000 lbs. This has

resulted in a increase of $875,600 compared to 2015.

3. Enplanements were down 3.5% in 2016 compared to 2015.

4. Concession revenue was $78,600, or 4.8%, below projection.

Concession revenue was 0.6% higher than 2015 revenue.

5. Total non-airline revenue was $1.7 million, or 7.5% below projection. Parking is $1.1 million and Ground Lease Revenue $417,500 below

projection. 4

Aviation Fund Highlights 6. Personnel costs were $601,200, or 4.3% under budget for

the period. The favorable variances were in overtime in the amount of $198,300, wages in the amount of $189,400 (including fringe benefits) and in health insurance of $121,500. Personnel cost are $129,500 lower than 2015.

7. Contracts, Materials and Other Uses were $1,574,700, or 10.9% below budget for the period. These favorable variances were mainly in supplies and materials of $539,900, utilities (electric and gas) of $575,900, and fuel of $203,300. These costs are $468,100, or 3.8% higher than 2015.

8. Only $213,000 in capital equipment purchases have been made as of the end of the year. This is a result of deferring purchases due to the decreased revenue collections.

9. Expenditures equal Revenue and Other Sources at the end of the year.

5

Spectrum Brand Facility Complete

6

Air Service

1. United and PSA have added larger Aircraft.

2. Allegiant will add Myrtle Beach on May 24, 2017.

7

Dayton Seats per Day Each Way by Carrier and Month January 2017 through June 2017

American Operates Approximately 40% of Dayton’s Capacity;

Delta Operates Approximately 27% of the Capacity

8

Dayton Total Seats per Day Each Way by Month January 2016 – June 2016 and January 2017 – June 2017

Total Capacity Will Be Virtually Unchanged from January through June 2017

Versus January through June 2016

9

Aviation Fund Take Aways

1. The Department had a balanced budget at year end with the use of fund balance of $1.8 million.

2. The average Daily Seat Capacity is expected to remain flat for 2017.

3. The Department met with all of its carriers. Delta, American and United are projecting 1% growth in 2017.

10

Thank You

11


Water and Sanitary Sewer Operating Funds

March 29, 2017

Water Fund Revenue & Expenditures Review 1. Water Fund Revenues (Sources) up, 3.1% or $1.5 million compared to the

twelve months of 2015. a) Revenue from City customers relatively unchanged compared to the forecast , up

$300,000 compared to 2015.

b) Revenue from Other Jurisdictions above forecast by 3.1% and up $700,000 compared to 2015.

c) Other Charges for Services included $239,800 more Lime sales to outside customers in 2016 compared to 2015.

2. Expenditures (Uses) down 5.6% or $2.7 million compared to 2015 due to lower Construction Capital Transfers, Contracts and Materials, and purchases of Capital Equipment. a) Additional Construction Capital Transfer of $2.3 million for Lime Kiln project in 2015.

b) Water Fund payroll for 2016 higher 0.4% compared to the full year 2015 due to increased Wages offset by lower Leave cost.

c) Contracts and Materials down 1.3% or $200,000 compared to 2015 due to decreased Electric and Water Utility and Other Professional Services, offset by higher Supplies and Materials, and Indirect Cost.

3. The Water Fund ended the year with a positive balance which will be used toward various deferred capital projects.

2

Water Fund Revenue, Expenditures and Other Sources/Uses Statement 2016

3

(Amounts shown in $000,000's)

Revenue and Other Sources

2016

Original

Budget

2016

YTD

Budget

2016

YTD

Actuals

Budget

Variance Fav/(Unfav)

Budget


2015

YTD

Actuals

2016

YTD

Actuals

'15-'16 $

Chg.

'15-'16 %

Chg.

City of Dayton Water Fees(Metered Water) 25.1 25.1 25.0 (0.2) (0.6%) 24.7 25.0 0.3 1.1%

Other Jurisdictions Water Fees (Metered Water) 19.7 19.7 20.3 0.6 3.1% 19.5 20.3 0.7 3.8%

Subtotal Metered Water 44.8 44.8 45.2 0.5 1.0% 44.2 45.2 1.0 2.3%

Other Charges for Services 2.2 2.2 2.5 0.3 13.8% 2.3 2.5 0.2 9.2%

Subtotal Customer Revenue 47.0 47.0 47.7 0.8 1.6% 46.5 47.7 1.2 2.6%

Other Revenue 5.2 5.2 5.0 (0.2) (3.6%) 4.9 5.0 0.1 2.2%

Interest Revenue 0.1 0.1 0.3 0.2 316.4% 0.2 0.3 0.1 53.0%

Operating Transfers In 0.0 0.0 0.0 0.0 N/A 0.0 0.0 0.0 N/A

Other Non-Operating Revenue(Expense) (0.0) (0.0) (0.0) 0.0 (77.0%) (0.0) (0.0) 0.0 (39.3%)

Bad Debt Expense (1.3) (1.3) (0.7) 0.6 49.7% (0.9) (0.7) 0.2 23.6%

Payment Discounts (0.9) (0.9) (0.9) 0.1 6.8% (0.8) (0.9) (0.1) (14.5%)

Discounts/Bad Debt/Adjustments (2.2) (2.2) (1.5) 0.7 32.0% (1.6) (1.5) 0.1 5.8%

Total Sources 50.0 50.0 51.5 1.5 3.0% 50.0 51.5 1.5 3.1%

Expenditures and Other Uses

Personnel 22.3 22.3 21.1 1.1 5.1% 21.0 21.1 0.1 0.4%

Contracts and Materials 19.1 19.1 16.1 3.0 15.5% 16.4 16.1 (0.2) (1.3%)

Capital Equipment 1.0 1.0 1.2 (0.2) (24.1%) 1.5 1.2 (0.3) (18.7%)

Capital Improvements 5.1 5.1 5.7 (0.6) (12.2%) 8.4 5.7 (2.8) (32.7%)

Debt Service - Interest 1.1 1.1 1.0 0.1 8.9% 0.5 1.0 0.5 92.2%

Total Uses 48.5 48.5 45.2 3.3 6.9% 47.8 45.2 (2.7) (5.6%)

Debt Payment - Principal Radios 0.1 0.1 0.1 0.0 0.0% 0.1 0.1 0.1 174.2%

Debt Payment - Principal Bonds 1.3 1.3 1.5 (0.2) (13.7%) 0.9 1.5 0.6 64.3%

Excess/(Shortfall) of Sources over Uses 0.0 0.0 4.7 1.2 4.7 3.5

Notes:


2. 2016 Budgets include adopted budget only and does not include prior year's encumbrances.

3. Actuals include expense against current year appropriation and prior year's appropriation that carried forward.

4. Other Charges for Services (non-metered charges) includes Lime Sales, Shut Off Charges, Misc. Revenue .

5. Discounts/Bad Debt/ Adjustments includes misc. refunds.

6. Payment of lease debt principal is $148,692.63.

7. Figures do not include Well Filed Fund (53997), Water Stores Inventory (53998).

2014-2016 Actual to 2017 Budget Comparison Water Fund

4



2014

Actuals

2015

Actuals

2016

Actuals

2017

Original

Budget

'16-'17

Budget

$ Chg.

'16-'17

Budget

% Chg.

City of Dayton Water Fees(Metered Water) 24.8 24.7 25.0 25.1 0.2 0.6%

Other Jurisdictions Water Fees (Metered Water) 20.3 19.5 20.3 20.7 0.4 2.1%

Subtotal Metered Water 45.1 44.2 45.2 45.8 0.6 1.3%

Other Charges for Services 1.8 2.3 2.5 2.5 (0.0) (1.0%)

Subtotal Customer Revenue 46.9 46.5 47.7 48.3 0.6 1.2%

Other Revenue 4.5 4.9 5.0 5.2 0.2 3.7%

Interest Revenue 0.1 0.2 0.3 0.1 (0.2) (76.0%)

Operating Transfers In 0.0 0.0 0.0 0.0 0.0 N/A

Discounts/Bad Debt/Adjustments (1.5) (1.6) (1.5) (1.7) (0.2) 13.3%

Total Sources 50.0 50.0 51.5 51.8 0.3 0.6%


Personnel 20.1 21.0 21.1 22.9 1.8 8.5%

Contracts and Materials 15.7 16.4 16.1 19.8 3.6 22.4%

Capital Equipment 1.7 1.5 1.2 1.3 0.0 2.5%

Capital Improvements 6.5 8.4 5.7 5.2 (0.5) (8.2%)

Debt Service - Interest 0.6 0.5 1.0 1.1 0.1 13.8%

Total Uses 44.6 47.8 45.2 50.3 5.1 11.3%

Debt Payment - Principal Radios 0.0 0.1 0.1 0.0 (0.1) N/A

Debt Payment - Principal Bonds 0.9 0.9 1.5 1.5 (0.0) (1.8%)

Excess/(Shortfall) of Sources over Uses 4.5 1.2 4.7 0.1 (4.6)

Sanitary Sewer Fund Revenue & Expenditures Review

1. Sanitary Sewer Fund Revenues (Sources) up 3.1% or $1 million compared to 2015 due to higher volumes in the City and Other Jurisdictions. a) Revenue from City Customers up $600,000 or 4.1% and Other Jurisdictions up

$500,000 or 4.4% in 2016.

b) Other Charges for Services above forecast by $500,000 due to higher surcharges for industrial waste and special monitoring fees.

2. Expenditures (Uses) down 2.6% or $800,000 compared to 2015 due to lower Construction Capital Transfers and Contracts and Materials, offset by higher Debt Interest cost. a) Sanitary Sewer Fund payroll for 2016 higher 2.8% compared to the same period in

2015 due higher Wages and Overtime cost.

b) Capital Improvement cash transfers $5.1 million in 2016 compared to $6.1 million at the end of the fourth quarter in 2015.

3. The Sewer Fund ended the year with a positive balance.

5

Sanitary Sewer Fund Revenue, Expenditures and Other Sources/Uses Statement 2016

6



2016

Original

Budget

2016

YTD

Budget

2016

YTD

Actuals

Budget


Budget


2015

YTD

Actuals

2016

YTD

Actuals

'15-'16 $

Chg.

'15-'16 %

Chg.

City of Dayton Sewer Fees 16.6 16.6 16.3 (0.2) (1.5%) 15.7 16.3 0.6 4.1%

Other Jurisdictions Sewer Fees 13.1 13.1 12.8 (0.3) (2.0%) 12.3 12.8 0.5 4.4%

Subtotal Sewer Fees 29.6 29.6 29.1 (0.5) (1.7%) 28.0 29.1 1.2 4.2%

Other Charges for Services 5.5 5.5 6.0 0.5 9.7% 5.9 6.0 0.1 1.5%

Subtotal Customer Revenue 35.1 35.1 35.2 0.0 0.1% 33.9 35.2 1.3 3.8%

Other Revenue 0.7 0.7 0.5 (0.2) (30.1%) 0.6 0.5 (0.1) (18.2%)

Interest Revenue 0.1 0.1 0.2 0.2 337.7% 0.2 0.2 0.1 40.7%

Operating Transfers In 0.0 0.0 0.0 0.0 N/A 0.0 0.0 0.0 N/A

Discounts/Bad Debt/Adjustments (1.4) (1.4) (1.5) (0.2) (12.3%) (1.3) (1.5) (0.2) (14.4%)

Current Year Sources 34.5 34.5 34.3 (0.2) (0.5%) 33.3 34.3 1.0 3.1%


Personnel 10.9 10.9 10.8 0.1 1.2% 10.5 10.8 0.3 2.8%

Contracts and Materials 13.5 13.5 12.2 1.3 9.5% 12.6 12.2 (0.4) (3.4%)

Capital Equipment 1.2 1.2 1.1 0.1 10.3% 1.2 1.1 (0.1) (7.6%)

Capital Improvements 5.1 5.1 5.1 0.0 0.0% 6.1 5.1 (1.0) (16.4%)

Debt Service - Interest 1.5 1.5 1.2 0.2 15.7% 0.8 1.2 0.4 50.9%

Total Uses 32.2 32.2 30.5 1.8 5.5% 31.3 30.5 (0.8) (2.6%)

Debt Payment - Principal Radios 0.1 0.1 0.1 0.0 0.1% 0.0 0.1 0.1 174.2%

Debt Payment - Principal Bonds 2.2 2.2 1.9 0.3 13.9% 1.8 1.9 0.1 4.8%

Excess/(Shortfall) of Sources over Uses 0.0 0.0 1.9 0.2 1.9 1.7

Notes:


2. 2016 and 2017 Budgets include adopted budget only and does not include prior year's encumbrances.

3. Actuals include expense against current year appropriation and prior year's appropriation that carried forward.

4. Other Charges for Services (non-metered charges) includes BOD, SS, Special Monitoring Fees, Misc. Revenue.

5. Other Revenue includes Bad Debt Recovery and Radio Lease Proceeds.

6. Payment of bond debt principal is $1,871,352.94. Radio lease principal payment of $81,385.75 included in Debt Service.

2014-2016 Actual to 2017 Budget Comparison Sanitary Sewer Fund Fund

7



2014

Actuals

2015

Actuals

2016

Actuals

2017

Original

Budget

'16-'17

Budget

$ Chg.

'16-'17

Budget

% Chg.

City of Dayton Sewer Fees 15.9 15.7 16.3 16.8 0.4 2.5%

Other Jurisdictions Sewer Fees 13.7 12.3 12.8 13.6 0.8 6.2%

Subtotal Sewer Fees 29.5 28.0 29.1 30.3 1.2 4.1%

Other Charges for Services 4.8 5.9 6.0 5.4 (0.6) (10.6%)

Subtotal Customer Revenue 34.3 33.9 35.2 35.7 0.6 1.6%

Other Revenue 0.4 0.6 0.5 0.6 0.1 18.4%

Interest Revenue 0.1 0.2 0.2 0.1 (0.2) (77.2%)

Operating Transfers In 0.0 0.0 0.0 0.0 0.0 N/A

Other Non-Operating Revenue (0.0) (0.0) (0.0) (0.0) (0.0) 169.4%

Bad Debt Expense (0.5) (0.4) (0.3) (0.3) (0.0) 6.7%

Payment Discounts (1.1) (0.9) (1.2) (1.0) 0.2 (14.1%)

Discounts/Bad Debt/Adjustments (1.6) (1.3) (1.5) (1.4) 0.1 (8.3%)

Total Sources 33.2 33.3 34.3 34.9 0.6 1.8%


Personnel 10.0 10.5 10.8 11.2 0.4 3.4%

Contracts and Materials 11.8 12.6 12.2 14.2 2.0 16.6%

Capital Equipment 1.1 1.2 1.1 0.7 (0.4) (32.1%)

Capital Improvements 6.3 6.1 5.1 5.3 0.2 3.9%

Debt Service - Interest 0.9 0.8 1.2 1.2 (0.0) (1.5%)

Total Uses 30.0 31.3 30.5 32.7 2.2 7.3%

Debt Payment - Principal Radios 0.0 0.0 0.1 0.0 (0.1) N/A

Debt Payment - Principal Bonds 1.7 1.8 1.9 2.2 0.3 18.6%

Excess/(Shortfall) of Sources over Uses 1.5 0.2 1.9 0.0 (1.9)

Water Fund Takeaways

1. Water Fund ended the year with a positive cash balance in support of the Water Capital Master Plan implementation.

2. Sanitary Sewer Fund ended the year with a positive cash balance.

3. Pebble Lime sales in 2016 up 37% over 2015, totaling $880,280 at the end of the fourth quarter.

8

finance committee briefing 2016 year-end results general

Documents