• Harrison, Young, Pesonen and Newell, Inc.: Direct Response TV, The Super-Tel Campaign

    An analyst at Harrison, Young, Pesonen, and Newell, Inc. had developed the media plan for a discount long distance telephone carrier (Super-Tel) and was supervising its execution. At the start of week eight of the twelve-week direct response television campaign she was monitoring customer response data from the telemarketing contractor in order to judge the performance of the advertising plan, with the objective of making adjustments to improve the plan. The analyst hoped to fine-tune the final weeks of advertising in order to maximize the number of customer orders received by Super-tel, while minimizing the costs of obtaining those orders. Could she use a decision support system to solve this problem. (A Microsoft Excel data file is available for use with this case, product 7A98E028.)
    詳細資料
  • Ivey School of Business: The Doctoral Tracking Database

    Richard Ivey School of Business has a need for the creation of a database, to be used for managing information about students and their courses of study, in its Business PhD program. Information on students to date has been maintained in a mix of paper and computer-file systems. The program director would like to develop a database, using a facility such as Microsoft Access, to be used for this purpose. The case provides examples of the actual forms and data maintained currently, and challenges the students to first create an entity-relationship data model, then a design for a relational database.
    詳細資料