Stat week 8

Purpose

To assess your ability to apply linear programming to transportation problems.

Action Items

1. Read the Transportation System case.

2. Answer the following items concerning the Transportation System case:

1. What is the transportation company trying to optimize? Are they trying to maximize or minimize?

2. Write the objective function to support this analysis.

3. What inputs do you need to support your analysis?

4. Is there any extraneous data you have been given that you will not need?

5. What criteria has the transportation company given you to support the analysis?

Create a spreadsheet model that supports your analysis.