Scribd
Upload
494 views3 pages

Recipe Cost Calculator

The document is a recipe cost calculator that calculates the costs of ingredients, overhead, waste, and profit to determine the menu price for a cheeseburger and fries for 4 servings. It lists the ingredients and their costs, then calculates a total cost of $16.91. It factors in a $5 overhead cost and $0.85 for waste to determine the total costs of $10.07. Adding a 5% profit margin sets the minimum menu price at $10.58, and it rounds up to a final menu price of $11.99.

Uploaded by

Anastasija Popovic
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
494 views3 pages

Recipe Cost Calculator

The document is a recipe cost calculator that calculates the costs of ingredients, overhead, waste, and profit to determine the menu price for a cheeseburger and fries for 4 servings. It lists the ingredients and their costs, then calculates a total cost of $16.91. It factors in a $5 overhead cost and $0.85 for waste to determine the total costs of $10.07. Adding a 5% profit margin sets the minimum menu price at $10.58, and it rounds up to a final menu price of $11.99.

Uploaded by

Anastasija Popovic
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Recipe Cost Calculator

Dish Name Cheese Burger and Fries

To use: Fill in the yellow boxes. The green boxes are the results.

Basic Costs Restaurant Menu Price


Number of Servings 4 Ingredients $4.23
Total Cost $16.91 Overhead $5.00
Cost Per Serving $4.23 Waste $0.85
Profit $1.91
Final Price $11.99

Ingredients
Name Quantity Units Cost Per Unit Total Cost
Ground Beef 2 Pounds $3.80 $7.60
Bun 4 Each $0.25 $1.00
Cheese Slice 0.5 Pounds $3.99 $2.00
Lettuce 0.5 Pounds $0.42 $0.21
Tomato 0.75 Pounds $2.00 $1.50
Mustard 4 Ounces $0.10 $0.40
Ketchup 12 Ounces $0.10 $1.20
French Fries 2 Pounds $1.50 $3.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Total Cost $16.91
Cost Per Serving $4.23

Restaurant Menu Cost

Food Cost
Cost Per Plate $4.23

Overhead Cost
You can either pick one method or enter both, and it will take the highest cost.
Total Monthly Overhead $10,000.00
Per Meal Method $5.00 Total Meals Served Per Month 2,000.00
OR
Total Food Costs $240,000.00
Ratio Method $2.11 Total Overhead Costs $120,000.00

Final Overhead Cost $5.00

Waste Cost
You can either pick one method or enter multiple, and it will take the highest cost.
Total Food Purchasing Cost $240,000.00
Total Cost Method $0.42 Total Cost of Wasted Food $24,000.00
OR

Times Sold/Times Dishes Sold 80


Made $0.47 Dishes Made 90
OR

Times Sold/Amount Dishes Sold 80


Bought $0.85 Dishes Bought Ingredients For 100

Final Waste Cost $0.85

Menu Price
Food Cost Per Plate $4.23
Final Overhead Cost $5.00
Final Waste Cost $0.85
Total Costs $10.07

Profit $0.50 Desired Profit Margin 5.00%


Minimum Menu Price $10.58 Manual Adjustment $1.41
Final Menu Price $11.99

Minus Costs $10.07


Net Profit $1.91
created by Sourcery (getsourcery.com)
INSTRUCTIONS: click File --> Make a Copy to save your own version.

Ingredients
Overhead
Waste
Profit

Ground Beef Bun


Cheese Slice Lettuce
Tomato Mustard
Ketchup French Fries

You might also like