Use Excel

Each of the 4 alternatives has a shelf life of 40 years. If the MARR is 6%, which alternative should be selected. Solve the problem by analyzing the benefit-cost ratio. B D Initial cost ($) 9.5k 9.0k 8.4k 7.7k Annual operating cost($) 120 155 200 300 Annual benefit $800 (same for all alternatives) Fill the whites: a)B/C ALT A ratio . B/C ALT B ratio . B/C ALT C ratio B/C ALT D ratio . Selected alternative (lyrics)