PLEASE INCLUDE EXCEL FORMULA AND IMAGES, PLEASE. $(15$ Points$)$ The Hernandez Electronics Corporation needs to transport $100$ units of their new smartphones

from their warehouse in San Diego to a retailer in New York at the lowest possible cost. The costs

associated with transporting $100$ units between various cities are provided in the following table:

To

a$.$ Write out the LP formulation of this problem. $($write it the long way please, laymans$)$

b$.$ What is the optimal solution? $($Formulate the mathematical model and solve it in Excel$)$ IT IS SUPPOSED TO BE FROM SAN DIEGO TO New York NOT San FRAN to Miami!!!!