Question: Using Excel Solver, solve the following LP problem. Round all answers to two decimal points. MAX: 2X 1 + 7X 2 S.T.: 5X 1 +

  1. Using Excel Solver, solve the following LP problem. Round all answers to two decimal points.

MAX: 2X1 + 7X2

S.T.: 5X1 + 9X2 90

9X1 + 8X2 144

X2 8

X1, X2 0

Obj = Blank 1 _________

X1 = Blank 2 _________

X2 = Blank 3 ________

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 General Management Questions!

Q:

Using Excel Solver, solve the following LP problem. Round all answers to two decimal points. MAX: 8X 1 + 3X 2 S.T.: X 2 8 8X 1 + 5X 2 80 3X 1 + 5X 2 60 X 1 , X 2 0 Obj = X 1 = X 2 =

Q:

Question number 1. Using excel solver, solve the following LP problem. xnumber of tables to be made x2 number of chairs to be made X3 number of TV stands to be made Maximize Profit (Z)=50x +30 x2...

Q:

Hey, could you please show the answers and how you did/could work the question out. Thanks heaps:)) 3. Solve each of the following equations. a. 9(x - 7) = 82 b. 2(x + 5) = 14 c. 7(a - 1) = 28 d. 4(b...

Q:

2-14: Solve the following LP problem by using Excel: Maximize profit = 4X + 5Y Subject to the constraints: 5X + 2Y 40 3X + 6Y 30 X 7 2X - Y 3 X, Y 0 2-18: Solve the following LP problem by using...

Q:

1. [-/1 Points] DETAILS SMITHPOW10 6.2.035. Find the circumference of the following figure by using the appropriate formula. (Assume a = 2.80 m. Round your answer to two decimal places.) m + Show My...

Q:

The following linear programming problem has been written to plan the production of two products. The company wants to maximize its profits. X = Number of product 1 produced in each batch X = Number...

Q:

Consider the following all-integer linear program. Max 5x + 8x2 s.t. 6x + 5x, $ 35 9x, + 4x, s 36 1x, + 2x, s 12 * .*, 20 and integer (a) Graph the constraints for this problem. Use points to...

Q:

Consider the following all-integer linear program. Max 5x + 8x s.t. 6x, + 5x, s 35 9x + 4x, 5 36 1x + 2x, $ 12 X, X, 20 and integer (a) Graph the constraints for this problem. Use points to indicate...

Q:

A furniture manufacturer produces two types of tables ( country and contemporary ) using three types of machines. The time required to produce the tables on each machine is given in the following...

Q:

The Bolded words are the questions asked!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Question 1) The Sea Wharf Restaurant would like to determine the best way to allocate a monthly...

Q:

A retail computer dealer is trying to decide between two methods for servicing customers equipment. The first method emphasizes preventive maintenance; the second emphasizes quick response to...

Q:

Between 1981 and 1987, direct foreign investment in the Third World plunged by more than 50%. The World Bank was concerned about this decline and wanted to correct it by improving the investment...

Q:

Business Transactions: The owner invests 2 5 0 , 0 0 0 to start the company Purchased a building for $ 5 0 , 0 0 0 in cash Bought $ 1 0 , 0 0 0 in furniture using cash Purchased equipment for $ 8 , 5...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...