Orange County NC Website
31 <br />Orange County, NC <br />Financial Plan and Rate Study for Solid Waste Enterprise Fund <br />2.1.4 Reserves <br />According to the County's Solid Waste Fund Revenues /Reserves sheet, March 15, 2016, the total <br />estimated ending balance for the Solid Waste Enterprise Fund was $8,867,042 ($3,492,631 of <br />which is the Equipment Reserve balance) on June 30, 2016. This amount represents the ending <br />Fund balance without loan proceeds including those from building construction, rural expansion <br />cart procurement, a rural truck purchase, Eubanks Road W &R Center loan, balance from closure <br />of the Orange County Landfill, and another prior loan. The total estimated Fund balance is <br />$12,751,990 when these additional loan proceeds are accounted for. Use of Fund balance has <br />been required in order to balance the Department budget over the past several fiscal years <br />including the current FY 2016 -17. The goal of the Department is to enable the Fund to be <br />structurally viable and sustainable without contributions from the General Fund or allocations <br />from the Fund balance. <br />2.1.5 Rate Model <br />At the outset of the work effort, SCS developed a Microsoft Exce1TM spreadsheet- based, pro - <br />forma model (Rate Model) to assist in the completion of the financial analysis. This model <br />includes the following facets: <br />• An analysis of operational expenditures (facility operation, staffing, recycling <br />tonnages, tipping fees, etc.); refer to Appendix E for 5 -year estimated Department <br />expense projections. <br />• Analysis of capital outlays (equipment replacement and capital projects) <br />• Revenue analysis (annual revenue projections, net expenditures, and rate plan to <br />provide sufficient revenues); refer to Appendix D for 5 -year estimated Department <br />revenue projections. <br />• Rate Benchmarking Analysis <br />• Transfer Station Implementation Analysis <br />2.1.6 Methodology Overview <br />The following methods were utilized by SCS to conduct the cost of service analysis: <br />• Collect Historical Actual Expenses and Revenues for the County System — This task <br />involved gathering available historical actual revenue and expense data for the Fund, <br />compiling these into a financial database, and incorporating the data into the Rate <br />Model. <br />• Develop the "Test Year" — The second task was the development of an annual <br />revenue requirement for a "Test Year ". The revenue requirement represents the total <br />revenue for the System needed to recover all System costs. SCS worked with County <br />staff to select a period that reflected a typical year for the System. Budgetary <br />expenses for FY 2016 -17 were used as the basis of the Test Year for the Study. SCS <br />then worked with County staff to make these costs more representative of anticipated <br />conditions during the upcoming 5 -year financial planning horizon. The resulting Test <br />18 <br />