Solve problem using excel solver to find optimal assignment


A company has four jobs (A, B, C and D) that it wishes to assign to four machines
(W, X, Y and Z). Only one job can be assigned to each machine. The cost of assigning these jobs to each machine are as shown below:

Machine

W X Y Z
A 3 8 9 4
Job B 4 5 7 2
C 1 6 9 9
D 10 11 9 10

(a) Model the problem of as a linear program by clearly specifying the decision variables, objective function and the constraints.

(b) Solve the problem using Excel Solver to find an optimal assignment.

(c) Model the problem as a transportation model and get an initial solution

(d) Find an optimal solution starting from the initial solution in part (c)

(e) What is the increase in cost if the job D has to be assigned to Machine X for a technical reason.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Solve problem using excel solver to find optimal assignment
Reference No:- TGS076161

Expected delivery within 24 Hours