July 28, 2013

1998: Clearing Merchandise

Five popular songs from 1998:
  • "Too Close" - Next
  • "The Boy Is Mine" - Brandy and Monica
  • "You're Still The One" - Shania Twain
  • "Truly Madly Deeply" - Savage Garden
  • "How Do I Live" - LeAnn Rimes
At Eddie Bauer in 1998, the popular theme was "clearance".

Business was awful.  Simply awful. Comparable customers were spending 10% to 20% less in 1998 than in 1997 ... that came on top of 10% drops in Fall/Holiday 1997.

I was the newly appointed Director of Catalog Circulation ... in 1998, before the internet took over, that was one of the five most important jobs in any catalog division.  I determined the catalog budget for the year (a budget of more than a hundred million dollars a year - and yes, there were plenty of cooks in the kitchen who would override my decisions, but you get the drift).  My team determined who would receive catalogs, who would receive discounts and promotions.  I got to decide (yes, again, many cooks in the kitchen) if we added or dropped catalogs from the annual contact strategy.  My team forecasted the sales of every catalog, every customer segment, every promotion, every merchandise category in each catalog.

Remember, I had no prior experience in this area.

Well, that's not true.  I worked on countless circulation projects at Lands' End, and was responsible for the models that determined who received catalogs.  But honestly, that was all support work ... no real accountability to speak of.

Now ... accountability.  There is an enormous gulf between most jobs, and jobs that have true accountability.  Always seek the latter.

So when the Inventory Executive stopped by my office on Day 2 and said "I need you to add a clearance catalog to the contact strategy, and I need you to mail enough customers and pages to clear about $10,000,000 of excess inventory, and I need you to not screw up the buying rhythm of our full price customer base", I got that cold, clammy feeling that can only be experienced when enjoying the reality of true accountability.

I started where any analytics expert would start.  "Do we have any cannibalization tests, A/B tests designed to measure what happens when we add a clearance catalog?"  Heck, we had dozens of these tests at Lands' End.

"No, we don't execute tests like that at Eddie Bauer, we don't want to lose demand."

Oh.

So we had to add a clearance catalog in Spring, sandwiched between two existing catalogs. My job is to make this work for all parties involved.

I had to craft a scenario that looked something like this:


We were never going to hit the original plan - business was off by 20%, and would continue to be off for another year.  So I had to show what the plan looked like when down 20% to plan (that's the middle column).  As you can see, profit dropped from $4.4 million to $3.5 million just because business stunk ... and we'd lose about $9,000,000 in demand ... hence the reason for having to clear $10,000,000 via a clearance catalog (with 20% off and free shipping and discounted prices ... a modern wonderland).

In the Clearance Scenario, I pulled 10% of the demand out of the February and March catalogs, because some customers would eschew those full-price mailings to instead shop in the Clearance catalog.  Then I forecast a whopping $10,000,000 in the Clearance catalog.

You run the profit and loss statement ... and then you get a sick feeling in your stomach.

See, you had no choice ... you had to clear the merchandise that wasn't going to sell, merchandise that was overbought.  You can't just let it sit there ... well, I suppose you could burn it, but then you're losing an incremental $5,000,000 instead of the $2,100,000 profit hit the clearance book would cause.

Here's a little hint, folks.  CFOs do not like situations where you add $3,000,000 in ad cost and you lower profitability by $2,100,000.  They really, really, really don't like those situations.  No amount of pithy advice from the experts on Twitter ("a social brand is a successful brand" ... "don't own your own product, avoid proprietary products") can help deal with having to clear $10,000,000 of merchandise in the next 1-2 months.

But that's the reality of a business in free fall.

And after having the Executive team yell at you about how rotten business is and how rotten your clearance plan is, you get busy trying to fix 1999 while burying the carcass of a 1998 that had just started.

That's my advice to you, dear e-commerce mavens operating in a modern world.  You have to do two things at once.  You have to deal with the reality of your current year, and at the same time, you have to make sure that next year is going to exceed expectations.  Online, the same things happen that happened in the old-school catalog world ... when you ramp up your clearance section, your full price section takes a hit.  Plan this accurately, get through the pain of clearing out the junk, and move on to planning the next year.

2 comments:

  1. In the modern world is there a whizzy piece of technology that might have helped...? I'm starting a data mining project with a BI business, that we hope will identify very particular customer behaviour - in this case I guess you'd want to find people that would buy from the clearance catalogue but not from the full price one - and vice versa - so send each group the relevant catalogue and hope to eek out the best of both worlds. Is that something a modern business should be able to achieve?

    ReplyDelete
  2. Yes, what you describe existed in 1998 and was used. When customers buy 2-3 times a year, they buy from clearance and they buy from full price, nullifying the magic of the clearance-based statistical model and the full price statistical models we used to select customers for mailings.

    We had a statistical model that predicted likelihood of buying and a separate statistical model that predicted amount spent ... two models for clearance ... two models for full price. We also had models for Mens, for Womens, for Casual, for Dressy merchandise, for Catalog, for Online, for Retail stores, and other models.

    ReplyDelete

Note: Only a member of this blog may post a comment.

Well, You Got Me Fired

I'd run what I now call a "Merchandise Dynamics" project for a brand. This brand was struggling, badly. When I looked at the d...