Calculate roi for both options

Assignment Help Management Information Sys
Reference no: EM13867591

Case- Campus Bikes

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 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 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 mea-sure, 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-

• The system will have a six-year useful life, be very flexible, and easiest to maintain.
• It will cost $15,000 to develop, install, and configure the system, and $1,000 to load existing data.
• Mark and the bookkeeper can handle day-to-day support with no added expense.

Costs for Option B: Purchase BikeData Software Package-

• This is a vertical package with a four-year useful life.
• The software is less flexible than an in-house system and some customizing will be needed.
• It will cost $8,000 to purchase, $1,500 to install and configure, $2,500 to load existing data, and $1,000 additional hardware will be needed
• Support is free for the first year, and then there is a $2,000 annual fee

Benefits for Both Options: $3,000 per year

Tasks

1. Prepare a detailed list of pros and cons of in-house versus software purchase.

2. Calculate ROI for both options.

3. Calculate NPV for both options. Use an 8% discount factor.

4. Create a PowerPoint presentation for Mark showing the results of your analysis, including recommendations and reasons.

Reference no: EM13867591

Questions Cloud

Eassy about beef and sugar : One and half page eassy about BEEF and SUGAR. How much should a person use them in the daily life. Also mention the side effects if the person eat alot of Beef or Suger and what disease may he get , what should he do if he get sick
List the potential gender and cultural issues in this case : List the potential gender and cultural issues in this case. How might an effective cultural counselor address each of them? Identify a multicultural competency that best supports your strategy to address the issue
What evidence of counselor bias exists in the case study : What evidence of counselor bias exists in the case study? What AMCD competencies might be useful to consider when deciding if the counselor can still be effective in dealing with the clients
How do the cultural identities of the counselor : Case- Paula, the counselor, is a 37-year-old woman. She has lived away from home since she began college. During college, she lived with roommates in an apartment.After graduation, she bought a condo. How do the cultural identities of the counsel..
Calculate roi for both options : Prepare a detailed list of pros and cons of in-house versus software purchase. Calculate ROI for both options. Calculate NPV for both options. Use an 8% discount factor
Write the summary of case- state vs nagami : Write the summary of the given case- Case- State v. Nagami. Japan, Nagasaki District Court, 1968
What amount should the city credit the encumbrances : The city receives the sedans along with an invoice for $ 104,000. With what amount should the city credit the Encumbrances account?
Determine the projected year end fund balance for this fund : General Fund revenues and expenditures for the current year are expected to be as shown here. Determine the projected year end fund balance for this fund.
The assessed valuation of all of the property : The county legislature approved the budget for 2013. Revenues from property taxes are budgeted at $ 800,000. According to the county assessor the assessed valuation of all of the property in the county is $ 50 million.

Reviews

Write a Review

Management Information Sys Questions & Answers

  Pursuit of operational excellence

ES' attempt to create a level of ‘intimacy' between the company and its main suppliers and customers. Explain what we mean when we use the term ‘intimacy' in sense. How does this intimacy contribute to the pursuit of operational excellence?

  Advantages and disadvantages of the patient entering

What would be the advantages and disadvantages of the patient entering vs. a health care professional in just the history portion of the EHR

  Importance of accuracy of data input

Importance of Accuracy of Data Input

  What would the pros and cons be of dedicated private fleet

What would the pros and cons be of using each technique listed below, Distribution center, Public warehouse, Third-party logistics

  Q1 define each of the following - pharmacokinetics -

q1 define each of the following - pharmacokinetics - pharmacodynamics - pharmacotherapeutics - toxicology q2common

  Show the variability in barilla''s supply chain

What are the reasons for the increase in variability in Barilla's supply chain and How can Barilla cope with the increase in variability?

  Paper on development of corporate strategy

Write a five to seven (5-7) page paper on development of Corporate Strategy for Information Security

  Question about wan technologycookies are us runs a series

question about wan technologycookies are us runs a series of 100 cookie store across the midwetern united states and

  How a consumer could benefit from asymmetric

how a consumer could benefit from asymmetric informationcreate an original example to illustrate how a consumer could

  Case for developing strategic information systems

Case for developing Strategic Information Systems - critical in the progression of businesses

  Introducing new technology in an organizationsome

introducing new technology in an organizationsome individuals in an organization may be extremely reluctant to embrace

  Calculate the weekly staffing required at 40 hours per week

Create the Excel spreadsheet shown in Figure 1-18 to calculate the weekly staffing required, at 40 hours per week, for production levels of 200, 300, 400, and 500 units

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd