QUESTION 1 Excel Solver can be used to solve linear programming problems. However, it cannot be used to solve binary integer programming problems. True False QUESTION 2 Let X and Y denote whether or not to build a factory in Japan and China, respectively. Suppose that X and Y are both binary variables. Suppose that the factory in Japan can produce up to 1000 units of IC chips if it is to be built. Let z be the number of IC chips to be produced in Japan. Which of the following constraints can be used for the capacity constraint in Japan? O Zs 1000x O Zs 1000 OXZs 1000 None of the Above QUESTION 3 1 2 5 Based on discrete available-to-promise (ATP) logic, how many units are available-to-promise in period 3 based on the master production schedule (MPS) schedule provided below? Period Forecast 25 15 25 15 10 Orders 18 20 20 10 10 Projected aynilable balance initial 15 units) Amilable to-promise (discrete) Master production schedule 60 50 O 10 O 25 O None of the above QUESTION 4 4 5 15 Period 123 Forecast 25 25 15 10 Orders 18 20 20 1010 Projected available balance initial 15 units) Amiable-to-promise (discrete) Master production schedule 50 Based on the table from the previous question, calculate the projected available balance in period 3. O 30 O 35 045 None of the above