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.

Plant$/$Customer Mesquite

Furniture

Tonopah Fashions Sumerlin

Appliance

Charleston

Furnishings

Bruderheim $$1\mathrm{.}70$ $$2\mathrm{.}30$ $$2\mathrm{.}40$ $$2\mathrm{.}15$

Cardston $$1\mathrm{.}95$ $$2\mathrm{.}35$ $$1\mathrm{.}65$ $$3\mathrm{.}55$

Exact Customer

demand$/$week

$($cases$)$

$1200150025001400$

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

$3600$ cases per week.

A$.$ Derive the minimum cost shipping plan.

B$.$ Mesquite Furniture is experiencing some financial problems. If Mesquite were to reduce its

order to $1000$ cases, how would the minimum cost shipping plan change?

Can you please do this in excel form?