Technical Services - Packaging weights script modifications

*Please note: the service contract for this position will not be concluded with Henkel AG & Co. KGaA but with an external party”.

Method validation: Approximation of packaging weights for insufficiently specified Henkel products – Script modifications

Problem

Henkel has to know the overall weight and materials of the packaging used for the Henkel products. Those parameters are determined based on the packaging BOM and specification data and the product sales data. Henkel specification data for determining the weight of packaging materials is not perfect, BOM data or the specification data can be missing or wrong. The fraction sales with such data cannot be neglected. Hence, the packaging weight of this fraction sales data has to be approximated. To that end, a python script has been developed and used for a comprehensive calculation of Henkel’s 2020 packaging data (created by the consultant in a previous project). This set of data will now be validated by the Henkel packaging experts. The validation exercise will be carried out in several iteration cycles. The expected number of iterations will be up to ten or until the most valuable product is created at least. Each cycle will result in change requests for the Python approximation algorithms.

Background of the engagement of an external consultant is that he has appropriate and required skills and capabilities that is not available internally. In addition the external consultant will provide services that are clearly distinguishable from the services internal employees are providing and he has already developed the python script independently.

Task

Each cycle of the validation exercise will result in change requests for the Python approximation algorithms. The contractor will receive a list of change requests, which he processes independently.

As part of the validation exercise the contractor has the following task that he provides independently:

Participate in project relevant workshops to evaluate the validation findings with the packaging experts and project manager

Based on the evaluation, mentioned above, define and consult on change requests

Processing of change requests (will be provided by project manager) for the resulting script

Re-running the resulting script to obtain a refined set of packaging result data

Handover of refined set of packaging result data to validation team (packaging experts and project manager)

All Henkel products sold in a year are in scope. Python is the coding language. The code used for calculation the well-specified data is available to the contractor from a previous project.

Used data:

Henkel sales data

Bill of Material data

Specification data for packaging materials

The goal is to refine the method of approximation of packaging weights for insufficiently specified Henkel products.