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.
Image of page 1
Image of page 2

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes