Business Case - TCO- MS Office

TCO-ROIworksheet-forOfficein-house-2018.xlsx

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 & double to include the burden rate
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)
Sever maintenance			0.00		0.00		0.00		0.00	Full time Years 1&2, Half time year 3, 25% time in year 4	This color shows where you input your data
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	Half time in years 1, 2, 3, 4,
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	cost	#	0.00	#	0.00	#	0.00	#	0.00
Hardware/Software
Exchange Server	1,299.99		0.00		0.00		0.00		0.00	Server # increases by 1 in year 3
Office Pro Plus	399.99		0.00		0.00		0.00		0.00	= total # of users
Visio Pro	589.00		0.00		0.00		0.00		0.00	= total # of users
Project Pro	1,159.92		0.00		0.00		0.00		0.00	= total # of users
			0.00		0.00
Utilities Expenses			0.00		0.00		0.00		0.00	8760 potential uptime hours per year per Server
Totals			0.00		0.00		0.00		0.00
Training	$per user	# of new		# of new		# of new		# of new
	$138
Users Total		0		0		0		0		# of new users increases by 10% per year
New			0.00		0.00		0.00		0.00	Starts with 125 users in year 1
TCO			0.00		0.00		0.00		0.00
per user			ERROR:#DIV/0!		ERROR:#DIV/0!		ERROR:#DIV/0!		ERROR:#DIV/0!
Total TCO					0.00		0.00		0.00

	year 1	year 2	year 3	year 4
Cost	$0.00	$0.00	$0.00	$0.00
Benefits	$150,000.00	$400,000.00	$1,358,000.00	$4,515,000.00
Cumulative
Cost	$0.00	$0.00	$0.00	$0.00
Benefits	$150,000.00	$550,000.00	$1,908,000.00	$6,423,000.00
					If the IRR is 3 years is this a good project ?
					Extra Credit- Only good if done for both sheets
					Extra Credit (3points)- what is the ROI Ratio
					Extra Credit (5points)-Provide a line chart of the C Cost & C Benefits
	cost	C Cost	Benefits	C Benefits
1	$0.00	$0.00	$150,000.00	$150,000.00
2	$0.00	$0.00	$400,000.00	$550,000.00
3	$0.00	$0.00	$1,358,000.00	$1,908,000.00
4	$0.00	$0.00	$4,515,000.00	$6,423,000.00