ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
WBSStaffFTE %Mos.Qty
Loaded Annual FTE Cost
NCE BudgetCommentsMonthly CostXSEDE NCE assumptions
2
2.1.1L2 0.112$63,899.65$12,779.9310% L2 for Lessons Learned (Sept 2022)$12,779.93PY10 actual data, plus 2.25%, used for FTE estimates
add 2.25% salary inflation
3
2.1.1L2 PM0.111$63,899.65$6,389.9710% Leslie M during September for CEE inputs to IPR18$6,389.97L2 PMs 10% for one month (Sept 2022) to complete IPR18
4
2.1.2L30.111$28,399.76$2,839.98$2,839.98L3s 10% for one month (Sept 2022) to complete IPR18
5
2.1.3L30.111$33,573.42$3,357.34$3,357.34L2s $ Deputies10% for one month (Sept 2022) to complete IPR18
6
2.1.4L30.111$46,149.74$4,614.97$4,614.97L1 management 15% for 4 mo (Sept-Dec 2022) and 5% for 8 mo (Jan-Aug 2023)
7
2.1.5L30.111$35,513.57$3,551.36$3,551.36Using 12 mo option for Eval team to complete all Longitudinal & ROI work
8
2.1.6L30.112$32,618.81$6,523.76$6,523.76IRIS activities through Dec 2022
9
2.1 Total$40,057.31Includes PEARC23 & IHPCSS23 evaluation costs
10
2.2.1L2 0.113$43,213.95$12,964.1910% L2 for Lessons Learned (Sept 2022)$12,964.19BusOps limited operations for full 12 mo
11
2.2.1L2 PM0.111$43,213.95$4,321.4010% Marques during September for ECSS inputs to IPR18$4,321.40
12
2.2.2L30.111$43,432.95$4,343.30$4,343.30
13
2.2.3L30.111$32,909.50$3,290.95$3,290.95
14
2.2.4L30.111$35,794.99$3,579.50$3,579.50
15
2.2.5L30.111$41,375.83$4,137.58$4,137.58
16
2.2.6L30.111$41,674.84$4,167.48$4,167.48
17
2.2 Total$36,804.39
18
2.3.1L2 0.113$57,757.53$17,327.2610% L2 for Lessons Learned (Sept 2022)$17,327.26
19
2.3.1L2 PM0.111$57,757.53$5,775.7510% Lucille during September for XCI inputs to IPR18$5,775.75
20
2.3.2L30.111$40,341.01$4,034.10$4,034.10
21
2.3.3L30.111$31,251.18$3,125.12$3,125.12
22
2.3 Total$30,262.23
23
2.4.1L2 0.112.5$77,926.59$19,481.6510% L2 for Lessons Learned (Sept 2022)$19,481.65
24
2.4.1L2 PM0.16521$77,926.59$25,715.7718% Scott during Sept. & 15% in Dec 2022 for Ops inputs to IPR18, IPR19, and overall report review.$12,857.89
25
2.4.2L30.112$46,978.20$9,395.64$9,395.64
26
2.4.3L30.111$41,260.38$4,126.04$4,126.04
27
2.4.4L30.111$26,786.48$2,678.65$2,678.65
28
2.4.5L30.111$35,442.93$3,544.29$3,544.29
29
2.4 Total$64,942.04
30
2.5.1L2 0.111$45,258.37$4,525.8410% L2 for Lessons Learned (Sept 2022)$4,525.84
31
2.5.1L2 PM0.111$45,258.37$4,525.8410% Sonia during September for RAS inputs to IPR18$4,525.84
32
2.5.2L30.111$20,847.16$2,084.72$2,084.72
33
2.5.3L30.111$40,386.51$4,038.65$4,038.65
34
2.5.XL30.101$0.00$0.00All existing contracts & MOUs end 31 Aug 2022$0.00
35
2.5 Total$15,175.04
36
2.6.1L2 0.1543$65,145.29$117,261.524mo: JT/TB/RP 15% (Sept-Dec 2022)$29,315.38
37
2.6.1L2 0.0583$65,145.29$78,174.348mo JT/TB/RP 5% (Jan-Aug 2023)$9,771.79
38
2.6.1L2 PM0.141$65,145.29$26,058.11Leslie 10% for 4 mo (Sept-Dec 2022) for general L1/L2 PM$6,514.53
39
2.6.2L30.111$38,650.21$3,865.02Dina for ER contributions to IPR18$3,865.02
40
2.6.3L30.241$39,675.59$31,740.474mo: LF 20% for IPR18, IPR19, and Final Report oversight$7,935.12
41
2.6.3PM0.1831$39,675.59$21,424.8218% Noni for IPR18, IPR19, and Final Report formatting$7,141.61
42
2.6.4All0.2543$32,999.37$98,998.124mo: RP/NL/DS 25% (Sept-Dec 2022)$24,749.53
43
2.6.4All0.183$45,481.63$109,155.928mo: RP/NL/DS 10% (Jan-Aug 2023)$13,644.49
44
2.6.5All112$961,866.36$961,866.36Includes PEARC23 & IHPCSS23. See "Eval Options" tab for details$80,155.53
45
2.6 Total$1,448,544.68
46
Grand Total
$1,635,785.70
47
IPR18 & project wrap-up
$673,919.33Grand Total minus 2.6.5 (Longitudinal, ROI, & IRIS)
48
49
9/1/2022$334,059.841.4
50
10/1/2022$168,669.580.1166666667
51
11/1/2022$155,811.69
52
12/1/2022$148,670.080.08333333333
53
1/1/2023$103,571.81
54
2/1/2023$103,571.81
55
3/1/2023$103,571.81
56
4/1/2023$103,571.81
57
5/1/2023$103,571.81
58
6/1/2023$103,571.81
59
7/1/2023$103,571.81
60
8/1/2023$103,571.81
61
Total$1,635,785.70
62
PY10 XSEDE L3 Totals
63
SUM of FTE Total (Salary, Wages, Fringe, F&A)
Type
64
L3BudgetActual
Act+2.25%
Monthly FTE
Monthly FTE Cost
65
2.1.1$383,628$387,460$396,1786.2$63,900
66
2.1.2$1,200,889$1,277,642$1,306,38946$28,400
67
2.1.3$288,353$308,974$315,9269.41$33,573
68
2.1.4$369,470$441,864$451,8069.79$46,150
69
2.1.5$710,481$713,050$729,09420.53$35,514
70
2.1.6$317,142$276,901$283,1318.68$32,619
71
2.2.1$501,147$445,875$455,90710.55$43,214
72
2.2.2$2,467,196$2,587,712$2,645,93660.92$43,433
73
2.2.3$1,031,659$932,731$953,71728.98$32,910
74
2.2.4$1,113,874$817,071$835,45523.34$35,795
75
2.2.5$701,614$835,205$853,99720.64$41,376
76
2.2.6$703,735$748,313$765,15018.36$41,675
77
2.3.1$218,786$231,595$236,8064.1$57,758
78
2.3.2$1,237,358$1,240,412$1,268,32131.44$40,341
79
2.3.3$512,665$501,547$512,83216.41$31,251
80
2.4.1$427,923$560,919$573,5407.36$77,927
81
2.4.2$984,296$943,699$964,93220.54$46,978
82
2.4.3$899,522$797,768$815,71819.77$41,260
83
2.4.4$518,057$550,662$563,05221.02$26,786
84
2.4.5$675,752$742,135$758,83321.41$35,443
85
2.5.1$191,174$150,935$154,3313.41$45,258
86
2.5.2$288,590$260,564$266,42712.78$20,847
87
2.5.3$1,273,494$1,296,318$1,325,48532.82$40,387
88
2.5.X$0$0$0
89
2.6.1$524,441$503,323$514,6487.9$65,145
90
2.6.2$428,932$531,086$543,03514.05$38,650
91
2.6.3$472,063$505,985$517,37013.04$39,676
92
2.6.4$228,464$218,167$223,0766.76$32,999
93
2.6.5$797,642$906,519$926,91620.38$45,482
94
Grand Total
$19,468,347$19,511,756$19,950,771#DIV/0!
95
96
97
98
99
100