Excel · SheetsIngredient costs with yield, recipe lines, plate cost, food cost % and a suggested menu price for every dish.
What's included:
- Ingredient list with pack size, pack price and yield %
- Recipe lines that pull unit costs automatically
- Menu pricing: plate cost, food cost %, gross profit
- Suggested price rounded to your price step
- Over / on / under target flags
- Excel, Google Sheets and LibreOffice
Preview: what's inside
Settings Settings
| Setting | Value |
|---|---|
| Target food cost % | 30% |
| Round suggested prices up to | 0.25 |
| Flag items over target by more than | 3% |
Summary Menu summary
- Menu items priced
- Average food cost % (priced items)
- Items over target
- Items on target
- Average gross profit per plate
- Ingredients costed
Sheet Ingredients — Cost per unit already includes the yield loss.
| Ingredient | Category | Pack size | Pack unit | Pack price | Yield % | Cost per unit | Supplier |
|---|---|---|---|---|---|---|---|
| Chicken thigh, boneless | Protein | 5 | kg | 38.50 | 92% | auto | Example |
| Basmati rice | Dry goods | 10 | kg | 21.00 | 100% | auto | |
| Yellow onion | Produce | 10 | kg | 12.00 | 88% | auto |
Sheet Recipe lines — One row per ingredient per dish. Qty is in the ingredient's pack unit.
| Menu item | Ingredient | Qty used | Unit | Line cost |
|---|---|---|---|---|
| Chicken rice bowl | Chicken thigh, boneless | 0.16 | auto | auto |
| Chicken rice bowl | Basmati rice | 0.09 | auto | auto |
| Chicken rice bowl | Yellow onion | 0.04 | auto | auto |
Sheet Menu pricing — Plate cost is the sum of the dish's recipe lines divided by portions per batch.
| Menu item | Portions per batch | Menu price | Plate cost | Food cost % | Suggested price | Gross profit | Status |
|---|---|---|---|---|---|---|---|
| Chicken rice bowl | 1 | 12.50 | auto | auto | auto | auto | auto |
| Chicken flatbread | 1 | 9.75 | auto | auto | auto | auto | auto |
Preview generated from the actual file: sample rows are example data you replace with your own; formulas fill the calculated columns.
Good to know
- Instant digital download. Nothing physical is shipped.
- Licensed for personal and single-business use.
- 30-day fix-or-refund if a file doesn't work as described (terms).
- Support: eclipsekingdom.support@gmail.com