The 2004 AMRE program saw 13 students work on five projects and 3 students work as interns. Last year’s project clients included ProQuest Automotive, ProQuest Business Solutions, Progressive Auto Insurance, The City of Wooster, and The College of Wooster. The projects required students to use a wide range of mathematical and computer skills.
Kenda Albertson, Peggy Winkler, and Jesse Smith worked for ProQuest, which develops and distributes a parts database for the automotive industry. The database is distributed on CD or DVD and in Web form. The parts database (for our purposes) consists of 2D, raster based, black and white line drawings of automobile parts. ProQuest has developed a proprietary image viewer that provides fast and accurate imaging of parts, but the viewer only deals with 2D raster images. Some automotive companies are currently providing ProQuest with part images in vector form. The team was asked to:
After researching vector image formats the team decided to look further into SVG (Scalable Vector Graphics), CGM (Computer Graphics Metafile), and DXF (Data eXchange File). SVG and CGM had already been received by ProQuest and DXF was a natural choice if ProQuest was thinking of moving to 3D images in the future. The team analyzed the formats and compiled information related to the criteria described in the problem. They also analyzed and rated multiple viewers for each formats. This research was designed to get an accurate picture of the advantages and disadvantages of each format so that ProQuest would be able to choose a format that would best suit the company’s needs. Their investigation of 3D formats began with sample images provided by ProQuest that were in XVL (eXtensible Virtual world description Language or eXtended VRML Language). They also found that X3D and WRL were worth investigating. The team provided ProQuest with information about these 3D formats to consider if they choose to adopt 3D images for their parts catalogue.
Jeremy DeGroot and Joel Wietelmann worked on the second project. 
The goal of the second project was to create an easy-to-use web-based contact management software system for the College of Wooster’s Student Affairs Division. The problem this was intended to solve was the communication of information among the widely scattered subdepartments of the Student Affairs Division. A way was needed to easily share information regarding each subdepartment’s interactions with students to help catch problems earlier. Requirements for the software included ease of use, portability, and security. The resulting product, Pansophy Contact Manager, is a web-based application written in the PHP scripting language and designed to run on top of a MySQL database. It provides an intuitive interface for recording and retrieving information about interactions between the College’s Student Affairs Division and its students. Pansophy contains a variety of security mechanisms and supports encrypted data transfer over a network when placed on an HTTPS-enabled web server.
Adam Hanley, Lauren Gruenebaum, and Ali Nau were asked to examine customer retention and price elasticity across various segments of Progressive auto insurance customers, with the purpose of determining which factors make a customer more or less price sensitive. The first part of the project involved extensive background research on why customers choose whether or not to renew their insurance policies, and general information on customer price sensitivity. Part of this included looking at complaints regarding general customer service and the handling of claims.
Data analysis comprised the second half of this project. Using SPSS, the Statistical Package for the Social Sciences, statistical analyses, including linear and logistic regression, in addition to descriptive statistics, were completed for each variable. The relationships between variables were also analyzed using the Cramer’s V statistic. Variables were then examined in conjunction with each other, creating several distinct segments which varied across individual variables; there was significant variation in the price elasticity of these segments.
The team of Gerry Ockers, Liz Whittam, and Becky Young investigated the economic impacts of Rubbermaid’s departure from the city of Wooster. The goal of this project was to provide information to both the city of Wooster and Wayne County public officials in estimating the effects of Rubbermaid’s departure from the Wooster area. The three areas of focus were the impacts on jobs, the housing market, and the tax implications. Techniques used include Location Quotient, Shift-Share Analysis, and Input-Output Analysis.
