Decision $2.$

Penny Chairs has two plants that manufacture and ship chair parts to other manufacturers. Penny Chairs

sells and ships to four manufacturers. The cost of shipping one chair from a plant to a customer is given

in the following table.

The plant in Bruderheim has a capacity of $3500$ cases per week, and the Cardston plant can produce

$4000$ cases per week.

A$.$ Derive the minimum cost shipping plan.

B$.$ Tonopah Fashions is experiencing some financial problems. If Tonopah were to reduce its order

by $1000$ cases, how would the minimum cost shipping plan change? C$.$identify and show how you would set up the objective function, decision varibles, and constraints in an excel table before trying to solve linear programming