Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need this on excell 1) A medium-size municipality plans to develop a software system to assist in project selection during the next 10 years.

i need this on excell image text in transcribed
1) 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 A (tailored system), B (adapted system), and C (current system). The costs are summarized below. Perform a life-cycle cost analysis to identify the best alternative at 8% per year using (a) tabulated factors first, then (b) a spreadsheet to verify your selection. Turn the spreadsheet portion in via Canvas. Alternative Cost Component Cost Estimates A Development $250,000 now, $150,000 years 1-4 Programming $45,000 now, $35,000 years 1,2 Operation $50,000 years 1 through 10 Support $30,000 years 1 through 5 B Development $10,000 now Programming $45,000 year 0, $30,000 years 1-3 Operation $80,000 years 1 through 10 Support $40,000 years 1 through 10 Operation $175,000 years 1 through 10 21 Field chlorinatinn of rorlaimed wotor non ho arromnlicher vio a lounnot

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

describe the main employment rights as stated in the law

Answered: 1 week ago