Question

How to solve using Excel Solver: 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

1. Formulate a linear programming model for this problem.

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

2. Solve problem using MS Excel’s Solver

Hint: Use the “integer” constraint

Highlight the "winning" cells in Excel

3. 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.

   	Test Module Scores
   Applicant	Carding	Spinning	Weaving	Inspection	Shipping
   Roger Acuff	68	75	72	86	78
   Melissa Ball	73	82	66	78	85
   Angela Coe	92	101	90	79	74
   Maureen Davis	87	98	75	90	92
   Fred Evans	58	62	93	81	75
   Bob Frank	93	79	94	92	96
   Ellen Gantry	77	92	90	81	93
   David Harper	79	66	90	85	86
   Mary Inchavelia	91	102	95	90	88
   Marilu Jones	72	75	67	93	93

Answer 1