SOLID WAST RATE STUDY - FY 2007
I
I
I
I
I
I
I
CITY OF CLEARWATER
FY 2007 SOLID WASTE
RATE STUDY
I I
I
I I
I
I
i I
I
I
I
I
I
I
I
rl ~....
,. ~.. . ~.::'tr=.'.
. .
',',
.~ "JJ
FINAL REPORT
ij"{~Hn~~~~Hfi~~~~
Utility Economics
Burton & Associates
200 Business Park Circle, Suite 101 . St Augustine, Florida 32095. Phone (904) 247-0787. Fax (904) 241-7708
E-mail: abumham@burtonandassociates.com
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
ll"f.tHn~~~HAif~~
July 5, 2007
Mr. Paul Nystrom
Controller
Solid Waste & General Services
City of Clearwater
1701 N. Hercules Ave.
Clearwater, Florida 33765
Re: FY 2007 Solid Waste Rate Study - FINAL Report
Dear Mr. Nystrom:
Burton & Associates is pleased to present this FINAL Report ofthe FY 2007 Solid Waste
Rate Study that we have performed for the City's Solid Waste System comprised of the
Solid Waste Utility Fund (Fund 424) and the Recycling Utility Fund (Fund 426).
We appreciate the fme assistance provided by you, your staff and all of the members of
City staff who participated in the analysis.
If you have any questions, please do not hesitate to call me at (904) 247-0787.
Very truly yours,
A lI\-c;:{ ve W J. 1; lA. VlI\-!tllil V1A
Andrew J. Burnham
Vice President
BIII1o" & Associates
200 Business Park Circle, Suite 101. StAugustine, Florida 32095. Phone (904) 247-0787. Fax (904) 241-7708
E-mail: abumham@burtonandassociates.com
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
TABLE OF CONTENTS
Table of Contents
CITY OF CLEARW A TER........................................................................................................ i
Table of Contents. ......... ......................... ....................... .................... ...... .............. ..... ........ ........ i
Executive Summary .................................................................................................................. 1
Section I - Introduction........................................ ............................ ........................................ 4
A. Scope....................................................................................................................... 4
B. Study Procedures......... ........................................................................................... 5
Section II - Solid Waste Fund RSA ......................................................................................... 6
A. Revenue Sufficiency Analysis .................... .......................... ................... ............... 6
1) Objective and Scope................................................................................... 6
2) Procedures................................................................................................... 7
3) Description of the Analysis......................................................................... 8
4) Assumptions................................................................................................ 8
A.
B.
C.
D.
E.
F.
G.
Revenues and Expenses............................................................ 8
Annual Operating & Capital Spending. .................................... 9
One-Time Reimbursement & Loan Payoff............................... 9
Payment in Lieu of Taxes Calculation...................................... 9
Cost Escalation........................................................................ 10
Borrowing Assumptions ...... ................... ................................ 10
Interest Earnings on Invested Funds. ...................................... 10
City of Clearwater
Final Report
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
TABLE OF CONTENTS
H. Growth. ..... ............ .... ..... ...... .................. ............ ...... .... ...... ..... 10
I. Minimum Balance in Unrestricted Reserves. ......................... 10
J. Minimum Balance in Capital Reserves................................... 10
K. Capital Improvement Program............................................... II
5) Results of the Revenue Sufficiency Analysis ........................................... II
A. Scenario 1: "Just-in-Time" ..................................................... 11
B. Scenario 2: "Level Plan @ 100%".......................................... 12
C. Scenario 3: "Level Plan @ 98.5%".........................................12
D. Scenario 4: "Roll-Off at Market Rates @ 98.5%" .................. 13
E. Supporting Analysis................................................................ 14
B. Conclusions and Recommendations ..................................................................... 17
Section In - Recycling Fund RSA ......................................................................................... 19
A. Revenue Sufficiency Analysis .................... .......................................................... 19
1) Objective and Scope ................................................................................. 19
2) Procedures................................................................................................. 20
3) Description of the Analysis....................................................................... 21
4) Assumptions.............................................................................................. 21
A. Revenues and Expenses.......................................................... 21
B. Annual Operating & Capital Spending................................... 22
C. Pinellas County Recycling Grants.......................................... 22
D. Annual Transfer to the Solid Waste Fund............................... 22
E. Payment in Lieu of Taxes Calculation.................................... 23
F. Cost Escalation........................................................................ 23
City of Clearwater
Final Report
;;
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
TABLE OF CONTENTS
G. Borrowing Assumptions ........................... .............. ................ 23
H. Interest Earnings on Invested Funds. ...................................... 23
I. Growth. ..................... .................................. ............................ 24
J. Minimum Balance in Unrestricted Reserves .......................... 24
K. Minimum Balance in Capital Reserves................................... 24
L. Capital Improvement Program............................................... 24
5) Results of the Revenue Sufficiency Analysis........................................... 24
A. Scenario I: "Just-in- Time" ................ ..................................... 24
B. Scenario 2: "Level Plan" ......................................................... 25
C. Scenario 3: "Inflation Thru FY 2011" .................................... 26
D. Supporting Analysis................................................................ 27
B. Conclusions & Recommendations ......................... ................. ......... ..................... 30
Appendix A.l .............................. .................................... ..... ....... ................................ ..... ....... 32
Schedule 1- FAMS-XL ~ Control Panel...................................................... 33
Appendix A.2 .......................................................................................................................... 34
Schedule 1 - F AMS- XL ~ Control Panel...................................................... 35
Appendix A.3 ......... ...................... .......................... ...................... ..... .......................... ....... ..... 36
Schedule 1- FAMS-XL ~ Control Panel...................................................... 37
Appendix A.4 ....... ............................................................. ... .... ....................................... ........ 38
Schedule 1 - F AMS-XL ~ Control Panel...................................................... 39
Schedule 2 - Assumptions............................................................................... 40
Schedule 3 - Beginning Balances................................................................... 41
City of Clearwater
Final Report
iii
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
TABLE OF CONTENTS
Schedule 4 - FY 2007 Operating Budget ....................................................... 42
Schedule 5 - Capital Improvement Plan......................................................... 43
Schedule 6 - Forecast of Net Revenues and Debt Service Coverage............. 44
Schedule 7 - Cash Inflows.............................................................................. 45
Schedule 8 - Cash Outflows........................................................................... 46
Schedule 9 - Capital Projects Funding Sources ............................................ 50
Schedule 10 - Projected Short-Term Borrowing............................................ 51
Schedule II - Funding Summary by Fund..................................................... 52
Appendix B.l ......................... ................................................................................................. 53
Schedule 1 - F AMS-XL ~ Control Panel...................................................... 54
Appendix B.2 .......................................................................................................................... 55
Schedule 1 - F AMS-XL ~ Control Panel...................................................... 56
Appendix B.3 .......................................................................................................................... 57
Schedule 1 - F AMS-XL ~ Control Panel...................................................... 58
Schedule 2 - Assumptions.......................... .............. ............ ............... ..... ....... 59
Schedule 3 - Beginning Balances................................................................... 60
Schedule 4 - FY 2007 Operating Budget .......................................................61
Schedule 5 - Capital Improvement Plan......................................................... 62
Schedule 6 - Forecast of Net Revenues and Debt Service Coverage............. 63
Schedule 7 - Cash Inflows.............................................................................. 64
Schedule 8 - Cash Outflows ........................................................................... 65
Schedule 9 - Capital Project Funding Sources............................................... 68
City of Clearwater
Final Report
iv
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
TABLE OF CONTENTS
Schedule 10 - Projected Short-Term Borrowing............................................ 69
Schedule II - Funding Summary By Fund .................................................... 70
City of Clearwater
Final Report
v
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
EXECUTIVE SUMMARY
Executive Summary
Weare pleased to present the results of our comprehensive rate study of the City
of Clearwater's Solid Waste and Recycling Utilities. Over the past nine months, we held
several interactive meetings with the Solid Waste/General Services Director, the Finance
Director, the Budget Director, the Solid Waste/General Services Controller and Senior
Accountant. We have reviewed these Utilities' significant operating, capital and transfer
expenditures, reserve requirements and forecasting assumptions for a ten-year projection
period (FY 2007 - FY 2016).
The City has reviewed several options for adjusting its residential, commercial
and roll-off collection rates that will allow the Solid Waste Fund to reduce its unrestricted
operating and capital reserves while it gradually increases its annual on-going revenues in
order to satisfy its annual cost requirements. Currently, the annual operating and capital
cost requirements for the Solid Waste Fund exceed its annual revenues, and absent any
adjustments to its rates, the fund will use up all available operating reserves in FY 2009.
The Solid Waste fund will utilize cost reduction efforts to reduce its cost requirements to
98.5% of projected/forecasted amounts without changing its service level. Assumptions
used for revenue and operating expense projections are stated in Schedule 2 of Appendix
AA for Solid Waste and Appendix B.3 for Recycling.
The City's current rates for roll-off service appear to be below the market and
could be increased significantly in FY 2008. It is important to note that the rates charged
City of Clearwater
Final Report
1
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
EXECUTIVE SUMMARY
for roll-off service should continue to be market-based and determined by the Solid
Waste/General Services Director. As such, we are recommending a substantial one-time
rate increase for roll-off service in FY 2008 (see Schedule 1 of Appendix A.4) and
continuing to allow the Director to determine increases in each subsequent year as is the
current practice.
Collection charges for Solid Waste for residential and commercial services have
not changed since January 1, 2001; or over six years ago. Given the need to increase
residential and commercial rates to cover annual cost requirements, we are
recommending increasing these respective rates at the same rate of increase (as identified
in Schedule 1 of Appendix A.4).
Similarly, collection charges for Recycling service have not changed since April
I, 1999; or over eight years ago. The annual operating and capital cost requirements for
the Recycling fund are in excess of its annual revenues and, absent any adjustment to its
rates, this fund will use up all available operating reserves in FY 2012. All of the same
cost increases in the Solid Waste Fund also adversely affect Recycling (e.g., pension,
fuel, energy, etc.). Given the need to raise residential, multi-family and commercial rates
to cover annual cost requirements, we are recommending increasing these respective rates
at the same rate of increase (as identified in Schedule 1 of Appendix B.3).
Since any forecast must be based on estimates about future uncertain conditions,
changing circumstances may require higher or lower increases. Because of this
uncertainty, near-term estimates are more reliable, and we recommend consideration of
City of Clearwater
Final Report
2
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
EXECUTIVE SUMMARY
the identified rate increases for only ftrst five years of the projection period (FY 2008 -
FY 2012). Furthermore, it is our strong recommendation that the City perform periodic
revenue sufficiency updates so that revised information and assumptions are incorporated
into the determination of future rate increases. As such, we therefore recommend the
adoption of the fourth scenario for the Solid Waste Fund and the third scenario for the
Recycling Fund.
City of Clearwater
Final Report
3
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
~CTIONI-ThITRODUCTION
Section I - Introduction
This Report presents the results of a Solid Waste Rate Study (Rate Study) that
Burton & Associates conducted for the City of Clearwater's Solid Waste System
(System). The City's System is comprised of two enterprise funds, the Solid Waste
Utility Fund (Solid Waste Fund) and the Recycling Utility Fund (Recycling Fund).
A. Scooe
This Rate Study included the following principal elements:
. Solid Waste Fund Revenue Sufficiency Analysis - an analysis was
conducted to evaluate the adequacy of projected revenues to satisfy the
Solid Waste Fund's cost requirements over a ten-year projection period
from FY 2007 through FY 20161.
. Recycling Fund Revenue Sufficiency Analysis - an analysis was
conducted to evaluate the adequacy of projected revenues to satisfy the
Recycling Fund's cost requirements over a ten-year period from FY 2007
through FY 20161.
It is important to note that the Rate Study also included a Diagnostic Rate
Structure Evaluation and Rate Design Analysis. This included an evaluation of the City's
existing Solid Waste and Recycling rates based upon various criteria such as
conformance with industry practice, equity, fairness, fiscal security etc. The Diagnostic
I The analysis begins with FY 2006 historical data, however, the majority of this information serves as base
data upon which future year projections of revenue and expenses are based. As such, for purposes of this
analysis, FY 2006 is not considered to be part of the projection period.
City of Clearwater 4
Final Report
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION I - INTRODUCTION
Rate Structure Evaluation concluded that the structure of the City's rates for its Solid
Waste and Recycling Systems generally satisfy the appropriate criteria and do not require
modification. As such, this report does not include or present any fmdings relative a
Rate Design Analysis that would affect the City's Solid Waste or Recycling rate
structure.
B. Studv Procedures
The revenue sufficiency analysis for each respective enterprise fund measured the
adequacy of projected revenue relative to projected cost requirements to determine
alternative financial management plans and associated annual rate adjustments, if
required, that would provide sufficient revenues to fund all of each enterprise fund's
respective cost requirements over a ten-year projection period. We accomplished this
through interactive work sessions with City staff. During these work sessions we
examined the impact of alternative scenarios upon key fmancial indicators by use of
graphical representations projected on a large screen from our computer rate models
which were up and running and upon which we conducted alternatives analyses
interactively with City staff. In this way we identified the alternative fmancial
management plans presented in this report for each enterprise fund that allows each fund
to meet its cost requirements.
City of Clearwater
Final Report
5
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION II - SOLID WASTE FUND RSA
Section II - Solid Waste Fund RSA
This section of the Report will present the results of the Revenue Sufficiency
Analysis performed for the City's Solid Waste Fund as part of this Rate Study.
A. Revenue Sufficiencv Analvsis
This section presents the results of the Revenue Sufficiency Analysis (RSA) that
was conducted for the Solid Waste Fund. The RSA was based upon a projection period
of FY 2007 through FY 20162. The following sub-sections present the objective and
scope of the RSA, the procedures employed in and description of the analysis, the
assumptions of the RSA, as well as the results of the analysis. Finally, Appendix A
includes the detailed financial analysis schedules supporting the fmancial management
plans (also referred to as "scenarios") evaluated herein for the Solid Waste Fund.
1) Obiective and ScoDe
The objective of the RSA was to:
Evaluate the sufficiency of the Solid Waste Fund's revenues over a ten-year
projection period and determine the amount of annual rate increases required, if
any, to provide sufficient revenue to satisfy all of the Solid Waste Fund's
requirements over the projection period.
2 The analysis begins with FY 2006 historical data. however, the majority of this information serves as base
data upon which future year projections of revenue and expenses are based. As such, for purposes of this
analysis, FY 2006 is not considered to be part of the projection period.
City of Clearwater 6
Final Report
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION n - SOLID WASTE FUND RSA
2) Procedures
In this RSA we developed alternative ten-year fmancial management plans or
scenarios and corresponding revenue adjustment plans through several interactive
work sessions with City staff. During these work sessions we examined the
impact of various alternatives upon key financial indicators by use of graphical
representations projected on a large screen from our computer rate models. In this
way, we identified the financial management plan scenarios and corresponding
rate plans in this report that allows the Solid Waste Fund to meet its cost
requirements throughout the projection period.
In order to initialize our analysis, we obtained the Solid Waste Fund's
historical and budgeted financial information regarding the operation of the Solid
Waste Fund. We also utilized the multi-year capital improvement program
provided by City staff. We also counseled with City staff regarding other
assumptions and policies that would affect the Solid Waste Fund, such as required
levels of operating and capital reserves, timing of repayment of existing debt,
transfers/reimbursements from other funds, operating and capital spending levels,
earnings on invested funds, escalation rates for operating costs, etc.
All of this information was entered into our proprietary Financial Analysis
and Management System (FAMS-XL ~) interactive model. The FAMS-XL ~
model produces a ten-year projection of the sufficiency of the Solid Waste Fund's
revenues to meet all of its current and projected financial requirements and
determine the specific level of residential, commercial, and roll-off rate increases
necessary in each year to provide sufficient revenues to fund all of the Solid
Waste Fund's requirements.
FAMS-XL ~ also utilizes all available and unrestricted funds in each year of
the projection period to pay for capital projects (to the extent that they are not
designated to be funded through the City's lease/purchase program) in accordance
7
City of Clearwater
Final Report
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION n - SOLID WASTE FUND RSA
with the rules of cash application defined with City staff within the model. The
model then produces a detailed summary of the funding sources to be used for
each project in the capital improvements program.
~ D~criDtWnofffleAnaws~
The RSA was performed usmg the historical and projected information
regarding the operation of the Solid Waste Fund. The City's Comprehensive
Annual Financial Report for FY 2005 and supplemental information provided by
City staff were used as sources for historical financial information in order to
establish the beginning FY 2006 balances of various funding sources. Revenue
and expense information for FY 2006 reflected actual results, while operating
expense projections were based upon the FY 2007 Solid Waste Fund budgeted
figures as provided by City Staff. Revenue projections from FY 2007 through the
end of the projection period were calculated based upon the actual FY 2006
results, extrapolated to reflect assumed growth and applicable rate increases.
During the conduct of this RSA, we communicated with City staff regarding
various assumptions used in the development of the analysis presented in this
report. The major assumptions included in RSA are listed in the next sub-section.
4) AssumDtions
The assumptions, funding strategies, and adjustments included in the RSA are
as listed below:
A. Revenues and Expenses - The FY 2006 revenue and expenses are based
on the Solid Waste Fund's actual amounts, respectively. The Solid Waste
Fund's FY 2007 Budget serves as the base year for future operating
expense and other operating revenue projections, while annual projections
of residential, commercial, and roll-off revenues are based upon the FY
City of Clearwater
Final Report
8
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION n - SOLID WASTE FUND RSA
2006 actual amounts, adjusted annually to reflect assumed growth and rate
increases as appropriate.
B. Annual Ooerating & Caoital Soending - The assumed annual spending of
operating and capital expenses versus projections reflects the results of a
multi-year historical review of actual spending versus budget performed
by City staff as part of this Rate Study. Historically, 100% of annual
budgeted capital expense levels have typically been spent, and as such, all
fmancial management plans reflect 100% spending of annual capital
expense projections. However, historically, the annual spending versus
budget for operations has varied somewhat from year to year. As such,
certain financial management plans presented in this report reflect
spending at either 100% of projected amounts or 98.5% (the three-year
average spending level identified in City staff's analysis).
C. One-Time Reimbursement & Loan Payoff - All fmancial management
plans presented herein assume the remaining balance of a prior $3.5
million interfund advance is repaid to the Solid Waste Fund in FY 2007
(representing a one-time transfer in of approximately $2.5 million).
Similarly in FY 2007, all fmancial management plans assume that the
Solid Waste Fund repays the entire remaining outstanding balance on its
only internal loan. As such, the analysis reflects a total one-time internal
loan debt service payment in FY 2007 of approximately $623,000.
D. Payment in Lieu of Taxes Calculation - The annual calculation of the
payment in lieu of taxes transfer is based upon 5.50% of the prior year's
total operating revenues in each year of the projection period beginning in
FY 2008. Prior year amounts are based upon actual amounts or budgeted
information.
City of Clearwater
Final Report
9
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION II - SOLID WASTE FUND RSA
E. Cost Escalation - Annual cost escalators for the vanous types of
operations and maintenance expenses were provided by City staff and
applied in each year of the projection period beginning in FY 2008. The
specific factors can be seen on Schedule 2 included in Appendix AA of
this report.
F. Borrowing Assumptions - The RSA assumes that new debt issued during
the projection period would carry the following terms:
Short-Term Financing (City's Lease/Purchase Program):
./ Term: 5 Years
./ Interest Rate: 3.50% in FY 2006 and 4.00% in FY 2007 and each
subsequent year of the projection period.
G. Interest Earnings on Invested Funds - It is assumed interest earnings on
invested funds would be 3.50% in FY 2006 and 4.00% per year beginning
in FY 2007 throughout the entire projection period.
H. Growth - Based upon discussions with City staff, no growth in revenue is
assumed during the projection period.
I. Minimum Balance in Unrestricted Reserves - The fmancial management
plans in this report assume that the Solid Waste Fund will maintain a
minimum Working Capital Reserve (WCR) fund balance in an amount
equal to 3 months or 25% of annual operations and maintenance (O&M)
expenses.
1. Minimum Balance in Capital Reserves - The fmancial management plans
in this report assume that the Solid Waste Fund will maintain a minimum
City of Clearwater
Final Report
10
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION IT - SOLID WASTE FUND RSA
Capital Reserve fund balance in an amount equal to approximately 1 year
of capital improvement plan expenses or $500,000.
K. Capital Improvement Program - The capital improvement program (CIP)
provided by City Staff for FY 2006 through FY 2012 is included in the
analysis by project. The estimated CIP for the remainder of the projection
period was based upon information provided by City staff for FY 2013
and a five-year rolling average, escalated by 5% per year for inflation.
5) Results of the Revenue Sufliciencv Analvsis
As described earlier, our approach to this RSA was to determine financial
management plans or scenarios and corresponding plans of annual rate
adjustments necessary to satisfy the Solid Waste Fund's cost requirements over
the projection period. A description of each of the scenarios and their financial
implications to the Solid Waste Fund are presented below.
A. Scenario 1: "Just-in- Time"
Description - The first financial management plan identified the exact
annual rate increase requirements calculated by our FAMS-XL ~ model based
upon the revenue and expense data initialized into the FAMS-XL ~ model as
provided by City staff. This scenario reflects 100% of spending of annual
operating and capital expense projections and applies the same rate increase to all
service types (i.e. residential, commercial, and roll-off).
Result - This scenario results in the use of unrestricted fund balances in
excess of the WCR target to offset annual operating and capital cost requirements
in excess of annual revenues. As such, the Solid Waste Fund uses all of the fund
balance in excess of the minimum requirement during FY 2009, and there is a
subsequent need for a substantial rate increase (19% in FY 2010) in order to
City of Clearwater
Final Report
11
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION II - SOLID WASTE FUND RSA
provide adequate revenue to satisfy annual operating and capital costs. A
summary of the results of this scenario can be seen in Appendix A.l of this report.
B. Scenario 2: "Level Plan @ 100%"
Description - The second financial management plan reflects an equal
annual rate increase of 5.50% starting in FY 2008 and extending throughout the
projection period, applied equally to all service types. This scenario also assumes
100% spending of projected operating and capital cost requirements.
Result - By implementing equal annual increase of 5.50% prior to FY
20 I 0, it 1) allows for a gradual increase in rate revenue that ultimately allows
annual operating and capital cost requirements to be met with rate revenue alone,
2) provides a more gradual reduction in fund balance to minimum required
amounts, and 3) avoids a significant rate increase to customers in FY 2010. The
results of this scenario can be seen in Appendix A.2 of this report.
C. Scenario 3: "Level Plan @ 98.5%"
Description - The third financial management plan reflects an equal
annual rate increase of 5.00% starting in FY 2008 and extending throughout the
projection period, applied equally to all service types. This scenario assumes
100% spending of projected annual capital requirements and 98.5% spending of
projected annual operating cost requirements.
Result - Assuming a lower level of operating expenditures allows for a
lower level of annual rate increases. As such, this scenario results in a 5.00% per
year increase versus the 5.50% per year increase contained in Scenario 2. As with
Scenario 2, this scenario also 1) allows for a gradual increase in rate revenue that
ultimately allows annual operating and capital cost requirements to be met with
rate revenue alone, 2) provides a more gradual reduction in fund balance to
minimum required amounts, and 3) avoids a significant rate increase to customers
12
City of Clearwater
Final Report
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION II - SOLID WASTE FUND RSA
in FY 2010. The results of this scenario can be seen in Appendix A.3 of this
report.
D. Scenario 4: "Roll-Off at Market Rates @ 98.5%"
Description - The fourth fmancial management plan reflects a specific
plan of rate increases developed for Roll-Off service considering the cost of
providing that service as well as the level of the City's existing rates versus others
providing similar services. Given the level of revenue to be provided by the
identified increases for Roll-Off service in this scenario, the annual rate increases
for residential and commercial rates were designed to provide the remaining level
of additional revenue in each year of the projection period necessary to provide a
the same level of total annual rate revenue increases identified in Scenario 3. This
scenario assumes 100% spending of projected annual capital requirements and
98.5% spending of projected annual operating cost requirements.
Result - Given that the City's current rates for Roll-Off service are
substantially below the current rates of others offering the same or similar service,
the City is able to substantially increase its rates in FY 2008. This serves to
reduce the level of rate increase required on its residential and commercial
customers in FY 2008 (4.00% versus 5.00%) and still result in Roll-Off rates
below the market average. Furthermore, applying equal annual increases of 4.5%
to Roll-Off rates per year each year thereafter is currently estimated to provide
future rates at the end of the projection period that will be very near the average
market rate for such service (assuming others increase their rates annually by 3%
per year for inflation). Each year after FY 2008, while Roll-Off rates increase by
the aforementioned 4.50% per year, residential and commercial rates will increase
by 5.00% per year. As with Scenarios 2 and 3, this scenario also 1) allows for a
gradual increase in rate revenue that ultimately allows annual operating and
capital cost requirements to be met with rate revenue alone, 2) provides a more
City of Clearwater
Final Report
13
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION n - SOLID WASTE FUND RSA
gradual reduction in fund balance to minimum required amounts, and 3) avoids a
significant rate increase to customers in FY 2010. The results of this scenario can
be seen in Appendix A.4 of this report.
E. Supporting Analvsis
The supporting analysis for the development of the financial management
plans or scenarios presented in the prior sub-section is presented below.
I. Basis for the Analysis
The scenarios presented in this report were developed by preparing
a ten-year projection of the financial results of the Solid Waste Fund,
starting with the current revenues estimated for FY 2007.
As a basis for all the scenarios evaluated, the analysis determined
the minimum level of total revenue required in FY 2008, the first true
projected year, and compared that to the projected revenue in FY 2008
with current rates. To the extent that an increase in revenue was needed in
FY 2008, the model determined the amount of additional revenue required
in FY 2008 and determined the percentage increase in revenue that that
represented across all rates for residential, commercial, and roll-off
servIces.
This process was repeated for each subsequent year in the
projection period to determine the amount of additional rate revenue
required in each year, compared to the rate revenue projected with the
rates from the prior year. Once the model determined the required rate
increase adjustment in each year (Scenario 1), a conversion to a levelized
rate adjustment plan was examined for Scenarios 2, 3, and 4. In this
approach, the same level of rate increase was identified and applied for
City of Clearwater
Final Report
14
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION n - SOLID WASTE FUND RSA
each individual service type that would produce sufficient revenue to meet
the Solid Waste Fund's cost requirements over the projection period.
2. Financial Results of Operations and Sources and Uses of Funds
Appendix A of this report presents the results for the scenarios
described previously. Appendix A.l presents the results of Scenario 1 (the
"Just-in-Time" Scenario), Appendix A.2 presents the results of Scenario 2,
(the "Level Plan @ 100%" Scenario), Appendix A.3 presents the results of
Scenario 3, (the "Level Plan @ 98.5%" Scenario), while Appendix AA
presents the results of Scenario 4 (the "Roll-Off at Market Rates @
98.5%" Scenario).
It is important to note that unless stated otherwise, the schedules
described below are included only for Scenario 4 in Appendix A.4.
Schedule I of Appendixes A.l, A.2, A.3, and A.4 present the
resulting Control Panels of their respective scenarios.
Schedules 2 through 5 of Appendix AA present detailed schedules
of the inputs and assumptions that are applicable to all of the financial
management plans developed in this RSA. Schedule 2 contains many of
the assumptions described in Section n.AA. Schedule 3 contains the end
of FY 2005 fund balances that serve as the FY 2006 beginning balances of
our analysis. Schedule 4 contains the detailed operating expense
departmental budget for FY 2007 provided by City staff. Schedule 5
provides a listing of the CIP projects and amounts utilized in the analysis.
Schedule 6 is the Pro Forma schedule that presents a projected
income statement, and cash flow analysis and can be found in Appendix
A.4.
City of Clearwater
Final Report
15
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION II - SOLID WASTE FUND RSA
Schedule 7 of Appendix A.4 contains a detailed list of all projected
cash inflows from FY 2006 through FY 2016, while Schedule 8 contains a
detailed list of all projected cash outflows during the same time period.
Schedules 9 through 11 present detailed fmancial results of
Scenario 4. Schedule 9 shows the funding sources utilized to pay for the
total capital improvement plan spending levels identified on Schedules 5.
Schedule 10 contains the calculation of any short-term borrowings (i.e.
annual Lease/Purchase Program amounts) forecasted during the projection
period. Schedule 11 presents a fund level cash flow reconciliation,
providing the beginning balance in each year, the amount utilized for
project funding, interest calculations, and the end of year fund balance.
i) System Revenues
Revenues can be considered as I) rate revenues subject to
rate increases, and 2) all other categories of revenue. Rate revenue
for FY 2007 was projected based upon the Solid Waste Fund's FY
2006 actual results, plus growth and applicable rate increases. Rate
revenue for the fiscal years after FY 2007 were projected based
upon additional rate revenue from the rate increase assumed in
each year for each respective scenario. All other non-rate revenues
were projected in subsequent years, by category of revenue, to be
the same as the FY 2007 budgeted revenue for those revenue
categories (unless affected by the rate increases assumed in each
scenario, such as surcharge revenue), except that budgeted interest
revenue was not used as an input to the rate model. The model
calculates interest earnings each year based upon average fund
balances (interest income is shown by fund on Schedule 11 of
Appendix A.4 for Scenario 4).
City of Clearwater
Final Report
16
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION n - SOLID WASTE FUND RSA
ii) Revenue Reauirements
The annual revenue requirements used in the projection of
required rate revenues were based upon budgeted O&M expenses
for FY 2007, and any appropriate adjustments as described in
Section n.AA. In subsequent years of the projection period,
individual O&M costs were adjusted based upon the appropriate
cost escalation factor provided by City staff described in Section
n.A.4.
B. Conclusions and Recommendations
. The annual operating and capital cost requirements for the Solid Waste Fund
are in excess of annual revenues and absent any adjustment to the rates for
solid waste services, the Solid Waste Fund will essentially use up all operating
reserves in FY 2010.
. The City has options relative to how it adjusts it rates for residential,
commercial, and roll-off services that will allow the Solid Waste Fund to
spend down operating reserves in excess of specified minimums while
increasing rates such that on an ongoing basis annual revenues will be
adequate to satisfy annual cost requirements.
. The City's current rates for Roll-Off service appear to be substantially below
the market average and could be increased fairly significantly.
. Given the need to increase rates to cover annual cost requirements and the
ability to increase its rates from a market perspective for Roll-Off service, we
recommend that the City implement the rate increases identified in Scenario 4
17
City of Clearwater
Final Report
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION II - SOLID WASTE FUND RSA
for each respective service type for the immediate five-year planning period of
this analysis (FY 2007 - FY 20 11)3 as identified on Schedule 1 of Appendix
A.4.
. The City should perform periodic revenue sufficiency updates so that
additional or revised information regarding future operational and capital
costs requirements may be incorporated into the determination of required rate
increases that would be necessary in order to allow the Solid Waste Fund to
meet its cost requirements during this time period. Advanced planning will
play a prominent role in avoiding significant future rate impacts to the Solid
Waste Fund's customers resulting from these variables occurring differently
than currently projected.
3 It is important to note that the rates to be charged for the market-based Roll-Off service are adjusted
annually (to the extent necessary) at the discretion of the Director of Solid Waste. As such, we would
recommend adoption of the FY 2008 increase for Roll-Off rates in Scenario 4 and allow the Director to
determine the exact level of increase in RolI-Offrates each year thereafter, consistent with current practice.
City of Clearwater
Final Report
18
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION ill - RECYCLING FUND RSA
Section III - Recycling Fund RSA
This section of the Report will present the results of the Revenue Sufficiency
Analysis performed for the City's Recycling Fund as part of this Rate Study.
A. Revenue Sufficiencv Analvsis
This section presents the results of the Revenue Sufficiency Analysis (RSA) that
was conducted for the Recycling Fund. The RSA was based upon a projection period of
FY 2007 through FY 20164. The following sub-sections present the objective and scope
of the RSA, the procedures employed in and description of the analysis, the assumptions
of the RSA, as well as the results of the analysis. Finally, Appendix B includes the
detailed fmancial analysis schedules supporting the financial management plans (also
referred to as "scenarios") evaluated herein for the Recycling Fund.
1) Obiective and ScoDe
The objective of the RSA was to:
Evaluate the sufficiency of the Recycling Fund's revenues over a ten-year
projection period and determine the amount of annual rate increases required, if
any, to provide sufficient revenue to satisfy all of the Recycling Fund's
requirements over the projection period.
4 The analysis begins with FY 2006 historical data, however, the majority of this information serves as base
data upon which future year projections of revenue and expenses are based. As such, for purposes of this
analysis, FY 2006 is not considered to be part of the projection period.
City of Clearwater 19
Final Report
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION In - RECYCLING FUND RSA
2) Procedures
In this RSA we developed alternative ten-year fmancial management plans or
scenarios and corresponding revenue adjustment plans through several interactive
work sessions with City staff. During these work sessions we examined the
impact of various alternatives upon key financial indicators by use of graphical
representations projected on a large screen from our computer rate models. In this
way, we identified the financial management plan scenarios and corresponding
rate plans in this report that allows the Recycling Fund to meet its cost
requirements throughout the projection period.
In order to initialize our analysis, we obtained the Recycling Fund's historical
and budgeted fmancial information regarding the operation of the Recycling
Fund. We also utilized the multi-year capital improvement program provided by
City staff. We also counseled with City staff regarding other assumptions and
policies that would affect the Recycling Fund, such as required levels of operating
and capital reserves, annual revenues from sale of recyclable materials,
supplemental capital funding sources, transfers to other funds, operating and
capital spending levels, earnings on invested funds, escalation rates for operating
costs, etc.
All of this information was entered into our proprietary Financial Analysis
and Management System (FAMS-XL ~) interactive model. The FAMS-XL ~
model produces a ten-year projection of the sufficiency of the Recycling Fund's
revenues to meet all of its current and projected fmancial requirements and
determine the specific level of residential, multi-family, and commercial rate
increases necessary in each year to provide sufficient revenues to fund all of the
Recycling Fund's requirements.
FAMS-XL ~ also utilizes all available and unrestricted funds in each year of
the projection period to pay for capital projects (to the extent that they are not
20
City of Clearwater
Final Report
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION III - RECYCLING FUND RSA
designated to be funded through the City's lease/purchase program) in accordance
with the rules of cash application defined with City staff within the model. The
model then produces a detailed summary of the funding sources to be used for
each project in the capital improvements program.
3) Descr;Dt;on of the Analvsis
The RSA was performed using the historical and projected information
regarding the operation of the Recycling Fund. The City's Comprehensive
Annual Financial Report for FY 2005 and supplemental information provided by
City staff were used as sources for historical financial information in order to
establish the beginning FY 2006 balances of various funding sources. Revenue
and expense information for FY 2006 reflected actual results, while operating
expense projections were based upon the FY 2007 Recycling Fund budgeted
figures as provided by City Staff. Revenue projections from FY 2007 through the
end of the projection period were calculated based upon the actual FY 2006
results, extrapolated to reflect assumed growth and applicable rate increases.
During the conduct of this RSA, we communicated with City staff regarding
various assumptions used in the development of the analysis presented in this
report. The major assumptions included in RSA are listed in the next sub-section.
4) AssumDt;ons
The assumptions, funding strategies, and adjustments included in the RSA are
as listed below:
A. Revenues and EXDenses - The FY 2006 revenue and expenses are based
on the Recycling Fund's actual amounts, respectively. The Recycling
Fund's FY 2007 Budget serves as the base year for future operating
expense and other operating revenue projections (excluding revenue from
the sale of recyclable materials), while annual projections of residential,
City of Clearwater 21 Burton & Associates
Final Report Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION ill - RECYCLING FUND RSA
multi-family, and commercial revenues are based upon the FY 2006 actual
amounts, adjusted annually to reflect assumed growth and rate increases as
appropriate. Annual projections of revenue from the sale of recyclable
materials (starting in FY 2007) are based upon the FY 2006 actual
amounts less 5%, and are assumed to remain constant throughout the
projection period. It is important to note that these revenues are
substantial and have a high degree of uncertainty due to the potential
variability in the recycling market. To the extent that the actual revenues
collected from the sale of recyclable materials differ from current
projections, it could have a material affect on the financial results of the
scenarios as presented in this report.
B. Annual Operating & Caoital Soending - The assumed annual spending of
operating and capital expenses versus projections reflects the results of a
multi-year historical review of actual spending versus budget performed
by City staff as part of this Rate Study. Historically, 100% of annual
budgeted capital and operating expense levels have typically been spent,
and as such, all fmancial management plans reflect 100% spending of
annual capital and operating expense projections.
C. Pinellas County Recvcling Grants - All fmancial management plans
presented herein assume that the City receives a Recycling Grant from
Pinellas County in FY 2008 of $420,000 in order to fund certain
capital/program costs identified in the capital improvement program. It is
important to note that to the extent that the City does not receive the grant,
City staff will defer completion/funding of the identified costs until a
future date at which funding is available.
D. Annual Transfer to the Solid Waste Fund - On an annual basis, the
Recycling Fund transfers monies to the Solid Waste Fund for the cost of
City of Clearwater
Final Report
22
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION m - RECYCLING FUND RSA
administrative services/provided by the Solid Waste Fund that benefit the
Recycling Fund. Based upon this analysis, it was determined that the
annual transfer should be increased from $147,000 in FY 2007 to
approximately $230,000 in FY 2008, escalating each year thereafter based
upon annual increases in cost for the Administration Department of the
Solid Waste Fund.
E. Payment in Lieu of Taxes Calculation - The annual calculation of the
payment in lieu of taxes transfer is based upon 5.50% of the prior year's
total operating revenues in each year of the projection period beginning in
FY 2008. Prior year amounts are based upon actual amounts or budgeted
information.
F. Cost Escalation - Annual cost escalators for the vanous types of
operations and maintenance expenses were provided by City staff and
applied in each year of the projection period beginning in FY 2008. The
specific factors can be seen on Schedule 2 included in Appendix B.3 of
this report.
G. Borrowing Assumptions - The RSA assumes that new debt issued during
the projection period would carry the following terms:
Short-Term Financing (City's Lease/Purchase Program):
./ Term: 5 Years
./ Interest Rate: 3.50% in FY 2006 and 4.00% in FY 2007 and each
subsequent year of the projection period.
H. Interest Earnings on Invested Funds - It is assumed interest earnings on
invested funds would be 3.50% in FY 2006 and 4.00% per year beginning
in FY 2007 throughout the entire projection period.
City of Clearwater
Final Report
23
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION m - RECYCLING FUND RSA
I. Growth - Based upon discussions with City staff, no growth in revenue is
assumed during the projection period.
J. Minimum Balance in Unrestricted Reserves - The fmancial management
plans in this report assume that the Recycling Fund will maintain a
minimum Working Capital Reserve (WCR) fund balance in an amount
equal to 3 months or 25% of annual operations and maintenance (O&M)
expenses.
K. Minimum Balance in Capital Reserves - The fmancial management plans
in this report assume that the Recycling Fund will maintain a minimum
Capital Reserve fund balance in an amount equal to approximately 1 year
of capital improvement plan expenses or $500,000.
L. CaDital ImDrovement Program - The capital improvement program (CIP)
provided by City Staff for FY 2006 through FY 2012 is included in the
analysis by project. The estimated CIP for the remainder of the projection
period was based a five-year rolling average, escalated by 5% per year for
inflation.
5) Results of the Revenue Sufliciencv Analvsis
As described earlier, our approach to this RSA was to determine financial
management plans or scenarios and corresponding plans of annual rate
adjustments necessary to satisfy the Recycling Fund's cost requirements over the
projection period. A description of each of the scenarios and their financial
implications to the Recycling Fund are presented below.
A. Scenario 1: "Just-in- Time"
Description - The first financial management plan identified the exact
annual rate increase requirements calculated by our FAMS-XL ~ model based
City of Clearwater
Final Report
24
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION HI - RECYCLING FUND RSA
upon the revenue and expense data initialized into the FAMS-XL ~ model as
provided by City staff. This scenario reflects 100% of spending of annual
operating and capital expense projections and applies the same rate increase to all
service types (i.e. residential, multi-family, and commercial).
Result - This scenario results in the use of unrestricted fund balances in
excess of the WCR target to offset annual operating and capital cost requirements
in excess of annual revenues. As such, without any rate increases, the Recycling
Fund uses all of the fund balance in excess of the minimum requirement during
FY 2012, and there is a subsequent need for substantial rate increases (28% in FY
2012 and 24% in FY 2013) in order to provide adequate annual revenue to satisfy
annual operating and capital costs. A summary of the results of this scenario can
be seen in Appendix B.l of this report.
B. Scenario 2: "Level Plan"
Description - The second fmancial management plan reflects an equal
annual rate increase of 5.75% starting in FY 2008 and extending throughout the
projection period, applied equally to all service types. This scenario also assumes
100% spending of projected operating and capital cost requirements.
Result - By implementing equal annual increase of 5.75% prior to FY
2012, it I) allows for a gradual increase in rate revenue that gradually increases
revenues consistent with annual increases in operating and capital cost
requirements, 2) provides a much more gradual reduction in fund balance to
minimum required amounts by the end of the projection period (FY 2016), and 3)
avoids significant rate increases to customers during the projection period. The
results of this scenario can be seen in Appendix B.2 of this report. It is important
to note that this scenario does not provide adequate annual revenues to satisfY
current projections of future annual cost requirements. As such, after FY 2016,
when there are no longer any excess operating reserve fund balances available to
25
City of Clearwater
Final Report
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION m - RECYCLING FUND RSA
satisfy annual shortfalls of revenue, the Recycling Fund would likely require
increases greater than 5% per year absent any reductions in cost.
C. Scenario 3: "Inflation Thru FY 2011"
Description - The third financial management plan reflects an equal
annual rate increase of 3.00% starting in FY 2008 through FY 2011 and an
11.00% annual increase in FY 2012 extending throughout the remaining five
years of the projection period, applied equally to all service types. This scenario
also assumes 100% spending of projected annual operating and capital
requirements.
Result - By implementing some level of annual rate increases prior to FY
2012 (albeit lower than Scenario 2), it does 1) allow for an increase in annual rate
revenue that provides for a gradual reduction in fund balances and 2) minimizes
rate spikes to customers during the projection period. The results of this scenario
can be seen in Appendix B.3 of this report.
When evaluating the merits of each of the above-described scenarios, it is
important to consider a few additional factors. First, there is generally a greater
degree of variability in projections beyond five years, such that the actual rate
increase requirements in FY 2012 and beyond will likely be different (potentially
higher or lower) than as presented today. Second, annual revenues resulting from
the sale of recyclable material may be better during the projection period than as
currently forecasted, which would reduce the amount of future rate increase
requirements, all other things being equal. Finally, to the extent that the City
updates this analysis every two to three years, it would be able to adjust certain
parameters of its financial plan to avoid the future rate impacts in FY 2012 and
beyond as presented today if they appeared likely to occur.
City of Clearwater
Final Report
26
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION m - RECYCLING FUND RSA
D. SUDllortinl! Analvsis
The supporting analysis for the development of the financial management
plans or scenarios presented in the prior sub-section is presented below.
1. Basis for the Analysis
The scenarios presented in this report were developed by preparing
a ten-year projection of the fmancial results of the Recycling Fund,
starting with the current revenues estimated for FY 2007.
As a basis for all the scenarios evaluated, the analysis determined
the minimum level of total revenue required in FY 2008, the fIrst
projected year, and compared that to the projected revenue in FY 2008
with current rates. To the extent that an increase in revenue was needed in
FY 2008, the model determined the amount of additional revenue required
in FY 2008 and determined the percentage increase in revenue that that
represented across all rates for residential, multi-family, and commercial
servIces.
This process was repeated for each subsequent year m the
projection period to determine the amount of additional rate revenue
required in each year, compared to the rate revenue projected with the
rates from the prior year. Once the model determined the required rate
increase adjustment in each year (Scenario 1), a conversion to a more
levelized rate adjustment plan was examined for Scenarios 2 and 3. In this
approach, the same level of rate increase was identified and applied for
each service type that would produce sufficient revenue to meet the
Recycling Fund's cost requirements over the projection period.
City of Clearwater
Final Report
27
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION m - RECYCLING FUND RSA
2. Financial Results of Operations and Sources and Uses of Funds
Appendix B of this report presents the results for the scenarios
described previously. Appendix B.l presents the results of Scenario 1 (the
"Just-in- Time" Scenario), Appendix B.2 presents the results of Scenario 2,
(the "Level Plan" Scenario), while Appendix B.3 presents the results of
Scenario 3 (the "Inflation Thru FY 2011" Scenario).
It is important to note that unless stated otherwise, the schedules
described below are included only for Scenario 3 in Appendix B.3.
Schedule I of Appendixes B.l, B.2, and B.3 present the resulting
Control Panels of their respective scenarios.
Schedules 2 through 5 of Appendix B.3 present detailed schedules
of the inputs and assumptions that are applicable to all of the financial
management plans developed in this RSA. Schedule 2 contains many of
the assumptions described in Section In.A.4. Schedule 3 contains the end
of FY 2005 fund balances that serve as the FY 2006 beginning balances of
our analysis. Schedule 4 contains the detailed operating expense
departmental budget for FY 2007 provided by City staff. Schedule 5
provides a listing of the CIP projects and amounts utilized in the analysis.
Schedule 6 is the Pro Forma schedule that presents a projected
income statement, and cash flow analysis and can be found in Appendix
B.3.
Schedule 7 of Appendix B.3 contains a detailed list of all projected
cash inflows from FY 2006 through FY 2016, while Schedule 8 contains a
detailed list of all projected cash outflows during the same time period.
City of Clearwater
Final Report
28
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION m - RECYCLING FUND RSA
Schedules 9 through 11 present detailed fmancial results of
Scenario 3. Schedule 9 shows the funding sources utilized to pay for the
total capital improvement plan spending levels identified on Schedules 5.
Schedule 10 contains the calculation of any short-term borrowings (i.e.
annual LeaselPurchase Program amounts) forecasted during the projection
period. Schedule 11 presents a fund level cash flow reconciliation,
providing the beginning balance in each year, the amount utilized for
project funding, interest calculations, and the end of year fund balance.
i) Svstem Revenues
Revenues can be considered as I) rate revenues subject to
rate increases, and 2) all other categories of revenue (including
most notably, revenue from the sale of recyclable materials). Rate
revenue for FY 2007 was projected based upon the Recycling
Fund's FY 2006 actual results, plus growth and applicable rate
increases. Rate revenue for the fiscal years after FY 2007 were
projected based upon additional rate revenue from the rate increase
assumed in each year for each respective scenario. All other non-
rate revenues were projected in subsequent years, by category of
revenue, to be the same as the FY 2007 budgeted revenue for those
revenue categories (unless either stated differently in Section
nI.A.4, such as revenue from the sale of recyclable materials, or
affected by the rate increases assumed in each scenario, such as
surcharge revenue), except that budgeted interest revenue was not
used as an input to the rate model. The model calculates interest
earnings each year based upon average fund balances (interest
income is shown by fund on Schedule 11 of Appendix B.3 for
Scenario 3).
City of Clearwater
Final Report
29
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION m - RECYCLING FUND RSA
ii) Revenue Reauirements
The annual revenue requirements used in the projection of
required rate revenues were based upon budgeted O&M expenses
for FY 2007, and any appropriate adjustments as described in
Section In.A.4. In subsequent years of the projection period,
individual O&M costs were adjusted based upon the appropriate
cost escalation factor provided by City staff described in Section
In.AA.
B. Conclusions & Recommendations
. The annual operating and capital cost requirements for the Recycling Fund are
in excess of annual revenues and absent any adjustment to the rates for solid
waste services, the Recycling Fund will essentially use up all operating
reserves during FY 2012.
. The City has options relative to how it adjusts it rates for residential, multi-
family, and commercial services that will allow the Recycling Fund to spend
down operating reserves in excess of specified minimums while increasing
rates such that on an ongoing basis annual revenues will approximate annual
cost requirements.
. In order to balance the use of excess operating reserves to satisfy annual
shortfalls in revenue with the objective of gradually increasing annual
revenues to satisfy annual cost requirements, we recommend that the City
implement the rate increases identified in Scenario 3 for the immediate five-
year planning period (FY 2007 - FY 2011) as identified on Schedule 1 of
Appendix B.3.
City of Clearwater
Final Report
30
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
SECTION ill - RECYCLING FUND RSA
· The City should perform periodic revenue sufficiency updates so that
additional or revised information regarding future operational and capital
costs requirements and sale of recyclable material revenues may be
incorporated into the determination of required rate increases that would be
necessary in order to allow the Recycling Fund to meet its cost requirements
during this time period. Advanced planning will play a prominent role in
avoiding significant future rate impacts to the Recycling Fund's customers
resulting from these variables occurring differently than currently projected.
City of Clearwater
Final Report
31
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX A.1
AJ!pendix A.l
Financial Analysis Schedule:
Solid Waste Fund RSA:
Scenario 1: "Just-in-Time"
City of Clearwater
Final Report
32
Burton & Associates
Utility Economics
I
I
~ ..-4 ~
I . ~ ~ ~
Q ..( Z
~ .....
~ es ~ .~ E
~ ~
I ~ ==
~ ~ ~ ~~
~ ~ Z ~.o
I .::::
~ ~ 8 ::: .';::
~~
< @ 1::
" ~ ==
I ~
tI:l
~ ~
I ~ ~
rJ'l I
-
< ~
I ~ S
Q
~
Q ::
u
I ~ tI:l
~
0
I rJ'l
.....
.....
I
I
I
I
I ...
~
I ~
~ 1::
o ~
~
I ~~
-
ol:t
.... .==
I u~
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX A.2
Alwendix A.2
Financial Analvsis Schedule:
Solid Waste Fund RSA:
Scenario 2: "Level Plan @ 1000/0"
City of Clearwater
Final Report
34
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~ ~ ~
Q < ~
=' ~ ~
~ ~ ~
~ ~ z
~ Q.c 0
~ ~ ~
.( ~
= ~
~ ~
~ ~
~
.(
~
Q
~
~
o
~
~ ~
~ .....
~ E
.... ~
~ ::
~ ~
~~
~o
~ .....
~:;:
=:;5
.s
a...
:=
~
.,..,
tv')
a...
~
~
~ 1::
~ ~
U~
~~
-
.c~
..... ...
U~
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX A.3
AJ!pendix A.3
Financial Analvsis Schedule:
Solid Waste Fund RSA:
Scenario 3: "Level Plan @ 98.50/0"
City of Clearwater
Final Report
36
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX A.4
AJ!pendix A.4
Financial Analysis Schedule:
Solid Waste Fund RSA:
Scenario 4: "Roll-Off at Market Rates @ 98.50/0"
City of Clearwater
Final Report
38
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~ ~ ~
=' ~ ~
~ ~ ~
rJ'l ~ Z
~ ~ 0
~ ~ u
..( -< @
= ~
~ ~
~ ~
rJ'l .:...
..(
~
Q
~
~
o
rJ'l
~
~
='
Q
~
=:
u
r-'J
~q~~
~~
'It 1 'It 'It~ ~
i~"" I- E I
~l3~~i~~~~~ ~
~ ~
~ .....
~ is
..... ~
~ :::
~ ~
. ~~
I ~~
~::::
....
I =:s
a
II ....
==
II ~
:
.
&
&
0\
"">
...
~
~
l::Sl::
~ ~
u~
~~
-
o~
.... .....
U~
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX A.4
SCHEDULE 2 - ASSUMPTIONS
CITY OF CLEARWATER. FL
Solid \~Jc1Stt' S"c,krn F,"allclal r,1c1I1c1gement Progralll Summary
t, s SI~IlII)ff()f)S
........aI.. ~.a~.- -~-. EUa fUIIl EUIIlI EllIlII EX.JIJI fUI11 EUI1Z nao EUIH EIJm EUm
SaUd w.- ~ GraMh'
RHidIntiaI Fees N1A MIA 000% 0.00% 000% 0.00% 000% 0.00% 000% 0.00% 000%
COIlMIfC~ Fees N1A MIA 0.00% 000% 0.00% 0.00% 000% 000% 0.00% 000% 000%
RolI-Off F... N1A MIA 0.00% 0.00% 0.00% 0.00% 000% 0.00% 000% 0.00% 0.00%
0IhAr....... ~
F..nc:Ilis. ".. . Pinebs County N1A MIA 000% 0.00% 0.00% 0.00% 000% 000% 0.00'% 000% 0..00'%
Contf8Clor Collection ".. N1A MIA 650% 2.25% 225% 2.25% 225% 225'1(, 225% 225'1(, 2.25%
FinIS. F""-its & PeMliH N1A N1A 0.00% 0.00% 0.00% 0.00% 000% 0.00% 0.00% 000'% 0.00'%
Surplus Vehicles N1A MIA 0.00% 0.00'% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00'%
S.. of RecycItebIet N1A MIA 0.00% 0.00% 0.00% 0.00% 0.00'% 0.00% 0.00'% 0.00'% 000'%
Olher Geller.. R_ N1A MIA 4.00% 4.00% 4.00% 4.00% 4.00% 400% 4.00% 4..00% 400'%
Work... Comp ReimburH N1A MIA 000% 0.00% 000% 0.00% 0.00'% 000% 0.00'% 000% 0.00'%
Unappropri8lllll RIUinlIlI &mings N1A MIA 000% o 00% 0.00% 0.00% 000% 0.00% 0.00% 000% 000%
UnIntic;p.tlllllnl_ &mings N1A MIA 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 000% 0.00%
late Payment 1'.. N1A MIA 0.00% 0.00% 0.00% 0.00% 0.00% 000% 000'% 000% 0..00%
~ F.---- ..........
FulT_~&W.. N1A MIA 4.00% 4.00% 4.00% 4.00% 4.00% 400% 4.00% 4.00% 4.00%
Pill TIfM SIIariH & w.. N1A MIA 400% 400% 4.00% 4.00% 4.00% 400% 4.00% 4.00'1(, 4..00%
Spec. P-v N1A MIA 4.00% 4.00% 4.00% 4.00% 4.00% 400% 4.00% 400% 4.00%
Oveltime N1A MIA 400% 4.00% 4.00% 400% 400% 400% 400% 4.00% 400%
MIjor MlIlIicallns-Emp N1A MIA 6.00% 6.00% 600% 6.00% 6.00% 600% 600% 6.00% 6.00%
!nip Pension PUn - % of P8Y N1A MIA 16.00% 20.00% 2000% 20.00% 2000% 20.00% 2000% 2000% 20.00%
Intelfund T..... - % of Py Tal.. Op Rev MIA MIA 5.50% 5.50% 5.50% 5.50% 5.50% 550% 5.50% 550% 5..50%
All Olhef Openiting E~ N1A MIA 3.50% 3.00% 300% 3.00% 300% 300% 300% 300% 3.00%
.......... ...... . --. ,...., ......-.........-. fIai fUIIl EUIIlI fIJIl1i
3.50% 4.00% 4.00% 4.00%
Tenn at Debt 5 Y...
- .
1nleNIt:
FY 2006 3.50% 3
FY 2007 - FY 2016 4.00%
CallI <l~'
Colt of 155'*lCe 1.00% ofP.
Undelwriter'. Discount $0.00 per $1.000
Bond In.ur_ o ...... lCIIII OS
Clpil8lizlllllnteml :~~
City of Clearwter
Final Report
40
Burton & Associates
Utility Economics
I
I
SOLID WASTE RATE STUDY
APPENDIX A.4
SCHEDULE 3 - BEGINNING BALANCES
I
I
I
I
I
CITY OF CLEARWATER. FL
Solid Waste System Financial ',lanagement Program Summar)'
~ e SJ.In'-1//JS1_~_CJ..I_?!.l~~
I8IIInee .. crt
!tI3OI2OO5
..
~or
ReHMd ..
Prajeds IIClt in
It..CI'
Beginning
8111rK:e AlIailabIe
.. Projects in the
CI'
FUND mLE
City of Clearwter
Final Report
41
S 1...871 S S 1....111
S 6,159,502 S S 6.15l1.582
S S S 926.150
S 8.'" 373 S S U10SlJ
EOY FY 2IIl!I
S 200
S 8.118.351
S
S 821.934
S
$
$
$ 136
S 1..621
S (413.159)
S (165,346)
S (38.829)
$ (82.474)
S (21,420)
S (75.020)
S
S 1.1".313
S
$ (1,984,871)
S 6,159.502
$
S 926,150
S
S
S
S
S 926.150
S
$
S
S
S 926.150
S 1.....71 I
Burton & Associates
Utility Economics
CipitlllmprCMlMllls Fund
R_ue Fund
Restricted Re_ Fund
leU! ContolidaIed Fund llellnce
I
RfVENUE FUND DETAIl
CURRENT UNRESTRICTED ASSETS
Cnh On HInd & In BaNes
Equity In Pooled Cash & IrMsIments
Advances To Other Funds
Accounts & ConlrIets Reeeivable. Net Of UnbiIIed ChaIgH Est.
Due From Other Funds
Due From Other ~ Entities
lIwenlories
PES
Total Ulll'elllrldad ,.....
Less: Aceounts IIId Conbac:ts PIyIble
Less: Accrued PayruI
Less: Compenuted Ab.-.ees
Less: Due to Other Funds
Less: Aceruecllnterest PIyIble
Less Notes. Loan, Pool~. IIId Acq ConlrIets
Less: Cuntnt I.iIIbiIities
Total U.....ncted WorIdng c.p...1
Less: lrMnlories
Less: Assets in CI' Fund
Net Ut..1lricead W...... ~ A.....
I
I
I
I
I
R.-letecI ,.....
Cnh And Cash EquivIIents
Cust_ 0ep0sU
kwestments
Interest ReeeiwabIe
Advances To Other Funds
UnImortized Bond Is_ Costs
Total Noneunent R.IridecI ,.....
Less: ~ed AbMnces
Less: Bonds PIyIble
Less: Cust_ DeposiIs
Less: Amount AdiIIlII For CapillI Funding
Net~~
I
I
I
I
~ Or Rieelrieted .....".. Avellllble Few ~ FuncIng
CapillI ~ Fund
I
I
I
I
SOLID WASTE RATE STUDY
I
APPENDIX A.4
SCHEDULE 4 - FY 2007 OPERATING BUDGET
I
CITY 0> C~EA;;:\'IATE;;: " -
Sill \~ J 1 " 3 v ~ tr ' 0 II d r"l' I \. .p l 3 "
C \ 5 ':
'J -.- .. .;"' .".. .. .7r-" .-
couac:-. couac:-. - -- - ~ 1OtM. ".,
_I6MCES
5_ '..__IW_ S 163UOI 172.110 06J.82ll 313.990 39lI.75Cl m.3'0 S J.062,700
51Q2DO Pad r.......... & w.. '6,2'0 16,210
5_ _P.,
5_~ 'OUI. K.1tO 2UOO 19.120 uoo 'U50 229.15.
,_ ~lIIM
5'11100 $idl:L..
5_ ~_"-
5122GO ....... T_
5'12)00 F~'"
512100 -. "-
512SOO My,-,
512700 -.,....
5:20100 LJo... S2500 EoloII ,... '70 2110 120 10 10 10 1.130
t2020G I"........a~ T.tlIO 3.110 .- 700 2.610 no 17.010
S2IlJOO _..._ 10 10 SOO 110
- ......-....... M.IOO 'IOAO 13._ 57.110 ".000 51.200 711.110
fa&GO SeciII SecIIiIl. r.pllj" 19.'50 12.710 '.m T2IIO .6.920 0.270 11.600
531700 r., __ 22UJO 1JJ.1OI IJ.Ta IT.3fO 2UlO 31.250 526.<30
---- 13..11. 21U8O 8.710 11,110 3910 3.110 313.150
&""~~S ,",:I 7<0 ~:I
S 2.- ....- - - lfU48 I
_T..o'~
531100 __ S 1),100 '.700 7.170 5.000 S ].U70
5JOJOlI~~"'" 25.100 UI. 100 2U50
531100 1Iw1"wcMN....... '.100 1,100
_ e.c....a.gn T.... 19.2IIt 12.920 40.010
~ 0... w_ &......... UbI 9._ 15.&10 13.270 311.510
W250lI "- .30 50 '10
S42IIIO_~_~ 2610 2.110
5<2100 ___~ 38<.000 192._ 11.- 11.000 129 ,000 2UJO HUJO
smoo ......... 4.IIiO lIOO 5.1SO
SQZOO~-~ 10 10
- 0..'" 2.311.000 2.0".500 llS6.160 5:ml.1lO
_r_ 8.000 9.000
54<'00 ~_ 15,000 100 100 J.100 1.750 20.&30
5<6100 ~ 18.010 ".730 1'.1SO 6.220 1060 1.360 147,010
500.00 o.c.l!4tOPs.: lllopW J50 J50
_ ~E.... s.:.1lopW .... 9.J60 3.950 '.!500 15,2'0
- Gonto~IlopW-" 13,000 6.000 6_ 25.000
M71tol.lllilDtMl~... t,lI3O 5.25G Hit '110 550 1.050 It.!JlI
5moo T_~ ..* 81D 618 10 5.730 2JO U10
smoo __ 200 TO - 50 5800 &,510
5mGO __ 9JO 190 2IlO 100 'GO 10 1.600
_ ~_o.~
_ 0lIc0__ 1.010 lI30 120 000 6.100
- Opooao;og SoI>Pioo . - 30.1100 JO.lTO 16."" 33710 5.630 12.600 133.150
552S8Q S7S0. ~.... & EM 6000 1.000
557.00 _Emo 1.670 1.1201 ... ..... JOO '.810
R~ 4TO 2tO 120 10 00 10 1.140
2.;1 2.-.. 151.1 110 ..4:1 ......1 1"';:1
I ,)f.,. I
_1IlMCI CIIAIlGES
-Gonto- 1 2.010.510 I56.CO 46Il.... 90.5lG 3.060 112,000 I 3.471.460
5lG2OO1loc..........._s.: '.MCI ... .. 2tO 2210 '00 5.140
iWG3OOT__V_ 2.700 900 '.060 900 ZUIO 30.000
-~- 1.130 1.130
5<GSOO _~...., "210 6.'30 3.* 3.2l;O 1.000 JOO 2U3O
_r_s.:_ 1200 J20 13.420 15.030
--- 310 310
_RioIr....._ U30 f.OlO 2A01l 1.880 1.5ro UTO 23.4.0
54.000 ~ T........ CIIoogo '26.HO 126.HO
1"200__ 3,700 3,TDO
5411GOIlIOg._...., 15.t60 ".260 57,220
54'!IOOGontoV_ 27.seo uoo IT .800 _ 4.000 79.MO
54_IlIOg'__V_ MCI 2SO 870 1.600
5611UO RIdio Sle-V....... 1.100 1.46. 3.010
54'OOO_~ :1'1.100 ..uoo ....Ito
RfLIfIIIi CIIAIlGEI I 2Am ..HI .J:I ':;1 ~~ ~ S ..a
~0U1U'
_nADittf I I
llE81' SBMCE' _IT EIlPfJUES 111
511200 "-.",, 1 2<1210 ro,JII 2IlO.J54 1 ITT.OOO
571300 _..-~ 29." 37.122 91.7. 117,611
572210 ...... c.er 25.000 12.500 '6.0<1 12.141
.rr.-rwr- I 271'- .~ ~:I .... J:W S 8
--
__T_ S m.ooo 216.000 tHIII nooo 47.000 '.130 S 100,1)0
_1.,~~s I MIl . i. n... .... a.1 I l.iII.1
OTIEIl_SU
8lt.... S I
TOTALO&.~S I . Aft ... UII'.IO 1........ - 1~ t.JIUN 1t.IlI.m
/11.....-- . . ~r 'Mil . . _.........___..l'_...ao.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
City of Clearwter
Final Report
42
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
>- ~ ~
~ < ~
~ ~
~ ~
r.I1 ~ ~
~ t ~
~ -< ~
~ =
~
~ ~
r.I1 u
~ ~
Q Q
~ ~
~ ~
o
r.I1
~ ."""".
!
~
~
!
~
~
!
!
!
!
..............................
..............................
..............................
'18 ' , , . , ., a$
r(~ ~~
.............................. ......
~88~~ ' , . , ,
t~~~~
NY"N
......."...."...............
118~~ . , , , .
:ill{~~.
.............................. IItIlt
111~~8 . . , ,
~~~~~~
......IIt.....................
~!ili~ ' . . , .
~ll{j!{a~
..............................
;~I~fj , . '88
NNon.,;~' f"ion
"""'Y" ,...,...
Y" Y" Y"
..............................
glll~ . , . 8 '
g:a!~~ :t
..............................
S!o..,~!lt'Si!.C").
;n3::i"l~ ;,; ~
~oD.,;f"i.,; on
Y"~::~
..............................
~:a ~,~
~! a Y" a
... ... ." ...
Sf;! ~,~
S~ ! Y" !
... ...... ...
!~ ! ~ ,
~~ Ii _
... ... ... ...
.,.
I Y" I
... ...
~ ~
~.;:::
. f:S l;:
t Q
~ ~
~ ~
~t;q
~.~
=~
.s~
a...
:::
~
! ~ !
!Y"!
... ...... ...
.,.
E Y" S
... ...
. # I
ii1It 8 .
... Y" ...
~ ~
... lit ... ...
! , I!
.;~.;
~ ~
lit lit ... ...
.....
"'"
~, ~
" Y" rJ
lit ... ... ...
! , !
iY"i
... lit'" ...
~,~
o Y" .
... ...
... ...
... lit... ...
:::!
~ 9:9:
~ 00
i ~~
~ tt 1
Ii ~f 66 !5
II~U ~ i
-II il~ n ~ ~
I~JIJlJI~ Ii } ~
11 Ij J ~ ~ 1
1<<<<. ))~ ~l!~ !J ~ J e
nd U j Jl J ~ I
a...
~
f
~ ~
o~
IU
~Q::
o~
.... .S
U~
-........~... .. a a .
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~ ~ 15
~ < ffi
~ >
~ ~ ~
~ ~ ~
-( ~
= ~
~ Q
~ ~
~ i
~
~ ~
o ~
rJ'J. 0
Eo- 4
~
U
~ .
o
~
I
\D
~
~
U
~
II !;;.lsl
~ ! u;a~
.,.,,"'" .....
!
~
!
!
!
!
!
!
!
!
iI.~li In II
. ';EI E~ lU
N N lli !;IN
""'...,.. ..... ....
~.~~~ i:ii ~:l!
~ ';~I In s:fi
N N S::SP
.. ..
~...
",1II
I!! it
~,.:
N
.. ..
~I..!. .~,,:!~\f!
~a ~ ~~; ~:;..
~ ~..... VI'"
!l.ll!;;
!Ii u;ii
en oa g
.. ..
i.ll!l ~.l~. g.~ls
~ u;~l ~ ~ ~ ~~~
m ~ g N N
..... -....."'" ---..
~.'~i
lli u;ll!":
: ~~
..... MW
f.lll!!
~ u;~~
fIi ..
.,. WI .. tit
I. Ulf
S "'_~
r',: ,.;
~.li:~
~ ~R~
vi ,..:
...... .......
5i.l
~ ~
,,;
.. ..
a.1
~ "'!i
ai ai
.. ..
9i.~!!!g
~ .;s~
l"i <".i
...- ...
in !8~
;a i~
~ N
.... ... tit
~.'5i! ~!!l 55
i ';:iI~ i!'!~ ~!
N N l;i Iii
lilt.,...... .... ....
l!I.'!~ ~~ ;~
I ~lIIi ~~ lli~
,.: N g S!
..... ""tilt
~.'i!!!! il! ~:;
I ';lfll !~ ~~
_..: ..:
... ..
.... WI"
~
..... ...-
~.,~~ ii! ~lil
~ ~lll~ ~~ ~~
.. ..
_.. -lit
...... ......
~18 mj
~! ~!1
~ t:
.. .. ..
~.l"'~ ~.l"'~ i.l"'i
~ ~ ~ ~ ~ . ~ ~ ~
w ~ ~ .:.:
..... .... .,... ....
~i ~;;;
i~ ~!
~ ~
.. .. .. tilt
~.,"'~ ~.,'" i.''''i ~~ ~ij
~ 0 ~ ~ 0 ~ 0 ~ ~! a~
v> _ ~ :: ~ ~~
...... ..... .-
H ! H
sl J'1
IJ 11 IJ 1 J I
6i 't lS t I
lilJJ~ 1111 JJlfi
S11i. l1i., isiJ!
i)111 III Iii!!
jJ ! 1 J !
...
~~.i.
~~ ;:
...........
11....1111........ D'" .11.
f'.l ~
~ .~
.~ ~
2 S
~~
~.o
=:~
s~
~
:=
~
"':t-
"':t-
~
~
f
~ ~
O~
ll.l
~tc:
o~
.... .~
U~
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~ ~ rJj
Q < 6
=' ~ ti
E-< ~ ~
~ ~ <
~ ~ u
~ ~ I
-< < :;
= 8
~ a
~ rJj
~
-<
~
Q
~
~
o
~
~ ~~~
888
000
"~
..nwi..
! !!! ~~!
! #~~
888
000
"~
.nu-l..t
~ !!! ~~~
~ "'."''''
888
000
"~
..-ivi...
9 !!! !~~
! !!! ~~~
! !!! !!~
"~
....~
~~~
! ~~~ ~~u
Jl)
JJ~
III
J IUS
IIJ j~]ll
~ll . i
Iji JJJ
i!Ul!!
i~!i~
~;:~~;(
.. iWt.....
5ii!~5i
.IU~
";~Nfj
....-...'"
a~l!!;
"'0"'_
lili!;~
4ft~ ~
.,.... .....
_ID N.....
lR::;~l:s
1il~~!
eON":
_ N
"'......tIIt
~!l~!i.l
.nN~"':
f.1111_1Il
......N~
...... WIt..
~a~a
'Ii....".,,1.l'i
;:~!:Q
cOfftN=
1IIt1lllt......
~i!l!il
E~~~
...:.,;-~
........ ..
rH~~i
~~l~
....:.;-~
""......-
~E=~
~~Ei~
..:....:-~
tilt.. .,. ...
~!H!~
ii;~
.o"":""'!i
...... .....
~U!~
ii;~
vi"':_~
...... ...
III)
ji!!
aJ..
jjsl
JJ I
SS]J
IJ'
. ~!
IJ
.....
8in .8!!!~ .81
~~ ..~..: 1!5
........................
~~~.8~~.~:;;
g~ aD~_.~!i
......................
8~$.8~~.8;
~~ ..~_. ~~
.......................
U!~ . 8Ei~ . ~a
gs co'~~ 1!5
...w....""....w..""
8~$.8~~.8~
~i cD~"-: ~~
.......................""
8i~.8g~.8a
gs cDl~ ~~
..""...............w
8~~.82~.8!i!
~i ..~,.: I!~
....................""
8;~.8~~.8i
~~ tOe"::!~
..................""...
~~~ . ~ll~ . 8.~
~~ '"'t!!- I!l!!
..............._Wlllt
88~.8~i1l.8*i
c:illi cD';":';":
......... .... ....G'I
... - '"
..w..........""""....
~-8$...... .....,
,..,~..-&':~, .gg
~~ ~:i~ :e~
......,................
it
O~t .~ j
'1~J.IJiJ~j
~~ij If' !
Hmdl~t
'"
. . . . . . . II ~ A II
.i.~~ =
~ ~~ ~
III
...""".....,. ...
ri'.l ~
~ .~
.~ ~
~ ~
~~
~.~
=:~
-S"-J
...
==
~
.~.~~ !
g g Ii
N ... ~
~
....."'."w ..
III _0 lit
. .... . :s l:1. l"l.
~ ~~ ~
::l
....... ...tIIt.,. ..
.~.l.:!g: l
~ ~a !
I:f
..........iIIIt ..
.!i!.~~ l
~ ~ffi r{
;r:;
.... IIA lilt tit.. ...
,~.~8 l
~ ~~ !
:(
..........'" ..
.~ .tUi .
!:I 1i;iS l j
= ...
M
...
.....,..,,"'" ..
,~,iU J:t f
~ ~~ . '"
= ~
t
........,."'" .. 'I
,~'O.... ~ l
Ii! ~:;; ! t
:ili
..vt4&'tw", .. i
.~.ilS r! I
it ~~ S 2
N"; ti !
...........IIIS .. I:
-p.........~ ,. I
.::?::!~lll l"l.
~~!!g ~
,.:,.: = '15
...~......... ... I
I
1
I
J
...
11
'15 Jj
J (
I -~ ~
il) i
jglj ..
ilJ. if J I
II ~I 1 i
... ...
"11111;11. II
'"
~
...
~
f
~ ~
~~
~
~~
o~
.... .~
U~
I
I SOLID WASTE RATE STUDY
I APPENDIX A.4
SCHEDULE 8 - CASH OUTFLOWS
I ~ ELlIIl ~ ~ fLlIII fUII1 flJIU fUm fUIH ElJlW EUIIi
t rw.. s...w- c_
I ~ LP .."..... I It... I ..... I ....:11I I 13<311 I ".300 I 7,670 I I I I I
. tnltmar Loen paymera. I .1'.m s IU.'- I I I I I I I I I
I . T~~"-=--' I al .Hi I ..11 HI HI 1111 ~:::l1 HI ~:II I 1.1: I 1::11
. . n&II ~ 11.,
, eatI2 . .. CeIectIoft .............
'uI r.... UIrin & W... 1,251,112 I 1.6.'- I 0.... I 1.7".757 I 1.1'0&17 1.""','169 1.890.736 I 2.070.366 S 2,153.180 I 2~3U01 I 2.321._
PatTIl'NISItaries&WIglS 3.. I S I I I I I S
_P." '5.~ I I I I I I I I
I <MoIime 4117 I 106._ I 110.601 I 115.G2t I 119,629 12',.n4 129.391 I ,3UST I 139.919 I 'US.Sf7 I 151.369
V~l... t3.1U I I S I I I I I
_L.- SU" I I I I I I I I
CIdw Paid l.. SIlO 5 5 5 5 5 5 5 I
InjwyTImll 5 5 I I I I I I
FURIr8IT.... U88 I S I I I I I I
MiMaty&.u... ,st, I S I I I I I I
"""- .. I I I I I I I I
I HoIidayTItI'le 152. ... I I S I 5 I I 5
LM 1M S2500 ~ & P~8 - I m I - I 001 I ... 532 ... I 51< I 581 I 598 I ...
"'LiIIl~ 6.171 I 1_ I 1.... I ..1A I .. I '.662 8.911 I 9.171 I Us.. I UJI I "'.0
SIml> lfo_ . I . 5 13 5 .. 5 .. I 102 '05 5 ,.. 5 .11 I 115 5 ,,,
..... _Ine-Emo ..021 I ..- 5 311M I 331m I :J58.2Sf I 3T9 .153 402,531 I .126.691 I m.m I 479..&30 I 588. ...
_s.cwey.e_ '1M 5 'USO 5 ..01 I 20.7J5 I 213S1 S 21.991 22.651 I 23.337 5 24.037 I 2.'.158 I 25.50'
Emp Pension PIIII'l 1&.115 I 22li.531 I 2It.Sf I 316161 I m.a:35 I 407,717 '*24,025 I 440._ I "5a,m I .&711,911 I ....BSO
w..kmInl Compenution 18._ I nl1l s 1I.!iIIS I 17,132 I 80.167 I 82.572 85.0<9 I 17.60' I 10.229 I 92.936 I ".12<
I -- ..- 5 u. 5 ..... 5 ...... I ".933 I 15.JI' 15.843 I 16.318 I 16.807 I 17,312 I 11,8)1
Other ConttKtllll s.rv I 25._ I 2S.115 S 21U5t I 21051 I 28.27. 29.123 I 29.... I 30.196 I 31,823 I 32.111
Garage SeMen 1711....' S 2..'" S 2.32,_ S 2.n6..5d S 2 262 549 I 2 330.425 2,400,338 I 2.472.348 I 2,54&.519 I 2.622.914 S 2,701.602
Doc~&PrinlStlopk - ..... I 161$ I tl63 I 1.713 I "1$l 1.e17 I U12 I U28 I U" I 2....
Telephone SaMe. Variable 2."" 2.188 I 2,795 S 2.m I 2955 I 3.(16.0 3.145 I 3.240 I 3.331 I 3,.437 I HOO
RIdioSvc-Filced 12:,. 14,291 $ ...... I ".230 I 1569' I 16.162 16.646 I 17.146 I 17.660 I 18,190 S 11.13&
Teiephone S\c FIXed S I I I I I I I
Postal SeMce 5 5 I I 5 I I 5
I ....-- U.. UJI I '10,174 I 10419 I 10,7$4 I 11.117 I 11.451 I 11,795 I 12,148 I 12.513 I 12._
""'T_C_ S I I I I I I I I
Geloge v_ 1,11151 21.. I 31.. S "'.31< I 30196 I 31.102 I 32,036 I 32.996 I D.1llI6 I 35.... 5 '0855
Bldg & ......V.- ... I .. I st7 I 615 I 633 I 652 I 6T2 I .92 I 113 I 1U
-CNove 242.... ....- S 251.. I 26S.Zl3 I m,1O I 281.386 I 289,828 I 298.522 I 307.478 I 316.7Cl2 S 326.203
e..--- 5.m uso I 1113 I 1.409 I 1,631 I 1.810 I 8.096 I 8.339 I '.589 I e,ln I '.112
p- I I I I I I I I
I InIIffmd Olher .s.r.a c..... 5 I I I I I I I
..............-........ JI...eo "".- I 3tT.... I <08.363 I 421.... I .,..293 I "7.322 I 460,142 I 4706,5&4 488,801 5 503.005
- 3,32' .... 5 5.123 I 5m I 5.eJ5 I '.598 I 5.166 S 5,939 I 6.117 6.301 S .....
Dump ,.. 2.299.315 2..... S 2....995 I 2..538,_ S 2,614.413 , 2.692,&.15 , 2.713.631 I 2,856,atO , 2.942,st5 3.030,821 S 3,121,7a
-. 71..... r.... I ..112 I 13.21C I 85.112 I ..~ I 80.932 I 9J.1SO I t6,470 ".36& I 102.:M5
Geloge--- UI2 IS.. 5 19&55 5 1915!1 I 14,274 I 14103 I IS,"'" I 15,598 I 16,066 16.SA8 I 17.....
- 1.188 UJI I u. I 9.6. I 1t15 I 10.213 I 10.519 I 10,135 I 11,160 11.4" I 11,09
T_~ 1.924 .. I 1.511 I l,SS6 I '.603 I 1.661 I 1,101 I 1.152 I 1.B04 U58 5 1.914
I -- .. ... 5 2111 I 2U S 220 I 22Ii I 2J3 I 2.0 I 241 25' I 262
--... ,.... !lJI S 963 I t!I, I 1,021 I UI52 I 1.083 I 1,116 I 1:1ot9 1.1" I 1.219
"""'-"'........ I I I I I I I I
Oke_ 1.812 1.850 I 1.0.1 I 1,119 I 1.153 I 1.188 I 1,223 I '.260 I 1.298 U31 I 1.m
~_&..... D.'" 3&.'- S 36 122 5 37,205 I 38,321 I 39.411 5 40.655 I .11,875 I 43.131 ".&2> S .t5.158
~..., tll3 ,lIl8 I 1121 I UIO I ..... I 1.... I 1,945 I 2,004 I 2.... 2,126 I 2....
Okl~ '18 m I .- I 001 I ... I 532 I ... I 51< I '81 59B I ...
Training & fW EmpklyM 105 U88 I ,1JO I un I 1.208 I .."" I 1,281 S 1.320 I 1,359 1.... I 1&.2
I f)me.TIlfTo Sku'1oIld I 5 I S I I I I
Inl.TsfTo $kg Fund 5 5 S I I 5 I I
G2OI3" $w C......" C......a.I
F.rINSIlIIritt& W.. .,n, 9n_ 1011," 1.051963 1.ON.OJI 5 1137.793 5 1,183.304 I 1,230.637 1,279.882 1.33U57 5 1 JU,219
p.., Tme UIrin & w..".. :lAm IUM '1.150 17.m 18.234 I 18.963 I 19,722 I 20.511 21,331 22.115 I 23.172
_P." 1U35 I I I I
"'""'"'" 16,751 .... so."" 60.715 63206 I 65.734 I 58.,", I 71JJ9' 13.942 16,9lIlI I 79,916
I VIC....l... 4", I I I I
_L.- 2.2.321 I I I I
Other PllidluYt 2.1~ I I I I
"'iuYTIlM I I S I
~ F....r.,.. 2.&36 I I I I
" _l..- I I I I
" """- .... I I I I
" HoIidIyTme r.995 I I I I
I .. UII kll S2500 E.... & Ptna n5 "" - 309 318 I 32B I 3J8 S '" 35B 369 S ...
" '''LA~ 2012 u. 3." 3.1... 3,931 I ..... I 4,170 I '.295 ..... 4.551 I .....
.. SIml> LIt_ S1 Ie S2 .. 56 I 58 I 10 I 12 1& l' I 19
" --- - -- 191._ 202.m 214 9S6 I 227.852 I 241,523 I 256.014 211.375 287,658 I JIM,9t7
- _v-EmoIoYee 11,.1. 12.... 'U. 13.635 .. ... I ...... I ".899 I 15.", 15,106 16.211 I 11.70
Emp Penaion PIIn -. 133.9BB 173.. 22lilll52 235.... I "".... I 254.278 I 264.....9 275.027 286.028 I 217._
WorlaMna~iDn 12"'. 212._ 219.... 22"'29 233 2Z1 I m.lI9 I 247,425 S 25..,,, 262,193 210.368 I 211,47J
I Pnnnion.II SwCes ... '.188 ...56 5.010 5,161 I 5,3ffi I 5,475 I 5,6)9 5.... 5.913 I '.162
""'" Coomctuol s... I 5 I I
""'- u. ,1JO 1.173 t208 I '.2&& I 1.281 I '.320 1,359 1.... I 1&&2
GenIgt SerWces -- IS"'," 119... &0"''" 720,125 I 7"2."9 I 76.t,723 I 711.665 811.295 135.033 5 ....102
""'Repo&""'-"'" ... ... &55 .... .., I .. I 513 I 528 5&& S60 I m
TeIIptlone StMce v.... '", .- 992 9st 9BB I 1.018 I ..... I 1.010 1,112 1.... I Uao
Radio~.fcuct 5.... """ '.:1&5 .535 .n. I U" I 7.1041 5 7,355 I 7,576 1.11I3 5 UJ7
TtWphonI SIc Fo.d I I I I I
I POIUI SeMe. I I I I I
....loIgmI- 1111 .... <212 .... .... I U,. I 7.059 I 7,271 I 1.&89 7.714 I 7.945
""'T_....... I I I I I
Geloge V_ 1._ ...- 10 241 10..... 10811 S l1.lt7 I 11.533 5 11,819 I 12.235 12,602 I 12."
Bldg 1 ......V_ 2Sf 2SO 211 215 I 283 I 291 I 300 I 309 3" I 92B
-CNove "1.7'10 ".9BB 111,_ 176,'" 'B2152 I 117.511 I 19J~ I 199,043 I 205.0'" 211.165 I 217.500
~_..... ,.. '.218 .... ,un 4,711 I ..,52 I 4,991 I 5,W7 I 5.:J02 U61 I 5.625
EJec-W c:..".s '.211 1.... .218 .... 1711 I .... I 9.249 I 9.521 I 9,813 10,107 I 10.410
I P- S I S I I
........0Ihe<_........ I I I I I
InIt1tnd Admin SeMce Chlrpa 1I2..OBO ..- M 121 .....12 210,122 I 211,147 I 223.661 5 230.311 I 231182 m,~1 I 251,rn
-- - . 932 ... ... I Ut18 I ..... I 1,080 I 1,112 1.... I uao
0Iher PromoIion AdMIy T1 Ie S2 .. " I sa I 10 I n I 1& 16 I 19
Dump F.. 10m 155 2041,_ 21t2!5J 2176 )11 2241631 I 2301._ I 2318."1 S 2,449,491 I 2.522.91' 2591.655 S 2.61'.625
I City of Clearwter 46 Burton & Associates
Final Report Utility Economics
I
- ..--------
I
I SOLID WASTE RATE STUDY
I APPENDIX A.4
SCHEDULE 8 - CASH OUTFLOWS
I lUll ~ E1JIB lUll EUIII EI..III1 EI.lIU ELIt.U EUIII ELIt.U EUIII
.. ...... - .,.. .,W . 0"10 . .... . ..... ..... . ..,. " -... . 1111tJ t1IN 1 111r81
.. a....&PIIN..a..: . 211. .. . . ... .... m. .... ... ... . ...
.. --- It! .. . tJZ . .. . .. t.01I 1 1,_ I 1._ " "Q '..1 UIIII
.. --- ,.... ,... . Ufo . ',.urS . ,lOt ,.., I ,,,. $ J.N' .1IIlt ~.1st 1 ur.
I .. -"'- ,.. ,.. m . ,., . '"~ Xl. ", . ... '" .., . ""
.. -- . $ . $ $ . $
.. --- tlM ,.. . ,... . ,.. . ,... ,... . ,.. . UII . ,m "., . ,.
.. ..._0.,. I I . I . I I
.. -.- III ... . .. I t17 S ... ml , oea I , l>> I , .., u. I 'IJI
.. .....-- I I . I I . $
.. ....ac'~ I I . I I I I
.. -0.,. I I . I . . $
I - --- ,. ,m I u" . ". " .. ,... . ,,.. . ... . , ... 1113 . "..
.. ....u.o -... I . . I . . .
- 0.......,........."" ...., ,.... I M,*' 'M... " 11.m 1UtS, I ".410 I II... . liP< .,.14> . "'"
.. - I . . I I I I
- _ ClIlw............ I . . I I I I
- ----... .... ... I ..:n. I ft.. S '''" ..... I II.. I 11.'. I II. IUts I 10.'"
.. - I I I I I I I
>II 00...__ I I I I . S I
I ... -'" I I I S I . .
... T_ I . . . . . .
'" -- - . .. I '" . '" U) I "0 . "" . ... ,,, . U1
.. - ... .... . ... . .... . ... 'Ill . ,. . ,... I ,., "" I ....
.. ....,E..lhcJ__ 121> >.1M I ... I '.21' . .", ."," I &II' . ~.7JI I ... .... I '.H'
... ......--- . I . . . I .
... u....~ Ut5 ,.. I ". I UK I un 1.'" , ,.t12 I ",.. I "" ',&01 I z.."
.. -- . . 12 . .. I 10 .. I II I n I 14 II . ,.
I - -- II I 52 I U I 51 " I 51 I 10 I 12 .. I II
>II -- .. - I .. I 1111 '.. 11J S ,.. . IJI I .... U' . '"
.. oo..._Qr~ I . . I I . . I
... .... - . I I I I S I I
.. --.- ..m )).N . ~.- , lU31 " "hi _us, 191)15_ , .."7 I .,CliO , ...,. . .. ..,
.. 1711 ~""'&I.-. 1..71 .. . .m I .. . ... ... I .. . ,.. I 1t. I ,.. . ""
... _be . . . . . . I I
pO -......-- .. .. I f) I .. . .. '" I .... _I tt1 . ,.. I ,,.
... '-....- II. I ,.. . '" . ,,, ... I 121 . '12 . .. . ... I ...
I - _TtI..... .... I I I I . I I I
.. ..TIlT. SIll"" I I I . I . I I
..
.. __ ' 5w...........
... ...--.- 116.111 M,. f.... 1M S U,. I ... WI , ... .., ... ... S 5&411I, go 72t ,",S117 ii' $16
PM rIM 9I6MM & w.. I I I I I
-... $.Oil . . I . .
........ J,I'I' ... '.. , ... . ..., . .... 'n. . ...' . .ta I.'" , ...
I -'- 2UT' I . I . I
... '- ""'4 . , , , I
00...___ '"' I I I , I
-- I I I I I
-- I I I I I
........ I I , I ,
....,- I . I . .
_r_ am , s I I ,
I LIt ... szseo EMP & p..., ,. 10 P I .. I .. I . I) , II I .. ... ...
w..ua.~ . J~ '.... ,. ''', . '''' . , ... , 'P' ),n . .."" , , ", un "..
-..- ,. ... ... , '" . ... . .n ..., .... 117 ., ..
--- _.1., ..- 51.. . "." . "... . .. ... II no . ... I nul. ..... 11010
--- 13.M ...- 17.iO , .... I ".~" . ",'. ,,,,.. S :It.lI' , "'" 21.S-. 22.'"
- e.,,__ 21.. II.. 1f,1)& , .1,l'" , ..1t6 , ..... ","2 . lfl.IM I ...'" 1'fO.4JI ,......,
. -- .. 1l1S .Mt I .m I '.'" I ....1t 1..1t) S '.n' I ..... 0.110' '11'
- -- 1.112 ,. ,.1 ,. . 'U , a' IItI 11I1 ... 112 'N
I - -- ..,.. .- I US I .... . I.. I .... UB I .... I .... .... . ...
- ...~- .. - ... I t01 . ,. . ttI ,.. . 121 I ,.. '21 tl1
.. ...- I I I I I I
... -- Ual ,.. . ...., 110 . I. . ),'" "" I U72 .. ".. I 'OK U'~
... 0.._.__.. .,. UII I ,.11 ~.'" , t." I '.... 'III . J.'" . Ulll . ,... ,....
... --- zun JI..I 'UII a.. , __ 1 ". 21St1 I lI.lIt 1 >OlO:l I "..1 ,....
.. -- ,... '.. 1.911- U.. . '.)11 . U" "tI I UN . U., I u. "..
... -- ,. .... ,.... t.., t,'" , .m 1211 . 1." , "" . US, 1.'"
I ... -"'- ...... "GO '.... 14,_ , ....nt .. 1".'" ".oJ , ",m , ...... , 17,'" 11,m
.. -..... JI! III Jt' "' I "'. '" "' I "'1 '" I "' '"
.. """_- Uti UII '.IZS 1.114 I '.131 I ,", '.'" I I." I u. I u. ,.1)54
- .T_o.,. QU. 131.1. 1)1.1" 05.. I ,,..m I ..,.JOt uH" , ,St.tT) , '56m I M1.2:zt 'fCJ*
.. ....- C.I:II ..... CIII .". I ..... I ..... .. 011 I e.. S ..... . 52,g, .....
- ~- .... UII 30"" UD 1 .... ..,It I ,UlI I un . ,Hit ",.aS1
- -- I I I I I
- ....- ,... III .. ... I III I .. UI' . ,... I .m . ,.., ""
I - ...k.v..... . I I I I
- -0.,. I I I . .
.. ~~.f'... .. .... .... , II> . ,.... . 1251 "I> I "" . un . 111) "SO
- ........ -... M.'U ~- ,un u.ml ..lIT . \U1l ...., . lUG' "."7 . ..... .....
- 0., W_&Sllil-.UIlI ",037 lUN uno "'" I ..'" I ,... ,.... I 1I.1tJ I ..... . .... "...
- - .. III us 'II I I&J I '" "' I 'II I .., , '" 'N
.. _ClIlws-c.~ Uti ... 17" '117 I au , ,... . ,m I u.. . uu I )411 ]SIC
... ...........~~ "'.211 ..... .1J;IU u:r.Ut , ..u.... I ..... . t~m .. ...... . ...... . ....." "'113
I ... - I I , . I I
~ ---- I I . I . .
- -'" . . . I I I
- T_ . , , I .
... -- ,.... ,.. u.' I.. UIt I .. . H.. tl" I Ulll . .... ....
.. - ,. .- .., ,.. 'III I .... 1 "31 , 2" . "'" , ". ....
.. ....-.....- II ... .. '" .. . "'" .. '" I AD . &II ...
.. ___a.:._ , 1 I I
---- . I I .
I ..........[..~ III III .. .. .. . 1>21 II' .. I .. , ... m
.. --- ..... uw ,.." ..- 'J11 , .... , .... 15.1'" . '.101 I ,~ r.,tJ
M -- ,.. .... .., .... .... I I.. . .... US, I ,.... . '.lI> '..
. -- .. .. .. .., nt . 11) .. '" 1211 '.. . ,., '"
. ---"'- , I I .
.. .... - 'M' ... ..., ..... &.122 . C,IQ Ii .... ~ 1U S UN I U,.. $.I.
. --.- ..$tO ... >.IZ' ... ..lfl . "Jlif I ,... ,~ . ..51 I 1,1I7 'Ill
- 11!1.__,_ I I I I
I .. I p ~e., ,.... '." IN '."' 1m I .m I ,''' 1,_ S ula I tn, 2,171
.. -....-- It . " " It . 1ft I tf!l "" 111 . It! lit
.. -....- HZ! .... U1l ... . '" I ... 1 om '10 I I". I .... ....
.. NiII:.TlfT.",. . 1 I .
.. ....1"'...'... I I . .
..
I City of Clearwter 48 Burton & Associates
Final Report Utility Economics
I
-- ---
I
I SOLID WASTE RATE STUDY
I APPENDIX A.4
SCHEDULE 8 - CASH OUTFLOWS
I lUll! 0.- lUll! EUIII EUIII I:UIU D:lIII I:UIU 0.-. EUIII EUIII
__ - -...-..c.c...-..
hi '-...... &... ...., . 21UlI , ....... .... . 31U. . JI"!) . m... . ..... . ..... . J1U1l .......
,..,.. ~ &.... . . . . . . . . .
-.... ... I I . . I . . . I
I - ...., . ..... . 11_S ...m . ..... . ".... . ..W. 21~' . 22.... . 2'J1,' 1,..12S
-... .... . . . . I I . I I
-... .... . I I . . I . I I
0lIliIr~"'L-. no. . . . I . . . I
-- I . . I I I I I I
IF.... r... .., . I I . I I . I .
~'-- 4.UO I . . . I . . I .
....- tit , I . . I I I I I
I -'- D.1M S . . I . . . I I
U...l2lJllliIIIlfIl..... .. I . . II . .. . . I . . OJ . .. . It . ,.. 'Ol
"'&,ailfll_ U~J~" .... .... ... . .... .. . m tOO . ... . '" I ,. ".
-...- I . I I I I I I
--- .. ... . "'- I ..m. 51,_ t .... I ...... In1' I "'... I '.... . "._ ".M1
.. s.:.iI5ee"'~.~" .m. ..... I utt , A.W' ..- . .... .."" I . '" . UfT I .." BW
.. E...~~ .,,, $. .... I _,_ S iUN S .... . ..... ". , 14..' . 71,,,", , ...... ."..
- -- R_ . J..' f.. , ..U. 1.11'1 I .. 'U1 . . "' I 4,.r $ .... ...
- -- I . I . . . . .
I ... -- I I . I I I I I
- --......- - . I I I . . I I
- ..- . . . . . . I .
.. -- 'MB' tW.. I ".ra , .... s ....w I 117,1f7 m.., 13D,V. I Dr. , ... .., ,...t 7)]
- Iloe_&__"", I . I ... "'. '. . '" ,. 120' W I 117 11I
.. '......!IeNee v..-. . . I . I .
... -- I I I I I I
... -...- . .. I ,.. .. ... I UO ... ..I '71 . JI:! '"
I .. '...... k'..., . I . . . .
.. - ...... I I . I
.. --- I ,lilt '.121 ,,. . ,.,. I ,. ,... 21" ,... . ".. "11
.. ... '....... o.tt . . . I
... ....- . . I I
.. -- ., . .... ..... .... . '.JI:! I .... .... .... ,1.1&3 .. .... ....
- ... &......v..- . . . I
.. -",.- . ,... un '.... I , II> . "" "" '7U ,.. I ,.. ,...
I .. -c.p . . I .
.. --- . ,. un ,a . '.... . '''' , JI, ,... ,... I , ... ,..,
- _a..o- . . . .
.. .. w.. &.......... . . I .
.. - , I .. .. .. . 56 . " .. .. Il . .. ..
.. _o.._a..o- . . . .
...... AIInI ..... c...p. . .UII "... ..... . 'U" . 'U.. "... ,,,.. "1M I .. "' "",
- I . I . I
0..__ . . . . .
I -,.. tit ,., . ... .. ... ... ....'" . IM._ , ..-.. . l1fta , ,..... I "111)1 . 1116.. IN..
,- . . . . . I
-- . "10 un ,. . UII . un. ua .. . .,., . .1lI U..
- . ,.. ,... ,.... . 1103 . 'Ill I ,.. ,~ I ... . ",. ".,
....-....- . . . . . .
--",.- .... ,.. ,.., ,.... . u., . 'M . ,.., ,... . ,.. . '101 ,....
---- . . . I I .
~E.~. ,." . ..... 1..' 1.'" S 1.1~ . ... I ,m ,.... . ,.. . 1.331 UTI
I ...- T:lI. III III ... . .., . ... - m. .. . m ...
-- . . I . I .
-- . .. .. .. . . . .. . " .. . " . '.. ...
'" aa. s... Or ~ . I . . . .
.. ....- . . . . . .
.. --.- u)IO . ..... .un u.ar s llUS . ...... I ..... ",.. . 'H1I' . 1U" .....
.. UJI._IiIIcIl&!.,. . . . . . .
.. . . i \.c Eooo ... .. In .. ... . UOI ... ... >>, . .. ,.,
I .. -- .. . .. II . .. . . . .. . " .. . " . '.. ...
.. '........,~ ... . .. . 171 . '.. . II' . .. "'. 'II . ... ".
.. ""-c.y.n...,... . . . . I I .
- ....r... '0" F..- . . . . . . .
.. T"'~~ . tI,IiD,8I I V...,. ,u....... ......... . ....,. I....... I"':u::a Ilt,.JD.N I >>....., I n...... I~
..
..-
I .. --- ... , "".. . ...... I ,olm s M'."" ... ... ... ." ..... . u:t ."7 . 551fj7!i . .......
.. ~"""'I"", ... I -- . N.'"' . _.~, #1,_ am .... JII,ftiI I ".M' .'m 1 "2',"
.. .,.,............,...... .. ... . 13._ . ..tv S ...... . ...... ...... ,.. ... '2I,oIU S ... . ':SUfi I 1..1U
.. IIWc.&aMr~. ......T...... n,. . n... I ..m. II. . ....n ... .... W.'"', . .,12t . to:).~ s .. ...
.. M.................. ,.... IU. . IJ._ I ..." 1 ...J7I . ...... . S6.J7I I ..... . IU" I ...on . 11.022 . 1'0,''''
.. .:rc:'tT-'- ....;.. I al .au .t:: I udJIl ...m I "..UII ..,{~ I ,;Jill ,..:::m I ,Aa
-
.'-- ...
I ".- -.
~'.c.'4! .... ....
c-. ,. o..p,.. .,-
.... ...... -.... ..... u",.
...~,.-
c........ t. Qp" ...... .
c.-. T. 0..,.'- .
... "-,... AiIP ...... .
I aL.-
e.-....... r. c., f. II....
c-Il T. CIMII!''''
.... ,.... AeMlI .-.. >>..,
.tw . c......-.......-.
c-...... T. c.'lII .
.. c..a ,. ~,... .
.. filii "..... AnII ...... .Dr .
.. .... ....--
I - c......... T. CiIlF' . I . I
c... T. 0.,."" . . . .
. ...--.... lUG I . . I
. _.oa. >>..1S . >>- . ".... >>... . "... >>.... "... 17", >>... I >>... "...
- ~.~~
- c....... T. C. N . I .. ... I .
- c.-.T.~'_ . . . .
I :'...~ClIl I all .. I ". ". I ". ". "... "... ". ". "....
................. ... & 1--- ,--- ...... ,--- ...... ...-.... ....... .---- .....-- ,.....-- ,---
(f0Ml.............,,..,.._..,._........___............1.
"........."",........._",_..."".. ..._......"'__",."........ --..".,__""..............a'_........ ~...-...,......,....
I City of Clearwter 49 Burton & Associates
Final Report Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~ ~ ~
Q -< ==
=' ~ 5
~ ~ ~
\I.J. ~ Z
~ ~ ~
~ ~ ~
< -., ~
=: ~
o
~ ==
~ ~
~ S
~ ~
Q ~
::s ~
o ~
~ 0
~
~
~
~
~
~
~
. ~
~
. !
~
~
!.~~~~.
~ ~&iiI1~
~ ~
~ .~
.~ t::
~ ~
~ ~
~~
~.c
=::s
.s:;j
....
==
~
.. .. "" .. .. .. ...
CD 210...........
~'...~:e:e'
~ g~g;
... ... "" lilt ... ." '"
!,=i!II.
o N......CD
.... 1""""'____
N V'J G) CD
..-..........
CD s:t:g........
~,c;; g:g:,
~ ~!:;m~
... ... ... ... ... ... ...
.... 2....gg
:;'csf8.....or-1
~ ~e!!
....._......~
~,~~~~,
~ ~!gii
... .. .. .. .,. tilt lilt
en 2--88
:!'C5~....,
Pi ~!~~
.,. WIt ... ... .. ... ...
en 2 enen
~1C511e:e,
~ m 'i;!
"lilt ,.., CD CD
c
....
... .. ... lilt ..,. ... ..
~.~,~~,
~ ~ ~~
... .,. .. tilt ... lilt ...
!,~.!!,
~ I' ~l!
... .,. .,. '" .. ... ...
~ on 1:::....
U')1::.cot3.
.: ,,; 00
~ 1J ~~
... .. ... ... tilt tilt .,.
a...
~
~
~ ~
C)~
IU
~tI::
o~
.... .~
U~
1
...
_ N fit . . . ...
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~!:: . . . . ,! ~.~~.
;!N !::" ~Cf~
N N ""
........................ ........
lR lR
.... . ....
~ ~
>- ~ Co-'
Q < Z
::s ~ ~
~ ~ ~
rIl ~ ~
~ ~ ~
~ ~ ~
-< I
= ~
o
~ ~
~ Q
rIl ~
-< ~
~ g
Q ~
~ S
~ f,O;l
o S
rIl fa
::c
u
r-'J
~ ~
~ "~
.~ ;:
~ c
2 ~
~~
'*J.o
=:~
.s:;j
J..;
:=
~
... ... ...
<r>,,-
8
~
1.1
..n iii
"- "-
N N
... ... ...
!l l!! .. ,I ~Ll1;l,
N~ vi ~...~
...... ,.... -.
N N
"'.....,............. W.,.W
<r>"#
8
~
"-:g .... CD.'"
m,,-.. .~ ~S\~.
~N ~ ~:;~
........................ ........
i.i
&ri iii
~ ~
... ... ...
<r>~
~
N" ""
:g~~
...;." ...;
.... ~
FJ.gj
~ ~
~!i:., .gj
&1.... ~
.... ....
........................
2~ ~
C5 \t') I' , an
~N ~
........................
... ... ...
... .. ...
....~S?
~l::!Ul
~~:i
N
... .. ...
~.~
f:ii f:ii
N N
... ... ...
<r>"#
8
~
"- "-
lS.lS
l8 lS
.... ....
1$ .. ,$ $~;
:8..... lS u)l:\~
.... .......
......... ........................ ........
<r>"#
8
~
2.... .... ....l:lt::
csl!i: ., . l!i: ~llic
~.... . ~Il~
j8,j8
~ ~
.... ....
......... ........................ ........
<r>~
~
<r>.....
"" .. <r>
<r>.c
~ig
""
... .. ...
~,~
~ ~
"" ....
... ... ...
I~ ., ., ~
~.... ~
"" ""
........................
....
'"
N J:!l
f;l'N
ri ,...;
~ J:!l
I~ ., "~
2.... ....
;;:; ~
........................
!lig
NN....
..."-~
... ... ...
... ... ...
<r>~
~
~ ~
co . co
.r: or:
co co
.... ....
I;. .; ~~S;
S~ ; ui~a;...-
.... ....
......... ........................ ........
<r>"#
~
...;
~.~
~ ..:
lf3 ~
~t:: ~ :D--:Sl::!,
...CD.IIII..... ii.~
~N ~ "'r;;~
......... ........................ ........
j
I~J~
.f;-jiS
'15&.' >~
~8000
..-'~
"--
~
~
~~
U&
~~
O~
.... "~
U~
I J ! ).I.li Ij
. J ~J~jis JI~
!I~ Jil!I~~i ~]~
!J
- N ft . _ . ~ ..... a a .. ~..
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX A.4
SCHEDULE 11 - FUNDING SUMMARY BY FUND
CITY OF CLEARWATER. FL
Sol CI \"Vastt. SJ~t"rn i=,"dIlCld r.lcmagelllent Program SUlTllllary
Fl /'lf~ 19 ~,n'~'l'! i IJiJlUJS!
EUIlIi EIlIIl EUII EUII a.JI2I EUI1l fUIU fUW EUIH film EUtI1i
I ,.- _.~ --
. I!Ieginning Bot.nc. I 1.98U71 I U56.967 I 1.45O.7lU I 9I2.22~ I 532.U9 I 52O.W I 52O.~13 I 520.408 I 520.408 I 520.408 I 520.408
. Not Addiliolltl Fundt 1 60 000 11.1.; 11.45O.rai I !l82.22~ I 532. U9 I 52O.W I t 52O.d I I I
. $ublOltl 2.OU.871 520.413 52Uoe sto.d 520.408
. Rtlllrict8d Amount I 500.000 I 5410.000 I 500.000 I 500.000 I 500.000 I 500.000 I 500.000 I 500.000 I 500.000 I 500.000 I 500.000
. Amount Avoillllllt for Projtcl. I 1.544.871 I 1.~.967 I 950.781 I .e2.224 I 32.1~9 I 20,~3 I 2O.~13 I 20.408 I 20._ I 20.408 I 20,408
, Amount Ptid for Proitct. I 451 522 I 536 100 t 51UM I ~"'719 S 32"U! I 2O,W I 2O,~13 I 20408 I 20 408 I 20.408 I 20,408
. SublOltl 11,093.349 I ".167 ~.518 I 2,~ S I I I I I I
. Add _ R.Ilr_ Amount I 500.000 I 5410.000 I 500.000 I 500.000 I 500 .000 S 500,000 I 500,000 I 500.000 I 5410,000 I 500.000 I 500.000
" Plus: Inl_ &mod During the V_ I 62.619 I lIU17 I ~7.706 I a,iN S 2O,W I 20,413 I 20,408 I 20.408 I 20..... I 20.408 I 20,408
ft ~... = CaIh Flow I I 1 1 I I S S S I I
It nding I U55967 11,45O.7lU 912,224 532,U9 52O,W S 520,413 I 520.408 I 520.408 I 520.408 I 520.408 I 520.408
.. --~..
14 I9tginning 15t1tnc. 56.159.502 17.627.903 18.567.707 57.923.707 17.235,151 $6,250,163 15.497,382 IU6U5. U746.229 U.754,819 15.110.308
II Not Additional Fund. I U6U01 $ 92lI ; 116J4 0001 $ ~ 567l I 1910\9881 I (752;1 S (529,0J21 I l222.1211 I 8590 $ 356419 $ 707 879
.. SublOltl I 7.627.903 18.557, 7 7.923.707 57 ,151 I U50,163 15.4117, U,ll68,J50 14.746.221 U.75U19 $ 5.110.308 15.818.187
" Restricted AmDUnt 53.880 ._ U.192.O!I4 $ ~.391.135 U.!i87.1U S 4.7"',436 S ~,907,353 Ull68.J50 14746.221 U.7S.,819 15.110.308 $5.81.,022
.. Amount Availlllllt for Projoc1. I 3.7.7.036 U,311UU $ 3.532.572 52.648,007 11.505.727 I 590,029 I I I I I 4.165
II Amount Ptid for Pnlie<I. 13U7c06 I Ui5.6~ 13.532,512 12.648.007 11,505,m I 590.029 1 1 1 1 I
.. SubtOltl I I ~,165
21 Add _ R.tl'ictod Amount 13.880._ U,I9Z.O!I4 14.391,135 U.!i87.1U 14,7....436 14,907,353 U.ll68.J50 14.746.221 U.7S..819 SS.110.308 SS.8U,022
.. Plus: Inl._ &mod During the V_ I 241.280 I 323.712 $ 329.628 I 303,ln I 268.706 I 2301951 I 209,315 I 194.292 I 190.021 I 197,303 I 218,570
'" L... -.. 10 CaIh Flow I 1241.2801 I '171211 ~~ I CJ03.1n1 $ ~7061 I ~.9511 I (2093151 I (194.2921 $ (190.021) I (197.3031 I 1218.5701
.. Ending 8tJ1lIlCtl 57.627.903 18. .7117 7. .07 7,2:35,151 $6 .163 $S,411 ,382 U.ll68.J50 14.146.221 I4.1S..819 $5,110.308 $5.818.187
.~~
.. Beginning Bolane. I 926.150 I 926.150 I 926.150 I 926.150 S 926.150 I 926,150 I 926.150 I 926,150 I 926.150 I 926.150 I 926.150
.. Additionol Fundt I I I I I I I I I I I
.. Otbt Sol'lico Rtsol'It on New 0eIIt I I I I I I I I I I $
.. Int_ Eomings I 32.~15 I 37.046 I 37.046 I 37.046 S 37 .046 S 37,046 I 37,046 I 37.046 I 37.046 S 37.046 $ 37,046
.. L...: Inl_ Etminat T......_to R-... Fund I (32.~151 I 13704611 137~1 (37,0461 I ~~II 137 ;1 I 137 ,0461 I (37.046l I (37.046l I 137 0461 I (37 0461
31 Ending BtIance I 926.150 $ 926.150 926.1 S 926.150 .1 I 926.1 S 926.150 I 926.158 I 926.150 $ 926.150 $ 926.150
City of Clearwater
Final Report
52
Burton & Associates
Utility Economics
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX B.1
AnPendix B.1
Financial Analysis Schedule:
Recycline: Fund RSA:
Scenario 1: "Just-in-Time"
City of Clearwater
Final Report
53
Burton & Associates
Utility Economics
I
I
~ ....-l ~ ~ ~
. ~
I ~ z ~ "~
Q .1::1 6
~ < .. ~ Q
=' Q.. a . ~ ~
~ ~ ~ .. J '" I .
I ~ 0 ~ i~ ~~
~ 8
r-'.J. ~ #J,#S ~ 15~ ~.~
~ z ~ #Uo '"
~ iS~oO ....e. .. :t ::::s
~ 0 ell :I~fl o'C a:
I .c~~ 'C~:::!~ ,s:::5
~ < u UU Q. Q..E I
@ a l2 a...
.( ::
~ Sif S:l ~
I " ><
I
~ f f = =
~ ~ .., .,
on III
~ . .
I ~ ..
... ~ ~
r-'.J. 0 I I
- N co co
.( ~ t cO cO
~ .., ~ I I
~ =' ... ~ I
I Q ~ ~ po.
t ...; ...; ~ . ..
~ N N ! .
Q ::c N ~ ~ ... ~' I
U ... .
0 ., .,
~ N It I 01
I ~ Clll Clll
t N N ~
~ '1111- Jmn;
... ~ ~ z.~ 1!!1
0 ...
~
t 0 0
r-'.J. ......
I ":t-
o ~ ~ .,.,
... .
0
N
t 0 0
.
I '" ~ ~
8
N S
t 0 0
Clll ~ .
I 8
N
t 0 IS
:~ ;',
I I -0 I,
I
I .
~
I ';. a...
~
. ~
I ~ ~
'T O~
=
i lU
~~
I O~
.... .~
Utt;
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX B.2
AJ!pendix B.2
Financial Analysis Schedule:
Recyclin2 Fund RSA:
Scenario 2: "Level Plan"
City of Clearwater
Final Report
55
Burton & Associates
Utility Economics
I.
, I
~ ~ ~
I ~
Q = z
-<
::s ~ Q.
~
II ~ 0 0
rJ'l ~ ~
z
I ~ ~ 0
~ ~ u
@
-< ~
I I = I
VJ
~ ~
~ ~
I rJ'l -
-< ~
I ~ :3
Q
~
Q :I:
u
VJ .
I ~
~
0
I rJ'l
I
I
I
I
I
I
I
I
I
. ~
...
~ It)
~
t It)
... ~ ~
...
co
N .... ....
t ItS ItS
N ~ di
...
~ .... ....
t ItS ItS
... ~ ~
...
~ .... ....
t ItS ItS
co ~ ~
...
~ VI
.... ....
t ItS ItS
COO ~ di
g It)
N .... ....
t ItS ItS
I ~ ~
.... ....
t ItS vS
:~
-d
..,
i
.::1
~ .. I~~r
. ...::1 I
.,. '1"'!f !
_CD.... .,.
ti~oo ...~ i ..
... a,:I:lB<9...
O~~~.f2!ii:S I
I
.
zz>- ~; 1 . j
"11;-
J . .
zz>- lJ~~
. .
..
..
IIUUt
I!!!!!!
......
.
~ ~
~":::=
.l'.:i t:::
~ c
~ ~
~~
~.b
=:~
.s~
...
:::
~
II
s
c
a
::
.
I
I
...
.
.
'C
.,...
~
)I
Ii
=
.
I
I
II
I ...
~
I ~
~ ~
o~
lU
~c:z::
o~
..... .~
U~
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX B.3
AJ!pendix B.3
Financial Analysis Schedule:
Recvclin!! Fund RSA:
Scenario 3: "Inflation Thru FY 2011"
City of Clearwater
Final Report
57
Burton & Associates
Utility Economics
I
I
~ rn ....:l ~ ~
. ~
I ~ z ~ "~
Q .l::i
>< 0( t Q
=' Q. ~.~~m 2 ~
~ ....:l
I ~ ~ 0 . ~~
~ . {! I
rJ1 ~ E- -;,~ -~ ~ II ~.~
~ ~ Z ts~QQ .....e! .. :::~
I ~ 0 Ql '~2 ~ ~ o'C a: ,
~ U ""..011 'C~:::!J!! 1 .s~
-< UUOOQ. Q..5 i
@ C! ...
-< ~~ ~. . az)o :::
....:l ~
cz::: >< C.... .... I "
I I
rJ:J
~ ~ :~ =
...
~ ...
~ .
I rJ1 I ~:~
- I:
-< ~ t ::
....:l
I ~ =' ~:~ .
0
~ t :: I ..
x .
Q u t:!_~ .
rJ:J . ~ - .
I ~ t :: "
~ ~
0 ~:~ j lUlll
!!!!I~
I rJ1 t ri .... 00
~-~ ......
It
N_
t ri
I .
~:~ *
t ri
CO I!
I ~:~
t ri !f
~:~ ;:;
I fit-o .
~PJ~:~ ,.
~ .
I 8 t - Q I
;
]J I
~ I ~
I ...
8 PJ ~ . ~
I it I ~
I ~ ~
~ I ~
o a: U~
8 i 11 ! IlJ
I ~~
o~
.... "~
Ut;t;
I
I - I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX B.3
SCHEDULE 2 - ASSUMPTIONS
CITY OF CLEARWATER. FL
Recycllllg System FlIlanclal Management Program Summary
.L\.5 S~)2J}tI2J2.5
Annual Growth & Cost Escalalolll: FY 2006 fUl!l!! FY 2006 E!..a!!l!! flll!1J! fU!!ll FY2012 mill f:UW EYlill FY 2016
RRcvcllna Fee Growth:
Residential Fees N/A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Munl-Famlly Fees N/A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Commercial Fees N/A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Other Revenues:
Other Licenses & Pennlts N/A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Pinellas County N1A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Sale of Containers N1A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Late Payment Fee N1A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Surplus Vehicles N1A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Sale of Recycleables - RES N1A -5.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Sale of Recycleables - MF N1A -5.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Sale of Recycleables . COM N/A -5.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Other General Revenue N/A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Unanticipated Interest Earnings N/A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Unappropriated Retained Eamings N/A N1A 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
ODeraUna ExDenses:
Full Time Salaries & Wages N/A N1A 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00%
Pari Time Salerles & Wages N1A N1A 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00%
Special Pay N1A N/A 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00%
Overtime N1A N1A 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00%
Major Medicellns-Emp N/A N/A 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Emp Pension Plan - % of pay N/A N/A 16.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00%
Interfund Transfer - % of Py Total Op. Rev. N/A N/A 5.50% 5.50% 5.50% 5.50% 5.50% 5.50% 5.50% 5.50% 5.50%
All Other Operating Expenses N/A N1A 3.50% 3.50% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
Othar AssumntJons: FY 2009 -
Debt AssumDtions: EDl!lIl all!!!1. FY 2008 E:UW
In s ".... 3.50% 4.00% 4.00% 4.00%
Tenn of Bonds 5 Years
Interest:
FY 2006 3.50% Months of O&M
FY 2007 - FY 2016 4.00%
Cost of Borrowino:
Cost of Issuance 1.00% of Par
Underwrite~s Discount $0.00 per $1 ,000
Bond Insurance o times total OS
Capitalized Interest o Yr. Interest
Debt Service Reserve o Years OS
City of Clearwater
Final Report
59
Burton & Associates
Utility Economics
I
I
SOLID WASTE RATE STUDY
I
APPENDIX B.3
SCHEDULE 3 - BEGINNING BALANCES
I
CITY OF CLEARWATER, FL
Recycling System Financial Management Program Summary
~
I
Balance as of
9/30/2005
Funds Incumbered Beginning Balance
or .Reserved for Available for
Projects not In the P . cts' th CIP
CIP roJe In e
I
FUND TITLE
I
Capital Improvements Fund
Revenue Fund
Total Consolidated Fund Balance
$
$
$
1,110,570 $
2,037,480 $
3,148,050 $
$
$
$
1,110,570
2,037,480
3,148,050
I
REVENUE FUND DETAIL
CURRENT UNRESTRICTED ASSETS
Cash on Hand & In Banks
Equity in Pooled Cash & Investments
Accounts & Contracts Receivable, Net of Unbilled Charges Est.
Due From Other Funds
Due From Other Governmental Entities
Inventories
Prepaid Items
Total Current Unrestricted Assets
Less: Accounts and Contracts Payable
Less: Accrued Payroll
Less: Compensated Absences
Less: Due to Other Funds
Less: Accrued Interest Payable
Less: Notes, Loan, Pool Agreements, and Acq. Contracts
Less: Current Portion of Long-Term Liabilities
Total Unrestricted Working Capital
Less: Inventories
Less: Assets in CIP Fund
Net Unrestricted Working Capital Available
EOY FY 2005
I
$
$ 3,401,849
$ (87,358)
$
$
$
$
$ 3,314,491
(32,450)
(29,286)
I
I
(100,713)
(3,992)
$ 3,148,050
I
(1,110,570)
$ 2,037,480
I
Restricted Assets
Cash And Cash Equivalents
Investments
Interest Receivable
Advances To Other Funds
Unamortized Bond Issue Costs
Total Noncurrent Restricted Assets
Less: Compensated Absences
Less: Bonds Payable
Less: Customer Deposits
Less: Amount Available For Capital Funding
Net Restricted Balance
$
I
$
I
$
I
Reserved Or Restricted Reserves Available For Capital Funding
Capital Improvements Fund
$
1,110,570
I
I
City of Clearwater
Final Report
60
Burton & Associates
Utility Economics
I
I
I
SOLID WASTE RATE STUDY
I
APPENDIX B.3
SCHEDULE 4- - FY 2007 OPERATING BUDGET
I
CITY OF CLEARWATER. FL
Recycling System Financial Management Program Summary
LY ~oo_-Jillcly.r!t
RESlDENI1AL IIUL n~AIIIL y COMMERCIAL TOTAL FY87
PERSONNEL SERVICES
510100 Full Time Salaries & Wages $ 288,540 116,540 245,240 $ 650.320
510200 Part Time Salaries & Wages 14,950 25,670 40,620
510400 Special Pay
510500 Overtime 17,500 10,600 17,9SO 46.050
510600 Vacation Leave
510700 Sick Leave
Sl0800 Other Paid Leave
512200 Injury Time
512300 Funeral Time
512400 Military Leave
512500 Jury Holiday
512700 Holiday Time
520100 Life Ins $2500 Empl & Pens 90 40 90 220
520200 1 % Life Insurance-Employee 970 170 690 1,830
520300 5amp Life Insurance 80 80
S20400 Major Medlcallns-Emp 58,880 23,040 54.400 136,320
520600 Social Security-Employee 5,060 1,370 S,2S0 11,680
520700 Emp Pension Plan 39,700 16,400 34,220 90,320
S20900 Workmans Compensation 6.780 4,860 5,950 17,590
SUBTOTAL: PERSONNEL SERVICES S 432,470 173,020 389,540 S 995,030
OPERATING & MAINTENANCE
530100 Professional Services $ 13,500 $ 13,500
530300 other Contractual Sarv l,SOO l,SOO
531100 lnv Purchase-Resale 299,500 299,500
542200 Elec-Uti! Charges 13,000 13,000
542300 Gas, Water & Sanitation Util
542500 Postage
542800 Interfund Other Service Charges SB,900 60,270 27,830 147,000
542900 lnterfund Admin Service Charges 100,000 14,180 13,000 127.180
543100 Advertising 5,820 2,9SO 11,020 19,590
543200 Other Promotion Activity SO SO
543500 Dump Fee
543600 Taxes
544100 Equip Renlal S80 S80 l,lSO 2.310
545100 Insurance 8,780 3,650 25,090 37,520
546200 Other Equip Svc & Repair 6,000 l.S80 4,810 12,370
546500 Garage Equipment Repair Services 3,000 3,000
547100 Untforms-Employee 1,300 S20 900 2,720
547200 Travel Expense-Emp 230 60 1,600 1,890
547300 Mileage Reimbursement 130 470 800
547400 Meals-Employee 150 260 190 600
548000 other Services Or Charges
550100 Office Supplies 1,120 1,300 2,420
5S04OO Operating Supplies & Mab 19,450 13,000 24,%0 57,410
552500 $7SO - SOOO Mach & Equip
557100 Memberships/Subs/Ltc Emp 360 520 880
557200 Officl Recognroon-Emp 100 40 100 240
557300 Trainina & Ref Employee 160 110 890 1.160
SUBTOTAL: OPERATING & MAINTENANCE S 21&,380 97,180 430,889 S 744,_
INTERNAL SERVICE CHARGES
540100 Garage SeMces S 125,4S0 3O,S80 175,090 $ 331.100
540200 Doc Repro & Print Shop Svc 3,640 210 2,390 6,240
540300 Telephone Service Variable 600 1,300 1,900
540500 Radio Svc-Fixed 2,660 590 S90 3,840
540600 Telephone Svc Fixed
540100 Postal Service
540900 Risk Mgmt Service 2,030 860 1,920 4,810
541000 Info Technology Charge 26,360 26,380
541500 Garage Variable
541600 Bldg & Maint-Variable 1,000 1,000
541100 Radio Svc-Variabla
541800 Administrative Charge 76,730 72.960 41,710 191,400
542000 E~oy.. Benefits-Fixed 1.430 610 1,360 3.400
SUBTOTAL: INTERNAL SERVICE CHARGES S 238,_ 105,790 225,380 S 570,_
DEBT SERVICE (1)
S71300 Principel- Loosed Equipment $ 78.530 21,n8 69,268 $ 169,576
512300 Interest - leased EQUipment 4954 3.726 10.401 19082
SUBTOTAL: DEBT SERVICE S 83,_ 25,504 79,670 S 188,858
IN1aU'UND TRANSFERS
590200 Interfund Transfer $ 10,500 63.000 79,600 $ 153,100
590800 Contribution To CIP Fd 20000 8.000 22 000 50000
SUBTOTAL: INTERFUND TllANSFERS S 30,500 71,000 101,600 S 203,100
OTHER EXPENSES
529700 Net Pension Asset Adiustment S $
SUBTOTAL: OTHER EXPENSES S
TOTAL 0 & .. EllPENDnuRES $ 1.001.134 412.494 1 227 050 S 2.101.218
(I) Per_modeI~_to--""ofUPProg..mond CPo
I
I
I
I
I
I
I
I
I
I
I
I
I
I
City of Clearwater
Final Report
61
Burton & Associates
Utility Economics
I
I
I
I
~ ~ ~
Q >< ~
=' ~ ~
~ ~ ~
~ ~ >
~ ~ ~
..( < ~
= ~
~ t=
~ ~
rI:J. u
..( ~
~ ~
Q ~
~ ~
o
rI:J.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~I
M-E$M~EB-W
~I
W~W"WW
~I
WWMWWW
~I
6'9-WEB-WElttlt
~I
'8
o
g
'"
WWEIt..,.W"
888
000
"':.nO
~~~
~I
'888 0
"'00 8
anu;"": N
"'ltLt)'IIt M
WWWWWW
~I
'0
8
iii
C")
'"
tltWWWWEllt
8~8
"''''0
~gi
~I
~oo
ffi88
~~g
wwwwww
~I
'88:2
~O<O
__.. iii"':
~l/'l<O
o
o
o
o
C")
'"
WWt4WEl:tW
~I
~
'000
000
000
~g~
WWWWWflt
<O'l/'l
~ ~
o
wwwwww
c.
E
'"
~ a.
.S! ~ ~
.lii a:: - 'E
u - :& CD
00C::5E E
.~,g;>2lc::2l
gp; ~ '" 0 '"
g-~eg.~g.
~ < a. a:: g.a::
~CD~c.:ic
g>.~'~~.S!~
'6 S '" .9-.2 .9-
=1:3::>'<:::>
::JO C"CDO"
cou w>w
aC)QDO)Q
.5 .5 .5 .5 .5 .S
~~~~~~
~~~~~~
...
...
...
...
...
...
...
o
8
iii
...
~
...
...
, ~
;:::
N
co
...
''''
<0
~
N
~
'"
'"
~
a>
l/'l
...
6"tWWW
MME$W
6<<)-WWElt
"WMEIt
6'tWMEi19-
EA-WWW
tIt"EIt"
WWMtIt
"69-MEA-
000.....
co88le
anlliNo
NNN.....
WMMW
6I'tMW61t
.,;
c::
o
;>
'"
c::
:c
E '"
2lSg>
1:...=
so",
.!! '8 E
l:l - tj
< g> I!! '"
S:.c:.c::J
ee-g~
G).ocaca
gc5~
'E &:';.!!
~ ~ .8" ;
.9-~:e c::
g.~ll:
w.<: 00 E
g-'j:fi ~
CD .!l ~1i
~.~ i!! ~
~.!o15
~~5E
~ ~:g ~
.!!! 'fi E .,;
lil ~e:!2
~I!! ":~
~ 15 .~ ~
~~i~
lil'&.>::>
a::~~iE
~ :: ~
..,.MMWMWWWM
W6"tMMMWMMW
MMMWMWWMW
WMWMMMWWW
MMMMMMMWW
WWWWWWMWW
WWEltw..,...,....,...,....,.
WWWWWWMWM
000000000
8~88888g8
OW"':arilONWM&6
,...."'.................... .q-
'"
MMWWWWWWW
MWWWWWWWW
WWMWWWMWW
l1
""
~ ~
'0; g
~~ a;
~ e ~ ~
:1-oB~ g ~
1615 ooB c::
. e"~ E J11 !!l
e",,,,::> 2l~.g
a. ~!I!.~ '" > l;;
- IS E 'E ..
~~Q..= 'C8.;p~
~~~ ~~E-:
c="2.eQ) U)~~.e
'fi: m'E.5 ~li:~ g>
CD5~~~>-~g,g.~
a::-J2 2l '" CD c::.~-6 ~
:&.S!.!!!a.c:,g~CD-o
t:Ua.I:::JOU.ctO
oG~~~~5!~:5
;..> lD'C.2 5.5:: CD
",C::E~-;;tj.,;oo:&E
= ~ 51ii,g-m:!2.~ E'g
.~ 2l8i B;>~~ 2l '"
a.CUca.c::;l~<<SQ).!!~
0..> (I)"C_C > a. a.
8 I!!l;l 2w:&,gal I!! [
",~>U.2-oBc."''''
>-CD-oC:::C'O;::>l!!C::~
LL~~~~&!iE~~~
~ ~ ~ ~ ~ ~ ~ ~ N ~
... '" Gl
~~ :;:
orillia>
co",...
C") ~
... ... ...
~~ g
l/'lCO ~
"':N'.
~'" ,
... ... ...
~COGl
... ~ GO
co...",
~:o ~
... ... ...
~~:g~:g
0,......... 0 ....
88 S ~ S
~~ '" '"
619- 6ft tit tit
g
o
N
~
... ... ...
o
o
N
..;
'"
~
... ... ...
'0
GO
GO
..;
Gl
...
...... ...
'i
iii
...
...
... .... ...
'"
GO
o
of
...
GO
... ... ...
'N
GO
o
i
N
...... ...
'N
...
'"
~
N
... .... ...
>-
'"
:!2
15
~
a.
:::;
a. a.
UU
00
Gl Gl
-0-0
~~
00
'" '"
I!! l!!
.a.a
1313
c:: c::
CD
c.
~~
;gj;gj
c.
~~
(ij(ij
::> ::>
c:: c::
~~
II~
'['2 -s
a.a....
~ ~ ~ ~
~ m
o N
~ a>
~
...
?f'. c
o 0
o ~
~ i
~
...
~ Gl
8 :g
~ ...
~
...
>I? 0
b 0
~ ~
~
...
>I? 0
8 :;:
~ ori
~
...
'#. c
o GO
o GO
~ ..;
Gl
...
...
'#. ...
o GO
~ 10
~
...
...
'#. II)
o GO
o 0
t.
GO
...
*' N
o GO
~ :-
10
N
...
~ ~
o '"
~ ~
N
...
j
::>
C.)
Gl
~
~ 'i
.9 ~
-0 ::>
Gl LL
~ 11
"l s
a. Ui
U <3
-0 a.
* U
Ol '1::J
-g -fl
co III
'0 cr
*' t.
~ ~
"'too;) .~
.S ~
~ c
~ ~
~~
~"~
::~
.s::S
....
:::
~
~
....
~
~
~~
U&
~~
o~
.... .S::
ULt;
~
N
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~ ~ 13
Q ~ ~
=' ~ ~
~ ~ 8
rJ'J. ~ ~
~ ~ 5=
~ ~ ~
-< < ~
" ~
~ Q
~ ~
rJ'J. <
-< ~
~ ~
Q >
~ ~
~ Eo-.
o ~
~
rJ'J. O.
Eo-
r.n
~
~
o
~
I
\0
~
;
U
r.n
!
~
~
..
II i!!.~~!i!
i:1 ~ :::si
~
~
!
!
!
!
!
.."" w..
!!l,~Yli!!
~ ::~~
..
!.' 'o~
;z 0 ~
H I!
IJ sf
JdJJI~
I~ii J
ilHU
Jj ~
~ ,',Hi a. '!!i:i
a ~=a ;@ ::~i
.... .,."" ... tit..
Ei.'~a
I :::ej@
-. ..""
~.'~5i
~ :::lS
~.'~;$.
4ft ___
III -"'1lI
~.'~e;
~ ::::1;
.. .. .. ..
!!i.U~
; ..;:!~
i& . ~!ll!!i.
5 '-';!5
!: ~o~
...._' 8 _
~ 0 ~
~ ~o~
....,8 ~
~ cO ~
::; ~~
. . 0 . OlD
:; :;~
.,...........
. ,!i! .!i!~ i~., !'~I~ . ,?!~~
~ ~! ~~ ~~~! ~~g
. ,5 .!$~
~ lI:~
...............
'"
....
Hi
s~
. ,3.35
~ :;;~
~
I I! !J
jl )i jl I! ~ ~ i~jl. i
I} iE =} if. . ~~ J
ijlll~ il)I)!, . 1 t ~ i~jiij!
111 f jll jj i J;fj I j!j i .Ii f
filII 11111 f~f IJ fjl,i.- li!~IIII,IIII~i
~ I I i il JitJ~ ~ I ! If
~ I ~ ~I I ~
'"
.. ..
tilt..........,.
;:~
;~
:::...
..~.!H4
Ii Ii!!
-...........................13 ... fii....IIAa........"o...s=:
!U
cD~
;'"
..
... ..
,.15.15;
tt ~E
......_w.....
c;tJ
~~
<! <!~
. . _ ._1Ift
:i lll~
.............M
~~
~~
..
......
, .~.n
lli Ill\!!
..
!il! !~
:;;~ 3~
;3 ~:
.. .....
.... ....-
. . 0 . 0_
! !~
~~
-..
"'...
-...
:;=
.~:i.lSi
rjt! ;5
. ,E . E~
It z;"
'" ..
.&:11
~..
:;;~
~ ~
~ "::l
.~ ;::
~ c
2 ~
~~
~"c
=:~
.s::5
....
:::
~
~
....
~
~
~ ~
U~
<U
~~
o~
.... "~
U~
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~ ~ ~
Q >< S
~ ~ ~
rI'1 ~ rJ:J
~ ~ c5
~ ~ I
..( < ~
=: s
~ ~
~ rJ:J
rI'1
~
Q
~
~
o
rI'1
~
~
~
~
~
~
. I!
. !
'. I !
..
. !
~ J !
.'15
I ~
!
~~~ ~~~
dod ::::::
~~~ ~~~
cicici ::::::
!!! ~~~
~~~
000
1/1.."..,.
~~~
!~IHi
~~!~
~ N
.,........
!~6~
la~:i
.,.: N
.. lit.. ""
il ...."....
........,
.......-
~~I~
...
... tit....
!::!~..,...
cn_~'"
!!i;i-lQ
lO....&1o
...
... tit ......
....~co...
l!e_1013
i~m~
~
...... ...
~~.t:
"'''I~co
~~~~
~
M.., .....
~!S!!;!~
~~5~
...... ...
:Hj~~
gt'lill)(7i
;slll~~
.. .. ......
si5~
18~i~
jl)
HI !ijJ
! H I.."
~ · ail J
IclQ! J s
III ~~~ ilJ!
l~l If) illJ
) fJ .) J f)
]) ill ])!
~
- ......... ..~ .....
~~~ ~~~
ciao
---
---
,~~ ~~~
QOO Mr'lr-i
~~~ ~~~
odo ~Mri
~~~ ,~,
odo MMM
~~, ~~~
000 rit"iri
~i~ ~~~
~~~ ~~~
liS . 5l~IU~!i~ . ~
"':";IIi'!Cit'ti <<i
"'t:;;: ~
~
..,......M....,....,...........
liS ,5l~!Hll~8~ .lS
"':"';.n~..n .,.:
"'t:j:! "
............................
~.5l8~~:g;!~.~
,.:.,;~~m ~
........."........,........
~,5l~~~:g~~.~
~cn~~"i ~
........M......,...........
~,5l8lil~:gI~.ie
":.,;~~a ~
............"".....,.,.....,.
liS.5l~~~:g~~.~
t-:".;~~.o ..
~t:t; 5
.............,...........,
liS.5l~~~:g!3~.~
":Gi~~S ~
~
.......""..w...........
~,5l8lil~:gi!~.~
":.,;~~li ~
.....-..................
lll,5l~~~:g~~.~
":oi~-~ i ~
-
.......................
~ ,5l~~~:gIU .!!!
,..:cri~~m ~
~
...M...................
!ii5~~i~~!~.;z
t7i vi~~Mcini oi
.... 16ll!:l 5
...w""...,.w""....w..
Ul ~ wJ
i ~~~ 1
~ .ilJ.t11iiJ
JIsillllj~
1..0.1...... ~
~!!!!!!!! I
....
....".....1111&
.S!..S! ~
wi I.l'i tt
.., .., ~
.
~ ~
~ .~
.l::S ;:
~ c
2 ~
~~
~.~
=:~
,S::5
....
==
~
........." .,.
!!il !!il co
. . . .. ;;
~ ~ E
,.;
"'......... ....
... .....!!
. S. . ,a. ;:
. . ~
....""MM ..
.3..3 it
~ ~ ~
..,
""'.......tIlt .,.
.je..je S
g g i
,.;
IIt.........WI .,.
. ~ .. ~ 1ft
;t ~ ~
N
M "" ""..."" vt
,~..~ iJ
:fi :fi.
N
............ ....
.~..~ ~
!.i !.i!
M ...""'....... _
~
co co ~
..... ...
. Q . . 0-
~ ~!
wwt........ ....
,E . . E ~
lll' III ~
N
............ ..
.~~.~ ~
~::i ~ ~
N
...."".... ..
]
..
&:
1 j
jlf)l
f] ~Id J
II !I 1
... l-
. II l; . 1111 "
...
~
~
~ ~
t)~
~
~~
e~
.1lo1l .~
U~
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SOLID WASTE RATE STUDY
APPENDIX B.3
SCHEDULE 8 - CASH OUTFLOWS
- --'---"~-
~. ::, - :: - ' . -.:=, c' ~ :J 11 ~l-' ,
~ -
~ .. . .. . . " .
flJIII EDIIl fUll fUIII n:JI1I fUW fliIU nJIU fllIH EUm ELlIJi
08bt: $.arvlea CMt8
Exiotiflg LP Payment. S 127,970 131.120 S 131.720 S n,960 S 27.720 S 5,820 S S S S
~~SeMce I Bt S I ;::n ~.m I 1:1 S ~;W I HI ~.Il 410 318 417 .208
Total _ 127-," S 418,318 4"'-
. 0&11 fKDaIIUNI'"
. 8aNl - ReCJdln8 - __I
T FuN TIII11 SIIIri.. & w_ S 225.343 S 281,s.o S 300.082 312.085 S 32U~8 337.551 351,053 365.095 379.699 39&.887 S 410.682
. Pall TIII1I_ & Wogo. S 4.n8 S ",950 S 15.548 1~.170 S 16.817 17."9 18.189 18.917 19.673 20.46G I 21.279
. Splcial Pay S 8,- S S S I
~ 0v0fIime S 7.703 S 17.500 I 11200 11.928 S 19,685 20.473 21.291 22.143 23.029 23.950 I 2U08
. VI<Mion l_ S 13,126 I S I S
. Sick l_ S 5,518 I S I S
~ Ottler Paid l_ S 959 I S I I
. IrljuryT.... S I S I I
. Funeral TIfl'II S I S I I
. Miitlfyl_ S 1.063 S S S S
. Jury Holiday S S S I I
. Holiday TIII1I S 2'.149 I I I S
. life 1ft. S2SOO EmpI & Pen. S 14 I 90 S 93 96 S 99 102 105 108 111 115 I 118
OJ I'll liIo _o-EmpIoyee S 483 I 970 I 1.0lM 1.034 I 1.065 1.097 t.t30 t.t64 1.199 1.235 I 1.272
" Samplilo_. S I S I I
.. Mojo< MedicalIno-Emp I 56.172 S 58.. S Q.413 16.158 I 70.127 74.335 78.795 83.522 88.5J.l 93.146 I 9U77
" Soc:iaI Security-EmployM S 3.891 S S._ I 5.237 5.3!M I 5.556 5.723 5,894 ~.071 6.253 1.441 I 6.634
.. ~ _ Plan S 2Ut7 S 39.190 I 5H13 69.437 S 72.214 75.103 78,107 81.231 8U80 87.859 S 91374
.. Wodcm.... ComponslOion S lU70 S 6.780 S 7.017 7.228 I 7.0U6 7,66& 7.898 8.135 8.379 8.630 S 8.889
.. P_-- S 1.080 S 13.500 S 13.973 S 14,392 I 14.823 15.268 15.726 16.198 lUN 17.114 I 17.700
.. Othor CoNrodWll Ser; S S I S I I
.. Garage _ $ 1,..228 $ 125.450 I 129.141 $ 133,736 I 137,7" 141.880 1".137 150.521 155.037 159.688 S 1~U78
.. Do<: Repro & Print Shop S>.<: $ 1,756 $ 3.660 I 3.767 $ 3.880 I 3,997 4.117 4.240 4.367 4,498 U33 S 4.m
OJ T....,..... SeMce V_ $ 351 $ 600 I 621 $ 640 I 659 679 695 720 742 764 $ ro
. _ S>.<:-Fixod $ 2.670 I 2.660 S 2.753 $ 2.836 I 2.921 3.008 3.09!l 3.192 3.287 3.Je6 $ 3,_
.. ToIopIloM S>.<: F'IXICI $ $ I $ S I
" P..... SeMce I $ I $ I I
.. Risk Mgmt _ $ 2.110 $ 2.030 $ 2.101 $ 2.164 I 2.229 2.296 2.365 2.436 2.509 2.514 $ 2.662
.. Into TodvloIogy Chafgo $ 23.830 $ 216.360 I 27.283 S 28.101 I 28.944 29.812 30.707 31.628 32.5n 33.554 I 34.561
.. Garags V_ $ I I I I I
" I9Idg & Maint-V_ $ I S I I $
.. Adminiatr_ Chafgo $ 74.830 I 76.730 S 79.416 I 81.798 I 14.252 86.780 89,383 92.064 9&.826 97,671 I 100.601
.. Employee _.-Fix... $ 1.- S 1.431 S 1.480 I 1.524 $ 1.570 U17 1.668 1.716 1.767 1.820 $ 1.815
.. POll. I I I $ I I
M Int_ Other SeMe. Chaoges I 56.900 I 58.900 I 92.161 I 9U26 I 97.774 100.707 103,7211 101.840 110.045 113.346 I 1t~.747
.. Int_Admin -. ChIrgH $ 911.000 I 100.000 S 103.500 S 106.605 $ 109.803 113.097 116.490 119.985 123.5M 127.292 I 131.111
.. _ioing $ 1.268 I 5.620 S 5.817 $ 5.991 $ 6.171 6.356 6.s.t7 6.743 6.915 7.1s.t I 7.368
" Dump F.. $ I I I I S
.. Equip R..... $ J12 I 510 I 600 I ~t8 I 637 654i 676 696 711 7J8 I 760
.. Iftourance $ 2O.9IiO I '.780 I 9.087 S 9.360 I 9.641 9.130 10.228 10.535 10.151 11. 116 I 11.512
" Othor Equip S>.<: & Repair I '.2t7 I 6.000 S 6210 $ ~.396 I ~.588 6.786 6.189 7.199 7.415 7.638 I 7.fllJl
.. Geroge ~ Repair-" $ I $ S $ I
.. Uailonn..fmployM $ 2.311 I 1300 S I.. I 1.Je6 S 1.427 1.470 1.514 1.560 1.607 1.655 I 1.7Ol
.. T_ ExponoKmp I S 2JO I 238 I :U5 I 253 2EG 268 276 284 293 I 302
~ MiINge_ S S 130 S 135 S 139 S 143 147 151 156 161 165 S 170
" Meal.-EmpIoyM I 14 S 150 I 155 $ 160 I 165 170 175 180 185 191 I 197
13 Othor -.. Or Chofge. $ I I $ S I
.. 0IIce ~ I 979 $ 1.120 I 1,159 I 1.191 I 1.230 1.267 1.305 1.3U 1.3N 1.Q6 S 1.468
.. 0peflIling ~ & Motl. $ 17.310 S 19.450 S 20.131 S 20.735 S 21.357 2t.997 22.657 23.337 2U37 :U.758 I 25.501
.. $750 - 5000 Modl & Ecpp $ I I I I I
IT _ipoISubsll.ic E"", $ ]50 I 360 I 373 $ 3N I 395 407 419 U2 445 458 $ 472
.. 0IicI~ I !GO I !GO I 104 I 107 I 110 113 116 120 l:U 127 I 131
II T IOining & ReI EnIfIIoyee I 125 I 160 S 166 I 171 S 176 181 186 192 198 ~ I 210
.. Prine- TofT 0 $leg Fund I S S $ I I
~ Int-TofTo $leg F.... $ $ S $ $ I
" 02N2 -1IecycIlng - _.fMlIIy
13 FuR T.... SoIorieo & W_ 95.70 116.s.o 121.202 12'.050 131.092 136.335 141.789 147.468 153.359 151.493 165.873
.. P..T...._&W_ 1.550
.. Special Pay 518
II 0wItime US4 10.600 lUtU 11.<165 11 .921 12.M11 12.897 13.412 13.919 14.507 15.087
City of Clearwater
Final Report
65
Burton & Associates
Utility Economics
I
I SOLID WASTE RATE STUDY
I APPENDIX B.3
SCHEDULE 8 - CASH OUTFLOWS
I
I fUlIi fUltI flJlIII flJlIII fUUI fllI11 EUIIZ EIJIU EUlU fI.1W EUlI3i
'" P_-- S S S S S S S S
.. 0tI1er~ _ S 1.500 S 1.553 S 1.519 1."7 S 1.196 1.141 S 1.800 S 1.854 S 1.909 S 1.961
'" Inv___ 361.678 S 299.500 S 309.983 S 319212 328.860 S 338.~ :wa.888 S 359.355 S 310.135 S 381.239 S 392.m
.. Gaggo- 162.621 S 115.090 S 181.218 S 186.655 192.25( S 198.022 203.963 S 210.1182 S 216.381 S 222.815 S 229.562
.. Doc Ropro & Print SIlop 51<: 112 S 2.3!10 S 2.414 S 2.Sf8 2.624 S 2.703 2.184 S 2.868 S 2.954 S 3.042 S 3.134
I .. Teltph... SoMe. v_ 1.052 S 1.300 S 1.346 S 1.386 1.427 S 1.410 1.514 S 1.980 S Ull1 S 1.655 S 1.704
., Radio 5I<:-Fixod 53lI S 590 S 811 S 629 648 S 867 A1 S 108 S 129 S 751 S 174
NO T....... 51<: Fixod S S S S S S S S
NO PootolSoMe. S S S S S S S S
.. Risk MgmISoMe. 1.610 S 1.920 S 1.987 S 2.047 2.108 S 2.111 2.231 S 2.304 S 2.313 S 2.444 S 2.511
'" InIo TodInoIogy a..vo S S S S S S S s
I eo Illdg & MainI-Foced S S S S S S S $
.. Garoge v_ 861 $ S S S S S $
.. IlIdg & MainI-V_ 980 S 1.000 S 1.035 1.086 S 1.098 S 1131 1.186 S 121111 S 1.236 S 1.213 $ l.311
. Radio s\<:.v_ S S S S S S S S
. Ad_ ChaIvo 40.880 S 41.710 S 43.110 44.465 S 45.199 S 41113 48.588 S 50.046 S 51.Sf1 S 53.093 S Sf.686
'" EmpIoyeo -.-Fixod 810 S 1.380 S 1.401 l.450 S 1.493 S 1.538 1.514 S 1.632 S I.Al S 1.131 S 1.783
. EIoc.w CIlaIpI 10.225 S 13.000 S 13.455 13.859 S 14.274 S 14.103 15.144 S 15.598 S 16.086 S 16.Sf8 S 11.044
I .. Got.W_&_W S S S S S S S $
.. POIUlge S S S S S S S S
'" Int_Other_~ 26,810 S 27,830 S 43.548 45,806 S 47.449 S 49.156 5O.!l2I S 52.110 S Sf .683 S 56.671 S 58.736
.. Int___~ 12,800 S 13.000 S 13.455 13.859 S 14.274 S lU03 15.144 S 15.598 S 16.086 S 16.548 S 11.044
.. AdYootising 6.O!M S 11.020 S 11.4lIf 11.748 S 12.100 S 12.463 12.831 S 13.222 S 13.619 S 14.CJ28 S 14.448
.. Other ""'-'- Ac1MIy 11 S 50 S 52 53 S 55 S 57 58 S 50 S 62 S " S 66
I .. Dump FH S S S S S $ S S S
. T_ S S S S S S S S $
'" Equipl_ 523 S 1.150 S 1.190 S 1.226 S 1.263 S l.3111 1.34lI S 1.38lI S 1.621 S 1.4" S 1,508
. _. 11.720 S 25.090 S 25.961 S 26.747 S 27.550 S 28.m 29227 s 3lI.lOf S 31.001 S 31 ,938 S 32.896
. Other Equip 51<: & R_ 8.961 S 4.810 S 4.978 S 5.128 S 5.282 S 5.440 5.503 S 5.171 S 5.944 S 6,123 S 6,306
.. Garoge EquipInn Ropoir SoMeos 2.039 S 3,000 S 3.105 S 3.198 S 3,294 S 3.393 3.495 S 3,600 S 3.108 S 3.819 S 3.933
'" UniIormo-EmployH 1.846 S 900 S 932 S 959 S 988 S 1.018 1.048 S I,CIIO S 1.112 S 1.146 S 1.180
I .. Tr..... Exponoe-Emp 789 S 1,600 S 1.666 S 1.706 S 1.757 S 1.810 1.864 S 1.920 S 1.917 S 2.031 S 2.098
m MiIugo- 41S S 410 S 488 S 501 S 516 $ 532 548 S 564 S 581 S 598 S 616
IN MeeIo-Employee 84 S 190 S 197 S 203 $ 209 S 215 221 S 228 S 235 S 242 S 249
.. Other SoMeos Or CllIIgos S S S S S S S S S
.. 0IIice SuppIios 1.349 S 1.300 S 1.346 S 1.386 $ 1.427 S l.410 1,514 S 1.980 S 1.501 S 1.865 $ 1.704
UP Oporoting SUlIPios & - 21,111 $ 24.950 S 25.834 S 26,609 S 27.407 S 28.229 29.016 S 29.!M8 S )0,841 S 31.172 $ 32.725
'" Mombeoohipo/Sub En., 318 S 520 S 538 S 554 S 571 S 588 606 S 62A S 643 S 662 S 682
I .. 0Ilie1 RocogniIion-Emp 100 S 100 S 104 S 107 S 110 S 113 116 S 120 S 124 S 121 S 131
.. Training & Rof~ 1140 S 890 S 921 S 949 S 917 S 1.001 1.037 S 1.068 S 1.100 S 1.133 S 1,161
'" Prine.TolTo Skg Fund S S S S S S S S S S
.. Int.Tt:Jt=. 12.237.793 12.388.5a 12.5N.. l2.m.13l 12.121$' 12.81..938 13,124.;" 13.133.5&3 s s
.. TOllII U1U59 S 3.248.456 S 3.363.621
I .. l8iIIfIrI.llII
.. Rosiclonliallnl_r_ 20.248 10.500 10.005 10.190 10.381 10.579 10,782 11.481 12.269 13.135 14.094
. Mulli-Fomitylnt_T_ S 10.800 S 63,000 S 10.029 S 61.141 S 62.288 S 63.411 S ".691 S 61.924 S 13.614 18.809 84,565
'" CO:=';_T_ I ~':l1 ,lll J:I 1 ~~ 1 lR~ I ,a 1 81136 I ':;;1 I 1~ 19 515 106.~
.. TOllI Out 157'- 191.519 205.
.. r~I:"_1JJ
I .. ~
'" C_ToClPFd 10.000 20.000
.. Contrib To Garoge Fund
.. Not Pension As... AdjuolmonI 20.182
.. MuIti:UDl1/;:
.. Contribution To CIP Fd 10.000 8.000
I .. Conlrib To Garoge Fund
'" Net Pension As... AdjuolmonI 8.918
.. ~
.. ContflblOiorITo CIP Fd 10.800 22,800
... ConIrib To Garoge Fund
.. NeI~=- 16~
. T...I 75 51'-
I aa IT_'" s.wfa. out. r....... . ~ .".,.. "'-- 1'''- S ut1.Jl1 I ~_.5D 11IJU51 13..1aDt S 3.27t.... IU.~ 115&aI 13.71U12 S 3.....213 S 3.11&.3621
(1) OCM~_._"'PfVI<<IN_
f2J T_..,,~____FY__ FY2tl... _,.,.....,_ "'......., CIP~_
I
I
City of Clearwater 67 Burton & Associates
I Final Report Utility Economics
I
- --- -------- ----- - -- -- ---------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~ rfl 8
Q = ~
=' ~ 0
~ ~ ~
r'-l ~ ~
~ t ~
~ < ~
...( ~
~ ~
0'
~ ~
~ Q.;
r'-l ...:l
...( ~
~ ~
Q ~
~ ~
S ~
r'-l 0
~
~ on r- 18 S!! S!!
rc'~"'NN'
ori ~:&~~
.... M ......
..M........M
~
~
~
~
~
9
~
!
~
~
S! ~ 88
;s:.I,t')'~""'f
sf ~ ~~
M..........M
~ ~
~.....
.~ ~
~ ~
~~
~"e-
=:~
.s~
...
:::
~
CD ..... 21'"
;:It:;'la~'
Iii g ~:=;:
M ....
........M....
fit ~ l8l8
,..... . 0 .............. I
8' M MM
..... ~ :&~
.. .. .. .. .. .. ..
8.g.88,
sf ~ ~~
M ""..
"MMMMMM
~,g.~~.
8' M MM
..... ~ ~~
MMMMMMM
o 0 oS!
~.8.~;;.
t 2i MM
..... N ~~
MMMMM"M
'r' 52 ~...
fB.<:).:8fB.
,..; txi orion
r- M ..........
N MM
MMMMMM"
~
~.ii!.:g:g.
iii ,..; .....
(;; ~ 2i)~
MMMMMMM
~.~.~i!1
~ ~ .~
MMMMM"M
l!! l::: ~~
NIN'''''''''''
ci M MM
r- .... ..........
..... NN
MMM"MMM
5
1
1
..0.
1.8
~ ~i
.. Ii
I ~. ~
1~.."
U-1 ~. .fa..
I I-" 0.01
r~.J~n~
...
~
~
~ ~
o~
lU
~~
o~
.... .~
U~
-Nft.....
I
I "'~ rJ.rJ ~~ s ~.l~
t'llD . ....
~ rn C-' ~ ...: ...: ~ro-O ...: ~1I~
. ~ lD ~ ~ ~
I ~ z ,., .... .... ~
Q ~ ... ... ... ........................ ... .. ... ~ "~
>< "" ~ ~ ,... ,., ,~ ~.~~ .~ ~
=' 0 ,., '" , .
~ t'I . t'I t'I,... . ~ ~
~ ~ ~ ~ ~ ~ro-O cD ~;lN
I ~ ,., ,., :! .... ~~
... ... ... ........................ ... .. ...
r'-J. ~ ~ "" '" '" ~~. .... ~:::8 ~.C
.... .... lD
~ ~ ....'.... . ,... ....~ c.te. C)~
~ .. ~ ~ ro-Oro-O ~ :!~~ =:~
I ~ ....
~ .... .... a:;j
~ ... ... ... ........................ ... .. ...
< "" ~ ~ ,... .... lD gP.... -..;
I .... ,... . , 0 N.~~ :::
~ o . 0 t'lO . , ....
= .. ...: ...: ~.. ...: ~lj;[;:; ~
I ~ 0 0 ..,
.... .... .... .... ....
0 ... ... ... ........................ ... .. ...
~ ~ "" ,., ~ ~!:!, 0 ,.,lOen
~.,., , ,... ,.,~,...
, '" ..... "'!.
~ @ .. a a ~ro-O cD ............
I .... - ... ...
r'-J. - - ....
... ... ... ........................ ... .. ...
~ u "" ~.~ ~~. .... ~iS
~ , .&:
I 0' .. :8 :8 ~ro-O cD :!is
....
,., .... .... .... ....
~ ... ... ... ........................ ... .. ...
~
Q I en en ,... en :8 ~~'"
.... - ~:;;. . , 10. :8.
en ' en . ....
I ~ 0 ~.. ..: ~N cD -:sI....
- ~ ~ .... - ~
~ .... ....
0 ~ ... ... ... ........................ ... .. ...
:s "'#. ~.~ ~~ - IOPg
r'-J. Q 8 t'I..... , . , .~ :o.~ .
I .. ci ci ro-ON '!j en:x~
~ ~ ~ .., ~
0 - - N
... ... ... ........................ ... .. ...
"'#. a.81 .... .... ,~ CD~CD
~ 8 ~8. ~. ;::.
I , .
.. ~ ~ ro-Oro-O ~ ~t;~
....
- ... ....
... ... ... ........................ ... .. ...
"" en en ....CD '" 6..~.
... .... ~~. . .~
I lD . GD
.. ci ci ,...;."..: :t ....~~
... ... ....
... ... ... ... ...
... ... ... ........................ ... .. ...
"'# a.a .... .... .! i.i~
I ~ ~~. . .
M ~. :t tti~ :t "'l=Ili
....
... .... ... ... ...
... ... ... ........................ ... .. ...
.
I ~liJ
~Jj~
I .:;;W);; ...
~ i.1 ;>! ;>! ~
0Ii!8000 ~
I 8.
I ~a
i - i ~ ~ ~
ij o~
i~.I~ ~
I rJ ~~
~I Il~IHH~ i~~ ~~
..... "S
lJJ ~ lJ~~J !~~ U~
I ...c~
- fill fill . . . .... ....1112... . . .
I
----------- ---- -------- -
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~
Q
='
~
~
~
~
-<
=
~
~
~
~
Q
.....
~
o
~
~ ~
>< ~
~ >-
~ ~
~ ~
~ ~
~
Co-'
~
~
~
I
=
~
='
Q
~
a
~
~
~
~
~
~
~
~
~
~
~
~
..0 1Y')Si!:U')U')'S!:.....
l;; l;;lSl;;l;; lS:;; :;;
~ ~~~~ ~g ~
""lilt.............,...,.....
~.~I~!i!I~.~
g g~~~~~~ ~
fftwtw................,.
g: . ~5!~:!!;::!iq:: '!:lI
..... 'r'~.........C5P") ;::
~ ~~~tosi~lQ g
...............,..........
~.~5!-fll~5!~.~
:s :SlS:s..._lSc> _
g g5i!'i8:if5i~ :e
.... .....U\N......u:; U)
.....,.,...,...............
N'N5!N5!N5!!i!'~
N ~;SN~NC5'6 ~
~ ~5i~~e5ig :if
CD COLnP') N~ .....
..................."'....
~'~1...~31~.~
. ..~.... N
~ ~5!1!?8~5!:::l _
CD CDU;...,.....C\lUl CD
..................w....
Fj'FjIFj!;I~.~
~ !~!~~~~ 5'
.........................
8 '818i~I!i'Fj
I" I"~.l::~~r; ~
.-........""ww..........
El~51~m~~~~'8
!~S~i:;;~~~ I
........,..,..,....",.......
!;!~~I~~!;!~; '51
~::i~~im5i~:; !
............."'.......,.,...
~.~2~r.n~2o.~
'" "'lS"'~l\jlS;S ...
ei ei!-eiC>ei~....: ...:
..... ..... .........~ M .....
~ ; co U">> ~
..w....._..............
I
>
. II
J. III
.1 ,. 111~
ilL II' 'I~s~
Ill) 111 IXlli
1~IIJIII~if
-................
a:s:gll!' , 'lI!~~:g
....~CDCil5 Ci5..........m
wi\ltog cir--:r--g
;:::;S~ ;SNN~
........ "'.,..... w...."
~:i....:::l2'~:::l............
._l(l...li'l .......~~l(l
~!~!fi i!f:g:s~
N N ~ ~ N
.............,.......M
CD~.................!i~....
~~:;::~ $Q::,:.:,....:;:
~I~~a a~:;;':;;~
N N .,.:.,.: <"i
.........................
I
>
. IJ
J- II~
J 1 ' 1111
jlL jli j~~.
. 1110. ...II!
dUHIUH
........."$lAlIi
............619
.. 1Wt.,.........
....,.........,.
.,.....,.......""
...wttlttft.....
........,...."..
..,..............
... ilI/t...".... M
....,...........
.................
tit........,.""...
l
IL
j
S
~
I 1
~ ~
..J .
!~jflj
jl~Jif
..SO.lIIRK
~ ~
~""'c
.~ ~
~ ~
~~
~.~
=::s
.st::)
....
==
~
C
t-..
....
~
~
f
~ ~
o~
lU
~~
o~
.... .a
U~