BBampaa

Lessons › Retail & Allocation › Store performance

Retail & Allocation lesson

ASP

Units sold, against the sales they brought in.

Try this lesson free →
About 5–10 minutes · no sign-up needed

The idea

Units sold, against the sales they brought in:

Formulas

Sales ÷ Units

Key points

ASPAverage selling price: what the typical item sells for, after any discounts.
Work it outDivide sales by units sold.
How it connectsBasket value is price times items. Toronto: $6 × 2.5 items = $15.

Bigger baskets come from pricier items, more items, or both.

Practice

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

1. What is Halifax's average selling price?
$6,000 ÷ 800 = $7.50
2. In D6, work out Calgary's ASP: sales ÷ units.
=B6/C6
3. Tap the store with the lowest ASP: the cheapest items on average.
Montreal's ASP is $5, the lowest in the chain.
4. Toronto's ASP is $6 and its UPT is 2.5. What is its ATV?
$6 × 2.5 = $15

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.

Try this lesson free →
About 5–10 minutes · no sign-up needed