Jodex

RECIPE COST WORKSHEET / EARLY PREVIEW

What does one batch cost?

Enter what you bought, what you used, and the costs for the whole batch. See ingredient cost, total batch cost and cost per finished portion in one worksheet.

US$9 planned priceOne editable .xlsx worksheet + a short usage guide

Ask about this worksheet

This is a product preview. Excel and Google Sheets compatibility are not yet confirmed. Confirm your app, availability and payment arrangements by email before ordering. This page takes no payment.

Worksheet sample with USD selected, a total batch cost of 11.825, 12 finished portions, and a cost per portion of 0.9854.
Original worksheet with fictional example values. Open the image for a closer look.

From a purchased pack to your batch

In the USD sample, buy 2 kg of flour for $4 and use 500 g: this batch uses $1 of flour. Enter up to 15 ingredients, then add labor, packaging and other costs for the entire batch.

Supported units are g / kg, ml / L and each. The worksheet converts within those groups. It does not turn cups into grams or assume an ingredient's density.

Ingredient rows with amber input cells, separate pack and recipe units, calculated batch costs, and input messages.
Enter the amber cells. Calculations and input messages sit alongside each ingredient.

Know what the result includes

  • Changing finished portions changes cost per portion. It does not scale ingredient quantities or other batch costs.
  • Missing or incompatible inputs show a message and block the affected result. Enter 0 when a cost does not apply.
  • Use a separate copy for each recipe. The worksheet has 15 ingredient rows; formula cells are editable, so use the marked inputs.
  • Choose one cost currency: USD, EUR, GBP, CAD, AUD, NZD, JPY or KRW. Enter every cost in that same currency. Changing the selection changes labels only, without converting amounts.
  • Inventory, orders, currency conversion, tax and selling-price recommendations are outside this worksheet's scope.

Read the usage guide

Would this fit your workflow?

Send your spreadsheet app and version, plus what you need to calculate. The planned $9 price covers the standard file and guide; custom changes need a separate scope.

Ask about Recipe cost worksheet

Your email and question are saved so Jodex can reply about this inquiry. Please leave out payment details and private customer information.

Prefer email? jodex145@gmail.com

An original worksheet created with Codex using synthetic example data. No macros. No customer results or sales are claimed.

Also in the lab: printable phone order record

Our page-load counter stores only the date, page and total, without cookies or visitor identifiers. Inquiry details are saved separately when you submit a form.