In-Class case study for Lecture 4

In-Class case study for Lecture 4 - report that answers...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
In-Class Case Studies for Lecture 4 Case Study 1 Benjamin Travis and Brady Austin are co-owners of B&B Travel Consultants, a medium size business in Seattle with several branch offices. B&B specializes in selling cruise packages. Ben and Brady maintain a workbook that contains the following list for each cruise package sale: A. LOCATION # —A unique number that identifies which office location recorded the sale B. TRAVEL AGENT # —A unique number that identifies which travel consultant recorded the sale C. CRUISE LINE —The name of the cruise line for which the package was sold D. TOTAL PACKAGE PRICE —The price charged to the customer for the package E. COMMISSION —The amount of money B&B made from the sale of the package Ben and Brady have decided to scale back their operations. So, they’re looking to you for help. The workbook name is XLMD_Travel.xls and you can find it on the Web site that supports this text at www.mhhe.com/haag (select XLM/D). Using AutoFilter, conditional formatting, and pivot tables, prepare a short
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: report that answers each of the following questions and illustrates the justification for your answers. a. Which, if any, location should be closed? b. Which, if any, travel consultants should be downsized? c. On which cruise lines should B&B focus its sales efforts? Case Study 2 CREATE A LIST FOR A BOOKSTORE Suppose that youre the manager for your schools bookstore. Your task is to create a list in a workbook that contains information about the textbooks it sells. In addition to tracking price, first author name, and publisher, identify five other pieces of information for each textbook. For this list, first provide a list definition table. Second, enter some information for 20 textbooks. Third, illustrate the use of the basic AutoFilter function, the Custom AutoFilter function, conditional formatting, and pivot tables. Finally, address how your bookstore might be able to use this information to support its decision-making tasks....
View Full Document

This note was uploaded on 07/15/2011 for the course EST 325 taught by Professor Wan during the Spring '09 term at SUNY Stony Brook.

Page1 / 2

In-Class case study for Lecture 4 - report that answers...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online