Roles assignment

Introduction

In jobs where people who can accomplish the jobs are available, factors considered could be the price for each individual to complete the job, the individual’s job completion rate for that job, the skill level of the individual for that job or whether or not the individual is fit for the specified job. So to that end, this project is conducted to assign jobs to someone with the same skill set and trying to minimize the total cost of hiring the workers.

Roles assignment: Text

Problem statement

There are 4 jobs and up to 10 workers each with their own role. The jobs are a data analysis job, web development job and digital marketing job which requires workers with their skill set. The 4th job is a creative job which can be done by a combination of individuals from the three skill set.

Tool used

Since this was an optimization problem, solver add-in in Microsoft excel was used for the formulation of the model while Microsoft word was used for its detailed explanation.

The solution.

The following parameters were used for the formulation of the solution.

The objective function: This is what we are trying to achieve. This is the least minimum cost of hiring the individuals for the jobs. It is the sum product of the price and the individuals chosen for the jobs.

Decision variables: This is the number that changes to achieve the optimal solution to our objective function. In this case, it is the individual selected for a particular job.

Feasibility regions: This are possible regions in our model. In this model, a data analyst cannot do a digital marketing job or a web development job. Same goes for a web developer and a digital marketer. A data analyst, web developer and a digital marketer can do the job that requires a creative role.

Constraints: These are conditions set prior to formulating the model. These include

The least amount of individuals required per job had to be met
The variables should be binary which is one to depict the individual been chosen for the job and zero to depict otherwise.

Conclusion

In conclusion, the model optimized the cost and the total cost of hiring the individuals amounted to $20 which was the least cost of hiring the individuals for the specified number of jobs and its specified requirement of workers. The details of the model alongside it’s answer report it’s specified in the excel file below.

Excel file with solver