HomeMy WebLinkAboutItem #12 Presentation on Utilities Department Sufficiency of Revenues and Ocoee Water Resource Strategy; and Seek Approval to move Forward on Securing Financing of Phase II SR 50 Widnening and Western Wastewater Transmission Main/Downtown Sewer Projects,/
I V k :/
OCO(?(?
florlda
AGENDA ITEM COVER SHEET
Meeting Date: April 15, 2014
Contact Name:
Contact Number
Item # � p�
Reviewed By.
Charles K. Smith, P.E Department Director: Charles
407 - 905 -3159
City Manager:
Robert Fran
Subject: Presentation on Utilities Department Sufficiency of Revenues Ind Ocoee Water
Resource Strategy; and seek approval to move forward on securing Financing of Phase II State
Road 50 Wideninq and Western Wastewater Transmission Mai /Downtown Sewer Projects
Background Summary:
The City of Ocoee Utilities Department maintains a detailed asset management plan that is comprised of 10-
year maintenance programs for lift station, water plants, wastewater plant, equipment and vehicles. The
programs inventories and schedules maintenance /rehabs /replacement. In addition, the department maintains a
10 Year Capital Improvement Program (C.I.P.) and an associated 10 Year Staffing Levels. These plans
forecast expectation levels of expenditure for the next 10 years. Using the plans and historical needs
(personnel, energy, contract service, chemicals, etc.) a detailed expenses profile has been generated.
Using the services of Public Resources Management Group, Inc. (PRMG) a detailed Revenue to Expense
Model was developed. The model broadens to cover not only the expenditure profile, current and future
revenues, existing fund balances, present and future debt service payment, expenditures not covered by plans
above and growth projections to forecast the financial viability of the Utilities Department. The model is
dynamic which is capable of analyzing "what if scenarios ".
The result of the model reported by PRMG dated May 21 2013 using the outlined expense above the current
revenues are sufficient for a five (5) year period The model includes a future debt service payment to cover
financing $10.3 million for the State Road 50 Widening Phase II Project and Ocoee West Wastewater
Transmission System Project/Initial Downtown Sanitary Sewer Project. At the end of this discussion, staff will
be seeking authorization to move forward in determining the terms and methods of financing these projects.
An important element of the C.I.P. plan which was integral within the model was a $0.5 million ($1.0 total) per
year commitment for the replace /upgrading of the existing potable water distribution system and further
maturing of the City reclaimed water system.
The City's current direction to meet the present and future water supply demands has been to extend the
reclaimed water distribution system. Increase in reclaimed water usage directly offsetting potable
(groundwater) shall make the offset potable water available for future demands. Staff and PRMG will be
available to outline possible steps to increase funding needed to increase commitment to annual funding levels
for reclaimed water projects.
Issue:
Staff will present an update to the Utilities Departments Revenue Sufficiency and Ocoee Water Resource
Strategy; and seek approval to move forward on securing Financing of Phase II State Road 50 Widening and
Western Wastewater Transmission Main /Downtown Sewer Projects.
Recommendations
Motion to Authorize City Manager to seek funding alternative for the Phase II of the State Road 50 Widening
and Western Wastewater Transmission Main /Downtown Sewer Projects.
Attachments:
Financial Forecast Summary Memorandum
Financial Impact:
There is no direct financial impact by this item.
Type of Item: (please mark with an `k')
Public Hearing
Ordinance First Reading
Ordinance Second Reading
Resolution
x Commission Approval
Discussion & Direction
For Clerk's Dept Use:
Consent Agenda
Public Hearing
Regular Agenda
Original Document/Contract Attached for Execution by City Clerk
Original Document/Contract Held by Department for Execution
Reviewed by City Attorney
Reviewed by Finance Dept.
Reviewed by Q
N/A
N/A
N/A
2
PUBLIC RESOURCES MANAGEMENT GROUP, INC.
Utility, Rate, Financial and Management Consultants
341 N. Maitland Avenue, Suite 300, Maitland, FL 32751
19 Telephone (407) 628 -2600 • Fax(407)628-2610
E -mail prmg@pringinc.com
prmginc.com
Transmittal Memorandum
To:
Charles Smith
CC:
Robert Briggs
From:
Henry Thomas & Shawn Ocasio
Date:
8/27/2013
Subject:
Financial Forecast Results
Dear Mr. Smith:
Based on our scope of services to update the City of Ocoee's Water and Wastewater Financial
Forecast, we have completed a series of tasks including: 1) a customer growth and revenue
forecast; 2) a capital improvement plan funding analysis; and 3) an overall revenue sufficiency
analysis to estimate the adequacy of the City's existing utility system water, wastewater and
reclaimed water rates.
This memorandum summarizes the results of the updated Financial Forecast including our
assumptions, analyses, conclusions and recommendations and is submitted for your review and
consideration.
Assumptions & Analyses:
1) Projected revenues from existing rates for the Water and Wastewater Systems (the
"System ") were based on the schedule of rates and charges reflected in the currently
adopted rate resolution. In order to calculate projected revenues from rates for the
Forecast Period, PRMG applied the rates to an estimate of the fiscal year 2012 billing
statistics. Based on discussions with Staff and current development information, this
analysis recognizes an average growth in water and wastewater customer accounts of
approximately 1.7% (or approximately 130 to 190 accounts) per year and an average
annual growth in reclaimed water accounts of approximately 15.6% (or 600 accounts)
throughout the forecast period. The increase in reclaimed water accounts assumes
expansion of the reclaimed water system. System rate revenues are estimated to grow
from approximately $8.5 to $9.6 million per year.
2) Other System revenues (late charges, penalties, etc.) are assumed to be fairly constant at
approximately $490,000 per year throughout the forecast period and interest earnings on
K:Al202.City of OcoeeA03.Utility Rate & Cost of Service Study \Reports \Status Memorandum
Mr. Charles Smith
Fiscal Year 2013 Financial Forecast Results
August 27, 2013
unrestricted funded balances are estimated at approximately $70,000 per year based on
projected fund balances and an interest rate ranging from 0.50% to 0.75 %.
3) The Fiscal Year 2013 Operating Budget, as adopted by the City, served as a base line for
the expenditure projections for the remainder of the Forecast Period (Fiscal Years 2013
through 2017). Adjustments were made to the Fiscal Year 2013 Operating Budget to
exclude renewal and replacement transfers, principal and interest payments on debt, and
capital expenses which were all accounted for separately in our analysis in order to
estimate cash operating expense levels. These adjustments resulted in the Operating
Budget of $8.7 million being adjusted down to approximately $5.1 million to reflect cash
operating expenses.
4) A contingency allowance of one percent (1.0 %) of operation and maintenance expense
was recognized in each fiscal year for each utility system. This allowance increases the
budgeted revenue requirements of the System by approximately $54,000 annually during
the Forecast Period and is included as an operating expense for the System.
5) Projected operation and maintenance expenses have been escalated by an annual average
of approximately 4.2% per year from Fiscal Year 2013 levels based upon several
escalation factors and the nature of the expense as shown below:
• Labor: 3% per year
• Health Insurance, Property & Liability Insurance: 4 -5% per year
• Utilities and Fuel: 5% per year plus growth in annual flows
• Repairs & Maintenance: 4% per year
• Reclaimed Water Purchase Costs: 3% per year plus growth in annual flows
• Consumer Price Index: Approx. 2% per year (Based on projections prepared by
the Congressional Budget Office)
6) Based on the debt service schedules for the currently outstanding bonds, the annual debt
service payments to be funded from rates are approximately $1.3 million per year.
7) The Capital Improvement Plan ( "CIP ") utilized in this analysis was based on the Fiscal
Year 2013 — 2017 Capital Plan as provided by the City. The City's plan includes
approximately $23.7 million in improvements, renewals & replacements, and upgrades.
The Financial Forecast analysis assumes that the anticipated CIP will be fully funded
through rate revenues, cash reserves, impact fees, additional debt and will be expended
during the forecast period.
8) An additional loan is anticipated to fund an estimated $10.2 million of reclaimed water
and other projects. The detailed loan assumptions are shown below:
• Construction Project Amount - $10.2 million
• Total Principal (Incl. Issuance Costs and Debt Service Reserve) - $10.3 million
• Term (Years) — 30
o Annual Interest Rate — 4.39%
o Estimated Annual Payment - $626,000
K:A 1202.0ty of OcoceA03.Utility Rate & Cost of Service Study \Reports \Status Memorandum
Mr. Charles Smith
Fiscal Year 2013 Financial Forecast Results
August 27, 2013
9) Renewal and replacement transfers from revenues are estimated at approximately
$660,000 per year for the combined water and wastewater system.
10) Annual administrative transfers from revenues are estimated to grow from approximately
$1.4 million to $1.7 million per year for the combined water and wastewater system.
Conclusions and Recommendations:
Based on the projected operating expenditure needs of the System and the projected funding plan
for the capital improvement program, it is estimated that the current rates will not be sufficient to
meet such needs and that the rates for monthly utility service will continue to need to be indexed
for inflation in accordance with the City's rate ordinance. The Financial Forecast recognizes
annual rate index increases of 3.0% per year during the Forecast Period. Below is a summary of
the projected rate increases along with a summary of the projected financial results they are
estimated to produce.
Summary of Projected Rate Adjustments and Operating Results
Senior Lien Debt Service
Coverage W/O System
Development Charges
(Min 1.00) 1.31 1.51 1.64 1.78 1.89
Senior Lien Debt Service
Coverage W/ System
Development Charges
(Min 1.10) 1.48 1.84 1.98 2.12 2.23
[1] Index amounts based on the City's rate ordinance which allows for a 3.0 % minimum increase or the change in the Consumer
Price Index if greater than 3 %.
12] Rates were adjusted at the beginning of Fiscal Year 2013 by 3.0% for the water and wastewater systems.
The detailed schedules prepared in conjunction with the Financial Forecast are attached.
K:Al202.City of0coeeA03.Uti1ity Rate & Cost ofService Study \Reports \Status Memorandum
Fiscal Year Ending September 30,
Description
2013
2014
2015
2016
2017
Combined System
Rate Increases [1]
N/A [2]
3.0%
3.0%
3.0%
3.0%
Combined System Net Cash
Flow Surplus / (Deficiency)
($394,281)
$433,363
$274,569
$635,399
$940,934
Operating Account
(Ending Balance)
$8,418,433
$8.494,396
$8,013,612
$7,878,817
$7,884,997
Min. Balance Policy (2yrs of
Debt Service plus 25% of O &M)
$6,054,904
$6,221,819
$6,363,513
$6,495,294
$6,699,275
Achieved (Yes/No)
Yes
Yes
Yes
Yes
Yes
Senior Lien Debt Service
Coverage W/O System
Development Charges
(Min 1.00) 1.31 1.51 1.64 1.78 1.89
Senior Lien Debt Service
Coverage W/ System
Development Charges
(Min 1.10) 1.48 1.84 1.98 2.12 2.23
[1] Index amounts based on the City's rate ordinance which allows for a 3.0 % minimum increase or the change in the Consumer
Price Index if greater than 3 %.
12] Rates were adjusted at the beginning of Fiscal Year 2013 by 3.0% for the water and wastewater systems.
The detailed schedules prepared in conjunction with the Financial Forecast are attached.
K:Al202.City of0coeeA03.Uti1ity Rate & Cost ofService Study \Reports \Status Memorandum
Mr. Charles Smith
Fiscal Year 2013 Financial Forecast Results
August 27, 2013
Additional Considerations:
During the course of performing the Financial Forecast PRMG also briefly reviewed the City's
reclaimed water rates with City Staff. This review found that, while the City's current tiered
reclaimed rates do promote some conservation, there could be certain modifications made in the
future to the rate structure that would provide a better incentive for reclaimed water conservation
in the higher usage blocks. We recommend that the City consider revising its reclaimed rate
structure in the future in order to continue to promote the responsible usage of this resource.
K:Al202.City of OcoeeA03.Utility Rate & Cost of Service Study \Reports \Status Memorandum
City of Ocoee, Florida
1INN ��� 2013 Utility Revenue Sufficiency Analysis
0( List of Tables and Figures 1B
f'.0d.
Table
No. Table Name
1 Projected Net Revenue Requirements - Water System
2 Projected Net Revenue Requirements - Wastewater System
3 Projected Net Revenue Requirements of the Utility System
4 Projected Operating Results and Debt Service Coverage Analysis
5 Development of Fund Balances and Interest Income for the Utility System Funds
6 Allocation of Operating Expenses to Individual Systems
7 Expense Allocation References
8 Expense Escalation Factors for Operating Expenses for Cost of Operation and Maintenance (Operating Expenses)
9 Projected Cost of Operation and Maintenance (Operating Expenses) - Water System
10 Projected Cost of Operation and Maintenance (Operating Expenses) - Wastewater System
11 Projected Cost of Operation and Maintenance (Operating Expenses) - Combined System
12 Calculation of Administrative Transfer Out
13 Summary of Renewal and Replacement Fund Transfer
14 Five -Year Estimated Utility Capital Improvements Program
Figure
No. Figure Name
Performance Metrics & Dashboards
Page I of2
Table 1
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Net Revenue Requirements - Water System
Line
$0
$0
Fiscal Year Ending September 30,
$0
No.
Description
2013
2014
2015
2016
2017
$4,165,136
Operating Expenses
72,285
225,331
185,467
169,966
$6,708
1
Water and Wastewater Administration Fund (53 1)
$430,478
$442,730
$455,848
$469,260
$483,225
2
Water Utilities Facilities (533)
871,840
906,911
944,707
980,010
1,017,174
3
Water Utility Operating (533.1)
1,372,967
1,408,999
1,447,058
1,486,397
1,527,286
4
Administrative Transfers Allocated to the Water System
[I] 709,400
756,700
794,400
832,400
871,800
5
Total Operating Expenses
$3,384,685
$3,515,339
$3,642,012
$3,768,067
$3,899,486
Other Revenue Requirements
$459,783
$460,146
$475,840
$477,272
6
Debt Service Requirement - Series 2003 Bonds
$170,733
$170,262
$169,698
$170,116
$170,333
7
Debt Service Requirement - Series 2008 Note
10,565
0
0
0
0
8
Debt Service Requirement - Series 2010 Note
168,266
169,599
170,382
170,625
0
9
Debt Service Requirement - Series 2012 Note
71,046
79,782
81,514
80,914
265,226
10
Debt Service Requirement - Series 2013 Bonds
[2] 75,042
75,042
75,042
75,042
75,042
11
Total Debt Service Requirements
$495,651
$494,685
$496,635
$496,697
$510,600
12 Transfer to Revenue Fund
13 Transfer to R &R Fund
14 Capital Funded from Rates
15 Total Other Revenue Requirements
16 Gross Revenue Requirements
Less Income and Funds from Other Sources
17 Other Operating Revenue
18 Transfer from Revenue Fund
19 Interest Income
20 Net Water System Development Fees Applied to Debt
21 Total Other Income and Funds From Other Sources
22 Net Revenue Requirements
Revenue from Water Rates
23 Revenue from Rates Effective October 1, 2012
24 Revenue From Prior Year Rate Index /Adjustments
25 Total Rate Revenue Before Current Year Adjustments
26 Revenue Surplus /Deficiency Under Existing Rates
27 Percent
Current Year Rate Index Adjustment
28 Current Year Rate Index Adjustment
Effective Month
29 % of Current Year Effective
30 Total Revenue From Current Year Adjustments
Current Year Rate Adjustments
31 Current Year Rate Adjustment
Effective Month
32 % of Current Year Effective
33 Total Revenue From Current Year Adjustments
34 Total Revenue From Rates
35 Revenue Surplus /(Deficiency)
Footnotes on Page 2.
0.0%
Oct.
100.00%
$0
$0
$0
$0
$0
[3]
300,000
315,114
329,372
343,146
356,256
$4,165,136
99,218
72,285
225,331
185,467
169,966
$6,708
$399,218
$387,399
$554,703
$528,613
$526,222
$4,279,554
$4,397,423
$4,693,350
$4,793,377
$4,936,308
$362,853
$378,553
$379,946
$382,550
$385,262
0
0
0
0
0
34,070
31,230
30,200
43,290
42,010
20,000
50,000
50,000
50,000
50,000
$416,923
$459,783
$460,146
$475,840
$477,272
$3,862,631
$3,937,640
$4,233,205
$4,317,537
$4,459,036
[4]
$3,804,592
$3,865,858
$3,926,026
$3,957,295
$3,989,730
[5]
0
0
117,800
241,000
370,000
$3,804,592
$3,865,858
$4,043,826
$4,198,295
$4,359,730
($58,039)
($71,783)
($189,379)
($119,242)
($99,307)
(1.5 %)
(1.9 %)
(4.7 %)
(2.8 %)
(2.3 %)
[6]
0.0%
3.0%
3.0%
3.0%
3.0%
Oct.
Oct.
Oct.
Oct.
Oct.
100.00%
100.00%
100.00%
100.00%
100.00%
$0
$115,980
$121,310
$125,950
$130,790
0.0%
Oct.
100.00%
0.0%
Oct.
100.00%
0.0%
Oct.
100.00%
0.0%
Oct.
100.00%
0.0%
Oct.
100.00%
$0
$0
$0
$0
$0
$3,804,592
$3,981,838
$4,165,136
$4,324,245
$4,490,520
[7] ($58,039)
$44,197
($68,069)
$6,708
$31,483
Page 2 of 2
'fable 1
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Net Revenue Requirements - Water System
Footnotes:
[1] Administrative transfers are based on a cost allocation that includes among other costs: i) a portion of the costs for the utility counter, it) an allocation
o1'salaries costs for some City engineers, iii) an allocation of mowing costs incurred by the public works department, and iv) a transfer equal to 12.0%
of Gross Rate Revenues.
[2] Amount includes anticipated additional debt allocated to the Water System estimated to be issued during the forecast period reflected above. The
additional debt includes the following assumptions:
Principal Amount of Bonds (Rounded) $10,335,000
Term -Years 30
Interest Rate 4.39%
First Year of Bond Term (Fiscal Year) 2013
Average Annual Payment $626,295
Allocation to Water System 11.98%
[3] The annual Renewal and Replacement Fund transfers and the corresponding percentage of the estimated previous year gross revenues are
as follows:
Projected Fiscal Year Ending September 30,
2013 2014 2015 2016 2017
'total Estimated Prior Year Gross Revenues - Water System $4,025,734 $4,201,515 $4,391,621 $4,575,281 $4,750,085
Renewal and Replacement Fund'1'ransfer- Water System $300,000 $315,114 $329,372 $343,146 $356,256
As a Percentage of Prior Year Gross Revenues T45% 7.50% 7.50% 7.50% 7.50%
[4] Revenue reflects an adjustment (reduction of revenue) due to the fact that some of the irrigation customers class codes (IR 50) and (1R77) are expected to
become part of the reclaimed water system during the Forecast Period. The revenue generated by these customers will be accounted for on the Wastewater
System.
[5] Amounts include revenues from rate adjustments estimated during the forecast period and prior to the current year shown.
[6] Index adjustment as set forth in the City's code of Ordinances (greater of 3.0% or the percentage increase in the Consumer Price Index as published by
the U.S. Department of Labor Bureau of Labor Statistics from January I to December 31 of the previous calendar year). For the forecast period it has
been assumed that the CPI index applied to rates every October I equals 3.0% per annum.
[7] Projected revenue surpluses are available for capital improvements and other lawful purposes. Projected deficiencies are funded from available reserves.
Page 1 of 2
Table 2
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Net Revenue Requirements - Wastewater Svstem
Line Fiscal Year Ending September 30,
No. Description 2013 2014 2015 2016 2017
Operating Expenses
I Water and Wastewater Administration Fund (53 1)
2 Wastewater Utility Facility (535)
3 Wastewater Utility Operating (535.1)
4 Admin. Transfers Allocated to the W/Water System
5 Total Operating Expenses
Other Revenue Requirements
6 Debt Service Requirement - Series 2003 Bonds
7 Debt Service Requirement - Series 2008 Note
8 Debt Service Requirement - Series 2010 Note
9 Debt Service Requirement - Series 2012 Note
10 Debt Service Requirement - Series 2013 Bonds
I 1 Total Debt Service Requirements
12 Transfer to Revenue Fund
13 Transfer to R &R Fund
14 Capital Funded from Rates
15 Total Other Revenue Requirements
16 Gross Revenue Requirements
$301,815
$311,818
$321,797
$332,044
$342,828
1,302,595
1,395,967
1,470,347
1,545,804
1,629,009
779,240
805,431
833,613
862,956
893,763
[1] 709,400
756,700
794,400
832,400
871,800
$3,093,050
$3,269,917
$3,420,158
$3,573,204
$3,737,400
$618,805
$617,100
$615,052
$616,571
$617,355
12,632
0
0
0
0
201,187
202,782
203,718
204,008
0
84,946
95,392
97,462
96,745
317,118
[2] 551,253
551,253
551,253
551,253
551,253
$1,468,824
$1,466,527
$1,467,486
$1,468,578
$1,485,726
$0
$0
$0
$0
$0
[3] 549,120
242,163
267,907
285,826
304,313
118,500
40,365
268,327
179,965
97,368
$667,620
$282,528
$536,234
$465,791
$401,681
$5,229,493
$5,018,972
$5,423,878
$5,507,573
$5,624,807
Less Income and Funds from Other Sources
Net Revenue Requirements
$5,035,471
$4,826,575
$5,233,306
17 Other Operating Revenue
$109,092
$112,027
$112,472
$112,929
$113,396
18 Transfer from CRA
0
0
0
0
0
19 Transfer from Revenue Fund
0
0
0
0
0
20 Interest Income
34,930
30,370
28,100
38,610
34,890
21 Net W/Water System Development Fees Applied to Debt
50,000
50,000
50,000
50,000
50,000
22 Total Other Income and Funds From Other Sources
$194,022
$192,397
$190,572
$201,539
$198,286
23
Net Revenue Requirements
$5,035,471
$4,826,575
$5,233,306
$5,306,034
$5,426,520
0
Revenue from Existing Rates
24
W /water Rate Rev. from Rates Effective Oct. I, 2012
$3,594,612
$3,657,680
$3,722,285
$3,788,472
$3,856,292
25
Reclaimed Rate Rev. from Rates Effective Oct. 1, 2012
[4]
1,104,618
1,406,150
1,533,549
1,642,593
1,773,138
26
Revenue From Prior Year Rate Index /Adjustments
[5]
0
0
157,700
330,800
522,000
27
Total Rate Revenue Before Current Year Adjustments
$4,699,229
$5,063,831
$5,413,534
$5,761,865
$6,151,430
28
Revenue Surplus /Deficiency Under Existing Rates
($336,242)
$237,256
$180,228
$455,832
$724,910
29
Percent
(7.2 %)
4.7%
3.3%
7.9%
11.8%
Current Year Rate Index Adjustment
30
Current Year Rate Index Adjustment
[6]
0.0%
3.0%
3.0%
3.0%
3.0%
Effective Month
Oct.
Oct.
Oct.
Oct.
Oct.
31
% of Current Year Effective
100.00%
100.00%
100.00%
100.00%
100.00%
32
Total Revenue From Current Year Adjustments
$0
$151,910
$162,410
$172,860
$184,540
Current Year Rate Adiustmcnts
33
Current Year Rate Adjustment
0.0%
0.0%
0.0%
0.0%
0.0%
Effective Month
Oct.
Oct.
Oct.
Oct.
Oct.
34
% of Current Year Effective
100.00%
1 00.00%
100.00%
100.00%
100.00%
35
Total Revenue From Current Year Adjustments
$0
$0
$0
$0
$0
36
Total Revenue From Rates
$4,699,229
$5,215,741
$5,575,944
$5,934,725
$6,335,970
37
Revenue Surplus /(Deficiency)
[7]
($336,242)
$389,166
$342,638
$628,692
$909,450
Footnotes on page 2.
Page 2 of 2
Table 2
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Pru*ected Net Revenue Requirements - Wastewater SVStem
Footnotes:
[ 1] Administrative transfers are based on a cost allocation that includes among other costs: if a portion of the costs for the utility counter, ii) an allocation
of salaries costs for some City engineers, in) an allocation of mowing costs incurred by the public works department, and iv) a transfer equal to 12.0%
of Gross Rate Revenues.
[2] Amount includes anticipated additional debt allocated to the Wastewater System estimated to be issued during the forecast period reflected above. The
additional debt includes the following assumptions:
Principal Amount of Bonds (Rounded) $10,335,000
Term -Years 30
Interest Rate 439%
First Year of Bond Tenn (Fiscal Year) 2013
Average Annual Payment $626,295
Allocation to Wastewater System 88.02%
13] The annual Renewal and Replacement Fund transfers and the corresponding percentage of the estimated previous year gross revenues are
as follows:
Projected Fiscal Year Ending September 30,
2013 2014 2015 2016 2017
Total Estimated Prior Year Gross Rev. - Wastewater System $4,470,848 $4,843,251 $5,358,138 $5,716,516 $6,086,264
Renewal and Replacement Fund Transfer- W /water System $549,120 $242,163 $267,907 $285,826 $304,313
As a Percentage of Prior Year Gross Revenues 12.28% 5.00% 5.00% 5.00% 5.00%
[4] Revenue reflects an adjustment (increase of revenue) due to the fact that some of the irrigation customers class codes (IR 50) and (IR77) are expected to
become part of the reclaimed water system during the Forecast Period. The revenue generated by these customers will be accounted for as part of the
miscellaneous revenues on the Wastewater System.
[5] Amounts include revenues from rate adjustments estimated during the forecast period and prior to the current year shown.
[6] Index adjustment as set forth in the City's code of Ordinances (greater of 3.0% or the percentage increase in the Consumer Price Index as published by
the U.S. Department of Labor Bureau of Labor Statistics from January 1 to December 31 of the previous calendar year). For the forecast period it has
been assumed that the CPI index applied to rates every October I equals 3.0% per annum.
[7] Projected revenue surpluses are available for capital improvements and other lawful purposes. Projected deficiencies are funded from available reserves.
Page I oft
Table 3
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Protected Net Revenue Requirements of the Utility Svstem
Line
Current Year Rate Index Adjustment
Fiscal Year Ending September 30,
No.
Description
2013
2014
2015
2016
2017
3.0%
Cost ol'Operation and Maintenance (Operating Expenses)
3.0%
3.0%
Effective Month
1
Water and Wastewater Administration Fund (53 1)
$732,293
$754,549
$777,645
$801,304
$826,053
2
Water Utilities Facilities (533)
871,840
906,911
944,707
980,010
1,017,174
3
Water Utility Operating (533.1)
1,372,967
1,408,999
1,447,058
1,486,397
1,527,286
4
Wastewater Utility Facility (535)
1,302,595
1,395,967
1,470,347
1,545,804
1,629,009
5
Wastewater Utility Operating (535.1)
779,240
805,431
833,613
862,956
893,763
6
Administrative Transfers
[1] 1,418,800
1,513,400
1,588,800
1,664,800
1,743,600
7
Total Operating Expenses
$6,477,735
$6,785,257
$7,062,170
$7,341,270
$7,636,885
100.00%
Other Revenue Requirements
100.00%
100600%
36
Total Revenue From Current Year Adjustments
8
Debt Service Requirement - Series 2003 Bonds
$789,538
$787,363
$784,750
$786,688
$787,688
9
Debt Service Requirement - Series 2008 Note
23,197
0
0
0
0
10
Debt Service Requirement - Series 2010 Note
369,453
372,381
374,101
374,634
0
11
Debt Service Requirement - Series 2012 Note
155,992
175,174
178,976
177,660
582,344
12
Debt Service Requirement - Series 2013 Bonds
[2] 626,295
626,295
626,295
626,295
626,295
13
Debt Service Requirement - Available Debt Issue 2
0
0
0
0
0
14
Debt Service Requirement - Available Debt Issue 3
0
0
0
0
0
15
Total Debt Service Requirements
$1,964,474
$1,961,212
$1,964,121
$1,965,276
$1,996,326
16
Transfer to Revenue Fund
$0
$0
$0
$0
$0
17
Transfer to R &R Fund
[3] 849,120
557,276
597,278
628,972
660,570
18
Capital Funded from Rates
217,718
112,650
493,659
365,432
267,333
19
Total Other Revenue Requirements
$1,066,838
$669,926
$1,090,937
$994,404
$927,903
20
Gross Revenue Requirements
$9,509,047
$9,416,395
$10,117,229
$10,300,950
$10,561,114
Less Income and Funds from Other Sources
21
Other Operating Revenue
$471,945
$490,580
$492,418
$495,479
$498,658
22
Transfer from Revenue Fund (Use of Reserves)
0
0
0
0
0
23
Interest Income
69,000
61,600
58,300
81,900
76,900
24
Net System Development Fees Applied to Debt
70,000
100,000
100,000
100,000
100,000
25
Total Other Income and Funds From Other Sources
$610,945
$652,180
$650,718
$677,379
$675,558
26
Net Revenue Requirements
$8,898,102
$8,764,215
$9,466,511
$9,623,571
$9,885,556
Revenue from Water, Reclaimed and Wastewater Rates
27 Revenue from Rates Effective Fiscal Year 2013 [4] $8,503,821 $8,929,688 $9,181,859
28 Revenue From Prior Year Rate Index /Adjustments [5] 0 0 275,500
29 Total Rate Revenue Before Current Year Adjustments $8,503,821 $8,929,688 $9,457,359
30 Revenue Surplus /Deficiency Under Existing Rates
($394,281) $165,473 ($9,151)
$9,388,360 $9,619,160
571,800 892,000
$9,960,160 $10,511,160
$336,589 $625,604
Foolnoles on page 2
Current Year Rate Index Adjustment
31
Current Year Rate Index Adjustment
[6]
0.0%
3.0%
3.0%
3.0%
3.0%
Effective Month
Oct.
Oct.
Oct.
Oct.
Oct.
32
% of Current Year Effective
100.00%
100.00%
100.00%
100.00%
100.00%
33
Total Revenue From Current Year Adjustments
$0
$267,890
$283,720
$298,810
$315,330
Current Year Rate Adjustments
34
Current Year Rate Adjustment
[6]
0.0%
0.0%
0.0%
0.0%
0.0%
Effective Month
Oct.
Oct.
Oct.
Oct.
Oct.
35
% of Current Year Effective
100.00%
100.00%
100.00%
100.00%
100600%
36
Total Revenue From Current Year Adjustments
$0
$0
$0
$0
$0
37
Total Revenue From Rates
$8,503,821
$9,197,578
$9,741,079
$10,258,970
$10,826,490
38
Revenue Surplus /(Deficiency)
[7]
($394,281)
$433,363
$274,569
$635,399
$940,934
Foolnoles on page 2
Page 2 o f 2
Table 3
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Proiccted Net Revenue Requirements of the Utility System
Footnotes:
[1] Administrative transfers are based on a cost allocation that includes among other costs: i) a portion of the costs for the utility counter; ii) an allocation
of salaries costs for some City engineers; iii) an allocation of mowing costs incurred by the public works department; and iv) a transfer equal to 12.0%
of Gross Rate Revenues.
[2] Amount includes anticipated additional debt allocated to the System estimated to be issued during the forecast period reflected above. 'file
additional debt includes the following assumptions:
Principal Amount of Bonds (Rounded) $10,335,000
Term Years 30
Interest Rate 4.39%
First Year of Bond Term (Fiscal Year) 2013
Average Annual Payment $626,295
Allocation to Water System 11.98%
Allocation to Wastewater System 88.02%
[3] The annual Renewal and Replacement Fund transfers and the corresponding percentage of the estimated previous year gross revenues are as follows:
Transfer for the Water R &R Fund
Total Estimated Prior Year Gross Revenue - Water System
Renewal and Replacement Fund Transfer - Water System
As a Percentage of Prior Year Gross Revenue
Projected Fiscal Year Ending September 30,
2013
2014
2015
2016
2017
$4,025,734
$4,201,515
$4,391,621
$4,575,281
$4,750,085
$300,000
$315,114
$329,372
$343,146
$356,256
7.45%
7.50%
7.50%
7.50%
7.50%
Transfer for the Wastewater R &R Fund
Total Estimated Prior Year Gross Rev. - W /water System
Renewal and Replacement Fund Transfer - W /water System
As a Percentage of Prior Year Gross Revenue
[4] Revenues reflect anticipated increase of revenues for the Reclaimed System due to: i) irrigation customers class codes (IR 50) and (IR77) expected
to become part of the Reclaimed System during the Forecast Period; and ii) anticipated revenue from retrofits.
[5] The revenue shown reflects the revenue expected to be generated by rate adjustments (indexes) of 3.0% effective each October Isl. as set forth in the
City's code of Ordinances (greater of 3.0% or the percentage increase in the Consumer Price Index as published by the U.S. Department of Labor
Bureau of Labor Statistics from January 1 to December 31 of the previous calendar year). For the forecast period it has been assumed that the CPI
index applied to rates every October I equals 3.0% per annum. Amounts also include revenues from rate adjustments estimated during the Forecast
Period.
[6] Percentage is inclusive of both the index adjustment and the forecasted adjustments.
[7] Projected revenue surpluses are available for capital improvements and other lawful purposes. Projected deficiencies are funded from available
reserves.
Projected Fiscal Year Ending September 30,
2013
2014
2015
2016
2017
$4,470,848
$4,843,251
$5,358,138
$5,716,516
$6,086,264
$549,120
$242,163
$267,907
$285,826
$304,313
12.28%
5.00%
5.00%
5.00%
5.00%
[4] Revenues reflect anticipated increase of revenues for the Reclaimed System due to: i) irrigation customers class codes (IR 50) and (IR77) expected
to become part of the Reclaimed System during the Forecast Period; and ii) anticipated revenue from retrofits.
[5] The revenue shown reflects the revenue expected to be generated by rate adjustments (indexes) of 3.0% effective each October Isl. as set forth in the
City's code of Ordinances (greater of 3.0% or the percentage increase in the Consumer Price Index as published by the U.S. Department of Labor
Bureau of Labor Statistics from January 1 to December 31 of the previous calendar year). For the forecast period it has been assumed that the CPI
index applied to rates every October I equals 3.0% per annum. Amounts also include revenues from rate adjustments estimated during the Forecast
Period.
[6] Percentage is inclusive of both the index adjustment and the forecasted adjustments.
[7] Projected revenue surpluses are available for capital improvements and other lawful purposes. Projected deficiencies are funded from available
reserves.
Page I of 5
Table 4
City of Ococe, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Operating Results and Debt Service Coverage Analvsis
Line
No. Description
System Revenues:
Sales Revenues
1 Water - Existing Rate Revenues
2 Wastewater - Existing Rate Revenues
3 Reclaimed Water - Existing Rate Revenues
4 Revenue from Rate Adjustments
5 Total Sales Revenues Water and Wastewater
6 Other Operating Revenues
7 Unrestricted Interest Income
8 Total System Revenues
Cost of Operation and Maintenance (Operating Expenses):
9 Water System
10 Wastewater System
11 Administrative Transfer
12 Total Operating Expenses
13 Net Revenues Available for Debt Service Coverage
14 All in Debt Service Coverage - Calculated
15 All in Debt Service Coverage - Target
TEST (a)
Debt Service Coverage Test (a) - 100%
16 Net Revenue Available for Debt Service Coverage
Bond Service Requirement - Senior Lien Debt
17 Debt Service Requirement - Series 2003 Bonds
18 Debt Service Requirement - Series 2008 Note
19 Debt Service Requirement - Series 2010 Note
20 Debt Service Requirement - Series 2012 Note
21 Debt Service Requirement - Series 2013 Bonds
24 Total Bond Service Requirement - Senior Lien Debt
25 Coverage Ratio - Calculated
26 Coverage Ratio - Required
Fiscal Year Ending September 30,
2013 2014 2015 2016 2017
[1] $3,804,592
$3,865,858
$3,926,026
$3,957,295
$3,989,730
[1] 3,594,612
3,657,680
3,722,285
3,788,472
3,856,292
[1] [21 1,104,618
1,406,150
1,533,549
1,642,593
1,773,138
[3] 0
267,890
559,220
870,610
1,207,330
$8,503,821
$9,197,578
$9,741,079
$10,258,970
$10,826,490
[41 471,945
490,580
492,418
495,479
498,658
69,000
61,600
58,300
81,900
76,900
$9,044,766
$9,749,758
$10,291,797
$10,836,349
$11,402,048
[51
$2,675,285
$2,758,639
$2,847,612
$2,935,667
$3,027,686
2,383,650
2,513,217
2,625,758
2,740,804
2,865,600
[61 1,418,800
1,513,400
1,588,800
1,664,800
1,743,600
$6,477,735
$6,785,257
$7,062,170
$7,341,270
$7,636,885
$2,567,031
$2,964,502
$3,229,627
$3,495,079
$3,765,163
1.31
1.51
1.64
1.78
1.89
1.50
1.50
1.50
1.50
1.50
[7]
$2,567,031
$2,964,502
$3,229,627
$3,495,079
$3,765,163
$789,538
$787,363
$784,750
$786,688
$787,688
23,197
0
0
0
0
369,453
372,381
374,101
374,634
0
155,992
175,174
178,976
177,660
582,344
181 626,295
626,295
626,295
626,295
626,295
$1,964,474
$1,961,212
$1,964,121
$1,965,276
$1,996,326
131%
151%
164%
178%
189%
100%
100%
100%
100%
100%
27 Net Revenues After Paying Bond Service Requirement $602,557 $1,003,289 $1,265,506 $1,529,803 $1,768,837
Pale 2 of 5
Table 4
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Operating Results and Debt Service Coverage Analysis
Line
No. Description
- -AND --
TEST (b)
Debt Service Coverage Test (b) - 110%
Fiscal Year Ending September 30,
2013 2014 2015 2016 2017
[7]
28 Net Revenue Available for Debt Service Coverage
29 Sewer System Development Charges Recognized
30 Water System Development Charges Recognized
Net Revenue Available for Debt Service Coverage Including
31 System Development Charges Recognized
32 Coverage Ratio - Calculated
33 Coverage Ratio - Required
Other Recognized Transfers
34 Junior lien Debt Service (SRF or LOC)
35 Total Other Transfers
Net Revenue Available for Other Lawful Purposes Including
36 System Development Charges After Transfers
$2,567,031
$2,964,502
$3,229,627
$3,495,079
$3,765,163
[9] 113,483
214,772
218,878
223,075
227,365
[10] 230,390
436,112
444,542
453,163
461,979
$2,910,904
$3,615,386
$3,893,048
$4,171,317
$4,454,506
148%
184%
198%
212%
223%
110%
110%
110%
110%
110%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$946,430 $1,654,174 $1,928,927 $2,206,041 $2,458,180
Footnotes on Pages 3 -5 of 5.
Page 3 of 5
Table 4
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Operating Results and Debt Service Coverage Analysis
Footnotes:
[1] Amounts include projected revenue from monthly water, reclaimed water and wastewater rates effective as of October 1, 2012.
[2] Revenues reflect anticipated increase of revenues for the Reclaimed System due to: i) irrigation customers class codes (IR 50) and (IR77) expected
to become part of the Reclaimed System during the Forecast Period; and ii) anticipated revenue from retrofits.
[3] Amounts include revenues from the following systenrwide average projected rate adjustments:
Projected Fiscal Year Ending September 30,
2013 2014 2015 2016 2017
CPI Index Adjustments
Water System
Reclaimed Water System
Wastewater System
Rate Adjustments (Additional to CPI Index Adjustments)
Water System
Reclaimed Water System
Wastewater System
0.0%
3.0%
3.0%
3.0%
3.0%
0.0%
3.0%
3.0%
3.0%
3.0%
0.0%
3.0%
3.0%
3.0%
3.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
[4] Amount includes water, reclaimed water, and wastewater connection charges revenue, water and wastewater maintenance fee revenue,
violations of ordinance revenue, and other miscellaneous revenues.
[5] The Cost of Operation and Maintenance for Fiscal Ycar 2013 was derived from the adjusted Fiscal Year 2013 Operating Budget as prepared by
City staff. Amounts for the remainder of the Forecast Period have been escalated from budgeted amounts as shown on Table 11. Amounts shown
do not include depreciation and amortization expenses, which are non -cash expenses and are not considered part of the Cost of Operation and
Maintenance as defined in the Bond Resolution.
[6] Administrative transfers are based on a cost allocation that includes among other costs: i) a portion of the costs for the utility counter; ii) an allocation
of salaries costs for some City engineers; iii) an allocation of mowing costs incurred by the public works department; and iv) a transfer equal to 12.0%
of Gross Rate Revenues.
[7] The Debt Service Coverage tests are defined in the Bond Resolution as the Rate Covenant.
[8] Amount includes anticipated additional debt estimated to be issued during the Forecast Period reflected above. The additional debt includes the
following assumptions:
Series 2013 Bonds Available Debt Issue 2
Principal Amount of Bonds (Rounded) $10,335,000 Principal Amount of Bonds (Rounded) $0
Term -Years 30 Term -Years 20
Interest Rate 4.39% Interest Rate 4.21%
First Year of Bond Term (Fiscal Year) 2013 First Year of Bond Term (Fiscal Year) 2013
Average Annual Payment $626,295 Average Annual Payment $0
Page 4 of 5
Table 4
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Operating Results and Debt Service Coverage Analvsis
Footnotes lCont'd.l :
[9] As set forth in the Rate Covenant, certain Water System Development Charges and Sewer System Development Charges are allowed to be used
for coverage purposes in an amount not greater than the Water System Development Charges Bond Service Component and the Sewer System
Development Charges Bond Service Component. The amount recognized for coverage purposes is derived from the following calculations:
1. Calculation of Water and Sewer Expansion Percentages
Allocation Percentages Adjusted Allocation
Amount Water Wastewater Water Wastewater
Estimated Proceeds of the Series 2003 Bonds
[a]
$13,150,000
33.5%
66.5%
$4,400,000
$8,750,000
Water Expansion Percentage
[b]
100.0%
Sewer Expansion Percentage
[b]
100.0%
Estimated Proceeds of the Series 2008 Note
[c]
$5,375,000
45.5%
54.5%
$2,448,018
$2,926,982
Water Expansion Percentage
[d]
100.0%
Sewer Expansion Percentage
[d]
100.0%
Estimated Proceeds of the Series 2010 Note
[c]
$2,072,000
45.5%
54.5%
$943,683
$1,128,317
Water Expansion Percentage
[d]
100.0%
Sewer Expansion Percentage
[d]
100.0%
Estimated Proceeds of the Series 2012 Note
$5,328,000
45.5%
54.5%
$2,426,613
$2,901,387
Water Expansion Percentage
[e]
100.0%
Sewer Expansion Percentage
[c]
100.0%
Estimated Proceeds of the Series 2013 Bonds
$10,163,708
12.0%
88.0%
$1,217,800
$8,945,908
Water Expansion Percentage
[f]
100.0%
Sewer Expansion Percentage
[f]
100.0%
2. Calculation of Water System Development Charges Recognized
for Rate Covenant Purposes
Projected Fiscal Year Ending September 30,
2013
2014
2015
2016
2017
Bond Service Requirement - Senior Lien Debt
Debt Service Requirement - Series 2003 Bonds
$789,538
$787,363
$784,750
$786,688
$787,688
Debt Service Requirement - Series 2008 Note
23,197
0
0
0
0
Debt Service Requirement - Series 2010 Note
369,453
372,381
374,101
374,634
0
Debt Service Requirement - Series 2012 Note
155,992
175,174
178,976
177,660
582,344
Debt Service Requirement - Series 2013 Bonds
626,295
626,295
626,295
626,295
626,295
Bond Service Requirement- Senior Lien Debt
$1,964,474
$1,961,212
$1,964,121
$1,965,276
$1,996,326
Calculated Water System Development Charges Bond Service Component
Debt Service Requirement - Series 2003 Bonds
$264,180
$263,452
$262,578
$263,226
$263,561
Debt Service Requirement - Series 2008 Note
10,565
0
0
0
0
Debt Service Requirement - Series 2010 Note
168,266
169,599
170,382
170,625
0
Debt Service Requirement - Series 2012 Note
71,046
79,782
81,514
80,914
265,226
Debt Service Requirement - Series 2013 Bonds
75,042
75,042
75,042
75,042
75,042
Calculated Water System Development Charges Bond
Service Component
$589,098
$587,875
$589,516
$589,807
$603,828
Water System Development Charges Collected Per Fiscal
Year
[g]
$113,483
$214,772
$218,878
$223,075
$227,365
Water System Development Charges Recognized for Rate
Covenants Purposes
111]
$113,483
$214,772
$218,878
$223,075
$227,365
Page 5 of 5
Table 4
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Operating Results and Debt Service Coverage Analvsis
Footnotes (Cont'd.) :
[a] Derived fiom infbnuation contained in the Official Statement for the Scries 2003 Bonds under the heading "THE 2003 PROJECT" on page 26.
[b] From the information contained in the Official Statement for the Series 2003 Bonds under the heading "THE 2003 PROJECT" on page 26, it can be inferred that
the portion of the total costs of such project financed with the proceeds of the Series 2003 which is attributable to Water Expansion Facilities and Sewer Expansion
Facilities equals 100 %.
[c] The Series 2008 Note and the Series 2010 Note refunded the Series 1997 Bonds. Information contained in the Official Statement for the Series 1997 Bonds under
the heading "TI IE PROJECT" on page 33.
[d] The Series 2008 Note and the Series 2010 Note refunded the Series 1997 Bonds. From the information contained in the Official Statement for the Series 1997
Bonds under the heading "THE PROJECT" on page 33, it can be inferred that the portion of the total costs of such project financed with the proceeds of the Series
1997 which is attributable to Water Expansion Facilities and Sewer Expansion Facilities equals 100 %.
[e] The Series 2012 Note refunded the Series 2008 Note which refunded the Series 1997 Bonds. From the information contained in the Official Statement for the Series 1997
Bonds under the heading "THE PROJECT" on page 33, it can be infericd that the portion of the total costs of such project financed with the proceeds of the Series
1997 which is attributable to Water Expansion Facilities and Sewer Expansion Facilities equals 100 %.
[f] As reflected on Table 14 of the Report, the proceeds of the Series 2013 Bonds can be fully attributed to Water Expansion Facilities and Sewer Expansion Facilities.
[g] Derived from Infonnation as contained on Table I.
[h] PW Snanl to the Bond Resolution, as set forth in the Rate Covenant, the amount recognized for Water Development Charges and Sewer Development Charges
reflects the lesser of the amount as used for rate making purposes and the amount calculated from the Water and Sewer System Development Charges Bond
Seri ice Component.
[10] As set forth in the Rate Covenant, the Sewer System Development Charges arc allowed to be used for coverage purposes in an amount not greater
than the Sewer System Development Charges Bond Service Component. The amount recognized for Sewer System Development Charges is
derived from the following calculations:
1 Calculation of Sewer Svstem Development Charges Recognized for Rate Covenant Purposes
$524,127
0
Debt Service Requirement - Series 2003 Bonds
$525,358
$523,910
Projected Fiscal Year Ending September 30,
Debt Service Requirement - Series 2008 Note
12,632
2013
2014
2015
2016
2017
Bond Service Requirement - Senior Lien Debt
Debt Service Requirement - Series 2012 Note
84,946
95,392
97,462
Debt Service Requirement - Series 2013 Bonds
Debt Service Requirement - Series 2003 Bonds
$789,538
$787,363
$784,750
$786,688
$787,688
Debt Service Requirement - Series 2008 Note
23,197
0
0
0
0
Debt Service Requirement - Series 2010 Note
369,453
372,381
374,101
374,634
0
Debt Service Requirement - Series 2012 Note
155,992
175,174
178,976
177,660
582,344
Debt Service Requirement - Series 2013 Bonds
626,295
626,295
626,295
626,295
626,295
Bond Service Requirement - Senior Lien Debt
$1,964,474
$1,961,212
$1,964,121
$1,965,276
$1,996,326
Calculated Sewer System Development Charges Bond Service Component
$524,127
0
Debt Service Requirement - Series 2003 Bonds
$525,358
$523,910
$522,172
Debt Service Requirement - Series 2008 Note
12,632
0
0
Debt Service Requirement - Series 2010 Note
201,187
202,782
203,718
Debt Service Requirement - Series 2012 Note
84,946
95,392
97,462
Debt Service Requirement - Series 2013 Bonds
551,253
551,253
551,253
Calculated Sewer System Development Charges Bond
Service Component
$1,375,376
$1,373,337
$1,374,606
Sewer System Development Charges Collected Per Fiscal
Year [a]
$230,390
$436,112
$444,542
$523,461
$524,127
0
0
204,008
0
96,745
317,119
551,253
551,253
$1,375,468 $1,392,498
$453,163 $461,979
Sewer System Development Charges Recognized for Rate
Covenants Purposes [b] $230,390 $436,112 $444,542 $453,163 $461,979
[a] Derived fiom Information as contained on Table 2.
[b] Pwsuant to the Bond Resolution, as set forth in the Rate Cotenant, the amount recognized for Water Development Charges and Sewer Development Charges reflects
the lesser of the amount as used for rate making ptvposes and the amount calculated from the Water and Sewer System Development Charges Bond Service Component.
Pale I of6
Table 5
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Develooment of Fund Balances and Interest Income for the Utilitv Svstem Funds
Line
$22,960
522,320
$21,790
Projected Fiscal Year Ending September 30,
$31,260
No.
Description
$13,815,712
2013
2014
2015
2016
2017
0.50%
Summary of Projected Ending Balances
0.75%
0.75%
15 Long -Tcrm Interest Rate
0.50%
0.50%
0.50%
1
Revenue Fund - 401
(U)
S8,418,433
$8,494,396
$8,013,612
$7,878,817
$7,884,997
2
Wastewater Renewal &Replac . Fund -407
(U)
1,637,568
1,458,053
1,425,019
1,227,134
1,132,705
3
Water And Wastewater Encumbered Projects Fund - 408
(U)
242,014
242,014
242,014
242,014
242,014
4
Water Renewal & Replacement Fund - 410
(U)
1,808,078
1,468,492
1,080,367
816,195
500,000
5
Total Projected End of Year Bat. Unrestricted Funds
0
512,106,093
$11,662,955
$10,761,013
$10,164,160
$9,759,716
6
Target (25.0% Annual Rev. + 2 yrs. of Avg. Debt Svc.)
770,194
$6,054,904
$6,221,819
$6,363,513
56,495,294
$6,699,275
7
Water System Development Charges Fund - 404
(R)
$696,683
$823,156
$918,334
$999,002
$1,052,358
8
Wastewater System Development Charges Fund -405
(R)
979,790
1,329,602
1,513,784
1,829,840
1,983,801
9
Construction Series 1997 Bonds Fund - 412
(R)
0
0
0
0
0
10
Construction Series 2003 Bonds Fund - 414
(R)
543,700
0
0
0
0
11
Bond Construction Fund
(R)
0
0
0
0
0
12
Total Projected End of Year Bal. Restricted Funds
59,500
$2,220,173
$2,152,757
$2,432,118
$2,828,842
$3,036,159
Total Projected End of Year Cash Balances Unrestricted and
$22,960
522,320
$21,790
$31,480
$31,260
13 Restricted Funds
$14,326,266
$13,815,712
$13,193,131
$12,993,002
$12,795,875
14 Short -Term Interest Rate
0.50%
0.50%
0.50%
0.75%
0.75%
15 Long -Tcrm Interest Rate
0.50%
0.50%
0.50%
0.75%
0.75%
REVENUE FUND - 401 (U)
113,483
214,772
218,878
223,075
227,365
16 Beginning Balance
$8,975,864 [2]
$8,418,433
$8,494,396
$8,013,612
$7,878,817
17 Transfers In - Water Rev. Requirements
0
44,197
0
6,708
31,483
18 Transfers In - Wastewater Rev. Requirements
0
389,166
342,638
628,692
909,450
19 Transfers Out - Water Rev. Requirements
58,039
0
68,069
0
0
20 Transfers Out - Wastewater Rev. Requirements
336,242
0
0
0
0
21 Transfers Out - Capital Improvements
163,150
357,400
755,352
770,194
751871
22 Transfers Out - Water R &R Fund To Maintain Balances
0
0
0
0
181,883
23 Transfers Out - Wastewater R &R Fund To Maintain Balances
0
0
0
0
0
24 Transfers Out - Water Impact Fees
0
0
0
0
0
25 Transfers Out - Wastewater Impact Fees
0
0
0
0
0
26 Interest Rate
0.50%
0.50%
0.50%
0.75%
0.75%
27 Interest Income
43,400
42,200
41,200
59,500
59,100
Recognition of Interest Earnings
28 in Revenue Requirements
43,400
42,200
41,200
59,500
59,100
29 Ending Balance Revenue Fund 401
$8,418,433
$8,494,396
$8,013,612
$7,878,817
$7,884,997
30 Less: 2 Years Debt Service Reserve
$3,928,949
$3,922,425
$3,928,243
$3,930,551
$3,992,652
31 Less: O&M Reserve (25% of Annual Revenues)
2,125,955
2,299,395
2,435,270
2,564,743
2,706,622
32 Ending Balance Exclusive of Reserves
$2,363,529
$2,272,576
$1,650,100
$1,383,523
51,185,722
33 Calculated Days Cash on Hand Fund 401 *
474
457
414
392
377
. Projected Cash Revenue Fund 401 - (Projected Current Expenses - 365)
34 Percent Allocable to Water System 52.90° 0 52.90% 52.90 5290°/ 52.9W
35 Amount Allocable to Water System
$22,960
522,320
$21,790
$31,480
$31,260
36 Amount Allocable to Wastewater System
20,440
19,880
19,410
28,020
27,840
WATER SYST. DEVELOP. CHARGES ED.
- 404 (R)
37 Beginning Balance
F 13]
$696,683
$823,156
$918,334
$999,002
38 Transfers In - Impact Fee Revenue
113,483
214,772
218,878
223,075
227,365
39 Transfers In - Revenue Fund
0
0
0
0
0
40 Transfers Out - Capital Improvements
0
42,000
78,000
99,507
131,609
41 Transfer Out - Debt Service
20,000
50,000
50,000
50,000
50,000
42 Interest Rate
0.50%
0.50%
0.50%
0.75%
0.75%
43 Interest Income
3,200
3,700
4,300
7,100
7,600
Recognition of Interest Earnings
44 in Revenue Requirements
0
0
0
0
0
45 Ending Balance
696,683
823,156
918,334
999,002
1,052,358
46 Percent Allocable to Water System
100.00%
100.00%
100.00%
100.00%
100.00%
Page 2 of 6
Table 5
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Development of Fund Balances and Interest Income for the Utility Svstem Finds
Line Projected Fiscal Year Ending September 30,
No. Description 11] 2013 2014 2015 2016 2017
47 Amount Allocable to Water System
$3,200
$3,700
$4,300
$7,100
$7,600
48 Amount Allocable to Wastewater System
0
0
0
0
0
WASTEWATER SYST. DEVEL. CH. FD. - 405
(R)
49 Beginning Balance
$795,000 [4]
$979,790
$1,329,602
$1,513,784
51,829,840
50 Transfers In - Impact Fee Revenue
230,390
436,112
444,542
453,163
461,979
51 Transfers In - Revenue Fund
0
0
0
0
0
52 Transfers Out - Capital Improvements
0
42,000
217,360
99,507
272,217
53 Transfer Out - Debt Service
50,000
50,000
50,000
50,000
50,000
54 Interest Rate
0.50%
0.50%
0.50%
0.75%
0.75%
55 Interest Income
4,400
5,700
7,000
12,400
14,200
Recognition of Interest Earnings
56 in Revenue Requirements
0
0
0
0
0
57 Ending Balance
979,790
1,329,602
1,513,784
1,829,840
1,983,801
58 Percent Allocable to Water System
0.00%
0.00%
0.00%
0.00 0 //0
0.00%
59 Amount Allocable to Water System
0
0
0
0
0
60 AmOUnt Allocable to Wastewater System
4,400
5,700
7,000
12,400
14,200
61 Water System
$0
$0
$0
$0
$0
62 Wastewater Svstem
0
0
0
0
0
WASTEWATER RENEWAL. & REPLAC. FUND - 407
(U)
63 Beginning Balance
$1,402,248
$1,637,568
$1,458,053
$1,425,019
$1,227,134
64 Transfers In
549,120
242,163
267,907
285,826
304,313
Additional Transfers In from Revenue Fund to Maintain
65 at least $1,000,000 Ending Balance
0
0
0
0
0
66 Transfers Out - Capital Improvements
313,800
421,678
300,941
483,711
398,742
67 Interest Rate
0.50%
0.50%
0.50°/
0.75%
0.75%
68 Interest Income
7,500
7,700
7,200
9,900
8,800
Recognition of Interest Earnings
69 in Revenue Requirements
7,500
7,700
7,200
9,900
8,800
70 Ending Balance
1,637,568
1,458,053
1,425,019
1,227,134
1,132,705
71 Percent Allocable to Water System
100.00%
100.00%
100.00%
100.00%
I OQOOiu
72 Amount Allocable to Water System
$7,500
$7,700
$7,200
$9,900
$8,800
73 Amormt Allocable to Wastewater System
0
0
0
0
0
WA "rER AND WASTEWATER ENCUMBERED
PROJECTS FUND - 408
(U)
74 Beginning Balance
$2,077,386 [6]
$242,014
$242,014
$242,014
$242,014
75 Transfers In
0
0
0
0
0
Additional Transfers In from Revenue Fund to Maintain
76 at least $000,000 Ending Balance
0
0
0
0
0
77 Transfers Out - Capital Improvements
1,835,372
0
0
0
0
78 Interest Rate
0.50%
0.50%
0.50%
0.75%
0.75%
79 Interest Income
5,700
1,200
1,200
1,800
1,800
Recognition oflnterest Earnings
80 in Revenue Requirements
5,700
1,200
1,200
1,800
1,800
81 Ending Balance
242,014
242,014
242,014
242,014
242,014
82 Percent Allocable to Water System
52.90
52.90%
52.90%
52.90%
52.90%
83 Amount Allocable to Water System
$3,000
$600
$600
$1,000
$1,000
84 Amount Allocable to Wastewater System
2,700
600
600
800
800
Page 3 of 6
Table 5
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Develonment of Fund Balances and Interest Income for the Utility Syste Funds
Line
BOND CONSTRUCTION FUND New Bonds
(R)
Projected Fiscal Year Ending September 30,
No.
Description
[1] 2013
2014
2015
2016
2017
$0
$0
WATER REN EWAL & REPLACEMENT RIND - 410
(U)
7,728,108
2,435,600
0
0
85
Beginning Balance
$2,217,078 171
$1,808,078
$1,468,492
$1,080,367
$816,195
86
Transfers In from Rates
300,000
315,114
329,372
343,146
356,256
0.75°%
Additional Transfers In from Revenue Fund to Maintain
Interest Income
0
0
0
0
87
at least $500,000 Ending Balance
0
0
0
0
181,883
88
Transfers Out - Capital Improvements
709,000
654,700
717,496
607,318
854,334
89
Interest Rate
0.50%
0.50%
0.50%
0.75%
0.75%
90
Interest Income
10,000
8,100
6,300
7,100
3,500
11.98%
Recognition of Interest Earnings
Amount Allocable to Water System
0
0
0
0
91
in Revenue Requirements
10,000
8,100
6,300
7,100
3,500
92
Ending Balance
1,808,078
1,468,492
1,080,367
816,195
500,000
93
Percent Allocable to Water System
0.00
0.00%
0.00%
0.00%
0.00°%
94
Amount Allocable to Water System
$0
$0
$0
$0
$0
95
Amount Allocable to Wastewater System
10,000
8,100
6,300
7,100
3,500
CONSTRUCTION SERIES 1997 BONDS FUND - 412
(U)
96
Beginning Balance
$0 181
$0
$0
$0
$0
97
Transfers Out - Capital Improvements
0
0
0
0
0
98
Interest Rate
0.50°%
0.50%
0.50%
0.75°%
0.75%
99
Interest Income
0
0
0
0
0
Recognition of Interest Earnings
100
in Revenue Requirements
0
0
0
0
0
101
Ending Balance
0
0
0
0
0
102
Percent Allocable to Water System
45.54%
45.54%
45.54°%
45.54%
45.54°%
103
Amount Allocable to Water System
0
0
0
0
0
104
Amount Allocable to Wastewater System
0
0
0
0
0
CONSTRUCTION SERIES 2003 BONDS FUND - 414
(U)
105
Beginning Balance
$996,755 191
$543,700
$0
$0
$0
106
Transfers Out - Capital Improvements
456,855
545,000
0
0
0
107
Interest Rate
0.50°%
0.50%
0.50%
0.75
0.75%
108
Interest Income
3,800
1,300
0
0
0
Recognition of Interest Earnings
109
in Revenue Requirements
0
0
0
0
0
110
Ending Balance
543,700
0
0
0
0
1 I 1
Percent Allocable to Water System
21.62%
21.62%
21.62%
21.62°%
21.62 0 '0'
112
Amount Allocable to Water System
$800
$300
$0
$0
$0
113
Amount Allocable to Wastewater System
3,000
1,000
0
0
0
BOND CONSTRUCTION FUND New Bonds
(R)
114
Beginning Balance
$0
$0
$0
$0
$0
115
Transfers In
7,728,108
2,435,600
0
0
0
116
Transfers Out - Capital Improvements
7,728,108
2,435,600
0
0
0
117
Interest Rate
0.50%
0.50%
0.50°%
0.75%
0.75°%
118
Interest Income
0
0
0
0
0
Recognition of Interest Earnings
119
in Revenue Requirements
0
0
0
0
0
120
Ending Balance
0
0
0
0
0
121
Percent Allocable to Water System
11.98%
0.00°%
11.98%
11.98%
11.98%
122
Amount Allocable to Water System
0
0
0
0
0
123
Amount Allocable to Wastewater System
0
0
0
0
0
Pale 4 of 6
Table 5
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Dcvcloumcnt of Fund Balances and Interest Income for the Utility Svstem Funds
Line
INTEREST INCOME
$1,337,826
Projected Fiscal Year Ending September 30,
154
No.
Description
111 2013
2014
2015
2016
2017
157
RATE STABILIZATION FUND
(R)
Wastewater System
159
Total
0.75%
124
Beginning Balance
$0
$0
$0
$0
$0
125
Transfers In
0
0
0
0
0
126
Transfers Out
0
0
0
0
0
127
Interest Rate
0.00%
0.00%
0.00%
0.00%
0.00%
128
Interest Income
0
0
0
0
0
0
Recognition of Interest Earnings
0
0
0
0
0
129
in Revenue Requirements
0
0
0
0
0
130
Ending Balance
0
0
0
0
0
131
Percent Allocable to Water System
0.00%
0.00%
0.00%
0.00%
0.00%
132
Amount Allocable to Water System
$0
$o
$0
$0
$0
133
Amount Allocable to Wastewater System
0
0
0
0
0
SINKING FUND - 406 and 413
Annual Sinking Fund Deposit:
134 Existing Debt
135 Proposed Debt
136 Average Balance (Assumes 25°% of Annual Debt Service)
137 Interest Rate
138 Interest Income
Recognition of Interest Earnings
139 in Revenue Requirements
140 Percent Allocable to Water System
141 Amount Allocable to Water System
142 Amount Allocable to Wastewater System
BOND RESERVE
Estimated Balance:
143 Series 2013 Bonds New Money
144 Available Debt Issue 2 New Money
145 Available Debt Issue 3 New Money
146 Transfers In
147 Transfers Out
148 Interest Rate
149 Interest Income
Recognition of Interest Earnings
150 in Revenue Requirements
151 Percent Allocable to Water System
152 Amount Allocable to Water System
153 Amount Allocable to Wastewater System
M
$1,338,179
INTEREST INCOME
$1,337,826
Unrestricted
154
Water System
155
Wastewater System
156
Total
491,100
Restricted
157
Water System
158
Wastewater System
159
Total
0.75%
TOTAL INTEREST INCOME
160
Water System
161
Wastewater System
162
Total
M
$1,338,179
51,334,917
$1,337,826
$1,338,981
$1,370,031
626,295
626,295
626,295
626,295
626,295
491,100
490,300
491,000
491,300
499,100
0.50%
0.50%
0.50%
0.75%
0.75%
2,400
2,400
2,400
3,600
3,700
2,400
2,400
2,400
3,600
3,700
2523%
2522%
25.29%
25.27%
25.58%
$610
$610
$610
$910
5950
1,790
1,790
1,790
2,690
2,750
$0
$o
$0
$0
$0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.50 o io
0.50%
0.50%
0.75%
0.75%
0
0
0
0
0
0
0
0
0
0
2523%
25.22%
25.29%
25.27%
25.58%
$0
$0
$0
$0
$0
0
0
0
0
0
$34,070
$31,230
530,200
$43,290
$42,010
34,930
30,370
28,100
38,610
34,890
$69,000
$61,600
$58,300
$81,900
$76,900
$4,000
$3,700
$4,300
$7,100
$7,600
7,400
5,700
7,000
12,400
14,200
$11,400
$9,400
$11,300
$19,500
$21,800
$38,070
$34,930
$34,500
$50,390
$49,610
42,330
36,070
35,100
51,010
49,090
$80,400
$71,000
$69,600
$101,400
$98,700
W
Pale 5 of 6
Table 5
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Development of Fund Balances and Interest Income for the Utility System Funds
Line Projected Fiscal Year Ending September 30,
No. Description [1] 2013 2014 2015 2016 2017
Footnotes:
[1 ] (U) = Interest Earnings unrestricted, assumed available to meet system expenditure requirements.
(R) = Interest Earnings restricted, assumed not available to meet system expenditure requirements.
[2] Beginning balances obtained from unaudited City trial balances and financial statements reflecting preliminary results and summarized as follows:
Fund 401 Revenue Fund
Beginning Balances as of 9/30/2012
Cash in Bank - SunTrust
$1,195,534
Raymond James 9676 Investments
701,126
SBA Investments
41,398
SunTrust Investments
4,502,030
Raymond James 41873 Investments
25,286
MM Investments
2,729,176
Beginning Balances as of 9/30
$9,194,550
Less: Customer Deposits (Restricted Funds)
($408,877)
Less: Retainage Payable
(9,809)
Less: Allowance for Prior Period Encumbrances
$200,000
Estimated Beginning Balance as of 9/30/2012
$8,975,864
[3] Beginning balances obtained from unaudited City trial balances and financial statements reflecting preliminary results and summarized as follows:
Fund 404 Water Connection Fees
Beginning Balances as of 9/30/2012
Cash in Bank - SunTrust
$1,117,512
Beginning Balances as of 9/30/2012
$1,117,512
Less: Allowance for Prior Period Encumbrances
($517,512)
Estimated Beginning Balance as of 9/30,
$600,000
[4] Beginning balances obtained from unaudited City trial balances and financial statements reflecting preliminary results and summarized as follows:
Fund 405 Wastewater Connection Fees
Beginning Balances as of 9/30/2012
Cash in Bank - SunTrust
$1,322,483
Raymond James 9676 Investments
0
SunTrust Investments
0
M &I Investments
1,1 18,276
Raymond James 41873 Investments
0
Beginning Balances as of 9/30/2012
$2,440,759
Less: Allowance for Prior Period Encumbrances
($1,645,759)
Estimated Beginning Balance as of 9/30/2012
$795,000
[5] Beginning balances obtained from unaudited City trial balances and financial statements reflecting preliminary results and summarized as follows:
Fund 407 Wastewater Renewal & Replacement
Beiinnim, Balances as of 9/30/2012
Cash in Bank - SunTrust $1,332,983
Raymond James 9676 Investments 299,265
Raymond James 41873 Investments 0
Beginning Balances as of 9/30/2012 $1,632,248
Less: Allowance for Prior Period Encumbrances ($230,000)
Estimated Beginning Balance as of 9/30 $1,402,248
Page 6 of 6
Table 5
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Development of Fund Balances and Interest Income for the Ftility System Funds
Line Projected Fiscal Year Ending September 30,
No. Description 111 2013 2014 2015 2016 2017
Footnotes (Cont'd.) :
[6] Beginning balances obtained from unaudited City trial balances and financial statements reflecting preliminary results and summarized as follows:
Fund 408 Water And Wastewater Encumbered Projects
Be,innin;*, Balances as of 9/30/2012
Cash in Bank - SunTrust
$1,661,927
Raymond James 9676 Investments
0
SunTrust Investments
2,000,000
M &I Investments
0
Raymond James 41873 Investments
0
Beginning Balances as of 9/30/2012
$3,661,927
Less: Allowance for Prior Period Encumbrances
($1,545,923)
Less: Contract Retaining
(38,618)
Estimated Beginning Balance as of 9/30/2012
$2,077,386
17] Beginning balances obtained from unaudited City trial balances and financial statements reflecting preliminary results and summarized as follows:
Fund 410 Water Renewal & Replacement
Beainnirn - Balances as of 9/30/2012
Cash in Bank - SunTrust
$1,440,093
Raymond James 9676 Investments
286,743
SunTrust Investments
500,243
M &I Investments
0
Raymond James 41873 Investments
0
Beginning Balances as of 9/30/2012
$2,227,078
Less: Allowance for Prior Period Encumbrances
($10,000)
Estimated Beginning Balance as of 9/30/2012
$2,217,078
[8] Beginning balances obtained from unaudited City trial balances and financial statements reflecting preliminary results and summarized as follows:
Fund 412 Construction Fund 1997 Bonds
Beainnintt Balances as of 9/30/2012
Cash - Special $0
Raymond James 9676 Investments 0
SunTrust Investments 0
M &1 Investments 0
Raymond James 41873 Investments 0
Beginning Balances as of 9/30/2012 $0
Less: Allowance for Prior Period Encumbrances $0
Estimated Beginning Balance as of 9/30/2012 $0
19] Beginning balances obtained from unaudited City trial balances and financial statements reflecting preliminary results and summarized as follows:
Fund 414 Construction Fund 2003 Bonds
Bcainnina Balances as of 9/30/2012
Cash - Special
$1,116,176
Raymond James 9676 Investments
26
SunTrust Investments
0
M &I Investments
0
Raymond James 41873 Investments
0
Beginning Balances as of930/2012
$1,116,202
Less: Allowance for Prior Period Encumbrances
($119,447)
Estimated Beginning Balance as of 9/30/2012
$996,755
Table 6
City of Ocoee, Florida
2013 Utility
Revenue Sufficiency Analysis
Allocation of Operating
Expenses to Individual Systems
II I
Line
Budget
Adjusted
Allocation Percentages
Adjusted 2013
No
Description
2013
Adjustments
2013
Basis
Water
Wastewater
Water
Wastewater
(c)
(d)
(e)
(1)
(g)
(Ir)
(U
G)
Water and Wastewater Administration Fund (531)
Personal Services
1
1200
Regular Salaries K Wages
$292,955
$0
$292955
Salaries
596%
40.4%
$174,601
$118,354
2
1400
Overtime Pay
17,060
0
17,060
Salaries
596%
404%
10,168
6,892
3
2100
FICA Taxes
23,720
0
23,720
Salaries
59.6 0 /'.
40.4%
14,137
9,583
4
2200
Retirement Contributions
71,030
0
71,030
Salaries
59.6%
40.4%
42,334
28,696
5
2300
Health Insurance
43,850
0
43,850
Salaries
596%
404%
26,135
17,715
6
2301
Life Insurance
810
0
810
Salaries
59.6%
40.4%
483
327
7
2302
DentalNision Insurance
1,750
0
1,750
Salaries
59.6%
40.4%
1,043
707
8
2303
Accident/Disability Insurance
2,280
0
2,280
Salaries
59.6%
404%
1,359
921
9
2400
Worker Comp. Insurance
3,780
0
3,780
Salaries
59.6%
404%
2,253
1,527
10
Additional Personnel
0
0
0
Calculated
50.0%
50.0%
0
0
11
Total Personal
Costs
$457,235
$0
$457,235
$272,512
$184,723
Operating Expenses
12
3101
Legal Expense
$10,000
$0
$10,000
Salaries
59.6%
40.4%
$5,960
$4,040
13
3128
Professional Services /Other
89,000
0
89,000
Accounts
60.2%
39.8%
53,578
35,422
14
3400
Contractual Services
3,580
0
3,580
Accounts
60.2%
39.8%
2,155
1,425
15
4000
Travel Expense
440
0
440
Salaries
596%
40.4%
262
178
16
4005
POWR Program
35,500
0
35,500
Salaries
596%
40.4%
21,158
14,342
17
4100
Telephone Expense
10,340
0
10,340
Salaries
59.6%
404%
6,163
4,177
18
4200
Postage and Freight
4,100
0
4,100
Salaries
596%
404%
2,444
1,656
19
4300
Electric Expense
4,800
0
4,800
Salaries
596%
404%
2,861
1,939
20
4301
Water Expense
1,200
0
1,200
Salaries
59.6%
404%
715
485
21
4400
Leasing Expense
2,600
0
2,600
Salaries
596%
404 0 /',
1,550
1,050
22
4501
Auto Liability Insurance
225
0
225
Salaries
99.6%
404%
134
91
23
4502
Multi -Peril Insurance
5,830
0
5,830
Salaries
59.6%
404%
3,475
2,355
24
4602
Building Maintenance
500
0
500
Salaries
596%
40.4%
298
202
25
4605
Vehicle Parts and Repairs
825
0
825
Salaries
596%
40.4%
492
333
26
4606
Equip_ Maintenance and Contracts
3,680
0
3,680
Salaries
59.6%
40.4%
2,193
1,487
27
4663
Emergency Repairs
0
0
0
Salaries
59.6%
404%
0
0
28
4902
Miscellaneous Expense
1,000
0
1,000
Salaries
59.6%
40.4%
596
404
29
4909
Bad Debt Write Offs
0
21,260 121
21,260
Input
44.7%
553%
9,511
11,748
30
5100
Office Supplies
2,000
0
2,000
Salaries
596%
404%
1,192
808
31
5200
POE Supplies
5,350
0
5,350
Salaries
59.6%
40.4%
3,189
2,161
32
5201
Uniforms
1,540
0
1,540
Salaries
59.6%
40.4%
918
622
33
5202 R 5 Operating Supplies R Electrical Supplies
6,000
0
6,000
Salaries
59.6%
40.4%
3,576
2,424
34
5206
Employee Gift Certificates
1,700
0
1,700
Salaries
59.6%
40.4%
1,013
687
35
5224
Emergency Management
3,000
0
3,000
Salaries
59.6%
40.4%
1,788
1,212
36
5230
Small Equipment
0
0
0
Salaries
59.6%
40.4%
0
0
37
5
Compuler EquipmenUSof fare
5,300
0
5,300
Salaries
59.6%
40.4%
3,159
2,141
38
5401
Books/Subscriptions
1,750
0
1,750
Salaries
59.6%
40.4%
1,043
707
39
5402
Professional Dues
850
0
850
Salaries
59.6%
40.4%
507
343
40
5405
'I raining Expense
2,600
0
2,600
Salaries
59.6%
404%
1,550
1,050
41
Reserve for Contingency
0
50,088 1 2 1
50,088
Input
52.9%
47.1%
26,488
23,600
42
6302
Capital Improvements
250,000
(250,000) 131
0
Salaries
S9,6%
40.4%
0
0
43
6405
Capital - Comp_EquiR /Software
0
0
0
Salaries
59.6%
40.4%
0
0
44
7100
Principal - SUV Lease
0
0
0
Salaries
59,6%
40.4%
0
0
45
7200
Interest - SUVLease
0
0
0
Salaries
59.6%
40.4%
0
0
46
Total Operating
Services
$453,710
($178,652)
$275,058
$157,966
$117092
47
Total Water and
Nastewater Admin. (Fund 531)
$910,945
($178,652)
$732,293
$430,478
$301,815
Water Utilities
Facilities (533)
Personal Costs
48
1200
Regular Salaries& Wages
$180,840
$0
$180,840
Direct -W
100.0%
0.0%
$180,840
$0
49
1400
Overtime Pay
11,740
0
11,740
Direct -W
100.0%
00%
11,740
0
50
2100
FICA Taxes
14,735
0
14,735
Direct -W
100.0%
0.0%
14,735
0
51
2200
Retirement Contributions
43,125
0
44,125
Direct -W
1000%
00%
44,125
0
52
2300
Health Insurance
20,950
0
20,950
Direct -W
100.0%
0.0%
20,950
0
53
2301
Life Insurance
565
0
565
Direct -W
1000%
0.0%
565
0
54
2302
Dental /Vision Insurance
1,050
0
1,050
Direct -W
100.0%
0.0%
1,050
0
55
2303
Accident/Disability Insurance
1,380
0
1,380
Direct -W
1000
00%
1,380
0
56
2400
Worker Comp_ Insurance
4,070
0
4,070
Direct -W
100.0%
00%
4,070
0
57
2500
Unemployment Compensation
0
0
0
Direct -W
100.0%
0.0%
0
0
58
Additional Personnel
0
0
0
Calculated
50.0%
50.0 0 /0
0
0
59
'Iota] Personal
Costs
$279,455
50
$279,455
$279,455
$0
Operating Expenses
60
3128
Professional Services /Other
$0
$0
$0
Direct -W
100.0/1
0.0%
$0
$0
61
3200
Accounting and Auditing
6,750
0
6,750
Direct -W
100.0%
0.0 0 /
6,750
0
62
3400
Contractual Services
26,120
0
26,120
Direct -W
100.0%
0.0%
26,120
0
63
4000
Travel Expense
2,250
0
2,250
Direct-W
100.0%
0.0%
2,250
0
64
4100
Telephone Expense
8,550
0
8,550
Direct -W
100.0%
0.0%
8,550
0
65
4200
Postage and Freight
400
0
400
Direct -W
100.0%
0.0 °0
400
0
66
4300
Electric Expense
250,000
0
250,000
Direct -W
100.0%
0.0%
250,000
0
67
4400
Leasing Expense
600
0
600
Direct -W
100.0%
0.0%
600
0
68
4501
Auto Liability Insurance
1,065
0
1,065
Direct -W
100.0%
0.0%
1,065
0
69
4502
Multi -Peril Insurance
21,080
0
21,080
Direct -W
100.0 1 /o
0.0%
21,080
0
70
4600
Water Sampling
15,660
0
15,660
Direct -W
100.0°x',
0.0%
15,660
0
71
4602
Building Maintenance
28,700
0
28,700
Direct -W
100.0%
00o /.
28,700
0
Table 6
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Allocation of Oneratine Expenses to Individual Svstems I
Line
Budget
Adjusted
Allocation Percentages
Adjusted 2013
No,
Description
2013
Adjustments
2013
Basis
Water
Wastewater
Water
Wastewater
(c)
(d)
(e)
(F)
(g)
(h)
(
(I)
72
4605 Vehicle Parts and Repair
4,945
0
4,945
Direct -W
100.0%
0.0%
4,945
0
73
4606 Equipment Maintenance Contracts
0
0
0
Direct -W
1000%
QO%
0
0
74
4663 Emergency Repairs -Uld
22,500
0
22,500
Direct -W
100.0%
0.0%
2,500
0
75
4902 Miscellaneous Expense
3,825
0
3,825
Direct -W
1000%
00%
3,825
0
76
5100 OlPice Supplies
0
0
0
Direct -W
1000%
0.0%
0
0
77
5200 POL Supplies
11,750
0
11,750
Direct -W
100.0%
00%
11,750
0
78
5201 Uniforms
1,290
0
1,290
Direct -W
1000%
0.0%
1,290
0
78
5202 Operating Supplies
31,000
0
31,000
Direct -W
1000%
00 "l0
31,000
0
79
5208 Chemical Expense
86,600
0
86,600
Direct -W
1000%
0.0%
86,600
0
79
5209 R 5216 Electrical Supplies R Copying Expense
14,200
0
14,200
Direct -W
1000%
0.0%
14,200
0
80
5217 Water Meters
0
0 141
0
Direct -W
100.0%
0.0%
0
0
80
5230 Small Equipment
21,000
0
21,000
Direct -W
1000%
0 0%
21,000
0
81
5233 Line and System Appurtenances
24,500
0
24,500
Direct -W
1000 0 /1
00%
24,500
0
81
5235 Computer Equipment/Software
3,000
0
3,000
Direct -W
1000%
0.0%
3,000
0
82
5401 Books /Subscriptions
0
0
0
Direct -W
100.0%
0.0%
0
0
82
5402 Professional Dues
400
0
400
Direct -W
100.0%
0.0%
400
0
83
5405 Training Expense
3,200
0
3,200
Direct -W
100.0%
0.0%
3,200
0
83
7200 Interest Expense
3,000
0
3,000
Direct -W
100.0%
00%
3,000
0
84
6302 Capital Improvements
332,000
(332,000) l5l
0
Direct -W
100.0%
0.0%
0
0
84
6400 Equipment
0
0 141
0
Direct -W
100.0%
0.0%
0
0
85
6401 Vehicle Replacement
0
0
0
Direct -W
100.0%
0.0%
0
0
85
7100 Principal - Pick -up Truck Lease
0
0
0
Direct -W
100.0%
0.0%
0
0
86
7200 Interest - Pick -up Truck Lease
0
0
0
Direct -W
100.0%
0.0%
0
0
86
Total Operating Services
$924,385
($332,000)
$592,385
$592,385
$0
87
Total Water Utilities Facilities (533)
$1,203,840
($332,000)
$871,840
$871,840
$0
Water Utility Operating (533.1)
Personal Costs
88
1200 Regular Salaries & Wages
$542,785
$0
$542,785
Direct -W
1000%
0.0%
$542,785
$0
88
1400 Overtime Pay
36,350
0
36,350
Direct -W
100.0%
QO%
36,350
0
89
2100 FICA Taxes
44,310
0
44,310
Direct -W
100.0%
0.0%
44,310
0
90
2200 Retirement Contributions
132,685
0
132,685
Direct -W
100 0%
00%
132,685
0
91
2300 Ifealth Insurance
91,350
0
91,350
Direct -W
1000%
00%
91,350
0
92
2301 Life Insurance
1,590
0
1,590
Direct -W
1000%
00 1 io
1,590
0
93
2302 Dental/Vision Insurance
5,250
0
5,250
Direct -W
1000%
0.0%
5,250
0
94
2303 Accident/Disability Insurance
4,205
0
4,205
Direct -W
100.0%
0.0 ".
4,205
0
95
2400 Worker Comp. Insurance
11,065
0
11,065
Direct -W
1000%
0.0%
11,065
0
96
2500 Unemployment Compensation
2,500
0
2,500
Direct -W
100.0%
0.0%
2,500
0
97
Additional Personnel
0
0
0
Calculated
50 0%
500 1 1.
0
0
98
Total Personal Costs
$872,090
$0
$872,090
$872,090
$0
Operating Expenses
99
3400 Contractual Services
$33,480
$0
$33,480
Direct -W
100.0%
00%
$33,480
$0
100
4000 Travel Expense
4,500
0
4,500
Direct -W
1000%
0.0%
4,500
0
101
4100 Telephone Expense
6,060
0
6,060
Direct -W
100.0%
00%
6,060
0
102
4200 Postage and Freight
1,000
0
1,000
Direct -W
100.0%
0.0%
1,000
0
103
4400 Leasing Expense
2,500
0
2,500
Direct -W
100.0%
0.0%
2,500
0
104
4501 Auto Liability Insurance
3,340
0
3,340
Direct -W
100.0%
0.0 1 io
3, 40
0
I0s
4502 Multi -Peril Insurance
35,840
0
35,840
Direct -W
1000%
00%
35,840
0
106
4600 Water Sampling
2,000
0
2,000
Direct -W
100.0
QO%
2,000
0
107
4605 Vehicle Parts and Repair
16,200
0
16,200
Direct-\V
100,0%
QO%
16,200
0
108
4606 Equipment Maintenance Contracts
0
0
0
Direct -W
100.0%
00%
0
0
109
4663 Emergency Repairs -Util.
22,27
0
22,227
Direct -W
I00.0
0.0%
22,227
0
110
4902 Miscellaneous Expenses
0
0
0
Direct -W
1000%
0.0 °%
0
0
111
5200 POE Supplies
46,700
0
46,700
Direct-W
100.0%
00%
46,700
0
112
5201 Uniforms
6,625
0
6,625
Direct -W
100.0%
0.0
6,625
0
113
5202 Operating Supplies
90,000
0
90,000
Direct -W
100.0%
0.0%
90,000
0
114
5209 Electrical Supplies
250
0
250
Direct -W
100.0%
0.0%
250
0
115
5217 Water Meters
220,415
0
220,415
Direct -W
100.0%
00%
220,415
0
116
5230 & 5235 Small Equipment & Computer Equipment
7,200
0
7,200
Direct -W
100.0%
0.0%
7,200
0
117
5401 Books /Subscriptions
80
0
80
Direct -W
100.0%
0.0%
80
0
118
5402 Professional Dues
460
0
460
Direct -W
100.0%
0 0 °!o
460
0
119
5405 Training Expense
2,000
0
2,000
Direct -W
100.0%
00%
2,000
0
120
6302 Capital Improvements
30,000
(30,000) 161
0
Direct -W
100.0%
0.0%
0
0
121
6400 Equipment
57,500
(57,500) 141
0
Direct -W
100.0%
00o/lo
0
0
122
6401 Vehicle Replacement
14,573
(14,573) 141
0
Direct -W
100.0%
0.0%
0
0
123
7100 Principal - Pick -up Truck Lease
0
0
0
Direct -W
100.0%
00%
0
0
124
7200 Interest - Pick-up '1 rmekLease
0
0
0
Direct -W
100.0%
0.0%
0
0
125
'total Operating Services
$602,950
($102,073)
$500,877
$500,877
$0
126
Total Water Utility Operating (533.1)
$1,475,040
(5103,073)
51,372,967
$1,372,967
$0
R'astewa ter Utility Facility (535)
Personal Services
127
1200 Regular Salaries & Wages
$238,670
$0
$238,670
Direct -S
0.0 %0
100.0 ".
$0
$238,670
128
1400 Overtime Pay
13,200
0
13,200
Direct -S
00%
1000 1 1/.
0
13,200
129
2100 FICA Taxes
19,270
0
19,270
Direct -S
0.0%
100.0%
0
19,270
130
2200 Retirement Contributions
57,710
0
57,710
Direct -S
00%
100.0%
0
57,710
131
2300 Health Insurance
43,850
0
43,850
Direct -S
0.0%
100.0%
0
43,850
132
2301 Life Insurance
685
0
685
Direct -S
0.0%
100.0%
0
685
133
2302 Dental/Vision Insurance
1.750
0
1,750
Direct -S
0.0%
100.0%
0
1,750
'fable 6
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Allocation of Oyeratiop Expenses to Individual Svstems III
Line
Budget
Adjusted
Allocation Percentages
Adjusted 2013
No
Description
2013
Adjustments
2013
Basis
Water
Wastewater
Water
Wastewater
(c)
(d)
(c)
(f)
(g)
(h)
(i)
�)
134
2303
Accident/Disability Insurance
1,910
0
1,910
Direct -S
0.0%
1000%
0
1,910
135
2400
Worker Comp. Insurance
3,580
0
3,580
Direct -S
0.0%
100.0%
0
3,580
136
2500
Unemployment Compensation
2,_500
0
2,500
Direct -S
0.0%
1000%
0
2,500
137
Additional Personnel
0
0
0
Calculated
50.0%
50.0%
0
0
138
'Total Personal
Services
$383,125
$0
$383,125
$0
$383,125
Operating Expenses
139
3128
Professional Services/Other
$0
$0
$0
Direct -S
0.0%
100.0%
$0
$0
140
3200
Accounting and Auditing
8,000
0
8,000
Direct -S
00%
100.0%
0
8,000
141
3400
Contractual Services
175,770
0
175,770
Direct -S
0.0%
100.0%
0
175,770
142
4000
Travel Expense
2,610
0
2,610
Direct -S
00%
1000%
0
2,610
143
4100
Telephone Expense
8,000
0
8,000
Direct -S
0.0%
1000%
0
8,000
144
4200
Postage and Freight
300
0
300
Direct -S
0.0%
100.0%
0
300
145
4300
Electric Expense
300,000
0
300,000
Direct -S
00%
1000%
0
300,000
146
4301
Water Expense (Reclaimed Purchases)
150,980
0
150,980
Direct -S
00%
100.0%
0
150,980
147
4400
Leasing Expense
500
0
500
Direct -S
0.0%
1000%
0
500
148
4501
Auto Liability Insurance
140
0
140
Direct -S
0.0%
100.0%
0
140
149
4502
Multi -Peril Insurance
20,980
0
20,980
Direct -S
0.0%
100.0%
0
20,980
150
4600
Water Sampling
39,540
0
39,540
Direct -S
00%
100.0%
0
39,540
151
4601
Building Maintenance
2,
0
2,500
Direct -S
0.096
100.0%
0
2,500
152
4605
Vehicle Parts and Repair
2,475
0
2,475
Direct -S
00%
1000
0
2,475
153
4606
Equipment Maintenance Contracts
0
0
0
Direct -S
0.0%
1000%
0
0
154
4663
Emergency Repairs -Uti1,
17,000
0
17,000
Direct -S
0.0%
100.0%
0
17,000
155
4902
Miscellaneous Expense
0
0
0
Direct -S
0.0%
100.0%
0
0
156
5100 R 5216
Office Supplies R Copying Expense
300
0
300
Direct -S
0.0%
100.0%
0
300
157
5200
POL Supplies
10,200
0
10,200
Direct -S
00%
100.0%
0
10,200
158
5201
Uniforms
2,19
0
2,195
Direct -S
0.0%
100.0%
0
2,195
159
5
Operating Supplies
53,000
0
53,000
Direct -S
00%
100.0%
0
53,000
160
5208
Chemical Expense
80,000
0
80,000
Direct -S
0.0%
100.0%
0
80,000
161
5209
Electrical Supplies
17,000
0
17,000
Direct -S
0.0%
100.0%
0
17,000
162
5230
Small Equipment
19,600
0
19,600
Direct -S
0.0%
100.0%
0
19,600
163
5233
Line and System Appurtenances
5,000
0
5,000
Direct -S
0.0%
100.0%
0
5,000
164
525
Computer Equipment/Sopware
0
0
0
Direct -S
0.0%
100.0%
0
0
165
5401
Books /Subscriptions
400
0
400
Direct -S
0.MI
100.0%
0
400
166
5402
Professional Dues
580
0
580
Direct -S
0.0%
100.0%
0
580
167
5405
Training Expense
2,400
0
2,400
Direct -S
0.0%
100.0%
0
2,400
168
6302
Capital Improvements
50,000
(50,000) 171
0
Direct -S
0.0%
1000%
0
0
169
6400
Equipment
6,000
(6,000) 141
0
Direct -S
00%
1000%
0
0
170
6401
Vehicle Replacement
0
0 14]
0
Direct -S
0.0%
100.0%
0
0
171
7100
Principal - Pick -up Truck Lease
0
0
0
Direct -S
0.0%
100.0%
0
0
172
7200
Interest - Pick -up Truck Lease
0
0
0
Direct -S
0.0%
100.0%
0
0
173
Total Operating
Expenses
$975,470
($56,000)
$919,470
$0
$919,470
174
Total Wastewater Utility Facility (535)
$1,358,595
($56,000)
$1,302,595
$0
$1,302,595
Wastewater Utility
Operating (535.1)
Personal Services
175
1200
Regular Salaries R Wages
$226,840
$0
$226,840
Direct -S
00%
1000%
$0
$226,840
176
1400
Overtime Pay
23,060
0
23,060
Direct -S
00%
1000%
0
23,060
177
2100
FICA Taxes
19,125
0
19,125
Direct -S
0.0%
100.0%
0
19,125
178
2200
Retirement Contributions
57,255
0
57,255
Direct -S
00%
100.0%
0
57,255
179
2300
Health Insurance
62,000
0
62,000
Direct -S
0.0%
100.0%
0
62,000
180
2301
Life Insurance
655
0
655
Direct -S
0.0%
100.0%
0
655
181
2302
DentalNision Insurance
2,100
0
2,100
Direct -S
0.0%
100.0%
0
2,100
182
2303
Accident /Disability Insurance
1,755
0
1,755
Direct -S
00%
1000%
0
1,755
183
2400
Worker Comp_ Insurance
3,500
0
3,500
Direct -S
0.0%
100.0%
0
3,500
184
2500
Unemployment Compensation
0
0
0
Direct -S
0.0%
100.0%
0
0
185
Additional Personnel
0
0
0
Calculated
50.0%
500
0
0
186
'Total Personal
Services
$396,290
$0
$396,290
$0
$396,290
Operating Expenses
187
3102
Engineering Expense
$0
$0
$0
Direct -S
00
100.0%
$0
$0
188
3400
Contractual Services
58,240
0
58,240
Direct -S
0.0%
100.0%
0
58,240
189
4000
Travel Expense
2,800
0
2,800
Direct -S
00o"
100 0%
0
2,800
190
4100
Telephone Expense
24,720
0
24,720
Direct -S
00%
1000%
0
24,720
191
4200
Postage and Freight
1,000
0
1,000
Direct -S
00%
1000%
0
1,000
192
4300
Electric Expense
70,000
0
70,000
Direct -S
00%
1000%
0
70,000
193
4301
Water Expense
0
0
0
Direct -S
0.0%
100.0%
0
0
194
4400
Leasing Expense
2,500
0
2,500
Direct -S
0.0%
100.0%
0
2,500
195
4501
Auto Liability Insurance
6,410
0
6,410
Direct -S
0 0%
100 0%
0
6,410
196
4502
Multi -Peril Insurance
36,205
0
36,205
Direct -S
00%
1000%
0
36,205
197
4600
Water Sampling
500
0
500
Direct -S
0.0%
100.090
0
500
198
4605
Vehicle Parts and Repair
20,600
0
20,600
Direct -S
0.0%
1000%
0
20,600
199
4663
Emergency Repairs -Ulil_
29,000
0
29,000
Direct -S
0 0%
1000%
0
29,000
200
4902
Miscellaneous Expense
3,000
0
3,000
Direct -S
0.0%
100.0%
0
3,000
201
5100
Office Supplies
0
0
0
Direct -S
0.0%
100.0%
0
0
202
5200
POL Supplies
25,600
0
25,600
Direct -S
0.0%
100.0%
0
25,600
203
5201
Uniforms
2,510
0
2,510
Direct -S
0.0%
100.0%
0
2,510
204
5202
Operating Supplies
45,000
0
45,000
Direct -S
0.0%
100.0%
0
45,000
205
5208
Chemical Expense
1,500
0
1,500
Direct -S
0.0%
100.0%
0
1,500
206
5209
Electrical Supplies
5,000
0
5,000
Direct -S
0.0%
1000%
0
5,000
�o
Table 6
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Allocation of Onerafine Expenses to Individual Svstems I I
Line
Budget
Adjusted
Allocation Percentages
Adjusted 2013
No
Description
2013
Adjustments
2013
Basis
Water Wastewater
Water
Wastewater
(c)
(d)
(e)
(f)
(g)
(h)
(i)
0)
207
5217 Water Meters
20,000
0
20,000
Direct -S
0.0%
100.0%
0
20,000
208
5230 Small Equipment
13,000
0
13,000
Direct -S
QO%
IOQO%
0
13,000
209
5233 Line and System Appurtenances
12,000
0
12,000
Direct -S
0.0%
100.0%
0
12,000
210
5235 Computer Equipment/Software
0
0
0
Direct -S
0.0%
100.0%
0
0
211
5401 & 5402 Books /Subscriptions and Professional Dues
465
0
465
Direct -S
0.0%
100.00
0
465
212
5405 Training Expense
2,900
0
2,900
Direct -S
0.0%
100.0%
0
2,900
213
6302 Capital Improvements
37,000
(37,000) 1
0
Direct -S
0.0%
100.0%
0
0
214
6400 Equipment
92,500
(92,500) 181
0
Direct -S
0.0%
100.0 °,0
0
0
215
6401 Vehicle Replacement
0
0 [8]
0
Direct -S
00%
100.0%
0
0
216
7100 Principal - Pick -up Truck Lease
0
0
0
Direct -S
0.0%
100.0%
0
0
217
7200 Interest - Pick -up Truck Lease
0
0
0
Direct -S
Qo%
100.0%
0
0
218
Total Operating Expenses
$512,450
($129,500)
$382,950
$0
$382,950
219
'Total Wastewater Utility Operating (535.1)
$908,740
($129,500)
$779,240
$0
$779,240
Non - Departmental -Fund Transfers
Fund Transfers
220
9100 Transfer from 533 to Debt Service
$108,760
($108,760) 191
$0
Direct-\V
100.0%
0.0%
$0
$0
221
9100 Transfer from 535 to Debt Service
447,175
(447,175) 191
0
Direct -S
0.0%
100.0%
0
0
222
9101 Transfer from 533 to Admin.
705,000
(705,000) 191
0
Direct -W
1000%
0.0%
0
0
223
9101 Transfer from 533.1 to Admin.
2,960
(2,960) 191
0
Direct -W
100.0%
0.0 °,o
0
0
224
9101 Transfer from 535 to Admin.
705,000
(705,000) 191
0
Direct -S
0.0%
100 0%
0
0
225
9101 Transfer from 535. I to Admin.
5,895
(5,895) 19J
0
Direct -S
0.0%
1000%
0
0
226
9104 Transfer from 533 to R&R
300,000
(300,000) 1
0
Direct -W
100 0%
0.0%
0
0
227
9104 Transfer from 535 to R &R
549,120
(549,120) 191
0
Direct-S
0.0%
100 0%
0
0
228
Interest from Fund 533 and 535
0
0 1
0
Direct -W
100.0%
0.0%
0
0
229
Other Fund Transfers from 535
0
0 1
0
Direct -S
0.0%
100 0 1 / 1 .
0
0
230
Total Non - Departmental -Fund Transfers
$2,823,910
(52,823,910)
$0
$0
$0
231
Total Operating and Maintenance Costs
$8,681,070
($3,622,135)
$5,058,935
$2,675,285
$2,383,650
Footnotes.
[I]
Based on information provided by the City's Utilities and Finance
Departments.
[2]
Amount reflects an additional adjustment for if contingency so
that the adjusted contingency
amount is equal
to 1.0% of budgeted expenditures;
and ii) bad debt, so that the adjuuted bad debt amount is equal to
03% of projected rate
revenues.
[3]
'The following projects are adjusted from projected Cost of Operation and Maintenance (operating expenses) and reflected in
the capital improvements
program_
Stand Alone Projects
Arden Park South (8" - 16 ")
$100,000
Total Projects Reflected on CIP
$100,000
Part of Capital Outlay
SR 50 Widening (Relocation of Water and Sewer Mains)
$150,000
Total Projects Reflected on CIP
$150,000
[4]
Equipment expenses and other capital outlay are adjusted from
projected Cost of Operation
and Maintenance
(operating expenses)
and reflected
in the capital improvements
program.
[5]
The following projects are adjusted from projected Cost of Operation and Maintenance
(operating expenses) and reflected in
the capital improvements
program_
Stand Alone Projects
Water Plants Repairs and Upgrades
$20,000
South Water Plant Entrance Improvements
10,000
Forest Oaks Phase 1 LISP $4 Improvements
20,000
Water Plants Repairs and Upgrades
25,000
Water Plants SCADA Instrumentation (Replacement)
250,000
Total Projects Reflected on CIP
$325,000
Part of Capital Outlay
Forest Oaks - Reroof Building
$7,000
Total Projects Reflected on CIP
$7,000
[6]
The following projects are adjusted from projected Cost of Operation and Maintenance
(operating expenses) and reflected in
the capital improvements
program_
Stand Alone Projects
Minor Water Lines (Replacement & Upgrades)
$15,000
Fire Hydrants - New and Replacements
15,000
Total Projects Reflected on CIP
$30,000
f7]
The following projects are adjusted from projected Cost of Operation and Maintenance (operating expenses)
and reflected in
the capital improvements
program.
Stand Alone Projects
Wastewater Plant Repairs and Upgrades
$20,000
Forest Lakes Golf Course Reclaimed Isolation Valve
30,000
Total Projects Reflected on CIP
$50,000
[8]
The following projects are adjusted front projected Cost of Operation
and Maintenance
(operating expenses)
and reflected in
the capital improvements
program:
Stand Alone Protects
Sanitary Sewer Manhole Replacements
$15,000
Centralized Non SCADA Alarm Center for Lill Stations
22,000
Total Projects Reflected on CIP
$37,000
[9]
Other costs that are not considered as components of the Cost
of Operation and Maintenance
(operating expenses)
including
transfers are reflected
in the revenue
requirements
summary, as
applicable.
Page 1 of 1
Table 7
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Expense Allocation References
Allocation Percentages
Line
Water
Wastewater
No.
Description
Basis
System
System
Total
1
Direct Water System
Direct -W
100.0%
0.0%
100.00%
2
Direct Sewer System
Direct -S
0.0%
100.0%
100.00%
3
Equal
Equal
50.0%
50.0%
100.00%
4
Revenues
Revenues
44.7%
55.3%
100.00%
5
Salaries and Wages
Salaries
59.6%
40.4%
100.00%
6
Operating Expenses
Expenses
52.9%
47.1%
100.00%
7
Customer Accounts
Accounts
60.2%
39.8%
100.00%
8
Additional Allocator 1
Al
50.0%
50.0%
100.00%
Accounts Allocation
Description
Basis of Allocation
Water
Wastewater
Total
9
No. of Accounts, FY 2012
11,079
7,313
18,392
10
Customer Accounts Allocation
Accounts
60.2%
39.8%
100.0%
Salaries Expense Allocation
Fiscal Year 2013 Budget
Department
Water
Wastewater
Total
11
Water Operating Fund (533 and 533.1)
$1,151,545
$0
$1,151,545
12
Wastewater Operating Fund (535 and 535.1)
0
779,415
779,415
13
Total
$1,151,545
$779,415
$1,930,960
14
Salaries Expense Allocation
Salaries
59.6%
40.4%
100.0%
Revenues Allocation
Description
Basis of Allocation
Water
Wastewater
Total
15
Revenues FY 2013
$3,804,592
$4,699,229
$8,503,821
16
Customer Accounts Allocation
Revenues
44.7%
55.3%
100.0%
Page 1 of 1
Table 8
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Expense Escalation Factors for Operating Expenses for Cost of Operation and Maintenance (Operating Expenses)
Line
No. Description
Escalation
Reference
Projected Fiscal Year Ending September 30,
2014 2015 2016 2017
(b) (c) (d) (e)
(a)
1
General Inflation [1]
Inflation
1.0170
1.0210
1.0210
1.0220
2
Labor Escalator
Labor
1.0300
1.0300
1.0300
1.0300
3
Repair and Maintenance
Repair
1.0400
1.0400
1.0400
1.0400
4
Life /Health /Disability Insurance Escalator
Ins - Health
1.0500
1.0500
1.0500
1.0500
5
Property Insurance Escalator
Ins- Property
1.0400
1.0400
1.0400
1.0400
6
Marginal Escalator
Margin
1.0100
1.0100
1.0100
1.0100
7
Constant
Constant
1.0000
1.0000
1.0000
1.0000
8
Elimination
Eliminate
0.0000
0.0000
0.0000
0.0000
9
Power Gas /Oil
Power
1.0500
1.0500
1.0500
1.0000
10
Other Escalator
Other
0.0000
0.0000
0.0000
0.0000
11
Electric Expense Admin
Power -Adm
1.0500
1.0500
1.0500
1.0500
12
Water Expense
Util W/W W
1.0000
1.0000
1.0000
1.0000
13
Power Gas/Oil + Inflation (Water)
Power -W
1.0681
1.0674
1.0521
1.0524
14
Power Gas /Oil + Inflation (Wastewater)
Power-WW
1.0706
1.0707
1.0709
1.0711
15
Operation Expenses
Expenses
1.0421
1.0382
1.0371
1.0382
16
Customer Acct. Growth + Inflation (Water)
Cust -Water
1.0340
1.0379
1.0380
1.0391
17
Customer Acct. Growth + Inflation (Sewer)
CUSt -Sewer
1.0346
1.0387
1.0387
1.0398
18
Reclaimed Water Purchases
Purch R/C
1.3172
1.1249
1.1044
1.1130
19
Rate Revenue - Water
Water Rev
1.0161
1.0156
1.0080
1.0082
20
Rate Revenue - Sewer
Sewer Rev
1.0175
1.0177
1.0178
1.0179
Footnotes:
[1] Congressional Budget Office: "The Budget and Economic Outlook: Fiscal Years 2013 to 2023" February 2013 Edition.
Page I of 3
Table 9
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Cost of Oneration and Maintenance (Operative Expenses) - Water System Ill
Fiscal Year Ending
September 30,
Line
Adjusted
Escalation
Escalation
Escalation
Escalation
No.
Description
2013
Reference
2014
Reference
2015
Reference
2016
Reference
2017
Water and Wastewater Administration Fund (531)
Personal Services
1
Regular Salaries &Wa
$174,601
Labor
$179,839
Labor
$185,234
Labor
$190,791
Labor
$196,515
2
Overtime Pay
10,168
Labor
10,473
Labor
10,787
Labor
11,111
Labor
11,444
3
FICA Taxes
14,137
Labor
14,561
Labor
14,998
Labor
15,448
Labor
15,911
4
Retirement Contributions
42,334
Labor
43,604
Labor
44,912
Labor
46,259
Labor
47,647
5
Health Insurance
26,135
4-Health
27,441
Ins - Health
28,813
Ins - Ilcalth
30,254
Ins - Ilcalth
31,767
6
Life Insurance
483
Labor
497
Labor
512
Labor
528
Labor
543
7
Dental/Vision Insurance
1,043
Labor
1,074
Labor
1,107
Labor
1,140
Labor
1,174
8
Accident /Disability Insurance
1,359
Labor
1,400
Labor
1,442
Labor
1,485
Labor
1,529
9
Worker Comp. Insurance
2,253
labor
2,320
Labor
2,390
Labor
2,462
Labor
2,536
10
Additional Personnel
0
Input
0
Input
0
Input
If
Input
0
11
1oral Personal Costs
$272,512
$281,210
$290,195
$299,477
$309,067
Operating Expenses
12
Legal Expense
$5,960
Inflation
$6,061
Inflation
$6,189
Inflation
$6,319
Inflation
$6,458
13
Professional Services /Other
53,578
Inflation
54,489
Inflation
55,633
Inflation
56,801
Inflation
58,051
14
Contractual Services
2,155
Inflation
2,192
Inflation
2,238
Inflation
2,285
Inflation
2,335
15
Travel Expense
262
Inflation
267
Inflation
272
Inflation
278
Inflation
284
16
POWRPiogram
21,158
Inflation
21,518
Inflation
21,970
Inflation
22,431
Inflation
22,924
17
Telephone Expense
6,163
Inflation
6,267
Inflation
6,399
Inflation
6,533
Inflation
6,677
18
Postage and Freight
2,444
Inflation
2,485
Inflation
2,537
Inflation
2,591
Inflation
2,648
19
Electric Expense
2,861
Poncer -Aden
3,004
P.ncer -Ada
3,154
Porcer -Aden
3,312
P-er -Ada
3,477
20
Water Expense
715
lint WAVW
715
UII WAvw
715
Util WANW
715
Uto wAvw
715
21
Leasing Expense
1,550
Repair
1,612
Repair
1,676
Repair
1,743
Repair
1,813
22
Auto Liability Insurance
134
Repair
139
Repair
145
Repair
151
Repair
157
23
Multi -Peril Insurance
3,475
Ins - Property
3,614
Ins -Propc t,
3,758
Ins- Prol -v,
3,909
Ins- Propertc
4,065
24
Building Maintenance
298
Inflation
303
Inflation
309
Inflati on
316
Inflation
323
25
Vehicle Parts and Repairs
492
Rcpak
511
Repair
532
Repair
553
Repair
575
26
Equip. Maintenance and Contracts
2,193
Inflation
2,231
Inflation
2,277
Inflation
2,325
Inflation
2,376
27
Emergency Repairs
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
28
Miscellaneous Expense
596
Inflation
606
hrfladar
619
Inflation
632
Inflation
646
29
Bad Debt Write Offs 121
9,511
Input 12]
9,955
Input 12]
10,413
Input 121
10,811
Input 121
11,226
30
Office Supplies
1,192
Inflation
1,212
Inflation
1,238
Inflation
1,264
Inflation
1,292
31
POL Supplies
3,189
Inflation
3,243
Inflation
3,311
Inflation
3,380
Inflation
3,455
32
Uniforms
918
Inflation
933
Inflation
953
Inflation
973
Inflation
994
33
Operating Supplies & Electrical Supplies
3,576
Inflation
3,637
Inflation
3,713
Inflation
3,791
Inflation
3,875
34
Employee Gift Certificates
1,013
Inflation
1,030
Inflation
1,052
Inflation
1,074
Inflation
1,098
35
Emergency Management
1,788
Inflation
1,818
],,nation
1,857
Inflation
1,896
Inflation
1,937
36
Small Equipment
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
37
Computer Equipment/Software
3,159
Inflation
3,212
Inflation
3,280
Inflation
3,349
Inflation
3,423
38
Books/Subscriptions
1,043
Inflation
1,061
Inflation
1,083
Inflation
1,106
Inflation
1,130
39
Professional Dues
507
Inflation
515
Inn ❑non
526
Inflation
537
Inflation
549
40
Training Expense
1,550
Inflation
1,576
Inflation
1,609
Inflation
1,643
Inflation
1,679
41
Reserve for Contingency 12]
26,488
Input 121
27,313
Input 121
28,194
Input 121
29,066
Input 121
29,977
42
Capital lmprovements 13]
0
Eliminate
0
climinatc
0
[laminate
0
Ifinunatc
0
43
Capital - Comp. Equip. /Software
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
44
Principal - SUV Lease
0
Eliminmc
0
Eliminate
0
Eliminate
0
Eliminate
0
45
Interest - SUV Lease
0
Eliminate
0
Eliminate
0
climinatc
0
Eliminate
0
46
Total Operating Services
$157,966
$161,520
$165,652
$169,782
$174,159
47
Total Water and Wastewater Admin. (Fund .53 1)
$430,478
$442,730
$455,848
$469,260
$483,225
Water Utilities Facilities (533)
Personal Services
48
Regular Salaries &Wages
$180,840
Labor
$186,265
Labor
$191,853
Labor
$197,609
Labor
$203,537
49
Overtime Pay
11,740
Labor
12,092
Labor
12,455
Labor
12,829
Labor
13,213
50
FICA Taxes
14,735
Labor
15,177
Labor
15,632
Labor
16,101
labor
16,584
51
Retirement Contributions
44,125
Labor
45,449
Labor
46,812
Labor
48,217
Labor
49,663
52
Health Insurance
20,950
Ins- Ileahh
21,998
Ins - ]lentil,
23,097
Ins - health
24,252
Ins- Haalth
25,465
53
Life Insurance
565
Labor
582
Labor
599
Labor
617
Labor
636
54
Dental /Vision Insurance
1,050
labor
1,082
Labor
1,114
Labor
1,147
Labor
1,182
55
Accident/Disability Insurance
1,380
Labor
1,421
labor
1,464
Labor
1,508
Labor
1,553
56
Woiker Comp. Insurance
4,070
Labor
4,192
Labor
4,318
Labor
4,447
Labor
4,581
57
Unemployment Compensation
0
Labor
0
Labor
0
Labor
0
Labor
0
58
Additional Personnel
0
Input
0
Input
0
Input
0
Input
0
59
Total Personal Costs
$279,455
$288,258
$297,345
$306,728
$316,415
Page 2 of 3
Table 9
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Cost of Operation and Maintenance (Operating Expenses) - Water Svstem Ill
Fiscal Year Ending September 30,
Line
Adjusted
Escalation
Escalation
Escalation
Escalation
No.
Description
2013
Reference
2014
Reference
2015
Reference
2016
Reference
2017
Operating Expenses
60
Professional Sets ices /Other
$0
Inflation
$0
Inflation
$0
Inflation
$0
Inflation
$0
61
Accounting and Auditing
6,750
Inflation
6,865
Inflation
7,009
Inflation
7,156
Inflation
7314
62
Contractual Services
26,120
Inflation
26,564
Inflation
27,122
Inflation
27,691
Inflation
28301
63
Travel Expense
2,250
Inflation
2,288
Inflation
2,336
Inflation
2,385
Inflation
2,438
64
Telephone Expense
8,550
Inflation
8,695
Inflation
8,878
Inflation
9,064
Inflation
9,264
65
Postage and Freight
400
Inflation
407
Inflation
415
Inflation
424
Inflation
433
66
Electric Expense
250,000
Ponccr-W
267,025
Poocr -W
285,022
Poncer -W
299,872
P.m -W
315,585
67
Leasing Expense
600
Repair
624
Rcpair
649
Repair
675
Repair
702
68
Auto Liabilitylnsurance
1,065
Repair
1,108
Repair
1,152
Repair
1,198
Rcpair
1,246
69
Multi- Peril lnsmance
21,080
Ins- Paipeny
21,923
Ins - Prop -n,
22,800
Ins-Propem
23,712
Ins- Propem
24,661
70
Water Sampling
15,660
Cast -Water
16,193
Cust -Water
16,807
Cust -Water
17,446
Cust -Water
18,127
71
Building Maintenance
28,700
Inflation
29,188
Inflation
29,801
Inflation
30,427
Inflation
31,096
72
Vehicle Parts and Rcpair
4,945
Repair
5,143
Repair
5,349
Repair
5,562
Repair
5,785
73
Equipment Maintenance Contracts
0
Rcpair
0
Rcpair
0
Repair
0
Repair
0
74
Emergency Repairs -Util.
22,500
Rcpair
23,400
Rcpair
24,336
Rcpair
25,309
Rcpair
26,322
75
Miscellaneous Expense
3,825
Inflation
3,890
Inflation
3,972
Inflation
4,055
Inflation
4,144
76
Office Supplies
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
77
POI, Supplies
11,750
Innmim
11,950
Inflation
12,201
Inflation
12,457
Inflation
12,731
78
Uniforms
1,290
Inflation
1,312
Inflation
1,339
Inflation
1,368
Inflation
1,398
79
Operating Supplies
31,000
Cast -Water
32,055
Cust -Water
33,271
Cust -Water
34,535
Cust -Waur
35,884
80
Chemical Expense
86,600
Cust -Water
89,546
Cost -Water
92,944
Cost -Water
96,476
Cnst -Water
100,244
81
Electrical Supplies & Copying Expense
14,200
Inflation
14,441
Inflation
14,745
Inflation
15,054
Inflation
15,386
82
Water Meters
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
83
Small Equipment
21,000
Inflation
21,357
Inflation
21,805
Inflation
22,263
Inflation
22,753
84
Line and System Appurtenances
24,500
Inflation
24,917
Inflation
25,440
Inflation
25,974
Inflation
26,545
85
Computer Equipment /Sollware
3,000
Inflation
3,051
Inflation
3,115
Inflation
3,180
Inflation
3,250
86
Books /Subscriptions
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
87
Professional Dues
400
Inflation
407
Inflation
415
Inflation
424
Inflation
433
88
Training Expense
3,200
Inflation
3,254
Inflation
3,323
Inflation
3,393
Inflation
3,467
89
Interest Expense
3,000
Inflation
3,051
Inflation
3,115
Inflation
3,180
Inflation
3,250
90
Capital lmpro'ements
131 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
91
Equipment
131 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
92
Vehicle Replacement
0
Eliminate
0
Eliminate
0
Elminato
0
Elfminam
0
93
Principal - Pick -up ]'nick Lease
0
Eliminate
0
Elh„man,
0
Lh inatc
0
Eli mate
0
94
Interest - Pick -up Track Lease
0
Eliminate
0
Eliminate
0
Fliminatc
0
Eliminate
0
95
Total Operating Services
$592,385
$618,653
$647362
$673,283
$700,759
96
Total Water Utilities Facilities (533)
$871,840
$906,911
$944,707
$980,010
$1,017,174
Water Utility Operating (533.1)
Personal Costs
97
Regular Salaries & Wages
$542,785
Labor
$559,069
Labor
$575,841
Labor
$593,116
Labor
$610,909
98
Overtime Pay
36,350
Labor
37,441
labor
38,564
Labor
39,721
Labor
40M2
99
FICA Taxes
44,310
Labor
45,639
Labor
47,008
Labor
48,419
labor
49,871
100
Retirement Contributions
132,685
Labor
136,666
Labor
140,766
Labor
144,988
Labor
149,338
101
I Iealth Insurance
91,350
Ins- Hcalih
95,918
Ins- Ilealth
100,713
Ins- Ilealth
105,749
Ins- 11ealth
111,036
102
Life Insurance
1,590
Labor
1,638
labor
1,687
Labor
1,737
Labor
1,790
103
Dental /Vision Insurance
5,250
Labor
5,408
Labor
5,570
Labor
5,737
Labor
5,909
104
Accident/Disability Insurance
4,205
Labor
4,331
Labor
4,461
Labor
4,595
Labor
4,733
105
Worker Comp. Insurance
11,065
Labor
11,397
Labor
11,739
labor
12,091
Labor
12,454
106
Unemploy'mentCompensation
2,500
tabor
2,575
Labor
2,652
Labor
2,732
Labor
2,814
107
Additional Personnel
0
Input
0
Input
0
Input
0
Inpm
0
108
Total Personal Costs
$872,090
$900,080
$929,000
$958,885
$989,766
Page 3 of 3
Table 9
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Cost of Operation and Maintenance (Operating Expenses) - Water System I l I
Line
No.
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
Operating Expenses
Contractual Services
Travel Expense
Telephone Expense
Postage and Freight
Leasing Expense
Auto Liability Insurance
Multi -Peril Insurance
Water Sampling
Vehicle Parts and Repair
Equipment Maintenance Contracts
Emergency Repairs -Util.
Miscellaneous Expenses
POL Supplies
Uniforms
Operating Supplies
Electrical Supplies
Water Meters
Small Equipment & Computer Equipment
Books /Subscriptions
Professional Dues
Training Expense
Capital Improvements
Equipment
Vehicle Replacement
Principal - Pick -up 77uck Lease
Interest - Pick -up Truck Lease
Total Operating Services
136 Total Water Utilities Facilities (533)
148 Total Operating and Maintenance Costs
149 Annual Increase
Footnotes:
Fiscal Year Ending September 30,
Adjusted Escalation Escalation Escalation Escalation
2013 Reference 2014 Reference 2015 Reference 2016 Reference 2017
$33,480
Non - Departmental -Fund Transfers
$34,049
Fund Transfers
137
Transfer from 533 to Debt Service
138
Transfer front 535 to Debt Service
139
Transfer from 533 to Admor
140
Transfer front 533.1 to Admin.
141
Transfer front 535 to Admin.
142
Transfer front 535.1 to Admin.
143
Transfer front 533 to MR
144
Transfer from 535 to R &R
145
Interest front Fund 533 and 535
146
Other Fund Transfers front 535
147
Total Non- Departamental -Fund Transfers
148 Total Operating and Maintenance Costs
149 Annual Increase
Footnotes:
Fiscal Year Ending September 30,
Adjusted Escalation Escalation Escalation Escalation
2013 Reference 2014 Reference 2015 Reference 2016 Reference 2017
$33,480
Inflation
$34,049
Inflation
$34,764
Inflation
$35,494
Inflation
$36,275
4,500
Inflation
4,577
Inflation
4,673
Inflation
4,771
Inflation
4,876
6,060
Inflation
6,163
Inflation
6,292
Inflation
6,425
Inflation
6,566
1,000
Inflation
1,017
Inflation
1,038
Inflation
1,060
Inflation
1,083
2,500
Inflation
2,543
Inflation
2,596
Inflation
2,650
Inflation
2,709
3340
Inflation
3,397
Inflation
3,468
Inflation
3,541
Inflation
3,619
35,840
Ins - Propene
37,274
Ins- Propertc
38,765
Ins- Propartc
40,315
Ins- Properr,
41,928
2,000
Cost -Water
2,068
Cost -Water
2,147
('a, -Water
2,228
Cost -Water
2,315
16,200
Repair
16,848
Repair
17,522
Repair
18,223
Repair
18,952
0
Repair
0
Repair
0
Repair
0
Repair
0
22,227
Repair
23,116
Repair
24,041
Repair
25,002
Repair
26,002
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
46,700
Inflation
47,494
Inflation
48,491
Inflation
49,510
Inflation
50,599
6,625
Inflation
6,738
Inflation
6,879
Inflation
7,024
Inflation
7,178
90,000
Cost -Water
93,062
Cost -Water
96,593
Cust -Water
100,263
Cost -Water
104,179
250
Inflation
254
Inflation
260
Inflation
265
Inflation
271
131 220,415
Constmn
220,415
Constant
220,415
Constant
220,415
Constant
220,415
7,200
Inflation
7,322
Inflation
7,476
Inflation
7,633
Inflation
7,801
80
Inflation
81
Inflation
83
Inflation
85
Inflation
87
460
Inflation
468
Inflation
478
Inflation
488
Inflators
498
2,000
Inflation
2,034
Inflation
2,077
Inflation
2,120
Inflation
2,167
1 0
Eliminate
0
Eliminate
0
Fliminote
0
Eliminate
0
I31 0
Elimitate
0
Eliminate
0
Eliminate
0
Eliminate
0
131 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
0
Eliminate
0
Eliminate
0
Eliminate
0
F.liminot,
0
$500,877
$508,919
$518,057
$527,512
$537,520
$1,372967
$1,408999
$1,447,058
$1,486,397
$1,527,286
141 $0
Eliminate
$0
Eliminate
$0
Eliminate
$0
Eliminate
$0
[4] 0
Eliminate
0
Eliminate
0
Eluturate
0
Eliminate
0
1 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
141 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
141 0
Eliminate
0
Eliminalc
0
Eliminate
0
Eliminate
0
1 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
141 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
141 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
141 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
1 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
0
0
0
0
0
$ 2,675,285
S 2,758,639
$ 2.847,612
$ 2,935,667
$ 3,027,686
3.12%
3,23%
3.09%
3.13%
[l] Based on information provided by the City's Utilities and Finance Departments.
[2] Amount reflects an additional adjustment for: if contingency so that the adjusted contingency amount is equal to 1.0% of budgeted expenditures;
and ii) bad debt, so that the adjsuted bad debt amount is equal to 0.3% of projected rate revenues.
[3] Equipment expenses and other capital outlay are adjusted front projected operating expenses and reflected in the capital improvements program
as applicable.
[4] Other non- operating expenses and transfers are reflected in revenue requirements summary, as applicable.
Page 1 of 3
Table 10
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Cost of Operation and Maintenance (Operating Expenses) - Wastewater System 111
Line
No.
Description
Adjusted
2013
Escalation
Reference
2014
Fiscal Year Ending September 30,
Escalation Escalation
Reference 2015 Reference
2016
Escalation
Reference
2017
Water and Wastewater Administration Fund (531)
Personal Services
I
Regular Salai ies & Wages
$118,354
Labor
$121,904
Labor
$125,562
Labor
$129,328
Labor
$133,208
2
Overtime Pay
6,892
Labor
7,099
Labor
7,312
Labor
7,531
Labor
7,757
3
FICA Taxes
9,583
Labor
9,870
Labor
10,166
Labor
10,471
labor
10,786
4
Retirement Contributions
28,696
Labor
29,557
tabor
30,444
Labor
31,357
Labor
32,298
5
Health Insurance
17,715
Ins - Health
18,601
Ins - Health
19,531
bs- Health
20,508
Ins - Health
21,533
6
Lifelnsurance
327
Labor
337
Labor
347
labor
358
Labor
368
7
Dental /Vision Insurance
707
Labor
728
Labor
750
Labor
773
Labor
796
8
Accident /Disability Insurance
921
Labor
949
Labor
977
Labor
1,007
Labor
1,037
9
WorkerContp.Insurance
1,527
Labor
1,573
Labor
1,620
Labor
1,669
Labor
1,719
10
Additional Personnel
0
Labor
0
Labor
0
Labor
0
Labor
0
11
Total Personal Costs
$184,723
$190,619
$196,710
$203,001
$209,502
Operating Expenses
12
Legal Expense
$4,040
Inflation
$4,109
Inflation
$4,195
Inflation
$4,283
Inflation
$4,377
13
Professional Services /Other
35,422
Inflation
36,024
Inflation
36,781
Inflation
37,553
Inflation
38,379
14
Contractual Services
1,425
Inflation
1,449
Infla on
1,479
Inflation
1,511
Inflation
1,544
15
Travel Expense
178
Inflation
181
Inflation
185
Inflation
188
Inflation
193
16
POWR Program
14,342
Inflation
14,586
Inflmlon
14,892
Inflation
15,205
Inflation
15539
17
Telephone Expense
4,177
Inflation
4,248
Inflation
4,338
Inflation
4,429
Inflation
4,526
18
Postage and Freight
1,656
Inflation
1,685
Inflation
1,720
Inflation
1,756
Inflation
1,795
19
Electric Expense
1,939
Ponmr -Aden
2,036
Poo -Adm
2,138
Ponccr -Adnn
2,245
Poaer -Aden
2,357
20
Water Expense
485
Util w/Ww
485
Util W/WW
485
Uul WAVW
485
lIll W/WW
485
21
Leasing Expense
1,050
Repair
1,092
Repair
1,136
Repair
1,182
Repair
1,229
22
Auto Liability Insurance
91
Repair
95
Repair
98
Repair
102
Repair
106
23
Multi- Peril lnsuiance
2,355
Ins- Propm,
2,450
Ins - Property
2,548
Ins- Propcn,
2,649
Ins- Propem
2,755
24
Building Maintenance
202
Inflation
205
Inflation
210
Inflation
214
Inflation
219
25
Vehicle Parts and Repairs
333
Repair
347
Repair
360
Repair
375
Repair
390
26
Equip. Maintenance and Contracts
1,487
Inflation
1,512
Inflation
1,544
Inflation
1,576
Inflation
1,611
27
Emergency Repairs
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
28
Miscellaneous Expense
404
Inflation
411
inflation
419
Inflation
428
Inflation
438
29
Bad Debt Write Offs
121 11,748
Input 121
13,039
lapin 121
13,940
Input 121
14,837
Input 12]
15,840
30
Office Supplies
808
Inflation
822
Inflation
839
Inflation
857
Inflation
875
31
POL Supplies
2,161
Inflation
2,198
Inflation
2,244
Inflation
2,291
Inflation
2,342
32
Uniforms
622
Inflation
633
Inflation
646
Inflation
660
Inflation
674
33
Operating Supplies & Electrical Supplies
2,424
Inflation
2,465
Inflation
2,517
Inflation
2,570
Inflation
2,626
34
Employee Gift Certificates
687
Inflation
698
Inflation
713
Inflation
728
Inflation
744
35
Emergency Management
1,212
Inflation
1,233
Inflation
1,258
Inflation
1,285
Inflation
1,313
36
Small Equipment
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
37
Computer Equipment /Software
2,141
Inflation
2,178
Inflation
2,223
Inflation
2,270
Inflation
2,320
38
Books /Subscriptions
707
Inflation
719
Inflation
734
Inflation
750
Inflation
766
39
Professional Dues
343
Inflation
349
Inflation
357
Inflation
364
Inflation
372
40
Training Expense
1,050
Inflation
1,068
Inflation
1,091
Inflation
1,114
Inflation
1,138
41
Reserve for Contingency
121 23,600
Input 121
24,883
Input 121
25,998
lapnt 121
27,137
Input 121
28,372
42
Capital lmproventents
131 0
Eliminate
0
Eliminate
0
F.linurnate
0
Eliminate
0
43
Capital - Comp. Equip. /Software
0
Eh n"t,
0
Eliminate
0
Eliminate
0
Eliminate
0
44
Principal - SUV lease
0
Eliminate
0
Eliminate
0
Ebminatc
0
Eli inntc
0
45
Interest - SUVLease
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
46
Total Operating Set N ices
$117,092
$121,200
$125,088
$129,042
$133,326
47
Total Water and Wastewater Admin. (Fund _531)
$301,815
$311,818
$321,797
$332,044
$342,828
Wastewater Utility Facility (53.5)
Personal Sets ices
48
Regular Salaries & Wages
$238,670
labor
$245,830
Labor
$253,205
Labor
$260,801
Labor
$268,625
49
Overtime Pay
13,200
Labor
13,596
Labor
14,004
labor
14,424
Labor
14,857
50
FICA Taxes
19,270
Labor
19,848
Labor
20,444
Labor
21,057
Labor
21,689
51
Retirement Contributions
57,710
Labor
59,441
Labor
61,225
Labor
63,061
Labor
64,953
52
Health Insurance
43,850
Ins -w,,bb
46,043
Ins - Health
48,345
Ins- 1i,,,bh
50,762
Ins - Health
53,300
53
Life Insurance
685
Labor
706
Labor
727
Labor
749
Labor
771
54
Dental /Vision Insurance
1,750
Labor
1,803
Labor
1,857
Labor
1,912
Labor
1,970
55
Accident/Disability Insurance
1,910
Labor
1,967
labor
2,026
Labor
2,087
Labor
2,150
56
Worker Cmnp.Inswance
3580
Labor
3,687
Labor
3,798
Labor
3,912
Labor
4,029
57
Unemployment Compensation
2,500
Labor
2,575
Labor
2,652
Labor
2,732
Labor
2,814
58
Additional Personnel
0
loput
0
lapin
0
Input
0
Infant
0
59
Total Personal Services
$ 383,125
S 395,496
$ 408,281
$ 421,497
$ 435,157
Page 2 of 3
'fable 10
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Cost of Oueration and Maintenance ( Operatino Expenses) - Wastewater System 111
Fiscal Year
Ending September 30,
Line
Adjusted
Escalation
Escalation
Escalation
Escalation
No
Description
2013
Reference
2014
Reference
2015
Reference
2016
Reference
2017
Operating Expenses
60
Professional Services /Other
$0
Inflation
$0
Inflation
$0
Inflation
$0
Inflation
$0
61
Accounting and Auditing
8,000
Inflation
8,136
Inflation
8,307
Inflation
8,481
Inflation
8,668
62
Contractual Services
175,770
Inflation
178,758
Inflation
182,512
lnflation
186,345
Inflation
190,444
63
Travel Expense
2,610
Inflation
2,654
Inflation
2,710
Inflation
2,767
Inflation
2,828
64
Telephone Expense
8,000
Inflation
8,136
Inflation
8,307
Inflation
8,481
Inflation
8,668
65
Postage and Freight
300
Inflation
305
Inflation
312
Inflation
318
Inflation
325
66
Electric Expense
300,000
Pc,-WW
321,180
Nola AM
343,887
Porccr -WW
368,269
Ponccr -WW
394,453
67
Water Expense (Reclaimed Purchases)
150,980
Parch R/c
198,871
Parch R/C
223,710
Punch R/C
247,065
Punch We
274,983
68
Leasing Expense
500
Inflation
509
Inflation
519
Inflation
530
Inflation,
542
69
Auto Liability Insurance
140
Inflation
142
Inflation
145
Inflation
148
Inflation
152
70
Multi -Peril Insurance
20,980
Ins - Property
21,819
Ine-Propm,
22,692
Ins - Property
23,600
Ins - Property
24,544
71
Water Sampling
39,540
Cust -S,,
40,908
Cust- S,,
42,491
Cnst- Sencer
44,137
Cnst- Sencer
45,893
72
Building Maintenance
2,500
Inflation
2,543
Inflation
2,596
Inflation
2,650
Inflation
2,709
73
Vehicle Parts and Repair
2,475
Repair
2,574
Repair
2,677
Repair
2,784
Rcpair
2,895
74
Equipment Maintenance Contracts
0
Rcpair
0
Rcpair
0
Rcpair
0
Rcpair
0
75
Emergency Repairs -Util.
17,000
Rcpair
17,680
Rcpair
18,387
Repair
19,123
Rcpair
19,888
76
Miscellaneous Expense
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
77
Office Supplies & Copying Expense
300
Inflation
305
Inflation
312
Inflation
318
hmFlat an
325
78
POL Supplies
10,200
lnflation
10,373
Inflation
10,591
Inflation
10,814
Inflation
11,052
79
Uniforms
2,195
Inflation
2,232
Inflation
2,279
Inflation
2,327
Inflation
2,378
80
Operating Supplies
53,000
Cust -S-r
54,834
Cust -Scecr
56,956
Cut-Saccr
59,162
Cust- Scnccr
61,516
81
Chemical Expense
80,000
Cust- scnccr
82,768
oust -s-,
85,971
Cost- Senccr
89,301
Cust- Scnccr
92,854
82
Electrical Supplies
17,000
Inflation
17,289
Inflation
17,652
Inflation
18,023
Inflation
18,419
83
Small Equipment
19,600
Inflation
19,933
Inflation
20,352
Inflation
20,779
Inflation
21,236
84
Line and System Appurtenances
5,000
Inflation
5,085
Inflation
5,192
Inflation
5,301
Inflators
5,417
85
Computer Equipment /Software
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
86
Books /Subscriptions
400
Inflation
407
Inflation
415
Inflation
424
Inflation
433
87
Professional Dues
580
Inflation
590
Inflation
602
Inflation,
615
Inflation
628
88
Training Expense
2,400
Inflation
2,441
Inflation
2,492
inflation
2,544
Inflation
2,600
89
Capital hnpro%ements
131 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
90
Equipment
I'll 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
91
Vehicle Replacement
131 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
92
Principal - Pick -up Truck Lease
0
F.Iminar
0
Fhnnnate
0
Eln,inatc
0
Eliminate
0
93
Interest - Pick -up Truck Lease
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
94
'I'ota] Operating Expenses
$919,470
$1,000,472
$1,062,066
$1,124,307
$1,193,852
95
Total Wastewater Utility Facility (535)
$1,302,595
$1,395,967
$1,470347
$1,545,804
$1,629,009
Wastewater Utility Operating (535.1)
Personal Services
96
Regular Salaries & Wages
$226,840
Labor
$233,645
Labor
$240,655
Labor
$247,874
Labor
$255,310
97
Overtime Pay
23,060
labor
23,752
labor
24,464
Labor
25,198
Labor
25,954
98
FICA Taxes
19,125
Labor
19,699
Labor
20,290
labor
20,898
labor
21,525
99
Retirement Contributions
57,255
Labor
58,973
Labor
60,742
Labor
62,564
Labor
64,441
100
Health Insurance
62,000
lns- Health
65,100
Ins- Health
68,355
Ins - Health
71,773
Ins- Flealth
75,361
101
Life lnsmance
655
Labor
675
Labor
695
Labor
716
Labor
737
102
Dental /Vision Insurance
2,100
Labor
2,163
Labor
2,228
Labor
2,295
Labor
2,364
103
Accident/Disability Insurance
1,755
labor
1,808
tabor
1,862
Labor
1,918
Labor
1,975
104
Worker Comp. Insurance
3,500
Labor
3,605
Labor
3,713
Labor
3,825
Labor
3,939
105
Unemployment Compensation
0
Labor
0
Labor
0
Labor
0
Labor
0
106
Additional Personnel
0
Input
0
Input
0
Input
0
Input
0
107
Total Personal Services
$396,290
$409,419
$423,003
$437,060
$451,608
Page 3 of3
Table 10
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Cost of Operation and Maintenance (Operation Expenses) - Wastewater System I11
Line
No.
Description
Adjusted
2013
Escalation
Reference
2014
Fiscal Year
Escalation
Reference
Ending September
2015
30,
Escalation
Reference
2016
Escalation
Reference
2017
Operating Expenses
Fund Transfers
108
Engineeting Expense
$0
Inflation
$0
Inflation
$0
Inflation
$0
Inflation
$0
109
Contractual Services
58,240
Inflation
59,230
Inflation
60,474
Inflation
61,744
Inflation
63,102
110
Travel Expense
2,800
Inflation
2,848
Inflation
2,907
Innation
2,968
Inflation
3,034
III
Telephone Expense
24,720
Inflation
25,140
Inflation
25,668
Inflation
26,207
Inflation
26,784
112
Postage and Freight
1,000
Inflation
1,017
Infladon
1,038
Inflation
1,060
Inflation
1,083
113
Electric Expense
70,000
Potccr-W'W
74,942
pnoC NYW
80,240
Poocr -WW
85,929
Potacr -WW
92,039
114
Water Expense
0
Uul W/WW
0
lJtil W/WW
0
Eat W/WW
0
Util W/WW
0
115
Leasing Expense
2,500
Inflation
2,543
Inflation
2,596
Inflation
2,650
Inflation
2,709
116
Auto Liability Insurance
6,410
Inflation
6.519
inflation
6,656
Inflation
6,796
Infladon
6,945
117
Multi -Peril Insurance
36,205
Ins - Propene
37,653
Ins- Propertc
39,159
Ins-Pnoperp
40,726
Ins - Property
42,355
118
Water Sampling
500
Cust- Setccr
517
C- a- Sctccr
537
Cust- Scher
558
Cnst- S,,
580
119
Vehicle Parts and Repair
20,600
Repair
21,424
Repair
22,281
Rcpak
23,172
Rcpak
24,099
120
Emergency Repairs -Uul.
29,000
Repair
30,160
Repair
31,366
Repair
32,621
Repair
33,926
121
Miscellaneous Expense
3,000
Inflation
3,051
Inflation
3,115
Inflation
3,180
Inflation
3,250
122
Office Supplies
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
123
POL Supplies
25,600
Inflation
26,035
Inflation
26,582
Inflation
27,140
Inflation
27,737
124
Uniforms
2,510
Inflation
2,553
Inflation
2,606
nflation
2,661
Inflation
2,720
125
Operating Supplies
45,000
Cost- Setcer
46,557
Cust- S,,
48,359
Cust- Scrccr
50,232
Cust- Setccr
52,231
126
Chemical Expense
1,500
Cust -Saner
1,552
Cuet -Setmr
1,612
Cost- Seiccr
1,674
Cust -Setmr
1,741
127
Electrical Supplies
5,000
Inflation
5,085
Inflation
5,192
Infladon
5,301
Infladon
5,417
128
Water Meters
20,000
Inflation
20,340
Inflation
20,767
Innation
21,203
Inflation
21,670
129
Small Equipment
13,000
Inflation
13,221
Inflation
13,499
Innation
13,782
Inflation
14,085
130
Line and System Appurtenances
12,000
Inflation
12,204
Inflation
12,460
Innation
12,722
Inflation
13,002
131
Computer Equipment 'Software
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
132
Books /Subscriptions and Professional Dues
465
Inflation
473
Infladon
483
Inflation
493
Inflation
504
133
Training Expense
2,900
Inflation
2,949
Inflation
3,011
Inflation
3,074
Inflation
3,142
134
Capital Improvements
131 0
Lhoninalc
0
Eliminate
0
Eliminmc
0
Eliminate
0
135
Equipment
PI 0
Eliminate
0
Eliminate
0
Ehannatc
0
Ehnninar
0
136
Vehicle Replacement
131 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
137
Principal - Pick -up Ti Lick Lease
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
138
Interest - Pick -Lip Truck Lease
0
Inflation
0
Inflation
0
Inflation
0
Innation
0
139
Total Operating Expenses
$382,950
$396,013
$410,610
$425,896
5441155
140 Total R'astewater Utility Operating (535.1)
$779,240
$805,431
$833,613
$862,956
$893,763
Non - Departmental -Fund Transfers
Fund Transfers
141 Transfer fiam 533 to Debt Sel rice
µl
$0 Eliminate
$0
Fliminatc
$0
Eliminate
$0
Eliminate
$0
142 Transfer front 535 to Debt Service
1
0 Eliminate
0
Fliminatc
0
Eliminate
0
Eliminate
0
143 Transfer front 533 to Admin.
141
0 Flimmute
0
Eliminate
0
Eliminate
0
Eliminate
0
144 Transfer front 533.1 to Admin.
141
0 Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
145 Transfer front 535 to Adjoin.
141
0 Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
146 Transfer from 535.1 to Admin.
141
0 Eliminate
0
Eliminate
0
Eliminate
0
Fliminatc
0
147 Transfer front 533 to R &R
141
0 Eliminate
0
Eliminate
0
Eliminmc
0
Eliminate
0
148 Transfer from 535 to R &R
141
0 Eliminate
0
Eli, t,
0
Fliminatc
0
Elinunar
0
149 Interest from Fund 533 and 535
µl
0 Eliminmc
0
Eli mot,
0
Fliminatc
0
Eliminate
0
150 Other Fund Transfers from 535
141
0 Eliminate
0
Elinunatc
0
Eliminate
0
Fliminatc
0
151 'total Non-Dep.-Fund Transfers
$0
50
$0
$0
$0
152 Total Operating and Maintenance Costs
$2,383,650
$2,513,217
$2,625,758
$2,740,804
$1865,600
153 Annuallncrease
5.44%
4.48%
4.38%
4.55%
Footnotes:
[1] Based on information provided by the City's Utilities
and Finance
Departments.
[2] Amount reflects an additional adjustment for: i) contingency
so that the adjusted contingency
amount
is equal to
1.0 %ofbudgeted expenditures;
and it) bad debt, so that the adjuuted bad debt amount
is equal
to 03% of projected rate
revenues.
[3] Equipment expenses and other capital outlay are adjusted
front
projected operating expenses
and reflected
in the
capital impioveutents
program
as applicable.
[4] Othei non- operating expenses and transfers are reflected
in revenue requirements summary,
as applicable.
Page 1 of 5
Table 11
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Proiected Cost of Operation and Maintenance ( Operatine Expenses) - Combined System 111
Projected Fiscal Year Ending
September 30,
Line
Adjusted
Escalation
Escalation
Escalation
Escalation
No.
Description
2013
Reference
2014
Reference
2015
Reference
2016
Reference
2017
Water and Wastewater Administration Fund (531)
Personal Services
1
Regular Salaries & Wages
$292,955
Labor
$301,744
Labor
$310,796
Labor
$320,120
Labor
$329,723
2
Overtime Pay
17,060
Labor
17,572
Labor
18,099
Labor
18,642
Labor
19,201
3
FICA Taxes
23,720
Labor
24,432
labor
25,165
Labor
25,919
Labor
26,697
4
RetirenaentConnibutions
71,030
Labor
73,161
Labor
75,356
Labor
77,616
Labor
79,945
5
Health lnsurance
43,850
Ins-ticaltb
46,043
Ins -Health
48,345
Ins- health
50,762
Ins - Health
53,300
6
Life Insurance
810
Labor
834
Labor
859
Labor
885
Labor
912
7
Dental /Vision Insurance
1,750
Labor
1,803
Labor
1,857
Labor
1,912
Labor
1,970
8
Accident/Disability Insurance
2,280
Labor
2,348
Labor
2,419
Labor
2,491
Labor
2,566
9
Worker Comp. Insurance
3,780
Labor
3,893
Labor
4,010
Labor
4,131
Labor
4,254
10
Additional Personnel
0
tabor
0
Labor
0
Labor
0
Labor
0
11
Total Personal Costs
$457,235
$471,829
$486,905
$502,479
$518,568
Operating Expenses
12
Legal Expense
$10,000
Inflation
$10,170
Inflation
$10384
Inflation
$10,602
Inflation
$10,835
13
Professional Sew ices/Other
89,000
Inflation
90,513
Inflation
92,414
Inflation
94,354
Inflation
96,430
14
Contractual Services
3,580
Inflation
3,641
Inflation
3,717
Inflation
3,795
Inflation
3,879
15
Travel Expense
440
Inflation
447
Inflation
457
Inflation
466
Inflation
477
16
POWR Program
35,500
Inflation
36,104
Inflation
36,862
Inflation
37,636
Inflation
38,464
17
Telephone Expense
10,340
Inflation
10,516
Inflation
10,737
Inflaton
10,962
Inflation
11,203
18
Postage and Freight
4,100
Inflation
4,170
Inflation
4,257
Inflation
4,347
Inflation
4,442
19
Electric Expense
4,800
Po,rer -Aden
5,040
Po,mr -Adnn
5,292
Pooer -Aden
5,557
Pri-r -Ada,
5,834
20
Water Expense
1,200
Otil WAVW
1,200
Unl W/WW
1,200
Util W/WW
1,200
Unl w/Ww
1,200
21
Leasing Expense
2,600
Repair
2,704
Repair
2,812
Repair
2,925
Repair
3,042
22
Auto Liability Insurance
225
Repair
234
Repair
243
Repair
253
Repair
263
23
Multi -Petit Insurance
5,830
Ins - Property
6,063
hns- Properh
6,306
Ins - Property
6,558
hns- Property
6,820
24
Building Maintenance
500
Inflation
509
Inflation
519
Inflation
530
Inflation
542
25
Vehicle Parts and Repairs
825
Repair
858
Repair
892
Repair
928
Repair
965
26
Equip. Maintenance and Contracts
3,680
Inflation
3,743
Inflation
3,821
Inflation
3,901
Inflation
3,987
27
Emergency Repairs
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
28
Miscellaneous Expense
1,000
Inflation
1,017
Inflation
1,038
Inflation
1,060
Inflation
1,083
29
Bad Debt Write Offs 121
21,260
Input 121
22,994
input 121
24,353
Input 121
25,647
Input 121
27,066
30
Office Supplies
2,000
Inflation
2,034
Inflation
2,077
Inflation
2,120
Inflation
2,167
31
POL Supplies
5,350
Inflation
5,441
Inflation
5,555
Inflation
5,672
Inflation
5,797
32
Uniforms
1,540
Inflation
1,566
Inflation
1,599
Inflation
1,633
I.Noun
1,669
33
Operating Supplies & Electrical Supplies
6,000
Inflation
6,102
Inflation
6,230
Inflation
6,361
Inflation
6,501
34
Etnployce Gift Certificates
1,700
Inflation
1,729
Inflation
1,765
Inflation
1,802
Inflation
1,842
35
Emergency Management
3,000
Inflation
3,051
Inflation
3,115
Inflation
3,180
Inflation
3,250
36
Sinall Equipment
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
37
Computer Equipment /Software
5,300
Inflation
5,390
Inflation
5,503
Inflation
5,619
Inflation
5,742
38
Books /Subscriptions
1,750
Inflation
1,780
lunation
1,817
Inflation
1,855
Inflation
1,896
39
Professional Dues
850
Inflation
864
Inflation
883
Inflation
901
Inflation
921
40
Training Expense
2,600
Inflation
2,644
Inflation
2,700
Inflation
2,756
Inflation
2,817
41
Reserve for Contingency 121
50,088
Input 121
52,197
Input 121
54,192
Input 121
56,203
Input 121
58,349
42
Capital Improvements 131
0
Eliminate
0
F.lin,inate
0
Eliminate
0
Eliminate
0
43
Capital - Comp. Equip. /Software
0
Fha mate
0
Eliminate
0
Eliminate
0
F.liminate
0
44
Principal - SUV Lease
0
Ehmh,it,
0
Hainaut,
0
Eliminate
0
El t,
0
45
Interest - SUV Lease
0
Eliminatr
0
Ehminatc
0
Eln raw
0
Ehminate
0
46
Total Operating Services
$275,058
$n
$282,720
$290,740
$298,825
$307,485
xo
47
Total Water and Wastewater Admin. (Fund 531)
$732,293
$754,549
$777,645
$801,304
$826,053
Water Utilities Facilities (533)
Personal Services
48
Regular Salaries & Wages
$180,840
Labor
$186,265
Labor
$191,853
Labor
$197,609
Labor
$203,537
49
Overtime Pay
11,740
labor
12,092
Labor
12,455
Labor
12,829
Labor
13,213
50
FICA Taxes
14,735
Labor
15,177
labor
15,632
Labor
16,101
Labor
16,584
51
Retirement Contributions
44,125
Labor
45,449
Labor
46,812
labor
48,217
Labor
49,663
52
Health Insurance
20,950
Ins -Hcahh
21,998
Ins -Health
23,097
Ins- licalth
24,252
Ins- Hoalth
25,465
53
Life Insurance
565
Labor
582
Labor
599
Labor
617
Labor
636
54
Deutal!Visionbasurance
1,050
Labor
1,082
Labor
1,114
Labor
1,147
Labor
1,182
55
Accident /Disability Insurance
1,380
tabor
1,421
Labor
1,464
Labor
1,508
Labor
1,553
56
Worker Comp. Insurance
4,070
Labor
4,192
Labor
4,318
labor
4,447
labor,
4,581
57
Unemployment Compensation
0
Labor
0
tabor
0
Labor
0
Labor
0
58
Additional Personnel
0
Input
0
Input
0
Input
0
Input
0
59
Total Personal Costs
$279,455
$288,258
$297345
$306,728
$316,415
Page 2 of 5
Table 11
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Cost of Operation and Maintenance (Operating Expenses) - Combined System I11
Operating Expenses
Projected Fiscal Year Ending
September 30,
Line
Adjusted
Escalation
$33,480
Escalation
$34,049
Escalation
$34,764
Escalation
$35,494
No.
Description
2013
Reference
2014
Reference
2015
Reference
2016
Reference
2017
Inflation
Operating Expenses
111
Telephone Expense
6,060
Inflation
6,163
Inflation
6,292
Inflation
6,425
60
ProfessionalSenices/Other
$0
Inflation
$0
Inflation
$0
Inflation
$0
Inflation
$0
61
Accounting and Auditing
6,750
Inflation
6,865
Inflation
7,009
Inflation
7,156
Inflation
7,314
62
Contractual Services
26,120
Inflation
26,564
Inflation
27,122
Inflation
27,691
Inflation
28,301
63
Travel Expense
2,250
Inflation
2,288
Inflation
2,336
Inflation
2,385
Inflation
2,438
64
Telephone Expense
8,550
Inflation
8,695
Inflation
8,878
Inflation
9,064
Inflation
9,264
65
Postage and Freight
400
Inflation
407
Inflation
415
Inflation
424
Inflation
433
66
Electric Expense
250,000
Ponce, -AV
267,025
Porer -W
285,022
Ponce, -W
299,872
Ponce, -W
315,585
67
Leasing Expense
600
Repair
624
Repair
649
Repair
675
Repair
702
68
Auto Liabilitylnswance
1,065
Repair
1,108
Repair
1,152
Repair
1,198
Repair
1,246
69
Multi - Peril lnsurance
21,080
Ins- Propert}
21,923
Ins- Propertc
22,800
Ins- Properh
23,712
Ins- Prepm,
24,661
70
Water Sampling
15,660
Cust -Water
16,193
Cost -Water
16,807
Cost -Wamr
17,446
('ust -Water
18,127
71
Building Maintenance
28,700
Inflation
29,188
Inflation
29,801
Inflation
30,427
Inflation
31,096
72
Vehicle Parts and Repair
4,945
Repair
5,143
Repair
5,349
Repair
5,562
Repair
5,785
73
Equipment Maintenance Contracts
0
Repair
0
Repair
0
Repair
0
Repair
0
74
Emergency Repairs -Ulil.
22,500
Repair
23,400
Repair
24,336
Repair
25,309
Repair
26,322
75
Miscellaneous Expense
3,825
Inflation
3,890
Inflation
3,972
Inflation
4,055
Inflation
4,144
76
Office Supplies
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
77
POL Supplies
11,750
Inflation
11,950
Inflation
12,201
Inflation
12,457
Inflation
12,731
78
Uniforms
1,290
Inflation
1,312
Inflation
1,339
Inflation
1,368
Inflation
1,398
79
Operating Supplies
31,000
Cust -Water
32,055
Cust-Watcr
33,271
('ustAVntnr
34,535
Cust -water
35,884
80
Chemical Expense
86,600
Rist -Water
89,546
Cust -Water
92,944
Rest -Water
96,476
Cost -Water
100,244
81
Electrical Supplies & Copying Expense
14,200
InFl ❑non
14,441
Inflation
14,745
Inflation
15,054
Inflation
15,386
82
Water Meters
1 0
Eliminate
0
Eliminmc
0
Eliminate
0
Eliminate
0
83
Small Equipment
21,000
Inflation
21,357
Inflation
21,805
Inflation
22,263
Inflation
22,753
84
Line and System Appurtenances
24,500
Inflation
24,917
Inflation
25,440
Inflation
25,974
Inflation
26,545
85
Computer Equipment /Software
3,000
Inflation
3,051
Inflation
3,115
Inflation
3,180
Inflation
3,250
86
Books /Subscriptions
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
87
Professional Dues
400
Innation
407
Inflation
415
Inflation
424
Inflation
433
88
Training Expense
3,200
Inflation
3,254
Inflation
3,323
Inflation
3,393
Inflation
3,467
89
Interest Expense
3,000
Inflation
3,051
Inflaion
3,115
Inflation
3,180
Inflation
3,250
90
Capital Improvements
131 0
Eliminate
0
Eliminate
0
Elimhnatc
0
Flnninatc
0
91
Fquipment
131 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
92
Vehicle Replacement
0
Eliminate
0
Eli ate
0
Eliminate
0
Ella innate
0
93
Principal - Pick -up Truck Lease
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
94
Interest - Pick -up Truck Lease
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
95
Total Operating Senices
5592,385
$618,653
$647,362
$673,283
MM59
96
Total Water Utilities Facilities (533)
$871,840
$906,911
$944,707
$980,010
$1,017,174
Water Utility Operating (533.1)
Personal Costs
97
Regular Salaries & Wages
$542,785
tabor
$559,069
Labor
$575,841
Labor
$593,116
Labor
$610,909
98
Overtime Pay
36,350
Labor
37,441
Labor
38,564
Labor
39,721
Labor
40,912
99
FICA Taxes
44,310
Labor
45,639
labor
47,008
Labor
48,419
Labor
49,871
100
Retirement Contributions
132,685
Labe,
136,666
Labor
140,766
Labor
144,988
Labor
149,338
101
Health Insurance
91,350
Ens - hearth
95,918
Ins- Ikalth
100,713
Ins-Heatth
105,749
Ins+lealth
111,036
102
Life Insurance
1,590
Labor
1,638
Labor
1,687
Labor
1,737
Labor
1,790
103
Dental /Vision Insurance
5,250
lobo,
5,408
Labor
5,570
Labor
5,737
Labor
5,909
104
Accident Disability Insurance
4,205
Labor
4,331
Labor
4,461
Labor
4,595
Labor
4,733
105
Worker Comp. Insurance
11,065
Labor
11,397
Labor
11,739
Labor
12,091
labor
12,454
106
Unemployment Compensation
2,500
labor
2,575
Labor
2,652
Labor
2,732
Labor
2,814
107
Additional Personnel
0
Input
0
Input
0
Input
0
Input
0
108
Total Personal Costs
$871090
$900,080
$929,000
$958,885
$989,766
Operating Expenses
109
ContractualSercices
$33,480
Inflation
$34,049
Inflation
$34,764
inflation
$35,494
Inflation
$36,275
110
Travel Expense
4,500
Inflation
4,577
Inflation
L673
Inflation
4,771
Inflation
4,876
111
Telephone Expense
6,060
Inflation
6,163
Inflation
6,292
Inflation
6,425
Inflation
6,566
112
Postage and Freight
1,000
Inflation
1,017
Inflation
1,038
Inflation
1,060
Inflation
1,083
113
Leasing Expense
2,500
inflation
2,543
Irma join
2,596
Inflation
2,650
Inflation
2,709
114
Auto Liability Insurance
3,340
Inflation
3,397
Inflation
3,468
Inflation
3,541
Inflation
3,619
115
Multi-Peril Insurance
35,840
Ins- Pr.1 -t,
37,274
Ins- Propertc
38,765
Ins - Property
40,315
Ins- P,opem
41,928
116
Water Sampling
2,000
Cult -Water
2,068
Cost -water
2,147
Rest -water
2,228
Cnst -Water
2,315
117
Vehicle Parts and Repair
16,200
Rcpnir
16,848
Repair
17,522
Repair
18,223
Repair
18,952
118
Equipment Maintenance Contracts
0
Repair
0
Rcpnir
0
Repair
0
Repair
0
119
Emergency Repairs -Util.
22,227
Repair
23,116
Repair
24,041
Repair
25,002
Repair
26,002
120
Miscellaneous Expenses
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
121
POL Supplies
46,700
Inflation
47,494
Inflation
48,491
Inflation
49,510
Inflation
50,599
122
Uniforms
6,625
Inflation
6,738
Inflation
6,879
Inflation
7,024
Inflation
7,178
123
Operating Supplies
90,000
(uso-wamr
93,062
CtistrWater
96,593
Cust-Water
100,263
Coso-Warr
104,179
124
Electrical Supplies
250
Inflation
254
Inflation
260
hnflntion
265
Inflation
271
Page 3 of 5
Table 11
City of Ococe, Florida
2013 Utility Revenue Sufficiency Analysis
Proiected Cost of Operation and Maintenance (Oneratioe Expenses) - Combined Svstem 111
Operating Expenses
Projected Fiscal Year Ending September 30,
Line
Adjusted
Escalation
$0
Escalation
$0
Escalation
$0
Escalation
$0
No.
Description
150
2013
Reference
2014
Reference
2015
Reference
2016
Reference
2017
125
Water Meters
131
220,415
Constant
220,415
Constant
220,415
Constant
220,415
Conntart
220,415
126
Small Equipment & Computer Equipment
2,610
7,200
Inflation
7,322
Inflation
7,476
Inflation
7,633
Inflation
7,801
127
Books /Subscriptions
Inflation
80
Inflation
81
Inflation
83
Inflation
85
Inflation
87
128
Professional Dues
305
460
Inflation
468
Inflation
478
Inflation
488
Inflation
498
129
Training Expense
Pourer -WW
2,000
Inflation
2,034
Inflation
2,077
Inflation
2,120
Inflation
2,167
130
Capital Improvements
131
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
131
Equipment
131
0
Lh mare
0
Eliminate
0
Eliminate
0
Eliminate
0
132
Vehicle Replacement
131
0
Himinatc
0
Eliminate
0
Eliminate
0
Elimmatc
0
133
Principal - Pick -up Truck Lease
Ins -Proem
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
134
Interest - Pick -up Truck Lease
45,893
0
Elimmatc
0
Elminmc
0
Eliminate
0
Eliminate
0
135
Total Operating Services
162
$500,877
2,475
$508,919
2,574
$518,057
2,677
$527,512
2,784
$537,520
136
7btal Water Utilities Facilities (533)
Equipment Maintenance Contracts
$1,372,967
Repair
$1,408,999
Repair
$1,447,058
Repair
$1,486,397
Repair
$1,527,286
164
Wastewater Utility Facility (535)
17,000
Repair
17,680
Repair
18,387
Repair
19,123
Repair
19,888
165
Miscellaneous Expense
Personal Services
Inflanon
0
Inflanon
0
Inflanon
0
Inflation
0
166
Office Supplies & Copying Expense
137
Regular Salaries & Wages
305
$238,670
Labor
$245,830
Labor
$253,205
Labor
$260,801
Labor
$268,625
138
Overtime Pay
Inflation
13,200
Labor
13,596
Labor
14,004
Labor
14,424
Labor
14,857
139
PICA Taxes
2,279
19,270
labor
19,848
Labor
20,444
Labor
21,057
Labor
21,689
140
Retirement Connibutions
Cust -smmr
57,710
Labor
59,441
Labor
61,225
Labor
63,061
Labor
64,953
141
Health Insurance
89,301
43,850
Ins - Health
46,043
bn walth
48,345
Ins -I Lcalth
50,762
Ins - Health
53,300
142
Life Insurance
Inflation
685
Labor
706
Labor
727
Labor
749
Labor
771
143
Dental /Vision Insurance
21,236
1,750
Labor
1,803
Labor
1,857
Labor
1,912
Labor
1,970
144
Accident/Disability Insurance
174
1,910
Labor
1,967
Labor
2,026
Labor
1087
Labor
2,150
145
Worker Comp. Insurance
Books /Subscriptions
3,580
Labor
3,687
Labor
3,798
Labor
3,912
Labor
4,029
146
Unemployment Compensation
580
2,500
Labor
2,575
Labor
2,652
Labor
1732
Labor
2,814
147
Additional Personnel
Inflation
0
Input
0
Input
0
Input
0
Input
0
148
Total Personal Services
0
$383,125
0
$395,496
0
$408,281
0
$421,497
Equipment
$435,157
Operating Expenses
149
Professional Services /Other
$0
Inflation
$0
Inflation
$0
Inflation
$0
Man-
$0
150
Accounting and Auditing
8,000
hnflntion
8,136
Inflation
8,307
Inflation
8,481
Inflation
8,668
151
Contractual Services
175,770
Inflation
178,758
Inflation
182,512
Intlanoo
186,345
Inflation
190,444
152
Travel Expense
2,610
Inflanon
2,654
Inflation
2,710
Inflation
2,767
Inflation
2,828
153
Telephone Expense
8,000
Inflation
8,136
Inflation
8,307
Inflation
8,481
Inflation
8,668
154
Postage and Freight
300
Inflation
305
Inflation
312
Inflation
318
Inflation
325
155
Electric Expense
300,000
Poncrr -WW
321,180
Pourer -WW
343,887
Ponccr -WW
368,269
Povccr-WW
394,453
156
Water Expense (Reclaimed Purchases)
150,980
Purch WC
198,871
Purch R/c
223,710
Purch WC
247,065
Purch R/C
274,983
157
Leasing Expense
500
Inflation
509
Inflation
519
Inflation
530
Inflanon
542
158
Auto Liability Insurance
140
Inflation
142
Inflation
145
Inflation
148
Inflation
152
159
Multi -Peril Insurance
20,980
In_s- Property
21,819
Ins- Propony
22,692
Ins- Propcny
23,600
Ins -Proem
24,544
160
Water Sampling
39,540
Cust- Senccr
40,908
Cust -Senmr
42,491
Oust- Scrccr
44,137
Cust- Server
45,893
161
Building Maintenance
2,500
Inflanon
2,543
Inflation
2,596
Inflatlon
2,650
Inflation
2,709
162
Vehicle Pmts and Repair
2,475
Repair
2,574
Repair
2,677
Repair
2,784
Repair
1895
163
Equipment Maintenance Contracts
0
Repair
0
Repair
0
Repair
0
Repair
0
164
Emergency Repairs -Util.
17,000
Repair
17,680
Repair
18,387
Repair
19,123
Repair
19,888
165
Miscellaneous Expense
0
Inflanon
0
Inflanon
0
Inflanon
0
Inflation
0
166
Office Supplies & Copying Expense
300
inflation
305
Inflanon
312
Inflanon
318
Inflation
325
167
POL Supplies
10,200
Inflation
10,373
Inflation
10,591
Inflation
10,814
Inflation
11,052
168
Uniforms
2,195
inflation
2,232
Inflation
2,279
Inflation
2,327
Inflation
2,378
169
Operating Supplies
53,000
cost- serer
54,834
cast- scnccr
56,956
Cust -smmr
59,162
Ctim- Scnner
61,516
170
Chemical Expense
80,000
Cust -Seder
82,768
Cust- Scncer
85,971
cyst- s,.
89,301
Cult -Seater
92,854
171
Electrical Supplies
17,000
Inflation
17,289
Inflation
17,652
Inflation
18,023
Inflation
18,419
172
Small Equipment
19,600
Inflation
19,933
Inflation
20,352
Inflation
20,779
Inflation
21,236
173
line and System Appurtenances
5,000
Inflation
5,085
Inflation
5,192
Inflation
5,301
mflat io.n
5,417
174
Computer Equipment/Software
0
Inflation
0
Inflation
0
Inflation
0
Inflation
0
175
Books /Subscriptions
400
Inflation
407
Inflation
415
Inflation
424
Inflation
433
176
Professional Dues
580
Inflation
590
Inflanon
602
Inflation
615
Inflanon
628
177
Training Expense
2,400
Inflation
2,441
Inflation
2,492
Inflation
2,544
Inflation
2,600
178
Capital Improveirents
131 0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
179
Equipment
131 0
Lin rate
0
ELI» inatc
0
Eliminate
0
eliminate
0
180
Vehicle Replacement
131 0
EII „inntc
0
Eliminate
0
Eliminate
0
Eliminate
0
181
Principal - Pick -up Truck lease
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
182
Interest - Pick -up Truck Lease
0
Elimmatc
0
Elimmatc
0
Eliminate
0
Elimmatc
0
183
Total Operating Expenses
$919,470
$1,000,472
$1,062,066
$1,124,307
$1,193,852
184
Total Wastewater Utility Facility (535)
$1,302,595
$1,395,967
$1,470,347
$1,545,804
$1,629009
Page 4 of 5
Table 11
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Cost of Operation and Maintenance (Operating Fxnenses) -Combined System 111
Projected Fiscal Year Ending
September 30,
Line
Adjusted
Escalation
Escalation
Escalation
Escalation
No.
Description
2013
Reference
2014
Reference
2015
Reference
2016
Reference
2017
Wastewater Utility Operating (535.1)
Personal Services
185
Regular Salaties & Wages
$226,840
labor
$233,645
Labor
$240,655
Labor
$247,874
Labor
$255,310
186
0,ertimePay
23,060
Labor
23,752
Labor
24,464
Labor
25,198
Labor
25,954
187
FICA Taxes
19,125
labor
19,699
Labor
20,290
Labor
20,898
Labor
21,525
188
Retirement Contributions
57,255
Labor
58,973
Labor
60,742
tabor
62,564
Labor
64,441
189
Health Insurance
62,000
Ins - Health
65,100
Ins - Health
68,355
Ins - Health
71,773
Ins - Health
75,361
190
Life Insurance
655
Labor
675
Labor
695
Labor
716
Labor
737
191
Dental /Vision Insurance
2,100
Labor
2,163
labor
2,228
Labor
2,295
Labor
2,364
192
Accident /Disability Insurance
1,755
Labor
1,808
Labor
1,862
Labor
1,918
Labor
1,975
193
Worker Comp.lnsuraice
3,500
Labor
3,605
Labor
3,713
Labor
3,825
Labor
3,939
194
Unemployment Compensation
0
Labor
0
Labor
0
Labor
0
Labor
0
195
Additional Personnel
0
Input
0
Input
0
Input
0
Input
0
196
Total Personal Services
$396,290
$409,419
$423,003
$437,060
$451,608
Operating Expenses
197
Engineering Expense
$0
Inflation
$0
Inflation
$0
Inflation
$0
Inflation
$o
198
Contractual Services
58,240
Inflation
59,230
Inflation
60,474
Inflation
61,744
Inflation
63,102
199
Travel Expense
2,800
Inflation
2,848
Inflation
2,907
unction
2,968
Inflation
3,034
200
Telephone Expense
24,720
Inflation
25,140
Inflation
25,668
inflation
26,207
Inflation
26,784
201
Postage and Freight
1,000
Inflati on
1,017
Inflation
1,038
Inflation
1,060
Inflation
1,083
202
Electric Expense
70,000
Potccr -ww
74,942
P.,.,-WW
80,240
P-r -WW
85,929
Pooer -WW
92,039
203
Water Expense
0
Util W/WW
0
Util W/WW
0
Util W/WW
0
Util W/WW
0
204
Leasing Expense
2,500
Inflation
2,543
Inflation
2,596
Inflation
2,650
inflation
2,709
205
Auto Liability Insurance
6,410
Inflation
6,519
Inflation
6,656
inflation
6,796
inflation
6,945
206
Multi -Peril Insurance
36,205
Ins -Trope c
37,653
Ins- Propert}
39,159
Ins- Propem
40,726
Ins- Propem
42,355
207
Water Sampling
500
CUSt -SC „Cr
517
Cust- S,,
537
Cust -Se r
558
Cust -Sc„er
580
208
Vehicle Puts and Repair
20,600
Repair
21,424
Repair
22,281
Repair
23,172
Repair
24,099
209
Emergency Repairs -Util.
29,000
Repair
30,160
Repair
31,366
Repair
32,621
Repair
33,926
210
Miscellaneous Expense
3,000
Inflation
3,051
lunation
3,115
Inflation
3,180
Inflation
3,250
211
Office Supplies
0
Inflation
0
Inflation
0
Innation
0
Inflation
0
212
POT Supplies
25,600
Inflation
26,035
Inflation
26,582
Inflation
27,140
Inflation
27,737
213
Uniforms
2,510
Inflation
2,553
Inflation
2,606
Inflation
2,661
Inflation
2,720
214
Operating Supplies
45,000
Cust -Seecr
46,557
Cult-Si, r
48,359
Cust -S,, e,
50,232
Cust -S-er
52,231
215
Chemical Expense
1,500
Cust -Sc„cr
1,552
Cust -S-cr
1,612
Cust -S-,
1,674
Cust -Seacr
1,741
216
Electrical Supplies
5,000
Inflation
5,085
Inflation
5,192
Inflation
5,301
Inflation
5,417
217
Water Meters
131
20,000
Inflation
20,340
Inflation
20,767
lunation
21,203
Inflation
21,670
218
Small Equipment
13,000
Inflation
13,221
Inflation
13,499
inflation
13,782
Inflation
14,085
219
Line and System Appurtenances
12,000
Inflation
12,204
inflation
12,460
Inflation
12,722
Inflation
13,002
220
Computer Equipire WSoftware
0
Inflati on
0
Inflation
0
Inflation
0
inflation
0
221
Books /Subscriptions and Professional Dues
465
Inflation
473
Inflation
483
Inflation
493
Inflation
504
222
Training Expense
2,900
Inflation
2,949
Inflation
3,011
Inflation
3,074
Inflation
3,142
223
Capital Improyentents
131
0
Eliminate
0
Elinnnatc
0
Eliminate
0
Eliminate
0
224
Equipment
131
0
Eliminate
0
Eliminate
0
Uimmatc
0
Eliminate
0
225
Vehicle Replacement
131
0
Eliminate
0
Ehminatc
0
Eliminate
0
Elimioam
0
226
Principal - Pick -up Truck Lease
0
Inflation
0
Inflauon
0
Inflation
0
Inflation
0
227
Interest - Pick -up Truck Lease
0
inflation
0
Inflation
0
Inflation
0
Inflation
0
228
Total Operating Expenses
$382,950
$396,013
$410,610
$425,896
$442,155
229
Total Wastewater Utility Operating (535.1)
$779,240
$805,431
$833,613
$862,956
$893,763
Non - Departmental -Fund Transfers
Fund Transfers
230
Transfer from 533 to Debt Service
141
$0
Eliminate
$0
Elinnnatc
$0
Eliminate
$0
Eliminate
SO
231
Transfer front 535 to Debt Service
141
0
Elinnnatc
0
Eliminate
0
Eliminate
0
Elinunote
0
232
Transfer from 533 to Admin.
141
0
Eliminate
0
Elinnnatc
0
Elimmatc
0
Eliminate
0
233
Transfer from 533.1 to Admin.
141
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
234
Transfer from 535 to Admin.
141
0
Elimmatc
0
Eliminate
0
Eliminate
0
Elimmatc
0
235
Transfer from 535.1 to Admin.
141
0
Eliminate
0
Eli inatc
0
Eliminate
0
Elimmam
0
236
Transfer from 533 to R &R
141
0
Eliminate
0
Eliminate
0
Eliminate
0
Eliminate
0
237
Transfer from 535 to R &R
141
0
Eliminotc
0
Eliminate
0
Eliminate
0
Eliminotc
0
238
Interest from Fund 533 and 535
141
0
Eliminate
0
eliminate
0
Elinnnatc
0
Enminatc
0
239
Other Fund Transfers from 535
141
0
Elimmatc
0
Eliminate
0
eliminate
0
Eliminotc
0
240
'Total Non -Dep. -Fund Transfers
$0
$0
$0
$0
$0
241
Total Cost of Operation and Maintenance
$5,058,935
$5,271,857
$5,473,370
$5,676,470
$5,893,285
242
Annual Increase
421%
3.82%
3.71%
3.82%
Page 5 of 5
Table l 1
City of Ococe, Florida
2013 Utility Revenue Sufficiency Analysis
Projected Cost of Operation and Maintenance (Operatine Exoenses) - Combined Sv stem 111
Projected Fiscal Year Ending September 30,
Line Adjusted Escalation Escalation Escalation Escalation
No. Description 2013 Reference 2014 Reference 2015 Reference 2016 Refer 2017
Footnotes:
[1] Based on information provided by the City's Utilities and Finance Departments.
[2] Amount reflects an additional adjustment for: it contingency so that the adjusted contingency amount is equal to 1.0% of budgeted expenditures;
and it) bad debt, so that the adjsuted bad debt amount is equal to 0.3% of projected rate revenues.
[3] Equipment expenses and other capital outlay are adjusted from projected operating expenses and reflected in the capital improvements program
as applicable.
[4] Other non - operating expenses and transfers are reflected in revenue requirements summary, as applicable.
Pagc I of I
Line
No. Description
A.- C 70 % of Utility Counter Operation, 50 % of 7'wo Eneincers
I and Mowing Transfer to Public Waits Department
D. 12% of Fund 401 Revenues (Including Misc. Revenues)
2 Water - Existing and Projected Rate Revenues
3 Sewer - Existing and Projected Rate Rex emle5
4 Interest Earnings
5 Miscellaneous Revenue
6 Total Water and Wastewater Gross Revenue
7 Funding Requirement (12 %ofGross Revenues)
8 12% of Fund 401 Revenues (Including Misc. Revenues)
9 Total PRMG Calculated Transfer
10 Total Estimated Transfer as Budgeted by City
1 I Difference Between PRMG calculated and City's Budgeted
Transfer Allocated to Water and Wastewater Systems
Basis for Allocation (Revenue Escalator)
12
13 Water Allocated Transfer
14 Wastewater Allocated Transfer
Table 12
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Calculation of Administrative Transfer Out
Budgeted Adjusted Fiscal Year Ending; September 30,
2013 Adjustments 2013 2014 2015 2016 2017
$333,483 $0 $333,483 $343,488 $353,792 $364,406 $375,338
$3,804,592
$0
$3,804,592
$3,981,838
$4,165,136
$4,324,245
$4,490,520
3,594,612
0
3,594,612
3,809,590
4,042,395
4,292,132
4,562,832
69,000
0
69,000
61,600
58,300
81,900
76,900
1,576.563
0
1,576,563
1,896,730
2,025,967
2,138,072
2,271,796
$9,044,766
$0
$9,044,766
$9,749,758
$10,291,797
$10,836,349
$11,402,048
1200%
12.00 9 ,0
1200%
12.00%
12.00%
12.00%
12.00%
$1,085,372
$0
$1,085,372
$1,169,971
$1,235,016
$1,300,362
$1,368,246
$1,418,855
$0
$1,418,855
$1,513,459
$1,588,808
$1,664,768
$1,743,584
$1,418,855
$0
$1,418,855
N/A
N/A
N/A
N/A
$0
$0
$0
N/A
N/A
N/A
N/A
Fiscal Year Ending September 30,
Percent
Adjusted
Basis
Allocation
2013
2014
2015
2016
2017
Equal
50.00%
$709,400
$756,700
$794,400
$832,400
$871,800
Equal
50.00%
709,400
756,700
794,400
832.400
871.800
100.00%
$1,418,800
$1,513,400
$1,588,800
$1,664,800
$1,743,600
Page I of I
Table 13
City of Ocoee, Florida
2013 Utility Revenue Sufficiency Analysis
Summary of Renewal and Replacement Fund Transfer
Line
No.
Projected Fiscal Year Ending September 30,
2013 2014 2015 2016 2017
(Estimated)
I Water Total Revenue - Prior Year
2 Wastewater Total Revenue - Prior Year
3 Total Prior Year Gross Revenue
Annual Funding Target (assuming no minimum)
4 Percent Water R &R
5 Percent Wastewater R &R
6 Water Amount
7 Wastewater Amount
8 Actual Deposits on Hand Water R &R Fund- Beginning Fiscal Year
9 Projected Use of Funds Water R &R Fund
10 Renewal and Replacement Funding Requirement
1 1 Total Water R &R Deposit
12 Actual Deposits on }land Wastewater R &R Fund- Beginning Fiscal Year
13 Projected Use of Funds Wastewater R &R Fund
14 Renewal and Replacement Funding Requirement
15 Total Wastewater R &R Deposit
16 Water R &R Fund Year End Balance - ($500,000 Requirement)
17 Wastewater R &R Fund Year End Balance - ($1,000,000 Requirement)
18 Total Year End Water and Wastewater Renewal and Replacement Balance
$4,025,734 $4,201,515 $4,391,621 $4,575,281 $4,750,085
4,470,848 4,843,251 5,358,138 5,716,516 6,086,264
$8,496,582 $9,044,766 $9,749,758 $10,291,797 $10,836,349
7.45% 7.50%
1128% 5.00%
$300,000 $315,114
$549,120 $242,163
$2,217,078 $1,808,078
709,000 654,700
$300,000 $315,114
$300,000 $315,114
$1,402,248 $1,637,568
313,800 421,678
$549,120 $242,163
$549,120 $242,163
$1,808,078 $1,468,492
1,637,568 1,458,053
$3,445,646 $2,926,544
7.50%
5.00%
$329,372
$267,907
$1,468,492
717,496
$329,372
$329,372
$1,458,053
300,941
$267,907
$267,907
$1,080,367
1,425,019
$2,505,386
7.50% 7.50%
5.00% 5.00%
$343,146 $356,256
$285,826 $304,313
$1,080,367 $816,195
607,318 854,334
$343,146 $356,256
$343,146 $356,256
$1,425,019 $1,227,134
483,711 398,742
$285,826 $304,313
$285,826 $304,313
$816,195 $500,000
1,227,134 1,132,705
$2,043,329 $1,632,705
V .
0
'.4
a
��
�n oo �n Nroo
v,
rm�r- roaNOOOO�rn o�no�
^
N
o
O
o
LL N
7 .-- 00
•T
(/1 vJ O �
O
K N
v'�
(n C K
i — G
G v v° o
o c o L Q Q �. r J J LVj e
e :
:'- a
a ' o
o f
f
r`_:'v_
0o ti c
1. O. V 0 0 0 O O. O. 0 0 0 0 0
ti
r O
r
O O O
.W E
E �
�•d W
W 0
0
cr
F
C
O O O 0 0 0 0
00
O 00 O O O V N O C O 0 0 0 0 0 0 0 0
O
O
O O O
O
L
c c o c o 0 0 0 0 0 0 0 0
0
0 0
0
0 0 0
O O
O
P
N
V1
fll
N
Ea9
N
(/i
0 0 0 0 0 0 0 0
O
O O O O O O O O O O O O C O C O O<
O O
O
O O O
.°
w o
o
vl �
r
va
sa
va zs
O
s�
vJ
Q
0 0 0 0 0 0 0 0
O
.............. O O O O
O
O O
O
O O O
L
Q
^O
Elj O
N
O
69 �
r
h
6A
69
6/1 6A
i
m
c
i
R
� C
�L d
_C 'r
^ W �
v
z °
o �
0
N
C
a�
m m
ti OG y Q
F' - 0 00 � •- 000a�000 0000 000 ti �� —
+
G
N
O
i — G
G v v° o
o c o L Q Q �. r J J LVj e
e :
:'- a
a ' o
o f
f
r`_:'v_
0o ti c
'n T '° v 'E '2 '° v � . 'o '2 'E
.W E
E �
�•d W
W 0
0
r O
�1 cj. �l
aro i
F-
iri N
^.4
0 o a o o n
r
O
N
C
C
9 C
e � w
v v
O q�
Q
F °
o
0
N
O r o e 0 0 r
c
O N O O O O O N
cA N N
� O
N N
V3 fn -
r r
N N
O N N
N �
O C O O 0 0 0 0 0 0 0 O
O N N
O O O O
� W W
O j N N
O O O O
O O
c O �
4 N
O O O O
t
Q
'O VOi O O O
O O
N �
'S
ot, y —v
C O O O O O O O
O O O O
EA �
O O O v 0 0 O
O O o � 0 0 O
O O G O 1 'n
0 0 0 0 0 0 0 10
V e Y e 7
3 3 3
r v r x
O � r
� r
N N
69
� O
- C -
FA
N OC N N
� O
O O O IO
O O O O
O O O O
O O O O
O O O I
00.
W
O O O O
(n N3
O O O
O O O
O O O
O ^
Ffl
O
O
O
cG a' cC
!
o-t -a0000 ovl �°r�r000000
00000000v ew�oo�OO �
r O O 1� r O O
--
6'i
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
fA
O e O V 0 0 0 0 O U' r Vr x 0 0 0 0 0 0
4A O O Y^ N pp W pp �
r r N o r r
N
O O O O O O O O O O O O O O O O O O G O O
--
� ti
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
!T
O O O O O O O O O O O O O C O O O O O O O
to
0 o a o o n
c S U_U -- -"E E ❑ � c'c
CJ C_) � . C G G j, c T � v U 0.,L
u
°a n. nvo �U cr✓ c v v
v c -8
n n n E
a °
o `n ^r, n,ul E_U[ =.
v. G
v a
- 0000
w
o
U
'� ti
�•a ,-
o
Y •- .s c a 3 a .a v v , n c E E E F E
c o uC700
.]
w
E E W- W W
E T C D 0. 0 E
'G C7 C7 CJ
E
v E E v F
cc
.1 v v c C C 6. 0. '� 'D v v 'O 'O
c
-
o 0 0�
L y
'E
r
°� v •--
�
c N c
E E E
� _
rY. t� �K• �: �. .- .- �- � L � �
.
c:c
.=. 0.'
-
U0 U 07000 LIJ .z x'SUUUCiGG
c c
2
1 G r C ( G
( G 1 C ( G ( C
W U
v v C C C V F G G G G G
' ` G
. ti c ti ti c ti F
F ti A F R c a A ti c a
a.aaaaaac.aaaiac aaa
�
- • c «.r �x.s
F- �
o E
°
0 3 3 0 0
�°
tt
r G O G 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O
e� �rw�o.-
�n
C
'O C
'L V
R � F
u r/•
o
F � �
0
>• a
M
N
y O M vl
j• N
W I
O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0
O O o O 0 0 0 O C O O O
O OC O H O O O O O
V rV N CO (V � 00 CO CO V
O O O O O O O O O
.0 O C 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0
O� O O
0 0 0 0 0 0 0 vt O O O O O
0 0 0 0 0 0 I. f- V h 0 V' O
0 0 1� O O O o0 M
O 1� a` O O O
O
N F �, N
�� V N- N -- N - N- N --
M Vl N �O 00 W M V f� R •- rl N CI 00 •--� N
vl N C OO 00 00 M v, r i
� M
O _
• h
J
G
O O O O O O O O O O O O C C O
O O O O O O O C O 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
O O
° � o
L N
l �
Q
..........
O O r ^• O O C O N t�
O O
�
, O N
O O O C O 0 0 0 0 0 0 0 0 0 0 0 0 0 ..
pi O O•
O O
O
N
N
N - fV .- .-
t N N � W W t� 7 t� V •-• .-
N
O
m
O O V' O -- 0 0 0 0 0 0 0 0 0 0
-------------- V O C ---
O- O O O O V' O O
O
.O
t7 M 1
r �
Or r
N N
N r.
M
C
'O C
'L V
R � F
u r/•
o
F � �
0
>• a
M
N
y O M vl
j• N
W I
O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0
O O o O 0 0 0 O C O O O
O OC O H O O O O O
V rV N CO (V � 00 CO CO V
n a
� E O
h w U v v
W u
N
t
C O G ` � O• � G, cG � c4 W
U 6 v°
D Q Q Q O Q � �� o F, `o w U V V C7 ¢ 5� u- c v �. u a Q 0 .G .E o .❑ � � � � .F O C U° "' c. � ^
Q Q Q Q v
v ,r r _vUi E G F �' v °' `' `' `' _� �'- 5 �. % a a a a U
U C]
ti •�• •_.- •^• W W W C7KUK U_UU U °0 0 000 u u v Q u, tixt xt=rr. ii =ii � ti w � FUx =iti ern rn ril ri,
,-
E E E E E E . �C'�C7 UC�C70000 Oa355'S 2'2'S 'S
JC o 0 o CC CG CC K •• ` ` •• a C C — u, cq c0 � 0 m t� rn r� m
�, .G .G prn rn v, rn aan a�., •
-
_
5 C G G v G F F y G
aaaaaaaaaaaaaaaa 0.11 ciaaaaa.aa.a������55� 55555i�3���
Y Y 1 Y Y Y Y Y
3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 cn3 6 3 3 3 3 3 5 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
a` ^J a s >> `-.• ` a a = ` � -' 7 7 7 7 v v v v v v v v v v v v v v v v v v v v
In v] N N N V: V V] v1 r/ v] V] V] � � V: U V] V] V1 V) V, V] V, vl vl rn v: W L*-. W 4. W !,-. [,� [+. W C [,. W W W L• [+. (_ W W [+.
G O 1 � O - N M V n lG
O O ... ._. .--. .- .- -
O O O O O O O O O
.0 O C 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0
o 0 0 0 0 0
C O ut O
. 0 0 0 0 0 0 0
ll �
0 0 0 0 0 0 v� ut n o� r
Q
G
O O O O O O O O O O O O C C O
O O O O O O O C O 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
O O
L
'J
Q
O O C C 0 0 0 0 0 0 0 0 0 0 0
O O O C O 0 0 0 0 0 0 0 0 0 0 0 0 0 ..
.........
O O
O -
N - fV .- .-
t N N � W W t� 7 t� V •-• .-
� N
m
c
r
3
n a
� E O
h w U v v
W u
N
t
C O G ` � O• � G, cG � c4 W
U 6 v°
D Q Q Q O Q � �� o F, `o w U V V C7 ¢ 5� u- c v �. u a Q 0 .G .E o .❑ � � � � .F O C U° "' c. � ^
Q Q Q Q v
v ,r r _vUi E G F �' v °' `' `' `' _� �'- 5 �. % a a a a U
U C]
ti •�• •_.- •^• W W W C7KUK U_UU U °0 0 000 u u v Q u, tixt xt=rr. ii =ii � ti w � FUx =iti ern rn ril ri,
,-
E E E E E E . �C'�C7 UC�C70000 Oa355'S 2'2'S 'S
JC o 0 o CC CG CC K •• ` ` •• a C C — u, cq c0 � 0 m t� rn r� m
�, .G .G prn rn v, rn aan a�., •
-
_
5 C G G v G F F y G
aaaaaaaaaaaaaaaa 0.11 ciaaaaa.aa.a������55� 55555i�3���
Y Y 1 Y Y Y Y Y
3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 cn3 6 3 3 3 3 3 5 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
a` ^J a s >> `-.• ` a a = ` � -' 7 7 7 7 v v v v v v v v v v v v v v v v v v v v
In v] N N N V: V V] v1 r/ v] V] V] � � V: U V] V] V1 V) V, V] V, vl vl rn v: W L*-. W 4. W !,-. [,� [+. W C [,. W W W L• [+. (_ W W [+.
G O 1 � O - N M V n lG
O O ... ._. .--. .- .- -
N
0
v
cu
c
Q
� C
�L d
v
r °
a 0 �
c i
U
M
N
1
�O N N N �
O 00
N V3
O O O O O O O O O C O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O
C O C
W � x
CJ N
v O V
r N ^
w
O O O O O O O O O C O O O O O O O C C O 0 0 0 0 0 O C O O O O O O O C O O
O O O O O O
0 0
O V
N
0 0 O O O N N N O O o0 O O O c O 0 0 C 0 0 0 0
0 0 0 0 0 0 0 0 0 0
O W
c"[ac"tcecec"e��c"cz d
O O lo O O O v, O
O vl 0 O 0 O
N
55
t1 CJ N r — --
�• N ^ --� V t1 't t i [ , t1
V C`
N
O
a
V3
= o
1,. N
O O O O O O O O O O O O O O O O O O O O O O O G C
O C O O O O O O O O
O
E
C1 C1
v
^
`o >
o m
a 'a
�' � ��ao
�
O
N
^ ^
0 0 0 0 0 0 0 0 0 0
V
N
65
1
�O N N N �
O 00
N V3
O O O O O O O O O C O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O
C O C
W � x
CJ N
v O V
r N ^
w
O O O O O O O O O C O O O O O O O C C O 0 0 0 0 0 O C O O O O O O O C O O
O O O O O O
0 0
O V
N
m
O
O
O
L7
O O O
O O O ^
vl
ss
0 0 0 0
c.s sv r
N
r 'J
vl
V
C
EaA
69 1
V
N
O
O O O
V7 En
C
O
N
O O O ^
O O O
O O O O
O r N
N
M
O O O O
fh E1, 6A
0 o c
o r
i�
0
N
fR
L L L L v�i v v v L L '= L L L L v L L v L L a v L L
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cctcecrcec�cec [cza�'cezac"ec"ecz��� ���a
c"[ac"tcecec"e��c"cz d
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
O
55
U' 0 C 0 0 0 I v, O
O v ut O V, O vi O O ll
C �
a
j N
Q
C
O O O O O O O O O O O O O O O O O O O O O O O G C
O C O O O O O O O O
O
E
C1 C1
v
^
`o >
a 'a
�' � ��ao
.. —
0 0 0 0 0 0 0 0 0 0 o c c o 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0
7 2 ?
C C
v o o v o 0 0 O
o o h O v, c o
Cl r ^ ^
N —
t I ^ -� V M V 11 11 tq
. C
I
m
O
O
O
L7
O O O
O O O ^
vl
ss
0 0 0 0
c.s sv r
N
r 'J
vl
V
C
EaA
69 1
V
N
O
O O O
V7 En
C
O
N
O O O ^
O O O
O O O O
O r N
N
M
O O O O
fh E1, 6A
0 o c
o r
i�
0
N
fR
L L L L v�i v v v L L '= L L L L v L L v L L a v L L
L L L N L
Cctcecrcec�cec [cza�'cezac"ec"ecz��� ���a
c"[ac"tcecec"e��c"cz d
R
55555555:55 535d55553�555
5533535355 3
55
v
a
T 2 c o 7E
- L7
a �UU a •= -1 '=' ?.
C1 C1
v
^
`o >
a 'a
�' � ��ao
.. —
^ N k F❑❑ U v c4 LO
a
O _ U
7 2 ?
C C
.-
L v
m m
U CL G 0. 4. K CG O O S >• w O�- � ti C O G O O O
O ..- C.J U
C C C
v E G E E E E ❑ ❑ ❑ ❑ ❑ ❑ ❑ - u, cD C'7 U C'7 C'7 U
C7 '- .G Q �' Q !� V: 'a rt
C
Q«
n?
U W af U U U U U
U O �_
" "
V r,
L7 C F ^ C
s � �' � v �' v � 2 � � t G C o a' a K C K K ` •. •: •: `
•. °L' = v = v ^' ui w
E
- CL
u u u F� u L) U o U o U U o 0 0 0 0
o w w 5 3 5 5 5 x z
-
-
o cn E
C
o Ci
v
m a F w `• w, ., r r. m
U
A
1 Z6 1 1 Y 12 Y 1 1 Z" Y l Y Y Y 1 Y
Y Y Y Y Y Y Y j'
.G .1 .Y .1 .1 .1 .L ._L .<
.1
1,
u
v a
`o L o L o L o L o L o `o L o L o L o L o `o
c
0 L o L o L o L o
E
� �
°
—
0 0 0 c c o o o c 0 o c o c o
L+
0 0 0 0 o o
o
K o
F A
F F
n io r 00 o 0 -- 7 v r 00 C` O -- N vl r
N 1 N 1 ^ ^ ^ ^ ^ ^ ^ ^ ^ , V K V C V C n V V n v, vl vl vl ^ ll 11 1
Wi
C
5 0
O
:4
a
C
C
R �
a; c
v
o y
R O O
F F
O U
�• a
0
N
.n r
-It" I 0 0 0 O
1
1. V V O
[- 4` - - N l O t` Q•
C-
- O
�
lC O N
U
JO 00 O C
1^
N N
O
Yi
w N
t`
-• rn
N
O
N
r (b
vi
O �
JO
O
(r
4A
Ni
69
^J
F
C
O O O O N O O O C C O
N
N
1
O W C O O. J o 0 0 0
l� -- •-
O
� O
�
l0 �
L
�
O O rn 0 0 0 0 0 0 0 0
i<i O
N
N O
N
O O O O O O O O O C O O
V. O K
O
O O O
O
O
O
O C O
Eli
O
En
O O O O
!n O O
N
0 0 0 0 0 0 0 0 0 0 0
O O
Ef>
O
O O C O O O O O O O O O
�
O
Vi
O O O
69
C
O O O
O
N N
O O C O
C O
M
N
'J � vl
OC
O O
Q
c
0 0 0 0 0 0 0 0 0 0 0
v,
C
rn
O C 0 0 0 0 0 0 0 0 0 0
v,
O
O O O
v,
O
sn
O O O
En
O
En
O O O O
vl E»
'O
O C C 0 0 0 0 0 0 0 0
VJ O O O
C
O
O O O O O O O O O O O O
En
O
VJ
O C O
fn
O
N
O O O
69
O
ER
O C C O
V, C O
N
O O
O O
CO
'1
c a
rG�KK 0.ry��rtK�a
CKKKKC�0.
E E
E E E
E4 5
F
F_
O
C
O
O
7
k o o h
�
� .� U
F
" Q
W
�. •n c
F
o
d.
t_
�p
ti 0.
W
v w
ti�,?,•c
— m m"
•o �
v
� p
z . a72
cp
Fp
G
F
:e E` v F c a F .
w22 aJ
c�
v
•a
my
wc.-.
,7 ,?.`�
a
� c,��- v « E ❑
F,000
'o
�o
�
' o
..
u F
c c ° ,� � F000
,
rn
F F
_ f
J E'
°'C7 v
° �
o
�
-
^
°
''
N ! J- 1 J N N N 1 I N
�
Vl W
G O
m O . N 'ct v Vr 1�
G�
O N ,^ V' t` O •-.
22
E>o
^ m O
m
a w w
O
- N^
Q
� G
Q {i
v U
m c
a
F � v
o u
M
O
N
Q O O O
N
V
G_
C
W �
v O N
r N �
(L 1
O O O O
d O O
^- O
N 69
O
O O O O
t,A O O
O O
O O
a
Y
O
N
c G
L �
G
c <
F
O O O O
0 0 0 0
ffi O O
O O
O O
^ 1
� Q Q
O O O O JG J O P 1�
O N O C � C O r^ N
on o0 O N N V O 'fi
GO
FA
a C r
69 O 609
Q 0 0 0 0 0 0 0 0 0 Q
N r �
C
69
O O ^
�O O
fl O
00 V' v7
0 0 0 0 0 0 0 0 0 0 O
O O O O
O O O O
vl O O V1
O V'
�A
O 00 0 0 0 0 0 0 0 1
V1 N
N N
r —
O oC O C 0 0 0 0 0 1
V3 O 1�
oC
N
r r m'
r ^
0 0 0 a o 0 0 0 0 0
O O
r J
l
♦. ��� v v v v v L
V L fi � K K K K fi
W
Q
O
O
m
Q
c
sA
0
O
O O 0 0 0 0 0 'O l� 1� J -- J — 0 0 0 0 r^
X 0 0 JO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
N O O O
C V1
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O 0 0 0 0
O O O O O
O rf Q O Q
O O O O O O O O O O C O O O O O C O O O O O O O O O O
O O C O O O O C
O O O O O O O O
C I J1 O v R O V
O O O O O O O O O C O O O C O 0 0 0 0 0 0 0 0 0 0 0 0
69
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O O O O O O O O
Fn
C� C CL CL H CC CC K CG CC CC x ce h m C 0� CC v N CC CG C4 v
� �xcex zCex �xccex Zxx Z zxxx C �Kcecc G
G
O
6
l:l
F p
C 0 C 0 C
0 0 0
F
O
O
O O
O Ll. N
^
S
J
1
O
N
W
Q
� G
Q {i
v U
m c
a
F � v
o u
M
O
N
Q O O O
N
V
G_
C
W �
v O N
r N �
(L 1
O O O O
d O O
^- O
N 69
O
O O O O
t,A O O
O O
O O
a
Y
O
N
c G
L �
G
c <
F
O O O O
0 0 0 0
ffi O O
O O
O O
^ 1
� Q Q
O O O O JG J O P 1�
O N O C � C O r^ N
on o0 O N N V O 'fi
GO
FA
a C r
69 O 609
Q 0 0 0 0 0 0 0 0 0 Q
N r �
C
69
O O ^
�O O
fl O
00 V' v7
0 0 0 0 0 0 0 0 0 0 O
O O O O
O O O O
vl O O V1
O V'
�A
O 00 0 0 0 0 0 0 0 1
V1 N
N N
r —
O oC O C 0 0 0 0 0 1
V3 O 1�
oC
N
r r m'
r ^
0 0 0 a o 0 0 0 0 0
O O
r J
l
♦. ��� v v v v v L
V L fi � K K K K fi
W
Q
O
O
m
Q
c
sA
0
O
O O 0 0 0 0 0 'O l� 1� J -- J — 0 0 0 0 r^
X 0 0 JO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
N O O O
C V1
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O 0 0 0 0
O O O O O
O rf Q O Q
O O O O O O O O O O C O O O O O C O O O O O O O O O O
O O C O O O O C
O O O O O O O O
C I J1 O v R O V
O O O O O O O O O C O O O C O 0 0 0 0 0 0 0 0 0 0 0 0
69
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O O O O O O O O
Fn
C� C CL CL H CC CC K CG CC CC x ce h m C 0� CC v N CC CG C4 v
� �xcex zCex �xccex Zxx Z zxxx C �Kcecc G
N N N N N N N N N N N N N N N N N N N N N N N N N N N
G
O
6
l:l
F
O
O
t�
S
J
a
cu
c
WE
o
n F
o
v
a
�
E
_
v Q V v
E
1E
F J
8
ti O
U
�
CC rn d CC � d P -2
= L Q F F 6. Q ti
K v N
� in ° E
F v y .'a
._ v v �
cv •—. — '.� .� fl v =ik '� 'O ,k ik �t m � � — F 'O
...
y
—
� 0 . '
n 3 n
E
E
d
a. d V 6.
0. i
j F� z 'O � .. - v
^ R
^ N N N N N N Q Q .^ '/1 '/1 '/1 � •--• •-• N N N N Q Q Q Q vl
0.
� •]
Y
Y p O� �' � U
�• � O
C
" C
O O O O O G O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ti� ti F M F F ti K m ti ff m F F W F F � F F F`-.. F
O
—�^.
t�C �tl Y
in in in v: v: �n in rig in rn v`� v� in rn in v in in rn rn in
O o
N N N N N N N N N N N N N N N N N N N N N N N N N N N
N
O
r
a
d
o v
F �
c u
.7
M
O
N
U� 000� c�nor�MO 0000crno � ��000r� r�o � ooxx000� �no�0000moavo
F-
v �
4. N
h V, v— <, vi vl hen
N
VO
N
O O O O O O O O O O O O O O O O C O O C O O O O O O O O O O O O O O O O O O O O O O O O O O O O O C O
h
O ^
N
O O O G� C O O O O O O O O O O O O O O O O O O O O O O O O O O C O O C O O O O O O O O o0 0o O� K O
rn l� t` r, O H O rn O K h ut h n rJ r!
0 O O O O O O O C O O O O O ...........
0 0 0 0 O O O O O O O O O C O O O C O O O C O 0 0
_ O
Q
O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O C O 0 0 0 0 0 0
G
J✓
C
0 0 0 0 0 0 0 C O O O O O O C O C O O O O O O O O O O O O O O O O O O O O O O O O C O O 0 0 0 0 0 0 0
O V V � V
0] N
CC ce y ce CK H K K �'
x v vicex v �cece v� >ce ce �wC4Cr w vice cece �ce rYce �CC ace r vice C r
� 3 3 Cr 3 3 3 N
C KKK K a
v
d
a aEi E 0. R v v v a v
6 6 N d p „ d d^
>, > ^
I � G nl N C L ; 3 -."
� G�.i .�V:� �'�
s .L' r j L .L � .=. C Q F O L � L � ._ F Q -- = ^ —• O � L R ��„ � F �.-- O ! .L' � .0 •- � �.
Q Q Q �_ � Q v � � Q � � � O .-1 Q � � K Q � A-' 0.' 0.' Q � � ce CL L✓ CL � 4 K Ce Q C Q f K Ce '� FO ce CC 0.' K v K LY Q
ii. 7
E c u c c E EE E E E c E c= E w
--
^
G C C C G G C ^ C C C ^^ C C^ C C C C C C C C C C r ^ r G r C r " r F ( C r C r ^ r = r C C r ^ C C C F C
O O O O O O O O G O O O O O O O G O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
�: 4= �= CC4.CCC�: Cam. '«.CCCCCCu.CCCwCCCCu_� Cc =.CC.0 �= C�= .CCCu.0 U:. W C
ry J 'S V' r C o—
O
�.4
a
R
C
Q
v �
o
R Q �
o i
V
M
O
N
F V r V
[i. N
r ^ r
r c
N�
1 1 N
N
69
0 0 0 0 0 0 0 0 0 0 0
N N
O r'1
N
0 0 0 0 0 0 0 0 0 0 0
O 1�
� O —
0 0 0 0 0 0 0 0 0 0 0
� O
N
Q
0 0 0 0 0 0 0 0 0 0 0
C
L
Q
UJ ^O
Oa
v v: In v �ci�rir�li v�v:
ccnn� ac.� v v
V1 v1 O O v, vt L vi �n v, v,
E E E E kl E E
2
v l v vvvvvv'n ..i �n o
0 0 0 0 0 0 0 0 0 0 0
a a a a a a a a a a a -
0
F
00 C P C Q. C P V1 U C P O
a z N N N 1 ! N N N 1 N 1
N0000�ooco ccoo ao o��nw000 coo�oaa�0000- c�nvrry
h 1
O O
O��
N m ^ N r
J J � O —
O� O O O OV O O O O O O O O O C O O O C C O O O V O O C O 0 0 0 0 0 0 0 0 0 0
r
N C�
X 0 0 0 O O O O O O O O C O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O v� fl O O N V1 N N
O O N fJ ^ ^
^ N —
. ............ O O ......
O O O G O O O O O O p O C 0 0 0 0 0
y K aJ CC CC 0C N y KC� cC N CG K v v, U H h N 0G C� K CC C nC 0C H ti v, v K h CC v v CC
N[ K CC CC K K > CC ce
- - - - - - - - :n 1i vJ N J
OO
a a
O f S i
O � O
F �
S] P
c^� w
0 0' o o G 0. 0 R C Y• >. _o O� !`-.. ti G� O F N Y ~O `0 7 �= ? G �? �.
g, "
TT�� a$ oU cow
c c
'� Oc v aci fc � E ° E E � a c � H C7 ° ° � � '^� v ✓ `o c o o ° ° v � ti '� 5_ b [- 5_ W
ll70.''CL1 R70a C7 VC7 C7 V V C7 C7 U^. u-c -- ^. .0 -. - r.^
Z Z Z Z 2 S 2 Z S 2 2 S 2 S 2 S Z 0 0 0 O O O O O O O O O O O O O O D U U U U
N
U
^
0.
Q �
9
d v
a °
° � v
F
o v
M
O
N
-
[ U r
O
w N
.-
N
N
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O O 0 0 0 0 0 0 O O O
O -
N ^
........... O O O O O O C O O O O O O C O O C O 0 0 0 .........
0 0 0 0 0 0 0 0 0 0 0 0 0
¢
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
F
.j
J,
� N
m
c'� w w w w w x x x x x r1 ` ` w w w w w w w w w w x w w
„In ace ��K �K�cti 3 3 5 x " aK� �act v u
v, v, v, v, v,rn��v,ri,rnJ:J,ri rnrnnv�J,v ��rn�rnci,J; J�v;J,J:vly v, v;ri�v Nv �rnrnri,v�v,v:v:rnv
C
O
F
F
F_
c °
o U
r
C �
� G
_^ E
c.E c a
a
.. n a
w0 axr.Ki+ �n.0 E n,E v v FaE
.E .E .^
:7 :.:t v o. E E E E E E€ F T
- w w r.
w <°.'. N w w w W
° v
[- m[- naaaaa Ez = r a`a`n`G`u. JQQ¢¢y ¢¢ o v v www w> wwww > > EL
E E E =_� �aawwwwwmww�55� �'a
u F C C C C C G i O O C C G G F C
E E k '" 'c '" '" '" '" i_ ^ ;-' ^°�-' ='- = c Q. a F� U U U "b "i .2 .2 .2 .° .° .2 .° . °_ . .° .° . .°^ .°^ .°_ .o
N N N 6 F F F F F F F F F F I E r
;CVU UC]UUU aU Uir� r in�vl in v, in r`n rn in in ins
E EE E E EE E E E E E E v
L 0 0 0 0
U U U U U U U U U U U U U U U U U U U U
G OI O — N ^ V �/, �O C O .-. N t1 V � JO � W � O .--. ^ V v lD O� O — N ^ V JO I� CT � — N t1 V v, � 1� � P O .-• 1
.-� z V V V 7 V V V V V 'C < r , r� c , <'1 r . r't r , < , r , �O V' \° � � VJ JO � � U' r [� r t` [� r t` t` t` r <'t r � r , < . r , r , < . r , M w C• Q\ C O�
N
O
.4
a
C
C
R >,
� C
^mow
v vv
o v
o i
M
O
N
v N cr r� O �O O V' 1 0 Ci c � c 1 � 0 0 0 0
O r —� r O �� v� — �O V� r� � v, N �O N C O -� � O N � O O O O i r O v, [� O O v,
H ^O
4. N
r o o o a N r o 0 0 0 o 0 0 0 0 o N o o o 0 0 0 0 0 0 0 0 o O c o 0 0 0 0 0 0 0 0 0 0 0
o= o --
o —
N
� N O
o N
N
0 0 0 0 0 0 0 0 0 0 0 o v o 0 o c o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o c o c o 0 0 0 0 0 0 0 0 0 0 o c o
ENO
—
0
N
O O O O C O O C O O O O O O O O O O O O C O O O O O O O ..... O O .... c c c 0 .... c c c 0
O O O O O
O
N
O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O C O 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O N 0 0 0 0 h i n 0 vt i
N N v 00 C vl v, — N C1
O O O O C O O O O
............ O O O O O O G O O O O O O O O O O O C O 0 0 0 .......
G
L
7
O O O O O O O O O O O C O C O O O O O O O O O O O O O O O O O O O
............ c c c 0 o c
O t`1 O O O
CO r
v � aaa a v. v. a .tea Loa "mod h vaaa Ha a �a
a v v v v a v a v a ce a v a Z v v a a c
> > u
�v a rc[a a aK a c r Cr > r c�a rYC 'C rau a c"c a - - �� a u au cc 0. 0. a �
J, J: J, J J, ��n A J J, v, A��� ✓,v,v,�v,J,v,J,v,J,�^J„n'.�v,
`o
a
G 0.
r � J
U > c
O O p O ^
a mn, h o a, ca7 ac4
°-
n
..
UUU o ... ° ` - 4 0.`v , °
_� o v,oNOO¢¢ o �a o i F .. .. � � . � �Uri"i❑ ti c
0 r _ _ _ ti A tiC� °
E E U o Y = o° Y Y o f E E v,
K _ u v c, c W o �.�.�.�_ ? uF c=a °aC.- i000C]a000U 'a0.
0�❑ N 1 1
5 v > �> c 0.
W F- o �, G� �TTT�� o o `o `o cLl�❑❑❑(�C]❑�C]❑❑ NCK,i;
0 0 0 o 0 0 0
.= ti '.J . «. . .= '� '.-
E :G .� .� .G .0 .� .� m ti F F tic ^.. 'D 'C 'J 'J 'O L 'D 'O 72 72 v w v
O F G n ti 0 . a u 4 c F t F ` Y Y. % Y% X% Y. %% Y. y.
�>-, o v a- ❑ v�F = �� Cam �a cn inw w`in v, in T, =T x.2000000000000 V UUU
g u n u u. �, :� G G G G G G . h .. h
E E E E E E ti F - F ti m °.' F m F m F
0.a �Kn'xJ 54 r E'4u c`4 Eh t, 6b t7L t4 c
F
W 0 �L �9 ^ 9 �U c �i, .q 64
tirna a - ��aKrL 0. nd0.nn0.GG GnGGGGGaGnann
u
G o, c n` a`. — " " c c 2 c _ �. u, ❑ ° E E E E _ E
0. 0. 0. y .--7 V, V u .^r. = ��
u ,
wcn cu „ �,_ c u nv u u u °J '� o o cUpj O KK,0. tL �,L✓a CL
❑ ❑ a r, 0 0 0 � � `^ .. H '� c. a` Ci U U .. OG -� a 'c � � F _ __ _._
in in in L U U U ° "° a v •. a o 0 0 0 4 0
a a cG tG a s c c
x m m x m cn a` v v v v v v v
.Z .5
5 5 5 5 5 5 5 5 5 5 5 5_ 5 5 5 5 5 5 5 5 5
w
0
C
Q
9 C
W O
0
U 1�.
M
N
-
- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r
0 0 0 0 0 0
I L I
O
F
W N
0 0 0 0 0 0 0 0 0 0 0 o c o 0 0 0 0 0 0 0 0 o r
0
0
N
o °—
N
F O O O O O O O O O O O O O O O O O O O O C O O N
N
U O
N 1^
Ffl
W
O O O O O O O O O O O O O O O O O O O C O 0 0 O
C
r
V
O 00
N N
...........
0 0 0 0 0 0 0 0 0 0 0 0 O
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 h
, 0 0 0 0 0 0 0 h b
O N
N �
Q
O O O O O O O O O O O O O O O O C O 0 0 0 0 0 O
C (n
L
Q
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o c o 0 0 0 0 0 0
0 0 0 0 0 0 0 h vt v) rn Jp
� N N
m �
�� rn fn fn r •n en a in H v H y H H H v v v v v fn vi
C
C C
1] U U F
a - a
n c v
- o o c � v F F� � o o c o•.oc > .� Q
� 'n v' — u, cri c°'n o 0 0 o a ' � u v' u � v v L>• � `.
� �UUUU _ � vm. -ice r[Oin c
W L�. W VJ 0. 0. 0 , O O O O O .� �w �• O O O�� r
c o 0 oUUUU V]in in in mm v �• � � �"�'"� .�.�
L—..
ri 000Uw`w `w uwoQct aa`�.. 4. c
a
^4 c g c E g !1 g w C4 CU W Ca E, UI a
n o.a n. o.aa caaccaano -.a a. a.c as
F O
sa sq o
O
O
o r
r N
0 0 o r
Fn vj o
c` r
o r
^ N
69 V?
O O O ^ O
N .o
v
N
O O O O
Q` N
•— N
O O O
V1 H9 C N
O O
N -
O --
R �O
N �
N N
O O O O
G O
r N
7
O_
V Y
c• c
cn rs
O O O O N
V
O .D
69
x a
� !r
� c W
N t
c W
0. Q
c F
E c
A F F U
ti r
y O
-o
N 4. N
0.
L O
F
N
T
c
n
9 C
O
� � v
L �
� O �
0
0
N
`c
L
Q
m
ui
5 u
� 7
C O
c 7
N N 00 a
sv
^ v o 0
69 iD �
O tri O C N
0
^ N o r o c
1
O O vi f�
O N O co O
C O
0 0 0 0 0 0 0 0 0 0 0 0 o
� rn
O 00 O O O O �n 0 0 0 0 0
O N O O
sn
�333�3�3�3
l� O CC O C
69
�D V
r N oo C
N r o^ o 0 0 0 0 0 0 0 0
N l° K 00
l� C
w
r�
0 000000000Co
n o r o o c
V N �
J
6A
O O O O J O O O O O O O
O C
r` o
N
v
N 'J
C`
FT
0 0 0 0 0 0 0 0 0 0 0 0 O
O �
r ^ 0 0
rs
W N iD V ^ N C O �n O O o0 O O
u' C �• t� r V v O
%s
rn
o vS ci c' r t`
0 0 0 0 0 0 0 0 0 0 0 0 0
r i ni -• v
O oo O O O N O O v� O O oo O O
O O O O O N O O O C O O O
EF r o
oa
N
0o h
O oo O C
n —
ss
-o
`o
G
O
n .o K <t K W � �
— [i 'o' v a d L L
c . ri o v v v C7 .° •°
P .E
U
:'- v ' v [i• I J - k �� p
W
te
U v o o°
c
>
- a' o o° rn Q Q
c
-s U n o o 25 rig Q Q
rivi
U
O
�O off.-. JO.
2 c °o
_
�U^ — O.mmm
a, N F � NO.pmmm
C7 0 ��
,
o Nr
w
K K
c
0 0
t tz a O
• 335UUa.0a'QQ
-
c4 r2
o
,%Kr2
o
U�cG
S�UUaO -r�r<C
F
a JO [� C O ^ N < ^. � n
oa
�D
� � ° O — N 'I r �O [�
C
O N � �O [� C O ^ N M
0
c
•1 p
Page I oft
Ocoee
11.00.
Figure I
City of Ocoee, Florida
Water and Wastewater System Financial Model
2013 Utility Revenue Sufficiency Analysis
Performance Metrics & Dashboards
r" ibit,
L AINAP 4 �
Year F�jd,,i, Sept,-L- 30
Fiscal Y'."
2 i ' ,c21
l
Pr,�P R Adj.,t, .0 2016 2017
S.Mide.— j
Utility System R, 2013 21� 14
Reflects Application of Pw, 1'—,,i 1r— Adjustments
C—ol Y ... 1.,&, Adj-trae.r (0,tol-) 3,00% 3,00% 3 3 00-N,
Water System Surplus (Deficien,0 3" S14 i"
Water System 0.00% A W% 0 0096 0,00% 0,00%
rIT.ti,e Month o Ine... 0& 0" Oct. 0"'. Ot.
Wastewater S),stem Su (Deficiency) 0, 16,:42
Wast—'t—S,,st— - Existing 00% 000% 0 WA OSV. 000%
Ety. Month of Increase Oct. 0't. 0o 01t
Combined System Surplus (Defi6eaey) (535M,291) 5433363 S'74.5, 563 Sal 1
. ... .. . .. .................. - ---------
Com bined System Revenue Requirements
.......................
40.0%.
....... ..... ....... ......
Net Revenue Margin
$14,000,000
35.0
$12,000.000
$10,000.000 . .............
30.0%
$9,000.000
25.0%
20.0
$6,000,000
S4,000,000
10.0%
5.0%.
0.0° /.
$2.000,000
SO
2013 2014 2015 2016 2017
2013 2014 2015 2016 2017
=T. — --
C jtal dW F., P— — to P. Ford TS., to R&R Fund
Debt Se rvice Total Opmtig Expenses Tool Reven at Proposed Ram
nanNet Revenue Margin —Fitch Mini.— Target 34%
Total P.-- as Eitig F..
Free Cash as % of Depreciation
Debt to Net Plant Investment
120.0°/.
75.01Y
-------
........... ......... . ... .. ....... ... . ....
110.0%
70.0%
6 5. (r/.
---------
100.0%
61,0%
--------
55.0
80.09/6
50
70.0 ./6
60.0%
450%
4
.0%
3 5
J,
50.0%
30.0%
40.0%
25 lr/,
30.0w'/.
15 0%
0
10'0%
50 -1.
111
0.0%
00%
.......... .
2013 2014 2015 2016 2017
2013 2014
2015 2016
2,117
MF— Cash
as%ofDepreciation . Cash as % ofDopoein.. (W/Adin. Transfier) — Minimum Target
uDebt to Net Plant
Investment aaaaaMaxinaorn Target
50%
Operating Reserves Ending Cash Balance
Capital Reserves Ending Cash Balances
$10.000'Wo
S7.000,000 ... ..... .... . . ........... ................. ..... ................ .
$9 ... ....... ......... . . . . . ...... . . . ............................... — ---- ----
$8,000,000
$7,000,000
55.004000
S6.000,000
$4,004000
55,000,000
54.000,000
53.000.000
53,000,000
S2.000.000
$2,000,000
S1.004000
$1,000.000
50 2013 2014 2015 2616 2017
So 2013 2014 2015 2616 2017
Wale, and Wastewater Encumbered Projec Fund - 408 ■P,.p..d Debt P,.e..d.
� Fund 401 Revenue (Operating) Fund ass, aaReqd Reserve (2yrs Debt Prot & 25% of O &M)
: Existing Debt Proceeds ■Cronbiood System Development Charges
Targ f4l7 Day, .f0&M
ult&R Fwd -407&410
Renewal and Replacement Fund Ending Cash Balance
Capital Improvement Program Funding
$4.000.000
R—F-d(Ttese—)-40l
S3,500,000
P- R—e (PAYW f.. P—)
51.456.M
S300,000
OW,w S Dev,Iansal Chg, F -404
$2,500,000
5351.116
5631,084 HWa—star N,etq— C",, Fund -405
$2,000,000
510.163.70
OW —,ter R,,,.l and R,,].— Fwd - 407
31,500,00O
$1,918,971
Al
$1,000,000
wW— W-- F—b=d Prjees, Fmd -
Q8
$500,000
uWmer Renewal and Replacement Fund -
$1.935.372
SO
2013 2014 2015 2016 2017
VQs—Tkn Si,, 2003 ands Fund - 414
Yes, End Cash Balances Deposits / Transfers In
51,001,85
Additional R--. &md Series 20l 1 13oad,
—R&R
Fund E.p-ditures T.-f.,a Out -City Target R&R 13.1—
&3,542,549
Page 2 of 2
�`',�
ocoee
11.11 b
Current Year Index Adp, mmt (October)
Water Sy t
EO tila Month of Increase
Wa t nt S) t Existing
rff,chve Month of Increase
Figure 1
City of Ocoee, Florida
Water and Wastewater System Financial Model
2013 Utility Revenue Sufficiency Analysis
Performance Metrics & Dashboards
0.0u"r6 390% 3.(HP7 3.00% 300%4 Water System Surplus(DeGcrmcy)
0,00% 0.w% 000% 1 "1", O.OU%
Ckt 0"' Od, 0.t. (Jr:t. Wastewater System Surphw (Def •yl
OIXPI. 0.00% 00(q %, IWO% 0.00!
Ckt. 0" - Cyst. (ycl, Oct Combmed System Sugrins (Deficfenq)
All -In Debt Service Coverage
.00 —. _...— ..--- - - ._ .. _
80 _— d
.40 • .._
i
.20
1.80
r
1.60
AIR
1.40 -"
l.zo
3
i
).00 - --
2013 2014 2015 2u16 2017
t All -In Debt Service Coverage t Minimum Target Coverage 1.50
Existing and Proposed Debt Outstanding - Ending Principal
Balance
2.5(
1.50
1.00
0.50
1'R
A \1:
Debt Service Coccrage - Senior Lien Debt
2013 2014 3015 2011 2017
MSenior Lien Coverage / Net Revenues ®Senior Lien Coverage / Net Revenues & SDC1's
..Minimum Requirement 1.00 — Minimum Requirement 1.10
Existing and Proposed Debt Service Payments
$2.500.000 .................- - --... _..... _....----------- .........
-.._—._ .........
—
$2.000.000 ...... --
51.500.000
51,000,000 -
5500,000
So 2013 2015 2017 2019 2021 2023 2025 2027 2029 2031 2033 2035 2037 2039 2041 2043 2045
uProposed Debt Service Payments ab.isting Senior Lien Debt Payments
$5.000.000 -- -
so 2013 2015 2017 2019 2021 2023 2025 2027 2029 2031 2033 2035 2037 2039 2041 2043 2045
uProposed Debt Service Balances ■Existing Senior Lim Debt Balances
Average Combined Residential Water & Sewer Bill (7 kgal)
Historical & Projected Water Accounts & Revenue Gallons
$70.00. — ... - -- - -- -- - - - - --
14,000 -_
1,604000
S60.00 4
12,0DO _...
1
1201,000
550.00
0,000 —
-
-- —
-
8.000
—
j
1.000,000
$ 40.00
4
t
800000
$30.00 —
00
6.0 —
- _..
I '
s
604000
$20.00 —
4.000
—
�
400,000
$10.00 .
2,000 ',
f
$0.00
2013 2014 2015 2016 2017
l
0 .
2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
0
Rates •Averege Total Water &Wasleweter B81- Proposed Rates
�Water Accounts Water Revenue Gallons
■Average Total Water & Wastewater Bill - Existing
Historical & Projected WastewaterAccounts & Revenue Gallons
Historical & Projected Reclaimed Accounts & Revenue Gallons
-
804000
7,000
1,000,000
9,000 -.
960,O10
8.000 .._._ ._ ........ — __..__.
__...
701.1100
6.000
Sao,"
7000
4
600.000
5 ._... ___ ............... --.-_ — ..........
21 6 000 ; -_ _... __..
g
!
500.000
'n
600.000 .
§ 5 000
4.000
i
500.M
ES
4,000 .. —
!3
i.. i
I
400.000
E 1
3 000 -_ _ -- -_ :,
1
i
- 400.000
3.000 C - -
1
{
1
2.000 1
_ I
200.000
-.
200.000
2,000
1
i
100.000
1.000 .... ... ._. !
i 1
!.
100,000
1000
i �
I ._....
- 0
0 -
2(x17 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
0
0 ,...�
2007 2008 2009 2010 2011 2012 2013 21114 21115 21116 2,17
Reclaimed Water Accounts �Reclained Water Revenue Gallons
Wastewater Accounts Wastewater Revenue Gallons