Answered step by step
Verified Expert Solution
Question
1 Approved Answer
May you please solve by excel and show me the calculation or formula you use for each cell ? A bridge is to be constructed
May you please solve by excel and show me the calculation or formula you use for each cell ?
A bridge is to be constructed now as part of a new road. An analysis has shown that traffic density on the new road will justify a two-lane bridge at the present time. Because of uncertainty regarding future use of the road, the time at which an extra two lanes will be required is currently being studied. The estimated probabilities of having to widen the bridge to four lanes at various times in the future are as follows: Widen Bridge In Probability 3 years 4 years 5 years 6 years 0.2 0.3 0.4 The present estimated cost of the two-lane bridge is $2,000,000. If constructed now, the four-lane bridge will cost $3,500,000. The future cost of widening a two-lane bridge will be an extra $2,000,000 plus $250,000 for every year that widening is delayed. If money can earn 12% per year, what would you recommend? A bridge is to be constructed now as part of a new road. An analysis has shown that traffic density on the new road will justify a two-lane bridge at the present time. Because of uncertainty regarding future use of the road, the time at which an extra two lanes will be required is currently being studied. The estimated probabilities of having to widen the bridge to four lanes at various times in the future are as follows: Widen Bridge In Probability 3 years 4 years 5 years 6 years 0.2 0.3 0.4 The present estimated cost of the two-lane bridge is $2,000,000. If constructed now, the four-lane bridge will cost $3,500,000. The future cost of widening a two-lane bridge will be an extra $2,000,000 plus $250,000 for every year that widening is delayed. If money can earn 12% per year, what would you recommendStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started