5).Calculate the return on investment

Inhouse development option

Develop,install and configure the system = $18000

Load the system = $1500

Total investment = $18000 + $ 1500 = $19500

Life of the software = 6 years

tangbile benifits is $ 6500 per year and for 6 years , it works out to be $39000

Return on investment = Total tangible benifits / Total investments x 100

= $39000/$19500 x 100 = 200 %

Bikeexpert Software package option

Total investment = Cost to purchase + Install and configure + Load existing data + Additional hardware cost+ Annual Support fee for 5 years

=$7500 + $1000 + $1500 + $1500 + ( 0+4x1500) = $17500

(annual support fee for 5 years , first year being zero = $ 1500 x 4 = $6000)

Life of the software = 5 years

tangbile benifits is $ 6500 per year and for 5 years , it works out to be $32500

Return on investment = Total tangible benifits / Total investments x 100

= $32500/$17500 x 100 = 185%

NPV of both options @ 8 % discount factor

is tis correct?

Part II: Until now, the owner, Mike Thomas, kept the business records on his personal computer. He created a simple database to keep track of inventory, but it is not always up-to-date. He also developed spreadsheets to track expenses and payroll. The business has grown and Mike wants to install a new computer system to handle all business functions. ISYS 463 Individual Assignment #3 You are a student in the information systems department at the college. You were recently hired by Mare and he asked you to help him plan a system for University Bikes. You used an object-oriented approach to create a model of the business functions and actors involved. Now Mike wants you to do a "make or buy" analysis. Specifically, you will look into the pros and cons of in-house development versus purchase of a software package. Your research indicates that the most popular bike shop package is offered by a vendor called BikeExpert. In your last meeting, Mike said that tangible savings for a new system would be hard to measure, but improved customer care, better service department records, and increased productivity are expected. Mike estimates that these benefits will add up to about $6,500 per year, whether the system is developed in-house, or purchased from BikeExpert. You decide to compare relative costs to establish a total cost of ownership (TOC) over the useful life of the system. Based on your research, you put together the following summary: In-house development option The system will have a six-year useful life, be very flexible, and easiest to maintain. It will cost $18,000 to develop, install, and configure the system, and $1,500 to load existing data. Mike and the bookkeeper can handle day-to-day support with no added expense. BikeExpert software package option Tasks This is a vertical package with a five-year useful life. The software is less flexible than an in-house system and some customizing will be needed. It will cost $7,500 to purchase, $1,000 to install and configure, $1,500 to load existing data, and $1,500 additional hardware will be needed (Year 0 costs) Support is free for the first year (free for Year 1), then there is a $1,500 annual fee (from year 2) 4. Prepare a detailed list of pros and cons of in-house versus software purchase. 5. Calculate ROI for both options. 6. Calculate NPV for both options. Use an 8% discount factor. Factor (8%) Year O 1 Year 1 0.926 Year 2 0.857 Year 3 0.794 Year 4 0.735 Year 5 0.681 Year 6 0.630