Ewance
← All challenges Junior Operations Analyst

Controlling Inventory for a Sustainable Fashion Brand

Duration
1 week
Level
Beginner
Type
Analysis
Team
1 to 5 people

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

  1. Your task is to develop an inventory control system for EcoThreads.
  2. 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

  1. Use ABC analysis to prioritize SKUs
  2. Calculate economic order quantity (EOQ) and reorder point (ROP)
  3. Consider using moving averages or simple exponential smoothing for forecasting
  4. 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.

Sample Ewance certificate of completion, verified by LearnCoin
Sample certificate
Your proof

Finish it. Earn this.

A verified certificate with your name. Anyone can check it.

Time to practice.

Solve this challenge
Related challenges

More like this.