(b) Determine the locations that need cars
c) make a "transportation model" similar to the one discussed in the live session. Explain what your variables mean, and what each of the constraints specify. Attach your spreadsheet formulation as Exhibit B. Please note that your spreadsheet must be sufficiently annotated so that it is readable in order to receive credit. See note earlier regarding printing Solver dialog box and solver model with formulas.
(d) What is the value of the objective function after optimization?
(e) Explain in detail the movement plan to get cars from locations with excess supply to
locations that are in deficit.