ARR OpenGov Presentation — original pdf

Backup

OpenGov: Budgeting and Planning ZWAC Presentation May 11, 2022 Agenda • How did we get here? • What is OpenGov? • Why OpenGov • How will ARR utilize the system? • Example screenshots from the system • ZWAC statistical reports How did we get here? • Budgeting of the past • Fiscal year 2014 – Excel • Fiscal year 2017 – Excel through SharePoint • Fiscal Year 2022 – OpenGov with Excel • Fiscal Year 2023 – OpenGov What is OpenGov • Cloud-based budgeting & performance management • Designed exclusively for government • Collaborative budget process • Budget monitoring and reporting • Dashboard and story creation Why OpenGov • Designed exclusively for government entities • All the latest features and functionality • Unlimited users (no per-user fee) • Transparency Questions Single Stream Recycling Statistical Report To: Zero Waste Advisory Commission CURRENT DATE Overview of Contracts The City of Austin is currently in 20‐year contracts with Balcones Resources (Balcones) and Texas Disposal Systems (TDS) for the City’s curbside single stream recycling processing. The agreements require the vendors to receive collected materials intended for recycling and to operate a materials recovery facility for the purposes of accepting, sorting, processing, and marketing the City’s collected material. Under the terms of the current agreements, Balcones receives 60% of the City’s collected material on an annual basis while Texas Disposal Systems receives 40%. Processing cost per ton is established during the recycling contract reset period that occurs every five years. The City receives revenue and pays processing costs to both vendors. The basis for revenue is the composition percentage of each class of recyclable material. This is determined during semi-annual composition studies that occur at each vendor’s facility. Prior to the latest contract reset that occurred in October 2021 both vendors had the same revenue share formula. However, during that reset period Balcones Resources agreed to a new revenue share formula. The following is each vendors' current revenue share formula: Texas Disposal Systems: (Revenue Percent x Value of Recyclable Material) - Processing Fee Balcones Resources: (Gross Value of Recyclable Material - Processing Fee) x Revenue Percent Note: Colors associated with each vendor are consistent throughout the report. Balcones amounts are represented by dark blue. TDS amounts are represented by light blue. Colors related to prior periods within charts are muted. Values displayed at the bottom of graphs are reflective of the most current period. Curbside Recycling by Vendor: 5 Year Annual History Light Blue: Texas Disposal Systems Dark Blue: Balcones Resources Data Updated 16 weeks ago Vendor Tons Delivered BALCONES TDS TONS DELIVERED Curbside Recycling by Vendor: 12 Month History Light Blue: Texas Disposal Systems Dark Blue: Balcones Resources Data Updated 16 weeks ago TDS: Year over Year - 2 Months Tons delivered to Texas Disposal Systems - current and prior month for two years. Data Updated 16 weeks ago 70k 60k 50k 40k 30k 20k 10k 0 7k 6k 5k 4k 3k 2k 1k 0 2.5k 2k 1.5k 1k 500 0 Tonnage of Curbside Recycling by Vendor Historical Annual Recycling Tonnages by Vendor FY2017 FY2018 FY2019 FY2020 FY2021 63,004.69 Vendor in FY2021 FY2017 34,201.13 24,488.10 58,689.23 FY2018 35,096.77 23,550.38 58,647.15 FY2019 35,302.74 23,986.85 59,289.59 FY2020 37,341.30 26,089.28 63,430.58 FY2021 35,507.33 27,497.36 63,004.69 Current Monthly Curbside Collection Tonnages by Vendor December 2020 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 August 2021 October 2021 4,792.05 Vendor in October 2021 Balcones: Year over Year - 2 Months Tons delivered to Balcones Resources - current and prior month for two years. Data Updated 16 weeks ago 3.5k 3k 2.5k 2k 1.5k 1k 500 0 October 2020 October 2021 October 2020 October 2021 2,011.28 Vendor in October 2021 2,780.77 Vendor in October 2021 Vendor Tons Delivered BALCONES TDS TONS DELIVERED September 2020 October 2020 September 2021 October 2021 3,248.67 2,294.06 5,542.73 3,176.88 2,094.01 5,270.89 3,006.21 1,930.38 4,936.59 1,286.17 2,011.28 3,297.45 Curbside Recycling Costs and Revenue by Vendor What is the cost of curbside recycling processing? What revenue is received from curbside recycling? Processing Cost by Vendor Amounts displayed are only related to the month of (INSERT HERE). Data Updated 16 weeks ago BALCONES TDS Revenue Share by Vendor Amounts displayed are only related to the month of (INSERT HERE). Data Updated 16 weeks ago BALCONES TDS $389,488.42 Vendor from FY2022 $443,494.89 Vendor from FY2022 Curbside recycling in Austin is collected in a single cart and therefore materials delivered to the vendor which have resale value must be sorted and prepared for secondary markets. This processing cost is assessed by the vendors and paid by the City per ton of recyclables delivered. The gross amount above is recognized as "Collection Costs" expense within Austin Resource Recovery's operating fund. Net Value to the City per Ton by Vendor Vendors compensate the City for an estimated portion of the resale value of recyclable material collected via revenue sharing. The gross amount above is recognized as "Recycling Sales" revenue within Austin Resource Recovery's operating fund. The graph below divides the net monthly revenue from each vendor by the tonnages delivered to each vendor in a given month, compensating for the difference in value generated from the amount of recyclables delivered. The differences in net value to the city per ton in a given month (below) are the result of contractual differences in processing rates and revenue sharing terms. Net Revenue Due to the City per Ton Due to cost being displayed as negative numbers, lower values in the visual display show higher cost to the City. Data Updated 16 weeks ago $30 $20 $10 $0 -$10 -$20 -$30 -$40 -$50 -$60 Powered by OpenGov December 2020 February 2021 April 2021 June 2021 August 2021 October 2021 Texas Disposal Systems Balcones Resources Austin Resource Recovery OpenGov