To be solved in excel and need step wise explanation for all the questions asked

3) A blood bank wants to determine the least expensive way to transport available blood donations from Pittsburgh and Staunton to hospitals in Charleston, Roanoke, Richmond, Norfolk, and Suffolk. The supply and demand for donated blood is shown in the figure along with the unit cost of shipping along each possible arc. FIGURE 5.36 Neteverk flowe madel for the Hood hank prokelem A. Provide the complete linear programing formulation. Clearly specify decision variables, objective function and constraints. B. Create a spreadsheet model for the problem and use Solver to find the oprtimal solution. Separate input data from calculations. Include all the input data provided in the Word problem and use Excel to perform calculations. a) Provide a screenshot of the model. Use '=FORMULATEXT' to show the calculation for the objective function and the left hand side of the constraints. A. Provide the complete linear programing formulation. Clearly specify decision variables, objective function and constraints. B. Create a spreadsheet model for the problem and use Solver to find the optimal solution. Separate input data from calculations. Include all the input data provided in the Word problem and use Excel to perform calculations. a) Provide a screenshot of the model. Use '=FORMULATEXT' to show the calculation for the objective function and the left hand side of the constraints. b) Provide a screenshot of the Answer Report including the top section with the log from Solver. C. What is the optimal transportation plan for the blood bank? What is the minimum total shipping cost? Communicate the recommendation in plain English. It is acceptable to use tables for clarity