Client Overview: The client is an online retail store specializing in electronics and gadgets. They manage a diverse product range with frequent stock updates and high turnover.
Challenge: The client struggled with outdated inventory tracking methods, leading to frequent stockouts and overstock situations. This inefficiency resulted in lost sales and increased holding costs.
Solution: I developed a dynamic inventory management spreadsheet in Google Sheets. It included automated stock level updates using formulas and conditional formatting to highlight low stock items. Additionally, I created a dashboard for quick insights into inventory status and sales trends.
Results:
- Quantitative: Reduced stockouts by 40%, decreased overstock by 25%, and improved order fulfilment time by 20%.
- Qualitative: Enhanced decision-making with real-time inventory data and minimized manual tracking errors, leading to higher customer satisfaction.