Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer the 3 questions using the case study Background and Information Harry, owner of an automobile battery distributorship in Atlanta, Georgia, performed an economic

Please answer the 3 questions using the case study

image text in transcribed

Background and Information Harry, owner of an automobile battery distributorship in Atlanta, Georgia, performed an economic analysis 3 years ago when he decided to place surge protectors in-line for all his major pieces of testing equipment. The estimates used and the annual worth analysis at MARR = 15% are summarized below. Two different manufacturers' protectors were compared. PowrUp Lloyd's Cost and installation, $ -26,000 -36,000 Annual maintenance cost, -800 -300 $ per year Salvage value, $ 2,000 3,000 25,000 35,000 Equipment repair savings, $ Useful life, years 6 10 The spreadsheet in Figure 6-9 is the one Harry used to make the decision. Lloyd's was the clear choice due to its substantially larger AW value. The Lloyd's protectors were installed. During a quick review this last year (year 3 of operation), it was obvious that the maintenance costs and repair savings have not followed (and will not follow) the estimates made 3 years ago. In fact, the maintenance contract cost (which includes quarterly inspection) is going from $300 to $1200 per year next year and will then increase 10% per year for the next 10 years. Also, the repair savings for the last 3 years were $35,000, $32,000, and $28,000, as best as Harry can determine. He believes savings will decrease by $2000 per year hereafter. Finally, these 3-year-old protectors are worth nothing on the market now, so the salvage in 7 years is zero, not $3000. Case Study Exercises 1. Plot a graph of the newly estimated maintenance costs and repair savings projections, assuming the protectors last for 7 more years. 2. With these new estimates, what is the recalculated AW for the Lloyd's protectors? Use the old first cost and maintenance cost estimates for the first 3 years. If these estimates had been made 3 years ago, would Lloyd's still have been the economic choice? 3. How has the capital recovery amount changed for the Lloyd's protectors with these new estimates? D G 1 MARR 15% 2 Lloyd's PowrUp Annual 4 Investment Repair savings 5 Your and salvage maintenance Repair Investment Annual savings and salvage maintenance 0 25,000 6 0 -26,000 -36,000 0 0 0 -800 7 1 -300 35,000 8 2 -800 -300 35,000 25,000 25,000 9 3 0 -800 -300 35,000 10 4 0 -800 25,000 -300 35,000 11 5 0 -800 25,000 -300 35,000 12 6 2,000 -800 25,000 -300 35,000 13 7 -300 35,000 14 8 -300 35,000 15 9 -300 35,000 16 10 -300 35,000 17 AW element -6,642 -800 25,000 -300 35,000 18 Total AW $ 17,558 $ 27,675 Figure 6-9 Annual worth analysis of surge protector alternatives, case study. ooc 0 0 oo 0 0 0 0 0 0 0 0 0 3,000 -7,025

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Financial Modelling Model Design And Best Practices Using Excel And VBA

Authors: Michael Rees

1st Edition

111890401X, 978-1118904015

More Books

Students also viewed these Finance questions