Sample result
Multi-Location Purchasing Dashboard Builder for Restaurants
The owner asked this:«I have three locations and each administrator buys on their own. I suspect the same cheese comes in at two prices, but I have never put it in a table.»
① The comparator: the same item, location against location
Every price was brought to the same unit before being compared — comparing different presentations manufactures gaps that do not exist.
| Item | Centro | Norte | Sur | Gap % | Money per month |
|---|---|---|---|---|---|
| Mozzarella (kg) | $18,400 | $21,900 | $19,100 | 19% | $612,000 |
| Beef loin (kg) | $42,000 | $43,100 | $46,800 | 11% | $498,000 |
| Sunflower oil (l) | $9,200 | $9,400 | $9,300 | 2% | $36,000 |
The verdict: Norte buys expensive on 7 of the 12 key items. The network average said cheese was «in line» — and the average was exactly what hid the location paying 19% more.
SUPUESTO: the discount this volume should win is taken from what the house has already negotiated before, not from a textbook figure. If the real achievable discount were half, the saving over 12 meses halves and the negotiating table is still worth holding.
② Consolidated volume and the master catalogue
The volume that pools the three locations is what goes to the table — one negotiation, not three.
| Item | Network volume/month | Supplier | Proposed unified price | Saving over 12 meses |
|---|---|---|---|---|
| Mozzarella | 340 kg | Lácteos del Valle | $18,400 | $7,344,000 |
| Beef loin | 180 kg | Cárnicos Unidos | $42,000 | $5,976,000 |
Master catalogue, the row that prevents the fake saving:
| Item | Single specification | Location already meeting it |
|---|---|---|
| Mozzarella | 5 kg block, low moisture, for oven | Centro |
| Beef loin | Centre cut, aged 21 días, 180 g per portion | Sur |
A note printed on the board itself: the specification is set by the dish's escandallo, not by the invoice. Dropping the loin calibre to win on the purchase is paid back next month in merma from porcionamiento and in food cost.
The full example has 1 more part(s): you see them inside the library, with your account.