Skip to content
Solved Assignments

Optimizing Fleet Efficiency: A Case Study Using Excel Solver

A case study exploring how Excel Solver can be used to optimize fleet efficiency, focusing on cost reduction and resource allocation.

Preview 2 of 4 pages

See the first 2 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    Optimizing Fleet Efficiency: A Case Study Using Excel Solver Solution in both Q/A Type and in Paragraph (write - up) Spreadsheet #3 – Optimizing the fleet Using Solver and Excel software you and your team will answer the following questions: 1. Which ships are the most efficient in the current fleet? Meloodia is the most efficient in the current fleet. Since the highest margin per return trip is $110,258,820, which is corresponding to the ship Meloodia , it can be considered asa most efficient ship in the current fleet. 2. Which ships are the least efficient in the current fleet? New Ferry is the least efficient in the current fleet. Since the lowest margin per return trip is $1,223,780, which is corresponding to the ship New Ferry, it can be considered as a least efficient ship in the current fleet. 3. Which ships have the least cost per passenger mile, and which have the highest cost? The ship ‘Vana - Tallinn’ has the least cost per passenger mile of $8 and the ship ‘AutoExpress’ has the highest cost per passenger mile of $251. 4. Which ships have the best margin and which have the least margin? The ship that has the best margin of $68,912 is ‘Meloodia’ and the ship that has the least margin of $490 is ‘New Ferry’. 5. Based solely on this information, which ships does your group believe are the most expendable for the fleet? Based on the available information, the ship that our group considered to be the most expendable for the fleet is ‘New Ferry’ . Since the ship that has the least margin is ‘New Ferry’, it can be considered as a worst ship and expendable for the fleet. 6. Which ships should continue to stay in the fleet by using Solver software?

  2. Page 2

2 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document
See all

Study this document with CramX

Once it is in your library, every tool can work from it.