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

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

2. Solve problem using MS Excels Solver (20 points).

Hint: Use the integer constraint

Highlight the "winning" cells in Excel

CASE PROBLEM 289 Test Module Scores Applicant Carding Spinning Weaving Inspection Shipping Roger Acuff Melissa Ball Angela Coe Maureen Davis Fred Evans Bob Frank Ellen Gantry David Harper Mary Inchavelia Marilu Jones 68 73 92 87 58 93 75 82 101 98 62 79 92 66 102 75 72 66 90 75 93 94 90 90 95 86 78 79 90 81 92 78 85 74 92 75 96 93 86 88 93 77 79 91 72 81 85 90 93 67 offer the vacant positions to the five Hidates. Determine an optimal assign- third applicant be selected if three of the job offers were declined? CASE PROBLEM 289 Test Module Scores Applicant Carding Spinning Weaving Inspection Shipping Roger Acuff Melissa Ball Angela Coe Maureen Davis Fred Evans Bob Frank Ellen Gantry David Harper Mary Inchavelia Marilu Jones 68 73 92 87 58 93 75 82 101 98 62 79 92 66 102 75 72 66 90 75 93 94 90 90 95 86 78 79 90 81 92 78 85 74 92 75 96 93 86 88 93 77 79 91 72 81 85 90 93 67 offer the vacant positions to the five Hidates. Determine an optimal assign- third applicant be selected if three of the job offers were declined