Develop a spreadsheet model for this situation, and apply whatever analysis tools you deem appropriate to help the admissions director make a decision on how many scholarships to offer.
The admissions director of an engineering college has $500,000 in scholarships each year from an…
