I AM PROVIDING THE SOLUTION OF THIS PROBLEM. I WOULD LIKE TO UNDERSTAND HOW THE VALUES IN CELLS C35, G35, K35 WERE FOUND AND HOW TO ANSWER TO QUESTION b, ON THE B-C ANALYSIS

An improvement to the roadway is desired from Philmont Scout Ranch to Springer in northeastern New Mexico. Alternative N (for north) costs $2,400,000 initially and $155,000/year thereafter. Route SA (for south, Alternative A) will cost $4,200,000 initially, and $88,000/year thereafter. Route SB is the same as SA with wider lanes and shoulders. It costs $5,200,000 initially with maintenance at $125,000/year. User costs considering time, operation, and safety are $625,000 for N, $410,000 for SA, and $310,000 for SB. The salvage values for N, SA, and SB after 20 years are 20% of initial cost, respectively. Using a MARR of 7 percent and a 20-year study period Calculate present worth using Use a B - C analysis.

Solution puter 01, Problem 011 (Vid Randh to Suri It costs $5.200,0 at Using MARR of 7 percent dy period calcula ution to the probe particula PERIOD $171 SALVACE 20.005. ANNUAL COST USER COST 000 0.00 (DIS5ENE ,400 2.00 20 000 $526 000 33 18 19 2.00 after, Houte SA (for south, Alternative A) will cust RUUNUU initially, Alter oosts $2,400,0 0,000 for SA, and $210,00U for SE. The salvage values for N, SA. a time, operation, and safety are $023,000 for N, $41 SE after 20 year ysis. not match th you ha been given to solve. $5.20 00.00 00.00 5.201.29 56.755.496.02 $3.281.140 55.25 408.02 $4,343.546.34 -116 NPNISC33H $3.284,144. of pectivel