Create a cost-benefit analysis

Assignment Help Business Management
Reference no: EM13936526

This is for MGMT 321 Systems Analysis and Design by Dennis Wixom and Roth 5th Edition

Create a cost-benefit analysis that illustrates the return on investment that you would receive from purchasing a computer. For assistance, you may visit computer-related Web sites (www.dell.com, www.hp.com) to view tangible costs that you can include in your analysis. Project the computer cost at $1,070.00. Include a three-year period of time and provide the net present value of the final total.

The following tips demonstrate how to create a Cost-Benefit Analysis for the Module 1 EOMQ Assignment1.3, Part 2:

Create a spreadsheet (MS Excel, Apache OpenOffice Calc). Refer to Figure 1-8 and Figure 1-9 in the textbook for examples of spreadsheet formatting. Note that Row "1" has "Years" beginning with "Year 0" and ending with "Year 3" moving across to the right followed by a"Total."

In Column 1 going down, you would first list the "Costs:" category that will be broken down into subparts below (unlike Figure 1-8 which has "Benefits" first). The "Costs" subparts would include such items as "Initial Purchase Costs" and "Ongoing Costs of Ownership," which in turn is broken down into subparts such as "Internet Access," "AntiVirus Subscription," "Computer Supplies," etc.

Next going down in Column 1, place "PV of Costs (Assuming a ___ % rate of return)." Decide on what Rate of Return" for your formulas you want and place in the blank space. Use the "Discounted Cash Flow Technique" to build your spreadsheet formulas as described on page 27 of the textbook. If you need help creating a formula for the spreadsheet cells, check out any of the following:

Next going down in Column 1, place "PV of All Costs."

Next going down Column 1 place the "Benefits:" category, which will be broken down into subparts similar to the "Costs:" category. The "Benefits" subparts would include such items as "Vehicle costs saved for having no travel to campus computer lab.

Next going down in Column 1, place "PV of Benefits (Assuming a ___ % rate of return)." Decide on what Rate of Return" for your formulas you want and place in the blank space. Use the "Discounted Cash Flow Technique" to build your spreadsheet formulas as described on page 27 of the textbook.

Next going down in Column 1, place "PV of All Benefits."

Finally, going down in Column 1, place "Yearly NPV of All Benefits."

Reference no: EM13936526

Questions Cloud

Describe sifibanks profit-maximizing function : Describe SifiBank's profit-maximizing function. Describe a conceptual model that relates risk-taking to asset generation and firm growth.
Research benefits of hris : Research Benefits of HRIS, Write a 2-3 pages (not including cover and reference pages), highlighting at least five considerations that must be addressed when choosing a Payroll HRIS. Include explanations why the considerations are important. Use a..
Explain stages of social development children experience : Compare the social and emotional development of the children in each of the age groups selected in Week Six. Preschool ages (3,4&5), middle school ages (9,10&11).
Leadership affected strategic change in the firm : What strategies have Compass employed in competing with other food service firms in the UK and how successful have these strategies been?
Create a cost-benefit analysis : Create a cost-benefit analysis that illustrates the return on investment that you would receive from purchasing a computer. For assistance, you may visit computer-related Web sites (www.dell.com, www.hp.com) to view tangible costs that you can includ..
What factors led to the near death of sifibank : What factors led to the near death of SifiBank after the financial crisis of 2008-2009? What is the Volcker Rule and what impact does it have on banking and financial risk management?
Implement the program by using vb.net : Draw all the diagrams which need it in the assignment by using smart draw program - the diagrams should match with the system
Debate in the topic of marketing and brand management : Select a current debate in marketing and brand management. • Search the Internet and University of Roehampton Library and identify a relevant article about the current debate you selected.
What is systemic risk and how does it affect bank risk : What is systemic risk and how does it affect bank risk? What is risk layering? What is CAMELS? What are some of the key provisions of DFA?

Reviews

Write a Review

Business Management Questions & Answers

  Egalitarian companies are more innovative

The BCG matrix is a portfolio strategy that categorizes a corporation business by growth rate and relative market share, and helps managers decide how to invest corporate funds.

  Fundamental of e-business and e-commerce

Specify the key ethical issues related to e-Business and e-Commerce. Next, propose at least two (2) ethical and legal considerations that the management must consider in order to establish organizational policy regarding e-Business and e-Commerce ..

  External environmentlooking at the external environment in

external environmentlooking at the external environment in asia identify the critical strategic factors in each of the

  Explain reassures employees and the community

Explain A crazed gunman drives his pickup truck into the side of a popular restaurant during the lunch hour rush. The man gets out of his truck and begins to fire on restaurant patrons

  What percentage of members of your organization understand

What percentage of the members of your current organization understand its strategy? What concept/idea in the assigned readings do you find most intriguing or useful? Why? How might you or others apply it?

  Define various definitional perspectives of quality

Define Various definitional perspectives of quality

  Cures segmentation strategy

Susan G. Komen for the Cure's segmentation strategy that pulled in 10.46% more donations per person

  Watson department store uses the retail inventory

Watson Department Store uses the retail inventory method to estimate its inventories. It intended its cost to retail ratio during the period

  Process time for the blood test step

Q1. Calculate the process time for the Blood Test Step. Q2. Calculate the FTE and cycle time. Q3. Calculate Value Added and Non Value Added Time

  Trust building in teams

Prepare a clear vision-A leader's responsibility is to ensure a team is on the same wavelength. Confusion is often eliminated if everyone within the team has a clear objective of what is expected.

  Define compensation and total compensation

Define compensation and total compensation - Explain what is total compensation and how might one apply both the expectancy and the equity theory in the endeavor of developing a compensation system?

  Non-market environment

What makes crises different from other events in the nonmarket environment

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