=E*7.17. Noble Amazon sells books online. Management is trying to determine the best sites for the companys
Question:
=E*7.17. Noble Amazon sells books online. Management is trying to determine the best sites for the company’s warehouses. Five potential sites are under consideration. Most of the sales come from customers in the United States. The average weekly demand from each region of the country, the average shipping cost from each warehouse site to each region of the country, the fixed cost per week of each warehouse if it is operated, and the maximum capacity of each warehouse (if it is operated) are shown in the table below. Formulate and solve a mixed BIP model in a spreadsheet to determine which warehouse sites Noble Amazon should operate and how books should be distributed from each warehouse to each region of the country to minimize total cost.
Step by Step Answer:
Introduction To Management Science A Modeling And Case Studies Approach With Spreadsheets
ISBN: 9780078096600
4th Edition
Authors: Frederick S. Hillier And Mark S. Hillier