Food Cost % + Menu Engineering Tool

What This Tool Does

Most hotel and resort F&B teams face two problems:

• Food cost % looks high, but it’s unclear whether the issue is purchases, wastage, inventory control, or pricing.
• Your menu has “busy” items that sell a lot but make low profit, and high-margin items that don’t sell.

This tool solves both in one place:

Part A — Food Cost % (Period-based)

Measure COGS, Food Cost %, Gross Profit, and Gross Margin % using standard inventory accounting.

Part B — Menu Engineering (Item-level)

Classify each menu item as:

• STAR(popular + profitable)
• PLOWHORSE(popular, low profit)
• PUZZLE(profitable, low popularity)
• DOG(low popularity + low profit)

…and get a simple insight summary + table you can use in meetings.

How It Works (3 Steps)

Step 1 — Enter your period numbers (Food Cost %)

Add beginning inventory, purchases, ending inventory, and food sales for the period.

Step 2 — Add menu items (Menu Engineering)

Add your top-selling 5–20 items with selling price, item cost, and quantity sold.

Step 3 — Get instant insights + classifications

You’ll see food cost %, margin, COGS, and a classified menu table with action suggestions.

Inputs Section

A) Food Cost % (Period-based)

1) Beginning Inventory

What you enter: Value of food inventory at the start of the period.
Examples: Start of month/quarter.

2) Purchases During Period

What you enter: Total food purchases during the period.
Tip: Include only food purchases (separate beverages if you track them separately).

3) Ending Inventory

What you enter: Value of remaining food inventory at the end of the period.

4) Food Sales (Food Revenue)

What you enter: Total food revenue for the period.
Important: This is food revenue, not total restaurant revenue, unless that matches your reporting.

Outputs update live while you type.

B) Menu Engineering (Item-level)

Add each menu item as a row:

Per-item fields

• Item name — e.g., Chicken Biryani, Veg Pasta
• Selling price — what the guest pays
• Item cost — portion/recipe cost (ingredients + portion size cost)
• Qty sold — quantity sold in the period

Best practice: Add your top 5–20 items for the clearest decisions.

Results Section (What You Get)

Part A Results — Food Cost % Summary

1) COGS (Cost of Goods Sold)

Formula: Beginning Inventory + Purchases − Ending Inventory
Meaning: What you actually “consumed” in the period.

2) Food Cost %

Formula: (COGS ÷ Food Sales) × 100
Meaning: What % of food revenue went into food cost.

If food sales are 0, the tool avoids invalid calculations.

3) Gross Profit

Formula: Food Sales − COGS
Meaning: Your gross profit from food.

4) Gross Margin %

Formula: (Gross Profit ÷ Food Sales) × 100
Meaning: Your food margin efficiency for the period.

Part B Results — Menu Engineering Summary

5) Popularity Threshold

How it’s calculated:

• Average quantity sold across items × 0.70
  Meaning: Items selling at or above this threshold are considered “popular.”

6) Profit Threshold (Avg Contribution Margin)

How it’s calculated:

• Average CM across items
  Meaning: Items with CM above this are considered “profitable.”

7) Insights Counter (Stars / Plowhorses / Puzzles / Dogs)

You’ll see a quick summary like:

• STAR: 2
• PLOWHORSE: 1
• PUZZLE: 1
• DOG: 1

This is your at-a-glance menu health snapshot.

8) Item-by-item Engineering Table

For each item, the tool shows:

• Item
• Price
• Cost
• Qty
• CM (Contribution Margin)
• Class (STAR / PLOWHORSE / PUZZLE / DOG)

Plus an insight line such as:

• “Top profit contributor: Chicken Biryani (₹X total profit contribution)”
  (where profit contribution = CM × quantity sold)

What To Do With Each Category (Action Rules)

STAR (Popular + Profitable)

Do: Feature/promote, keep quality consistent, protect recipe and portion control.
Goal: Sell more without hurting guest experience.

PLOWHORSE (Popular, Low Profit)

Do: Raise price slightly, reduce cost, optimize portion size, re-engineer ingredients.
Goal: Keep sales volume while improving margin.

PUZZLE (High Profit, Low Popularity)

Do: Improve menu placement, rename/describe better, bundle, and train staff to recommend.
Goal: Increase visibility and conversion.

DOG (Low Profit, Low Popularity)

Do: Remove, redesign, reposition, or keep only if strategically required.
Goal: Stop wasting menu space and kitchen effort.

Why This Tool Helps Hotels & Resorts (Real Business Benefits)

1) You’ll reduce food cost % with clarity (not guesswork)

You’ll know if the issue is:

• inventory variance
• over-purchasing,
• wastage
• portion control
• or menu pricing.

2) You’ll optimize menu performance, not just costs

Most profitability comes from:

• fixing PLOWHORSES
• promoting PUZZLES
• protecting STARS
• removing DOGS

3) You’ll get a report-ready output for weekly/monthly reviews

Perfect for:

• owner reviews
• chef meetings
• finance reconciliation
• menu revision planning

FAQs

1) What period should I use for Food Cost %?
Monthly is the most common. Weekly is also possible if you track inventory regularly.

2) What should be included in the item cost?
Portion/recipe cost (ingredients based on actual yield and portion size). Keep it consistent across all items.

3) Can I include OTA/aggregator commissions in variable cost?
This tool is for food items; commissions are usually not relevant. But you can include packaging/delivery platform fees if the item is delivered.

4) How many items should I add for menu engineering?
Add 5–20 top items for the best insight. Too few items can distort thresholds.

5) Is this the only way to do menu engineering?
It’s a widely used simplified method that’s fast and actionable. It’s ideal for quick decisions.