Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the screenshot of Figure 15.11 with cells lettered A through O. Choose a letter and discuss the meaning of the associated numerical value
Refer to the screenshot of Figure 15.11 with cells lettered A through O. Choose a letter and discuss the meaning of the associated numerical value in the context of the problem. Please title your discussion post "Letter D".
In addition to your individual assigned cell, what overall conclusions and/or predictions can you make from the results presented here?
What is the meaning behind Letter D? Why is it important? What affects will happen if the value were to decrease by more than 33.33?
Figure 15.11 J&M Manufacturing Solver Sensitivity Report Ch 7 A B C D E F G H 5 Objective Cell (Max) 6 Cell Name Final Value 7 $F$27 Profit contribution Total Profit 407857.1429 A 8 9 Decision Variable Cells 10 Final Reduced Objective Allowable Allowable 11 Cell Name Value Cost Coefficient Increase Decrease 12 $B$25 Number produced A E 3857.142857 0 B 40 20.00000004 1.000000042 13 $C$25 Number produced B FO $1.904761905 60 1.904761905 1E+30 14 $D$25 Number produced C 1235.714286 0 100 13.33333389 33.33333339 15 $E$25 Number produced D 1000 19.28571429 130 1E+30 19.28571429 16 17 Constraints 18 Final Shadow Constraint Allowable Allowable 19 Cell Name Value Price R.H. Side Increase Decrease 20 $F$19 Stamping Hours Used 320.000 H571.429 320 44.58333333 0 5 21 $F$20 Painting Hours Used 223.571 1 0.000 320 1E+30 96.42857143 22 $F$21 Assembly Hours Used 320.000 642.857 320 3.333333333 71.33333333 23 $F$22 Inspection Hours Used 308.952 0.000 320 1E+30 11.04761905 24 $F$23 Packaging Hours Used L 141.369 M 0.000 320 1E+30 178.6309524Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started