Find what to reorder before the weekend
A ready reorder list from your stock sheet, with how much to buy.
- ForKirana, medical and hardware shops that run out of fast items on busy days.
- HelperStock Keeper
- ModeBerri Strawberry 1
- AttachExcel sheet
Copy the prompt
This is my stock sheet with columns for item, stock in hand and average daily sale. Tell me what will run out before [day] and how much I should order of each, keeping [number] days of extra stock.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in and the Stock Keeper helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Add a column for supplier name and ask Berri to group the order list by supplier.
- Ask for a reminder every Thursday at 5 pm to send the updated sheet.
Find what to reorder before the weekendStock Keeper
XLSstock.xlsx
This is my stock sheet with columns for item, stock in hand and average daily sale. Tell me what will run out before Sunday and how much I should order of each, keeping 3 days of extra stock.
Reading stock.xlsx
Four items will run out before Sunday:
| Item | In hand | Runs out | Order |
|---|---|---|---|
| Sugar 1 kg | 18 | Friday | 40 |
| Tea 250 g | 9 | Thursday | 24 |
| Salt 1 kg | 12 | Saturday | 20 |
| Soap bar | 20 | Saturday | 36 |
Order today and everything lasts till next Wednesday.
Figures here are made up to show the shape of the answer. Yours come from your own file and words.