Payback scehdule eduGAIN support Production v2.xls


	Year 1				Year 2				Year 3				Year 4				Total costs
	Y1 Q1	Y1 Q2	Y1 Q3	Y1 Q4	Y2 Q1	Y2 Q2	Y2 Q3	Y2 Q4	Y3 Q1	Y3 Q2	Y3 Q3	Y3 Q4	Y4 Q1	Y4 Q2	Y4 Q3	Y4 Q4
Total Development	12250	13250	41312.5	0	0	0	0	0	0	0	0	0	0	0	0	0	66812.5
Development FTE	11000	11000	11000	0	0	0	0	0									33000
Travel for Outreach	750	750	750														2250
Coordination with partner relations/user liason	500	500	500														1500
2nd level support 10% easy cases			312.5														312.5
2nd level support 85% average cases			21250														21250
2nd level support, 5% difficult cases			7500														7500
Pilot ticketing system setup		1000															1000
Total Production	0	0	0	4406.25	6254.6875	6304.6875	6004.6875	7154.6875	9587.5	8365.625	8437.5	9515.625	8837.5	7615.625	7015.625	8765.625	98265.625
Handover FTE				2000
Reactive 2nd level support 10% easy cases	0	0	0	31.25	78.125	78.125	78.125	78.125	125	109.375	125	109.375	109.375	93.75	93.75	93.75	1203.125
Reactive 2nd level support 85% average cases	0	0	0	1062.5	2656.25	2656.25	2656.25	2656.25	4250	3718.75	4250	3718.75	3718.75	3187.5	3187.5	3187.5	40906.25
Reactive 2nd level support, 5% difficult cases	0	0	0	250	625	625	625	625	1000	875	1000	875	875	750	750	750	9625
Pro-active ticket resolution	0	0	0	62.5	195.3125	195.3125	195.3125	195.3125	312.5	312.5	312.5	312.5	234.375	234.375	234.375	234.375	3031.25
Travel for customer/user engagement	0	0	0	750	750	750	750	750	750	750	750	750	750	750	750	750	9750
Coordination with partner relations/user liason	0	0	0	750	750	500	500	750	750	500	500	750	750	500	500	750	8250
1st line support & full production ticketing system + FAQ KB	0	0	0	1500	1200	1500	1200	2100	2400	2100	1500	3000	2400	2100	1500	3000	25500
Total Costs	12250	13250	41312.5	4406.25	6254.6875	6304.6875	6004.6875	7154.6875	9587.5	8365.625	8437.5	9515.625	8837.5	7615.625	7015.625	8765.625	165078.125

Income
SA2 Handover budget			2000						0	0	0	0	0	0	0		2000
EU GN2-JRA3 T2	11500	11500	11500	0	0	0	0	0									34500
Pilot staff JRA3 T2		9000	9000														18000
Travel Budget JRA3	750	750	750														2250
Travel budget SA2				750	750	750	750	750									3750
SA2 Operations funding				17 891	17 891	17 891	17 891	17 891									89456.25
Future operations incident management funding request in GN4-3									20 000	20 000	20 000	20 000	20 000	20 000	20 000	20 000	160000
Future travel funding request in GN4-3									750	750	750	750	750	750	750	750	6000
Total Funding	12250	21250	23250	18641.25	18641.25	18641.25	18641.25	18641.25	20750	20750	20750	20750	20750	20750	20750	20750	315956.25
CashFlow	0	8000	-18062.5	14235	12386.5625	12336.5625	12636.5625	11486.5625	11162.5	12384.375	12312.5	11234.375	11912.5	13134.375	13734.375	11984.375	150878.125
JRA3	10250															Gross Margin	0.477528534
SA2	93206.25	2000	95206.25
	Year 1				Year 2				Year 3				Year 4
	Y1 Q1	Y1 Q2	Y1 Q3	Y1 Q4	Y2 Q1	Y2 Q2	Y2 Q3	Y2 Q4	Y3 Q1	Y3 Q2	Y3 Q3	Y3 Q4	Y4 Q1	Y4 Q2	Y4 Q3	Y4 Q4
Cumulative Costs	12250	25500	66812.5	71218.75	77473.4375	83778.125	89782.8125	96937.5	106525	114890.625	123328.125	132843.75	141681.25	149296.875	156312.5	165078.125	1613709.375
Cumulative Funding	12250	24500	45750	69000	87641.25	106282.5	124923.75	143565	162206.25	182956.25	203706.25	224456.25	245206.25	265956.25	286706.25	307456.25	2492562.5
Cumulative Cash Flow	0	-1000	-22062.5	-24281.25	-14113.4375	8390.9375	43531.875	90159.375	145840.625	213906.25	294284.375	385896.875	489421.875	606081.25	736475	878853.125	3831384.375
																Gross Margin	0.352590206

Space shortcuts

Page tree