Solve using solver showing the all formula for objective function, Decision Variables and constraints

Restoration of the electrical grid after a hurricane is an enormous challenge. After Hurricane Ian, Duke Energy dispatched 40,000 and 10,000 crews to Florida and North Carolina, respectively. These additional crews are dispatched from the South, West, Midwest, and East regions. The P3-Duke-Energy worksheet contains: a) The cost of dispatching crews. b) The number of available crews. c) The number of crews needed. Duke Energy implemented a policy for the Midwest Region. Specifically, at most 75% of crews may be dispatched from the Midwest region to Florida.

1) Using proper spreadsheet modeling principles, find the optimized crew distribution plan and its corresponding cost for Duke Energy.

2) Interpret the sensitivity report of the solution. Specifically, a. Point out if there is an alternate solution b. Report on the shadow prices of the constraints. How is this information useful? c. Report on the reduced costs of the decision variables. How is this information useful?

Parameters \begin{tabular}{|r|c|c|c|} \hline & \multicolumn{2}{|c|}{ Crew Dispatch Costs } \\ \hline From/To & Florida & North Carolina# of Crews Available \\ \hline South Region & $2,750 & $3,500 & 15,000 \\ \hline West Region & $3,200 & $2,800 & 20,000 \\ \hline Midwest Region & $3,500 & $3,400 & 20,000 \\ \hline East Region & $4,200 & $4,100 & 25,000 \\ \hline # of Crews Needed & 40,000 & 10,000 & \\ \hline Crew Limitation & 75% & & \\ \hline & 15,000.00 & & \\ \hline \end{tabular} Parameters \begin{tabular}{|r|c|c|c|} \hline & \multicolumn{2}{|c|}{ Crew Dispatch Costs } \\ \hline From/To & Florida & North Carolina# of Crews Available \\ \hline South Region & $2,750 & $3,500 & 15,000 \\ \hline West Region & $3,200 & $2,800 & 20,000 \\ \hline Midwest Region & $3,500 & $3,400 & 20,000 \\ \hline East Region & $4,200 & $4,100 & 25,000 \\ \hline # of Crews Needed & 40,000 & 10,000 & \\ \hline Crew Limitation & 75% & & \\ \hline & 15,000.00 & & \\ \hline \end{tabular}