The Goodgrant Foundation is a charitable organization that wants to improve education performance of undergraduates attending colleges and universities in the US. So the foundation plans to contribute a total of US 50...The Goodgrant Foundation is a charitable organization that wants to improve education performance of undergraduates attending colleges and universities in the US. So the foundation plans to contribute a total of US 50 million for a suitable team of schools per year under the condition of avoiding repeated other large grant organizations’ investment. The DEA (Data Estimate Analysis) model is developed to determine an optimal investment strategy for the Goodgrant Foundation. In this paper, two questions were solved: how to choose a suitable team of schools and how to allocate the investment. Before the establishment of the model, the EXCEL software is used to preprocess data. Then the DEA model which includes two models in the paper is developed. For the first question, the CCR model is established to rank schools which used efficiency from DEAP 2.1. For the second question, the resource allocation model is established to allocate investment amount by weights of allocation from MATLAB software. Accordingly, the optimal investment strategy is received for the Goodgrant Foundation. Through the analysis above, 23 from 293 schools are selected to invest. Then the schools are ranked and the investment of US 50 million for 23 schools is allocated.展开更多
文摘The Goodgrant Foundation is a charitable organization that wants to improve education performance of undergraduates attending colleges and universities in the US. So the foundation plans to contribute a total of US 50 million for a suitable team of schools per year under the condition of avoiding repeated other large grant organizations’ investment. The DEA (Data Estimate Analysis) model is developed to determine an optimal investment strategy for the Goodgrant Foundation. In this paper, two questions were solved: how to choose a suitable team of schools and how to allocate the investment. Before the establishment of the model, the EXCEL software is used to preprocess data. Then the DEA model which includes two models in the paper is developed. For the first question, the CCR model is established to rank schools which used efficiency from DEAP 2.1. For the second question, the resource allocation model is established to allocate investment amount by weights of allocation from MATLAB software. Accordingly, the optimal investment strategy is received for the Goodgrant Foundation. Through the analysis above, 23 from 293 schools are selected to invest. Then the schools are ranked and the investment of US 50 million for 23 schools is allocated.
