Problem 4-20 | |||||||
X | Y | ||||||
Profit | $4 | $5 | =SUMPRODUCT(B5:C5,$B$4:$C$4) | ||||
Constraints | |||||||
Labor | 1 | 2 | =SUMPRODUCT(B7:C7,$B$4:$C$4) | <= | 10 | ||
Material | 6 | 6 | =SUMPRODUCT(B8:C8,$B$4:$C$4) | <= | 36 | ||
Storage | 8 | 4 | =SUMPRODUCT(B9:C9,$B$4:$C$4) | <= | 40 | ||
LHS | Sign | RHS | |||||
The (B4:C4) signifies the number of X & Y manufactured/procured
Objective Cell is D5 which is a summation of profits from the X & Y
Constraint at D7 signifies the total labor consumed in having the (B4:C4) quantity of X & Y
Constraint at D8 signifies the total material consumed in having the (B4:C4) quantity of X & Y
Constraint at D9 signifies the total storage consumed in having the (B4:C4) quantity of X & Y
Putting this in solver we get, Optimal solution at X = 2 & Y = 4
The screenshots are attached,
Please Like & Provide your reviews in Comments. :-)
Get Answers For Free
Most questions answered within 1 hours.