---
name: stok-karsilama
description: "Use when a consumables stock days of cover analysis is requested from available stock, historical consumption, observation days and supplier lead time. Produce a formula-based Excel file and a Word summary."
---

# Consumables stock days of cover

Which item in stock could run out before the supplier lead time is up?

## Input and scope

Available stock, historical consumption, observation days and supplier lead time.

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. Convert to the same unit per item and storeroom. Separate blocked, reserved and expired quantities from available stock. Do not add transfers between storerooms to the hotel's total consumption.

2. Average daily consumption = net consumption / observation days. Days of cover = available stock / daily consumption. Do not produce a day count when consumption is zero or unclear.

3. Compare the lead time with days of cover. If an approved open order has an arrival date and quantity, show it separately. Do not assume a safety stock or order quantity without the hotel's own rule.

## 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: Item, Daily consumption, Days of cover, Status.

## 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: At the current rate, shampoo stock lasts four days. The lead time is five days.
