what-if model...

Closed Posted 5 years ago Paid on delivery
Closed 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.)

Excel

Project ID: #17727428

About the project

10 proposals Remote project Active 5 years ago

10 freelancers are bidding on average $51 for this job

Tanmoy236

"""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 m More

$150 USD in 1 day
(222 Reviews)
6.8
sevillajk01

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

$40 USD in 10 days
(27 Reviews)
4.5
Baderah

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

$35 USD in 10 days
(25 Reviews)
3.9
AMPaunescu

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

$50 USD in 1 day
(4 Reviews)
1.9
Munivijay

Excel Relevant Skills and Experience Ns office

$35 USD in 10 days
(0 Reviews)
0.0
seema9010

I can complete your project in given period of time and with valid result Relevant Skills and Experience Creative thinking , goal oriented

$35 USD in 10 days
(0 Reviews)
0.0
Madushan94

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

$30 USD in 7 days
(0 Reviews)
0.0
Kkavindu

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 f More

$35 USD in 10 days
(0 Reviews)
0.0