Business case Requirements and ROI 1 and 2

profileNote to Self
1TCO-ROIworksheet-forOfficeonline.xlsx
Home>Information Systems homework help>Business case Requirements and ROI 1 and 2

TCO

Labor Rate ($) Year 1 hrs Year 1$ Year 2hrs Year 2 $ Year 3hrs Year 3$ Year 4hrs Year 4 $ Notes:
Project Manager 0.00 0.00 0.00 0.00 Full time Years 1&2, Half time year 3, 0 in year 4 www.salary.com for pay rate & include the burden rate of 50%
Desktop Support 0.00 0.00 0.00 0.00 There are 2 Personnel- Half time years 1, 2, 3, full time in year 4 2080 working hours per year (40hr x 52 weeks)
SharePoint Developer 0.00 0.00 0.00 0.00 Full time in year 1
Software Trainer 0.00 0.00 0.00 0.00 Full time in year 1. Half time in years 2, 3, 4, This color shows where you input your data
Customer Support 0.00 0.00 0.00 0.00 There are 2- Personnel 18 hours/month and increases 4 hours per month each year
Totals 0.00 0.00 0.00 0.00
Hardware/Software Cost # of users # of users # of users # of users
Exchange online server license 47.63 0.00 0.00 0.00 0.00 Online server license for IT staff of 20 personnel/year
MS Enterprise Office online license 238.00 0.00 0.00 0.00 0.00 = total # of users (you do not add anything here it will self-calcuate )
Project Online license 691.00 0.00 0.00 0.00 0.00 = total # of users (you do not add anything here it will self-calcuate )
Visio Online license 154.96 0.00 0.00 0.00 0.00 = total # of users (you do not add anything here it will self-calcuate )
0.00 0.00 0.00 0.00 There are NO on premise servers as this cloud based so no utility costs are calculated
Totals 0.00 0.00 0.00 0.00
Training $per user # of new # of new # of new # of new
138.00
Users Total 0 0 0 0 There are 125 new users in the first year
New 0.00 0.00 0.00 0.00 Year 2 there is an increase of 10% of new users over the previous year
Year 3 there is a decrease of 30% of new users over the previous year
TCO 0.00 0.00 0.00 0.00 Year 4 there is a decrease of 50% of new users over the previous year.
per user ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total TCO 0.00 0.00 0.00

ROI

year 1 year 2 year 3 year 4
Cost $0.00 $0.00 $0.00 $0.00
Benefits $50,000.00 $400,000.00 $1,879,000.00 $4,369,000.00
Cumulative
Cost $0.00 $0.00 $0.00 $0.00
Benefits $50,000.00 $450,000.00 $2,329,000.00 $6,698,000.00
If the IRR is 3 years is this a good project ?
Extra Credit- Only good if done for both sheets
Extra Credit (2points)- what is the ROI Ratio
Extra Credit (3points)-Provide a line chart of the C Cost & C Benefits
cost C Cost Benefits C Benefits
1 $0.00 $0.00 $50,000.00 $50,000.00
2 $0.00 $0.00 $400,000.00 $450,000.00
3 $0.00 $0.00 $1,879,000.00 $2,329,000.00
4 $0.00 $0.00 $4,369,000.00 $6,698,000.00

Sheet1