Question: Hi i am having trouble on this problem i was wondering can you help me on this. Please show steps in excel 6 Consider the

Hi i am having trouble on this problem i was wondering can you help me on this. Please show steps in excel

6 Consider the following LP problem, in which X and y denote the number of units of products X and Y to produce, respectively: Maximize profit = $4X + $5Y subject to the constraints X + 2Y = 10 (labor available, in hours) 6x + 6Y S 36 (material available, in pounds) 8x + 4Y S 40 (storage available, in square feet) X,Y 20 (nonnegativity) The Excel Sensitivity Report for this problem is shown in Screenshot 9. Calculate and explain what happens to the optimal solution for each of the fol- lowing situations. Each question is independent of the other questions. (a) You acquire 2 additional pounds of material. (b) You acquire 1.5 additional hours of labor. (e) You give up 1 hour of labor and get 1.5 pounds of material. (d) The profit contributions for both products X and Y are changed to $4.75 each. (e) You decide to introduce a new product that has a profit contribution of $2. Each unit of this prod. uct will use 1 hour of labor, 1 pound of material, and 2 square feet of storage space

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!

Cheadle Company purchased a fleet of 20 delivery trucks for $8,000 each on January 2, 2019. It decided to use composite depreciation on a straight-line basis and calculated the depreciation from the...

EXCEL FORMULAS ONLY!!!! PLEASE SHOW YOUR EXCEL WORK AND THE SENSITVITY USING SOLVER AND THE WORK TO ANSWER THE PROBLEM The season yield of olives in a Piraeus, Greece, vineyard is greatly influenced...

Hi can some one help me two question and show work on excel, please show on excel calculation. I need it by 12 pm today (3 hrs left from now) 1/. Juki Mara is Dallas based company specializing in...

Please show steps in Excel. Practice Problem 4). Let's return to the LP problem we formulated in Final Prob1. We are going to solve the problem in Solver and consider the information in the Solver...

This is an excel data cleaning problem. I need help and it is due soon. All steps need to be done in excel.. Please show steps with pictures if possible! Anything will help! Page 1 of 3 ZOOM + Data...

please solve parts b and c and kindly show steps :) 2. Consider a factory that produces tables. The demand for the tables is known for the coming four months. The manager wants the make a planning of...

help please. please show steps Problem 7.21 (Algo) Segment Reporting and Decision-Making [LO7-4] Vulesn Cormpanyle contribution formet incorne stetement for June is as followis: Manegement is...

Please show steps and calculations please! Consider the following LP and its solution from HW 5 - Problem 4. Do not use Excel. Show your calculation. MaximizeZ=12x1+18x2 Subject to:...

Problem # 4 Tin - Can, Inc. Aircraft ( TCAI ) R&D Project Management Problem Your group is hired to help TCAI Project Manager to solve the following problem. Using the activity time estimates and...

(g). Using the initial project detailed information (on page 2), prepare an Excel summary table providing the expected profit or loss which TCAI can expect on this contract. TCAI Project Information...

In June 2006, Harry Sinclair, General Manager of the Texas Division of Agri Chem Corporation, received notification from Ben Elliot of Enerco that natural gas supplies were being rapidly depleted. In...

Roger Strader works for a small manufacturing company and is married to Amy, who were high school sweethearts and are both currently 64 years old. He receives an annual salary of $80,000 and Amy...

Two moles of helium gas (y=5/3) are initially at 27C and occupy a volume of 20 litres. The gas is first expanded at constant pressure until the volume is doubled. Then it undergoes an adiabatic...

How do you construct a covered call position in AMZN, intended to generate income? Group of answer choices Short Short Long Long Short Long Long Short

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...