Use Google Sheets AI to Track Food Waste and Labor Cost

What This Does

Google Sheets' AI formula assistant helps you build a running food waste and labor cost tracker without knowing how to write spreadsheet formulas — so you can catch problems mid-week instead of finding out on Friday.

Before You Start

• You have a Google account (free — any Gmail account works)
• You're at sheets.google.com or have Google Sheets open
• You have access to your daily sales figures and waste numbers from your POS or manager log

Steps

1. Create a New Spreadsheet

Go to sheets.google.com → click Blank spreadsheet. Title it "QSR Waste & Labor Tracker — [Your Location]."

2. Set Up Your Column Headers

In row 1, type these headers:

• A1: Date
• B1: Day's Total Sales
• C1: Total Food Waste ($)
• D1: Waste % of Sales
• E1: Labor Hours Worked
• F1: Labor Cost ($)
• G1: Labor % of Sales
• H1: Notes

3. Use the AI Formula Assistant

Click on cell D2 (where you want Waste % to appear). Look for the Help me write button at the top of the screen or the formula bar, OR open the Gemini sidebar from the menu: Extensions → Gemini in Sheets.

In the chat, type: "Write a formula for D2 that divides C2 by B2 and formats it as a percentage." Sheets AI will write the formula for you. Hit Enter to apply it.

Repeat for G2: "Write a formula for G2 that divides F2 by B2 as a percentage."

What you should see: Formulas appear in the cells automatically. You don't need to know any spreadsheet code.

4. Add Conditional Formatting to Flag Problems

Click on column D → Format → Conditional formatting. In the sidebar, use Custom formula is and ask the AI sidebar: "What formula highlights a cell red if the value is above 3%?" Apply that formatting so any day where waste exceeds 3% of sales turns red automatically.

Repeat for column G using a 30% labor threshold.

5. Extend Formulas Down

Once D2 and G2 have working formulas, click D2 → hold Shift → click D30 → press Ctrl+D (or Cmd+D on Mac) to copy the formula down to all 30 rows. Repeat for column G.

Now you have a tracker that auto-calculates percentages as you enter daily numbers.

6. Update It Daily in 3 Minutes

Each day, enter that day's total sales in column B, waste in column C, and labor numbers in columns E–F. The percentages and red flags calculate automatically. You don't need to look up formulas again.

Real Example

Scenario: It's Wednesday and you suspect food waste has been high this week, but you won't see it in the official report until Friday.

What you type into the daily tracker: B4: $4,800 (Tuesday's sales), C4: $190 (waste logged). Sheets auto-calculates D4 as 3.96% — and it turns red because it's above your 3% threshold.

What you get: An instant flag that Tuesday's waste was elevated. You investigate and find the fryer team has been over-portioning fries. You correct it Wednesday morning instead of reading about it in Friday's report.

Tips

• Keep the spreadsheet open on the manager tablet or pin it in your browser bookmarks so daily entry takes under 2 minutes
• Add a "Notes" column so you can log why a day was high (catering order, equipment issue, training a new cook)
• Share the sheet with your GM so they can see your tracking proactively — it builds trust

Tool interfaces change — if a button has moved, look for similar AI/formula/Gemini options in the Google Sheets sidebar.