Determine the minimum, average, and maximum payment (Lowest, Average, and Highest), respectively.

­­EMPIRE STATE COLLEGE

MBA /PM Certificate Program

Assignment #6 Colorado Trip

Several years ago, Connor and Siobhan Dempsey moved to Boulder, Colorado, drawn by their love of the mountains and their interest in outdoor activities of all kinds. This interest led them to form the Mountain River Adventures center. The center began as a whitewater rafting tour provider, but quickly grew to encompass other activities, such as canoeing, hiking, camping, fishing, and rock climbing.

From the beginning, Connor and Siobhan have used computers to help them manage all aspects of their business. They are exploring using Excel to store information about clients, equipment, and types of guided tours they provide.

Please help this company to develop a Colorado Trip management system.

  1. Download Assignment 6 Colorado Trip workbook (Excel file) and save it as your name A6 Colorado Trip Lookup.
  2. Fill in Cover Sheet.
  3. On Trip Data Sheet,

Insert a new column after the Region column and label it as New Region. Create Input Data Dropdown List for Region and fill in the data from the drop-down list.

  1. Using Lookup to fill in Commission Rate (Set up a commission table first as shown below).
  2. Calculate total commission amount.
  3. Using Lookup to fill in Salary (Set up a Salary table first as shown below).
  4. Calculate total payment (Commission and Salary).
  5. Determine the minimum, average, and maximum payment (Lowest, Average, and Highest), respectively.