Tableau form and Excel, engineering homework help
please solve the following in Tableau form and also in Excel:
Problem 1- Z= x1+x2+2×3 S.T
x1+x2+x3 <=12
2×1+x2+5×3=20
x1+x2+x3>=8
Problem 2- x1=denim x2= pound Z=2.25×1 +3.1 x2 S.T
3.2×2 +3×1 <=3000
7.5 x2 +5×1<= 6500
x2>=510
x1>=0
problem 3: x1= blocks x2= radio x3= toster Z=8×1+10×2+7×3 S.T
7×1+10×2+5×3<=2000
2×1+3×2+x3<=600
problem 4: a=lamp b=sport c= linen
MAX Z=130×1 a +150×1 b+90×1 c +275×2 a+300×2 b+ 100×2 b+ 180 x3 a+ 225×3 b+140×3 c+ 200 x4 a+ 120x4b+160×4 c S.T
x1a +x1 b+ x1c=1
x2a + x2b+x2c=1
x3a+x3b+x3c=1
x4a+x4b+x4c=1
1<=b<=2
1<=c<=1
xij>=0
a=x1a+x2a+x3a+x4a
b=x1b+x2b+x3b+x4b
c=x1c+x2c+x3c+x4c