PROBLEM: You should ANSWER this question ON an A4 sheet by indicating "PROBLEM X", where X is the question number in your online exam. e If you have attempted this question, select YES in the drop-down menu Ryan is an electronics company with production facilities in Denver and Atlanta. Components produced at either facility may be shipped to either of the firm's regional warehouses, which are located in Kansas City and Louisville. From the regional warehouses, the firm supplies retail outlets in Detroit, Miami and Dallas. The data (in bold font) and optimal solution of the transshipment problem for Ryan Electronics are shown in the EXCEL screenshot below. A D G H - 1 Ryan Electronics - Transshipment Problem 2 3 4 5 6 FLOW CONSTRAINTS Denver 400 Atlanta 300 explanations = 200 inflow>=demand >= 150 inflow>#demand >= 350 inflow>=demand Total Cost $3,450 a) (8 points) Write down the FORMULAS for the following cells: G5- G8- G11- G15- b) (5 points) Also fill out the "Solver Parameters" screen below. Solved Parameters b) (5 points) Also fill out the "Solver Parameters" screen below. Solver Parameters Ses Objective: To: Max MO Value of: By changing Variable Cells: Subject to the Constraints: Add Change Delete Beset Al Load/Save Malge Unconstrained variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close c) Please briefly explain how will you modify your problem formulation in part (b). D (3 points) If profit.per unit shipments are given instead of the cost values (.e., in cells C4:C13) ID (3 points) if there are flow limits of 200 units for each route. HD) (3 points) if no shipment is allowed between Kansas City and Dallas