Baking Ingredient Costs

When is this template useful?

When several products use the same butter, a change in its purchase price affects their ingredient costs. This template uses one shared cost per gram, then calculates batch and per-serving costs for cookies, pound cakes, and scones.

In Calvance, replace the pack price, net weight, butter quantities, other ingredient costs, and saleable quantities with your own figures. Next time the price changes, edit the shared butter price to update all three products.

Which numbers do you enter?

The example uses US dollars (USD) for money and grams for weight. These are illustrative figures, not market prices or a tested recipe. You can use another currency by changing all monetary inputs consistently and updating the labels; this template does not convert currencies.

Shared input	Example	What to enter
Butter pack price	$8	The purchase price used for this estimate
Net weight per pack	500 g	The pack’s net weight; must be greater than zero

Product	Butter	Other ingredients	Saleable quantity
Butter cookies	200 g	$6.80	40 cookies
Plain pound cakes	250 g	$6	2 cakes
Plain scones	120 g	$7.68	12 scones

“Other ingredients” means the cost consumed by this batch, excluding butter, rather than the purchase price of whole packs. Enter the number of items the batch can actually yield for sale. This quantity must be greater than zero; other inputs must be nonnegative.

How are batch and per-serving costs calculated?

First find the butter cost per gram, then each batch’s cost, and finally the cost per serving.

1. Butter cost per gram = pack price ÷ net pack weight
2. Batch ingredient cost = butter cost per gram × butter used + other ingredient costs
3. Cost per serving = batch ingredient cost ÷ saleable quantity

For cookies: 8 ÷ 500 = $0.016/g; the batch costs 0.016 × 200 + 6.80 = $10; each cookie costs 10 ÷ 40 = $0.25.

All three products reference the same butter cost per gram. Changing the pack price updates their batch and per-serving costs together. Other ingredient costs and saleable quantities stay unchanged.

What changes when butter goes from $8 to $10?

Change only the pack price. Keep the pack weight and all other inputs the same. Butter goes from $0.016 to $0.020 per gram.

Product	Batch cost: $8 → $10 per pack	Cost per serving: $8 → $10 per pack
Butter cookies	$10 → $10.80	$0.25 → $0.27 per cookie
Plain pound cakes	$10 → $11	$5 → $5.50 per cake
Plain scones	$9.60 → $10.08	$0.80 → $0.84 per scone

The download starts at $8 per pack. After importing, try $10 and check these results before entering your own figures.

What are the limits?

• Ingredients only. Labor, packaging, utilities, delivery, and other expenses are excluded. The result is not a complete business cost, selling price, or net profit.
• It does not scale a recipe. For a larger batch, update the quantities used, other ingredient costs, and saleable quantity. Changing only the saleable quantity changes how the cost is divided.
• It estimates future production. Updating today’s purchase price does not recalculate the actual spending on past batches.
• Account for waste yourself. Use realistic saleable yields and include wastage in your ingredient quantities or costs as appropriate. The template does not estimate loss automatically.

Common questions

Can I use other ingredients or products?

Yes. Edit the numbers, labels, and formulas in Calvance. If several ingredients need independent price changes, give each its own unit cost and references. This file shares the unit cost of one type of butter.

What if I buy a different pack size?

Change the pack price and net weight together. For a 400 g pack, enter that pack’s price. Do not combine the price of one size with the weight of another.

How much should I raise my selling price?

This template calculates changes in ingredient costs only. Pricing also depends on other expenses, target profit, and your business circumstances. The results are not a selling-price recommendation.

Do I need a subscription to import it?

Importing does not require a subscription, but the imported canvas uses one canvas from your allowance. The trial includes one local canvas, Local Pro includes 20, and Local Unlimited has no limit. Premium adds cross-device sync while subscribed. See plans.

How to import your template

1. Save the file. Choose Download template and save the .calvx file to Files on your iPhone or iPad. From a computer, you can send it to your device with AirDrop.
2. Open Import. In All Canvases in Calvance, tap the add button to open the template screen, then choose Import.
3. Choose the file. Select the saved .calvx file to create your own canvas. Importing uses one canvas from your allowance.
4. Edit and check. Check the results against the worked example, then add your numbers. Duplicate the canvas to keep different versions.

Download .calvx file