CAN YOU EXPLAIN HOW TO USE GOAL SEEK FOR THIS PROBLEM? THANKS IN ADVANCE!

CAN YOU EXPLAIN HOW TO USE GOAL SEEK FOR THIS PROBLEM? THANKS IN ADVANCE!

Using a spreadsheet, consider the four independent projects outlined below. At 5% per year and a 15-year study period, (a) determine which projects are acceptable, and (b) the value of the annual M\&O cost to make any nonacceptable project acceptable with a B/C ratio of at least 1.0. (Note: Utilize a logical IF function somewhere in your analysis.) Solution: (a) Screen image \#1: projects M and N are acceptable; O and P are not. (b) Use Goal Seek to determine maximum M\&O costs. Screen images \#2 and \#3: O is acceptable if M\&O is below $32,465 per year P is acceptable if M&O is below $32,124 per year Using a spreadsheet, consider the four independent projects outlined below. At 5% per year and a 15-year study period, (a) determine which projects are acceptable, and (b) the value of the annual M\&O cost to make any nonacceptable project acceptable with a B/C ratio of at least 1.0. (Note: Utilize a logical IF function somewhere in your analysis.) Solution: (a) Screen image \#1: projects M and N are acceptable; O and P are not. (b) Use Goal Seek to determine maximum M\&O costs. Screen images \#2 and \#3: O is acceptable if M\&O is below $32,465 per year P is acceptable if M&O is below $32,124 per year