Skill · Kitchen and F&B
Portion cost from recipe
What does one portion of the same dish cost at current purchase prices?
Download skill package
recete-porsiyon-maliyeti/ ├─ SKILL.md ├─ assets/ │ └─ ornek-girdi.xlsx └─ ornekler/ ├─ analiz.xlsx └─ yonetim-ozeti.docx
SKILL.md instructions and sample files in one package
How to use
- Download the package.
- In an assistant that supports skills (e.g. Claude), upload the package as a skill. In other assistants, paste the SKILL.md text into the chat.
- Attach your own Excel export and send the message below. The assistant prepares the formula-based workbook and the Word summary.
Try it with the sample
Before using your own data you can try the sample input in the package. Send this message to the assistant together with the file:
Analyze the files I attached for recipe portion cost. What does one portion of the same dish cost at current purchase prices? Prepare the result as a formula-based Excel file and a one-page Word report we can use in our meeting.
The 20-portion recipe has an ingredient cost of 690 TL, or 34.50 TL per portion.
Sample files
- Sample input
ornek-girdi.xlsx - Expected Excel analysis
analiz.xlsx - Expected Word summary
yonetim-ozeti.docx
The sample files are in Turkish.
Instructions (SKILL.md)
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
- 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.
- 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.
- 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.