Description of the problem:
- 50 Offices of a Company spread in country region.
- 90 New employees
- each location has specific numbers of tasks.
- each employee can assigned a 24 tasks as max
- in case one location has less than 24 tasks then the employee is allow to share more than one location to reach 24 tasks.
We need to allocate these new 90 employees to the 50 Locations keeping in mind the following:
1- We need to take into consideration their location preference and their living area during the distribution of employees.
2- One of the constrains is that we need to make sure that all the employee should have Max load of work which is 24 tasks. in some locations maybe one location will have 12 tasks so we need to let that employee share two location in order to complete 24 Tasks.
3- when sharing locations we need to make sure that the employee is not assigned more than 3 locations and have not more than 24 tasks assigned. all the sharing location should be near to each other and the employee should not drive more than one hour.
4- Special cases is for the female employees, if they are expecting to have a Maternity leave which is 3 months off duty. This should be implemented in the model so that we can expect and predict the time when we will face the shortage ahead of time to cover that female location.
The objective is to solve the problem by building Mathematical Linear Programming model:
1- Formulating the model with Objective function, Decision variable, and Constraints.
2- Solving the model with Excel and Gums Software.
3-Documentation - writing and explain the problem and the strategy of solving as a report.
Develop a mathematical model of the problem that can be used to determine the right employee to the appropriate location based on the preferences and company needs.
11 freelancere byder i gennemsnit $111 på dette job
Hi, I am an operational research engineer. I have worked with LINDO, AMPL, and excel solver before and I'm available to complete this project in 3 days. Waiting to hear from you. Regards.
Hello, your project seems very interesting, I would like to know more about your project. I have extensive experience in the area of operations research, I also handle both Excel and Gams