Optimizing Fleet Efficiency: A Case Study Using Excel Solver
- Operations Management
- 4 pages
- Shared May 2025
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.
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?
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 documentMore Operations Management study materials
See all
Textbook GuidesSolution Manual for Operations and Supply Chain Management, 14th Edition
Operations Management
342 pages133downloadsFeb 2025
Textbook GuidesManaging Quality: Integrating the Supply Chain, 6th Edition Solution Manual
Operations Management
262 pages115downloadsFeb 2025
Textbook GuidesOperations Management, (Mcgraw-hill Education Operations and Decision Sciences) 1st Edition Solution Manual
Operations Management
153 pages91downloadsFeb 2025
Textbook GuidesSolution Manual For Matching Supply with Demand: An Introduction to Operations Management, 4th Edition
Operations Management
76 pages36downloadsFeb 2025
Class NotesLecture Notes for Operations Management, 2nd Edition
Operations Management
95 pagesMay 2025
Class NotesLT DQ Bottleneck Exercise Process Map
Operations Management
1 pageMay 2025
Class NotesPROCESS DESIGNS AND SUPPLY CHAINS PART 2 - OPS/571
Operations Management
7 pagesMay 2025
Textbook GuidesManaging Operations Across the Supply Chain 3rd Edition Solution Manual
Operations Management
481 pagesMay 2025
Study this document with CramX
Once it is in your library, every tool can work from it.

