Question: Solve the following LP problem using excel solver and indicate the optimal solution. Maximize profit = $3X + $2Y subject to: 2X + Y

Solve the following LP problem using excel solver and indicate the optimal solution.

Maximize profit = $3X + $2Y

subject to:

2X + Y <=150

2X + 3Y <= 300

Obtain the sensitivity report in excel and answer the following questions. (Make sure to upload the Excel worksheet) SHOW WORK IN EXCEL

(a) Does the optimal solution change if the profit per unit of X changes to $4.50?

(b) What happens if the profit function should have been $3X + $3Y?

(c) Comment on the dual price of each constraint.

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:

Solve the following LP problem using excel solver and indicate the optimal solution. Maximize profit = $3X + $2Y subject to: 2X + Y

Q:

Graph the following LP problem and indicate the optimal solution point: Maximize profit = $3X + $2Y Subject to 2X + Y 150 2X + 3Y 300 (a) Does the optimal solution change if the profit per unit of...

Q:

Solve the following LP problem using Excel Solver and report the objective function value at the optimal solution. Note that this is a minimization problem that has 4 decision variables (x1, x2, x3,...

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:

please can tou answer quastion 2-5 A Saudi furniture manufacturer buys fabric from three suppliers, one in Jeddah, one in Rome and one in Amsterdam. The price per unit from the Jeddah supplier is...

Q:

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...

Q:

solve it by using Excel. A furniture firm makes three types of tables: coffee table, side table and dining room table, and two types of chairs : arm chair and side chair. A coffee table requires 35...

Q:

A furniture firm makes three types of tables: coffee table, side table and dining room table, and two types of chairs : arm chair and side chair. A coffee table requires 35 unit s of wood, a side...

Q:

#2) Solve the following LP by using Excel. State the Optimal Solution and the Objective Function Value. Maximize profit = 6X + 5Y Subject to: 4X + 2Y 40 3X + 5Y 30 X 7 2X - Y 4 X, Y 0 #3) Solve the...

Q:

Problem 1 The Outdoor Furniture Corporation manufactures two products, benches and picnic tables, for use in yards and parks. The firm has two main resources: its carpenters (labor force) and a...

Q:

(b). The profit after tax for Barstead for the year ended 30 September 2009 was $15 million. On 1 October 2008, the company had in issue 36 million equity shares and a $10 million 8% convertible loan...

Q:

Romberg Products Company operates three divisions, each with its own manufacturing plant and marketing/sales force. The corporate headquarters and central accounting office are in Romberg, and the...

Q:

Which of the following is a true statement about activity-based customer costing? a. Customer diversity requires multiple drivers to trace costs accurately to customers. b. Customers consume...

Q:

Modern Com buy handles for the desks at $8 as follows pany manufactures wood desks. They have the opportunity to per unit. This purchase would affect costs Unit selling price Volume (monthly) Unit...