HomeworkLib
Question

Decision Variable Cells Final Reduced Objective Allowable Allowable Cell SCS4 Number to produce Generators SDS4 Number to produce Alternators Name Value Cost Coefficient Increase Decrease E+30 150.0000001 1E+30 130 250 150 225 225 Constraints Fina Shadow Constraint Allowable Allowable Value Cell SES8 Wiring Used SES9 Testing Used Name Price R.H. Side Increase Decrease 260 130 125 260 140 20 1E+30 260 10

X1=130 and X2=0, optimal profit 32,500

Using the solver report and the sensitivity report answer the question below. Please show your work:

Assume the marginal profit on the generators will decrease by $25.00. Without solving the problem again, what is the optimal profit for the company now?

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Since allowable decrease for generators is 150
25 < 150
profit will be (250 - 25) * 130 + 0 *150
= 29250

0 0
Add a comment
Know the answer?
Add Answer to:
X1=130 and X2=0, optimal profit 32,500 Using the solver report and the sensitivity report answer the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • (10) Problem #3 Using the Sensitivity Report output for the Blue Ridge Hot Tub example appearing ...

    (10) Problem #3 Using the Sensitivity Report output for the Blue Ridge Hot Tub example appearing below: a. What is the range in the number of available pumps that will keep the current basis optimal assuming the amount of labor hours and tubing feet remain constant? b. Blue Ridge is considering introducing a new model of hot tub called the Typhoon-Tub. Suppose that each unit of this new model requires 1 pump, 12 hours of labor, and 13 feet of...

  • Use the sensitivity report given to answer the questions below: Name SENSITIVITY REPORT Final Reduced Objective...

    Use the sensitivity report given to answer the questions below: Name SENSITIVITY REPORT Final Reduced Objective Value Cost Coefficient 110 0 350 300 75 Allowable Increase 80 # Aqua-Spa # Hydro-Lux # Typhoon-Lagoon Allowable Decrease 30 Infinite 10 -20 20 320 50 Constraints Name Shadow Price 150 Allowable Decrease Final Value 175 1400 2550 # Pumps used Hrs. Labor Used Ft. of Tubing Used Constant RHS 175 1500 2550 Allowable Increase 10 Infinite 100 15 125 O 7 50 11...

  • The sensitivity report is shown in Figure below SENSITIVITY REPORT FOR THE DIGITAL CONTROLS, INC., PROBLEM Variable Cel...

    The sensitivity report is shown in Figure below SENSITIVITY REPORT FOR THE DIGITAL CONTROLS, INC., PROBLEM Variable Cells Model Final Reduced Objective Allowable Allowable Name Variable Value Coefficient Increase Decrease Cost Models A Manufactured 1.750 IE+30 AM 00.000 0.000 10.000 3.000 Models B Manufactured 0.000 2.333 BM 60.000 6.000 1.750 AP BP Models A Purchased E+30 1.750 0.000 90.000 14.000 0.000 3.000 Models B Purchased 9.000 2.333 Constraints Final Shadow Constraint Allowable Allowable Price Constraint Number Name R.H. Side Value...

  • Below is the Sensitivity Report for Par Inc. In which departments would you not investigate whether...

    Below is the Sensitivity Report for Par Inc. In which departments would you not investigate whether it was possible to increase the available hours? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$14 Bags Produced Standard 540 0 10 3.5 3.7 $C$14 Bags Produced Deluxe 252 0 9 5.286 2.33 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$19 Cutting and Dyeing Hours Used 630 4.375 630 52.364...

  • a. What is the optimal solution in lay terms? What is the optimal value of the...

    a. What is the optimal solution in lay terms? What is the optimal value of the objective function? b. Which constraints are binding? Explain. c. What are the shadow prices of demand for B constraint and assembly time constraints? Interpret each. d. If you could change the right-hand side of one constraint by one unit (either increase or decrease), which one would you choose? Why? Show all calculations. e. State and interpret the ranges of optimality for any one of...

  • Below is the Sensitivity Report for the Par Inc. What would be the increase in the objective function if 10 additional hours were available in the Finishing Department?  Enter your answer without a do...

    Below is the Sensitivity Report for the Par Inc. What would be the increase in the objective function if 10 additional hours were available in the Finishing Department?  Enter your answer without a dollar sign and rounded to two decimal places. Microsoft Excel 16.0 Sensitivity Report Worksheet: [Par.xlsx]Model Report Created: 3/1/2018 4:16:53 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$14 Bags Produced Standard 540 0 10 3.5 3.7 $C$14 Bags Produced Deluxe...

  • If you could sell 50 oz. of stabilizer at $2.25/oz, how would this affect profit? Adjustable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease Cell $B$5 Varia...

    If you could sell 50 oz. of stabilizer at $2.25/oz, how would this affect profit? Adjustable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease Cell $B$5 Variable C $C$5 Variable P Name 100 350 0 1E+30 2 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 200 500 50 Cell Name $D$11 Fragrance LHS 1600 $D$12 Intensifier LHS 1300 $D$13 Stabilizer LHS 350 1600 166.6666667 1E+30 50 1.5 1800 350 2 Adjustable Cells Final...

  • The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both products require wiring and...

    The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both products require wiring and testing during the assembly process. Each generator requires 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Each alternator requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period,...

  • HERE IS THE SENSITIVITY REPORT!!!!!!!!! PLEASE SHOW ALL WORK A B C D E F G...

    HERE IS THE SENSITIVITY REPORT!!!!!!!!! PLEASE SHOW ALL WORK A B C D E F G H J K M N O 1 Transportation Model (Basic) Use Solver on Data Ribbon to solve 2 3 Input Matrix: Destinations C D A 4 1 4 7 7 1 100 5 SUPPLY 8 8 2 12 3 200 6 5 3 10 16 150 7 90 80 120 160 8 Demand Required 10 Do not change or delete unshaded cells. 11 12...

  • 1.Using the sensitivity report below, answer the following question: Which constraints are binding? Name Final Value...

    1.Using the sensitivity report below, answer the following question: Which constraints are binding? Name Final Value Reduced Cost Objective Coefficient Allowable Increase AllowableDecrease # Of Apple Pie 5.66 0 6 5.87 3.25 # Of Turnovers 35.25 0 0.75 0.89 0.55 # Of Cheesecake 4 0 8 1E+30 3.860759494 Name Value price R.H. Side Increase Decrease Apple Total 16.81 0 20.83 1E+30 4.02 Flour Total 5.7 6.17 5.7 2.67 2.98 Sugar Total 200 0.21 200 63.534 71.77 Cheese Total 15 1.03...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT