Turn past sales into next week's order, prep and staff plan
A restaurant group uses this kind of forecast to cut waste, schedule better and negotiate supplier prices.
A sketch of what you'll get back.
Your prompt
Fill in your details. Skip any you like.
ChatGPT and Claude open with your prompt already typed in. Gemini can't be filled in from a link, so its button copies your prompt: paste it into the new chat.
The prompt that gets copied
Attached is the sales export for the last [TIME PERIOD, e.g. 8 weeks] from [YOUR BUSINESS, e.g. a pizza restaurant]. It includes [FILE CONTENTS, e.g. sales by item, day and hour]. Coming up next week: [NEXT WEEK NOTES, e.g. school holiday, big game Friday] Current staffing: [CURRENT STAFFING, e.g. 2 cooks, 3 front staff per shift] Please: 1. Summarize the patterns: busiest days and hours, top 10 items and any trends 2. Forecast next week's sales by day, and explain how you got there 3. Turn that into an order list and a daily prep list for my top items, with quantities 4. Suggest staff numbers per shift, and flag shifts that look over- or under-staffed 5. List your assumptions so I can correct them Use simple tables. If the data has gaps or odd numbers, tell me before you forecast.
Upload your sales and item-mix export from your POS. You get a day-by-day forecast for next week, with what to order, how much to prep and how many staff you need on each shift.
Step by step
- Export the last 8 weeks of sales by item, day and hour from your POS.
- Attach the file and paste the prompt.
- Correct any assumption it got wrong and ask it to redo the plan.
- Use the order and prep lists, then compare them to what really sold.
What you'll get
A sales summary, a day-by-day forecast, order and prep lists and suggested staff numbers per shift.
Needs file upload. Remove customer names and card details from exports first.
- Made for
- Small business owners
- Works in
- ChatGPT, Claude, Gemini
