---
name: acik-bufe-artigi
description: "Produces Excel and Word reports by analysing open buffet leftovers from end-of-service weights by item and cover counts for each meal."
---

# Open buffet leftovers

Read the attached Excel files and work on a copy of the workbook. If there are multiple tabs, different headers or separate files, map the fields whose meaning can be verified. Note the source file, tab, field, scope and excluded records. Check date and number formats. Reconcile with the source total. If an ambiguity affects the result, ask one concrete question. Keep the metrics that can still be produced. Deliver analiz.xlsx and yonetim-ozeti.docx to the user. The Excel file should contain Analysis, Checks and the required anonymised source fields. Use traceable formulas for derived numbers. The Word file should include the period, the main result, at most three evidence-backed findings and the follow-up the team will check. Reopen the files, check for formula errors and compare the figures in Word with Excel. Use the sample inputs only when the user wants to work with the sample.

1. Define each service by hotel, date, outlet and meal. Select the measured leftovers returned from the buffet. Keep preparation waste, plate waste and measured buffet returns separate. Convert kilograms and grams to a common weight unit. If there is no verified conversion for pieces or litres, show the quantity separately.

2. Use a single cover count per service. Count the same cover count repeated on item rows only once. Flag conflicting cover counts within the same service for checking. Sum the weights by item and service. Distinguish a missing weight record from an explicitly recorded zero.

3. Leftover grams per cover = total leftovers in kg × 1,000 / service covers. Period average = total grams of services with a computable ratio / total covers of the same services. Leave the ratio blank when covers are zero or missing. Rank the items with the most leftovers by kg, and list all items in case of a tie.

4. In Excel, show the service, covers, leftover kg, grams per cover, the item with the most leftovers and the reason for any exclusion. In Word, write the service with the highest per-guest leftovers, the item with the most leftovers and the one topic the chef should review. Do not produce cost or savings figures without a verified unit cost.

## Try it with the sample

Match the weights of items returned from the buffet with the service covers. Prepare grams per cover by meal and the item with the most leftovers in Excel, and a summary for the kitchen meeting in Word.

The sample file is assets/ornek-girdi.xlsx. The expected Excel and Word outputs are in the ornekler/ folder.
