Hi,
We are recording "in-process" rework on our assemblies under the downtime categories. We report rework (if necessary) at the operation level. This has been great for capturing where we need improve processes and the additional time taken to process a work order however I can't seem to incorporate the downtime value into our operations efficiency report.
Our efficiency saved search stems from a Manufacturing Operations Task base and the AM Downtime records are not available. If I attempt from a transaction base saved search, while I can access the downtime records I end up with the multiple/duplication of lines issue and can report successfully.
So I have the issue that the efficiency report is understated if there is rework as the rework (downtime) hours are not incorporated into the total work order hours and I am also unable to see what the % of rework time is over total work order to see if we are improving where issues have been identified.
We don't want to have rework as an operation as it normalizes rework and the operation will have to be transacted through even if has zero value.
The 2 formulas I am hoping to be able to develop are:
- Work Order Efficiency = (Planned Setup Time + Planned Run Time) / (Actual Set Up Time + Actual Run Time + Downtime/(Rework))
- Rework % = Downtime(Rework)/ Actual Set Up Time + Actual Run Time + Downtime/(Rework))
Just getting usable downtime data within the total work order times data will be a bonus!
Thanks,