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.
Emma Thompson
Contributor
4.5
54
4 months ago
Preview (2 of 4)
Sign in to access the full document!
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, itcan 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?
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, itcan 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?
Preview Mode
Sign in to access the full document!
100%
Study Now!
XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat
Document Details
Subject
Operations Management