Question: Find the optimal integer valued solution to the following problem using excel solver: max 0.25X + 0.50Y + 3Z 0.8X + 0.2Y 3 1.0X +

Find the optimal integer valued solution to the following problem using excel solver:

max 0.25X + 0.50Y + 3Z

0.8X + 0.2Y 3

1.0X + 1.5Y + 3.0Z 6

1.0X + 0.6Y + 2.0Z 4

X + Y + Z 6

X, Y, Z 0

Submit only the excel file. (business decision analysis)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Find the optimal integer valued solution to the following problem using excel solver: max 0.25X + 0.50Y + 3Z 0.8X + 0.2Y 3 1.0X + 1.5Y + 3.0Z 6 1.0X + 0.6Y + 2.0Z 4 X + Y + Z 6 X, Y, Z 0 (For this...

Q:

Find the optimal integer valued solution to the following problem using excel solver: max 0.25X + 0.50Y + 3Z 0.8X + 0.2Y 3 1.0X + 1.5Y + 3.0Z 6 1.0X + 0.6Y + 2.0Z 4 X + Y + Z 6 X, Y, Z 0 Submit only...

Q:

Find the optimal integer valued solution to the following problem using excel solver: max 0 . 25 X +0 . 50 Y +3 Z 0 . 8 X +0 . 2 Y 3 1 . 0 X +1 . 5 Y +3 . 0 Z 6 1 . 0 X +0 . 6 Y +2 . 0 Z 4 X + Y + Z...

Q:

5. (15 points) Find the optimal integer valued solution to the following problem using excel solver: max 0.25X + 0.50Y + 3Z 0.8X + 0.2Y 3 1.0X+1.5Y +3.0Z6 1.0X+0.6Y +2.0Z4 X+Y+Z6 X, Y, Z 0 Submit...

Q:

5. (15 points) Find the optimal integer valued solution to the following problem using excel solver: max 0.25X +0.50Y +32 0.8X +0.2Y 3 1.0X + 1.5Y + 3.02 6 1.0X +0.6Y +2.02 > 4 X + Y + 2

Q:

1.Joe is an active26-year-old male who lifts weights six days a week. He is looking to minimize the cost of consuming his favorite foods. Joe is trying to gainweight, or at least maintain his current...

Q:

Please give me direct answers to put in the boxes. please make it clear what should go on the boxes. Problem 7-02 (Algorithmic) Consider the following all-integer linear program: Max 5x1 + 8x2 s.t....

Q:

Consider the following all-integer linear program. Max5x1+8x2s.t.6x1+5x2359x1+4x2361x1+2x212x1,x20andinteger (a) Graph the constraints for this problem. Use points to indicate all feasibllnteger...

Q:

An airline company wishes to assign two types of its aircraft to three routes. Each aircraft can make at most two daily trips. Furthermore, 3 and 4 aircrafts of types A and B are available...

Q:

Consider the following all-integer linear program. Max 1X2 + 1x2 s.t. 4X1 + 6x2 S 34 1x1 + 7x2 21 2x1 + 1x2 = 15 X1, X220 and integer (a) Graph the constraints for this problem. Use dots to indicate...

Q:

Find the frequency-domain impedance, Z, as shown infigure. j1n -j2 0 ww

Q:

A wave function is given to be p(x) = N( x /x0 )^ ne -x/x0, N, n, x0 are constants From Schrodinger wave equation find potential V(x) and the energy E for which (x) is an Eigen function. %3D

Q:

Which of the following developed a new mortgage - backed instrument - the collateralized mortgage obligation ( CMO ) - in which investors were offered different classes of mortgagebacked securities...

Q:

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...