Originally Posted by

**ndb** Hello,

First of all I want to apologize if did not post in the right place.

I need your help to find the right tool for solving practical problem.

My data includes information for number of Items produced for a day and total time for the production. The problem is that one employee can produce 3 different kinds of items with different level of difficulty.

My goal is to measure average time for the 3 items based on the information for total time and number for each item.

My idea was to make a system of equation from each two days in which the employee has values for two of the items and another system for the days in which there is values for the 3 items. Then, using the results for x,y and z from each system to find the average value for x,y and z.

50x + 30y = 450 min

45x + 15y = 400 min

45x + 1y + 14z = 420

33x + 20y + 15z = 450

50x + 15y + 10z = 400

etc............

If values for example are: x =7 y= 9 z = 10 then i am finding the weight of y and z like this:

7 9 10

x y z

1 9/7=1.285 1.428

From here I can transfer items B and C to items A

If:

ItemA ItemB ItemC

1000 600 400

Then

1000 ItemA + 600*1.285 + 400*1.482 = Total Production Time

The problem here is that the time for each of the items can vary for each day in a way that I am getting negative numbers in the results of the system.

So now when you know what I am trying to do can you please tell me how can I obtain the most reliable results for x, y and z?

Many thanks for the help!