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.)
11 freelancers are bidding on average $49 for this job
Being a n investment banker, making presentation and financial models are central to our professional life. Therefore, I am advance user of MS Excel and Ms Power point. For more details kindly contact me