Discovery · System inventory
System inventory
Musterwerk Antriebstechnik GmbH
Scope and limits
Landscape
13 systems recorded; 5 examined in depth. Select a system on the map for details.
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
| System | Purpose | Owner | Technology and hosting | Depends on | Evidence |
|---|---|---|---|---|---|
| ERP | Orders, 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 |
| AuftragsPlaner | Production planning and machine scheduling for every order. | Petra Vogel | Desktop application with an SQL database, written in 2009. Plant server; installed on 14 workstations. | ERP, File server | Observed |
| Drive and Sheets | About 400 sheets: price lists, capacity plans, supplier lists; Docs used as process manuals. | Each department | Google Workspace. Provider cloud. | AuftragsPlaner | Observed |
| Excel workbooks | Offer calculation and monthly reporting, with macros. | Andrea Hoffmann, Markus Wendt | Excel with macros. File server and laptops. | ERP, Drive and Sheets | Observed |
| Shared mailboxes | Orders, change requests, and complaints that arrive by email. | Sales back office | Email. Provider cloud. | ERP | Observed |
| Customer portalcontext | Order status, delivery dates, and documents for B2B customers. | Markus Wendt | PHP web application. Rented virtual private server. | Nightly sync | Observed |
| Nightly synccontext | Moves orders and delivery dates between the ERP and the portal as CSV files. | Nobody named | Scheduled scripts and file transfer. Split between the plant server and the rented server. | ERP | Observed |
| EDI linkcontext | Electronic orders and delivery notes with two large customers. | Markus Wendt | EDI converter service. External provider. | ERP | Observed |
| Shop-floor datacontext | Machine and labour time recorded at each work centre. | Petra Vogel | Terminal software writing export files. Shop floor; files to the file server. | File server | Observed |
| File servercontext | Shared drives, machine data exports, and drawings. | Jens Albrecht | Windows file server. On-premises. | — | Observed |
| Document archivecontext | Invoices, delivery notes, and certificates, archived for retention. | Andrea Hoffmann | Document management system. On-premises. | ERP | Observed |
| Quality systemcontext | Inspection plans, complaints, and certificates. | Ralf Neumann | QM software. On-premises. | ERP | Observed |
| HR and payrollcontext | Personnel records, time accounts, and payroll. | HR | Software as a service. Provider cloud. | — | Observed |