As a manufacturing business, one of the main areas of focus is utilization of the production floor. In the case examined here, the factory works 247 and every production stop reduces the total units that can be produced and therefore undermines revenue and profitability.
Understanding trends, main root causes and other insights from analyzing this data will enable the organization to focus on the most crucial improvements that need to be made.
Dashboard Example (sample data)
Click on the image to open and interact with the dashboard:
Goals
Maximize production utilization in order to achieve higher profitability.
Objectives
Analyze the utilization rate for every period of time, error type and product type to figure out what should receive higher focus.
Understand total downtime in order to have a numeric reference that can be used to analyze trends and problematic areas.
KPI Architecture
Objectives
KPIs
Measures
Data Source
Analyze the utilization rate for every period of time, error type and product type to figure out what should receive higher focus.
Understand total downtime in order to have a numeric reference that can be used to analyze trends and problematic areas.
% of Utilization
Utilization %/per unit type/per week –
(1440-avg([Unit_Day],sum([Duration (minutes)])))/1440
Shop Floor Control\ProductionStops;Machines;Dates
Utilization distribution per day of week
(Day of week Utilization %)/ Utilization %
Shop Floor Control\ProductionStops;Machines;Dates
Average downtime by hour
AVG DOWNTIME by hours \per error type\
avg([Unit_Day],sum([Duration (minutes)]))/60
Shop Floor Control\ProductionStops;ErrorType
Standard deviation of Downtime by hour
StDev DOWNTIME by hours
StDev([Unit_Day],sum([Duration (minutes)]))/60
The following resources will enable you to design your dashboard and data model with sample
data and then apply it to your own data. Note that you will need to have a previously
installed version of Sisense (you can use the free trial version if you’re
not a customer).
