Deep analysis: patterns behind the baseline
Article language, variety, supply routes, rhythm — recomputed against the raw dataSynthetic purchase lines
Entirely generated from the documented random seed.Matched basket
Matched using the synthetic product key.Offer versions
Three successive versions per offered item.Missing shared item terminology
How much spend joins to the tender basket?In the synthetic dataset, 79 % of purchasing volume (26.87 million EUR from 34.01 million EUR) is linked to a shared item key. Other lines simulate local item identifiers.
In the synthetic dataset, 79% of spend maps to a shared article key. Other records simulate local numbering.Variety is manageable
How many articles carry 80% of spend?The synthetic dataset shows purchasing concentration in a core set of items. Basket size remains an illustrative planning assumption.
The synthetic dataset illustrates spend concentration. Tender basket size is an illustrative planning assumption.Invoice route per Market
Manufacturer entity or distributor, and where the RFI offers direct supplySynthetic invoice routes illustrate manufacturer and distributor purchasing shares. They support discussion of hypothetical direct-supply options.
Synthetic invoicing routes illustrate manufacturer and distributor shares and hypothetical direct-sourcing options.Supplier assessment matrix (RFI)
Synthetic offer matrix and illustrative fulfillment scoresIllustrative offer overview: which supplier serves which market and through which route. Solid dot = direct supply offered in the RFI; hollow dot = indirect supply through a distributor or intermediate route; blank = no offer.
Synthetic offer overview: which supplier offers in which market, and via which route. Full dot = direct supply offered in the RFI, hollow dot = indirect via distributor, empty = no offer. Hover any cell for the verbatim RFI answer.| Market | 3M | Glasurit (BASF) | Finixa | Mirka | SATA | tesa | PPG / Nexa | Würth | Kovax | Starcke |
|---|---|---|---|---|---|---|---|---|---|---|
| ATAustria | ||||||||||
| DEGermany | ||||||||||
| SESweden | ||||||||||
| FRFrance | ||||||||||
| ITItaly | ||||||||||
| ESSpain | ||||||||||
| PTPortugal | ||||||||||
| CHSwitzerland | ||||||||||
| PLPoland | ||||||||||
| CZCzechia | ||||||||||
| SKSlovakia | ||||||||||
| HUHungary | ||||||||||
| SISlovenia | ||||||||||
| HRCroatia | ||||||||||
| RORomania | ||||||||||
| BGBulgaria | ||||||||||
| RSSerbia | ||||||||||
| BABosnia and Herzegovina | ||||||||||
| ALAlbania | ||||||||||
| MKNorth Macedonia | ||||||||||
| MEMontenegro | ||||||||||
| UAUkraine | ||||||||||
| CNChina | ||||||||||
| JPJapan | ||||||||||
| MYMalaysia | ||||||||||
| SGSingapore | ||||||||||
| CLChile | ||||||||||
| COColombia | ||||||||||
| XKKosovo | ||||||||||
| Total Markets with Offer | 24 | 25 | 25 | 25 | 25 | 25 | 25 | 24 | 25 | 25 |
Supplier fulfilment calculated from RFI responses: catalogue (7 Tender categories), market coverage (29 markets), direct supply and price transparency (21 reference items). Unweighted average; procurement determines the weights.
Fulfillment per supplier, derived mechanically from the RFI returns; the average is unweighted — weighting is a procurement decision, configurable later.Ordering pattern
Monthly patterns where markets provide themSynthetic monthly series show different ordering patterns. Highlighted peaks illustrate potential consolidation windows.
Synthetic monthly series illustrate ordering rhythms and potential consolidation windows.Austria
Median 160 €k/monthGermany
Median 148 €k/monthSweden
Median 138 €k/monthFrance
Median 134 €k/monthItaly
Median 159 €k/monthSpain
Median 130 €k/monthPortugal
Median 171 €k/monthSwitzerland
Median 139 €k/monthPoland
Median 158 €k/monthCzechia
Median 132 €k/monthSlovakia
Median 153 €k/monthHungary
Median 159 €k/monthSlovenia
Median 157 €k/monthCroatia
Median 148 €k/monthRomania
Median 177 €k/monthBulgaria
Median 133 €k/monthSerbia
Median 123 €k/monthBosnia and Herzegovina
Median 147 €k/monthAlbania
Median 118 €k/monthNorth Macedonia
Median 154 €k/monthMontenegro
Median 124 €k/monthUkraine
Median 151 €k/monthChina
Median 160 €k/monthJapan
Median 146 €k/monthMalaysia
Median 172 €k/monthSingapore
Median 150 €k/monthChile
Median 128 €k/monthColombia
Median 130 €k/monthKosovo
Median 144 €k/monthIf-then rules
The patterns as transparent rules, no model neededIF Invoice price differs from the effective agreement
THEN Check price version and pack unit; document the decision.
OpportunityIF Item code or agreed price missing
THEN Request human review; do not report savings.
GapFrom report to continuous monitoring
What Lab monitors continuously through tender and contract phaseThe baseline is a snapshot. These alert rules are illustrative requirements for a future implementation with live data.
The baseline is a synthetic snapshot. These alert rules illustrate requirements for a future implementation.| Alarm | Metric / threshold | Data source | Start |
|---|---|---|---|
| Price variance | Net price per normalized piece | synthetic-invoices.json / offer-versions.json | sofort |
| Record quality | Missing or conflicting fields | quality-issues.json | after award |
Measurement limits
What this data cannot show, stated openlyCommercial values, supplier relationships and records are synthetic; supplier names are real references.
No real supplier assessment or price recommendation.
Raw-record defects must be checked before aggregation.