Question: The Sensitivity Report is given below: Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient increase Decrease 9 R4C2# made

The Sensitivity Report is given below: Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient increase Decrease 9 R4C2# made Small Canoe 13.4065934 0 32 4.08 1.2162963 10 R4C3 #made Regular Canoe 65.8021978 0 41 1.38215488 2.98529412 11 R4C4 # made Single Kayak 04.55238095 42 4.55238095 15:30 12 R4CS # made Double Kayak 57.1428571 0 55 15-30 4.78 13 R4C6 #made Dinghy 10 0 25 3.12307692 16.30 14 15 Constraints 16 Final Shadow Constraint Allowable Allowable 17 Cell Name Value Price R.H. Side Increase Decrease 18 R1107 Min Canoe Total 79.2087912 0 SO 29.2087912 15.30 19 R1207 Min Kayak Total 57.1428571 0 50 7.14285714 15.30 20 R13C7 Min Dinghy Total 103.12307692 10 49.962406 10 21 R6C7 Kayak mold Total 120 6.01465201 120 15.1212121 2.71111111 22 R7C7 Kayak oven Total 131.428571 0 240 18-30 108.571429 23 R8C7 Kelvar Total 210 3.84615385 210 28.5142857 4.35714286 24 R9C7 Finishing Total 242.098901 0 320 1E+30 77.9010989 25 R10C7 Fittings Total 320 15.6923077 320 3.48571429 19.4415584 26 27 28 Answer Report 1 Sensitivity Report 1 Sheet1 a) [4 pts] What is the production plan and total profit? Assume that fractional output is acceptable. If we force the variables to take integer values, then we cannot get a sensitivity report. b) (4 pts] Which constraints are binding? c) [6 pts) Would the solution change if the minimum number of canoes made was increased to 60? If the minimum number of kayaks was increased to 60? If the minimum number of dinghies was increased to 20? d) (4 pts) It has been determined that the oven used to heat the kayak mold must be shut down in one month, leaving only 150 hours of time. Will this affect the solution or the profit? (Explain using the given output; do not re-solve.) c) 14 pts) Extra fitting time can be obtained by hiring someone at minimum wage of $10.85. Should RBB hire someone? If so, for how many hours? f) (2 pts) Suppose they can also get someone to help with the kayak mold at $10.85 per hour. Should RBB hire someone? If so, for how many hours? g) And suppose that they can also get someone to help with finishing at $10.85 per hour. Should RBB hire someone? If so, for how many hours? h) (2 pts] Management has noted that the plan calls for production of all products except the single kayak. What would be the impact on profits if they decided to make a single kayak

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!

7 ca 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $E$5 values X1 500 0 49.5 19.5 1E+30 10 $F$5 values X2 200 0 69 1E+30 8.5 11...

answer them 17) Consider the sensitivity report below: 5 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$3 x1 50 0 13...

6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$13 Variable 1 0 -50 1300 50 1E+30 10 $D$13 Variable 2 20 0 600 150 50 11 $E$13...

You set up and ran an LP problem about the supply and demand of flu vaccine in 6 cities, and resulted with the following Sensitivity Report 80 20 6 Variable Cells 7 Final Reduced Objective Allowable...

Linear Programming The Whole Food Nutrition Centre uses three bulk grains, A, B, and C, to blend a natural cereal that it sells by the pound. The cost of each bulk grain is indicated in the table...

6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $B$1 Decision Variables 75 0 9 1 1 10 $C$1 Decision Variables 0 -1.5 9 1.5 1E+30...

1. Rose Bay Boatworks will be closing their facility in two months time so that major renovations can be done. They will be closed for almost 6 months and so want to make best use of resources that...

Please tell me if the following is true or false and why. If you believe the statement is is false, provide a brief reason for why that statement is false (indicate all reasons why it is false if...

1. The marginal revenue associated with the 3rd unit is? 2. The total revenue associated with the 5th unit is? 3. The marginal revenue associated with the 6th unit is? 4. The total revenue associated...

D n Question 1 Which of the following is an argument for free trade? Lower consumption possibilities. The need to protect goods and services essential to national security. Greater efficiency through...

3. You use the constant to include the Exclamation icon in a message box. a. MessageBox.Exclamation b. MessageBox.IconExclamation c. MessageBoxIcon.Exclamation d. MessageBox.WarningIcon

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...