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

100%

  1. Page 1

    Optimizing Fleet Efficiency: A Case Study Using Excel Solver, page 1Optimizing Fleet Efficiency: A Case Study Using Excel SolverSolution inbothQ/A Type and in Paragraph(write-up)Spreadsheet #3–Optimizing the fleetUsingSolver and Excel software you and your team will answer the following questions:1.Which ships are the most efficient in the current fleet?Meloodiais the most efficient in the current fleet.Since the highest margin per return trip is$110,258,820, which is corresponding to the shipMeloodia,itcan be considered asa mostefficient 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 thelowestmargin per return trip is$1,223,780, which is corresponding to the ship New Ferry,itcan be considered as aleastefficient 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 theleast cost per passenger mileof $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 marginof $490 is ‘New Ferry’.5.Based solely on this information, which ships does your group believe are themostexpendablefor the fleet?Basedon the available information, the ship that our group consideredto be the most expendablefor the fleet is ‘New Ferry’. Since the ship that has the least margin is ‘New Ferry’, it can beconsidered 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

    Optimizing Fleet Efficiency: A Case Study Using Excel Solver, 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

More Operations Management study materials

See all

Study this document with CramX

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