Use only EXCEL SHEET for the solution PLZ

project selection during the next 10 years. Use an annual life-cycle cost approach to identify the best alternative at 8% per year.

Alternatives Component Development A Programming Operation Cost $250,000 now, $150,000 years 1-5 with additional amount of $50,000 at year 4 $45,000 now, $35,000 years 1-3 $60,000 years (1-5) and increase by 8% per year thereafter from 6-10 years. $40,000 years 1-3, 20,000 years 4-5 $150,000 now and decrease by 5% thereafter. $45,000 now, $35,000 years 1-3 $70,000 at year 1 and increase by $ 10,000 thereafter. $30,000 years 1-3, 30,000 years 4-5 Support Development (Years 1-4) B Programming Operation (Years 1-10) Support