Discovery · Project definition

Offer process modernization (indicative)

Musterwerk Antriebstechnik GmbH

Situation
Spreadsheets, silos, and a wish for AI
Access
Tier A
Prepared by
Aleph Engineering GmbH
Version
1.0, reviewed by a second engineer

Scope

  • Read-only inspection of the ERP price data and the calculation macros
  • ERP as the single source of base prices; spreadsheets connected read-only
  • Surcharge rules documented with the calculators and moved into one tested calculation
  • Request tracking and lead times from planning

Not included

  • AI-assisted offer drafting (a separate decision after this project)
  • Changes to the AuftragsPlaner beyond a capacity export

Team and roles

Lead engineer
Accountable for the plan and the calculation design.
Engineer
Builds and tests the calculation; every change reviewed by a second engineer.
Your side
Ms Hoffmann owns prices; the two senior calculators validate the rules; Mr Wendt tests with real requests.

Schedule

Week 1
Read-only inspection; the project definition is then confirmed or adjusted.
Weeks 2-8
Prices and rules consolidated, run in parallel with the workbook.
Weeks 8-10
Request tracking and lead times.

Weeks count from the agreed start date.

Acceptance checks

  • For 50 historical offers, the new calculation matches the approved price
  • Base prices maintained in one place only
  • Every surcharge rule documented and tested
  • Time from request to offer measured from the new tracking

Musterwerk's responsibilities

  • Decide price ownership
  • Make the calculators available for rule sessions
  • Grant read-only ERP access

Commercial basis

Indicative only at this access level. After the inspection in week 1, milestone-based pricing set out in the proposal.

Risks

  • Indicative scope: the macros may hold more rules than the interviews revealed
  • Calculator availability during the busy season

Open decisions

  • Who owns prices
  • ERP or separate tracker for requests

← Back to the guided tour