A) Develop a spreadsheet model to evaluate the extra funds needed from the deans budget (or unused funds) based on the number of scholarships offered and the estimated acceptance rate.

B) Apply a two-way data table to examine extra funds needed under varying acceptance rates (50%, 55%, 60%, 65%, 70%, & 75%) and the number of offers (25, 30, 35, 40, & 45).

C) (15 pts) Apply a two-way data table to check unused funds under varying acceptance rates (50%, 55%, 60%, 65%, 70%, & 75%) and the number of offers (25, 30, 35, 40, & 45).

\begin{tabular}{|c|l|r|} \hline & \multicolumn{1}{|c|}{ A } & \multicolumn{1}{c|}{ B } \\ \hline 1 & 2a. Scholarships Model Spreadsheet (30 pts) \\ 22 & (Complete the model formulation) \\ \hline 3 & Data \\ 4 & Number of offers (Decision) & \\ \hline 5 & Acceptance \% (estimated) & 0.70 \\ \hline 6 & Number available & 20 \\ \hline 7 & Scholarship amount & $25,000 \\ \hline 8 & Total funds available & $500,000 \\ \hline 9 & & \\ \hline 10 & Model \\ \hline 11 & Number accepted \\ \hline 12 & Extra \# needed & \\ \hline 13 & Extra funds needed & \\ \hline 14 & Unused funds & \\ \hline 15 & & \\ \hline 16 & & \\ \hline 17 & & \\ \hline 18 & & \\ \hline 19 & & \\ \hline 20 & & \\ \hline \end{tabular} 2b. (15 pts) Two-way table for extra funds (\$) needed with varying acceptance rate and number of offers \begin{tabular}{|c|c|c|c|c|c|} \hline & 25 & 30 & 35 & 40 & 45 \\ \hline 50% & & & & & \\ \hline 55% & & & & & \\ \hline 60% & & & & & \\ \hline 65% & & & & & \\ \hline 70% & & & & & \\ \hline 75% & & & & & \\ \hline & & & & & \\ \hline \end{tabular} 2c. (15 pts) Two-way table for unused funds with varying acceptance rate & \# of offers \begin{tabular}{|c|c|c|c|c|c|} \hline & 25 & 30 & 35 & 40 & 45 \\ \hline 50% & & & & & \\ \hline 55% & & & & & \\ \hline 60% & & & & & \\ \hline 65% & & & & & \\ \hline 70% & & & & & \\ \hline 75% & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|r|} \hline & \multicolumn{1}{|c|}{ A } & \multicolumn{1}{c|}{ B } \\ \hline 1 & 2a. Scholarships Model Spreadsheet (30 pts) \\ 22 & (Complete the model formulation) \\ \hline 3 & Data \\ 4 & Number of offers (Decision) & \\ \hline 5 & Acceptance \% (estimated) & 0.70 \\ \hline 6 & Number available & 20 \\ \hline 7 & Scholarship amount & $25,000 \\ \hline 8 & Total funds available & $500,000 \\ \hline 9 & & \\ \hline 10 & Model \\ \hline 11 & Number accepted \\ \hline 12 & Extra \# needed & \\ \hline 13 & Extra funds needed & \\ \hline 14 & Unused funds & \\ \hline 15 & & \\ \hline 16 & & \\ \hline 17 & & \\ \hline 18 & & \\ \hline 19 & & \\ \hline 20 & & \\ \hline \end{tabular} 2b. (15 pts) Two-way table for extra funds (\$) needed with varying acceptance rate and number of offers \begin{tabular}{|c|c|c|c|c|c|} \hline & 25 & 30 & 35 & 40 & 45 \\ \hline 50% & & & & & \\ \hline 55% & & & & & \\ \hline 60% & & & & & \\ \hline 65% & & & & & \\ \hline 70% & & & & & \\ \hline 75% & & & & & \\ \hline & & & & & \\ \hline \end{tabular} 2c. (15 pts) Two-way table for unused funds with varying acceptance rate & \# of offers \begin{tabular}{|c|c|c|c|c|c|} \hline & 25 & 30 & 35 & 40 & 45 \\ \hline 50% & & & & & \\ \hline 55% & & & & & \\ \hline 60% & & & & & \\ \hline 65% & & & & & \\ \hline 70% & & & & & \\ \hline 75% & & & & & \\ \hline \end{tabular}