Chapter $6-$ Burlingham Textile Co$.$ Case.

This is an assignment problem with $10$ applicants and $5$ positions. Determine the optimal assignments that Brenda Last should make. Use the data to determine the optimal assignments, but do not complete questions in the last two paragraphs of the text

Formulate a linear programming model for this problem. $(20$ points$).$

List the objective function $($minimize or maximize$)$ and all model constraints.

Solve problem using MS Excel$$s Solver or Excel QM or QM for Windows. $(20$ points$).$

Hint: Use the $$integer$$ constraint

Highlight the "winning" cells

This question is an assignment maximization problem $($hint$).$ However, the Assignment Model could be used to minimize. In what circumstances would you $($or could you$)$ use the Assignment Model to minimize? Give an example. $(10$ points$).$

$4.$ Submit the Excel Solution and your response to $3.$ in Canvas.