Lessons › Retail & Allocation › Store performance
Retail & Allocation lesson
UPT
Units sold, shared across the receipts.
Try this lesson free →The idea
Units sold, shared across the receipts:
Formulas
Units ÷ TransactionsKey points
UPTUnits per transaction: how many items the typical basket holds.
Work it outDivide units sold by the number of transactions.
Read itA UPT of 2.5 means two or three items a sale. Add-ons and multi-buys push it up.
ATV is what the basket is worth. UPT is how full it is. Read them together.
Practice
1. What is Montreal's UPT?
1,800 ÷ 600 = 3 items per sale2. What is Toronto's UPT?
2,000 ÷ 800 = 2.5 items per sale3. In D3, work out Vancouver's UPT: units ÷ transactions.
=C3/B34. Montreal sells 3 items a sale, Toronto 2.5. Yet both have a $15 ATV. Why?
Montreal sells cheaper itemsLearn 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 →