Cost and Carbon Models

This section includes cost and carbon modeling tools to help policy planners evaluate the economic and environmental impacts of program changes.

Blue Box Carbon Cost Calculator:

LINK TO CARBON COST CALCULATOR (Updated October 2016)

(NOTE: MACROS MUST BE ENABLED FOR FILE TO WORK)

The Blue Box Carbon Cost Calculator optimizes the Blue Box program by achieving maximum emissions offsets at the lowest possible cost. A new metric for evaluating materials ($ spent for every one tonne of CO2 avoided is introduced). Users can enter in a Goal emissions target, and the calculator will automatically calculate what materials should be targeted for recovery.

1) The calculator first identifies an optimal emissions target. This is done subject to the following constraints:

Minimize the $/teCO2 for the entire system. There was an algorithm that inputted in a system wide GHG goal, and the calculator would then change the recovered tonnes for each of the materials (specifically targeting materials with low costs and high emissions savings) and determine what the total system cost, $/teCO2 and recycling rate would be. These results are shown in the worksheet Optimal Emissions Target. Each of the rows represents a separate calculation to determine at what point $teCO2 is minimized.

2) Once the calculator finds the point at which $/teCO2 is minimized (and the corresponding systems emissions level), it then optimizes the system (by changing the recovered tonnes) to achieve the lowest possible system cost at that particular emissions level (2,050,000T).

There are a number of constraints on how the recovered tonnes can change – generally speaking, I limited the range for how much a specific materials recycling rate can change (within 25% of the historical average). These constraints can be seen by opening Excel’s solver feature.

Blue Box Optimized Cost Calculator 

Blue Box Material Specific Cost Model 2015

(NOTE: MACROS MUST BE ENABLED FOR FILE TO WORK)

The Blue Box Optimized Cost Calculator attempts to achieve a goal recycling rate (user entered) at the lowest possible cost. Users can also enter in custom scenarios to determine how removing materials from the Blue Box program impacts system costs. A full write up on the methodology behind the calculator can be found in the following attachment:

Model Methodology

Blue Box Municipal Bands Calculator

Modeling Municipal Bands v2

(NOTE: MACROS MUST BE ENABLED FOR FILE TO WORK)

The Blue Box Municipal Bands calculator attempts to optimize the Blue Box program by targeting specific geographic regions for recovery. This findings from this calculator raise important questions regarding whether access to recycling is a right that should be enjoyed by everybody, or something that should only be offered if certain conditions are met.

Ontario Electronic Stewardship Carbon Cost Calculator

OES Calculator 01202016 (Updated November 2016)

(NOTE: MACROS MUST BE ENABLED FOR FILE TO WORK)

The OES Optimized Cost Calculator attempts to achieve a goal recycling rate (user entered) at the lowest possible cost. Users can also enter in custom scenarios to determine how removing materials from the WEEE program impacts system costs.