Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Solve the above LP using Excel or GoogleSheets. Please show your Excel input and output. Minimize z = (3x, +3.4x12 +3.8x,3)+(2.5x2 +2.8x22 +3.4x3) +0.5(i +12

image text in transcribed

Solve the above LP using Excel or GoogleSheets. Please show your Excel input and output.

Minimize z = (3x, +3.4x12 +3.8x,3)+(2.5x2 +2.8x22 +3.4x3) +0.5(i +12 +13)+0.4(iz+in+i) Subject to the constraints 4,1-1 = 40 1. + X12 - 12 = 30 12 + X13 13 = 20 22-12 = 20 121 + X22 - in2 = 30 iz2 + xy-ing = 20 x,, + x2,565 X12 + X22 365 X13 + xy 365 All variables 20 Minimize z = (3x, +3.4x12 +3.8x,3)+(2.5x2 +2.8x22 +3.4x3) +0.5(i +12 +13)+0.4(iz+in+i) Subject to the constraints 4,1-1 = 40 1. + X12 - 12 = 30 12 + X13 13 = 20 22-12 = 20 121 + X22 - in2 = 30 iz2 + xy-ing = 20 x,, + x2,565 X12 + X22 365 X13 + xy 365 All variables 20

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Reliability Engineering Designing And Operating Resilient Database Systems

Authors: Laine Campbell, Charity Majors

1st Edition

978-1491925942

More Books

Students also viewed these Databases questions

Question

Describe the concept of diversity and diversity management.

Answered: 1 week ago

Question

How does the EEOC define sexual harassment?

Answered: 1 week ago