The situation
EcoThreads is a 2-year-old sustainable fashion brand with 20 employees, selling online and in two pop-up stores. It has 200 SKUs and annual revenue of €1.5M, but inventory costs are eating into margins.
Your task
How can EcoThreads implement effective inventory control to reduce overstock and stockouts while maintaining its sustainability commitments?
The brief
What you do
- Your task is to develop an inventory control system for EcoThreads.
- You must analyze historical sales data (provided in a CSV), identify patterns, propose KPIs (e.g., turnover ratio, fill rate), design a simple dashboard (Excel or Google Sheets), and recommend inventory policies.
Success looks like
Success means a functional dashboard with at least 5 KPIs, a written report explaining your methodology, and clear recommendations for reorder points and safety stock levels for top 10 SKUs.
What you will practice
- Apply controlling concepts (KPIs, variance analysis) to inventory management
- Use data to inform decision-making on reorder quantities and safety stock
- Understand the role of planning and control in operations
- Develop basic forecasting skills using historical data
A suggested way in
- Use ABC analysis to prioritize SKUs
- Calculate economic order quantity (EOQ) and reorder point (ROP)
- Consider using moving averages or simple exponential smoothing for forecasting
- Design dashboard using pivot tables and conditional formatting
Skills you will practice
Inventory management, Data analysis, Kpi definition, Dashboard design, Demand forecasting
How it is assessed
- Data Analysis30%
Accuracy of sales pattern identification and inventory metrics calculation
- Dashboard Design25%
Clarity, relevance, and visual appeal of the KPI dashboard
- Recommendations30%
Feasibility and justification of proposed inventory policies
- Communication15%
Quality of written report and presentation
Resources
- Microsoft ExcelTool
Essential for data cleaning, pivot tables, and basic inventory metrics.
- Python (pandas)Tool
Enables advanced data analysis and demand forecasting beyond spreadsheet limits.
- Tableau PublicTool
Creates interactive dashboards to visualize KPIs and inventory trends.
- Google Data StudioTool
Free tool to build shareable dashboards connected to various data sources.
- CanvaTool
Designs professional-looking reports and presentation slides easily.
- NotionTool
Organizes project tasks, notes, and documentation in one place.
- Google SheetsTool
Collaborative spreadsheet for real-time data analysis and scenario modeling.
Finish it. Earn this.
A verified certificate with your name. Anyone can check it.
Time to practice.
Solve this challengeMore like this.
- Data ScientistExplain a Credit-Risk Model with SHAP for a Fintech
- Senior AccountantIFRS 16 Lease Accounting for a Renewable Energy Firm
- Software EngineerODE Integrator Benchmark for a Pharma PK/PD Pipeline
- Data ScientistInterpretable-by-Design GAM for an Insurer's Claims Triage
-
Explain a Credit-Risk Model with SHAP for a Fintech Data Scientist You receive a trained XGBoost credit-risk model (binary default prediction), the training feature schema (38 features), and a held-out 10,000-sample t shapinterpretabilityfairness analysis Open challenge → -
IFRS 16 Lease Accounting for a Renewable Energy Firm Senior Accountant You are a senior accountant at SunPower Renewables. The company is adopting IFRS 16 for the first time. You are given a sample lease for a wind turbin ifrs 16lease accountingright of use asset Open challenge → -
ODE Integrator Benchmark for a Pharma PK/PD Pipeline Software Engineer Use SciPy's solve_ivp + SUNDIALS (via scikit-sundae or diffeqpy) to benchmark: RK45 (baseline), LSODA, BDF (CVODE), Radau, and Rosenbrock. Run on thre numerical odesstiff integratorsscientific python Open challenge → -
Interpretable-by-Design GAM for an Insurer's Claims Triage Data Scientist You receive an anonymized claims dataset (around 60,000 claims, target: log reserve), a feature schema (22 features), and an existing LightGBM baselin generalized additive modelsebminterpretability Open challenge →