Sensit 1. 45, Only For Academic Use Many Inputs , One Output www. Decision Toolworks .com Single - Factor Sensitivity Analysis Date 05 - 0kt - 12 Workbook Freemark Abbey (05 102012 0). Time 7:06 Output Cell Sheet ? ! 5 8 5 27 LOTTESOONding Inout Value Input Value as }6 Of BASE Output Value Input Variable LOW Output BASE CASE High Output LOW ?'` BASE ?'` High $6 LOW BASE High SWINE Price per bottle if botrytis didn't form 50.096 100.096 150.096| 35072 39744 4.3596\\ 77:04 $4.796 10.0.096 1.35. 1%6| 39744 3974 4 46200 95+ 7 Price per bottle for not quite ripe grape PRICE 2590 SLEET WINE 2. 5} 4. 5^ 71.496 10:0.096 128. 696| 38244 7974 4 42144| 390 0 Price 2 096 Sugar WINE {` 60. 796 100.095 13.3.386| 38244 3974 4 42144| 390.0 Price botrytised riesling 87.596 100.096 112.5%6| 38064 3974 4 41424| 7360 Price low acid wine 1 . 2 . 5} 3. 51 60.096 100.096 140.096| 38544 3974 4 4094 4| 2400 addition in volume if the berries swell 0.07 0 . 1 71.496 100.096 142.7%6| 39600 3974 4 39760 360 Price Fell in bulk 0.096 100.09^ 200. 096| 39744 39744 39744 Price Sell the grape 0.096 100.095, 200.096| 39744 39744 3974 4|