Monday morning report

Store and stock, side by side

About 5–10 minutes · no sign-up needed

Key points

Headline firstChain sales against target, in one line.

Then the whyWhich store, which driver.

Then the actionOne clear recommendation, backed by the numbers.

An analyst's job isn't the numbers. It's what the business should do because of them.

Try each one in your head first, then open the answer.

1. In J2, total the sales across all five stores. Each answer stays in the report as you go.

=SUM(B2:B6)

2. In J3, work out the chain's % of target, as a decimal.

=J2/SUM(C2:C6)

3. In J4, work out like-for-like growth, as a decimal: (sales − last year) ÷ last year.

=(J2-SUM(D2:D6))/SUM(D2:D6)

4. In J5, work out the chain's conversion: transactions ÷ footfall, as a decimal.

=SUM(F2:F6)/SUM(E2:E6)

5. In J6, work out the average transaction value (ATV).

=J2/SUM(F2:F6)

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

About 5–10 minutes · no sign-up needed