Harbor delivery service: case study Based on the two pictures below. And based in the solution in the schedule: Write a conclusion: explain what is your decision and why you choose your preferred option and other necessary explanations.
Harbor delivery service: case study Based on the two pictures below. And based in the solution in the schedule: Write a conclusion: explain what is your decision and why you choose your preferred option and other necessary explanations.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Harbor delivery service: case study
Based on the two pictures below.
And based in the solution in the schedule:
Write a conclusion: explain what is your decision and why you choose your preferred option and other necessary explanations.

Transcribed Image Text:Summary
We have been tasked to determine the best power source for the harbors
delivery services boat fleet. They have posed the question which engine would be more
cost effective for the fleet Diesel or Gasoline. Both engines have their good and bad
qualities to be reviewed against one another but freight management can not decide
which single power source would be best for their whole fleet to convert to. In order to
determine which route would be best is to generate an economic analysis of the two
alternatives. There are 10 managers that have evaluated the two power sources as
options and 5 of the 10 believe gasoline to be the better option due to the higher speed
and lower maintenance cost. But diesel is also viewed as a superior option due to its
efficiency and lower overall cost of operation.
The Specifications of the gasoline engine list it as costing $76,586 to purchase
with a 350 hp engine, a 300 gallon fuel capacity, moving 21.1 knots using 26 gallons per
hour. The diesel specifications list it as costing $97,995 to purchase with a 300 hp
engine, a 300 gallon fuel capacity, moving 17.4 knots using 17 gallons per hour.

Transcribed Image Text:HDS Equivalent Uniform Annual Worth
Initial Cost
Annual O&M
Annual Benefit
Salvage Value
Useful life
MARR
Initial Cost
Annual O&M
Annual Benefit
Salvage Value
Useful life
Gasoline
$76,586.00
$295,990.84
$18,250.00
$38,000.00
3
18%
Company A
HDS given (2)IF16
HDS given (2)!F40
-50*365
HDS given (2) IF26
3
Diesel
$97,995.00
$367,889.90
0
$48,000.00
4
18%
Company B
HDS given (2) IG16
HDS given (211040
0
HDS given (211G26
4
5-button solution
Gasoline
Diesel
5-button solution
Gasoline
Diesel
Table solution
Gasoline
Diesel
i
18%
18%
i
18%
18%
(76586+295990.84)*(A/P 18 %,3)-(18250-38000) (A/F,18%,3)
(76586+295990.84)*(0.4599)-(18250+38000)*(0.2799)
$155,603.71
(97995+367889.90) (A/P,18% 41-48000 (A/F,18 %,4)
197995+367889.90)*(0.3717)-48000* 1917)
$163,967.82
n
3
4
3
4
PMT
PMT
PV
FV Solve for
($372,576.84) $56,250.00 PMT
($465,884.90) $48,000.00 PMT
PV
(C5+06)
(D5+06)
FV
-C7+C8
-08
Answer
$155,611.26
$163,983.98
Formula
-PMT 825,C25,E25,F25)
PMT|B26,C26,E26,F26)
Formula
Solve for
PMT
Answer
=PMTIH5,15,K5,L5) -PMT[825,C25,125,F25)
PMT -PMTIH6,16,K6L6) -PMT1826,C26,E26,F26)
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.