Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Exploring Management

Authors: John R. Schermerhorn, Daniel G. Bachrach

7th Edition

1119704189, 9781119704188

More Books

Students also viewed these General Management questions