Assignment Problem in Excel Using Solver

How do you set up the assignment problem step by step?

Lay out the cost matrix (workers × tasks). Mirror it with a blank binary matrix for decisions. Total cost = SUMPRODUCT(costs, decisions). Add row-total and column-total cells. In Solver: Set Objective to total cost, To Min, By Changing the binary cells, subject to binary constraints plus row sums = 1 and column sums = 1, solving method Simplex LP. Solve and keep the solution.

• 1Cost matrix + mirrored binary decision matrix
• 2Objective: =SUMPRODUCT(costs, decisions), minimize
• 3Constraints: decisions binary; each row = 1; each column = 1
• 4Method: Simplex LP (not GRG Nonlinear)
• 5Answer + Sensitivity reports for the submission appendix

Solver assignment due? Get the model built and explained.

LP models, transportation problems, and Goal Seek sensitivity tasks are solved with a documented model — constraints listed, reports attached, method explained — from $15/hr through our Excel assignment help service.