Wooble
Build your proof

Wooble FastTrack · Level 2: Applied

Product profitability analysis project

Profitability by product, at Sootli HomeSimulation

Every product has a healthy gross margin, yet cash ran short. Find the ones that lose money once returns, shipping and ads are paid, and what sinks each.

  • You're the AI-enabled Data & Finance Analyst
  • About 75 minutes, no timer
  • 7 days to hand in
  • Checked the moment you hand in
  • Free
Join the track

Free. Level 2 opens once you pass 2 Level 1 problems. Start at Level 1.

The situation

Ishaan BhatiaFinance Lead, Sootli Home

Hi, and welcome to Sootli!

Here's the puzzle I've been handed. On paper, every product we sell has a gross margin of 55 to 65 percent, so the founders believe every product makes money. But September's cash went out faster than it came in, and they're about to approve a bigger ad budget across the whole catalogue.

Before they do, I want to know what each product really earns us once returns, shipping and its own ads are paid for. For September:

  • Our net revenue, and our gross margin.
  • Our total contribution: every product's, added up.
  • Which products lost money, and for each, the one cost that sank it.
  • How much those loss-makers cost us between them.

Please use our definitions in the handbook. Shipping is the fiddly part: the courier bills us by order, not by product.

Use any tools you like, AI included. Then write me a short note: what should we do about each loss-maker?

Thanks, Ishaan

When you start, you get Sootli Home's handbook and your own data: the same story as everyone else's, with different records, so your answers are yours alone.

What you hand in

  1. 1Net revenue: September's net revenue, every product, in rupees (in whole rupees)
  2. 2Gross margin: Net revenue less the cost of the goods delivered (in whole rupees)
  3. 3Total contribution: Every product's contribution, added up (in whole rupees)
  4. 4What the loss-makers cost: The contribution of the products that lost money, added up (a negative number) (in whole rupees)
  5. 5Loss-makers: A table with two columns, sku and reason, uploaded as a CSV or pasted.
  6. 6Your working: The spreadsheet, SQL or notebook that produces your answers, as a link anyone can open.
  7. 7A note to Ishaan: 200 words at most.
  8. 8How you used AI: Your prompts or the chat, if you used it.

Your figures and your loss-makers are checked against your own data the moment you hand in. The pass mark is 70 of 100, and the total contribution must be right. Hand in as often as you need; every hand-in is counted.

What passing earns

  • A step to your AI-enabled Data & Finance Analyst · Level 2 badge: 1 of the 2 passes it needs, and the next level opens with it.
  • A badge page that anyone can check, which you can add to LinkedIn as a certification.
  • A project on your Wooble profile made from your hand-in, when you choose to add it.
  • 50 points for the pass.
  • Finish every level for the track certificate: Wooble FastTrack Certified: AI-enabled Data & Finance Analyst.

Level 2 opens once you pass 2 Level 1 problems.

More in Level 2