OREM 4395 – Senior Design Archive

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…

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…

Client: Methodist Dallas Medical Center
Team: Kyle Chester, Kristin Evanto, and Emily Gray
Faculty Advisor: Dr. Barr
Year: 2010
Documents: Final Report, Presentation

A “hub” of activity at MDMC is the Outpatient Services department. Outpatient Services exists to serve the needs of physicians and surgeons alike with routine x-rays, blood draws to test for Tuberculosis or other ailments, or diagnostics to assess patient health. Many patients who come to Outpatient Services are preparing for surgery and thus need to undergo preliminary screens such as blood draws and EKGs.

The focus of this project is the observation and analysis of the administrative and technical operations within the laboratory component of Outpatient Services. Outpatient Services aims to reduce its patient wait times throughout the entire duration of a patient’s stay in Outpatient Services. Management has expressed a desire to reduce patient wait times such that 95% of all patients wait less than 15 minutes for the Outpatient laboratory department. Read more…

Client: Capstone Asset Management Co.
Team: Mallory Harrison, Natalie Jaroski
Faculty advisor: Dr. Barr   Year: 2010
Documents: Final report (PDF), Presentation (PDF)

Capstone is a privately owned investment advisory firm in Houston, TX that offers privately managed accounts to achieve client’s financial objectives. They currently manage over $3.8 billion in assets for about 3,000 different clients. They provide products and services through three distribution channels: brokers/advisors, institutions/corporations, and high-net-worth individuals. Revenues are generated by marginal product fees associated with assets under management allocated by product.

Capstone has in place a detailed budgeting process but desires to expand the process to include financial modeling to measure profitability by product. Our goal for this project is to develop a model that would calculate existing profitability on assets under management by product. Our second goal is to develop an optimization model that takes into account the revenues and expenses associated with sales of existing products versus the revenues and expenses associated with the development of new products. The final output of the optimization model is to identify the most profitable mix for new product sales. Read more…

Client: Lennox Industries
Team:  Diana Batten, Maddie Kamp
Faculty Advisor: Dr. Siems
Year: 2011
Documents: Final Report, Presentation

Lennox Industries is a residential and commercial heating and air-conditioning company with a 13-15% market share in about 80 countries. Lennox is unique in that they operate as both the manufacturer and distributor of their products selling directly to their customers, typically contractors.

This project identified correlations between customers’ buying patterns and their attrition, or loss of their business. Based on transaction-level data of 4,500 customers over a three-year period, an early-warning model was developed to signal the potential loss of a customer and enable Lennox to act preemptively. The analytics were based on a ranking procedure based on key indicators and a Markov chain analysis with categorical transition probabilities derived from historical data. With this model encapsulated in spreadsheet form with the ability to customize the analysis geographically and seasonally, the results give Lennox management a new tool to maintain their current customers and evaluate new markets.

Client: Arlington Texas Police Department
Team: Ron Andrews, Blake Robinson
Faculty Advisor: Dr. Siems
Year: 2011
Documents: Final Report, Presentation

The Arlington Police Department is responsible for policing the city of Arlington to achieve a safer community. The policing of the city is divided roughly into four main areas (north, south, east, and west) with each respective area possessing its own police station. The Arlington Police Department requested insight into the placement of the police stations to see if they were effectively located to process the level one crimes that originate from each main area. If a main area was not adequately covered, areas could be hypothetically redrawn to accommodate effective policing.

Our method of analysis included the use of in-depth data analysis and a pure network model that had the potential to take into consideration Euclidean distances, time schedules, crime severity and political issues. Our findings indicated that the placement of police stations given current population levels were placed reasonably close to where our model suggested they should be placed. It was also discovered that complex issues such as political issues and crime severity are hard to quantify within a model given due to the ambiguous nature of the data.

Client: Lake Highlands Soccer Association
Team:  Sherif Khalifa
Faculty Advisor: Dr. Barr
Year: 2008
Documents: Final Report (Word), Presentation (PPT)

The scheduling of sports competitions is a challenge for both professional teams, such as the NBA, to amateur leagues. In this project an effective strategy to model sports scheduling is developed.

Lake Highlands Soccer Association was formed in 1972 to promote the sport of Soccer in Dallas’ Lake Highlands area and throughout North Texas and serves as the “Home Association” for about 1,800 youth players from neighborhoods in the Dallas and Richardson school districts. The LHSA’s Boys League Director provided data that is needed in developing their schedules and a constraint-programming model was implemented  that meets all their requirements and delivers a far more effective solution.

Similar to many leagues, Lake Highland Soccer Association uses an inefficient method of scheduling to determine all leagues games. There is no model in place, and schedules are done manually, leading to many wasted hours to determine a schedule that may be suitable to the each league’s constraints. Read more…

Client: Heeling Sports Limited
Team: Gustavo Carrere and Marcus Klintmalm
Faculty Advisor:  Dr. Siems
Year: 2005
Documents: Final Report (PDF)

The Heeling Sports Limited is a Dallas-based footwear designer, manufacturer and distributor. The Company’s mission is to generate new and exciting footwear utilizing contemporary and progressive styles with comfort-enhancing performance features. To generate new footwear style HSL will introduce one product per year through acquisition or in-house development.

Extensive interviews and observation lead us to several bottlenecks in the order process. Most often these bottlenecks concerned procedure rather than anything else. There are many simple, no-cost options to optimizing the Heelys order process. Read more…

Team:  Julianna LaFerney, Casey O’Brien
Faculty Advisor: Dr. Siems
Year: 2009
Documents: Final Report (Word), Final Presentation (PPT)

Telecommunications industry is one of the most profitable and rapidly developing industries in the world and it is regarded as an indispensable component of the worldwide utility and services sector.  In recent years, the number of mergers and acquisitions in Telecom Sector has been increasing significantly, and this event study explores mergers and acquisitions in the United States’ telecommunications industry. The study analyzes the history of mergers and acquisitions in the telecommunications industry using market and event study modeling while using the Verizon and Alltel merger as the case study. Read more…

Team: Kathryn Gotcher, Kyle Merino, Gregory Moran
Faculty Advisor: Dr. Siems   Year: 2009
Documents: Final Report (Word), Final Presentation (PPT)

In the present global economic state, finding ways to improve a nation’s economy is vital to government leaders. The problem presented to us was to study various political institutions and policies of the world’s nations and determine which measures, if any, are accurate predictors of economic health and growth. In particular, we were interested in the effect that measures of free trade would have upon the economy. Read more…