Solve the following problem by using Excel: Max $3.10W1 + $3.20W2 + $3.45W3 + $4.15W4 + $3.25W5 + $2.75W6 Subject to W1 + W2 + W3 + W4 + W5 + W6 =…

Solve the following problem by using Excel:

Max $3.10W1 + $3.20W2 + $3.45W3 + $4.15W4 + $3.25W5 + $2.75W6

Subject to

W1 + W2 + W3 + W4 + W5 + W6 <= 15000

0.125W1 + 0.064W2 + 0.144W3 + 0.448W4 + 0.048W5 + 0.018W6 <= 1300

W1 <= 5000

W2 <= 4500

W3 <= 3000

W4 <= 3500

W5 <= 4000

W6 <= 3500

W1, W2, W3, W4, W5, W6 >= 0

Show more 

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount