Please solve the Question, using the Excel Template!

Question 4. (17 points) See the next page for the Excel worksheet for the formulation of the APP as a transportation problem. Provide the formula for the following cells, using the cell addresses provided on the worksheet: (a) [lpt] cell E17 (total cost formula): (b) [lpt] cell L3: (c) [1pt] cell J15: (d) [14pt] You want to use Excel Solver for the transportation problem to minimize the total cost. Complete the following underlined components of the Solver using the correct cell references from the Excel worksheet: [lpt] Set Objective: Cell reference [lpt] To (choose one, mark by X): Max --- Min --- Value of --. [3pt] By Changing Variable Cells: Cell reference [6pt] Subject to the Constraints:(Write down ALL the constraints below using Excel cell references) [lpt] Make unconstrained variables non-negative (choose one, mark by X ) Check: ---- Do Not Check:-- [1pt] Select a Solving Method (choose one, mark by X): Simplex LP GRC Nonlinear Evolutionary [1pt] Clearly explain your choice of the solving method