Machine and Operator Capacity dashboard


Business challenge

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:

  1. Visualise the planned operator and machine capacity vs. the available capacity;
  2. Consolidate the dashboards of the different areas into one single document;
  3. Provide the flexibility to the end-user to adjust parameters in face of an everchanging organisational context.


Our approach

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.


Data analytics & insights

Data analytics drives excellent organisations: how to do we move from good to great? Accelerate in process improvement, use your data company-wide and get outstanding results.
Printer Friendly, PDF & Email