The Foresio
Operator Toolkit.

Eight Excel templates built for independent restaurant operators. Recipe costing, inventory control, labor scheduling, menu engineering — the spreadsheets your operation should have been running on from day one. Free. No email required.

8 templates
Excel + Google Sheets compatible
No email required

A note from Adnan

"These templates are what every restaurant should be running on before they even think about software. We're releasing them free because the industry has a spreadsheet problem — not a technology problem. Fix the fundamentals first. Foresio handles the automation once the data is clean."

— Adnan Ezzi, CEO

Template 01 Recipe & Costing
Recipe Cost Calculator
Know your food cost before service, not after

Enter your ingredients, quantities, and supplier prices. The template calculates exact food cost per dish, gross margin percentage, and flags any item where your cost has pushed margin below your target. Update ingredient prices once a week and your entire menu reprices automatically.

Item
Qty
Unit Cost
Recipe Cost
Margin %
Truffle Risotto
1 plate
$4.20
$4.20
72%
Grilled Salmon
8 oz
$8.80
$11.20
22% ⚠
Lamb Chop
12 oz
$14.40
$14.40
28% ⚠
Short Rib
10 oz
$7.80
$7.80
65%
Ingredient price table Per-recipe cost breakdown Auto margin calculation Margin alert flags Supplier cost tracking
Template 02 Food Cost Tracking
Weekly Food Cost Report
Actual vs. theoretical, every Monday

Track what you actually spent on food each week versus what your recipe model predicted you'd spend. The gap — called "variance" — is your waste, theft, and portioning error combined. Most operators who run this for the first time discover they're losing 4–8% they didn't know about.

Week
Theoretical
Actual
Variance
Apr 28 – May 4
$4,820
$5,180
+$360 ↑7.5%
May 5 – May 11
$5,100
$5,240
+$140 ↑2.7%
May 12 – May 18
$4,640
$4,690
+$50 ↑1.1% ✓
Weekly actual cost entry Theoretical model Variance % auto-calc 12-week trend chart Category breakdowns
Template 03 Inventory Control
Inventory Par Sheet
What you have, what you need, what to order

A structured weekly count sheet pre-organized by storage zone — walk-in, dry goods, bar, freezer. For each item: current count, par level, and auto-calculated reorder quantity. Color-coded alerts when stock falls below par. Takes 15 minutes to fill in and prevents stockouts completely.

Item
On Hand
Par Level
Unit
Reorder?
Salmon, Atlantic
22 lbs
8 lbs
lb
HOLD ⚠
Chicken Thighs
3 lbs
12 lbs
lb
ORDER 9 lbs ↑
Arborio Rice
8 kg
5 kg
kg
OK
Truffle Oil
1 btl
3 btl
bottle
ORDER 2 ↑
Walk-in zone Dry storage zone Bar & beverage Freezer Auto reorder calc Color-coded alerts
Template 04 Labor Scheduling
Staff Schedule Builder
Build the week and see the labor cost before you publish

A 7-day scheduling grid where you enter shifts for each staff member and immediately see the projected labor cost, labor cost percentage of forecasted revenue, and total hours per employee. Catches overtime before it happens. Includes a vacation/availability tab for each employee.

Staff
Mon
Tue
Wed
Thu
Fri
Total $
Maria S.
5–10p
5–11p
5–10p
5–11p
$272
James K.
4–10p
4–10p
4–11p
$224
Total hrs
5h
6h
12h
5h
13h
$2,840
7-day grid Role-based wage input Overtime flags Labor % of revenue Availability tracker
Template 05 Menu Engineering
Menu Engineering Matrix
Star / Plowhorse / Puzzle / Dog — which items earn and which don't

Enter sales volume and food cost for every menu item. The template automatically classifies each item into the classic four-quadrant matrix — Stars (keep, push, feature), Plowhorses (reprice or redesign), Puzzles (market harder), Dogs (remove or overhaul). Includes specific action recommendations for each quadrant.

Item
Sales/wk
Food Cost%
Margin
Category
Truffle Risotto
84
28%
$19.80
⭐ STAR
Grilled Salmon
61
78%
$4.20
🐴 PLOWHORSE
Lamb Chop
12
72%
$7.20
🐕 DOG
4-quadrant matrix Auto-classification Action recommendations Visual chart output Category filtering
Template 06 Daily Operations
Daily Cash & Revenue Log
End-of-day numbers in 5 minutes

A structured end-of-day form for recording total revenue by channel (dine-in, takeout, delivery), cash drawer count, credit card total, voids and comps, and net revenue after fees. Spots discrepancies between your POS total and your actual drawer. Monthly summary auto-populates from daily entries.

Date
Gross Revenue
Net Revenue
Variance
Tue May 7
$4,820
$4,790
$30 ✓
Wed May 8
$5,140
$4,980
$160 ⚠
Thu May 9
$3,860
$3,848
$12 ✓
Revenue by channel Cash drawer reconciliation Void & comp tracking Monthly auto-summary Delivery fee deductions
Template 07 Procurement
Supplier Price Tracker
When your supplier raises prices, you'll know instantly

Log every invoice price for your key ingredients each week. The template tracks price trends over 12 weeks, flags items where the price has increased more than 5% in any rolling 4-week window, and compares your current supplier prices against publicly available USDA commodity benchmarks for common proteins, produce, and dairy.

Ingredient
Apr Wk 2
Apr Wk 4
May Wk 1
Trend
Salmon /lb
$7.80
$8.20
$8.80
+12.8% ⚠
Chicken /lb
$2.40
$2.40
$2.45
+2.1%
Butter /lb
$3.10
$3.40
$3.60
+16.1% ⚠
12-week price history Auto % change calc Spike alert flags Multi-supplier comparison USDA benchmark tab
Template 08 Staff Management
Shift Change & Incident Log
A paper trail that protects your operation

A structured daily log for recording callouts, late arrivals, early departures, cover arrangements, customer incidents, and equipment issues. Creates a timestamped record that makes patterns visible — which employees are chronically late, which shifts consistently have issues, what time of week your equipment flags problems. Essential for HR conversations and insurance.

Date
Staff / Issue
Notes
Resolved?
May 7
Maria S. callout
6pm shift. James covered. Notified 2hr prior.
✓ Covered
May 8
Dishwasher issue
Unit leaking at 7pm service. Contained. Tech called.
⏳ Pending
May 9
Carlos — 35min late
3rd late this month. Verbal conversation had.
✓ Logged
Callout log Late arrival tracking Cover arrangements Equipment incidents Customer incidents Monthly pattern summary

These templates are what
Foresio automates.

Every spreadsheet in this toolkit represents something Foresio's agents do automatically — tracking your food cost in real time, flagging margin drops the same day they happen, building your weekly schedule from demand data, monitoring supplier prices without manual entry.

Use the templates to understand your operation. Then let Foresio run it.

Start Free 30-Day Pilot → See All 20 Agents →
Recipe Cost Calculator
Template 01
→ Food Cost Alert + Menu Engineer
Inventory Par Sheet
Template 03
→ Inventory Watchdog
Staff Schedule Builder
Template 04
→ Schedule Optimizer
Menu Engineering Matrix
Template 05
→ Menu Engineer
Supplier Price Tracker
Template 07
→ Supplier Performance Tracker