Sample result
Multi-Location Inventory Dashboard Builder for Restaurants
The owner asked this:«I have two locations. Norte bought beef loin last week and Centro let the loin it had expire. Each one counts its storeroom whenever it can.»
① The pairs per location, and the crossings that call for a transfer
The pairs come from EACH location's sales — copying the big location's fills one storeroom and empties the other.
| Item | Location | Stock | Minimum | Maximum | Status |
|---|---|---|---|---|---|
| Beef loin | Centro | 4 kg | 12 kg | 30 kg | 🔴 below minimum |
| Beef loin | Norte | 38 kg | 10 kg | 26 kg | 🟠 above maximum |
| Mozzarella | Centro | 18 kg | 8 kg | 24 kg | 🟢 in range |
| Mozzarella | Norte | 6 kg | 9 kg | 22 kg | 🔴 below minimum |
The network verdict: two crossings call for a transfer, not a purchase. Loin is over at Norte (12 kg above its maximum) and short at Centro — moving it costs the trip, buying it again costs the whole loin.
SUPUESTO: the safety stock level is taken from the lead time each supplier actually meets in THIS network today, not from a textbook figure. If the supplier took twice as long, the minimums rise and some crossings stop being transfers and go back to being purchases.
② Merma compared, location against location
The network average said «normal merma». The average was exactly what hid the location that is losing.
| Item | Merma Centro | Merma Norte | Gap in money/month | Cause | Practice that travels |
|---|---|---|---|---|---|
| Beef loin | low | twice Centro | $840,000 | Portions cut by eye on the night shift | Centro's cutting template, with its gramaje |
| Vegetables | low | three times Centro | $310,000 | Receiving with no pallet rotation | Centro's storeroom order, first in first out |
Storeroom merma and porcionamiento merma are counted separately: the first is fixed with order, the second with the receta estándar. An owner and a 30 días deadline for each practice that travels.
A note printed on the board itself: figures from different days are not compared, they are discarded. Tuesday stock against Friday stock talks the house into shortfalls that do not exist.
The full example has 1 more part(s): you see them inside the library, with your account.