this is all the same problem. i dont expect you to do the Excel but this is dificult to track.

Klein Chemicals, Inc., produces a special oil-based material that is currently in short supply. Four of Klein's customers have already placed orders that together exceed the combined capacity of Klein's two plants. Klein's management faces the problem of deciding how many units it should supply to each customer. Because the four customers are in different industries, different prices can be charged because of the various industry pricing structures. However, slightly different production costs at the two plants and varying transportation costs between the plants/ and customers make a "sell to the highest bidder" strategy unacceptable. After considering price, production costs, and transportation costs, Klein established the following profit per unit for each plant-customer alternative. Plant Clifton Springs Danville D $32 $34 $34 $30 The plant capacities and customer orders are as follows. Plant Clifton Springs Danville n E D Customer 2 Capacity (units) 5,000 3,000 D3 $32 $28 D $40 $38 4 Distributor Orders (units) D D D Da 2,000 5,000 3,000 2,000 (a) How many units should each plant produce for each customer to maximize profits? Optimal Solution Clifton Springs-D Clifton Springs-D Clifton Springs-D3 Clifton Springs-D4 Danville-D Danville-D Danville-D Danville-D Total Cost Units (b) Which customer demands will not be met? Distributor 1 will have a shortfall of Distributor 2 will have a shortfall of Distributor 3 will have a shortfall of Distributor 4 will have a shortfall of $ $ $ $ $ $ $ $ $ Cost units. units. units, units. Model and linear programming formulation. (1) network model (Submit a file with a maximum size of 1 MB.) Choose File No fle chosen This answer has not been graded yet (i) linear programming formulation Let x number of units / shipped to client j, using the indices from the given table. (It may be necessary to combine plants or distributors in a single node in order to solve this problem. Use index number 5 for this type of node. Enter "DNE" in any unused answer blanks.) Max s.t. Orders from Clifton Springs Orders from Danville Orders from/for Dummy Node Orders for D Orders for D Orders for Dy Orders for Da x 20 for all i, j Klein Chemicals, Inc., produces a special oil-based material that is currently in short supply. Four of Klein's customers have already placed orders that together exceed the combined capacity of Klein's two plants. Klein's management faces the problem of deciding how many units it should supply to each customer. Because the four customers are in different industries, different prices can be charged because of the various industry pricing structures. However, slightly different production costs at the two plants and varying transportation costs between the plants/ and customers make a "sell to the highest bidder" strategy unacceptable. After considering price, production costs, and transportation costs, Klein established the following profit per unit for each plant-customer alternative. Plant Clifton Springs Danville D $32 $34 $34 $30 The plant capacities and customer orders are as follows. Plant Clifton Springs Danville n E D Customer 2 Capacity (units) 5,000 3,000 D3 $32 $28 D $40 $38 4 Distributor Orders (units) D D D Da 2,000 5,000 3,000 2,000 (a) How many units should each plant produce for each customer to maximize profits? Optimal Solution Clifton Springs-D Clifton Springs-D Clifton Springs-D3 Clifton Springs-D4 Danville-D Danville-D Danville-D Danville-D Total Cost Units (b) Which customer demands will not be met? Distributor 1 will have a shortfall of Distributor 2 will have a shortfall of Distributor 3 will have a shortfall of Distributor 4 will have a shortfall of $ $ $ $ $ $ $ $ $ Cost units. units. units, units. Model and linear programming formulation. (1) network model (Submit a file with a maximum size of 1 MB.) Choose File No fle chosen This answer has not been graded yet (i) linear programming formulation Let x number of units / shipped to client j, using the indices from the given table. (It may be necessary to combine plants or distributors in a single node in order to solve this problem. Use index number 5 for this type of node. Enter "DNE" in any unused answer blanks.) Max s.t. Orders from Clifton Springs Orders from Danville Orders from/for Dummy Node Orders for D Orders for D Orders for Dy Orders for Da x 20 for all i, j