only these and plz solve on q1 the graph

now is clear plz do

its all clear zoom

gn Layout References Mailings Review VIEW Abbcode An CCD4F1 ABB Del | tin Soading Hesding Here x X Normal PowrUp Lloyd's Cost and installation, s --26,000 -36,000 Annual maintenance cost, Sper year -800 -300 Salvage value, s 2,000 3,000 Equipment repair savings, 25,000 35,000 Useful life, years The spreadsheet in below sheet 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. 10 MARR 15% Investment and salvage -$26,000 Years 0 1 2 3 4 PoweUp Annual maintenance SO -5800 -5800 -$800 -5800 -$800 -5800 -5800 Repair savings 50 $25,000 $25,000 $25,000 $25,000 $25,000 $23.000 $25.000 50 5 6 Lloyd's Investment Annual Repair and salvage maintenance savings -$36.000 SO SO SO -$300 $35.000 SO -$300 $35,000 $0 -$300 $35,000 SO -$300 $35.000 50 -$300 $35,000 SO -$300 $35,000 SO -$300 $35,000 SO -$300 $35,000 SO -$300 $35,000 $3,000 -5300 $35.000 $7,025 -5300 $35,000 O Focus CROCE 7 $2,000 9 10 AW element -56,068 $800 $25,000 English W 28 e 80 ODU Dod DIA F FS F F2 TE 59 SVC $ % & 4 & nat Tools Table Window Help hw4 Q Searc Layout References Mailings Review View AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbceDdEx Heading 1 Heading 2 , A Normal No Spacing During a quick review this last year (year 3 of operation), it was obvious that themaintenance 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 13% per year for the next 10 years. Also, the repair savings for the last 3 years were $31,312, $27,565, and $30,493, as best as Harry can determine. He believes savings will decrease by $2,199 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 $3poo. Case Study Exercises Q1- Plot a graph of the newly estimated maintenance costs and repair savings projections, assuming the protectors last for seven more years. ANNUAL WORTH ANALYSIS-THEN AND NOW 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, S -26,000 -36,000 Annual maintenance cost, S per year 800 -300 Salvage value, $ 2,000 3,000 Equipment repair savings, $ 25,000 35.000 Useful life, years 10 The spreadsheet in below sheet 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 MARR 15% PoweUp Ush Lloyd's O Focus W 28 la MacBook 80 53 DOO Boo F4 da DW ES F8 53 FA 59 F % A * $ 4 E 50 6 1 & 7 7 V V8 A 9 9 Abdee teedte AaBbcAb Aa le XX Annual maintenance cost, $ per year -800 -300 Salvage value, 2000 3,000 Equipment repair savings. $ Useful life, years 25,000 35,000 6 10 The spreadsheet in below sheet 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. MARR 15% Years 0 1 2 3 lovet and salvage $26.000 50 SO 50 90 50 50 52.000 PoweUp Annual maintenance SO -5800 S800 -5800 -5300 -5500 -S500 -5600 Repair savi so $25.000 $25,000 $25,000 525.000 $25.000 $25,000 $25,000 Investment and salvage -$36.000 SO Se 50 30 30 50 50 4 I 5 Lloyd's Repair maintenance savings SO 50 -5300 335,000 $300 $35.000 -5300 $15.000 -5300 35,000 -5300 $35.000 5300 $35.000 -5300 $35,000 -5300 535.000 -$300 55.000 -$300 535,000 -5300 $35.000 $27.674.48 6 7. X 9 10 AW me Total AW SO $3,000 -S603 -5800 525.000 SIE 131.35 Thish 28 100 9 so 888 8 D : FE DD 59 : 710 $ & 3 % 50 4 E 6 1 7 V 8 A 99 1 0 E 9 R T Y U w M: 16 le. E OP C 0 G During a quick review this last year (year 3 of operation), it was obvious that themaintenance 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 13% per year for the next 10 years. Also, the repair savings for the last 3 years were $31,312, $27,565, and $30,493, as best as Harry can determine. He believes savings will decrease by $2,199 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 Q1- Plot a graph of the newly estimated maintenance costs and repair savings projections, assuming the protectors last for seven more vears. ANNUAL WORTH ANALYSIS-THEN AND NOW 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. Cost and installation, $ PowrUp Lloyd's -26,000 -36,000 --800 --300 2,000 3,000 Annual maintenance cost, $ per year Salvage value, $ Equipment repair savings, $ Useful life, years 25,000 35,000 10 6 The spreadsheet in below sheet 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. MARR 15% PoweUp Lloyd's lish Focus The spreadsheet in below sheet 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. MARR 15% Investment Years 0 Investment and salvage -$26,000 SO and salvage -$36,000 SO 1 2 PoweUp Annual maintenance SO -$800 -$800 -$800 -$800 -$800 -$800 -$800 Lloyd's Annual maintenance SO -$300 -$300 -$300 -$300 -$300 -$300 SO Repair savings $0 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 SO 3 SO SO SO SO SO 00 UA $0 $0 Repair savings SO $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $27,674.68 6 7 $2,000 SO SO SO SO $3,000 -$7,025 9 -$300 -$300 -$300 -$300 -$300 10 AW element -$6,068 -$800 $25,000 $18,131.35 Total AW During a quick review this last year (year 3 of operation), it was obvious that themaintenance 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 13% per year for the next 10 years. Also, the repair savings for the last 3 years were $31,312, $27,565, and $30,493, as best as Harry can determine. He believes savings will decrease by $2,199 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 Q1- Plot a graph of the newly estimated maintenance costs and repair savings projections, assuming the protectors last for seven more years. gn Layout References Mailings Review VIEW Abbcode An CCD4F1 ABB Del | tin Soading Hesding Here x X Normal PowrUp Lloyd's Cost and installation, s --26,000 -36,000 Annual maintenance cost, Sper year -800 -300 Salvage value, s 2,000 3,000 Equipment repair savings, 25,000 35,000 Useful life, years The spreadsheet in below sheet 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. 10 MARR 15% Investment and salvage -$26,000 Years 0 1 2 3 4 PoweUp Annual maintenance SO -5800 -5800 -$800 -5800 -$800 -5800 -5800 Repair savings 50 $25,000 $25,000 $25,000 $25,000 $25,000 $23.000 $25.000 50 5 6 Lloyd's Investment Annual Repair and salvage maintenance savings -$36.000 SO SO SO -$300 $35.000 SO -$300 $35,000 $0 -$300 $35,000 SO -$300 $35.000 50 -$300 $35,000 SO -$300 $35,000 SO -$300 $35,000 SO -$300 $35,000 SO -$300 $35,000 $3,000 -5300 $35.000 $7,025 -5300 $35,000 O Focus CROCE 7 $2,000 9 10 AW element -56,068 $800 $25,000 English W 28 e 80 ODU Dod DIA F FS F F2 TE 59 SVC $ % & 4 & nat Tools Table Window Help hw4 Q Searc Layout References Mailings Review View AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbceDdEx Heading 1 Heading 2 , A Normal No Spacing During a quick review this last year (year 3 of operation), it was obvious that themaintenance 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 13% per year for the next 10 years. Also, the repair savings for the last 3 years were $31,312, $27,565, and $30,493, as best as Harry can determine. He believes savings will decrease by $2,199 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 $3poo. Case Study Exercises Q1- Plot a graph of the newly estimated maintenance costs and repair savings projections, assuming the protectors last for seven more years. ANNUAL WORTH ANALYSIS-THEN AND NOW 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, S -26,000 -36,000 Annual maintenance cost, S per year 800 -300 Salvage value, $ 2,000 3,000 Equipment repair savings, $ 25,000 35.000 Useful life, years 10 The spreadsheet in below sheet 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 MARR 15% PoweUp Ush Lloyd's O Focus W 28 la MacBook 80 53 DOO Boo F4 da DW ES F8 53 FA 59 F % A * $ 4 E 50 6 1 & 7 7 V V8 A 9 9 Abdee teedte AaBbcAb Aa le XX Annual maintenance cost, $ per year -800 -300 Salvage value, 2000 3,000 Equipment repair savings. $ Useful life, years 25,000 35,000 6 10 The spreadsheet in below sheet 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. MARR 15% Years 0 1 2 3 lovet and salvage $26.000 50 SO 50 90 50 50 52.000 PoweUp Annual maintenance SO -5800 S800 -5800 -5300 -5500 -S500 -5600 Repair savi so $25.000 $25,000 $25,000 525.000 $25.000 $25,000 $25,000 Investment and salvage -$36.000 SO Se 50 30 30 50 50 4 I 5 Lloyd's Repair maintenance savings SO 50 -5300 335,000 $300 $35.000 -5300 $15.000 -5300 35,000 -5300 $35.000 5300 $35.000 -5300 $35,000 -5300 535.000 -$300 55.000 -$300 535,000 -5300 $35.000 $27.674.48 6 7. X 9 10 AW me Total AW SO $3,000 -S603 -5800 525.000 SIE 131.35 Thish 28 100 9 so 888 8 D : FE DD 59 : 710 $ & 3 % 50 4 E 6 1 7 V 8 A 99 1 0 E 9 R T Y U w M: 16 le. E OP C 0 G During a quick review this last year (year 3 of operation), it was obvious that themaintenance 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 13% per year for the next 10 years. Also, the repair savings for the last 3 years were $31,312, $27,565, and $30,493, as best as Harry can determine. He believes savings will decrease by $2,199 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 Q1- Plot a graph of the newly estimated maintenance costs and repair savings projections, assuming the protectors last for seven more vears. ANNUAL WORTH ANALYSIS-THEN AND NOW 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. Cost and installation, $ PowrUp Lloyd's -26,000 -36,000 --800 --300 2,000 3,000 Annual maintenance cost, $ per year Salvage value, $ Equipment repair savings, $ Useful life, years 25,000 35,000 10 6 The spreadsheet in below sheet 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. MARR 15% PoweUp Lloyd's lish Focus The spreadsheet in below sheet 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. MARR 15% Investment Years 0 Investment and salvage -$26,000 SO and salvage -$36,000 SO 1 2 PoweUp Annual maintenance SO -$800 -$800 -$800 -$800 -$800 -$800 -$800 Lloyd's Annual maintenance SO -$300 -$300 -$300 -$300 -$300 -$300 SO Repair savings $0 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 SO 3 SO SO SO SO SO 00 UA $0 $0 Repair savings SO $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $27,674.68 6 7 $2,000 SO SO SO SO $3,000 -$7,025 9 -$300 -$300 -$300 -$300 -$300 10 AW element -$6,068 -$800 $25,000 $18,131.35 Total AW During a quick review this last year (year 3 of operation), it was obvious that themaintenance 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 13% per year for the next 10 years. Also, the repair savings for the last 3 years were $31,312, $27,565, and $30,493, as best as Harry can determine. He believes savings will decrease by $2,199 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 Q1- Plot a graph of the newly estimated maintenance costs and repair savings projections, assuming the protectors last for seven more years