othlem $2$

including intermediary distribution centers $x$ and $Y$ as shown in the figure and using the given network, will the impany save money in its transportation costs compared to the results obtained in problem $1?($Note: For any two ven nodes, a directed arrow represents an existing route between the two nodes.$)$

a$)$ Write the mathematical formulation of the problem.

b$)$ Use the Excel Solver to solve the problem, Generate the knswer and sensitivity reports in Excel, and submit your Excel worktoak as a separate atrachment.

c$)$ Provide the solution obtained in the space pravided. What is the optimal cost of transportation? Will the transpertation cossts be reduced after the intermediate points have been included? how do I set this up in solve