Work out your units per store per week, and how far it is from the buyer’s number.
Enter the units a sales report shows, the stores it counts, the weeks it covers and the number the buyer quoted. You get your units per store per week, and how many more units a week across those stores it would take to match the buyer.
Your report and the buyer’s number
Your item sells 2.5 units per store per week.
That is 83% of the buyer’s 3. Matching it takes 20 more units a week across these stores.
- Units a week, all stores
- 100
- The buyer’s number
- 3 per store per week
- Extra units a week to match it
- 20
The calculator treats every store and every week in the report alike. A store that got the item halfway through, or a week with a promotion in it, counts the same as any other. If the buyer counts stores differently from you, their number and yours are two different measures.
The arithmetic behind the number
Every figure comes from the four numbers you enter, in these steps:
- Units per week is the units in the report divided by the weeks it covers.
- Your units per store per week is units per week divided by the stores.
- Your share of the buyer’s number is your units per store per week divided by the buyer’s, times 100.
- Extra units a week to match the buyer is the buyer’s number minus yours, times the stores.
Do this for every item in the report.
Give Claude, Anthropic’s AI assistant, a distributor’s sales report and it works out units per store per week for every item and shows each step, so you can check it the way you checked this one.
Week 1 of the AI CPG Workshop shows you how to write your products, customers, pricing and trade terms down once, as documents Claude reads before every job, so it starts from your facts.
Live online, Tuesdays at 10 AM Pacific, one hour, recorded: November 10, 17 and 24 and December 1, 2026. Needs a paid Claude subscription.
Price, seats and the full schedule are on the workshop page.
Questions before you use it
What does it cost?
Nothing. It needs no account and no email address.
Does it keep my numbers?
No. The arithmetic runs in your browser, and the numbers you enter are not submitted, saved or sent to us.
Where do the figures come from?
Only from the four numbers you enter. The calculator holds no category average and no target velocity, so it cannot tell you what a good number is, only how yours compares with the one the buyer gave you.
Which stores should I count?
The ones the buyer counts, and the buyer can tell you which. Take 1,200 units over 12 weeks. Counting 40 stores gives 2.5 units per store per week. Counting only the 30 that sold some gives 3.3.
Where do I find the units, stores and weeks?
In the distributor’s or retailer’s sales report: units sold, a store count and the date range it covers.
What if the buyer quoted dollars, not units?
Divide the buyer’s dollars per store per week by the unit price those dollars are counted at, shelf or wholesale, then enter the result as the buyer’s number.