<< Click to Display Table of Contents >> Navigation:  Knowledge Base > Efficiency Reports Topic Last Edited 27/05/2016

 

The query behind the standard employee, work centre, WC Location, WC Cell efficiency detail reports is identical. For the standard efficiency reports (i.e. based on qty booked) the estimated time is the time it SHOULD have taken to manufacture the booked quantity in comparison to the planned time and the WO quantity while the efficiency is based on the qty booked, estimated time and the actual time taken by the employee.

 

Efficiency By Employee Detail

 

 

NOTE: No estimated times or efficiencies are calculated for setup time booked as quantities are not booked against setup timesheets, only “booked” timesheets.

 

 

If the employee spends 30mins working on this WO and booked a quantity of 5 when he jobs off the WO, the calculation would be as follows:

 

ESTIMATED TIME = (Completed Qty/WO Qty) x Planned Time (setup+run) = (5/100) x 180 = 9mins

 

So the Estimated Time for a booked qty of 5 units would show as 9 mins.

 

The efficiency value is calculated as follows:

 

EFFICIENCY = (Estimated Time / Timesheet Time Booked) x 100 = (9/30) x 100 = 30%

 

Therefore, the employee efficiency for a booked qty of 5 over a 30min period would be 30%

 

==================================================================================================================================

 

The only efficiency reports that differ from the standard reports above are the Efficiency By Employee Based On Hours Booked reports. These do not consider booked quantities; only booked time.

 

“EFFICIENCY BY EMPLOYEE BASED ON HOURS BOOKED DETAIL” report

 

Using the same example as above:

 

 

If the employee initially spends 30mins working on this WO (10mins setup, 20mins run) and booked a quantity of 5 when he jobs off the WO, the calculations would be as follows:

 

 

After the employee spends a further 40mins (0mins setup, 40mins run) on the job:

 

*(Setup estimated time and efficiency remains the same as no additional setup time has been recorded)

 

After the employee completes the op (another 150mins later ) (0mins setup, 150mins run):

 

 

Therefore, over the entire operation, and compared against the planned setup and run times, the employee was 100% efficient during the setup, but only 94.444% efficient over the run time. The report summaries by booking type (setup, run, etc) as well as by employee to give an overall average value for estimated time and efficiency.

 

“BASED ON HOURS BOOKED DETAIL (SUM SETUP AND RUN)” report

 

Using the same example as above:

 

 

If the employee initially spends 30mins working on this WO (10mins setup, 20mins run) and booked a quantity of 5 when he jobs off the WO, the calculations would be as follows:

 

 

After the employee spends a further 40mins (0mins setup, 40mins run) on the job:

 

 

After the employee completes the op (another 150mins later ) (0mins setup, 150mins run):

 

 

Therefore, over the entire operation, and compared against the planned total setup and run times, the employee was 81.8% efficient over the course of the operation. The report summaries this by employee to give an overall average value for estimated time and efficiency.