{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

5) What If Scenario and Solver Assignment

# 5) What If Scenario and Solver Assignment - SAM Projects...

This preview shows pages 1–3. Sign up to view the full content.

SAM Projects Office 2010 NP EXCEL 2010 T10 CP1b - Adair Scholarship Fund DO NOT DELETE--> %(4A86B22CA7F68E85-01E207BDD5311871)% Author %(4A86B22CA7F68E85-01E207BDD5311871)% wdvkddjudzdod Note: Do not edit this sheet. If your name does not appear in cell B4, please download a new copy of the start file from the SAM web site.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Scenario Summary Current Value Fund Scenari Fund Scenari Fund Scenari Fund Scenario 4 Changing Cells: Low0Score 0 0 0 0 0 Low1000Sco 50 20 30 50 60 Low2000Sco 75 40 50 70 80 Low5000Sco 90 60 70 90 95 Result Cells: Percent0 48% 16% 27% 48% 62% Percent1000 23% 20% 21% 20% 18% Percent2000 20% 26% 20% 23% 15% Percent5000 8% 38% 32% 8% 5% HowFarFrom 66% 58% 67% 66% 93% Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray.
Adair Scholarship Fund Application Scoring Application ID Score Scholarship Scholarship Distribution 1 82 5000 Lowest Score Highest Score Scholarship Count Percentage Optimal Difference 2 38 1000 0 19 0 24 16% 15% 1% 3 23 1000 20 39 1000 31 20% 45% 25% 4 88 5000 40 59 2000 40 26% 30% 4% 5 75 5000 60 100 5000 59 38% 10% 28% 6 86 5000 Total 154 100% 100% 58% 7 94 5000 8 91 5000 9 77 5000 Minimal Curve Difference Model 10 32 1000 58% 11 25 1000 3 12 77 5000 TRUE 13 75 5000 32767 14 53 2000 0 15 97 5000 16 41 2000 17 58 2000 18 19 0 19 81 5000 20 39 1000 21 77 5000 22 43 2000 23 22 1000 24 88 5000 25 24 1000 26 6 0 27 44 2000 28 12 0 29 96 5000 30 13 0 31 58 2000 32 63 5000 33 43 2000 34 0 0 35 95 5000 36 41 2000 37 15 0 38 89 5000 39 95 5000 40 57 2000 41 59 2000 42 32 1000 43 39 1000 44 61 5000 45 63 5000 46 33 1000 47 11 0 48 5 0 49 40 2000 50 79 5000 51
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}