Decision Optimization

 View Only
  • 1.  Resource Allocation Modelling Assistant Constraints

    Posted Tue May 10, 2022 11:00 AM
    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
    ------------------------------


  • 2.  RE: Resource Allocation Modelling Assistant Constraints

    Posted Mon May 16, 2022 09:12 AM
    Hi Trisha,

    I wonder if this is really a Resource Allocation or a Scheduling with assignments. I mean, what is the optimization objective? Is the goal to have all projects completed as soon as possible? Also, does it matter in which order Projects are completed? When assigning multiple employees to a project, are they working together in parallel or one after another? Are employees working on a single project at a time? Are they working on a particular project all their allocated time for the project and then switch to another project or they can go back and forth between projects?

    ------------------------------
    Tymoteusz Gedliczka
    ------------------------------



  • 3.  RE: Resource Allocation Modelling Assistant Constraints

    Posted Mon May 16, 2022 09:21 AM
    Please also explain what is the relationship between Project's "Total Hours" and "Days". It's unclear to me.
    For example in row 4, should the effort of 41 hours be spread evenly across all 115 days (about 0.35h per day)?

    ------------------------------
    Tymoteusz Gedliczka
    ------------------------------