Skip to content
Workflow · Finance close · Opening soon

Recipe costing and menu price

Export your recipes, supplier prices, and menu from Excel, then upload the files. Mammoth matches ingredients to supplier prices, adds the menu price, and calculates food cost for each dish.

Early access opens shortly. Check back soon.

Someone typed

“cost each recipe from its ingredients at our current supplier prices, and compare plate cost with the menu price as a food cost percentage”

The agent read it as

Cost each recipe from its ingredients in Excel recipes at current supplier prices in Excel supplier prices, and compare plate cost with the menu price in Excel menu as a food cost percentage.

What the agent built

6 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Excel recipes
    CSV export · 40 rows
  2. File
    Excel supplier prices
    CSV export · 15 rows
  3. File
    Excel menu
    CSV export · 8 rows
  4. Step
    Make recipe matching keys
    Step 1
  5. Step
    Calculate supplier unit prices
    Step 2
  6. Step
    Make menu matching key
    Step 3
  7. Join
    Add supplier unit prices
    40 of 40 paired
  8. Join
    Add menu prices
    40 of 40 paired
  9. Step
    Calculate dish food costs
    Step 6
  10. Result
    Recipe Food Cost
    8 rows
  11. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 8 rows came out, and the join paired 40 of 40 rows; the join paired 40 of 40 rows.

What you get back

The result of that run, the rows to look at first.

Recipe Food CostSample data8 rows
DishPlate costFood cost percentageMenu price
Beef Burger2.4928.4%8.75
Chicken Caesar Wrap2.9031.4%9.25
Grilled Chicken Bowl3.2928.6%11.50
Salmon Pasta3.5928.7%12.50
Salmon Salad2.7536.6%7.50
Steak & Potatoes3.2031.2%10.25
Tomato Soup2.5335%7.25
Veggie Omelette1.3322.2%6
8 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Recipe Food Cost workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Recipe Food Cost: questions

How do you cost recipes and compare menu price?
Export your recipes, supplier prices, and menu from Excel, then upload the files. Mammoth matches ingredients to supplier prices, adds the menu price, and calculates food cost for each dish. You get a recipe food costs result you can review and adjust.
What export should you use from Excel?
Use the spreadsheet export that contains the rows and columns for your recipes, supplier prices, and menu. The file needs enough detail to match ingredients and items by name or code.
What happens to rows that do not match?
Rows that do not match a rule stay out of the matched result. You can review them, then fix the source file or change the matching words and run it again.
How do you change the rules?
You change the rules in words, by updating the matching terms and calculation steps. Then run the workflow again on the same exported files.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →