what-if model

The project objective is to reduce the cost and improve the utilization of the shuttle service by exploring the possibility of eliminating the low-number- passenger routes and optimizing the schedules and paths of the current routes. The project will include assessing the current routes used by the shuttles, the necessary number of stops offered on each route, and the utilization of the routes during the peak and slow training times. o While the housing locations themselves were a point of concern brought to our attention by FAA Student Services staff the low housing peridium offered to students limits their housing options and will not be included in our project scope because it is not under FAA supervision. However, we were asked to include a crime report or crime statistics of the locations offered to students as a tool to aid them in their housing selection. what i need you to do is: Perform “what-if” analysis on the cost for different alternatives o Look at cost of FAA owning and maintain shuttle fleet instead of contracting to third parties by looking at shuttle investment, insurance, and driver costs and if there is a cost worthy payoff over time. o Analyze different stops for existing route to grab more students with fewer stops. o Look at redesigning routes 1 and 3 so that if route 3 is eliminated, they may be able to accommodate these students. o Perform time study to determine time impact on purposed alternatives. (you can put random numbers and i will plug the real data, so i just need the model.)