Attached are Weeks 1, 2, & 3 assignments for reference.
The ROI Calculator spreadsheet is to be included with the individual technology solution description. This allows each member of the team to specify costs and savings and be able to see how the Return on Investment (ROI) and payback period are calculated.
Prior to the week in which the individual technology solution assignment is due, there is an ungraded Exercise for you to practice with the ROI calculator using simple data and step-by-step directions.
HOW THE CALCULATOR WORKS
First, it would be helpful to understand how the ROI Calculator works. Open the ROI Calculator spreadsheet and click on the “Instructions” tab. Read the instructions and then click on the “ROI Calculator Example” tab. At the top you will see 4 charts; scroll down to the data and come back to the charts later. In the data area, you will note that savings and costs are identified for the first 5 years of the project, and you will see the following:
Total Project Expenditures are shown in blue.
HOW TO USE THE CALCULATOR
After reviewing the ”Instructions” tab and the “ROI Calculator Example” tab, and the information above, open the tab “Costs and Sources.” Here you will enter the list of all components that need to be acquired (either by purchase, lease, subscription, etc.), the quantity of each required and a unit cost and a total cost associated with each item. These general cost estimates may be obtained from any source, but the sources should be cited – for this you should complete the “Source of Cost” column in the spreadsheet inserting the URL where you found the cost. The categories listed are to help you be sure to include everything; you may add rows as needed in the spreadsheet. Note that one-time implementation costs are separated from ongoing repeated costs. Enter your items in the appropriate area. For example, software costs that are a one-time startup fee would go in the Implementation Costs, while monthly or annual subscription costs for software would go in the Ongoing Costs. Every item in your description of resources and your graphical representation needs to be included on the cost spreadsheet.
Next, using the “ROI Calculations” tab on the spreadsheet, transfer the one-time costs to that tab, in item 2.2 under year 1. Copy the recurring annual costs for those items and enter the annual cost in item 2.3; enter the annual cost in the columns for years 1-5. Then, go to item 2.1 and enter estimates for the costs of selecting and documenting the proposed solution; use reasonable cost estimates for each category; note these are entered in the “year 0” column, since they are incurred prior to the acquisition of the system.
Finally, go to section 1 on the spreadsheet tab and enter several areas where the organization in the Case Study will realize savings by implementing the system. You should refer to Section IV of your group’s business case for areas where savings may be realized. You can add other areas where savings could be expected to come up with a list of four or five areas. The total savings over the five year period must exceed the total cost of the system, or it will not be approved by the decision-makers. So, think carefully about all the ways your system will save money for the organization and be sure your total savings if more than the total costs.
If you use the spreadsheet as it is and use “Insert Row” to add rows where you need them and “Delete Row” where needed, the spreadsheet will calculate the total savings and the total costs by year for the first 5 years. The totals are displayed in blue in bold font.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admission Essays & Business Writing Help
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.