Distributor Order Builder
Turns last week's sales numbers and your shelf and cooler counts into a clean order for each distributor, so you reorder what is selling and what is running low without guessing.
Before and after
Order for Monday, Snowhollow Beverage and Mart, 2653 Riverhollow Rd, Fawnfield
Stock target: 10 days (3 days to delivery plus 7 safety days)
Bellwether Distributing (rep: Curtis Dunn, 267-555-0150)
Out or nearly out, order first:
- Hazy Mule IPA 6pk: sold 36, on hand 0
No order needed:
- Old Quarry Lager cans
Order lines:
- Stonehollow Pale Ale cans: sold 96, so 96 / 7 = 13.7 per day. Times 10 days = 137. Plus 25 percent for the Saturday cookout display = 171.4, rounds to 172 cans. On hand 40. Need 172 - 40 = 132 cans. At 24 per case, 132 / 24 = 5.5, round up to 6 cases.
- Old Quarry Lager cans: sold 48, so 48 / 7 = 6.9 per day. Times 10 days = 69. On hand 70. Need is zero or less. No order needed (listed above).
- Hazy Mule IPA 6pk: sold 36, so 36 / 7 = 5.1 per day. Times 10 days = 51.4, rounds to 52 six-packs. On hand 0. Need 52. At 4 six-packs per case, 52 / 4 = 13. Order 13 cases.
Pat's Snack Supply
Order lines:
- Jalapeno pork rinds: sold 21, so 21 / 7 = 3 per day. Times 10 days = 30 bags. On hand 6. Need 24 bags. At 12 per box, 24 / 12 = 2. Order 2 boxes.
- Salt and vinegar chips: sold 35, so 35 / 7 = 5 per day. Times 10 days = 50 bags. On hand 30. Need 20 bags. At 20 per box, order 1 box.
Summary of the order:
- Bellwether: 6 cases Stonehollow Pale Ale cans, 13 cases Hazy Mule IPA 6pk
- Pat's Snack Supply: 2 boxes jalapeno pork rinds, 1 box salt and vinegar chips
What to tell Curtis Dunn at Bellwether: We need the Hazy Mule IPA 6pk first because we are at zero. We are adding 6 cases of Stonehollow Pale Ale to cover the Saturday cookout display Cristina Darby is setting up. We are skipping Old Quarry Lager this week because we have enough on hand.
Questions for the owner
- Do you want a cost total? Send the case and box prices and we will add them.
- Does Bellwether have a minimum order or a cutoff time for Monday delivery? We did not assume one.
- Please confirm any rules on alcohol ordering with your distributor or local authority. We did not state any.
What it does
Turns last week's sales numbers and your shelf and cooler counts into a clean order for each distributor, so you reorder what is selling and what is running low without guessing. It shows the math so you can check it.
Use it when: Use when a convenience or liquor store owner or manager needs to build a distributor order from last week's sales and what is low on the shelf, such as: build my order, what do I need to reorder, make the beer order, or write up the order for the rep.