J$12$

A

B

C

D

E

F

G

H

$1$

J

K

L

M

N

$4.$ Excel Solver solution for this transportation problem $(25$ pts $)$

a$.(10$ pts$)$ Formulate the colored cells.

b$.(15$ pts$)$ Solve the problem using Solver.

$\backslash$table$[[$From$,$Los Angeles,New York,Production capacity$],[$Atlanta$,$$$14,,600],[$Tulsa$,800,100,900$

Please show each step in detail and what formula to put in for each answer!!