5) What If Scenario and Solver Assignment

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

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

View Full Document Right Arrow Icon
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 cel B4, please download a new copy of the start file from the SAM web site.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Scenario Summary Current ValueFund ScenariFund ScenariFund ScenariFund 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.
Background image of page 2
Adair Scholarship Fund Application Scoring Application ID Score Scholarship Scholarship Distribution 1 82 5000 Lowest Score Highest Score Scholarship Count
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

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

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online