Waste tracking dashboard & source tagging system

Purpose

Make food and portion waste visible, measurable, and actionable. Use a simple tagging system to capture each waste event, feed a lightweight spreadsheet or BI starter dashboard, and run a short weekly review cadence that turns observations into repeatable margin gains.

Key dashboard widgets (design guidance)

• Waste by source (stacked bar) — prep, spoilage, plate/guest-return, overproduction, theft/loss, other. Show count and cost for a rolling 4-week window.
• Waste by category / item — top 10 menu items by cost lost and by frequency.
• Cost per week — weekly total waste cost with trend line and week-over-week % change.
• Operator / shift trends — waste per shift and per operator to spot training or process issues (anonymize where appropriate until patterns are understood).
• Portion variance heatmap — items with high variance in portion size or ingredient usage (if collected via recipe/portion checks).
• Intervention impact — simple before/after comparison for specific countermeasures (e.g., changed par levels, new SOP) showing absolute cost saved and % reduction.

Minimum data model (spreadsheet starter)

Each waste event should capture a single row. Start simple, then enrich.

1. DateTime (timestamp)
2. Location / Station (e.g., Line 1, Prep, Cold Table)
3. Shift (AM/PM/Other)
4. Operator (initials or role)
5. SourceTag (one of: Prep, Plate, Spoilage, Overproduction, Theft/Loss, Other)
6. Item / Ingredient (name)
7. Quantity (units or weight)
8. Unit (each, lb, oz, portion)
9. UnitCost (currency per unit)
10. TotalCost (calculated = Quantity * UnitCost) — Excel example: =G2*I2
11. Explanation / Quick note (short free text)
12. TaggedBy (who tagged the event)
13. CorrectiveAction (optional) — immediate fix taken
14. FollowUpOwner (who will check next week)

Simple KPI definitions

• Weekly Waste Cost — sum(TotalCost) for the week.
• Waste Cost as % of Food Sales — Weekly Waste Cost / Weekly Food Sales.
• Top 3 Waste Sources — ranked by TotalCost over last 4 weeks.
• Events per 100 Covers — (count of waste events / covers) * 100 to normalize by volume.
• Intervention ROI — (Cost avoided this period due to the intervention) / (cost of intervention, e.g., time, packaging).

One‑page source‑tagging card (printable)

Weekly review agenda (15–30 minutes)

1. Quick numbers — show weekly waste cost, % of sales, top 3 items by cost (2 minutes).
2. Spotlight event — review one high-cost event with details, root cause hypothesis, immediate fix taken (5 minutes).
3. Trend check — are any sources rising? Is a particular shift or operator showing a pattern? (5 minutes).
4. Action list — agree 1–3 concrete experiments (e.g., adjust par, change prep step, new portion tool), assign owner and measure method (5 minutes).
5. Close — confirm who will update dashboard, next check-in, and any training notes (2 minutes).

Pilot plan (2 weeks)

Run a focused pilot for 2 weeks with a single station or shift:

• Train staff on the quick tagging card, keep cards within reach.
• Collect every waste event into the spreadsheet daily.
• Run the weekly review agenda and implement one small experiment in week two.
• At pilot end, calculate weekly waste cost change and per-event cost, then decide whether to scale changes.

Common pitfalls & how to avoid them

• Under-reporting: tagging feels like blame — emphasize rapid learning, anonymous aggregation at first, reward teams for reductions.
• Too many fields: start minimal. Add fields only when they provide clear insight.
• Unclear unit costs: maintain a simple master price list for common ingredients so taggers can record reasonable unit costs quickly.
• One-off fixes: always pair short fixes with a verification plan (who checks, when) so gains persist.

Where to add interactivity (capability opportunities)

The dashboard content is ready to benefit from simple interactive capabilities already on the platform:

• Replace the printable tag card with an interactive waste event form that staff can submit from a tablet or manager phone (collects the named fields above). This uses the platform's Interactive Form Rendering (CapabilityID 1) and stores entries with Content Data Submission (CapabilityID 2).
• Enable automated rollups and a starter BI view that reads the stored submissions and populates the dashboard widgets. Start with the provided spreadsheet template and move to a lightweight BI feed later.
• Treat the dashboard and tagging toolkit as a reusable domain or toolkit that sites can copy and tailor (CapabilityID 3) so multi-location groups can standardize measurement while allowing local customization.

Starter spreadsheet columns (copy/paste)

Date,Location,Shift,Operator,SourceTag,Item,Quantity,Unit,UnitCost,TotalCost,Note,TaggedBy,CorrectiveAction,FollowUpOwner

Example TotalCost formula (Excel/Sheets): =QuantityCell * UnitCostCell

Tip: Keep a separate 'Master Unit Cost' sheet and use VLOOKUP / INDEX-MATCH to populate UnitCost automatically for common items.

Next steps & sustainability

Start small, get value quickly, then expand. After 4–8 weeks, review whether the tagging process is steady and whether the dashboard shows repeatable improvement. If successful, create a short SOP that includes who tags, who uploads (if using paper cards), dashboard owner, and escalation rules for anomalies.