(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.
Recently Asked Questions
- During October and November 2008 , gasoline prices were falling dramatically making travel by car less expensive but air travel prices were as high as ever .
- An improvement in the weather led to an increase of 40 % in the size of the corn crop . The demand curve for corn did not change . The price of corn fell by 20
- Table : Pumpkin Market There are two consumers , Andy and Ben , in the market for pumpkins . Their willingness to pay for each pumpkin is shown in the table