Resource

Decision Support for Sustainable Finance – Calculating Scheme Fees

Resource Information

Resource credentials, information, and download.

Authors
PacWastePlus
Country project
N/A
Document type
Resource Template
Abstract
This Excel spreadsheet is designed to assist in the calculation of the likely Handling and Administration Fees to be placed on each items within a Sustainable Financing (Deposit) Scheme. By using this Excel model, stakeholders can understand financial requirements of a scheme to make informed decisions to ensure the scheme is financially sustainable.

The model's key features include:

Fee Calculation: Based on your inputs in the Questions tab, the model calculates the likely Handling and Administration Fee based on the number of items collected, the power, labour, and other costs to collect and process the items, and the administrative costs to manage the scheme.
Labour Calculation: Based on estimated scheme throughput, the model calculates the "man-hours" required to safely collect and process the items
Export Requirements: Based on estimated scheme throughput and size reduction, the model calculates the number of 20ft sea containers that may be required each year to export the items to recycling markets
Performance Tracking: Once your scheme commences, the model provides for you to track collection data and measures scheme performance (against import data). This allows for accurate reporting the identification of areas for improvement.

This model can be used in conjunction with the Economic Modelling spreadsheet which assist users to analyse the financial implications and return rates across the different system designs.
Attachments
  • Decision-Support-for-Sustainable-Finance-Calculating-Scheme-Fees.xlsx