Consider the following transportation problem data for Baker Industries (these data are available in the Excel worksheet Baker Industries on MindTap): 

Use the techniques explained in Supplement E: The Transportation Problem to address the following:

a. Formulate the linear optimization model to minimize total cost.
b. Implement your model on a spreadsheet and use Excel Solver to find an optimal solution.
c. How would the optimal solution differ if we must ship 150 units on the Tucson to San Diego route? Explain how
you can modify the model to incorporate this new information.

Transcribed Image Text:

Plant San Jose Las Vegas Tucson Demand Los Angeles $4 $8 $14 200 Distribution Center San Francisco $10 $16 $18 300 San Diego $6 $6 $10 200 Supply 100 300 300