Archive

Archive for the ‘Transportation’ Category

SMU Students Aim to Save Lives at Busy Intersection

April 28th, 2017 Comments off

Senior design project featured (click to view)

NBC Channel 5 news story: Southern Methodist University students focus their project on making the intersection of Fitzhugh and Travis streets in Dallas safer for pedestrians. Senior Design team Andrew Brunts, Hailey Phelps, and David Smith built a simulation of Fitzhugh Avenue traffic to evaluate configuration alternatives for a neighborhood improvement organization.

Clustering and Segmentation of Ticketing Data

September 9th, 2015 Comments off

Client: Sabre Airline Solutionssabre
Team: Hunter Ross, Mary Liz Tuttle, Ramon Trespalacios
Faculty Advisor: Dr. Barr   Year: 2014
Documents: Presentation, Report, Video

Sabre Airline Solutions offers data solutions and software to aid airlines sell products, market themselves, and operate efficiently. The company would like to provide traveler segmentation services for their customer reservation system to support various marketing programs. (Segmentation involves classifying prospective buyers into groups, or segments, to create products specifically for each segment.) This project required creating segmentation rules that classify ticket purchase data in this manner.

The senior design team replicated the data to create pre-booking and post-booking results. Pre-booking segmentation will show clusters that do not include variables such as fare and travel time, because these can’t be known until after booking. On the other hand, post‐booking data will provide segments that include purchases made. Pre-booking clusters could be used to make promotions for customers while booking, and post-booking clusters could be used to make promotions after booking.

The team used k-means clustering method and the R software to find the optimal number of clusters in the data and assist Sabre with the design of good fare products. For example, if an airline has created a ticket fare product for a specific market like business‐travelers, the team’s segmentation rules can confirm whether the product is well‐defined and well-targeted.

Frito-Lay Out-of-Stock Inventory Modeling Tool

May 15th, 2012 No comments

Client: Frito Laymicrosoft-powerpoint-8-fritolay_emis
Team
: Matt Alfano, Brittany Masi
Faculty Advisor
: Dr. Barr Year: 2010
Documents
: Presentation, Report, Video

The project is to design and create an out-of-stock inventory tool that is user-friendly and able to historically scan data while predicting inventory shortfall at the club/SKU level. More features of this project include determining what Inventory is needed by club/SKU and determine delivery frequency by club. We decided that only these opportunities fell into the scope of our project.

After consolidating all of the available information into one database we removed unnecessary tables to increase the processing speed of analyzing the product “Spy Reports” generated by their current database queries. We analyzed two of the highest-demand product lines that Frito Lay stocks at Sam’s Clubs nationwide. These two products are Smart Mix and Variety Mix. Read more…

Senior Design Projects & Client Perspectives

May 12th, 2012 No comments

The stories of three Senior Design projects from the clients’ point of view, including North Texas Food Bank, Texas Department of Transportation, and Southwest Airlines:

Transportation Bid Selection Tool

January 20th, 2010 No comments

Client: truckingAlix Partners
Team: Matthew Hale
Faculty advisor: Dr. Barr   Year: 2008
Documents: Final report, final presentation

The main goal of this project was to create a tool that would assist midsize companies in their selection of transportation bids. The tool needed to be easy to use, scalable, reusable, and distributable. In order to accomplish these goals, Microsoft Access was selected as the platform to handle the back-end tasks. By developing a clean front-end for Access, we were able to meet the ease of use requirement while harnessing the power of Access to scale and be reusable. Read more…

Model for Airline Ticket Counter Staffing Using Sabre StaffPlan Staff Forecasting and Planning System

January 20th, 2010 Comments off

sabre-airlinesolutionsClient: Sabre Holdings: Sabre Airline Solutions
Team: Lauren Duplantis, Hamel Husain, Francisco Villagran
Faculty advisor:  Dr. Siems  Year: 2003
Documents: Final report (PDF)

Our project involved working with Sabre Inc. on a problem that they were having with their system StaffPlan that is maintained by their Airline Solutions Division. StaffPlan is an Airline Solutions system that minimizes the number of check-in agents at an airport based on the time of day, queue, airline, destinations, and passenger arrival curve categories. Read more…

Traffic Flow: Exploring Dynamic vs. Static Toll Pricing in a Traffic Network Simulation Model

October 5th, 2009 No comments

trafficflow1Client: CEE Prof. Abdelghani
Team:  Nora Shora, Laura Tatsch
Faculty advisor: Barr   Year: 2006
Documents: Final report (Word), final presentation (PPT)

Many cities across the world have experienced, and are currently experiencing, increased traffic on highways and urban networks.  At the same time, roads and highways have a limited capacity and are only capable of transporting a limited number of travelers. An increase in the number of travelers has increased all of the following factors associated with travel: travel time, number of stops, travel costs, delays, air pollution, accidents, and noise level.

Road pricing is one tactic used as an effective demand management strategy to reduce traffic congestion and improve performance during peak periods in many cities. In our simulation model of Knoxville, TN we added tolls to certain roads in the network in order to acquire data that would help us distinguish whether changing tolls during peak hours would improve average travel time. Read more…

Gulf Freeway Evacuation Model

June 5th, 2009 No comments

09hurricanepres1

Client:
Team: Ava Damri, Calvin Smellage, Al Zinkand
Faculty advisor: Dr. Barr  Year: 2009
Documents: Final report (Word), final presentation (PPT)

Our team examines the evacuation of six cities in the Gulf Freeway area stretching from Galveston in the south, to League City in the north. Any model created to solve the problem of evacuating a large number of people in a short time would need to account for real world complexities, such as multiple on-ramps, carrying capacities of highways, and the time required to close on-ramps in an emergency situation. Read more…