The organisation’s drug pilot plant faced an increasing customer demand. The planning of production batches was done without a clear view on operator and machine availability. This led to capacity issues and hence a decreased customer satisfaction.
The objective was to:
- Visualise the planned operator and machine capacity vs. the available capacity;
- Consolidate the dashboards of the different areas into one single document;
- Provide the flexibility to the end-user to adjust parameters in face of an everchanging organisational context.
All stakeholders were interviewed to assess their needs and requirements and to develop an understanding of the as-is process with its pitfalls. Consequently, an overall scope for the future state was defined and agreed upon with the customer.
With the obtained process knowledge, a model was created using OMP export data, which is transformed by the Power Tool Add-ins from MS Excel. By closely involving the customer’s process owner, the dashboard was further developed. The other core team members were kept up to date by installing a periodic status-meeting. The resulting feedback was used to drive incremental improvements. Using the gained expertise in both the process data and the model, a set of extra-additional visualisations were proposed which gave the customer new insights into the organisation.
The customer is now able to assess the planned versus the available capacity at a glance. This allows the planning to be adjusted in a timely fashion to guarantee and increase customer satisfaction as well as mitigate the risk of internal escalations. Furthermore, the organisation has a renewed view on its internal operations and can now take data-driven decision in order to define process improvement projects and hence increase the plant’s capacity.