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. This is something that you will have to find from your own computer. Since most students own and operate a variety of different computers with different software versions, it’s literally impossible for me to write cogent instructions for everyone. Instead, I have the generic outline for MS Office 2018 PC version. Mac maybe different and you can look at YouTube videos to get going.

Sample Solution

This question has been answered.

Get Answer