Product family · Supplier comparison
Compare total acquisition cost, delivery and quality rates. Find records below the weighted-score threshold.
Premium preview · Member downloads are not yet available · Excel workbook in Turkish
Results from the sample workbook
- Average acquisition cost
- 142.5
- Average supplier score
- 90.14%
- Suppliers below threshold
- 9
Who can use it, and for what?
Furniture manufacturing
For teams tracking product family records by workshop. Compare total acquisition cost, delivery and quality rates. Find records below the weighted-score threshold.
A worked example from the workbook
These figures come from 16 fictional records in the workbook’s Panel sheet.
| Measure | Sample result |
|---|---|
| Average acquisition cost | 142.5 |
| Average supplier score | 90.14% |
| Suppliers below threshold | 9 |
| On-time delivery rate | 91.71% |
How do you start with your own data?
- Choose a start and end date on Panel. If the workbook has assumptions, replace the example values with your own.
- Replace the sample records in the yellow cells on Girdiler. Enter a unique ID and a valid date for each record.
- Review period totals and breakdowns on Panel. Resolve flags on Kontrol and trace calculations on Hesap.
Workbook input fields
Labels appear in Turkish in the workbook.
- Teklif fiyatı / birim
- Nakliye ve diğer / birim
- Teslim sayısı
- Zamanında teslim
- Kontrol adedi
- Kusur adedi
Sample assumptions
- Hedef edinme / birim
- 110
- Termin ağırlığı
- 0.4
- Kalite ağırlığı
- 0.35
- Fiyat ağırlığı
- 0.25
- Onay puanı eşiği
- 0.9