Colorado Trip

Assignment #6 Colorado Trip


Don't use plagiarized sources. Get Your Custom Essay on
Colorado Trip
Just from $13/Page
Order Essay

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 (East, West, South and North) and fill in the data from the dropdown list.

  1. Using vLookup to fill in Commission Rate (Set up a commission table first as shown below).
  2. Calculate total commission amount.
  3. Using hLookup 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.

Make sure to save your work

  1. On Trip Fee Sheet: Using hLookup to set up only one Lookup table. After you finish the following processes, when you enter a trip ID, the rest of information filled in the table automatically:
    1. Using Trip ID to lookup each trip information.
    2. Calculate field Trip Fee that times Fee and Person.
    3. Use the If function to reduce TripFee by 10% if the people is greater than or equal to ten (10).
    4. Calculate Total trip fee.
  2. Save your work for submission.




Commission Table
Sale Bonus
0 0
10000 0.03
 20000 0.05
30000 0.06
40000 0.07
50000 0.08
60000 0.09
70000 0.1



Associate Senior Staff
 $  54,500.00  $  46,500.00 $  38,500.00











Examples Entering Trip ID 3002, 3009.





Essay Assign
Calculate your paper price
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

All our papers are original and written from scratch. We will email you a plagiarism report alongside your completed paper once done.

Free Revisions

All papers are submitted ahead of time. We do this to allow you time to point out any area you would need revision on, and help you for free.


A title page preceeds all your paper content. Here, you put all your personal information and this we give out for free.


Without a reference/bibliography page, any academic paper is incomplete and doesnt qualify for grading. We also offer this for free.

Originality & Security

At Essay Assign, we take confidentiality seriously and all your personal information is stored safely and do not share it with third parties for any reasons whatsoever. Our work is original and we send plagiarism reports alongside every paper.

24/7 Customer Support

Our agents are online 24/7. Feel free to contact us through email or talk to our live agents.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

We work around the clock to see best customer experience.


Flexible Pricing

Our prices are pocket friendly and you can do partial payments. When that is not enough, we have a free enquiry service.


Admission help & Client-Writer Contact

When you need to elaborate something further to your writer, we provide that button.


Paper Submission

We take deadlines seriously and our papers are submitted ahead of time. We are happy to assist you in case of any adjustments needed.


Customer Feedback

Your feedback, good or bad is of great concern to us and we take it very seriously. We are, therefore, constantly adjusting our policies to ensure best customer/writer experience.