Using a linear programming framework and the data from case Exhibit 1, formulate and solve the problem
Question:
Using a linear programming framework and the data from case Exhibit 1, formulate and solve the problem of finding the cost-minimizing set of bids that meet Mars' business requirements and determines the winning suppliers. (Ignore the requirement that first bid wins in the case of ties.
Q2. In hypothesis, Mr. Ng wants to compare the solution in Q1 to other solutions in different conditions. If the following constraints are newly set in place, answer how much different is going to be from the original cost respectively. 1. If Mr. Ng ignores the condition "Mars did not want to become dependent on just a few suppliers" and rather chooses as a few suppliers as possible. 2. If Mr. Ng allows each supplier only to win at most one bid. Show 2 different calculation sheets and discuss.
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier