i need 9.25 on excel

resurfacing will be required every 10 years at a cost of 10% of the first cost of each route. Regardless of which route is se- lected, the volume of trallic is expected to be 400,000 vehicles per year. If the vehicle operating expense is assumed to be 50.35 per kilometer and the value of reduced travel time for the short route is estimated at $900,000 per year, determine which route should be selected, using a conven- tional B/C analysis. Assume an infinite life for each road, an interest rate of 65 per year, and that one of the roads will be built. of possibly building a new container port to augment the current port. The west coast site has deeper water so the dredging cost is lower than that for the east coast site. Also, the redredging of the west site will be re- quired only every 6 years while the cast site must be reworked each 4 years. Redredging. which is expected to increase in cost by 10% each time, will not take place in the last year of a port's commercial life. Disbenefit esti- mates vary from west (fishing revenue loss) to cast (fishing and resort revenue losses). Fees to shippers per 20-foot STD equivalent are expected to be higher at the west site due to greater difficulty in handling ships be- cause of the ocean currents present in the area and a higher cost of labor in this area of the country. All estimates are summarized below in si million, except annual revenue and life. Use spreadsheet analysis anda dis- count rate of 45 per year to determine if ei- ther port should be constructed. It is not nec- essary that the country build either part since one is already operating successfully. West Coast Site East Coast Site 9.24 A city engineer and economic develop- ment director of Buffalo are evaluating two sites for construction of a multipur- pose sports arena. At the downtown site. the city already owns enough land for the arena. However, the land for construction of a parking garage will cost Sl million. The west side site is 30 kilometers from downtown, but the land will be donated by a developer who knows that an arena al this site will increase the value of the re- mainder of his land holdings by many times. The downtown site will have extra construction costs of about SIO million because of infrastructure relocations, the parking garage, and drainage improve- ments. However, because of its centralized location, there will be greater attendance at most of the events held there. This will result in more revenue to vendors and local merchants in the amount of S350,000 per year. Additionally, the average al- tendee will not have to travel as far, result- ing in annual benefits of $400,000 per year. All other costs and revenues are ex- pected to be the same at either site. If the city uses a discount rate of 8% per year. where should the arena be constructed? One of the two sites must be selected Initial costs Year 0 Year! Dredging cost. S. year Annual M&O. S/year Recurring dredging CONS Annual disbenefits s/year Annual fees: number of 20-foot STD at Scontainer Commercial life. years 2 each 6 years with increase of 109 each time 1.2 each 4 years with increase of | W t ch as 5 million/year at $2.50 each 8 million/year cach 2012 9.25 A country with rapid economic expansion has contracted for an economic evaluation resurfacing will be required every 10 years at a cost of 10% of the first cost of each route. Regardless of which route is se- lected, the volume of trallic is expected to be 400,000 vehicles per year. If the vehicle operating expense is assumed to be 50.35 per kilometer and the value of reduced travel time for the short route is estimated at $900,000 per year, determine which route should be selected, using a conven- tional B/C analysis. Assume an infinite life for each road, an interest rate of 65 per year, and that one of the roads will be built. of possibly building a new container port to augment the current port. The west coast site has deeper water so the dredging cost is lower than that for the east coast site. Also, the redredging of the west site will be re- quired only every 6 years while the cast site must be reworked each 4 years. Redredging. which is expected to increase in cost by 10% each time, will not take place in the last year of a port's commercial life. Disbenefit esti- mates vary from west (fishing revenue loss) to cast (fishing and resort revenue losses). Fees to shippers per 20-foot STD equivalent are expected to be higher at the west site due to greater difficulty in handling ships be- cause of the ocean currents present in the area and a higher cost of labor in this area of the country. All estimates are summarized below in si million, except annual revenue and life. Use spreadsheet analysis anda dis- count rate of 45 per year to determine if ei- ther port should be constructed. It is not nec- essary that the country build either part since one is already operating successfully. West Coast Site East Coast Site 9.24 A city engineer and economic develop- ment director of Buffalo are evaluating two sites for construction of a multipur- pose sports arena. At the downtown site. the city already owns enough land for the arena. However, the land for construction of a parking garage will cost Sl million. The west side site is 30 kilometers from downtown, but the land will be donated by a developer who knows that an arena al this site will increase the value of the re- mainder of his land holdings by many times. The downtown site will have extra construction costs of about SIO million because of infrastructure relocations, the parking garage, and drainage improve- ments. However, because of its centralized location, there will be greater attendance at most of the events held there. This will result in more revenue to vendors and local merchants in the amount of S350,000 per year. Additionally, the average al- tendee will not have to travel as far, result- ing in annual benefits of $400,000 per year. All other costs and revenues are ex- pected to be the same at either site. If the city uses a discount rate of 8% per year. where should the arena be constructed? One of the two sites must be selected Initial costs Year 0 Year! Dredging cost. S. year Annual M&O. S/year Recurring dredging CONS Annual disbenefits s/year Annual fees: number of 20-foot STD at Scontainer Commercial life. years 2 each 6 years with increase of 109 each time 1.2 each 4 years with increase of | W t ch as 5 million/year at $2.50 each 8 million/year cach 2012 9.25 A country with rapid economic expansion has contracted for an economic evaluation