The admissions director of an engineering college has $$$ in scholarships each year from an endowment to offer to$$ high$-$achieving applicants. The value of each scholarship offered is $$$ $($thus$,$ scholarships are$$ offered$).$ The benefactor who provided the money would like to see all of it used each year for new students.$$ However, not all students accept the$$ money; some take offers from competing schools. If they wait until the end of the admission deadline to decline the$$ scholarship, it cannot be offered to someone else because any other good students would already have committed to other programs.$$ Consequently, the admissions director offers more money than available in anticipation that a percentage of offers will be declined. If more than students accept the$$ offers, the college is committed to honoring$$ them, and the additional amount has to come out of the$$ dean's budget. Based on prior$$ history, the percentage of applicants that accept the offer is about $\%.$ Develop a spreadsheet model for this situation to evaluate how much money must be allocated from the$$ dean's budget based on the number of scholarships$$ offered, $.$