Question

A firm produces three products: A, B, and C. Each requires 3 resources in the production process: 1, 2, and 3. There are 15,000, units of resource 1 available. There are 17,000 units of resource 2 available. There are 19,000 units of resource 3 available. Product A requires 4 units of resource 1, 3 units of resource 2, and 5 units of resource 3. Product B requires 7 units of resource 1, 6 units of resource 2, and 5 units of resource 3. Product C requires 6 units of resource 1, 5 units of resource 2, and 4 units of resource 3. Product A has a net per unit profit of $125, product B has a net per unit profit of $150, and product C has a net per unit profit of $225. We must make at least 500 units of each product. However, we must not make more than 1,200 units of each product. Including each specific equation, how many constraints are there in this problem as if you were using solver on excel? Group of answer choices:

a. 6

b. 12

c. 3

d. 9

Answer 1

A be resource 1, B be resource 2, C be resource 3

Constraints:

1. 4A + 3B + 5C <= 1200
2. 7A + 6B + 5C <= 1200
3. 6A + 5B + 4C <= 1200
4. 4A + 3B + 5C >= 500
5. 7A + 6B + 5C >= 500
6. 6A + 5B + 4C >= 500
7. A <= 15000
8. B <= 17000
9. C <= 19000
10. A >= 0
11. B >= 0
12. C >= 0

There are 12 constraints. Since it is mentioned that if we were using solver on excel, we choose the option " Make Unconstrained values non-negative" which saves us using the last 3 constraints. So I'll go with only 9 constraints for solver on excel. ( Choose 12 incase 9 is incorrect, this happens often whenever the question is made confusing about considering the binding constraints and moreover when a vague condition like "using solver" is given.)

Answer : OPTION D

PLEASE LEAVE A LIKE. IT REALLY HELPS ME A LOT. THANK YOU!!!