2016美国数学建模MCM c题 翻译:Goodgrant基金会的挑战

The Goodgrant Foundation is a charitable organization that wants to help improve educational performance of undergraduates attending colleges and universities in the United States. To do this, the foundation intends to donate a total of $100,000,000 (US100 million) to an appropriate group of schools per year, for five years, starting July 2016. In doing so, they do not want to duplicate the investments and focus of other large grant organizations such as the Gates Foundation and Lumina Foundation.

Your team has been asked by the Goodgrant Foundation to develop a model to determine an optimal investment strategy that identifies the schools, the investment amount per school, the return on that investment, and the time duration that the organization’s money should be provided to have the highest likelihood of producing a strong positive effect on student performance. This strategy should contain a 1 to N optimized and prioritized candidate list of schools you are recommending for investment based on each candidate school’s demonstrated potential for effective use of private funding, and an estimated return on investment (ROI) defined in a manner appropriate for a charitable organization such as the Goodgrant Foundation.

To assist your effort, the attached data file (ProblemCDATA.zip) contains information extracted from the U.S. National Center on Education Statistics (www.nces.ed.gov/ipeds), which maintains an extensive database of survey information on nearly all post-secondary colleges and universities in the United States, and the College Scorecard data set (https://collegescorecard.ed.gov) which contains various institutional performance data. Your model and subsequent strategy must be based on some meaningful and defend able subset of these two data sets.

In addition to the required one-page summary for your MCM submission, your report must include a letter to the Chief Financial Officer (CFO) of the Goodgrant Foundation, Mr. Alpha Chiang, that describes the optimal investment strategy, your modeling approach and major results, and a brief discussion of your proposed concept of a return-on-investment (ROI) that the Goodgrant Foundation should adopt for assessing the 2016 donation(s) and future philanthropic educational investments within the United States. This letter should be no more than two pages in length.

Note: When submitting your final electronic solution DO NOTinclude any database files. The only thing that should be submitted is your electronic (Word or PDF) solution.

The ProblemCDATA.zip data file contains:

Goodgrant基金会是帮助提高美国本科生大学教育表现的慈善组织。该基金会每年拟共将$ 100,000,000（1亿美元）捐给一些学院，从2016年7月开始，持续五年。他们不希望自己的投资和其他重点大型授予组织（如盖茨基金会和Lumina）重复。

您的团队要求为Goodgrant基金会建立一个模型来确定学校的最优投资策略，来鉴定每所学校的投资金额，这项投资的回报，持续时间。该基金会投资的资金应该使得对学生的表现有很强的正效应的可能性最高。这一战略应包含你推荐的从1到N排序的学校名单(排序基于每个候选学校的数据表明的能有效利用资金的可能性大小)，和预计投资回报ROI。


为了帮助你们，附加的数据文件（ProblemCDATA.zip）包含来自美国国家中心教育统计局的信息（www.nces.ed.gov/ipeds），它包含几乎所有的美国二级学院和美国大学的调查信息的大型数据库，以及各种制度绩效数据学院记分卡数据集（https://collegescorecard.ed.gov）。您的模型和随后的策略必须基于这两个数据集中一些有意义的子集。


除了为您的MCM提交所要求的一页纸的总结，你的报告必须包括一封信给Goodgrant基金的首席财务官（CFO）阿尔法蒋先生，信中需要描述最优投资策略，您的建模方法和主要结果，以及简要讨论你提出的投资回报（ROI）的概念，该投资回报用于评估2016年Goodgrant基金会的捐款和在美国未来的慈善教育的投资。这封信应不长于两页。


注意：当您提交最终电子解决方案不包含任何数据库文件。应提交的唯一的事情就是你的电子（Word或PDF）解决方案。


另：该ProblemCDATA.zip数据文件包含：
?题C - IPEDS UID为潜在的候选Schools.xlsx
?题C - 最近客群组数据（记分卡元素）的.xlsx
?题C - CollegeScorecardDataDictionary-09-08-2015.xlsx

?IPEDS数据Selection.pdf变量

© 2016 COMAP, The Consortium for Mathematics and Its Applications
May be reproduced for academic/research purposes
For More information on COMAP and this project visit http://www.comap.com