Please help to advise a formular for this excel file, i want to allocate demand in a week :
i have headcount and Efficiency as below :
please help me advise 1 formulas or any ways to allocate demand , Allocate so that Q'ty of days is equal and efficiency as the table above , thank you so much :
397 | 166 | 65 | 65 | 59 | 22 | 20 | |
Item | Qty | 7/8/2024 | 7/9/2024 | 7/10/2024 | 7/11/2024 | 7/12/2024 | 7/13/2024 |
aa | 63 | 50 | 13 | ||||
bb | 82 | 70 | 12 | ||||
cc | 43 | 20 | 6 | 7 | 10 | ||
bb | 8 | 8 | |||||
aa | 14 | 6 | 8 | ||||
bb | 9 | 9 | |||||
bb | 12 | 12 | |||||
cc | 29 | 13 | 16 | ||||
dd | 31 | 14 | 17 | ||||
cc | 19 | 18 | 1 | ||||
cc | 19 | 19 | |||||
dd | 12 | 12 | |||||
aa | 12 | 12 | |||||
cc | 8 | 8 | |||||
dd | 12 | 12 | |||||
aa | 24 | 12 | 5 | 7 |
i have headcount and Efficiency as below :
Headcount | ||||
Line | Cell | Headcount | Efficiency | Working Hour |
2A02 | 2A021 | 10 | 45% | 10 |
2A02 | 2A022 | 12 | 50% | 10 |
2A02 | 2A023 | 12 | 45% | 10 |
2A02 | 2A024 | 12 | 45% | 10 |
2A02 | 2A025 | 12 | 47% | 10 |
please help me advise 1 formulas or any ways to allocate demand , Allocate so that Q'ty of days is equal and efficiency as the table above , thank you so much :
0 | 0 | 0 | 0 | 0 | 0 | ||||
Line | Cell | Item | Qty | 07/08 | 07/09 | 07/10 | 07/11 | 07/12 | 07/13 |
2A02 | 2A021 | aa | 0 | ||||||
2A02 | 2A021 | aa | 0 | ||||||
2A02 | 2A022 | aa | 0 | ||||||
2A02 | 2A022 | aa | 0 | ||||||
2A02 | 2A022 | bb | 0 | ||||||
2A02 | 2A023 | bb | 0 | ||||||
2A02 | 2A023 | bb | 0 | ||||||
2A02 | 2A023 | bb | 0 | ||||||
2A02 | 2A024 | cc | 0 | ||||||
2A02 | 2A024 | cc | 0 | ||||||
2A02 | 2A024 | cc | 0 | ||||||
2A02 | 2A024 | cc | 0 | ||||||
2A02 | 2A025 | cc | 0 | ||||||
2A02 | 2A025 | dd | 0 | ||||||
2A02 | 2A025 | dd | 0 | ||||||
2A02 | 2A025 | dd | 0 |