5. A company will begin stocking remote control devices. Expected monthly demand is 800 units. The controllers can be purchased from either supplier A or supplier B. Their price lists are as follows: Supplier A Quantity Unit Price* 1 - 199 $14.00 200 - 499 $13.80 500 - 1000 $13.60 Supplier B Quantity Unit Price* 1 - 149 $14.10 150 - 349 $13.90 350 - 600 $13.70 The fixed ordering cost for Supplier A is $400 and has a capacity to supply up to 1000 units per month. The fixed ordering cost for Supplier B is $300 an has a capacity to supply up to 600 units. The objective is to minimize the total cost of purchasing (fixed plus variable costs). a. Formulate this problem as a linear integer programming problem and find an optimal solution using Excel solver. (Assume an all-units discount offering from the suppliers) b. Formulate this problem as a linear integer programming problem and find an optimal solution using Excel solver. (Assume a graduated discount offering from the suppliers) 5. A company will begin stocking remote control devices. Expected monthly demand is 800 units. The controllers can be purchased from either supplier A or supplier B. Their price lists are as follows: Supplier A Quantity Unit Price* 1 - 199 $14.00 200 - 499 $13.80 500 - 1000 $13.60 Supplier B Quantity Unit Price* 1 - 149 $14.10 150 - 349 $13.90 350 - 600 $13.70 The fixed ordering cost for Supplier A is $400 and has a capacity to supply up to 1000 units per month. The fixed ordering cost for Supplier B is $300 an has a capacity to supply up to 600 units. The objective is to minimize the total cost of purchasing (fixed plus variable costs). a. Formulate this problem as a linear integer programming problem and find an optimal solution using Excel solver. (Assume an all-units discount offering from the suppliers) b. Formulate this problem as a linear integer programming problem and find an optimal solution using Excel solver. (Assume a graduated discount offering from the suppliers)