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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

13th Edition Global Edition

1292263350, 978-1292263359

More Books

Students also viewed these Databases questions

Question

L A -r- P[N]

Answered: 1 week ago

Question

Did you trace the accomplishments, issues, and milestones?

Answered: 1 week ago