please show complete text answers and solutions in excel. using excel solver. thank you!

1. A food distribution company ships fresh spinach from its four packing plants to large East-coast cities. The shipping costs per crate, the supply and demand are shown in the table below. (Problem 5-18 in the textbook) MARKETS Packing Plants Atlanta Boston Charlestown Dover Supply Eaglestown $6.00 $7.00 $7.50 $7.50 8,000 Farrier $5.50 $5.50 $4.00 $7.00 10,000 Guyton $6.00 $5.00 $6.50 $7.00 5,000 Hayesville $7.00 $7.50 $8.50 $6.50 9,000 Demand 8,000 9,000 10,000 5,000 (a) formulate a model that will permit the company to meet its demand at the lowest possible cost. (b) the company wishes to spread out the source for each of its markets to the maximum extent possible. To accomplish this, it will accept a 5% increase in its total transportation cost from part (a). What is the new transportation plan, and what is the new cost