operational research linear programming

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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.

it is simple task, I have the map and grouped the location. Please if you are serious and motivated, chat with me. I need the task to be finished in 1 day

Excel Linear Programming

Project ID: #16907987

About the project

10 proposals Remote project Active 5 years ago

Awarded to:

engrmaliksultan

i will do the project 8888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888888 More

$66 USD in 1 day
(11 Reviews)
3.4

10 freelancers are bidding on average $47 for this job

schoudhary1553

Hi there..... Warm Greetings We came along with your request for operational research linear programming and we reviewed your project description. We'd like to help you with confidence and satisfying results... More

$50 USD in 2 days
(303 Reviews)
7.9
Developer000

I am here freelancer first to discuss the details of operational research linear programming then i can sure about my price and the deadline. My way of working is not only to complete but also to provide enough und More

$30 USD in 1 day
(15 Reviews)
4.7
Valuesolutions

Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things

$133 USD in 2 days
(6 Reviews)
3.9
Nicecreator

Hi there, i understand your requirement and can do the work perfectly using my outstanding experience. Please award me the project so that we discuss it more Thank you.

$25 USD in 1 day
(11 Reviews)
3.6
Narula7

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
0.0
Afrimidrizi

Hello sir I am a civil engineering working in a building company that have a lot of daily calculation, so i spnd a lot of timeand doing my calculation in excel also. For more details please contact me

$45 USD in 3 days
(0 Reviews)
0.0
talqershi

A proposal has not yet been provided

$55 USD in 2 days
(0 Reviews)
0.0