Harg, dan tomobile battery distributorship in Atlanta, Georgia, performed an economie analysis 3 years ago when he decided to place surge petectonis line for all his majors of testing equipment. The estimated and the annual Wrth analysis at MAXRemmarised below. Two different matters protectors were compared Powry Lyd 24,000,000 Constallations Mannar, Spy your Sale, 300 -360 3000 repeat wavings yan The spreadsheet in below sheet is the one Harry used to make the decisiva. Lloyd's was the clear choice due to its substantially larger AW value. The Lord's protectors were installed. MAR $35.000 125,000 125.000 PoweUp Lloyd's Investment Annual Repair Investment Annual Repair Years and salvage maintenance savings and salvage maintenance serving 0-526.000 50 SO -$36,000 50 50 -5800 $25,000 -$300 SO 5800 $25.000 NO $300 VO 135,000 -5800 10 1300 4 50 -5800 $25,000 VO 1300 so $35,000 -5800 $25,000 30 $300 $35.000 -5800 $25,000 DO -5300 $35.000 52.000 -5300 525.000 10 -1300 $35.000 0 -$300 $35.000 10 -100 $35,000 10 $3,000 -$300 $35,000 AW -56,058 bleme 5800 $25,000 $7,025 $300 $35,000 Total AW $18.131.35 527.674.68 During a grick review, it was noted that the maintenance costs and repair savings did not follow the estimates made 3 years ago. In fact, the maintenance cost a poing from $300 to $1200 per year from the firth year and will then increase per year theater. Also, the repair savings for the last 3 years were $32.847. $27.452, and $28,607, respectively. He believes savings will decrease by $2,901 per year herafter. Finally, the salvage is seo, not $3000 Case Study Exercises Qu-Plot a graph of the newly estimated maintenance costs and repair savings projection, suming the perfectors last for seven mape year. 02-With these new estimates, what is the recalled AW for the Lad's protections? Use the old first cost and maintenance cost estimates for the first man type your answer in the answer box 03-If these estimates had been made 3 years ago, would Lloyd's still have been the economie choice . 04- How as the capital recovery amoont changed for the Lloyd's protectors with these newestimates Harg, dan tomobile battery distributorship in Atlanta, Georgia, performed an economie analysis 3 years ago when he decided to place surge petectonis line for all his majors of testing equipment. The estimated and the annual Wrth analysis at MAXRemmarised below. Two different matters protectors were compared Powry Lyd 24,000,000 Constallations Mannar, Spy your Sale, 300 -360 3000 repeat wavings yan The spreadsheet in below sheet is the one Harry used to make the decisiva. Lloyd's was the clear choice due to its substantially larger AW value. The Lord's protectors were installed. MAR $35.000 125,000 125.000 PoweUp Lloyd's Investment Annual Repair Investment Annual Repair Years and salvage maintenance savings and salvage maintenance serving 0-526.000 50 SO -$36,000 50 50 -5800 $25,000 -$300 SO 5800 $25.000 NO $300 VO 135,000 -5800 10 1300 4 50 -5800 $25,000 VO 1300 so $35,000 -5800 $25,000 30 $300 $35.000 -5800 $25,000 DO -5300 $35.000 52.000 -5300 525.000 10 -1300 $35.000 0 -$300 $35.000 10 -100 $35,000 10 $3,000 -$300 $35,000 AW -56,058 bleme 5800 $25,000 $7,025 $300 $35,000 Total AW $18.131.35 527.674.68 During a grick review, it was noted that the maintenance costs and repair savings did not follow the estimates made 3 years ago. In fact, the maintenance cost a poing from $300 to $1200 per year from the firth year and will then increase per year theater. Also, the repair savings for the last 3 years were $32.847. $27.452, and $28,607, respectively. He believes savings will decrease by $2,901 per year herafter. Finally, the salvage is seo, not $3000 Case Study Exercises Qu-Plot a graph of the newly estimated maintenance costs and repair savings projection, suming the perfectors last for seven mape year. 02-With these new estimates, what is the recalled AW for the Lad's protections? Use the old first cost and maintenance cost estimates for the first man type your answer in the answer box 03-If these estimates had been made 3 years ago, would Lloyd's still have been the economie choice . 04- How as the capital recovery amoont changed for the Lloyd's protectors with these newestimates