Archive

Archive for the ‘Methodology’ Category

Tuning-In on the Market: The Financial Impact of Project Delays in Product Development

June 23rd, 2010 No comments

logo_microtuneClient: Microtune Inc.
Team: Andrew Bass, Chris Ginder, Shan Zaidi
Faculty Advisor: Dr. Siems
Year: 2009
Documents: Final Report (Word), Final Presentation (PPT)

The problem our team faced was how to account for the financial impact of project delays in product development. Microtune had a product in the market and a new product was under consideration to replace the existing product. The goal was to determine the value of the new product to the firm. In order to generate a cost/benefits analysis for the implementation of a product we developed a series of models in Excel to account for various uncertainties. Read more…

The Wealth of Nations: A Study of Political Institutions and Economic Growth

June 23rd, 2010 No comments

globe_money_article
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…

Transportation Network for Williams Technologies

January 20th, 2010 No comments

williamstechnology_networkflowdiagramClient: Williams Technologies, Inc.
Team: Erik Wikstrom, Jeff Cate
Faculty advisor:  Dr. Barr  Year: 1996
Documents: Final report (PDF)

Williams Technologies Incorporated (WTI), intends to increase customer satisfaction by decreasing time-to-market of its products, namely re-manufactured transmissions. WTI believes this goal can be accomplished by developing a more efficient shipping system, while minimizing the cost-to-market. This new system may be developed in-house or outsourced. Therefore, WTI needs an in-house solution that can be compared to those submitted by outside sources. 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…

Film Shoot Scheduling with Constraint Programming

October 7th, 2009 No comments

Client:film_shoot
Team: Jay Mandyam
Faculty advisor:  Dr. Barr  Year: 2008
Documents: Final report (PDF)

In Hollywood, the Assistant Director is in charge of creating the shooting schedule and the Unit Production Manager has the task of making sure that each and every crew position is filled for every day of shooting. On smaller, independent, low-budget movies, however, scheduling is at the mercy of the actors and the crew since they usually work for free or for a small stipend. It thus falls on the producer to create the shooting schedule based on people’s availabilities. Typically, the “easiest” way to approach this is to do it manually, with a lot of guessing, testing, and revising. Read more…

Frito-Lay, Inc. and Sam’s Club: The Pick N’ Pack Aggregate

October 7th, 2009 No comments

fritolay_samsClient: Frito-Lay, Inc. and Sam’s Club
Team: Christian Edison, Ashley Mills, Stephen Rumpler
Faculty advisor:  Dr. Siems  Year: 2005
Documents: Final report (PDF)

Working with the Frito-Lay Supply Chain Department, our team has found an improved inventory process that will increase in-stock performance at Sam’s Clubs. Sam’s Club demands a 99.8% in-stock performance. Currently, Frito-Lay is not meeting this demand, therefore improvements must be made.

Analyzing Frito-Lay’s current inventory replenishment process, we discovered several problems. Some of these problems included inconsistencies in taking inventory at the clubs, negligence of inventory worksheets, and lack of communication. After further analysis, we discovered that forecasting more accurately would prevent some of these problems. There was a new challenge: finding a method of forecasting the new product line, Pick ‘N Pack. With very little historical sales, it was difficult to forecast sales. Read more…

More Than Just Great Food: Factors Influencing Customer Traffic in Restaurants

October 5th, 2009 No comments

Client:
Team: Emily Moravec, Megan Siems, Christine Van Horn
Faculty advisor:  Dr. Siems  Year: 2009
Documents: Final report (Word), Final presentation (PPT)

Although our client is a world leader in casual dining, the company experienced a decrease in overall customer traffic from one year to the next at one of the specific casual dining brands. As the company invested time and money into marketing campaigns for this restaurant chain throughout the year, they were interested in what caused the overall percent change in customer traffic from the first half of fiscal year 2008 (from now on referred to as 1HF08) to the first half of the fiscal year 2009 (1HF09) to be -3.74%. Read more…

Quest Resource: Natural Gas Marketing

October 5th, 2009 No comments

Award Winner: Omega Rho National
Student Project Competition
quest1
Client:
Quest Resource, Inc.
Team:  John Jarvis, Claudia Johnson, Liana Vetter
Faculty advisor: Barr   Year: 2004
Documents: Final report (Word), final presentation (PPT)

Currently, Quest guarantees about 85% of its gas through monthly contracts, while selling the remaining at the daily price. The amount to guarantee per sale point per month is a major decision within Quest. The motivation for Quest to optimize this process is two-fold. First, by paying close attention to past production, optimization can help assure that Quest will rarely produce under their monthly guarantee and will never incur a penalty for that underproduction. Second, through researching the historical relationship between Quest’s contract prices and the corresponding market prices for each month, Quest can better estimate the contract volume that will maximize revenue. Read more…

Expediting the Changeover Time at the American Airlines Center

October 5th, 2009 No comments

Client: American Airlines Centeraac
Team:  Andrew Conway, Marcos Garza, Tabatha G. Olaechea, Jennifer Keen, Marcus Wentrck
Faculty advisor: Barr   Year: 2004
Documents: Final report (Word), final presentation (PPT)

The American Airlines Center is a dual – purpose facility; they house the NBA’s Dallas Mavericks as well as the NHL’s Dallas Stars and must accommodate them both through out their respective seasons.  The AAC is setup to change back and forth to both set ups.  Making a quicker transition time when switching from a basketball court to a hockey rink would decrease scheduling conflicts between the two teams, and possibly allow for an increase in other sports; and non-sporting (i.e. concerts, seminars, rodeos, etc.) events to take place in the arena.  This could potentially increase revenue for the AAC.  As of right now they do not make much money on the Maverick’s and Star’s games, so by decreasing changeover time, they would be able to bring in other venues to increase the amount of money they make in a fiscal year.

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…