Question: Please use one decimal place. QUESTION 1 Given: Objective function: maximize Z = 6x1+ 7x2 Constraints: x1 + 3x2 5 30 4 x1 + x2

Please use one decimal place.

QUESTION 1 Given: Objective function: maximize Z = 6x1+ 7x2 Constraints: x1 + 3x2 5 30 4 x1 + x2 2 32 x1 2 0, x2 2 0 Use EXCEL SOLVER to determine the optimal solution for X1. Please use one decimal place. QUESTION 2 Given: Objective function: maximize Z = 6x1 + 7x2 Constraints: x1 + 3x2 5 30 4 x1 + x2 2 32 x1 2 0, x2 2 0 Use EXCEL SOLVER to determine the optimal solution for X2. Please use one decimal place. QUESTION 3 Given: Objective function: maximize Z = 6x1+ 7x2 Constraints: x1 + 3x2 5 30 4x1 + x2 2 32 x1 2 0, x2 2 0 Use EXCEL SOLVER to determine the optimal value for 2. Please use one decimal place

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 Mathematics Questions!

help please :((((( i will upvote your solution SENSITIVITY ANALYSIS 1. Given: Objective Function: Min z = 6x1 + 9x2 ($ cost) Subject to: X1 + 2X2 8 10X1 + 7.5X2 30 X2 2 X1, X2 0 a) Solve graphically...

Help Please :((((( SENSITIVITY ANALYSIS 1. Given: Objective Function: Min z = 6x1 + 9x2 ($ cost) Subject to: X1 + 2X2 8 10X1 + 7.5X2 30 X2 2 X1, X2 0 a) Solve graphically then find the Optimal...

Question 7: Sensitivity analysis (20 marks, 2 marks per subquestion) A garden store prepares various grades of pine bark for mulch: nuggets ( x 1 ), mini-nuggets ( x 2 ), and chips ( x 3 ). The...

A garden store prepares various grades of pine bark for mulch: nuggets ( x 1 ), mini-nuggets ( x 2 ), and chips ( x 3 ). The production process requires pine bark, machine time, and labour time. Each...

Sensitivity analysis (20 marks, 2 marks per subquestion) A garden store prepares various grades of pine bark for mulch: nuggets ( x 1 ), mini-nuggets ( x 2 ), and chips ( x 3 ). The production...

Question 7:Sensitivity analysis (20 marks, 2 marks per subquestion) A garden store prepares various grades of pine bark for mulch: nuggets ( x 1 ), mini-nuggets ( x 2 ), and chips ( x 3 ). The...

MS&E 211 Homework #2 Course Instructor : Yinyu Ye Due Date: Oct 20th, 2016 Problem 1. Which of the following sets are convex? If they are convex explain why, otherwise give a counter-example. (a) The...

Derana Furnitures manufactures three products: Single Bed, The Dining Table, and Dining Chair. Derana Furnitures wants to maximize their profits by producing their products effectively. Each product...

Find the ratios of products A, B, and C using a closed model. a. 8: 10: 40 b. 8: 13: 32 c. 8: 10: 3 d. 32: 40: 13 Anne and Nancy use a metal alloy that is 28% copper to make jewelry. How many ounces...

What are input masks? What are validation rules? Why are they important?

Do the columns of the matrix span R? Select an Answer 1. A = A || 3 -5 Select an Answer 2. -7 2 A = 7 -6 9 45 144 8 40 128 5 25 80 Select an Answer 3. -6 -18 -65 -6 -17 -62 3 9 33 Select an Answer 4.

Benzi Co . had the following transactions for the month: Provided services for $ 5 0 0 on account.Received $ 3 0 0 from credit clients.Purchased supplies for $ 1 0 0 cash.Provided services for $ 3 0...

please explain as best as you can Required information [The following information applies to the questions cisplayed beiow] Gteener Pastures Corporation borrowed $1,000,000 on November 1, 2021. The...