In this diploma thesis entitled "Optimization of capacity utilization report in a pharmaceutical company using Microsoft Excel", we aim to explore the area of pharmaceutical supply chain, specifically how to manage risk through the S&OP process within the production resource planning function, achieve agility and high flexibility, and implement an automated report. The automated report will help mitigate supply chain risks and provide a better user experience by focusing on the speed of the review preparation and clear visualization of KPIs, making it easier for employees to make business decisions. The main problem with the outdated report currently is the time planners need to prepare it and the lack of KPI indicators and their visualization. In the theoretical part of the thesis, we dive deep into the supply chain, production planning and the Power Query tool that we will use for the creation. In the empirical part, we use the qualitative method of unstructured interviews to gather additional information about the necessary improvements before creating an automated report in the final section. With the automation, we managed to fulfill most of the users' requirements and confirm all the hypotheses targeting the improvements.
|
