In: Statistics and Probability
Grade |
Grade |
Grade |
Available |
|
A |
B |
C |
Resources |
|
Labor hours |
4 |
4 |
5 |
80 hr |
Raw material #1 |
200 |
300 |
300 |
6,000 kg |
Raw material #2 |
600 |
400 |
500 |
5,000 kg |
Formulate as an LP problem to maximize profit. What mix of products would yield maximize profit? (Use excel solver to find the optimal solution).
Objective function
Maximize profit = 40(800)A + 50(700)B + 60(800)C
Constraints
Labor: 4A +4B +5C <= 80
Raw material #1: 200A + 300B +300C<=6,000
Raw material #2: 600A + 400B +500C<=5,000
The solution is:
A = 0
B = 0
C = 10
Z = 480000