Back

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

  1. Framing: DARCI stakeholder map, plus a SMART problem statement based on real quarterly figures.
  2. 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.
  3. 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
  4. Analysis: Margin and volume compared by category, by store location, 2022 vs 2023, and by product.
  5. Impact sizing: Estimated the profit gain from shifting unit share back to Electronics, keeping total units the same and only changing the mix.
  6. Dashboard: Interactive Tableau Public dashboard with category and store location filters.
  7. Pitch: Leadership deck designed in Figma, with charts traced from Tableau, and presented to leadership.

#4.Metrics

  • 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

Toy retail margin dashboard

Rebuilt from the same data as the Tableau version.

Year

Store location

Category

Profit margin

27.8%

Profit

$4.01M

Revenue

$14.44M

Units sold

1,090,565

Units sold by category

Profit and margin

Share of units sold

Always 2022 vs 2023

Profit by category and store location

#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
CategoryUnits soldProfitMarginProfit per unit
Art & Crafts325,574$753,35427.8%$2.31
Toys267,200$1,079,52721.2%$4.04
Games194,673$673,99330.3%$3.46
Sports & Outdoors169,043$505,71823.3%$2.99
Electronics134,075$1,001,43744.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
CategoryDowntownCommercialResidentialAirport
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
Category2022 share2023 share
Art & Crafts22.3%37.5%
Toys25.7%23.3%
Games19.7%15.9%
Sports & Outdoors16.1%14.8%
Electronics16.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
ProductCategoryUnitsProfitMargin
ColorbudsElectronics104,368$834,94453.4%
Action FigureToys57,958$347,74837.5%
Lego BricksToys59,737$298,68512.5%
Deck Of CardsGames84,034$252,10242.9%
Glass MarblesGames37,518$187,59045.5%

Recommendations (from the final leadership deck)

  1. Grow Electronics' share. Bring Electronics back to 16% of units, its 2022 level, with more shelf space and stock priority.
  2. Stock by store location. Lead with Electronics in Commercial and Airport stores. Keep Toys front and center in Downtown and Residential.
  3. 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)