Supplier scorecard
The supplier scorecard answers three questions about each supplier: Do they send what you ordered? Do they come on the day they said? Do their prices hold? Rinvy calculates the answers from the orders and receipts that you already record. You do not enter anything extra.
The scorecard is on the Standard and Pro plans. Owners and managers can see it. Staff and viewers do not see it.
Where to find it
Go to Suppliers. Each supplier row has a strip with three chips: Fill, On-time and Price. Tap the strip to open the full scorecard.
All numbers use the last 90 days, by your kitchen's local calendar.
The three scores
| Score | What it measures | Green | Orange | Red |
|---|---|---|---|---|
| Fill rate | The share of the units that you ordered that the supplier delivered. | 95% or more | 85% or more | Less than 85% |
| On-time | The share of deliveries that came on or before the expected delivery date. | 90% or more | 70% or more | Less than 70% |
| Price stability | How many products changed price. A product changed if its case price moved more than 5% between two deliveries. Fewer products is better. | 10% or less | 34% or less | More than 34% |
Fill rate uses only orders that you placed in Rinvy and then received against a receipt. It compares only the products that were on the order.
On-time uses only deliveries that have both an expected date and a delivered date.
Price stability uses only products that you received two or more times in the 90 days.
How the numbers add up for one supplier
Say you placed three orders with Sysco in Rinvy and received each one against its order:
| Order | Expected | Delivered | Ordered | Received |
|---|---|---|---|---|
| 1 | Tuesday | Tuesday | 40 | 40 |
| 2 | Friday | Saturday | 60 | 54 |
| 3 | Tuesday | Monday | 100 | 100 |
- Fill rate is 194 received ÷ 200 ordered = 97%, which is green. Fill rate adds up units across all the orders, in each product's counting unit, so a short on a big order costs more than a short on a small one.
- On-time is 2 of 3 deliveries = 67%, which is red. Order 3 came a day early, and early counts as on time. Order 2 came 1 day late, so the scorecard shows an average of 1 day late.
- The strip also shows 1 of 3 short, because order 2 arrived 6 units short.
Now say you received 12 Sysco products two or more times. Mozzarella went from $48.00 to $51.00 a case, a 6.25% move, so it counts as moved. One other product moved too. Price stability is 2 of 12 = 17%, which is orange. The strip shows Price 2 moved, and the full scorecard shows 2/12 moved.
What the scorecard compares
- The delivered date is the Received on date of the receipt, not the day you typed it in. If the truck came Tuesday and you enter the receipt on Thursday, set Received on to Tuesday. Otherwise the delivery counts 2 days late.
- The expected date starts as the supplier's next delivery day, and you can change it on the order draft. If the rep moves the truck to a later day after you send the order, change the date with the calendar button on the order's row in the Pending tab of the Receive page. The scorecard then measures the delivery against the new date.
- A price move compares each delivery's case price with the delivery just before it. A price that rises 4% at each delivery never counts as a move, even after two rises take it more than 8% higher. To spot that slow climb, compare the Low and High columns under Price volatility by product.
- The Variation column is the coefficient of variation: the standard deviation of a product's case prices divided by their average, as defined in the NIST Dataplot reference. A product whose case price never changed shows 0.0%. The most variable products are listed first.
A price move is not always the supplier's choice. Wholesale food prices shift across the whole market, and the USDA Economic Research Service forecasts those changes every month in its Food Price Outlook. Before you blame one supplier, check whether your other suppliers raised the same product. The vendor price comparison report lines up the price of each product that has two or more purchase options.
What does a dash mean on the scorecard?
A dash (—) means that Rinvy has nothing to measure for that score yet. For example, you did not receive an order from that supplier in the last 90 days. A dash is not 0%. Rinvy shows it instead of a number that it does not have the data for.
To get a fill rate and an on-time score, place orders from the order list and receive them against the order.
The full scorecard
Tap a supplier's strip to open the scorecard. It shows:
- Fill rate, with how many deliveries were short.
- On-time, with the average number of days late.
- Price stability, with the number of active price alerts for this supplier.
- Spend (90 days), with this supplier's share of all your purchases. Credits reduce the spend.
- Price volatility by product: the lowest and highest price of each product, and how much it varied.
- Recent deliveries: the last 10 received orders, with the expected and delivered dates, ordered and received amounts, and a status such as On time, Late or Short.
- Marked out of stock on invoices: lines that an invoice marked as out of stock. These lines do not change the fill rate.
If you record shorts, credits and returns as their own line types, the fill rate and the spend are more accurate. See Receive a delivery manually.
Other places the scorecard shows
- When you send an order, the send screen shows one line for the supplier, for example "Sysco: 2 of 12 deliveries short · 83% on time". It shows after the supplier has 3 or more measured deliveries.
- In the vendor price comparison report, tap a supplier's name to open its scorecard.