Mandalay CS 3.2Regulatory ReportingVictoriaHow do I implement the VIC EPA data pack for Waste Mass Balance and Levy Return reporting?

How do I implement the VIC EPA data pack for Waste Mass Balance and Levy Return reporting?

The state government of Victoria has issued a requirement that all Landfill operators where a waste levy is currently paid to the EPA will need to provide a Mass Balance Report (see here for the publication of the guidelines)

This report is required to show movement of waste into the site and out of the site along with whether the waste has gone to disposal or stockpiled at the facility.

The government has issued an Excel template that is to be used by the operator to submit their data along with their quarterly levy returns. The spread sheet contains 3 parts:

Data Entry

https://www.epa.vic.gov.au/about-epa/publications/2040-waste-

https://www.epa.vic.gov.au/about-epa/publications/2040-waste-mass-balance-guideline

Calculations

Waste Flow Diagrams

The data pack that Mandalay provides is designed to assist with entry of data into this spread sheet. Specifically the first section where the data is entered. The data pack comprises a set of data categories and events that can be applied to various master data elements. When a transaction is recorded the data categories will then be applied to the transaction. Reports can then be run against a transactions to determine the correct classification of the data.

The Victorian EPA data pack will comprise the following data categories:

  • Waste Category
  • Levy Rate
  • Waste Fate
  • Destination
  • Waste Material Type
  • Operational Use Type
  • Mass Determination

Reporting will be provided to allow:

  • Auditing of the data captured against each transaction and
  • Submission of the quarterly Levy Return
  • Quarterly Waste Mass Balance data entry

Applying a Category

The data pack categories provided can be applied to either a product or a location to allow the scenarios allows through waste mass balance report. There are 2 types of categories available, 1) Data Category or 2) Levy Exemption Events.

Locations

Some of the data categories will need to be applied to a location. Its also possible to assign an Operational Use Type event to a locations to ensure a movement is classified for operational use.

  1. When a location is external and being used for outbound movements the Destination can be set as required.
  2. For operational use the Destination Levy Exemption Event can be set to a valid Operational Use Type.
  3. Source Use is the data category for identifying how the location is categorised when used as the source of transaction.
  4. Waste Fate is the data category for identifying how the location is categorised when used as the destination of transaction.

Note: The Destination is only required to be applied at the top most location. All other locations under it will inherit this category in the reports.

Products

For a product the data categories are applied using the manage favorites button. From here the Waste Category and Levy Rate for all movements can be defined. Plus the waste material type for outbound movements is defined here.

To add a data category, select it from the left list and then press the add button (or double click) to move it to the right.

Note: It is possible to add more than one option to the right list but unless this field is mandatory, and would therefore require the operator to select, it is advisable to only ever have one option applied to a production. This may require the creations of an additional product if it could be classified as either.

Its also possible to apply an operational use exemption against a product rather than the location.

Data Pack Categories

Below is an explanation of each of the data categories available as part of the VIC EPA data pack and how will be reported. Mandalay provides these data elements for you to assign as required to your data elements, but can not provide direct advise on how your waste movements should be categorised. Where possible we will identify what may not be a valid reporting scenario but at this will be provided through the reporting process once made available.

For assistance on how to classify you data correctly you should reach out the Victorian EPA or contact our preferred consultation partner Resource Hub.

Waste Category

The Waste Category is used to specify the type of waste being moved. The data pack provides the following data options:

Code Description
PWA Packaged Waste Asbestos
CD Construction and Demolition
CI Commercial and Industrial
MSW Municipal Waste
FILL Fill material
CATB Priority Waste - Cat B
CATC Priority Waste - Cat C
CATD Priority Waste - Cat D
SCA Soil Containing Asbestos
OTH Other
NA Not Reportable (this will exclude a transaction from the mass balance report and levy return report)

NOTE: The CD and CI categories will both be reported and aggregated as Industrial Waste when reported in the Waste Mass Balance report. The Levy Return report will report against each category.

Levy Rate

The Levy Rate is used to specify the levy rate applicable for a specific waste movement. The data pack provides the following data options:

Code Description
MSW MSW
CI CI
CD CD
PWB PW B
PWC PW C
PWD PW D
SCA Soils Containing Asbestos
PWA Packaged Waste Asbestos
NOLEVY Not Levied
REBATE Allowable rebate claim

NOTE: The CD and CI categories will both be reported and aggregated as IND when reported in the Waste Mass Balance report.

Waste Fate

The Waste Fate category is used to determine what has occurred to the waste at the destination location for the movement. The data pack provides the following data options:

Code Description
DISP Disposal
OP Operational use
REC Recovered Resource
STORERR Temporary Storage (resource recovery)
STOREOP Temporary Storage (operational use)
STOREDISP Temporary Storage (disposal)
STATIon Transfer Station 

Destination

The Destination category if used to define an external location that is used for outbound movements. It's defines the location of the site receiving the waste. The data pack provides the following data options:

Code Description
SA SA
VIC VIC
QLD QLD
WA WA
NT NT
TAS TAS
ACT ACT
INT International

Note: This category is only required for outbound movements.

Waste Material Type

The Waste Material Type is used to define the material composition for outbound waste movements. The data pack provides the following data options:

Code Description
C Concrete
M Metal
TGW Timber/green waste
P Plastic
CP Cardboard/paper
FILL Fill material
OTH Other

Note: This category is only required for outbound movements.

Operational Use Type

The Operational Use Type is used to define how material is being used for operational purposes on site. This category is define using Levy Exemption events and the data pack provides the following levy exemption events:

Code Description
CON Construction
CAP Final Capping
COVER Cover material
INTRD Internal haul roads
LF Landfill

Mass Determination

Mass Determination is an element required in the Waste Mass Balance report. The report allows for 3 options:

  • Onsite weight - Any transaction with a gross and tare captured over a weighbridge or manual weights but the Offsite Weight manual ticket reason was not used.
  • Offsite weight - Any transaction with a gross and tare captured manually and the Offsite Weight manual ticket reason was used. (A manual ticket reason called Offsite is created as part of this data pack)
  • Conversion factor - Any transaction where no gross and tare exist. This is essentially any non weighed transaction. Refer to the Mass Balance guidelines on the appropriate conversion factors to apply to your non weighed products.

Note: To support the offsite weight option a manual ticket reason event has been provide in the data pack.

Source Use

The Source Use category is used in provide details on the source of the waste movement. It is specifically needed for providing the information on if the load is Waste In, Waste Out or Temporary Storage. The code is applied to the locations used as as the source of a location.

Code Description Mass Balance Report
TSWON Temporary Storage (material won onsite) Temporary Storage (material won onsite)
TS Temporary Storage Temporary Storage
EXTERNAL External Source Waste In
INTERNAL Internal Source Waste Out
STATION Transfer Station  Waste In (Where the was comes from another facility not on part of the landfill and on the same site)

Landfills with a Transfer Station

If your site includes a transfer station that is not part of the Landfills EPA license, you should ensure that your location tree in Mandalay separates the Landfill from the Transfer Station locations.

Any location that is not part of the landfill license should have the Waste Fate and Source Use set to Transfer Station. This will ensure any inbound transactions are ignored and any internal movements from the transfer station to the landfill are reported as Waste In for the landfill.

Excluding a transaction from a report

In some cases you may want to exclude a transactions from the Mass Balance or Levy Return report. If this is required the NA Waste Category should be used. This will only affect the summary reports so they will still be included in any detailed audit reports.