Find repeat patterns in a shop’s waste log
Compare prep, sales and discarded stock before changing how much the team makes.
What you’ll produce
A waste-review table with unit checks, recurring patterns and a small proposed prep experiment.
Inputs & connections
- Dated prep, sales and waste records with item identifiers and units
- Recipe yields, stock adjustments, opening hours and known events affecting demand
Use spreadsheet exports for the first review. POS and stock-system connections require separate setup; this workflow does not change ordering automatically.
Your starting prompt
Replace the bracketed fields. This is our suggested prompt, not a quote from the source.
Review [prep, sales and waste logs] for [period]. Normalize units only where a conversion is supplied, retaining original values. Reconcile opening stock, production, sales, adjustments and closing stock where the records allow it. Separate recorded waste from unexplained differences. Compare like weekdays and note events, closures or stockouts. Identify repeated excess preparation and propose one bounded change to test, including service-level and waste measures. Do not infer food safety from the logs, recommend reusing unsafe items or change purchase orders. Return calculations, source rows and missing-data questions.
How to run it
- 01
Choose a small set of high-waste items and define the units for each.
- 02
Reconcile prep, sales, stock adjustments and discarded quantities.
- 03
Review recurring patterns while separating event days and stockouts.
- 04
Have the manager approve a limited prep change and retain existing food-handling rules.
- 05
Compare waste and availability during the trial before changing the standard quantities.
Review before you act
Check unit conversions, recipe yields, staff meals, transfers and whether a stockout suppressed recorded sales.
Limitations & success checks
- Missing waste entries can make unexplained losses look like ordinary demand.
- Historical averages alone do not predict a special event or establish safe food handling.
Measure: Recorded waste per item, unexplained inventory differences and stockouts during the trial.
Sources & attribution
The sources below support the reported example or a tool capability. They do not validate our prompt or prove the outcome in your environment.
Source post and author checked through X public oEmbed on October 17, 2026. The supplied coffee-shop report includes waste tracking alongside other ChatGPT Work tasks. This guide separates the waste review into its own proposed pilot and makes no time-saving claim. The prompt, setup and checks are original editorial additions. The directory has not reproduced the reported deployment or results.
Creator / publisher: @tuanle6618
Editorial review: 2026-10-17. How we label evidence.