LEGO RPO / 02 Service Design

Optimizing a global supply chain tool for global retail planners through qualitative research, workflow blueprinting, and actionable UI rationalization.

Enterprise Platform Optimization & Workflow Blueprinting
Project Client
LEGO RPO
Service
Service Design
Role
Service Designer
Year
2025

The Challenge

LEGO RPO relies on a complex global supply chain tool for retail planning across global markets. The Retail Planning Operations team acts as the critical link connecting this external vendor platform to the actual demand planners. These planners operate across EMEA, APAC, AMS, and China, handling a massive workload forecasting demand for physical retail stores and online channels.

The core issue was a distinct lack of structured understanding regarding planner satisfaction and friction. The existing qualitative data was fragmented. We had no clear map of the end-to-end planning journey. The platform functioned technically, yet the human experience driving the data remained largely undocumented. Planners needed more time for high-impact strategic tasks rather than fighting system inefficiencies.

Service Design Approach

Designing for this highly specialized workflow required deep immersion into the users' ecosystem. By systematically mapping their processes and synthesizing thick qualitative data, I uncovered the human friction hidden beneath the technical platform.

01 / ALIGNMENT

ecosystem mapping

Built a stakeholder map to align internal engineering capabilities with overarching business goals.

02 / RESEARCH

qualitative research

Designed a collection guide and facilitated 7 deep-dive interviews with demand planners spanning all 4 global regions.

03 / OBSERVATION

contextual inquiry

Conducted live user walkthroughs of the platform to observe candid discussions about critical pain points.

04 / SYNTHESIS

insight synthesis

Used qualitative synthesis tools to map pain points, structuring the narrative using the SCR framework.

Strategic Outcomes

I translated complex qualitative insights into tangible, highly readable assets designed to actively drive product development, prioritize immediate usability features, and confidently guide the strategic roadmap for the engineering teams.

* Note: The artifacts and descriptions below have been simplified to protect confidential company data.

PERIOD
WEEK 1
WEEK 2
WEEK 3
WEEK 4
STAGE
DATA COLLECTION AND EARLY ANALYSIS
EARLY FORECASTING
INPUT AND ALIGNMENT
FINALIZATION
TASK
Analyze year-to-date performance
Identify planning exceptions
Draft new forecasts in Excel
Upload forecasts to the system
Execute submission steps
Validate disaggregation accuracy
Communicate updates
JOBS TO BE DONE
Pull historical sales and compare to the last approved forecast. Identify SKUs with recurring underperformance or strong uplift
Highlight SKUs with abnormal growth, large forecast error, or newly launched items missing history
Build initial demand plans based on previous cycle performance and updated assumptions. Apply promotional uplifts manually for specific SKUs.
Import Excel forecasts into system (volume-to-value view). Ensure correct mapping across fields and markets
Run macro refresh, recalculate sell-in, refresh reports, and finalize submission for all markets
Check that commercial strategy and top-line numbers correctly cascade to lower levels
Send final plan updates to stakeholders and notify teams of next cycle start
TOUCHPOINT
Power BI, Excel
Excel, Power BI
Excel
Volume-to-value screen in the platform
Platform (action buttons)
Commercial strategy screen and frames in the platform
Email, Teams
FRUSTRATION
No consolidated overview inside the platform
Missing exception or variance fields inside the tool. Hard to isolate anomalies
Heavy file handling, error-prone manual inputs, and no version control
File imports fail if format or field order changes. Errors not clearly shown. No bulk edit option
No progress indication for macros. Unclear job completion status
Automatic disaggregation incorrect for some themes
No release notes
WORKAROUNDS
Use pivot tables in Excel or pre-built Power BI dashboards to track actual versus forecast
Use Excel formulas to calculate variance by SKU and sort by percentage change
Use linked Excel macros to calculate adjustments and baseline overrides
Split large uploads into smaller files and retry sequentially
Monitor manually and re-trigger if needed
Manual split in Excel
Check on the Teams channels or ask peers
IMPACT (task criticality against the demand planning process)
USER SATISFACTION (user satisfaction against the workflow efficiency)
DIAGRAM
INTERSECTION PEAK FRUSTRATION INTERSECTION
OPPORTUNITIES
Integrate YTD/YTG views directly into the planning screen
Introduce a variance-based "plan by exception" filter
Embed forecasting and promo uplift modeling into the tool directly
Build guided import flow, bulk edit support, and preview error messages
Merge redundant buttons and add progress bar with estimated completion
Automate disaggregation logic based on historical splits
Introduce monthly release notes for planners
GLOBAL USER JOURNEY MAP SIMPLIFIED FOR VISUALIZATION
HIGH IMPACT
LOW IMPACT
LOW EFFORT
HIGH EFFORT
1
QUICK WINS
2
BIG BETS
3
FILL-IN
4
MONEY PIT
Automate historical splits
Fix Export Formatting Concatenation
Remove Redundant Refresh Buttons
Restrict Scenario Controls to Admins
Predictive Promo UI
Centralized Workflow Hub
Contextual ML Dashboard
Custom Disaggregation Engine
Async Recalculation UI & Notifications
Update Button Naming Conventions
Tooltips for legacy fields
Legacy Macro Support Maintenance
Custom user-defined SQL views
IMPACT-EFFORT MATRIX SIMPLIFIED FOR VISUALIZATION

Key Deliverables

  • Created a unified artifact mapping the end-to-end planning cycle across 4 global regions, exposing exactly where planners lose the most time.
  • Designed a prioritized 2x2 matrix categorizing 40+ usability issues and workflow bottlenecks into actionable product roadmap items.
  • Formulated a blueprint for consolidating redundant screens and automating massive data disaggregation flows.

Business Impact

  • Exposed critical macro failure points, leading to a streamlined asynchronous recalculation UI that reduces waiting times by 30%.
  • Provided essential transparency, shifting the engineering team's focus from "technical functionality" to "user efficiency".
  • Defined the definitive starting point and scope for the next major iteration of the retail planning workspace.
MARIUS BARBUȚA • OTHER PROJECTS ↓