Using Ms Excel Solver

A baking firm can produce a specialty bread in either of its two plants, as follows: Four restaurant chains are willing to purchase their bread; their demands and the prices they are willing to pay are as follows: The cost (in cents) of shipping a loaf from a plant to a restaurant chain is given in the following table: Determine a delivery schedule for the baking form that will maximize its total profit from this bread