Q. 1: Excel (attach your solution to this sheet A medium-size municipality plans to develop a software system to assist in project selection during the next 10 years. A life-cycle cost approach has been used to categorize costs into development programming, operating, and support costs for each alternative. There are three alternatives under consideration, identified as M, N, and O. The costs are summarized on in the table. Use an annual life-cycle cost approach to identify the best alternative at 8% per year. Alternative Component Development Programming Operation Support Development Estimated Cost (1000 S) 250 now 150 years (1-4) 45 now 35 years (1.2) 50 years (1-10) 30 years (1-5) 10 now 45 year 0 30 years (1-3) 80 years (1-10) 40 years (1-10) 175 years (1-10) Programming Operation Support Operation Grading Sale T elui Chess