Design and implementation of a reporting tool under a supply planning team

This report consists of the design and implementation of a reporting tool created to provide the supply planner with information on the availability of the components needed for the production of the products under their portfolio. The project has been performed into the company of Henkel, under a team of supply planners from Adhesive Technologies in Europe that was mainly focusing on Co-packing activities with external manufacturers. To do so, the below steps have been followed in the creation of the project: 1. Analysis of main handicaps for the supply planning team. 2. Design and creation of a reporting tool made to provide the most valuable information to the Supply Planners. 3. Implementation of the mentioned tool. 4. Analysis of the output and general performance from the supply planners. Three objectives have been defined on the performance of the project: • A reduction in the time invested from each planner to their portfolio. • A reduction on the inaccurate information sent to the manufacturer. • An improvement on preventing future bottlenecks from the stock availability of the components. After the development and implementation of the project, data from twenty-five weeks of usage has been analyzed to determine whether the above objectives have been accomplished or not