Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. sensitivity analysis solve the following lp in exc

Sensitivity Analysis Solve the following LP in Excel Solver/Lindo and create the Sensitivity Analysis Report....

70.2K

Verified Solution

Question

Accounting

image Sensitivity Analysis Solve the following LP in Excel Solver/Lindo and create the Sensitivity Analysis Report. Please answer the following questions according to the report. Zmax=s.t.9x1+14x2+8x33x1+2x2+2x3120(MaterialConstraint)x1+3x2+x3150(RawMaterialConstraint)2x1+x2+2x380(ProductionConstraint)x1,x2,x30 1) Indicate the basic and non-basic variables and explain your answer. 2) Indicate the amount of the resources to be used at the optimal solution. 3) Indicate the objective function coefficient of X2 (\$\$ $1 ). Interpret the meaning of the number 4) Indicate the technological coefficients of x1 at the raw material constraint. Interpret the meaning of the number. 5) Indicate the optimality range of X2. If we increase the objective function coefficient of X2 to 25 , how does the value of the variables and the value of Z change? 6) If we increase the objective function coefficient of X2 to 16, how does the value of the variables and the value of Z change? 7) Indicate the feasibility range of the raw material constraint, and explain your answer. 8) What is the shadow price of the material constraint? How does it affect to value of Z? Explain

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students