Production Detail Report- Efficiency Calculation

Epicor ERP 10
, ,
1

I have been on Epicor for a total of 7 weeks so, please forgive me for what is probably an elementary question. I ran a production Detail Report for a particular Job# to check the efficiency report. But what I am seeing here is a wrong calculated efficiency. I have the formula about how it should work and it goes by

If setup is not complete:
Eff. % = (Earned hours/Actual hours ) * (100)
Earned hours (Setup)= (Est Setup Hours) OR (ActSetupHours) , whichever is less.
Earned hours (Prod) = (EstProdHours / RunQty )* (Labor Qty)

Eff. % = (Earned Setup Hours + Earned Prod Hours) / (Actual Hours ) (* 100)

If setup is complete:
Eff. % = ( Earned Hours / Actual Hours ) * (100)
Earned Hours (Setup) = Est Setup Hours
Earned Hours (Prod) = (EstProdHours / RunQty ) * (Labor Qty)

Eff. % = (Earned Setup Hours + Earned Prod Hours) / Actual Hours * (100)

Also, almost for all jobs run qty and labor qty are same.

Now, if I see about how the report is set up, it is actually different. Any suggestions about how should it work ?

user111
user1111658×746 57.1 KB

According to formula it should be around 538,…% but it is 303.46
user222

Thank you in advance.

2

Just curious where you found your formula?

Ref Eff% field help in Job Tracker - Labor Trans sheet

Efficiency % - Displays a measurement used to compare estimated to actual labor hours. This measurement appears throughout the system. The actual calculation may vary slightly, depending on where it appears. In general, it is:
Earned Hours/actual hours * 100
Definition:
Earned Hours The number of hours it should have taken to produce the job quantities reported, based on the estimates you enter.

FWIW I have never trusted some of the performance fields too much in Epicor.
e.g. Supplier PO “OnTime”

2 Likes
3

Thank you for your response. But how do we calculate Earned Hours ?

4

I use the Data Dictionary for LaborDtl.EarnedHrs

The amount of hours that it should have taken (based on standard) to produce the reported LaborQty. For Setup labor the Earned hours is the lessor of (Est.Setup - ActSetUp) or LaborDtl.BurdenHrs. Rework labor always has zero Earned hrs. Earned hours for production labor is calculated as (JobOper.EstProdHours / JobOper.RunQty) * LaborDtl.LaborQty

image
image808×452 11.8 KB

5

Hey @bordway, Thank you for your help and time, I will review it now.