Solver Parameters Ses Objective: To: Max value of: By Changing Variable Cels: Subject to the Constraints: Add Change Delete Beset Al Load/Save Maige 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 Olgue 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 (I.e. In cells C4:013) ii) (3 points) if there are flow limits of 200 units for each route. iii) (3 points) if no shipment is allowed between Kansas City and Dallas, iv) (3 points) if direct shipment between Atlanta and Detroit (with 35/unit cost) is allowed. 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 facillty 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. H explanations 200 inflow> demand > 150 inflow>=demand > 350 inflow-demand GB- G11- G15 b) (5 points) Also fill out the "Solver Parameters" screen below