Auto Allocation of Products to Workers, which set of tools to use, machine learning ?

[Deevi]

Hi, 

I need help creating a workflow to automatically assign Products to workers for quality check according to worker's knowledge base and the products complexity.

Sample data attached. To give more details - 

1. Every Product has a Unique Product Code. The Product e.g. Shirt needs to go through 2 Quality Checks.

2. Every Day, we have a list of Products to be evenly distributed amongst all workers ("Checker 1" and "Checker 2"), whether it is the first quality check or second, is given in data. (Table 1)

3. The worker who did the fist Quality check should not be the person to do the second quality check.

4. Assume every worker works only 8 hrs per day so time has to be managed according to Table 2 given below.

5. Similarly, the complexity of the quality check should be evenly distributed amongst all available workers. (Table 2)

Table 2 is a static table to maintain as and when a new worker is employed, etc. Table 1 is new data received every day.

Table 1:

More data available in Excel attached.

Unique Product Code	Product Category	Check Type	Checker 1	Checker 2
120	Shirt	1		NA
121	Trousers	1		NA
122	Pen	2	Brune
123	Mouse	2	Dave
124	Shoes	1		NA
125	Lipstick	1		NA

Table 2:

Product Category	Workers with knowledge to check Product Quality -1	2	3	Time Taken to review quality in hours	Complexity of task (1 (most difficult) to 4 (easy))
Shirt	Adam	Brune		1	2
Trousers	Adam	Brune	Michael	1	2
Pen	Brune	Flora		0.25	3
Mouse	Dave	Adam		1.25	1
Shoes	Flora	Dave		2	1
Lipstick	Michael	Flora	Brune	0.5	4
Comb	Brune	Michael	Dave	0.1	4
Cooker	Charlie	Brune		2	1
Sofa	Flora	Dave		3	1
Pillow	Charlie	Dave		1.5	2

Please advise which tools I can use in Alteryx to achieve this, can machine learning tools in Alteryx Designer be used here and if yes how?

Thanks & Regards

[Kamran1991]

Please try to simplify the problem. 

[Deevi]

Thanks, further simplified the problem below:

New Sample data attached. To give more details - 

1. Every Product has a Unique Product Code. 

2. Every Day, we have a list of Products to be evenly distributed amongst all workers ("Checker") according to their skillset given in Table 2. 

3. Assume every worker works only 8 hrs per day so time has to be managed according to Table 2 given below.

Table 2 is a static table to maintain as and when a new worker is employed, etc. Table 1 is new data received every day.

Table 1:

More data available in Excel attached.

Unique Product Code	Product Category	Checker
120	Shirt
121	Trousers
122	Pen
123	Mouse
124	Shoes
125	Lipstick

Table 2:

Product Category	Workers with knowledge to check Product Quality - 1	2	3	Time Taken to review quality in hours
Shirt	Adam	Brune		1
Trousers	Adam	Brune	Michael	1
Pen	Brune	Flora		0.25
Mouse	Dave	Adam		1.25
Shoes	Flora	Dave		2
Lipstick	Michael	Flora	Brune	0.5
Comb	Brune	Michael	Dave	0.1
Cooker	Charlie	Brune		2
Sofa	Flora	Dave		3
Pillow	Charlie	Dave		1.5

Any ideas?

Regards