Consider the following linear programming problemMax. Z = 9X₁ + 16X₂Subject to:C1:C2:C3:C4:C5:Variable CellsX₁2X₁X₁X₁Microsoft Excel 16.0 Sensitivity ReportWorksheet: [Question Sensitivity analysis.xlsx]Sheet2Report Created: 10/24/2021 10:45:53 AM$B$5 Values x1$C$5 Values x2$D$10 C5Z$D$6 C1Z$D$7 C2Z$D$8 C3Z$D$9 CAZX₂This problem was solved using MS Solver of MS Excel.Following is the output of the solution.363X₂00X₂Final Reduced Objective Allowable AllowableCell Name Value Cost Coefficient IncreaseDecrease632493ConstraintsCell Name Value Price R.H. Side05500-55153000324100Final Shadow Constraint Allowable AllowableIncrease Decrease1E+3051E+3024106331E+301E+307.531813 1E+30Write your report on the sensitivity analysis of constraintsC2 and C3

Linear programming is a mathematical technique that is also used in operations management…

Answered: Write your report on the sensitivity…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Use the following information for the next 3 problems: ABC Company plans to construct a 60,000 sq. ft private warehouse and rent public warehouse as needed. Warehouse inventory turns at the rate of 2 times per month. One pound of merchandise occupies 0.2 cubic feet of warehouse space and can be stacked 10 feet high. Given aisles, and normal operating efficiency, only 50 percent of the total warehouse space is actually used for storage. Assume the facility is being built to size so no additional space is allowed for future product growth. A private warehouse can be constructed for $36 per sq. ft. and can be amortized over 20 years. Annual fixed costs amount to $20 per sq. ft. of total space. The cost of operation is $0.03 per pound of throughput. Space may also be rented for a storage charge on inventory of $0.06 per pound per month and a handling charge of $0.05 per pound of throughput. Monthly demands for a typical year are as follows: Month Demand (lb) Jan 2,000,000…
The steel beam shown in figure 3, has a height of 350 mm and a width of 160 mm . Determine the stress at points A, B, C, D and E. 8 ft 3 kips/ft 10 kips 3ft 2ft 3ft E G B I C D H
Case StudyThe ARCASNA company is dedicated to the manufacture of dog and cat food. Recently, the industrial engineering team became aware of potential areas of opportunity in the area of dog meat manufacturing. Currently, 45 liters of the solution are used to create them, and 50 jumbo, 75 medium and 100 small-sized chews are produced daily, to be sold and distributed in single packs (jumbo), trios (medium) and 5-packs (small). Recently there were inspections by the new manager in the industrial engineering area and the team realized that at the end of the day, among the "waste" (the material that remains at the end of each process), there is enough material left to fill a 5-liter bucket, which is wasted and thrown away. However, as there are 10 processes in total, there is very little left over at each of the stations, so they had never stopped to analyze the total loss per line. There are 6 workers on the line, distributed as follows: (Shown in the attached image). In addition, the…
Using the 1st law of Thermodynamics solve the following problem and the format of the answer is as follow a.) given:b) required:c solution : The 2M Company supplies 50 kilograms of chicken to ABEst Restaurant, which is contained in a box at 6°C, and is to be frozen at-18°C. The container box is 1.5 kg and the specific heat of the box material is 1.4 kJ/kg-°C. The freezing temperature of chicken is -2.8 °C. Determine the amount of heat that needs to be removed
What relationship between x and y is suggested by the scattergram? OA a quadratic relationship with downward concavity OB. a linear relationship with positive slope OC. a linear relationship with negative slope D. a quadratic relationship with upward concavity
No chatgpt used i will give 5 upvotes typing please full answer
Q46 Mixing Company manufactured 2,500 units of its only product during 2022. The inputs for this production are as follows: 550 pounds of Material A at a cost of $2.50 per pound 400 pounds of Material H at a cost of $3.75 per pound 700 direct labor hours at $60 per hour The firm manufactured 3,920 units of the same product in 2021 with the following inputs: 700 pounds of Material A at a cost of $2.20 per pound 560 pounds of Material H at a cost of $3.50 per pound 600 direct labor hours at $58 per hour The partial operational productivity of Material A in 2021 is: Multiple Choice 5.60 units per pound. 0.44 units per pound. 4.67 units per pound. 5.18 units per pound. 0.51 units per pound.
A Company currently has 230 units of a product on-hand that it orders every three weeks when the salesperson visits the premises. Average demand for the product is 20 units per day with a standard deviation of 5 units. Lead time for the product to arrive is seven days. Management has a goal of 95 percent probability of not stocking out for this product. The salesperson is due to come in late this afternoon when 210 units are left in stock. How many units should be ordered?

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Write your report on the sensitivity analysis of constraints C2 and C3