Solution in Excel:
Step 1: First I made the model of the problem in spreadsheet.
where some cells have excel formula like,
Production Quantity left blanked, because we have to find that,
Unit profit is filled, according to the , 'Maximise Profit: = 20x 1 + 40x 2 + 30x 3'
C4= 20
D4= 40
E4=30
F4 = (C3*C4)+(D3*D4)+(E3*E4)
In Constraint,
Resource 1: 3x1 + 5x2+4x3≤ 400
C8= 3
D8=5
E8=4
F8 = (C3*C8)+(D3*D8)+(E3*E8)
G8=400
Resource 2: x1 +x2 + x3≤ 100
C9=1
D9=1
E9=1
F9 = (C3*C9)+(D3*D9)+(E3*E9)
G9 = 100
Resource 3: x1 + 3x2 + 2x3≤ 200
C10=1
D10=3
E10=2
F10 = (C3*C10)+(D3*D10)+(E3*E10)
G10=200
Step 2: I opened the solver. Data --> Solver
Added the values like in:
Set objective: I select the Total Profit Cell '$F$4'
To: I select 'Max' Because it is the maximization problem.
By changing Variable cells: I select the "Production Quantity" Cell for all 3 Products.
Subject to constraints: I added 3 constraints as given in the question, and the value is Used<= Available of 3 resources
then,
I "select the solving method" that is "Simple LX".
Then i click solved.
Then i get
Its shows that, if we manufacture
Product = 50
Product 2 = 50
Product 3 = 0,
then we achieve the maximum profit in given resources.