Coffee and Milk Reorder List From Weekly Usage

Takes the cafe's weekly usage and on-hand counts for coffee, milk, and related supplies and builds a reorder list for each supplier.

CafeFood and Drink✓ Checkedv1.0

Before and after

BEFORE · what the owner typed

Riverview Coffee House, 8638 Pineview St, Eaglehollow. I'm Iris Harrington, I do the ordering. Want 2 weeks of stock after delivery for everything. Beans come from Rushview Roasters, Ian Gamble is my rep, 336-555-0164, they deliver Thursdays. Milk and oat milk come from Rushview Dairy Supply, Isabel Hicks, 336-555-0165, delivery Tuesdays. House blend beans: used 14 bags this week (5 lb bags), have 6, 0 on order. Sold in cases of 4 bags, can only order full cases. Decaf beans: used 3 bags, have 4, 0 on order. Also cases of 4 bags. Whole milk: used 22 gallons, have 5, 0 on order. Ordered by the gallon, no case size. Oat milk: used 9 cartons, have 2, 12 on order arriving Tuesday. Cartons come 6 to a case. Half and half: used 4 quarts, have 8, 0 on order. Vanilla syrup: used 2 bottles, have 1, nothing on order. Skip syrup this week, I'm buying it elsewhere. Whole milk use-by on what I have is this Friday.

AFTER · what the skill produced

Reorder list for Riverview Coffee House
Target: 2 weeks of stock after delivery (weekly usage times 2). Items are grouped by supplier.

Rushview Roasters (Ian Gamble, 336-555-0164, delivers Thursdays)

House blend beans (5 lb bags, cases of 4) - Running low, order first
- Used this week: 14. On hand: 6. On order: 0.
- Target: 14 x 2 = 28. Need: 28 - 6 - 0 = 22 bags.
- Rounded up to full cases: 6 cases = 24 bags (22 divided by 4 is 5.5, so rounded up).
- Order: 6 cases (24 bags).
Decaf beans (5 lb bags, cases of 4)
- Used this week: 3. On hand: 4. On order: 0.
- Target: 3 x 2 = 6. Need: 6 - 4 - 0 = 2 bags.
- Rounded up to full cases: 1 case = 4 bags.
- Order: 1 case (4 bags).

Rushview Dairy Supply (Isabel Hicks, 336-555-0165, delivers Tuesdays)

Whole milk (gallons) - Running low, order first
- Used this week: 22. On hand: 5. On order: 0.
- Target: 22 x 2 = 44. Need: 44 - 5 - 0 = 39 gallons.
- Order: 39 gallons.
- Note: the milk on hand has a use-by date of this Friday.
Oat milk (cartons, 6 to a case) - Running low, order first
- Used this week: 9. On hand: 2. On order: 12 arriving Tuesday.
- Target: 9 x 2 = 18. Need: 18 - 2 - 12 = 4 cartons.
- Rounded up to full cases: 1 case = 6 cartons.
- Order: 1 case (6 cartons).
Half and half (quarts)
- Used this week: 4. On hand: 8. On order: 0.
- Target: 4 x 2 = 8. Need: 8 - 8 - 0 = 0.
- No order needed.

Skipped or no order needed

Half and half: no order needed, on hand already meets the 2 week target.
Vanilla syrup: skipped this week as you asked, since you are buying it elsewhere.

Questions for the owner

Whole milk had a big week at 22 gallons. Is that a normal week for you, or was it a one-off? If it was a one-off, we can lower the order.
Do you want the whole milk order placed with Isabel Hicks before Tuesday so it arrives on your delivery day?

What it does

Takes the cafe's weekly usage and on-hand counts for coffee, milk, and related supplies and builds a reorder list for each supplier. It shows how much was used, how much is left, and how much to order, using the owner's own targets.

Use it when: Use when a cafe owner or manager needs to turn weekly usage counts of coffee beans, milk, and related supplies into a reorder list for suppliers, such as: what do I need to order, make the coffee and milk order, or build this week's reorder from my counts.