No video
LP Blending Problem | Formulation + Solution | Product Mix Example
Рет қаралды 12,219
Күн бұрынThis video shows how to formulate and solve a blending/product mix linear programming problem.
Solving LP in LINDO: • Solve LP using LINDO (...
00:00 -Intro
00:33 -Decision Variables
01:05 -Objective Function
01:48 -Supply Constraints
02:05 -Octane Ratings
03:26 -Requirement Constraints
04:35 -Solving the LP
Maximize 40R1 + 51R2 + 62R3 + 60P1 + 71P2 + 82P3
s.t.
R1 + P1 ≤ 82000
R2 + P2 ≤ 96000
R3 + P3 ≤ 99000
7R1 +1R2 - 3R3 ≥ 0
4P1 - 2P2 - 6P3 ≥ 0
0.7R1 - 0.3R2 - 0.3R3 ≤ 0
-0.25R1 - 0.25R2 +0.75R3 ≤ 0
0.8P1 - 0.2P2 - 0.2P3 ≥ 0
-0.35P1 -0.35P2 + 0.65P3 ≤ 0
P1 - P3 ≥ 50000
@magorzatapetzel7619 Жыл бұрын
Better solution (Excel Solver) R1 = 32 000, R2 = 73 000, R3 = 99 000, P1 = 50 000, P2 = 23 000, P3 = 0 Objective function value = 0,15774 E +08
@joshemman Жыл бұрын
You're right. At 04:39, I used -0.25R1 - 0.25R2 +0.75R3 ≤ 0 in my input instead of -0.25R1 - 0.25R2 +0.75R3 ≥ 0. Thanks, Małgorzata Petzel, for taking the time to check it out and for posting.
@sonceraelewis7231 6 ай бұрын
how would you input these numbers into Excel? Thank you!
@joshemman 6 ай бұрын
See if this video helps: kzfaq.info/get/bejne/sM-Gn72judPYeWg.html
ABRACADABRA TV
Рет қаралды 8 МЛН