Archive

Archive for the ‘Dallas-Ft. Worth Area’ Category

Improving Patient Flow in LBUCC’s Obstetrics

December 30th, 2017 No comments

ClientLos Barrios Unidos Community Clinic
Team: Shorjoe Bhattacharya and Harvey Hauw
Faculty Advisors:  Drs. Barr, Bing         Year: 2017
Documents: Presentation, Report

Los Barrios Unidos Community Clinic, located in West Dallas, offers services in many different healthcare areas including pediatric care, behavioral health, and obstetrics. The focus of this project was in the obstetrics department, at which patient satisfaction was dropping due to long wait times leading to long appointment durations.

Our team was tasked with collecting time and motion data, mapping out current workflows of the clinic, running a simulation model, and analyzing the results. We collected data with a simple yet effective time and motion study where we asked the individual patients to log their times as they went station to station in the clinic. We also learned the workflows and layout of the clinic by talking to staff members at the location. This was data was used in a computer simulation model of the Obstetrics wing, developed using “MedModel” (specialty healthcare facilities simulation software). The simulation results revealed ways to reduce patient wait times to improve the patient experience at LBUCC.

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.

Optimizing Product Transportation from Hispanic Markets

May 15th, 2012 No comments

Client: Frito Laygamesa__2006_-logo-cb8481d8e4-seeklogocom
Team: Javier Gonzalez, Fernando Sada, Marcelo Sada
Faculty Advisor: Dr. Siems
Year: 2011
Documents: Final Report, Presentation

In order to satisfy the large Hispanic market in the United States, Frito Lay imports products manufactured in Mexico by Gamesa, a sister company to Frito Lay due to the fact that they are both owned by PepsiCo. Gamesa has plants all across Mexico, having the main ones located in Celaya, Vallejo, Obregon and Monterrey. In the past, all products being imported into the U.S were produced in Obregon, a city in Northwestern Mexico. As of today, the Hispanic population has dispersed all across the country, increasing Gamesa’s market to a large portion of it. Gamesa’s products are now being distributed all the way from California, to Texas, and onto the East Coast and Midwest. Imports have increased so much that in order to satisfy the demand, Gamesa has started producing all across Mexico for exports. 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:

Rental Engine Check-in and Repair Optimization Scheduling

March 7th, 2012 No comments

Client: Pratt & Whitney Engine Servicesprattwhitney
Team:  Michael DeVore
Faculty advisor: Barr   Year: 2004
Documents: Final report (Word)

The Pratt and Whitney Addison Service Center is a unique situation involving rental engines and their repair.  These engines are delivered by a 3rd party carrier and must be checked over and repaired if necessary.  At that point the engine must be sent back out to either the customer who rented it or to another intermediate step.  The Addison, TX Service Center Manager requested help in optimizing the employee’s time spent on these rental engines.  He wanted to know what could be done to improve Service Center response time and maximize output.  Read more…

Cross-Staffing Problem

March 7th, 2012 No comments

Client: Carrollton Concentralogo_concentra1
Team: Daniel Olivares, Beverly Ross, Devin Kyles
Faculty Advisor: Dr. Siems
Year: 2011
Documents: Final Report, Presentation

Concentra presented the problem of cross-staffing some of its employees throughout its centers. The problem addresses a potential decision of staffing methods of which the options were to staff to the market or create a cross-staffing model. These decisions relied upon the variability of patient visits among the centers and the ability to schedule based on future forecasted patient visits. Ultimately, the question was to find if there is an opportunity to staff across all centers or must it be dynamically adjusted based on forecasting by center. A solution to this problem would potentially decrease patient wait times and turnaround times (a patient’s check-in time to checkout time), idle times in which staff members are not performing any duties, and times in which centers experience a heavier traffic flow. Read more…

Optimal Phasing of the Opening of Buildings in an Office Complex

March 7th, 2012 No comments

Client: Texas Plaza, Prof. Peisertxplaza
Faculty advisor: Dr. Barr
Year: 1982
Documents: Final report (PDF)
Appeared in different form as a journal cover article.  R. Peiser and Scot Andrus, Phasing of Income-Producing Real Estate, Interfaces 13:5 (1983) 1-9.

Integer programming techniques were used to determine the order in which to build office buildings and when to put the space on the market for a seven-building, 90-acre, mixed-use real estate project in Texas. The output of the optimization provided development managers with the schedule for opening each building, the amount of space to be leased each year in each building, and the annual cash flows to the owner.

Call Center Personnel Scheduling

February 1st, 2012 No comments

Client: Federal Reserve Bank of Dallas
Team: Alex Grosjean, Brianna Bauer
Faculty Advisor: Dr. Siems
Year: 2011
Documents: Final Report, Presentation

Every month, the Treasury sends out roughly ten million physical checks for Social Security payments and other benefits. On average, it costs them about $1 apiece to send these checks via surface mail. As a cost saving method, the Treasury is now requiring these recipients to use direct-deposit methods, and will eventually cease to send out physical checks.

This is where the Federal Reserve’s GoDirect program comes in. GoDirect is both a call center and a website which helps the recipients switch over to direct deposits, which only cost about 9 cents per person. The return on investment for this project is expected to be ten years. The Call Center wishes to optimize the schedule of employees to handle these incoming calls; thus our goal is to design a model to minimize the cost associated with the call center. Read more…

Lockheed Martin: Electromagnetic Pulse Modeling

January 31st, 2012 No comments

EMP blast effects

Client: Lockheed Martin Missiles and Fire Control
Team: Stephen Beckert, Brandon Joslin, Pierce, Meier
Faculty Advisor: Dr. Barr
Year: 2010
Documents: Final Report, Presentation

Lockheed Martin presented us with a project more exciting than we could ever imagine: aiding the research into ways to model the effects of an Electromagnetic Pulse (EMP). EMP is extremely devastating and can be caused by both natural and man-made events. EMP primarily affects electronic devices, rendering them useless or destroyed. Since the United States is heavily dependent on electronic interfaces, we are extremely vulnerable to this effect. In addition to this vulnerability to the EMP effect, the United States has a complex system of connected critical infrastructures that have not been studied as interrelated systems. This presents a major problem, how can one forecast the possible failures of such a massive complex system? Read more…