|
From 8 DeprPleasanton Garbage Service, Inc.Depreciation & Replacement ScheduleRFP Response Dated March 2, 2018Depreciation (Projected)Notes/Units LifeEstimated Capital Costs FYE 3/31/20183 Months Ended 6/30/186/30/2019 6/30/2020 6/30/2021 6/30/2022 6/30/2023 6/30/2024 6/30/2025 6/30/2026 6/30/2027 6/30/2028 6/30/2029Assets for Current ProgramsTrucks / Trailers1,446,725$ Furniture & Fixtures35,541 Leasehold Improvements32,630 Machinery & Equipment142,353 Assets Placed in Service From 4/1/17 to 10/31/17In svc 4/1/1711 1,657,249 150,659 37,665 150,659$ 150,659$ 150,659$ 150,659$ 150,659$ 150,659$ 150,659$ 150,659$ 150,659$ 112,994$ Estimated Additional Asset Additions Through 6/30/1811 400,000 36,364 36,364 36,364 36,364 36,364 36,364 36,364 36,364 36,364 36,364 36,364 Estimated Commercial Recycling / Organics Route Expansion Roll Out 26 Yard FEL (CNG) 2 11 937,378 85,216 85,216 85,216 85,216 85,216 85,216 85,216 85,216 85,216 85,216 85,216 Small Bins 900 11 495,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 Total Assets for Current Programs3,489,627$ 150,659$ 37,665$ 317,239$ 317,239$ 317,239$ 317,239$ 317,239$ 317,239$ 317,239$ 317,239$ 317,239$ 279,574$ 166,580$ Estimated Cost of Assets Purchased for New Contract G&AHybrid Vehicle 1 11 35,000 3,182 3,182 3,182 3,182 3,182 3,182 3,182 3,182 3,182 3,182 3,182 CIS - Tower11 175,000 15,909 15,909 15,909 15,909 15,909 15,909 15,909 15,909 15,909 15,909 15,909 Bulky Collection Item Asset Additions25 Yard Rearloader (CNG) 1 11 370,833$ 33,712 33,712 33,712 33,712 33,712 33,712 33,712 33,712 33,712 33,712 33,712 18' Flatbed (CNG) 1 11 205,874$ 18,716 18,716 18,716 18,716 18,716 18,716 18,716 18,716 18,716 18,716 18,716 Used Oil Program AssetsOil Jug Racks 8 11 14,344$ 1,304 1,304 1,304 1,304 1,304 1,304 1,304 1,304 1,304 1,304 1,304 Replacement EquipmentReplacement Trucks 12 11 6,000,000 545,455 545,455 545,455 545,455 545,455 545,455 545,455 545,455 545,455 545,455 545,455 Replacement Containers 11 2,535,000 230,455 230,455 230,455 230,455 230,455 230,455 230,455 230,455 230,455 230,455 230,455 Estimated Total of Asset Acquisitions for New Contract9,336,051$ -$ -$ 848,732$ 848,732$ 848,732$ 848,732$ 848,732$ 848,732$ 848,732$ 848,732$ 848,732$ 848,732$ 848,732$ Total12,825,678$ 150,659$ 37,665$ 1,165,971$ 1,165,971$ 1,165,971$ 1,165,971$ 1,165,971$ 1,165,971$ 1,165,971$ 1,165,971$ 1,165,971$ 1,128,306$ 1,015,312$ Depreciation Expense Reconciliation to Cost FormsForm 5A Detailed Costs Vehicle and Container Direct Depreciation1,146,880$ Form 5B - Allocated Costs19,091 Form 5C - MRF- Rounding Error(0) Total FY 6/30/19 Depreciation Expense Reported on Cost Forms 9,336,051$ 1,165,971$ Old Contract DepreciationFISCAL YEAR ANNUAL DEPRECIATION YEARS 1 THROUGH 11
|