Lessons › Retail & Allocation › Store performance
Retail & Allocation lesson
% of target
Every store gets a sales target for the week. % of target shows how close it came.
Try this lesson free →The idea
Every store gets a sales target for the week. % of target shows how close it came:
Formulas
Sales ÷ Target × 100Key points
% of targetHow much of its sales target a store reached. 100% means it hit the number exactly.
Work it outDivide sales by the target, then multiply by 100.
Read itOver 100% beat the target. Under 100% missed it: 80% means 20% short.
% of target answers one question: did we do what we planned?
Practice
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 (no × 100).
=B2/C23. Tap a store that beat its target.
Over 100% means the store beat its number.4. Toronto sold $12,000, more than three other stores, but reached only 80% of target. What does that tell you?
Its target was $15,000, so it fell $3,000 shortLearn 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.
Try this lesson free →