RECIPE COST CALCULATOR
© 2024 Spreadsheet123 LTD. All rights reserved
DATE 29-Jun-23 COST DISTRIBUTION
DISH NAME Tarte aux pomme
15%
0%
EST. SALE PPRICE OMR0.20
TOTAL COST OMR2.37
COST MARGIN % 1184.00
85%
NET PROFIT $ -2.17
PRIMARY INGREDIENTS
Product Name Qty. Cost Total Cost
(per unit)
Butter 2 OMR1.00 OMR2.01
sugar 1
eggs Insert a Photo of the Dish
flour
TOTAL $ 2.01
SECONDARY INGREDIENTS
Qty Cost
Product Name Total Cost
Gm Kg/Lt
CHILLI SAUCE 1 OMR8.000 OMR0.008
Tartar Sauce 0 OMR0.000 OMR0.000 PREPARATION
Green Beans 1.5 OMR0.000 OMR0.000
TOTAL OMR0.008
UTILITY AND PREP. COST
Name Total Cost
Preparation OMR0.03
Gas OMR0.12
Electricity OMR0.11
Water OMR0.10
TOTAL OMR0.36
ALLERGIES
Inventory Templates by Spreadsheet123 © 2013 Spreadsheet123 LTD. All rights reserved
Prepared By Approved By
Occupation Occupation
Inventory Templates by Spreadsheet123 © 2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
© 2024 Spreadsheet123 LTD. All rights reserved
DATE 6-Jun-16 COST DISTRIBUTION
DISH NAME tarte aux pommes
15%
0%
EST. SALE PPRICE OMR0.20
TOTAL COST OMR2.37
COST MARGIN % 1184.00
85%
NET PROFIT $ -2.17
PRIMARY INGREDIENTS
Product Name Qty. Cost Total Cost
(per unit)
Butter 2 OMR1.00 OMR2.01
sugar 1
eggs Insert a Photo of the Dish
flour
TOTAL $ 2.01
SECONDARY INGREDIENTS
Qty Cost
Product Name Total Cost
Gm Kg/Lt
CHILLI SAUCE 1 OMR8.000 OMR0.008
Tartar Sauce 0 OMR0.000 OMR0.000 PREPARATION
Green Beans 1.5 OMR0.000 OMR0.000
TOTAL OMR0.008
UTILITY AND PREP. COST
Name Total Cost
Preparation OMR0.03
Gas OMR0.12
Electricity OMR0.11
Water OMR0.10
TOTAL OMR0.36
ALLERGIES
Inventory Templates by Spreadsheet123 © 2013 Spreadsheet123 LTD. All rights reserved
Prepared By Approved By
Occupation Occupation
Inventory Templates by Spreadsheet123 © 2013 Spreadsheet123 LTD. All rights reserved
Help
Primary Products
1. In the cell "Name" enter the name of the primary product of the dish (Steak, Cod Fish, Pie etc.)
2. In the cell "Quantity" enter the number of units for a single dish (one piece of Steak or two slices of fish)
3. In the cell "Price" enter the price of your primary product per single unit of measure (1 steak - $2.00)
4. The cell "Total Price" calculates cost of a single unit multiplied by number of units in one portion.
Secondary Products
1. In the cell "Name" enter the name of the secondary product for your recipe (pasta, chips, new potatoes etc.)
2. In the cell "Quantity" enter the quantity of the secondary product needed for preparation in Grams (100 Gm, 200 Gm)
3. In the cell "Price" enter the price of secondary product per 1 Kilo or Liter ($10.00 per Kg or Lt)
4. The cell "Total Price" calculates cost of secondary product by multiplying cost of product per amount of weight,
used in your recipe.
Total Cost
Cell "Total Cost" calculates total of Primary and Secondary Products
Selling Price
In the cell "Selling Price" put the price of the dish as per your menu or the price that this dish will
sell for.
Food Margin
Cell "Food Margin" calculates proportion between cost of the dish and generated revenue.
(30% of the costs involved in preparation of the dish should generate 70% of profit)
Generated Revenue
Cell "Net Profit" calculates potential Net Profit, which your recipe can generate.
h, Pie etc.)
or two slices of fish)
1 steak - $2.00)
one portion.
hips, new potatoes etc.)
tion in Grams (100 Gm, 200 Gm)
Kg or Lt)
duct per amount of weight,
s dish will
nue.
Terms of Use - EULA
© 2024 Spreadsheet123 LTD. All rights reserved
IMPORTANT—READ CAREFULLY:
This End-User License Agreement (”EULA”) is a legal agreement between you and Spreadsheet123.com that
covers all Microsoft Excel and OpenOffice.org templates or spreadsheets (”TEMPLATES”) and software ("SOFTWARE") made
by Spreadsheet123.com.
By downloading, copying, accessing or otherwise using any TEMPLATES or/and SOFTWARE, you agree to be bound by the
terms of this EULA.
TEMPLATES LICENSE
This TEMPLATE is protected by copyright laws and international copyright treaties, as well as other intellectual
property laws and treaties. Each TEMPLATE is licensed, not sold.
1. GRANT OF LICENSE.
This EULA grants you the right to download this TEMPLATE free of charge for personal use or use within your company
or organization.
You may customize this TEMPLATE with you personal information and use for its intended purpose in personal calculations
documentation or/and communications, but you may not remove or alter any logo, trademark, copyright, hyperlinks,
disclaimers, terms of use or other proprietary notices within this TEMPLATE.
You may not sell, resell, license, rent, lease, lend or otherwise transfer for value without written
permission of SPREADSHEET123.COM
You may not distribute this TEMPLATE in any stand-alone products that contain only the TEMPLATE, or as part of any other
product. You may not copy or post any TEMPLATE on any network computer or broadcast it in any media without
written permission of SPREADSHEET123.COM.
2. RESERVATION OF RIGHTS.
All title and copyrights in and to the Template, and any copies of the Template, are owned by Spreadsheet123.com.
All rights not expressly granted are reserved by Spreadsheet123.com. In particular, this EULA does not grant you any
rights in connection with any trademarks or service marks of Spreadsheet123.com. Use of any Template for any purpose
other than expressly permitted in this EULA is prohibited, and may result in severe civil and criminal penalties.
3. TERMINATION.
Without prejudice to any other rights, Spreadsheet123.com may terminate this EULA if you fail to comply with the
terms and conditions of this EULA. In such event, you must destroy all copies of any TEMPLATE.
4. NOTICE SPECIFIC TO TEMPLATES.
SPREADSHEET123.COM MAKE NO REPRESENTATIONS
ABOUT THE SUITABILITY OF THE TEMPLATES FOR ANY PURPOSE. ALL TEMPLATES ARE PROVIDED
“AS IS” WITHOUT WARRANTY OF ANY KIND. SPREADSHEET123.COM HEREBY DISCLAIM ALL
WARRANTIES AND CONDITIONS WITH REGARD TO THE TEMPLATES, INCLUDING ALL IMPLIED
WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE
AND NON-INFRINGEMENT. IN NO EVENT SHALL SPREADSHEET123.COM BE LIABLE FOR ANY SPECIAL,
INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS
OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS
ANY REFERENCES TO EVENTS, PEOPLE, PLACES, OR ENTITIES IN THE TEMPLATES IS PURELY FICTITIOUS AND NOT INTENDED TO REPRESENT ANY ACTUAL EVENT,
PERSON, PLACE, OR ENTITY. SPREADSHEET123.COM DISCLAIMS ANY LIKENESS OR SIMILARITIES TO ACTUAL EVENTS, PEOPLE, PLACES, OR ENTITIES, AND
ANY SUCH LIKENESS OR SIMILARITIES ARE UNINTENTIONAL AND PURELY COINCIDENTAL.
5. MISCELLANEOUS.
Some states do not allow the limitation or exclusion of liability for incidental or consequential
damages, so the above limitation may not apply to you.
