---
name: tedarikci-teklif
description: "Use when a same-unit supplier quote comparison analysis is requested from supplier quotes and delivery terms for the same product specification. Produce a formula-based Excel file and a Word summary."
---

# Supplier quotes compared on the same unit

Once case size, discount and delivery are taken into account, which quote is better value?

## Input and scope

Supplier quotes and delivery terms for the same product specification.

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. Match product grade, quantity, delivery point, VAT basis and currency. Use verified conversions between kg, litres and units.

2. Apply the discount to the base the quote applies it to. Do not add order-level delivery charges once per product line. Divide the total delivered cost by the comparable quantity.

3. Show differences in payment terms, minimum order and delivery lead time separately. Only include quotes with equivalent terms in the price ranking. In Word, state the difference between the best quote and the runner-up.

## 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: Supplier, Total kg, Delivered cost (TL), Delivered TL / kg.

## 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: Supplier A ranks first at 40.90 TL/kg including delivery.
