Logo
Home Study Material Contact Search
AI Chat FREE
  1. engineering
  2. mechanical engineering
  3. solve by excel solver using  branch and boun

Solve by Excel Solver using  branch and bound method. Minimise: f = 4x1 + 5x2 + x3 + 4x4 +...

60.1K

Verified Solution

Question

Mechanical Engineering

Solve by Excel Solver using  branch and boundmethod.

Minimise:

f = 4x1 + 5x2 + x3 +4x4 + 2x5 + 11x6 + 2x7

Subject to:

g1 = 2x1 + 4x2 + 5x3 +7x4 + x5 + 4x6 + 10x7 ≥ 110

g2 = 4x1 + x2 + 5x3 +7x4 + 3x7 ≤ 80

g3 = 2x1 + 5x2 + 3x3 +3x4 + x5 + 8x6 + x7 ≥ 40

x1, x2, x3, x4 ∈ {1, 2, 3,4}

x5, x6, x7 ≥ 0

Answer & Explanation Solved by verified expert
4.5 Ratings (941 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A projective plane is a plane (S,L ) satisfying the following four axioms. P1. For any...

Advance Math
Q

O. M. is a 6-year-old child at a freestanding emergency room. Per the mother, O.M. is...

Medical Sciences
Q

Particle nature of light is exhibited by O Diffraction and interference O Diffraction and refraction

Physics
Q

Ceruly Lesson 6 8 Volume and Surface Area 5 Step 1 of 1 me of...

Algebra
Q

Yoshi Company completed the following transactions and events involving...

Accounting
Q

In response to intessive foreign competition, the manngement of Florex Company has attempted over the...

Accounting
Q

Do you think only top managers (CEO, President, etc.) should prepare the company budget, or...

Accounting
Q

[The following information applies to the questions displayed below.] On January 1,Mitzu Company...

Accounting
Q

Please show work. Thank you! Complete the following partial flexible budget performance report and...

Accounting
Q

Purchasing Inc. purchases a bulldozer from Selling Inc. on Jan 1st,2023 using a note payable....

Accounting
Q

Schweser Satellites Inc. produces satellite earth stations that sell for $95,000 each. The firm's fixed...

Finance
Q

Retained Earnings represent since the company's formation, how much "operating income" has been kept...

Accounting