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.)
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work.
Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction.
I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
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
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/beneficiaries of the shuttle service.
I am Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are looking for data entry or search work, I am the Right person for you