adambrousell

Food Waste Tracker — Case Study
← Portfolio Projects Contact
CASE STUDY · FOOD WASTE · WEB APP

Food Waste Tracker

A mobile-first web application that lets kitchen staff log food waste in real time via QR code scan — no app install, no training, no friction. Every entry feeds a summary dashboard that turns waste data into purchasing and prep decisions.

HTML / CSS / JS Mobile-First QR Code Local Storage CSV Export TableStandards

Introduction

Food waste in restaurants is invisible until it isn’t. Most operators know waste exists but have no data on what’s being thrown out, when, why, or from which station. Without structured logging, waste reduction is just a slogan on the kitchen wall.

The problem isn’t awareness — it’s friction. Clipboards get lost. Binder sheets go unfilled. Apps require downloads and logins that kitchen staff won’t do mid-service. The solution has to be as fast as throwing something in the trash — because that’s what it’s competing with.

The Food Waste Tracker is a zero-install, mobile-first web tool built for TableStandards. A QR code posted near the kitchen waste station lets any team member log an entry in under 15 seconds from their phone. Entries are categorized by station, waste type, item, and quantity — then surfaced in a summary dashboard that identifies patterns by shift, day, and category.

Problems Identified

1. No Structured Waste Data Existed

The kitchen was throwing out food every shift but nobody was recording what, how much, or why. Without data, there was no way to distinguish between trim waste (expected) and spoilage or overproduction (actionable). Management was making purchasing decisions blind.

2. Previous Tracking Attempts Failed on Friction

Paper logs lasted about a week. A shared Google Sheet required Wi-Fi, a login, and typing on a tiny keyboard while holding a bus tub. Any solution that adds more than 15 seconds of friction to the disposal process won’t get used by line cooks during service.

3. Waste Patterns Were Invisible to Purchasing

The prep cook overproducing pasta on Mondays and the grill station burning proteins during the Friday rush were two completely different problems requiring two different fixes. But without station-level, type-level, daypart-level data, they were both just “food cost is high.”

Solution: The Food Waste Tracker

How It Works

📱
1

Scan

QR code posted at the waste station. Staff scan with their phone camera. No app install needed — opens directly in the browser.

✏️
2

Log

Tap station, tap waste type, type item name, enter quantity. Pre-populated buttons eliminate typing. 15 seconds or less.

📊
3

Review

History and summary tabs show entries by date. Filter by waste type. Patterns emerge: which station, which day, which items.

📤
4

Export

CSV export for deeper analysis in Excel or R. Feed waste data into purchasing models, menu engineering, and P&L tracking.

App Interface

Food Waste Tracker
Log Entry
History
Summary
QR Setup
Station
🍝 Pasta
🔥 Grill
🍽️ Middle
🥩 Salumi
🫕 Pasta Prep
🔪 Other Prep
Waste Type
Trim
Spoilage
Overproduction
Burnt
Item Name
Rigatoni bolognese
Quantity
2.5
Unit
lbs
Submit Waste Entry

Analysis: What the Data Revealed

After 4 weeks of active logging (280+ entries across 6 stations), the waste data surfaced three actionable patterns:

Waste by Type

Waste Type% of Total WasteActionabilityPrimary Fix
Trim38%Low (expected)Benchmark, don’t eliminate
Overproduction29%HighPrep par adjustments by day
Spoilage22%HighFIFO enforcement, order cadence
Burnt / Overcooked11%MediumStation training, equipment check

Waste by Station

StationEntriesTotal lbsTop Waste TypeFinding
🫕 Pasta Prep7248.5OverproductionMonday/Tuesday pasta prep exceeded demand by 40%
🔥 Grill5831.2BurntFriday 8–10 PM spike correlates with understaffing
🥩 Salumi4522.8SpoilageCharcuterie board components over-ordered by 25%
🍝 Pasta4118.3TrimWithin benchmark — no action needed
🍽️ Middle3815.6OverproductionSoup du jour consistently over-batched
🔪 Other Prep2612.1TrimWithin benchmark

The Monday Pasta Problem

The highest single-station waste source was pasta prep overproduction on Mondays and Tuesdays. The prep cook was batching to a Thursday/Friday par level every day of the week. The fix was a day-of-week prep par card posted at the station — cost: $0. Impact: 40% reduction in pasta prep waste within two weeks.

Results

280+
Entries Logged (First Month)
15 sec
Avg Time per Entry
40%
Pasta Prep Waste Reduction
$0
Cost to Deploy

Conclusion

Friction is the only thing that matters

The tracker works because it’s faster than not logging. QR scan, tap, tap, type, submit — 15 seconds. Any tool that asks a line cook to open an app, log in, navigate menus, or use a keyboard extensively will fail. The UX was designed around the constraint that staff are holding something they’re about to throw away.

Categorization creates actionability

Trim waste and overproduction waste require completely different responses. Trim is a benchmark to monitor. Overproduction is a prep par problem. Spoilage is a purchasing cadence problem. Burnt is a training or equipment problem. Without type-level categorization, all waste looks the same and nothing gets fixed.

The cheapest fix is often the best one

A day-of-week prep par card taped to the wall — generated from 4 weeks of waste data — eliminated the single largest source of food waste in the operation. No new equipment, no new software, no new training. Just data turned into a piece of paper posted at the right station.

Next Steps

The tracker is live and free to use

  • Try the Food Waste Tracker — scan the QR code or open the link on any phone
  • Part of the broader TableStandards 90-Day Pilot for restaurants
  • Waste data feeds into the labor optimization and product mix models for a complete operational picture
  • CSV export integrates directly with R Studio analysis pipeline and Power BI dashboards
  • Future: API integration with inventory management systems for automated purchase order adjustment