Good morning 👋 Welcome to Good Eatz
Restaurant & food business overview — May 2026
🍽️ Total Revenue
₱284,500
↑ 14.2% vs last month
📈 Net Profit
₱98,400
↑ 18.6% vs last month
💸 Food Cost
₱82,100
28.9% of revenue
🛵 Total Orders
1,284
↑ 9.3% vs last month
Daily Revenue vs Food Cost — May
Cost Breakdown
Food Cost 29%
Labor 25%
Overhead 18%
Packaging 8%
Best Sellers Today
| Dish | Orders | Revenue | Status |
|---|---|---|---|
| 🍝 Pasta Aglio e Olio | 87 | ₱13,050 | Best Seller |
| 🍗 Chicken Inasal Bowl | 73 | ₱10,950 | Top 2 |
| 🥩 Beef Caldereta | 61 | ₱12,200 | Popular |
| 🍜 Sinigang Ramen | 54 | ₱10,800 | Trending |
| 🥗 Pinoy Power Bowl | 48 | ₱7,200 | Regular |
KPI Progress — May
Monthly Sales Target94.8% — ₱284.5K/₱300K
Food Cost Target28.9% vs 30% cap ✓
Net Profit Target98.4% — ₱98.4K/₱100K
Orders Per Day Target85.6% — 43/50 daily avg
New Customer Signups72% — 72/100 target
⚠️ Low Stock Alerts
5 Items| Ingredient | Stock | Min Level | Status |
|---|---|---|---|
| Linguine Pasta | 2 kg | 10 kg | ⚠️ Reorder |
| Heavy Cream | 1.5 L | 8 L | ⚠️ Critical |
| Chicken Thighs | 4 kg | 10 kg | ⚠️ Reorder |
| Coconut Cream | 12 cans | 10 cans | ✅ OK |
| Beef Chuck | 3 kg | 8 kg | ⚡ Watch |
Recent Activity
GE
Invoice #GE-0042 sent to GrabFood — ₱18,500
15 min ago
⚠
Stock alert: Linguine pasta critically low — 2 kg remaining
1 hour ago
FP
FoodPanda payout received — ₱24,300 cleared
3 hours ago
SYS
Monthly report auto-generated for April 2026
Yesterday
📋 Task Board
Kitchen, operations, and business tasks
AllKitchenFinanceDeliveryMarketing
Backlog3
Develop June limited-edition summer menu
Set up GCash QR payment at dine-in
Create food photography for Instagram
To Do4
Order: Linguine pasta 20 kg — urgent restock
Follow up: GrabFood payout — ₱18,500
Post May promo on Facebook & Instagram
Renew health & sanitation permit
In Progress3
12-in-1 BizOS Google Sheets setup
Progress — 65%
Recipe costing sheet — all 22 menu items
Progress — 55%
Negotiate Grabfood exclusive promo for June
Progress — 80%
Review2
May expense report — kitchen + overhead
New packaging design — eco-friendly boxes
Done5
Hire 2 delivery riders for weekend shifts
April monthly P&L report finalized
Launch Sinigang Ramen new menu item
FoodPanda merchant setup complete
Supplier contract renewal — Wet Market
🛒 Sales Tracker
Orders and revenue — May 2026
₱284,500
Total Revenue
1,284
Total Orders
₱221.57
Avg Order Value
43
Daily Avg Orders
Daily Revenue — May
Revenue by Channel
| A — Date | B — Order # | C — Channel | D — Item/Bundle | E — Qty | F — Price | G — Discount | H — Net Total | I — Method | J — Status | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | May 29 | GE-1284 | GrabFood | Pasta Aglio + Drink | 3 | ₱150 | ₱30 | ₱420 | GCash | Delivered |
| 2 | May 29 | GE-1283 | Dine-In | Beef Caldereta Set | 2 | ₱200 | ₱0 | ₱400 | Cash | Done |
| 3 | May 29 | GE-1282 | FoodPanda | Chicken Inasal Bowl | 4 | ₱150 | ₱0 | ₱600 | Card | Delivered |
| 4 | May 28 | GE-1281 | Walkin | Sinigang Ramen x2 | 2 | ₱200 | ₱0 | ₱400 | Cash | Done |
| 5 | May 28 | GE-1280 | GrabFood | Pinoy Power Bowl | 1 | ₱150 | ₱15 | ₱135 | GCash | Delivered |
| 6 | May 27 | GE-1279 | Catering | Party Pack 10pax | 1 | ₱3,500 | ₱350 | ₱3,150 | Bank | Pending |
| 7 | May 27 | GE-1278 | FoodPanda | Pasta Aglio e Olio | 5 | ₱150 | ₱0 | ₱750 | Card | Delivered |
| 8 | May 26 | GE-1277 | Dine-In | Beef Caldereta + Rice | 6 | ₱200 | ₱0 | ₱1,200 | Cash | Done |
💸 Expense Tracker
Kitchen and operational costs — May 2026
₱186,100
Total Expenses
₱82,100
Food Cost
₱71,200
Labor Cost
₱32,800
Overhead
Expenses by Category
Monthly Expense Trend
| A — Date | B — Vendor / Person | C — Category | D — Description | E — Amount | F — Method | G — Receipt | |
|---|---|---|---|---|---|---|---|
| 1 | May 29 | Wet Market | Food Cost | Chicken, pork, beef — weekly | ₱18,500 | Cash | 📎 market_may29.jpg |
| 2 | May 28 | Metro Supermarket | Food Cost | Pasta, sauces, canned goods | ₱6,200 | Credit Card | 📎 metro_may28.pdf |
| 3 | May 27 | Staff Payroll | Labor | 3 kitchen staff — weekly | ₱16,800 | Bank Transfer | 📎 payroll_w4.pdf |
| 4 | May 25 | Meralco | Utilities | Electricity — kitchen + store | ₱8,400 | Bank | 📎 meralco_may.pdf |
| 5 | May 22 | EcoPack PH | Packaging | Takeout boxes, cups, bags | ₱4,800 | GCash | 📎 ecopack.pdf |
| 6 | May 20 | GrabFood | Platform Fee | Commission 25% — April | ₱9,200 | Deducted | 📎 grab_stmt.pdf |
| 7 | May 15 | Delivery Riders | Labor | 2 riders — weekly allowance | ₱5,600 | GCash | 📎 riders_may3.pdf |
| 8 | May 10 | LPG Supplier | Utilities | Gas tank refill x3 | ₱2,100 | Cash | 📎 lpg_may.jpg |
📈 Profit & Loss
Restaurant financial performance — Jan–May 2026
Gross Revenue
₱284,500
↑ 14.2% MoM
Total Expenses
₱186,100
65.4% of revenue
Gross Profit
₱202,400
Margin: 71.1%
Net Profit
₱98,400
Margin: 34.6%
Monthly P&L Trend
P&L Summary — May 2026
| Line Item | Amount | % Rev |
|---|---|---|
| Gross Revenue | ₱284,500 | 100% |
| Food Cost (COGS) | ₱82,100 | 28.9% |
| Gross Profit | ₱202,400 | 71.1% |
| Labor Cost | ₱71,200 | 25.0% |
| — Kitchen Staff | ₱56,000 | 19.7% |
| — Delivery Riders | ₱15,200 | 5.3% |
| Overhead | ₱32,800 | 11.5% |
| — Utilities (Elec+Gas) | ₱18,200 | 6.4% |
| — Packaging | ₱8,400 | 2.9% |
| — Platform Fees | ₱6,200 | 2.2% |
| Net Profit | ₱98,400 | 34.6% |
YTD Comparison vs 2025
💰 Cash Flow
Monthly cash position — 2026
₱38,200
Opening Balance
₱284,500
Cash Inflows
₱186,100
Cash Outflows
₱136,600
Ending Balance
Cash Flow — 2026
Monthly Breakdown
| Month | Opening | Inflows | Outflows | Closing |
|---|---|---|---|---|
| January | ₱15,000 | ₱198,000 | ₱158,400 | ₱54,600 |
| February | ₱54,600 | ₱218,500 | ₱162,000 | ₱111,100 |
| March | ₱111,100 | ₱238,000 | ₱170,000 | ₱179,100 |
| April | ₱179,100 | ₱249,000 | ₱178,000 | ₱250,100 |
| May (Current) | ₱38,200 | ₱284,500 | ₱186,100 | ₱136,600 |
🧾 Invoices
Delivery platform and catering invoices
₱128,400
Paid
₱18,500
Pending
₱6,300
Overdue
32
Total Invoices
Invoice List
| Invoice # | Client | Amount | Status |
|---|---|---|---|
| GE-INV-042 | GrabFood | ₱18,500 | Pending |
| GE-INV-041 | FoodPanda | ₱24,300 | Paid |
| GE-INV-040 | Catering – Corp | ₱6,300 | Overdue |
| GE-INV-039 | GrabFood | ₱21,200 | Paid |
| GE-INV-038 | FoodPanda | ₱19,800 | Paid |
| GE-INV-037 | Dine-In Daily | ₱38,600 | Paid |
Invoice Preview — GE-INV-042
🍽️ Good Eatz By Eleven
goodeatzbyeleven.com
INVOICE
#GE-INV-042
Bill To
GrabFood Philippines
Merchant Payout Statement
Period
May 22–29, 2026
Due Date
June 5, 2026
| Description | Orders | Rate | Total |
|---|---|---|---|
| GrabFood Delivery Orders | 124 | ₱175 avg | ₱21,700 |
| GrabFood Commission (25%) | — | 25% | -₱5,425 |
| Promo Subsidy Recovery | — | — | ₱2,225 |
| NET PAYOUT DUE | ₱18,500 | ||
📦 Inventory
Ingredients and supplies — reorder management
Total Ingredients
68
Active SKUs
Inventory Value
₱48,200
At cost
Low Stock
5
Needs reorder
Turnover Rate
8.4x
Monthly — good!
Stock by Category
Inventory Value Trend
| A — Ingredient | B — Category | C — Unit | D — Opening | E — Received | F — Used | G — Current | H — Reorder At | I — Unit Cost | J — Value | K — Alert | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Linguine Pasta | Dry Goods | kg | 15 | 0 | 13 | 2 | 10 | ₱85 | ₱170 | ⚠️ REORDER |
| 2 | Heavy Cream | Dairy | L | 8 | 0 | 6.5 | 1.5 | 8 | ₱220 | ₱330 | ⚠️ CRITICAL |
| 3 | Chicken Thighs | Protein | kg | 20 | 0 | 16 | 4 | 10 | ₱220 | ₱880 | ⚠️ REORDER |
| 4 | Beef Chuck | Protein | kg | 12 | 0 | 9 | 3 | 8 | ₱380 | ₱1,140 | ⚡ WATCH |
| 5 | Coconut Cream | Canned/Sauces | cans | 20 | 10 | 18 | 12 | 10 | ₱45 | ₱540 | ✅ OK |
| 6 | Jasmine Rice | Dry Goods | kg | 50 | 25 | 42 | 33 | 20 | ₱55 | ₱1,815 | ✅ OK |
| 7 | Garlic (peeled) | Produce | kg | 5 | 3 | 6 | 2 | 1 | ₱120 | ₱240 | ✅ OK |
| 8 | Sinigang Mix | Seasoning | packs | 30 | 20 | 28 | 22 | 15 | ₱18 | ₱396 | ✅ OK |
👥 Customer Database
Regular customers, delivery accounts, and loyalty tracking
2,841
Total Customers
72
New This Month
₱221
Avg Order Value
4.2x
Avg Repeat Orders
Revenue by Channel
Customer Retention
76%
30-Day Return Rate
| A — Name / Platform | B — Type | C — Phone / ID | D — Total Orders | E — Total Spend | F — Fave Item | G — Last Order | H — Status | |
|---|---|---|---|---|---|---|---|---|
| 1 | GrabFood Channel | Platform | Grab #GE-1829 | 487 | ₱85,225 | Pasta Aglio | May 29 | Active |
| 2 | FoodPanda Channel | Platform | FP #ME-2241 | 342 | ₱58,140 | Chicken Bowl | May 29 | Active |
| 3 | Maria Santos | Regular | +63-917-XXXX | 38 | ₱7,980 | Beef Caldereta | May 28 | VIP |
| 4 | ABC Corp (Catering) | Catering | accounts@abc.com | 12 | ₱52,400 | Party Pack | May 27 | Pending PO |
| 5 | Juan dela Cruz | Regular | +63-918-XXXX | 24 | ₱4,800 | Sinigang Ramen | May 26 | Active |
🎯 KPI Tracker
Restaurant performance metrics — May 2026
94.8%
Sales Target
₱284.5K / ₱300K goal
28.9%
Food Cost Ratio
Target ≤30% — ✅ Under
43
Daily Avg Orders
Target: 50/day
76%
Return Rate
30-day customer return
34.6%
Net Profit Margin
Industry avg: 30% — above ✓
4.7★
GrabFood Rating
Based on 284 reviews
KPI Radar Chart
Monthly Scorecard
| KPI | Target | Actual | Status |
|---|---|---|---|
| Monthly Revenue | ₱300K | ₱284.5K | 🟡 Near |
| Food Cost Ratio | ≤30% | 28.9% ✓ | 🟢 Good |
| Net Profit Margin | 30% | 34.6% | 🟢 Exceeded |
| Daily Orders | 50/day | 43/day | 🟡 85.6% |
| New Customers | 100 | 72 | 🔴 72% |
| Return Rate | 80% | 76% | 🟡 Near |
| GrabFood Rating | 4.5★ | 4.7★ ✓ | 🟢 Exceeded |
📊 Reports & Analytics
Business intelligence for Good Eatz By Eleven
YTD Revenue
₱1.27M
↑ 22% vs 2025
YTD Profit
₱436K
Margin: 34.3%
YTD Food Cost
₱368K
29.0% — on track
YTD Orders
5,840
↑ 18% vs 2025
YTD Revenue, Food Cost & Net Profit
Monthly Sales by Channel
Top Selling Items — May
| Dish | Orders | Revenue | Share |
|---|---|---|---|
| Pasta Aglio e Olio | 87/day | ₱13,050 | |
| Chicken Inasal Bowl | 73/day | ₱10,950 | |
| Beef Caldereta Set | 61/day | ₱12,200 | |
| Sinigang Ramen | 54/day | ₱10,800 |
Cost Breakdown — YTD
Monthly Food Cost % Trend
📅 Calendar
Operations calendar — June 2026
◀ June 2026 ▶
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Upcoming Events
!
Restock Urgent — Linguine pasta + Cream
Jun 1 · Do today
🛵
GrabFood Payout — ₱18,500 expected
Jun 2
📋
GrabFood Promo finalization meeting
Jun 3
💰
Payroll Processing — June week 1
Jun 5
🍽️
Recipe costing all 22 items — deadline
Jun 7
📄
Health Permit Renewal submission
Jun 10
⚡ Activity Feed
System events, team updates, and build checklist
Build Checklist
5 remaining✓
Create 12 Google Sheets tabs with all headers
✓
Set up data validation dropdowns
✓
Add SUMIF / COUNTIF formulas
✓
Google Forms for expense entry
✓
Protect formula cells
✓
Recipe costing formulas added
✓
Sample menu and sales data loaded
Apps Script: low-stock email alerts
Apps Script: daily sales summary email
Connect Looker Studio dashboard
Make.com: delivery platform sync
Monthly auto-report trigger
Full Activity Log
GE
Invoice #GE-INV-042 created for GrabFood payout ₱18,500
May 29 · 3:10 PM
FP
FoodPanda payout GE-INV-041 received — ₱24,300
May 29 · 11:00 AM
⚠
Stock alert: Linguine pasta — 2 kg (critical, reorder at 10 kg)
May 28 · 9:00 AM
CH
Chef Carlo added Sinigang Ramen recipe costing — 26% food cost
May 28 · 8:30 AM
💸
Expense submitted: Wet Market ₱18,500 — food cost category
May 28 · 7:45 AM
SYS
Auto-report: April 2026 monthly summary saved to Google Drive
May 27 · 12:00 AM
MA
Mae A. updated cash flow — April closing balance ₱250,100
May 26 · 4:00 PM
GE
New delivery rider added to team: 2 weekend shift riders onboarded
May 25 · 10:00 AM
🚀 Build Guide
System setup roadmap for Good Eatz BizOS
Automation Flow Diagram
Google Forms
Expense input
→
Google Sheets
Main database
→
Apps Script
Alerts + PDF
→
Gmail
Notifications
Sheets Data
Source
→
Looker Studio
Dashboard
→
Make.com
Integrations
→
GrabFood / FP
Delivery sync
Tech Stack Cost
| Tool | Use | Cost |
|---|---|---|
| Google Sheets | Database | FREE |
| Google Forms | Expense forms | FREE |
| Apps Script | Automation | FREE |
| Looker Studio | Dashboards | FREE |
| Google Drive | Files + Reports | FREE (15GB) |
| Make.com | Integrations | FREE (1K ops) |
| AppSheet | Mobile access | $5/user/mo |
4-Week Build Timeline
Week 1 — Foundation
12 sheet tabs · Headers · Ingredient list · Menu catalog · Data validation · Sample data
Week 2 — Formulas & Dashboard
Recipe costing formulas · SUMIF cross-references · Admin Dashboard KPI cards · Conditional stock alerts
Week 3 — Forms & Automation
Google Forms for expense + daily sales · Apps Script: low-stock alerts · Daily sales email summary
Week 4 — Dashboards & Integrations
Looker Studio connection · Make.com delivery platform sync · Monthly auto-reports · Final QA
🤖 AI Master Prompt
Copy and use in Claude, ChatGPT, or any AI builder
Good Eatz Master Prompt
ReadyBuild me a 12-in-1 Business Management System for a food restaurant business called "Good Eatz By Eleven" using Google Workspace.
BUSINESS TYPE: Filipino food restaurant / cloud kitchen with dine-in, GrabFood, FoodPanda, and catering channels.
STACK: Google Sheets (database) · Google Forms (input) · Apps Script (automation) · Looker Studio (dashboards) · Make.com free plan
MODULES TO BUILD:
1. Admin Dashboard — KPIs: daily revenue, food cost %, net profit, total orders, best sellers, low stock alerts, delivery platform performance
2. Sales Tracker — Date, Order #, Channel (Dine-in/Grab/FoodPanda/Catering), Dish, Qty, Price, Discount, Total, Payment Method, Status
3. Daily Sales Report — Total revenue, order count, avg order value, revenue by channel, top 5 dishes
4. Inventory System — Ingredient, Category, Unit, Opening, Received, Used, Current Stock, Reorder Level, Unit Cost, Total Value, Auto-alert
5. Menu & Recipe Costing — Dish name, Category, Selling Price, Food Cost, Cost %, Gross Margin, Menu Engineering classification
6. Expense Tracker — Date, Vendor, Category (Food Cost/Labor/Utilities/Packaging), Amount, Method, Receipt
7. P&L Tracker — Revenue, Food Cost (COGS), Gross Profit, Labor, Overhead, Net Profit, Margin %
8. Invoice Generator — For GrabFood/FoodPanda payouts and catering billings, auto PDF to Drive
9. Cash Flow — Daily and monthly cash position, inflows (sales), outflows (expenses, payroll)
10. KPI / Target Tracker — Sales target, food cost ratio target, daily orders target, customer return rate, platform ratings
11. Customer / Account Database — Walk-ins, regulars, delivery platforms, catering clients
12. Reports & Analytics — Menu performance (star/dog matrix), channel analysis, monthly comparisons
AUTOMATION:
- When ingredient hits reorder level → Gmail alert to kitchen manager
- End of each day → auto-send daily sales summary email
- When invoice is generated → save PDF to Google Drive + email to client
- Expense submitted via Google Form → auto-add to tracker + update P&L
- Monthly: auto-generate P&L report and save to Drive
KEY METRICS TO TRACK:
- Food Cost Ratio (target ≤30%)
- Net Profit Margin (target ≥30%)
- Daily orders (target 50/day)
- Revenue by delivery channel (GrabFood vs FoodPanda vs Dine-in vs Catering)
- Menu Engineering: Star (high popularity + high margin), Plowhouse, Puzzle, Dog
- Customer 30-day return rate
DESIGN: Color-coded (green=good, yellow=watch, red=alert), data validation dropdowns, protected formulas, sample data with Filipino food items included.