what-if model...
$10-50 USD
Paid on delivery
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.)
Project ID: #17727428
About the project
10 freelancers are bidding on average $51 for this job
hello! I am confident that I can deliver this project for you and you can be assured of a quality and accurate output from me. thanks
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
I do this kind of analysis daily at my job as FInancial Auditor. Please contact me to see how I can help you. Thanks, Adrian
I can complete your project in given period of time and with valid result Relevant Skills and Experience Creative thinking , goal oriented
Since I am a Transport and Logistics undergraduate I have experience in analyzing similar problems. I will use operation research methods and project appraisal techniques to reduce the cost and optimize the bus stops/ More