Question: use excel , this is OR 2 7 Points Question 1 Using Excel (Solver) A company can produce 2 products. Product A1 has a profit
use excel , this is OR 2
7 Points Question 1 Using Excel (Solver) A company can produce 2 products. Product A1 has a profit of 300, it takes 2 units of raw materials to produce it. Product A2 has a profit of 360, it takes 3 units of raw materials to produce it. The company has currently 5000 units of raw material. For production of a type of product to be economically feasible, at least 1600 products of that type must be produced. The company is trying to maximize their total profits for the coming period. Choose all the correct answers: A The number of decision variables is 2 B This problem is from the Either-Or problem family The optimal solution z is equal to 675 thousands In this problem we used Big M, an acceptable value for Big M would be 1000 The optimal solution includes producing over 2000 products of A1
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
