How is the cost calculated?

Materials from the recipe plus labor (minutes × rate) plus overheads as a percentage; per unit, it is divided by the batch yield.

How do I set the price?

By markup (general or specific to the product) or manually; tax on revenue is accounted for separately.

What if raw material prices go up?

Change the price on the «Materials» sheet — the cost and price of all products are recalculated.

Is it suitable for services?

Yes: enter consumables as materials and the main cost through working time.

← All templates

Cost Calculation — Excel Template for Product Costing

The cost of a product or dish from its recipe and working time, overheads, tax, selling price, profit and margin.

490 ₽

≈ 5 USD

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

To set a price you need to know the cost. The spreadsheet calculates it from the recipe: materials, labor and overheads. Then comes the price with markup, tax, profit and margin, and the product card prints on a single sheet.

What is inside

«Settings»: labor rate, overheads, default markup and tax.
«Materials»: prices of raw materials — change a price and all products are recalculated.
«Recipe»: what a product consists of and how much goes into a batch.
«Products»: batch and unit cost, selling price, profit and margin.
«Card» and «Summary»: a printable card and a comparison of products.

Who it is for

Bakers and pastry chefs, craftspeople and furniture makers, tailors, small cafés, producers, and anyone who sells products and wants to know what is left as profit.

What you get

The package includes a blank spreadsheet and a filled-in sample with fictional data, so you can see how the formulas and checks work. It is a spreadsheet built on ordinary formulas, not an accounting program. All fixes and new versions of the project are free.

Compatibility

Excel 2007 and later, LibreOffice. No macros. Rates, thresholds and reference values are kept in settings: check them against the rules that apply to you before use. Calculations are approximate. The file is in English.

Questions and answers

How is the cost calculated?: Materials from the recipe plus labor (minutes × rate) plus overheads as a percentage; per unit, it is divided by the batch yield.
How do I set the price?: By markup (general or specific to the product) or manually; tax on revenue is accounted for separately.
What if raw material prices go up?: Change the price on the «Materials» sheet — the cost and price of all products are recalculated.
Is it suitable for services?: Yes: enter consumables as materials and the main cost through working time.