solver and solvertable ms excel

The purpose of this assignment is to introduce how network models can be used to solve a business problem.

Using specified data files, and complete Problems 17(with solverTable), and 88. Use Microsoft Excel’s Solver Add-In to complete these problems.

17. In the RedBrand template, the costs for shipping_from plants or warehouses to customer 2 (Node 7) were purposely made high so that it would be optimal to ship to customer 1(node 6) and then let customer_1 (node 6) ship to customer 2 (node 7). Use SolverTable appropriately to do the following. Decrease the unit shipping costs from plants and warehouses to customer 2 (node 7), all by the same amount, until it is no longer optimal for customer 1 to ship to customer 2. Describe what happens to the optimal shipping plan at this point.

88. An oil company produces oil from two wells. Well_1 can produce up to 150,000 barrels per day, and well 2 can produce up to 200,000 barrels per day. It is possible to ship oil directly from the wells to the company’s customers in Los Angeles and New York. Alternatively, the company could transport oil to the ports of Mobile and Galveston and then ship it by tanker to New York or Los Angeles, respectively. Los Angeles requires 160,000 barrels per day, and New York requires 140,000 barrels per day. The costs of shipping 1000 barrels between various locations are shown in the file P14_88.xlsx, where a blank indicates shipments that are not allowed. Determine how to minimize the transport costs in meeting the oil demands of Los Angeles and New York.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.