Waste & Recycling Economics: Collection Routes, Gate Fees, Sorting Recovery Rates, Material Prices, Residue Costs & Cost per Tonne
Follow waste from the bin to the buyer. You will cost collection rounds, compare gate fees at fictional treatment sites, track material through a sorting plant with recovery rates and purity, value the output at fictional material prices, pay for residues and find the net cost or profit per tonne, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course follows a fictional recycling business from the bin to the buyer in a spreadsheet. You cost collection rounds per tonne and pool the week, add haul cost to gate fees and pick the cheapest site per area with MIN and INDEX/MATCH, blend household and commercial compositions into material streams with SUMPRODUCT, apply recovery rates and contamination to get bale tonnes, grade bales by purity with XLOOKUP, value the output at fictional prices and test a price drop, price residues and rejected bales, find the net cost per tonne and the break-even in-feed and compare four scenarios in a column chart.
Lessons
- Collection Rounds: Bins, Lifts per Hour, Tonnes per Round and Cost per Tonne Pro
- Gate Fees and Haul Distance: The Cheapest Destination per Area Pro
- The Mass Balance: In-Feed Tonnes × Composition = Material Streams Pro
- Recovery Rates and Purity: Recovered Tonnes, Bale Weight and Grade Bands Pro
- Output Revenue: Tonnes × Price × Grade, Price Swings and Scenarios Pro
- Residues and Rejected Bales: Residue Tonnes, Disposal Cost and the Cost per Tonne of In-Feed Pro
- Plant Economics: Fixed and Variable Costs, Net Cost per Tonne and Break-Even Throughput Pro
- Scenarios and Dashboard: Price Drops, More Recycling, Contract Options and the Chart Pro