Propose a reorder from a weekly count
Count the costly items, see par versus on-hand and on-order, and get an order to approve.
Operations · Restaurants · On a schedule · Updated
Works with
- Slack
- Airtable
- Microsoft 365
Slack
Airtable
Microsoft 365How do you propose a reorder from a weekly count?
To propose a reorder from a weekly count, set a Loop for count day. Maito posts the count sheet in Slack, compares counts with par levels, sales and open orders from your inventory system, and drafts the order with notes on unexplained variances. Nothing is ordered until you approve.
How it's done today
Staff count whatever they notice and the manager orders by gut feel.
What Maito does
- Ask for counts on the high-value items
- Compare counts with par and what's on order
- Note waste and variance against sales
- Draft the order for approval
Example
Loop run: Thursday 2:30 PM · High-value count
Counts are in for 18 items. Draft order to Stark Logistics: $1,284.60. • Salmon, 12 lb on hand, par 30, nothing on order: order 20 lb • Ribeye, 9 lb vs par 24: order 15 lb • Burrata, 14 on hand, par 20, 12 on order arriving Fri: no order • Olive oil, 2 cans, par 4: order 2 Variance: ribeye was 6 lb below what sales say we should have. Waste log shows 1.5 lb trimmed. About 4.5 lb is unexplained. Catch: burrata looks short, but the 12 on order land tomorrow. Ordering again would put 26 on hand, and the cheese lasts about 5 days. From the count sheet, POS sales and the inventory system. Send this order as is, Marco?
@Maito cut salmon to 15 lb, we have a slow weekend. Rest is fine.
Updated to $1,019.60, salmon 15 lb. Ready to send on your word, and I'll put the ribeye gap on next week's count.
Maito (3:40 PM):
Counts are in for 18 items. Draft order to Stark Logistics: $1,284.60.
• Salmon, 12 lb on hand, par 30, nothing on order: order 20 lb
• Ribeye, 9 lb vs par 24: order 15 lb
• Burrata, 14 on hand, par 20, 12 on order arriving Fri: no order
• Olive oil, 2 cans, par 4: order 2
Variance: ribeye was 6 lb below what sales say we should have. Waste log shows 1.5 lb trimmed. About 4.5 lb is unexplained.
Catch: burrata looks short, but the 12 on order land tomorrow. Ordering again would put 26 on hand, and the cheese lasts about 5 days.
From the count sheet, POS sales and the inventory system. Send this order as is, Marco?
Marco (3:52 PM):
cut salmon to 15 lb, we have a slow weekend. Rest is fine.
Maito (3:53 PM):
Updated to $1,019.60, salmon 15 lb. Ready to send on your word, and I'll put the ribeye gap on next week's count.
How to set it up
- Ask your agent
“Every Thursday at 2:30, post the high-value count sheet in #kitchen. When counts are in, compare them with par and on-order quantities from the inventory system and draft the order. I approve before anything is sent.”
- Connect point of sale
- Shopify
- Connect inventory system
- Airtable
- Shopify
- Connect spreadsheet
- Airtable
- Microsoft 365
Not connected yet? Your agent sends you a link to sign in.
What it won't do
It trusts the counts staff enter. It can flag a gap between counts and sales but can't tell where the missing stock went.
Questions
No. It drafts it and waits for your approval.
Yes. It subtracts quantities already on order and arriving, so it doesn't order twice.
Shopify for point of sale and inventory, plus Airtable or Microsoft 365 for the count sheet and par levels.
