← L3VLUP Labs
Free · no sign-up

Structure the Problem

A strong answer to a business question starts before any arithmetic. The split you choose decides what you can explain: a good one leaves nothing out and counts nothing twice, and a poor one hides the answer in a gap or an overlap. Each case here asks you to build the tree, put numbers on its branches from a data pack, and say which sentence the numbers support.

Three cases, each marked out of 100: structure 40, numbers 40, conclusion 20. Retry as often as you like.

The question

Why did Harbour Foods revenue fall between the two years?

Harbour Foods sells packaged food through three channels. Revenue fell from one year to the next and the board wants to know where the loss came from before it decides what to fix.

The data pack

Units sold (thousand)
SegmentYear 1Year 2
Retail500450
Foodservice300240
Online100120
Total900810
Average price per unit (£)
SegmentYear 1Year 2
Retail10.0010.40
Foodservice8.008.50
Online15.0014.50
Revenue (£ thousand)
SegmentYear 1Year 2
Retail5,0004,680
Foodservice2,4002,040
Online1,5001,740
Total8,9008,460

Change in revenue: -440 (£ thousand)

Step 1. Build the tree

Choose the first split of the top question, then list the drivers under each branch. Every branch should be separate from its neighbours, together they should cover the question, and each should sit on the same level as the others.

First split