Lecture_02_Shell - Dollars per Euro Origin Names Charleston Durham Boston Reno 1.32 Cost(Dollars 45 30 66 21 You are a transporter You carry loads from

# Lecture_02_Shell - Dollars per Euro Origin Names Charleston...

This preview shows page 1 - 3 out of 3 pages.

Dollars per Euro 1.32 Origin Names Cost (Dollars) Charleston 45 Durham 30 Boston 66 Reno 21 Destination Names Reward (Euro) Brindisi 41 Naples 68 Florence 41 Prato 65 Cinque Terra 29 You are a transporter. You carry loads from the origin and carry them to the destination for a profit. For each load you carry, you have to pay for the load at the origin, but then you get paid for the load at the destination, according to the rates on the left. 1 - Translate the Euros to Dollars 2 - Use paste special to paste the origins above the destinations horizontally. 3 - Using ONE FORMULA, calculate the profit on each route in this 2d array. 4 - If you did each of the 20 routes, what would be your total profit? What is the route with the max profit? 5 - Using Goalseek, determine what the exchange rate must be in order for the Charleston-Cinque Terra route to be positive. 6 - Show the formulae, and show them in R1C1 style.

#### You've reached the end of your free preview.

Want to read all 3 pages?

• Spring '13
• KATOK,ELENA
• Standard Deviation, English-language films, United States dollar, Cinque Terra