University of Twente Student Theses
Improving insights into the inventory liability of EMS components
Hartgring, E.I. (2025) Improving insights into the inventory liability of EMS components.
|
PDF
2MB |
| Abstract: | This report addresses the inventory component liability at Nedap Retail. The problem started with the Electronic Manufacturing Services (EMS) claiming that high inventory positions are primarily driven by actions from Nedap. Nedap requires a substantiated explanation or supporting documentation from the EMS before agreeing to this claim. Therefore, the core problem identified is the lack of insight into component inventory liability at EMS. The aim of this research is to determine the extent to which the component inventory liability can be made transparent and optimized through data analysis in Power Business Intelligence (Power BI). To address this problem, the research was structured around four research questions. The main focus was on the fluctuations of the Key Performance Indicators (KPIs) and their impact. The KPIs are: inventory position, sales orders and forecasts, lead time, and price, and are referred to as “reason codes”, along with their corresponding liability values. A data-driven approach was used to develop a prototype tool aimed at improving the insight into component inventory liability. Data from Power BI was exported and analysed to identify the liability values associated with corresponding KPI fluctuations and excess value. The prototype tool is created in Excel. |
| Item Type: | Essay (Bachelor) |
| Clients: | Nedap, Groenlo, Netherlands |
| Faculty: | BMS: Behavioural, Management and Social Sciences |
| Subject: | 58 process technology |
| Programme: | Industrial Engineering and Management BSc (56994) |
| Link to this item: | https://purl.utwente.nl/essays/105279 |
| Export this item as: | BibTeX EndNote HTML Citation Reference Manager |
Show download statistics for this publication
Show download statistics for this publicationRepository Staff Only: item control page
