Optical lens manufacturer
Sales planning and production planning
Starting point
- Sales planning is currently done via Excel (across over 20 workbooks)
- Extensive adjustments due to recurring changes in planning assumptions require high effort, such as during the monthly initialization of planning
Procedure
- Creation of the "Big Picture" based on a rough requirements analysis and a high-level concept
- Gradual gathering of detailed requirements in workshops with business departments and creation of the design for the business data model
- Workshop with Lessons Learned and definition of necessary adjustments
- Employee training
- Test development and execution by the customer
Features/Project outcome
- Workflow-driven planning system with integration into operational systems
- Planning of scenarios and versions to simulate business changes
- Product "break-down" into manufacturing items based on production bills of materials
- Automatic distribution of production quantities across production machines with varying capabilities based on a defined optimization procedure
- Role-based management of access rights
Customer benefits
- Acceleration of the planning cycle through a parallelizable workflow
- Effort reduction through a central planning system
- Error reduction through integration with operational systems and elimination of manual steps
- Determination of production quantities per machine at different locations

Sascha Mertens | Senior Manager / Prokurist