Discovery · System inventory

System inventory

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 and limits

Systems examined
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.

Landscape

13 systems recorded; 5 examined in depth. Select a system on the map for details.

ERPAuftragsPlanerCustomer portalNightly syncEDI linkShop-floor dataFile serverDocument archiveQuality systemHR and payrollDrive and SheetsExcel workbooksShared mailboxes
Core business systemCustom-built softwareCloud serviceSpreadsheets and documentsIntegration

Spreadsheets and documents

Excel workbooks

Offer calculation and monthly reporting, with macros.

Owner
Andrea Hoffmann, Markus Wendt
Technology
Excel with macros
Runs on
File server and laptops
Users
Sales and finance

Inventory

SystemPurposeOwnerTechnology and hostingDepends onEvidence
ERPOrders, materials, purchasing, invoicing, and accounting.Andrea Hoffmann (process), Sabine Roth (technical)Standard ERP with about 60 customizations, two major versions behind. On-premises server in the plant.—Observed
AuftragsPlanerProduction planning and machine scheduling for every order.Petra VogelDesktop application with an SQL database, written in 2009. Plant server; installed on 14 workstations.ERP, File serverObserved
Drive and SheetsAbout 400 sheets: price lists, capacity plans, supplier lists; Docs used as process manuals.Each departmentGoogle Workspace. Provider cloud.AuftragsPlanerObserved
Excel workbooksOffer calculation and monthly reporting, with macros.Andrea Hoffmann, Markus WendtExcel with macros. File server and laptops.ERP, Drive and SheetsObserved
Shared mailboxesOrders, change requests, and complaints that arrive by email.Sales back officeEmail. Provider cloud.ERPObserved
Customer portalcontextOrder status, delivery dates, and documents for B2B customers.Markus WendtPHP web application. Rented virtual private server.Nightly syncObserved
Nightly synccontextMoves orders and delivery dates between the ERP and the portal as CSV files.Nobody namedScheduled scripts and file transfer. Split between the plant server and the rented server.ERPObserved
EDI linkcontextElectronic orders and delivery notes with two large customers.Markus WendtEDI converter service. External provider.ERPObserved
Shop-floor datacontextMachine and labour time recorded at each work centre.Petra VogelTerminal software writing export files. Shop floor; files to the file server.File serverObserved
File servercontextShared drives, machine data exports, and drawings.Jens AlbrechtWindows file server. On-premises.—Observed
Document archivecontextInvoices, delivery notes, and certificates, archived for retention.Andrea HoffmannDocument management system. On-premises.ERPObserved
Quality systemcontextInspection plans, complaints, and certificates.Ralf NeumannQM software. On-premises.ERPObserved
HR and payrollcontextPersonnel records, time accounts, and payroll.HRSoftware as a service. Provider cloud.—Observed

← Back to the guided tour