---
name: recete-porsiyon-maliyeti
description: "Use when a recipe portion cost analysis is requested from standard recipe, net usage quantity, edible yield, purchase price and portions produced. Produce a formula-based Excel file and a Word summary."
---

# Portion cost from recipe

What does one portion of the same dish cost at current purchase prices?

## Input and scope

Standard recipe, net usage quantity, edible yield, purchase price and portions produced.

Use the attached Excel/CSV files as the source. Read each one without modifying it. Identify the sheets, report scope, periods, units and required fields. Match synonymous column headers to the sample. If a missing field affects only a specific metric, still produce the other metrics. If a critical definition can be interpreted in more than one way, ask one focused question. Trace subtotals and duplicates back to the source row. Remove fields containing personal data from the output. Use the sample only when the user wants to try it with the sample data.

## Analysis

1. Verify the recipe version, the actual batch portion count, the purchase price date and the units. In the sample, the recipe quantity is cleaned net kg and the price is the gross purchase price per kg.

2. Gross requirement = net quantity / edible yield. Do not apply waste a second time to a quantity entered as gross. If the yield is outside the (0, 1] range, the portion count is zero or the unit conversion is unclear, flag the cost as incomplete.

3. Sum the batch ingredient costs and divide by the portions of a single batch. Do not sum the same portion count across rows. If a price is missing, do not present the result as the full cost. State in the scope whether labour, energy and overheads are included.

## Delivery and checks

On the first sheet of Analiz.xlsx, show the rows that answer the question and the calculated indicators. Keep the sources on a separate sheet with anonymised fields. Write Excel formulas for derived measures. On the Checks sheet, add the date range, column mapping, scope, missing/unmatched records and the reconciliation result. Create the Word file as Yonetim-Ozeti.docx. On one page, write the period, the main result, at most three evidenced findings and the work the responsible team should check. Reopen both files; independently check the numbers, the denominators of the ratios and the source totals. Do not report causes you cannot verify as findings. Deliver both files as downloads.

Visible fields in the Excel analysis: Ingredient, Gross requirement (kg), Batch cost (TL), Contribution per portion (TL).

## Try it with the sample

Use assets/ornek-girdi.xlsx. The expected Excel and Word examples are in the ornekler/ folder. Check specific to this sample: The 20-portion recipe has an ingredient cost of 690 TL, or 34.50 TL per portion.
