Sin título establecido.

Abstract

This project addresses a core operational challenge faced by Ailin, a Spanish home-based diagnostic kit company, the absence of a structured, data-supported approach to inventory management and demand forecasting. As the company scales across seven European markets, its reliance on manual processes generates increasing friction across purchasing, warehousing, and customer fulfillment. Through process mapping, bottleneck analysis and a benchmarking of six inventory management solutions, the project diagnoses the root causes of these inefficiencies and defines sixteen functional requirements for a technology solution suited to Ailin's operational context and regulatory environment. The recommendation is a phased approach. First an immediate combination of the e-commerce platform's inventory module, Power BI, and automated Excel, delivering real-time visibility and analytical capability within six months at an estimated total cost of ownership of 18.700 euros; followed by a medium-term migration to SAP Business One once defined operational thresholds are met. Financial modelling under both standard and conservative scenarios confirms Phase 1 is viable without external financing, while Phase 2 remains sustainable under standard conditions. Together, the two phases provide a realistic, evidence-based path from Ailin's current manual model toward a fully integrated, compliance-ready inventory infrastructure.

This project addresses a core operational challenge faced by Ailin, a Spanish home-based diagnostic kit company, the absence of a structured, data-supported approach to inventory management and demand forecasting. As the company scales across seven European markets, its reliance on manual processes generates increasing friction across purchasing, warehousing, and customer fulfillment. Through process mapping, bottleneck analysis and a benchmarking of six inventory management solutions, the project diagnoses the root causes of these inefficiencies and defines sixteen functional requirements for a technology solution suited to Ailin's operational context and regulatory environment. The recommendation is a phased approach. First an immediate combination of the e-commerce platform's inventory module, Power BI, and automated Excel, delivering real-time visibility and analytical capability within six months at an estimated total cost of ownership of 18.700 euros; followed by a medium-term migration to SAP Business One once defined operational thresholds are met. Financial modelling under both standard and conservative scenarios confirms Phase 1 is viable without external financing, while Phase 2 remains sustainable under standard conditions. Together, the two phases provide a realistic, evidence-based path from Ailin's current manual model toward a fully integrated, compliance-ready inventory infrastructure.