What is the constraint associated with Plant 2 for the existing set of plants and regional...

Correct answer is (This constraint describes capacity constraint of plan B)

Let,In this case, Decision variables have been identified as,

xij = number of units shipped from plant i to regional center j where i = {1,2,3,A=4} and j = {Philadelphia = P,Atlanta=A,Dallas=D,Los Angeles=L}

------------------------------------------------------------------------------------------------------------------------------------------------------

For your reference please find the solution below

With Plant A,

Let,

xij = number of units shipped from plant i to regional center j where i = {1,2,3,A=4} and j = {Philadelphia = 1,Atlanta=2,Dallas=3,Los Angeles=4}

Spreadsheet model

Formula used

Solver window input

Solving in solver we get following optimal schedule

Minimized cost = 148350

With Plant B,

Spreadsheet model

Formula used

Solver window input

Solving in solver we get following optimal schedule

Minimized cost = 148550