data4success

Contact

Calculator for notifications according to the Packaging Act

I know my sales figures. How do I use them to create the reports to the Central Packaging Register?

The answer: Use my interactive Excel calculator for this. All you have to do is enter there:

  1. Which items were sold to Germany and how often.
  2. Which packaging materials are incurred per item.

Excel calculator Reports according to packaging law based on sold article quantities Download

The calculator automatically calculates the quantities you need to enter in the Lucid packaging register from these two pieces of information!

Excel sheet "Packaging material per item

Here you enter per article which packaging type consists of which materials, and how many grams this material makes up per sales unit. The example in the picture means that the article with the number "2" has a service packaging, which consists of 464 grams of beverage carton packaging, and 180 grams of ferrous metals. You could also add a third line to this item that has paper/cardboard/cardboard 300 grams as shipping packaging. You enter this for all items.

Excel sheet "Sales to Germany

In this worksheet you copy a list of all sales, for example from your merchandise management system. For each item number and date, simply enter how often the item was sold. If an item occurs multiple times in one day, that's ok too. Of course, you should subtract returns/credits/returns from these numbers. If you don't have the data to the day, you can just pick any day in the month.

Evaluation (message)

Once you have entered the data in the first two worksheets, you only need to press the following buttons, from which the message will be created automatically:

Then wait a few seconds, and the numbers for the message are already calculated.

Types packing

First, you should record for each item what types of packaging it has and what materials they are made of. It is important to separate the types of packaging from one another as early as the recording stage, as different types of packaging may or may not be subject to system participation depending on the customer and the product. For example, shipping and transport packaging does not always have to be reported, but sales packaging does. The Central Office distinguishes between the following five types of packaging (Source):

  • Service packagingService packaging is packaging that is only filled with goods at the final distributor in order to enable or support the transfer to the private end consumer. Typical examples are bread roll bags, butcher paper, trays for French fries, coffee-to-go cups or bags for fruit and vegetables. Here - and only here - the person who places this packaging filled with goods on the market for the first time is allowed to
    (e.g., baker, butcher, snack bar, café, or retailer) who already purchase packaging with system participation.
  • Transport packaging: Transport packaging means packaging which facilitates the handling and transport of goods in such a way as to avoid their direct contact as well as transport damage and which is typically not intended to be passed on to the final consumer.
  • Repackaging: Overpacks group together a certain number of sales units and are offered to the end consumer in this form. Alternatively, they serve to stock the sales shelves. An example of this is packaging that groups bottles together as so-called "carriers".
  • Sales packaging: A sales package is a product made of any material to contain, protect, handle, deliver or present goods. It is typically offered to the end consumer as a sales unit consisting of goods and packaging. This also includes service packaging and shipping packaging as well as all components of the packaging and packaging aids, such as labels, suspension aids, closures.
  • Shipping packagingShipping packaging enables or supports the shipment of goods to the end consumer. The entire packaging material, including the filling material, which is placed on the market as part of the handover or shipment to the end consumer and which accumulates there for disposal, is considered to be shipping packaging and is subject to system participation.

Packaging materials

For each of the above packaging types, you must now define for each item what materials they are made of. Here, it is important to note that the categorization of the materials is done exactly according to the correct definitions. Green Dot, for example, distinguishes between the following materials in its GTC:

  • Glass: Hollow glass, separated by colors white, green, brown, with lids, residue empty. Filling residue max. 10% of net packaging weight.
  • Paper/cardboard/cardboard: Free from more than 1% non-paper constituents and papers and boards harmful to production (e.g. wax, kerosene, bitumen, oil papers or boards; wet-strength impregnated and/or sized papers and boards). Paper is a flat packaging material consisting essentially of fibers, usually of vegetable origin. Parchment, parchment substitute, glassine and waxed paper are classified as paper.
  • Tinplate: With residual packaging, but emptied of residues. Filling material residues max. 10% of net packaging weight.
  • AluminumOther metals: cartridges, cans, tubes, foils, etc. made of aluminum, empty of residues. Filling material residues max. 10% of the net packaging weight.
  • Plastics: All mixed plastics except material fractions mentioned under c1), c2) and c3). With residual adhesions, but emptied of residues. Filling material residues max. 10% of net packaging weight.
  • PE film: Printing not more than 3% of the surface, without adhesive strips; only material equivalent stickers (eg PE film/PE stickers), film bags residue free without contamination.
  • EPS (polystyrene): White, clean, without glue, without adherent odor. Separated EPS moldings (styrofoam) and loose-fill (chips).
  • PETHollow bodies, emptied of residues, residues max. 10% of the net packaging weight.
  • Plastic composite packaging (LPB)Beverage cartons, empty of contents, max. 10% of the net packaging weight.
  • Other compounds
  • Natural materials: natural rubber, cotton, jute, linen, wool, wood, cork, ceramics, porcelain, earthenware, stoneware, clay

Please note, however, that this calculator is a "simple" variant of the calculation, without taking into account various factors (e.g. type of customers or type of individual product), which can make the calculation a bit more complicated. For individual advice, please feel free to contact me personally. I can support you with the automation of the messages from your ERP system.

Fabian Shirokov - data4success