BBampaa

Lessons › Retail & Allocation › Store performance

Retail & Allocation lesson

ATV and UPT

Two basket measures: how much each sale is worth, and how many items are in it.

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

The idea

Two basket measures: how much each sale is worth, and how many items are in it.

Formulas

Sales ÷ Transactions
Units ÷ Transactions

Key points

ATVAverage transaction value: Sales ÷ Transactions.
UPTUnits per transaction: Units ÷ Transactions.
Grow the basketBundles, add-ons at the till, and good staff raise both.

ATV and UPT are the levers stores control on the shop floor.

Practice

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

1. What is Vancouver's ATV?
$15,000 ÷ 750 = $20
2. In D3, work out Vancouver's ATV: sales ÷ transactions.
=B3/C3
3. What is Montreal's UPT?
1,800 ÷ 600 = 3 items per sale
4. Tap the store with the smallest baskets by value.
Calgary's ATV is $12.50, the lowest in the chain.

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