2. Get ready

Use spreadsheet software to open the Factors file.

3. Now you try it

1. Select the cells C11:C14, press [Ctrl]+[C] to copy the formulas, select cells D11:F14, then press [Ctrl]+[V] to paste the formulas

2. Click cell C15, press [Ctrl]+[C] to copy the formula, select cells D15:F15, then press [Ctrl]+[V] to paste the formula

Which tour has the highest weighted total?

E X Tours to offer Quest Corporate customers A1. Tours to offer Quest Corporate Customers 2 Ratings (-5) Alaska Caribbean Mediterranean Hawaii Activity level 5 Meeting facilities 6 Travel time 7 Weather 9 Weighted factors Weight Alaska Caribbean Mediterranean Hawaii Activity level 8o 2O 12 Meeting facilities 1O io 13 Travel time 50 150 14 Weather 2 O 40 15 Total 28o. ioo 2o 21 22 E X Tours to offer Quest Corporate customers A1. Tours to offer Quest Corporate Customers 2 Ratings (-5) Alaska Caribbean Mediterranean Hawaii Activity level 5 Meeting facilities 6 Travel time 7 Weather 9 Weighted factors Weight Alaska Caribbean Mediterranean Hawaii Activity level 8o 2O 12 Meeting facilities 1O io 13 Travel time 50 150 14 Weather 2 O 40 15 Total 28o. ioo 2o 21 22