Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A. Click cell E13 and insert a lookup function that looks up the tour code, compares it to the tours table, and returns the departure

A. Click cell E13 and insert a lookup function that looks up the tour code, compares it to the tours table, and returns the departure date. Copy the function down through cell E22.

B. Click cell F13 and insert a lookup function that looks up the tour code, compares it to the tours table, and returns the base cost of the trip. Copy the function down through cell F22.

C. In cell G13, insert a formula that adds taxes and fees to the base cost of the trip (in cell F13) by using the percentage value in the input area. Use a mixed reference to the cell containing 20% in the input area above the data. Copy the formula down through cell G22.

D. In cell H13, insert a PMT function to calculate the payments for students who want to pay for their trips in three installments. Use the interest rate and months in the input area above the data. Use appropriate relative, mixed, and/or absolute cell references in the formula. Make sure the result is a positive value. Copy the function down through cell H22.

E. Click cell I13 and calculate the agent commission using the base cost of the trip and a VLOOKUP function that returns the commission rate based on the base cost of the trip using the rates lookup table. The function should then calculate the monetary value of the commission. Copy the function down through cell I22.

The first image is the "Lookup Table" and the second is where the data is being input on the Data.

Package 1 Base Price Commission 2 $1,699 3 $1,749 4$1,799 5 $1,849 6 $1,899 Tour Description 10 Adventures in Canada 20 Check Out the Czech Republic! 30 Croatian Wonders 40 Live it Up London 50 Parisian Pleasures 60 Roaming Rome 70 Viva Es Departure Base Cost 6/11/16 $1,699.00 6/4/16 $1,799.00 6/11/16 $1,899.00 6/18/16 $1,699.00 6/25/16 $1,749.00 6/11/16 $1,849.00 /16 $1,799.00 3.0% 4.0% 4.5% 

 

A B D. F G H. Departure Base Cost 6/11/16 $1,699.00 6/4/16 $1,799.00 6/11/16 $1,899.00 6/18/16 $1,699.00 6/25/16 $1,749.00 6/11/16 $1,849.00 6/25/16 $1,799.00 1 Base Price Commission Package Tour Description Adventures in Canada Check Out the Czech Republic! 2 $1,699 2.5% 10 $1,749 3.0% 20 4 $1,799 3.5% 30 Croatian Wonders Live it Up London Parisian Pleasures Roaming Rome Viva Espaa $1,849 4.0% 40 6. $1,899 4.5% 50 7 60 8 70 9. 10 11 12 13 14 15 16 17 18

Step by Step Solution

3.46 Rating (149 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Chemical Analysis

Authors: Daniel C. Harris

8th edition

1429218150, 978-1429218153

More Books

Students also viewed these Computer Network questions

Question

Describe the Gestalt approach to the mind brain problem.

Answered: 1 week ago