## Microsoft Excel Sensitivity Report### Adjustable Cells| Cell | Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease ||--------|--------------------------|-------------|--------------|----------------------|-------------------|-------------------|| $B$19 | Acres to Plant Watermelons | 60 | 0 | 256 | 28.5 | 66.33 || $C$19 | Acres to Plant Cantaloupes | 40 | 0 | 284.5 | 99.5 | 28.5 |### Constraints| Cell | Name | Final Value | Shadow Price | Constraint R.H. Side | Allowable Increase | Allowable Decrease ||--------|--------------------------|-------------|--------------|----------------------|-------------------|-------------------|| $F$11 | Water Used per hour | 6,000 | 1 | 6,000 | 1,500 | 1,000 || $F$19 | Acres Planted per hour | 100 | 199 | 100 | 20 | 20 |### Questions1. **How much can the price of watermelons drop before it isn't optimal to plant any watermelons?** (round to 2 decimal places)2. **How much does the price of cantaloupes have to increase before it is optimal to only grow cantaloupes?** (round to 2 decimal places)

1) According to given sensitivity report, the profit of the watermelons per acre would drop by…

Answer the following questions based on the following Sensitivity Report. Microsoft Excel Sensitivity Report Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$19 Acres to Plant Watermelons 60 256 28.5 66.33333333 $C$19 Acres to Plant Cantaloupes 40 284.5 99.5 28.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SF$11 Water Used per hour) 6,000 1 6000 1500 1000 SF$19 Acres Planted per hour) 100 199 100 20 20 1. How much can the price of watermelons drop before it isn't optimal to plant any watermelons? (round to 2 decimal places) 2. How much does the price of cantaloupes have to increase before it is optimal to only grow cantaloupes? (round to 2 decimal places)

Answer the following questions based on the following Sensitivity Report. Microsoft Excel Sensitivity Report Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$19 Acres to Plant Watermelons 60 256 28.5 66.33333333 $C$19 Acres to Plant Cantaloupes 40 284.5 99.5 28.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SF$11 Water Used per hour) 6,000 1 6000 1500 1000 SF$19 Acres Planted per hour) 100 199 100 20 20 1. How much can the price of watermelons drop before it isn't optimal to plant any watermelons? (round to 2 decimal places) 2. How much does the price of cantaloupes have to increase before it is optimal to only grow cantaloupes? (round to 2 decimal places)

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

Cell Name: $C$5 Qty Doors 24 0 Qty $D$5 Windows 48 0 $E$5 Qty Vents Using the sensitivity report below, by how much will profit increase if you add an additional unit of 'Finishing Used'? 120 60 48 Cell Name $F$9 Cutting Used 48 $F$10 Sanding Used 60 $F$11 Finishing Used O 440 Final Reduced Objective Allowable Value Cost Coefficient Increase 100 0 60 -220 500 Final Shadow Constraint Value Price 0 440 120 450 200 R.H. Side 100 60 60 550 220 Allowable Increase 1E+30 Allowable Decrease 20 275 75 1E+30 Allowable Decrease 52- 43.33333333 15 30
Josh Smith, the materials manager at a retail store, has determined that a particular product experienced 5 turns last year, with an annual sales volume of $15 million. What was the average inventory value for this product last year? $2.5 million $2.75 million $3 million $5 million
3
Please calculate the sensitivity analysis of NPV increase in 10%, 30%, and 50%. NPV (current) natural forest 70141.71 protective forest 123582.50 agroforestry & terracing 263.11 Beekeeping 198275.14 Cookstoves 61490651
Aaron is considering potential
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