Target and growth

Two questions start every Monday meeting: did we hit target, and are we up on last year?

About 5–10 minutes · no sign-up needed

The idea

Two questions start every Monday meeting: did we hit target, and are we up on last year?

Sales ÷ Target × 100

( Sales − LY ) ÷ LY × 100

% of targetSales ÷ Target × 100. Over 100% beats the number.

Like-for-like (LFL)This year against the same week last year, for the same stores.

Growth %(This year − Last year) ÷ Last year × 100.

% of target asks "did we do what we planned?" LFL asks "are we better than last year?"

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

1. What % of its target did Montreal hit?

$9,000 ÷ $10,000 × 100 = 90%

2. In D2, work out Toronto's % of target: sales ÷ target, as a decimal.

=B2/C2

3. What is Toronto's like-for-like growth?

($12,000 − $10,000) ÷ $10,000 × 100 = 20%

4. Tap the store that grew on last year but still missed its target.

Toronto is up 20% on last year, but only reached 80% of a stretching target.

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