Why a Toy Chain Kept Selling but Lost Margin
Aug 2026 to Oct 2026 · 5 min read
The chain kept selling, but its profit margin slipped from 29.3% to 26.2%. I traced it back to the product mix and found a way to win back $208K in profit without selling a single extra unit.
- Role
- Data Analyst, solo project
- Industry
- Retail
- Tools
- Python (pandas), Tableau, Figma
- Timeline
- Aug 2026 to Oct 2026
- Margin drop
- 29.3% → 26.2%
- Profit within reach
- +$208K
- Margin after step one
- 26.2% → 27.7%
#TL;DR
- Problem
- A toy store chain's blended profit margin fell from 29.3% in 2022 to 26.2% in 2023. The goal: get it back to 30% within 2 quarters.
- What I did
- Framed the business question, cleaned and joined 5 tables in Python, analyzed margin by category, product and store location, built a Tableau dashboard, and pitched recommendations to leadership.
- What I found
- Electronics earns the most per unit but its share of units fell from 16% to 8%, while lower-margin Art & Crafts rose from 22% to 38%. Bringing Electronics back to its 2022 share is worth about +$208K in profit and lifts margin from 26.2% to 27.7%, with no new sales needed.
Electronics' share halved while Art & Crafts grew by about 70%.
#1.My role & scope
- Role: Data Analyst, solo project (sole author of all deliverables)
- What I owned: problem framing, stakeholder mapping, cleaning, analysis, Tableau dashboard, final deck design and pitch
- Feedback loop: Each stage was reviewed by my team lead. Based on their feedback, I made Head of Merchandising the Decider and restructured a root cause branch.
- Deliverables: framing deck, root cause & hypothesis deck, 10-slide insight deck, Tableau Public dashboard, leadership pitch deck (Oct 2026)
#2.Background
- Context: A toy retail chain in Mexico with 50 stores across four store locations: Downtown, Commercial, Residential and Airport. 35 products in 5 categories.
- Problem: Blended profit margin dropped from 29.3% (2022) to 26.2% (2023, Jan to Sep), even though the stores kept selling.
- Business question (SMART): How can the chain raise its overall profit margin from 26.2% to 30% within 2 quarters by rebalancing product mix toward higher-margin categories in each store location?
- Why 26.2% is the baseline: it's the current (2023) margin that the recommendations act on. 29.3% is the 2022 "before" level in the decline story, and 27.8% is the 21-month average on the dashboard, which mixes before and after.
- Stakeholders (DARCI):
- Decider: Head of Merchandising, decides pricing and product mix changes
- Accountable: Merchandising Lead, owns the outcome of category decisions
- Responsible: Data Analyst (me), runs the analysis and builds the recommendation
- Consulted: Store Managers, give ground-level input on what sells in each location
- Informed: Purchasing and Inventory team, adjusts ordering based on the results
- The data: A star schema (sales, products, stores, inventory, calendar), which let me answer a real profit question, not just describe sales.
#3.Method / Strategy
- Framing: DARCI stakeholder map, plus a SMART problem statement based on real quarterly figures.
- Root cause & hypotheses: Issue tree built on
Profit = Revenue − Cost, MECE-checked within each branch. Two hypotheses:- H1: The highest-volume category is not the highest-margin category.
- H2: The most profitable category is different in each store location.
- Both were confirmed by the data.
- Cleaning (Python in Google Colab):
- Stripped
$from cost and price columns so they could be calculated - Combined two different date formats into one
- Ran an IQR outlier check on units sold. The IQR was zero, so I kept the bulk purchases as legitimate orders and wrote down why
- Cleaned tables saved as
clean_copies, then joined into one analysis table
- Stripped
- Analysis: Margin and volume compared by category, by store location, 2022 vs 2023, and by product.
- Impact sizing: Estimated the profit gain from shifting unit share back to Electronics, keeping total units the same and only changing the mix.
- Dashboard: Interactive Tableau Public dashboard with category and store location filters.
- Pitch: Leadership deck designed in Figma, with charts traced from Tableau, and presented to leadership.
#4.Metrics
| Metric | Formula | Why it matters |
|---|---|---|
| Gross Profit | (Price − Cost) × Units | The money each category actually brings in |
| Profit Margin % | (Price − Cost) / Price | The headline number to recover |
| Units Sold | SUM(Units) by category / store location | Shows the mix shift behind the drop |
| Units share by category | Category units / total units, 2022 vs 2023 | Shows which categories grew or shrank |
Gross Profit
- Formula
- (Price − Cost) × Units
- Why it matters
- The money each category actually brings in
Profit Margin %
- Formula
- (Price − Cost) / Price
- Why it matters
- The headline number to recover
Units Sold
- Formula
- SUM(Units) by category / store location
- Why it matters
- Shows the mix shift behind the drop
Units share by category
- Formula
- Category units / total units, 2022 vs 2023
- Why it matters
- Shows which categories grew or shrank
#5.Solution
- Tableau dashboard: View dashboard (opens in a new tab)
- Colab notebook: View notebook (opens in a new tab)
- Leadership deck (PDF): View deck (opens in a new tab)
- Dashboard contents: KPI cards (margin, profit, revenue, units), units sold by category, category profit and margin, mix shift by year, profit heatmap by category and store location. Filters: category, store location, year.
#6.Result / Output
Key insights
Insight 1 · The volume vs. margin paradox
Art & Crafts sells the most. Electronics earns the most per sale.
Art & Crafts sells the most units, but Electronics earns the highest margin (45%, vs 21% for Toys). Each Electronics unit brings in $7.47 profit, compared to $2.31 for Art & Crafts.
Show data
| Category | Units sold | Profit | Margin | Profit per unit |
|---|---|---|---|---|
| Art & Crafts | 325,574 | $753,354 | 27.8% | $2.31 |
| Toys | 267,200 | $1,079,527 | 21.2% | $4.04 |
| Games | 194,673 | $673,993 | 30.3% | $3.46 |
| Sports & Outdoors | 169,043 | $505,718 | 23.3% | $2.99 |
| Electronics | 134,075 | $1,001,437 | 44.6% | $7.47 |
Insight 2 · The winning category depends on location
The top category flips by store location.
Electronics leads in Commercial and Airport stores. Toys leads in Downtown and Residential.
Show data
| Category | Downtown | Commercial | Residential | Airport |
|---|---|---|---|---|
| Toys | $630,029 | $225,034 | $136,214 | $88,250 |
| Electronics | $502,490 | $287,574 | $103,176 | $108,197 |
| Art & Crafts | $444,320 | $155,461 | $92,132 | $61,441 |
| Games | $378,421 | $146,296 | $68,508 | $80,768 |
| Sports & Outdoors | $293,468 | $112,499 | $60,358 | $39,393 |
Insight 3 · The mix shift is the root cause
Electronics' share halved while Art & Crafts grew by about 70%.
From 2022 to 2023, Electronics' share of units fell from 16% to 8%, while Art & Crafts grew from 22% to 38%. That pulled the blended margin down from 29.3% to 26.2%.
Show data
| Category | 2022 share | 2023 share |
|---|---|---|
| Art & Crafts | 22.3% | 37.5% |
| Toys | 25.7% | 23.3% |
| Games | 19.7% | 15.9% |
| Sports & Outdoors | 16.1% | 14.8% |
| Electronics | 16.1% | 8.4% |
Insight 4 · A few products carry the profit
One product, Colorbuds, earns more than the next two combined.
Colorbuds is the #1 profit maker at $835K with a 53% margin. Lego Bricks is #3 in profit but earns only 12.5% per sale.
Show data
| Product | Category | Units | Profit | Margin |
|---|---|---|---|---|
| Colorbuds | Electronics | 104,368 | $834,944 | 53.4% |
| Action Figure | Toys | 57,958 | $347,748 | 37.5% |
| Lego Bricks | Toys | 59,737 | $298,685 | 12.5% |
| Deck Of Cards | Games | 84,034 | $252,102 | 42.9% |
| Glass Marbles | Games | 37,518 | $187,590 | 45.5% |
Recommendations (from the final leadership deck)
- Grow Electronics' share. Bring Electronics back to 16% of units, its 2022 level, with more shelf space and stock priority.
- Stock by store location. Lead with Electronics in Commercial and Airport stores. Keep Toys front and center in Downtown and Residential.
- Protect winners, fix thin margins. Protect Colorbuds as the top profit maker, and fix the thin margin on Lego Bricks.
Expected impact
- +$208K in profit with no new sales needed, lifting margin from 26.2% to 27.7%. This is step one toward the 30% target.
- How I sized it: about 40K units shifted from Art & Crafts to Electronics × $5.16 extra profit per unit ($7.47 vs $2.31). Assumes total units stay the same and only the mix changes.
#7.Reflection
- The +$208K is a ceiling, not a promise. It assumes every shifted unit moves one for one from Art & Crafts to Electronics. Some shoppers won't switch, so I'd test the new shelf mix in a few stores first and measure the real lift.
- 2023 only runs to September. The holiday season is missing from the 2023 numbers, so I'd re-check the mix shift once the full year is in.
Data note: Built on a public toy retail dataset: 50 stores, 35 products, 5 categories, 4 store locations, about 829K transactions, January 2022 to September 2023.
View dashboard (opens in a new tab)View deck (opens in a new tab)View notebook (opens in a new tab)