Hi Everyone,
I'm trying to create a resource allocation plan that assigns employees(up to the max number specified in my data) to projects within their own departments. Each project has a total number of hours it will take to complete. The total hours to complete the project should be divided between the employees assigned to the project, but the hours they work a day on it should not exceed their daily working hours (8).
Each employee should have multiple projects and each project should have multiple employees with the work divided between them.
I've been able to assign employees to projects within their own department, and even have multiple employees assigned to projects. However, while I have the total number of hours in my spreadsheet, I'm unable to figure out a constraint or condition within my Resource Allocation project that will divide these total hours between the different employees.
I am using the modelling assistant for this and for now, a very small dataset. Would anyone be able to help me with this? I've attached screenshots of my datasets below
------------------------------
TT
------------------------------
#DecisionOptimization