I need help with a Computer Science question. All explanations and answers will be used to help me learn.

Mini Case: Campus Bikes

In Chapter 6 (Please see hw 5 description), you learned that Campus Bikes is a popular bicycle shop located near a major university. The shop sells several brands of new bikes, including everything from high-end racing models to beach cruisers. In addition to sales of new bikes and accessories, Mark’s service department is always busy. The staff includes Mark himself, a bookkeeper, two part-time sales reps, a full-time mechanic, and several part-time service helpers who assemble bikes.

Background

Until now, the owner, Mark Turner, kept the business records on his personal computer. He cre- ated 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 Mark wants to install a new computer system to handle all business functions.

You are a lab assistant in the computer information department at the college. You earned
a computer science degree at a two-year school, and you recently decided to work toward your four-year degree. Mark recently asked you to help him plan a system for Campus Bikes. You used an object-oriented approach to create a model of the business functions and actors involved.

Now Mark 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 BikeData.

In your last meeting, Mark 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. Mark estimates that these benefits will add up to about $3,000 per year, whether the system is developed in-house, or purchased from BikeData.

You decide to compare relative costs to establish a total cost of ownership (TOC) over the use- ful life of the system. Based on your research, you put together the following summary:

Costs for Option A: Develop In-house

Costs for Option B: Purchase BikeData Software Package

Benefits for Both Options: $3,000 per year

Tasks

  1. (30 pts) Prepare a detailed list of pros and cons of in-house versus software purchase.
  2. (20 pts) Calculate ROI for both options.
  3. (20 pts) Calculate NPV for both options. Use an 8% discount factor.
  4. (30 pts) Create one sheet word document for Mark showing the results of your analysis, including recommendations and reasons.

Rubric

CS4447_HW6

CS4447_HW6

Criteria Ratings Pts

This criterion is linked to a Learning OutcomeTask 1Prepare a detailed list of pros and cons of in-house versus software purchase.

30.0 pts

Full Marks

15.0 pts

Pros or Cons Missing

0.0 pts

No Marks

30.0 pts

This criterion is linked to a Learning OutcomeTask 2Calculate ROI for both options. To get full credit, you should show all of your computation.

20.0 pts

Full Marks

10.0 pts

Partial calculation provided

7.0 pts

Only Final Answer Provided

0.0 pts

Incorrect/Missing Answer

20.0 pts

This criterion is linked to a Learning OutcomeTask 3Calculate NPV for both options. Use an 8% discount factor. To get full credit, you should show all of your computation.

20.0 pts

Full Marks

10.0 pts

Partial calculation provided

7.0 pts

Only Final Answer Provided

0.0 pts

Incorrect/Missing Answer

20.0 pts

This criterion is linked to a Learning OutcomeTask 4Create one sheet word document for Mark showing the results of your analysis, including recommendations and reasons.

30.0 pts

Full Marks

15.0 pts

Analysis Incomplete

You should provide cost, ROI, NPV for both cases here and make a reasonable recommendation based on numbers.

0.0 pts

No Marks

30.0 pts

Total Points: 100.0