Question: A linear programming problem and the solver solution with a sensitivity report are given below. Please answer the following questions. Resources Product 1 Product 2

A linear programming problem and the solver solution with a sensitivity report are given below. Please answer the following questions.

Resources Product 1 Product 2 Available
Raw Mat 30 40 260
Labor 10 20 110
Profit/Unit $40 $60

Report:

A linear programming problem and the solver solution with a sensitivity report

Sensitivity Report

are given below. Please answer the following questions. Resources Product 1 Product
  1. What is the optimal solution to the problem? Give the values for all the decision variables and the objective function.
  2. If the availability of Raw materials increased by 50 units, what would be the value of the objective function?
  3. If the profitability of product 1 is increased by 10 what would be the objective function values?
  4. If the profitability of product 2 is decreased by 4 what would be the objective function value?
  5. If the availability of labor hours is increased from 110 to 120, would the objective functions value go up, down or remain the same? By how much?

Objective Cell (Max) Variable Cells Constraints Variable Cells Constraints

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:

Ron Garcia felt good about his first week as a management trainee at Mexicana Wire Winding, Inc. He had not yet developed any technical knowledge about the manufacturing process, but he had toured...

Q:

XYZ Corp manufactures four products A, B, C and D. Each product uses time in Dept 1, time in Dept 2 and a certain amount of material. The resources required to make each product are given below. At...

Q:

Question 4 (10 marks) A small catering business is expanding its take-out business as a result of the restrictions placed on businesses due to the Covid pandemic. It has decided to prepare 4...

Q:

Question 4 (10 marks) A small catering business is expanding its take-out business as a result of the restrictions placed on businesses due to the Covid pandemic. It has decided to prepare 4...

Q:

2. Remember the Sonoma Apple problem in the previous homework. This problem is based on that but realize it is a bit different. The problem was solved in Excel and the sensitivity report is shown...

Q:

A small catering business is expanding its take-out business as a result of the restrictions placed on businesses due to the Covid pandemic. It has decided to prepare 4 different meals using the same...

Q:

A small catering business is expanding its take-out business as a result of the restrictions placed on businesses due to the Covid pandemic. It has decided to prepare 4 different meals using the same...

Q:

Take Home Exam Problem Sensitivity Analysis Given the following Product Mix Linear Programming Problem and Excel Solver Solution: Maximize Profit = 1 5 X 1 + 2 0 X 2 + 1 4 X 3 Subject to: 5 X 1 + 6 X...

Q:

6:49 1 Motunui Coffee Company-F20.pdf BUS 121_Assignmnet 13 The Mounul Coffee Company (MCC) makes four different products from Coffee beans grown in the Monuni Island chocolate-coated whole coffee...

Q:

Bearland Manufacturing produces 4 different types of wood paneling. Each type of paneling is made by gluing and pressing together a different mixture of pine and oak chips. The following table...

Q:

Kwan purchased a new Mercedes Benz automobile from a dealership for $46,370.24. During the first year of ownership, he returned the car at least 10 times for numerous repairs, some of which Kwan...

Q:

For the domestic airline industry the amount of time each plane must spend in maintenance is a critical factor. The records show that for a sample of 49 planes, Central Airways average downtime is 12...

Q:

The ieventory cost flow method that assigns the most recent costs to coit of goods sold is a b . LF c . wrighed iwnoge cost d . epecilic Mentibation

Q:

2. Use the Big-O limit Lemma to show that log(n) = O (n). Then use the limit lemma to show that n* logn - O (n*+1) for any constant k