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

Finance
1.2K views

You are offered a European Call option. This means you will have the option, but not...

Physics
1.2K views

A semi circular disc is moving rightward with velocity vo and acceleration ao both rightward...

Geometry
1.2K views

20 Describe how you would construct an angle measuring 75 21 Construct the complement of...

Geometry
1.2K views

A computer programmer earned 1043 a week last year What was her yearly salary A...

Basic Math
1.2K views

terms of T 1 G J and n the angle through which end A rotates

Statistics
1.2K views

Construct a 95 confidence interval for with the sample statistics for mean calorie content of...

Calculus
1.2K views

A triangular sail for a sailboat has sides of length 6'2", 7'3", and 10'7". What...

Calculus
1.2K views

The function C 1 Co 1 r models the rise in the cost of a...

Algebra
1.2K views

2x 9x 5 0 Choose the correct graph of 2x 9x 5 below A Q...

Algebra
1.2K views

Write the following expression in exponential form 7 7 7 7 7 7 Use integers...

Accounting
1.2K views

The following four companies use a process cost system: Required: Treating...

Finance
1.2K views

1. Determine the risk-based and Tier I leverage capital ratios for Amadeus Federal Savings: ...