Score suppliers on delivery and price
See on-time, in-full and price changes by supplier, with valid claims separated from your own changes.
Operations · Wholesale and distribution · When you ask · Updated
Works with
- Slack
- Airtable
- Microsoft 365
Slack
Airtable
Microsoft 365How do you build a supplier scorecard?
To build a supplier scorecard, ask Maito in Slack with your order data. It calculates on-time and in-full delivery and price changes by supplier, and separates misses the supplier caused from changes your team made. You get one scorecard to use in the next supplier review.
How it's done today
Late deliveries and price rises are remembered by whoever was most annoyed.
What Maito does
- Match purchase orders to receipts
- Calculate on-time and in-full rates
- Separate changes you asked for
- Summarize price movement
Example
Loop run: None
@Maito score our top 5 suppliers for Jul to Sep.
Q3, 212 purchase orders. On time and in full: • Acme Packaging 96 percent, prices flat • Wonka Foods 91 percent, prices plus 3.4 percent • Stark Logistics 78 percent, prices flat • Vandelay Imports 71 percent, plus 7.9 percent • Soylent Labs 94 percent Catch: 9 of Vandelay's 14 late orders had their date changed by us after ordering, so I counted them as on time. Their real record is 86 percent, but the price rise is on every order since Aug 8. Source: ERP purchase orders and receiving dates. Attached: supplier-scorecard-q3.xlsx.
@Maito draft a short note to Vandelay about the price change. Only facts.
Draft is in your email: it lists the 4 invoices, old and new unit prices and asks them to confirm the change. It makes no claim about lateness. Nothing is sent.
Marco (3:03 PM):
score our top 5 suppliers for Jul to Sep.
Maito (3:12 PM):
Q3, 212 purchase orders. On time and in full:
• Acme Packaging 96 percent, prices flat
• Wonka Foods 91 percent, prices plus 3.4 percent
• Stark Logistics 78 percent, prices flat
• Vandelay Imports 71 percent, plus 7.9 percent
• Soylent Labs 94 percent
Catch: 9 of Vandelay's 14 late orders had their date changed by us after ordering, so I counted them as on time. Their real record is 86 percent, but the price rise is on every order since Aug 8.
Source: ERP purchase orders and receiving dates. Attached: supplier-scorecard-q3.xlsx.
Marco (3:20 PM):
draft a short note to Vandelay about the price change. Only facts.
Maito (3:22 PM):
Draft is in your email: it lists the 4 invoices, old and new unit prices and asks them to confirm the change. It makes no claim about lateness. Nothing is sent.
How to set it up
- Set up
Nothing to set up. Ask in Slack or by email whenever you need it.
- Connect spreadsheet
- Airtable
- Microsoft 365
- Use ERP
- NetSuite
No MCP server needed. Ask your agent to save a skill with the steps, then add the login or API key in Settings → Vault.
Not connected yet? Your agent sends you a link to sign in.
What it won't do
It can't judge quality or service that isn't in your data. Missing delivery dates will limit the score for that supplier.
Questions
Your spreadsheets in Airtable or Microsoft 365, and an ERP such as NetSuite through a skill with a login or API key in the Vault.
It marks those as your changes and leaves them out of the supplier's misses.
Yes. Ask for all suppliers, or one, for a period you choose.
