Kitchen food wastage analysis for a restaurant, bakery or canteen
Reads a kitchen's waste log, sales and purchase records to find what is thrown away, at which stage, on which days and why, puts a rupee value on it, and returns prep, ordering and menu changes ranked by money saved. Use it for restaurants, cloud kitchens, bakeries, hostels and office canteens where food cost keeps creeping up.
The output this prompt produced, unedited.
The prompt
What to give
Kitchen type and covers or orders a day: [e.g. a North Indian cloud kitchen, about 220 orders a day]
Waste log: [paste rows: date, item, quantity, unit, stage (storage, prep, cooking, unsold, plate return), reason if noted]
Sales by item and day for the same period: [paste]
Purchase cost per unit of the main ingredients: [paste]
Current prep plan or par levels: [paste, or none]
Check each item
Value of waste by item and by stage, in rupees and as a share of purchases.
Day-of-week pattern: which days prep runs ahead of sales.
Items whose waste is mostly storage, pointing to over-ordering or poor rotation.
Items whose waste is mostly unsold, pointing to prep levels set too high.
Plate returns, pointing to portion size or a recipe problem.
Gaps in the log, such as days with no entries.
Output format
| Item | Stage | Quantity | Value | Share of item's purchases | Likely cause |
A day-of-week table for the top five wasted items.
Ten fixes ranked by money saved per month, each tagged ordering, storage, prep, portion or menu.
A suggested prep level for the top five items by day of week, based on sales.
A simpler waste log layout the staff can keep in under a minute a shift.
Guardrails
Never suggest serving food past its safe time to cut waste.
Mark any rupee figure as an estimate when the cost per unit is missing.
Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.
The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.