Assignment
This is your second business case of this course. Use the feedback received from your prototype and first business case assignments. Again, part of this course is critical thinking, which means you will have to look at the whole picture regarding this project. This assignment will be graded harder than the last business case! This is a FIFTY point assignment if you provide just the basic information (i.e. one or two sentences for each section that are vague) you will are looking at earning about half the points for this assignment. (Note: this assignment is due at the end of Module 4, you should be working on it well in advance of the due date - as always I am available for questions)
You received an email (Microsoft Office Upgrade Business Case Exercise- attached below) from a Senior Manager about the company's old Microsoft Office 97 software
Develop a Business Case (Using the 447- Business Case MS Office Upgrade document) and use the two spreadsheets attached to determine the TCO and ROI for in-house and on-line solutions for an Office Upgrade
Import the TCO solution for the chosen solution into the Business Case document. Submit both spreadsheets and the business case document.
The benefits for this Business Case are provided for you below:
Your Benefits for each year for both spreadsheets are:
Year 1 - $0
Year 2 - $600,000
Year 3 - 1,274,000
Year 4 - 3,127,000
Provide the ROI ratio for both spreadsheets
Use and submit the two spreadsheets attached to determine the TCO and ROI for in-house and on-line (NOTE there are two tabs on each spreadsheet)
Provide a line chart showing C-Cost & C-Benefits for both spreadsheets- 5pts
Use Salary.com to find Salary ranges for your personnel, calculate the hourly rate and add 50% to the rate for the burdened costs. Burdened costs are the overhead for each employee; vacation time, insurance, benefits, the cost of providing them a workspace, and equipment (desk, chair, computer, etc).
Your Benefits for each year are:
Year 1 - $0
Year 2 - $600,000
Year 3 - 1,274,000
Year 4 - 3,127,000
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.
Attachment:- Worksheet-for-Office.rar