Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A small company has four employees who need to be assigned to four different tasks. Each employee has a different skill level and each task
A small company has four employees who need to be assigned to four different tasks. Each employee has a different skill level and each task requires a different level of skill. The table below shows the skill level of each employee and the required skill level for each task: \begin{tabular}{|c|c|c|c|c|} \hline & Task 1 & Task 2 & Task 3 & Task 4 \\ \hline Emp 1 & 7 & 4 & 6 & 9 \\ \hline Emp 2 & 5 & 8 & 7 & 6 \\ \hline Emp 3 & 9 & 6 & 5 & 4 \\ \hline Emp 4 & 4 & 9 & 8 & 7 \\ \hline \end{tabular} Each employee can only be assigned to one task and each task can only be assigned to one employee. The goal is to assign employees to tasks in such a way that the total skill level required is minimized. Insert a new worksheet, and rename it to "Question 1LP ". Set up the LP in that sheet and solve it using the Excel solver. a. Link to the cell in your worksheet "Question 1LP " that contains the optimal value of the objective function. b. Write the task that you assigned to each employee (Only the number is enough, e.g., Task 1 -> 1) Emp 1 Emp 2 Emp3 Emp 4
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started