Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination.

a$.$ Develop a transportation grid for this problem.

$\backslash$table$[[$From$/$To$,$New York City,Fort Worth,San Diego,Minneapolis,Supply$],[$Boulder$,10,8,14,18,90,000],[$Macon$,20,10,12,7,95,000],[$Gary$,12,10,12,19,120,000],[$Requirements$,40,000,70,000,75,000,60,000,]]$

b$.$ Find the optimal solution using Microsoft Excel.

Note: Leave no cells blank $-$ be certain to enter $"0"$ wherever required.

$\backslash$table$[[$Bindley Plant Types,,,,$],[$Boulder$,,,,],[$Macon$,,,,],[$Gary$,,,,]]$