Discovery · Systems handbook
Systems handbook
Musterwerk Antriebstechnik GmbH
Scope and limits
Excel workbooks
Every statement carries an evidence label, so you can see what we checked and what remains open.
Purpose and users
- Observed
The calculation workbook produces every offer price. Six people in sales use it; two senior calculators maintain it.
- Observed
One offer typically touches four systems: the mailbox, the workbook, the price sheet, and the ERP.
How an offer is made today
- Observed
1. Request arrives by email. 2. Item data copied from the ERP. 3. Base price taken from the Google Sheet. 4. Surcharges calculated by macros. 5. Lead time taken from the capacity sheet. 6. Offer typed into the ERP and sent as PDF.
- Observed
Median time from request to offer in the five cases: six business days.
Data sources
- Observed
Base prices: ERP, Google Sheet, and a copy inside the workbook (F1).
- Inferred
The Google Sheet is the version sales trusts most; the ERP is updated last.
Operations
- Observed
The workbook is copied for each year; there are 11 versions on the file server.
- Unverified
Which version is the current master; staff gave two different answers.
Known risks
- Observed
Conflicting prices (F1).
- Inferred
Undocumented surcharge macros (F2).
Knowledge gaps
- Unverified
The full logic of the surcharge macros (needs Tier B).
- Unverified
How prices in the ERP are maintained and by whom.
Evidence labels
- Observed
- We saw it, or it was shown or told to us directly.
- Validated
- We checked it against code, configuration, logs, or a test.
- Inferred
- A reasoned conclusion from what we saw, not yet checked.
- Unverified
- Reported to us, but we could not confirm it.