Q. Case Applichem the transportation problem:
Applichem management is faced with the difficult problem of allocating to its customers the capacity of manufacturing plants which are located around the world. Management has long recognized which the manufacturing plants differ greatly in efficiency but has had little success in improving the operations of the inefficient plants.
These are the answers I am looking for.
Given all these data, set up a spreadsheet ( Applichem is a start) and answer the subsequent questions.
1) Evaluate the cost associated with the way Applichems plant capacity is currently being used.
2) Find out the optimal use of Applichems plant capacity using the solver in excel
3) Illustrate what would you recommend which Applicheem management do? Explain why?