Business Finance 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