Calculate productivity for employees in assembly area

[alespooletto]

I would like to implement a calculation for employees productivity, which is supposed to run like this:

Productivity = Ideal time * Total Count / Run Time

Where:

Ideal Time = the time an employee should be available (7:30 hours) as per laws here

Total Count = the number of goods produced 

Run Time = the effective time an employee was available. 

I am having troubles putting this down into expressions and in the load script editor. Here you can find the table of data that I have available (there is a xlsx attached too)

Since the person has produced 15 items in 6:38 hours, it means around 13.29 for an hour, if I understand correctly. But what I want to obtain, is a measure that tells me in percentage how productive the employee was. How can I modify the current settings to obtain the desired measure?

[steeefan]

Would that not simply be Productivity = [Labour Duration] / [Nominal Time]?

For the values at hand, that would result in a producitvity of 88.66%. If the value for [Labour Duration] were to be the same as for [Nominal Time], that would then give you a prodcutivity of 100%.

In case of calculating the producvity in units, you would need a target amount. If that were 18 for instance, the productivty would then be 15 / 18 = 83.33%.

[alespooletto]

Thank you @steeefan , I use those Labor Duration / Nominal Time as measures for the availability of the employee aka how much of the nominal time they spent working. For the productivity, I guess you are right about the target. I do have standard times for some of the cells in which employees are located, the problem is using them seems to mess up my availability measures:

AS you can see, not all work centers have a standard time of completion for the products.