Chapter 5: Network Design in the Supply Chain
Right click and save the Sun Oil Excel
demo to your hard drive.
If the demand in Asia doubles, what happens to the total cost and what is the best configuration of plants for Sun Oil under these conditions? Note: Use the “Solver” capability under the ”Tools” menu (but you need to change the demand for Asia in cell E9 from 16 to 32 prior to running “Solver”).
*Note on using the “Solver” Add-In:The Solver Add-in is an Excel add-in program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first. Instructions for doing so were included within the module.
