Analytical report · 2026-10-11
February 2022 profit margin: a seasonal operations problem, not a product problem
TechWorld · 2,008 order lines, Q1 2022
The profit margin fell from 29.6% to 14.3% in February (-15.3pp) and recovered to 30.0% in March. The drop was broad-based across every category and region and went with the return rate rising from 3.5% to 27.9%; orders delivered in more than 7 days were returned 37.2% of the time vs 10.0%. The priority is a delivery plan for peak season, not a change in product mix.
SituationTechWorld sells consumer electronics online in 4 regions; January 2022 had 713 order lines at a profit margin of 29.6%.
ComplicationIn February 2022 the profit margin fell to 14.3% (-15.3pp).
QuestionWhich area drove the February margin drop, and what must be fixed before Q2 so it does not repeat?
29.6%
Profit margin 2022-01
14.3%
Profit margin 2022-02
-15.3pp
Change in Profit margin 2022-01→2022-02
-25.0%
% change in Revenue
+696.0%
% change in Return rate
Key arguments
- February is the break point of the quarter (-15.3pp) and March recovered to 30.0%: the problem is timing-related.
- No single area carries the drop: Electronics fell -14.5pp, the other categories -21.3pp; the four regions differ by 2.6pp; every channel fell.
- Returns rose evenly across the main categories (+22.0pp to +23.1pp); orders delivered in more than 7 days were returned 37.2% of the time vs 10.0%.
When
The profit margin fell from 29.6% to 14.3% in February, then recovered to 30.0% in March
Source: techworld_ecommerce_teaching_Q1_2022.csv (2,008 rows after filters); base period 2022-01, comparison period 2022-02. · Exhibit 04
Broad-based
Electronics accounts for 82.3% of the drop but did not fall the most: -14.5pp vs -21.3pp in the other categories
Source: techworld_ecommerce_teaching_Q1_2022.csv (2,008 rows after filters); base period 2022-01, comparison period 2022-02. · Exhibit 05
Broad-based
The four regions fell by almost the same amount, only 2.6pp apart
Source: techworld_ecommerce_teaching_Q1_2022.csv (2,008 rows after filters); base period 2022-01, comparison period 2022-02. · Exhibit 06
Broad-based
The margin fell in every traffic channel, most in Organic (-19.9pp) and least in Direct (-11.8pp)
Source: techworld_ecommerce_teaching_Q1_2022.csv (2,008 rows after filters); base period 2022-01, comparison period 2022-02. · Exhibit 07
Goes with returns
Return rates rose almost equally in the three main categories, from +22.0pp to +23.1pp; Wearables (small sample) rose +42.4pp
Source: techworld_ecommerce_teaching_Q1_2022.csv (2,008 rows after filters); base period 2022-01, comparison period 2022-02. · Exhibit 08
Goes with returns
Orders delivered in more than 7 days were returned 37.2% of the time, nearly four times the on-time rate (10.0%)
Source: techworld_ecommerce_teaching_Q1_2022.csv (2,008 rows after filters); base period 2022-01, comparison period 2022-02. · Exhibit 09
Hypothesis testing
4 hypotheses supported by the data, 2 rejected, 0 not testable with the current data
| ID | Hypothesis | ICE | Result | Evidence |
|---|---|---|---|---|
| H1 | The margin drop is concentrated in one product category. | 540 | Rejected | Category = Electronics: 28.6% → 14.0% (-14.5pp), 82.3% of the total change of -15.3pp; all other Category values -21.3pp. The large contribution comes from the size of Electronics, not from Electronics moving more than the rest: the change is broad-based. |
| H2 | February is the break point of the quarter and March recovers. | 490 | Supported | Profit margin by period: 2022-01 29.6%, 2022-02 14.3%, 2022-03 30.0%. Worst period: 2022-02 (-15.3pp). |
| H3 | Orders delivered in more than 7 days have a much higher return rate. | 432 | Supported | Return rate: delivered in > 7 days 37.2% vs delivered in ≤ 7 days 10.0% (gap +27.2pp). |
| H4 | The return rate rose in every category in February. | 300 | Supported | By Category (all rows): Accessories +23.1pp, Audio +22.8pp, Electronics +22.0pp. Spread across groups 1.1pp vs a typical change of 22.8pp → the change is uniform. |
| H5 | The margin fell evenly across all regions (not a local problem). | 250 | Supported | By Region (all rows): East -15.4pp, North -16.1pp, South -14.5pp, West -13.5pp. Spread across groups 2.6pp vs a typical change of 14.9pp → the change is uniform. |
| H6 | The margin fell evenly across all traffic channels (not one ad channel getting more expensive). | 200 | Rejected | By Traffic_Source (all rows): Direct -11.8pp, Email -14.6pp, Facebook Ads -16.3pp, Google Ads -14.5pp, Organic -19.9pp, Referral -14.9pp. Spread across groups 8.1pp vs a typical change of 14.8pp → groups differ clearly. |
Recommendations
Priority: prepare peak-season logistics and track returns weekly
| # | Action | Owner | Timeline | KPI | Type |
|---|---|---|---|---|---|
| 1 | Reserve delivery capacity for Lunar New Year 2023 and line up a backup carrier Shrink the group of orders with a 37.2% return rate | Head of Operations | Before December 2022 | Share of orders delivered in more than 7 days | Quick win |
| 2 | Track the return rate weekly and alert when it exceeds 10.0% (the on-time delivery level) | Head of Customer Service | Within 2 weeks | Weekly return rate | Quick win |
| 3 | Put a maximum 7-day delivery SLA and late-delivery penalties into carrier contracts Bring the return rate from 27.9% back toward January's 3.5% | Procurement Manager | Q2 2022 | Monthly return rate | Big project |
| 4 | Capture the carrier and the return reason for every order to isolate the cause of late deliveries | Data Lead | Within 1 month | Share of returned orders with a recorded reason | Big project |
Limitations
What the current data cannot answer
- There is no fixed-cost data, so Net_Profit is order-level profit.
- There is no carrier information, so the cause of late deliveries cannot be isolated.
- Only Q1 2022 is available; no same-period comparison with the previous year.
Next steps:
- Join carrier data to test the hidden-variable hypothesis (a partner that is both slow and damages goods).
- Compare with the previous year's Lunar New Year once the data is available.
Appendix
Method and source figures
Source: techworld_ecommerce_teaching_Q1_2022.csv (2,008 rows after filters); base period 2022-01, comparison period 2022-02. Issue tree structure: segmentation. ME: Each order line belongs to exactly one category, one region and one channel; revenue-weighted shift-share adds up exactly to the total margin Δ. CE: The total Δ equals the sum of every category's contribution; the operations branch (delivery, returns) is tested by group comparison; fixed costs are outside the data and recorded in boundaries.
Facts cited in this report (40)
| Fact id | Value | Description |
|---|---|---|
H1.Electronics.base | 28.6% | Profit margin, Category=Electronics, base period |
H1.Electronics.comp | 14.0% | Profit margin, Category=Electronics, comparison period |
H1.Electronics.delta | -14.5pp | Change in Profit margin, Category=Electronics |
H1.Electronics.share_of_delta | 82.3% | % of the total change from Electronics |
H1.mix_total | +0.1pp | Part of the change due to Category mix (mix effect) |
H1.rate_total | -15.4pp | Part of the change due to performance within each Category (rate effect) |
H1.rest.delta | -21.3pp | Change in Profit margin for all other Category values |
H1.top_vs_rest | 0.7x | How many times the change in Electronics exceeds that of the rest |
H1.total.base | 29.6% | Profit margin, base period (all rows) |
H1.total.comp | 14.3% | Profit margin, comparison period (all rows) |
H1.total.delta | -15.3pp | Change in Profit margin (all rows) |
H2.2022_02.delta | -15.3pp | Change in Profit margin, period 2022-02 vs previous period |
H2.2022_02.value | 14.3% | Profit margin, period 2022-02 |
H2.2022_03.delta | +15.7pp | Change in Profit margin, period 2022-03 vs previous period |
H3.false | 10.0% | Return rate, group delivered in ≤ 7 days |
H3.gap | +27.2pp | Gap: delivered in > 7 days vs delivered in ≤ 7 days |
H3.n_true | 384 | Rows in group delivered in > 7 days |
H3.true | 37.2% | Return rate, group delivered in > 7 days |
H4.Accessories.delta | +23.1pp | Change in Return rate, Category=Accessories |
H4.Audio.delta | +22.8pp | Change in Return rate, Category=Audio |
H4.Electronics.delta | +22.0pp | Change in Return rate, Category=Electronics |
H4.Wearables.delta | +42.4pp | Change in Return rate, Category=Wearables |
H4.spread | 1.1pp | Max−min spread of the change across Category |
H4.typical_change | 22.8pp | Typical size of the change (median |Δ|) across Category |
H5.East.delta | -15.4pp | Change in Profit margin, Region=East |
H5.North.delta | -16.1pp | Change in Profit margin, Region=North |
H5.South.delta | -14.5pp | Change in Profit margin, Region=South |
H5.West.delta | -13.5pp | Change in Profit margin, Region=West |
H5.spread | 2.6pp | Max−min spread of the change across Region |
H5.typical_change | 14.9pp | Typical size of the change (median |Δ|) across Region |
H6.Direct.delta | -11.8pp | Change in Profit margin, Traffic_Source=Direct |
H6.Email.delta | -14.6pp | Change in Profit margin, Traffic_Source=Email |
H6.Facebook_Ads.delta | -16.3pp | Change in Profit margin, Traffic_Source=Facebook Ads |
H6.Google_Ads.delta | -14.5pp | Change in Profit margin, Traffic_Source=Google Ads |
H6.Organic.delta | -19.9pp | Change in Profit margin, Traffic_Source=Organic |
H6.Referral.delta | -14.9pp | Change in Profit margin, Traffic_Source=Referral |
H6.spread | 8.1pp | Max−min spread of the change across Traffic_Source |
H6.typical_change | 14.8pp | Typical size of the change (median |Δ|) across Traffic_Source |
support.return_rate.base | 3.5% | Return rate 2022-01 |
support.return_rate.comp | 27.9% | Return rate 2022-02 |