Lecture_02_Completed - Dollars per Euro Origin Names Charleston Durham Boston Reno 1.32 You are a transporter You carry loads from the origin and carry

# Lecture_02_Completed - Dollars per Euro Origin Names...

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

Dollars per Euro 1.32 Origin Names Cost (Dollars) Charleston 45 Durham 30 Boston 66 Reno 21 Charleston Durham Boston Reno Destination Names Reward (Euro) Revenue in Dollars 45 30 66 21 Brindisi 41 54.12 9.12 24.12 -11.88 33.12 Naples 68 89.76 44.76 59.76 23.76 68.76 Florence 41 54.12 9.12 24.12 -11.88 33.12 Prato 65 85.8 40.8 55.8 19.8 64.8 Cinque Terra 29 38.28 -6.72 8.28 -27.72 17.28 Sum 478.32 Max 68.76 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.

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

Want to read all 3 pages?

• Spring '13
• KATOK,ELENA
• Harshad number, Charleston, ='2-way Data Table, Max 68.76