Hello,
I need someone advice how to calculate workload of employee if with one customer works two employees.
How to manage relationship between one customer and two employes. And how to calculate total work load of employee B and F
My exmaple bellow
| | | | | | |
| Customer | Order lines | Employee no.1 | Employee no.2 | | |
| XXX | 10 000 | A | B | | |
| ZZZ | 1000 | B | | | |
| VVV | 1000 | B | | | |
| FFF | 2000 | C | | | |
| LLL | 2000 | D | | | |
| WWW | 12 000 | E | F | | |
| DDD | 1000 | F | | | |
| HHH | 100 | F | | | |
| MMM | 100 | F | | | |
| | | | | | |
| Customer | Employee | Empl. Work with customer, coefficient % | | | |
| XXX | A | 80% | | | |
| XXX | B | 20% | | | |
| VVV | B | 100% | | | |
| FFF | C | 100% | | | |
| LLL | D | 100% | | | |
| WWW | E | 80% | | | |
| WWW | F | 20% | | | |
| DDD | F | 100% | | | |
| HHH | F | 100% | | | |
| MMM | F | 100% | | | |
| If one employ works with 3 and more customers, for his workload top must be added 20%; if with 4 - 30%, if with 5 - 40% |
