This paper circulates around the core theme of Formulate and solve an IP model in the given spreadsheet shell to help this company solve its plant and warehouse location problem. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
A company manufactures one if its most popular products at five
different plants. The capacity (in tons) of each plant is given in the
file GS 4.xlsx. The cost per ton of manufacturing this product at each
plant and shipping it to each warehouse is also given in GS 4.xlsx. This
company has four major customers. The cost of shipping a ton of the
product from each warehouse to each customer is provided in GS 4.xlsx.
Each customer must receive the amount (in tons) of the product given in
GS 4.xlsx. The annual fixed cost of operating each plant and warehouse
is also recorded in the given Excel worksheet. The company’s goal is to
minimize the annual cost of meeting all customer demands. The company
wants to determine which plants and warehouses to open, as well as the
optimal shipping plan. Formulate and solve an IP model in the given
spreadsheet shell to help this company solve its plant and warehouse
location problem