| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 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 | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |