Problem $15-7($Algo$)$

Bindley Corporation has a one$-$year contract to supply motors for all washing machines produced by Rinso Ltd$.$ Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location:s problem.

b$.$ Find the optimal solution using Microsoft Excel. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required$)$

c$.$ Find the profit