---
name: camasirhane-yogunlugu
description: "Use when a laundry load and unit cost analysis is requested from room linen weights, laundry costs and occupied room nights for the same period. Produce a formula-based Excel file and a Word summary."
---

# Laundry load and unit cost

Is the increase in room linen load driven by the number of occupied rooms or by the amount washed per room?

## Input and scope

Room linen weights, laundry costs and occupied room nights for the same period.

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. Map synonymous column headers against the sample. If a missing field affects only a specific metric, still produce the other metrics. If a critical definition can be read 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 outputs. Use the sample only when the user wants to try it with the sample data.

## Analysis

1. Separate spa, banquet, restaurant and staff linen from room linen. Do not count outgoing and returned laundry twice for the same load.

2. Check the lag between the processing day and the usage day. If batches pile up over the weekend, switch to adequately matched period totals. Keep the kg measurement basis and the cost scope constant.

3. Calculate kg per occupied room, TL per kg and TL per occupied room. Derive total ratios from the sums of the relevant numerators and denominators. Leave the ratio blank when the denominator is zero.

## 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 named Yonetim-Ozeti.docx. On one page, write the period, the main result, at most three evidence-backed findings and the follow-up the responsible team will check. Reopen both files; independently check the numbers, the denominators of ratios and the source totals. Do not present unverifiable causes as findings. Deliver both files as downloads.

Visible fields in the Excel analysis: Date, Kg / occupied room, TL / kg, TL / occupied room.

## Try it with the sample

Use the file assets/ornek-girdi.xlsx. The expected Excel and Word examples are in the ornekler/ folder. Sample-specific check: On 18 November, laundry per occupied room rose to 5.5 kg and cost to 176 TL.
