Find the optimal solution $($C$)$ using Excel Solver.

Profit

New York

Fort Worth

San Diego

Minneapolis

Boulder

Macon

Gary

Total profit

$($D$)$

Question $19$ options:

a$)$

$4,240,000$

b$)$

$5,210,000$

c$)$

$8,170,000$

d$)$

$6,510,000$