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.

Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...
icon
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.
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: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.
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)
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
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
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,