1GROUP6ASSIGNINGSTUDENTSTOSCHOOLS1218
14页1、nts to SchoolsDec. 18, 2008徐立平 (Leon)沈山丹 (Lar) 李硕仁 (Lee Seog In)孙显燮 (Son Hyun Sub)Case 5-4Programming & Decision making by Dr. Chen LihuaIMBA2 Group 6Contents 1. Case Overview2. A linear programming model on a Spreadsheet & The Sensitivity report3. Assumption 1 for Problem4. Assumption 2 for Problem 5. Recommendations1. Case OverviewThe Springfield School Board has made the decision to close one of its middle schools at the end of this school year and reassign all of next years middle school stu
2、dents to the three remaining middle schools. The school district provides busing for all middle school students who must travel more than approximately a mile, so the school board wants a plan for reassigning the students that will minimize the total busing cost.The annual cost per students for busing from each of the six residential areas of the city to each of the schools is shown in the table. In term of busing cost per student field, 0 indicates that busing is not needed and a dash indicates
3、 an infeasible assignment.The School board also has imposed the restriction that each grade must constitute between 30 and 36 percent of each schools population. The above table shows the percentage of each areas middle school population for next year that falls into each of the three grades.2. A linear programming model and the sensitivity report Before showing model for this problem on spreadsheet, there are two issues for solving this Case with related to Case 3-5. One thing is that we can se
4、t a linear programming model if there is no additional restriction that each grade must constitute between 30 and 36 percent of each schools population. The other thing is that we can establish this problem as a nonlinear programming model if the additional restriction of the school board is adapted to problem. l A linear programming model Target Cell Total Cost Adjustable Cells Assignment Constraints Area 2 to School 1 = NAArea 5 to School 2 = NAArea 4 to School 3 = NA Total Assignment = Area P
《1GROUP6ASSIGNINGSTUDENTSTOSCHOOLS1218》由会员公****分享,可在线阅读,更多相关《1GROUP6ASSIGNINGSTUDENTSTOSCHOOLS1218》请在金锄头文库上搜索。
2023-01-19 5页
2022-07-27 2页
2023-06-07 21页
2023-10-26 2页
2022-07-24 6页
2022-09-03 2页
2023-07-25 6页
2023-12-30 3页
2024-02-07 3页
2023-09-17 4页