Question: Excel please! d Problem 6-1 Maximize profit = $30X + $40Y Solve the following LP model graphically and then by using Excel: Figure 6.14 shows

Excel please! Excel please! d Problem 6-1 Maximize profit =

d Problem 6-1 Maximize profit = $30X + $40Y Solve the following LP model graphically and then by using Excel: Figure 6.14 shows the feasible region as well as a level profit line for a profit value $60. Note that the third constraint (2X - Y > 2) has a positive slope. As usual, to find the optimal corner point, we need to move the level profit line in the direction of increased 3 and Y = 2, yielding an opti- The Excel layout and Solver entries for this problem are shown in Screenshot 6-4. As expected, the optimal solution is the same as the one we found by using the graphical approach Problems subject to the constraints Solution profitthat is, up and to the right . Doing so indicates that corner est profit. The values at this point are calculated to be X = 3 and Y mal profit of $170. www 4X + 2Y = 16 Y

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!

DRAW neat and clear graphs, and label both axes and all lines. EXPLAIN briefly your solutions/results. DO NOT CLUTTER! Show your work! Q1. (a) Solve the following LP model graphically using the...

Thank you so much in advance. I have trouble with these questions. Exercise 2-13: Solve the following LP problem by using the graphical procedure and by using excel: For all problems use Excel Solver...

ADM2302 -Summer 2016 Instructor: Davood Astaraky Assignment one Linear Programming Formulation, Graphical Method and Excel Solver Please note that submitted assignments must be neat, readable, and...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

ADM 2302 -Assignment #1 Problem 1 (15 points) The price of oil has been dropping significantly recently. This urges fund managers to adjust their investment portfolios. In particular, many fund...

Problem 1 (20 points) Personal Mini Warehouses is planning to open a new branch in Manitoba. In doing so,the company must determine how many storage rooms of each size to build. The company builds...

HW3 consists of 12 questions that relate to the following problem: A company produces two products on two machines. A unit of Product 1 requires 2 hrs on machine 1 and 1 hr on machine 2. For Product...

Help please! I attached the problems that I need help with. Module 3 Individual Problems M3_IND1. A furniture cabinet maker produces two types of cabinets, Mission and Rustic, that house and hide LCD...

Week 1 Assignment Problems W1_A1. An electronics firm is current manufacturing a product that has a variable cost of $0.60 per unit and a selling price of $1.10 per unit. Fixed costs are $15,500....

Determine the input impedance seen by the source in the network shown in Figure P8.54 20 1:4 2 Ideal Ideal Figure P8.54

Use the formal definition to prove that the following sequences {an} diverge as n . Vn; (a) an nlk (for fixed k E N). (b) an =

The traditional three - way match matches the purchase order, receiving report and what other document?

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...