ERP, AuftragsPlaner, Drive and Sheets, Excel workbooks, Shared mailboxes
Context only
Customer portal, Nightly sync, EDI link, Shop-floor data, File server, Document archive, Quality system, HR and payroll
Period
10 business days
Access
Tier A, context-led: Interviews, the documentation you supply, demonstrations, and limited non-invasive review.
Exclusions
No production data, no changes to any system, no security testing beyond configuration review.
Confidence
Medium for the process and the root causes, which we observed in five real offers. Low for the inner workings of the macros and the ERP data, which we could not inspect. We recommend a short read-only inspection before committing to a larger change.
Recommendation
Modernization
Fix the price and rule sources first, then add AI where it is safe. Start with a short read-only inspection, then consolidate prices and surcharge rules into one tested calculation.
Reasons and evidence
01The delay comes from copying between four systems and from conflicting prices, not from a lack of AI (F1, F3, F4).
02The surcharge knowledge of two senior people needs to be written down and tested regardless of what comes next (F2).
03An AI assistant is realistic for reading requests and drafting text, but only after prices come from one correct source (F5).
04Our evidence is context-led; a short inspection reduces the uncertainty before you commit to the larger change.
Alternatives considered
An AI offer assistant now
It would produce well-written offers with wrong prices.
A new offer system
Possible later; first the rules must be known, or a new system copies today's errors.
Application Managed Services
There is no single application to operate; the problem is the flow between them.
Next step
If Musterwerk decides to proceed, the attached project definition is the basis for a proposal. If not, all outputs remain Musterwerk's to use.