Case Applichem the transportation problem:Applichem management is faced with the difficult problem of allocating to its customers the capacity of manufacturing plants that are located around the world

Case Applichem the transportation problem:Applichem management is faced with the difficult problem of allocating to its customers the capacity of manufacturing plants that are located around the world. Management has long recognized that 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 following questions.1)Evaluate the cost associated with the way Applichems plant capacity is currently being used.2)Determine the optimal use of Applichems plant capacity using the solver in excel3What would you recommend that Applicheem management do? Why?