Spreadsheet: 15d60b29-64af-4f54-b66f-0a8037de27dc
Sheet: Sheet1

Year | -4 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | -3 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | -2 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | -1 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | 0 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | 1 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | 2 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | 3 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | 4 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | 5 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | 6 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | 7 | Unnamed: 46 | Unnamed: 47 | Unnamed: 48 | 8 | Unnamed: 50 | Unnamed: 51 | Unnamed: 52
quarter | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4
 | 2008 |  |  |  | 2009 |  |  |  | 2010 |  |  |  | 2011 |  |  |  | 2012 |  |  |  | 2013 |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016 |  |  |  | 2017 |  |  |  | 2018 |  |  |  | 2019 |  |  |  | 2020
Buy Infrastructure
ECS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ECS | ECS |  |  |  | ECS
BW |  | BW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BW | BW |  |  | BW | BW
BCP | BCP |  |  |  |  |  |  |  |  |  |  |  |  |  | BCP |  |  |  | BCP | BCP | BCP | BCP |  | BCP | BCP | BCP | BCP
EP |  |  | EP |  |  |  |  |  |  |  |  |  |  |  | EP |  | EP | EP | EP | EP | EP | EP | EP | EP | EP | EP | EP | EP
HPR | HPR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HPR | HPR | HPR |  | HPR | HPR | HPR
HVO | HVO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HVO | HVO | HVO |  | HVO | HVO | HVO
CAF | CAF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAF |  |  | CAF | CAF
CTM | CTM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CTM | CTM | CTM | CTM | CTM | CTM
VTS |  |  |  |  | VTS |  |  |  |  |  |  |  |  |  |  |  | VTS |  |  |  | VTS | VTS | VTS | VTS | VTS | VTS | VTS | VTS
HTS | HTS |  |  |  |  |  | HTS |  |  |  | HTS |  | HTS |  | HTS |  | HTS |  | HTS |  | HTS
CAT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAT |  |  |  | CAT | CAT | CAT | CAT | CAT | CAT | CAT | CAT | CAT
CTF |  |  |  |  |  |  |  |  |  |  |  | CTF |  |  |  |  | CTF | CTF | CTF | CTF | CTF | CTF | CTF | CTF | CTF
Capacity (CM/yr)
ECS | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 90 | 150 | 150 | 150 | 150 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210
BW | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 82 | 122 | 122 | 122 | 162 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202
BCP | 2 | 2 | 2 | 2 | 2 | 2 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 42 | 42 | 42 | 42 | 62 | 82 | 102 | 122 | 122 | 142 | 162 | 182 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202
EP | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 32 | 32 | 47 | 62 | 77 | 92 | 107 | 122 | 137 | 152 | 167 | 182 | 197 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212
HPR | 2 | 2 | 2 | 2 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 62 | 92 | 122 | 122 | 152 | 182 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212
HVO | 2 | 2 | 2 | 2 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 62 | 92 | 122 | 122 | 152 | 182 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212 | 212
CAF | 40 | 40 | 40 | 40 | 40 | 40 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 120 | 120 | 120 | 160 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
CTM | 6 | 6 | 6 | 6 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 66 | 96 | 126 | 156 | 186 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216 | 216
VTS | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 42 | 42 | 42 | 42 | 62 | 82 | 102 | 122 | 142 | 162 | 182 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202 | 202
HTS | 2 | 2 | 2 | 2 | 8 | 8 | 8 | 8 | 8 | 8 | 14 | 14 | 14 | 14 | 20 | 20 | 26 | 26 | 32 | 32 | 38 | 38 | 44 | 44 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
CAT | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 30 | 30 | 30 | 30 | 50 | 70 | 90 | 110 | 130 | 150 | 170 | 190 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210
CTF | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 26 | 26 | 26 | 26 | 26 | 46 | 66 | 86 | 106 | 126 | 146 | 166 | 186 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206 | 206
Overall capacity (not HTS) |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 10 | 26 | 26 | 26 | 26 | 30 | 30 | 30 | 80 | 120 | 120 | 120 | 150 | 197 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Target Capacity | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 120 | 120 | 120 | 120 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 110 | 110 | 110 | 110
RF
RF (klystron + mod +dist) | 1 |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 9 |  |  |  | 23 |  |  |  | 40 |  |  |  | 67 |  |  |  | 67 |  |  |  | 40 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Cost of infrastructure
ECS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2 | 0.2 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BW | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BCP | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.5 | 0 | 0 | 0 | 1.5 | 1.5 | 1.5 | 1.5 | 0 | 1.5 | 1.5 | 1.5 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EP | 0 | 0 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.5 | 0 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HPR | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2 | 0.2 | 0.2 | 0 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HVO | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAF | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CTM | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
VTS | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HTS | 1.5 | 0 | 0 | 0 | 0 | 0 | 1.5 | 0 | 0 | 0 | 1.5 | 0 | 1.5 | 0 | 1.5 | 0 | 1.5 | 0 | 1.5 | 0 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CTF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Infra Totals by 1/4 | 6.45 | 3 | 1.5 | 0 | 1 | 0 | 1.5 | 0 | 0 | 0 | 1.5 | 15 | 1.5 | 0 | 4.5 | 0 | 19 | 16.5 | 20.5 | 21 | 23.5 | 19 | 21.95 | 24.45 | 24.45 | 7.45 | 8.65 | 4.95 | 2.2 | 1 | 1.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
integral CM infra | 6.45 | 9.45 | 10.95 | 10.95 | 11.95 | 11.95 | 13.45 | 13.45 | 13.45 | 13.45 | 14.95 | 29.95 | 31.45 | 31.45 | 35.95 | 35.95 | 54.95 | 71.45 | 91.95 | 112.95 | 136.45 | 155.45 | 177.4 | 201.85 | 226.3 | 233.7499999999999 | 242.3999999999999 | 247.3499999999999 | 249.5499999999999 | 250.5499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999 | 251.7499999999999
Infra FY Totals | 10.95 |  |  |  | 2.5 |  |  |  | 16.5 |  |  |  | 6 |  |  |  | 77 |  |  |  | 88.9 |  |  |  | 45.5 |  |  |  | 4.4 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
CM parts and processing | 6 |  |  |  | 6 |  |  |  | 6 |  |  |  | 39 |  |  |  | 39 |  |  |  | 180 |  |  |  | 300 |  |  |  | 300 |  |  |  | 165 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
RF (klystron + mod +dist) | 3.5 |  |  |  | 3.5 |  |  |  | 7 |  |  |  | 10.5 |  |  |  | 31.5 |  |  |  | 80.5 |  |  |  | 140 |  |  |  | 234.5 |  |  |  | 234.5 |  |  |  | 140 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
(CM + Infra + RF) FY  totals | 20.45 |  |  |  | 12 |  |  |  | 29.5 |  |  |  | 55.5 |  |  |  | 147.5 |  |  |  | 349.4 |  |  |  | 485.5 |  |  |  | 538.9 |  |  |  | 399.5 |  |  |  | 140 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
(CM + Infra + RF) FY  integral | 20.45 |  |  |  | 32.45 |  |  |  | 61.95 |  |  |  | 117.45 |  |  |  | 264.95 |  |  |  | 614.3499999999999 |  |  |  | 1099.85 |  |  |  | 1638.75 |  |  |  | 2038.25 |  |  |  | 2178.25 |  |  |  | 2178.25 |  |  |  | 2178.25 |  |  |  | 2178.25
 | 2008 |  |  |  | 2009 |  |  |  | 2010 |  |  |  | 2011 |  |  |  | 2012 |  |  |  | 2013 |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016 |  |  |  | 2017 |  |  |  | 2018 |  |  |  | 2019 |  |  |  | 2020
Year | -4 |  |  |  | -3 |  |  |  | -2 |  |  |  | -1 |  |  |  | 0 |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8
integral CM parts and processing | 6 |  |  |  | 12 |  |  |  | 18 |  |  |  | 57 |  |  |  | 96 |  |  |  | 276 |  |  |  | 576 |  |  |  | 876 |  |  |  | 1041 |  |  |  | 1041 |  |  |  | 1041 |  |  |  | 1041 |  |  |  | 1041
integral RF | 3.5 |  |  |  | 7 |  |  |  | 14 |  |  |  | 24.5 |  |  |  | 56 |  |  |  | 136.5 |  |  |  | 276.5 |  |  |  | 511 |  |  |  | 745.5 |  |  |  | 885.5 |  |  |  | 885.5 |  |  |  | 885.5 |  |  |  | 885.5
Resource | Code |  | delay after purchase |  | unit cost |  | unit capacity |  | quantity for > 20 CM/yr |  | cost for > 20 CM/yr |  | Actual capacity
Eddy current scanner | ECS |  |  | 0.5 |  | 0.2 |  | 60 |  | 1 |  | 0 |  | 60
Beam Welder | BW |  |  | 2 |  | 3 |  | 40 |  | 2 |  | 6 |  | 80
BCP | BCP |  |  | 1.5 |  | 1.5 |  | 20 |  | 1 |  | 1.5 |  | 20
Electropolish | EP |  |  | 1.5 |  | 1.5 |  | 15 |  | 2 |  | 3 |  | 30
High Pressure Rinse | HPR |  |  | 1 |  | 0.2 |  | 30 |  | 2 |  | 0.4 |  | 60
High temp [NAME] | HVO |  |  | 1 |  | 1 |  | 30 |  | 1 |  | 1 |  | 30
CAF clean room | CAF |  |  | 1.5 |  | 2 |  | 40 |  | 1 |  | 2 |  | 40
cavity tuning machine | CTM |  |  | 1 |  | 0.25 |  | 30 |  | 1 |  | 0.25 |  | 30
Vertical Test System | VTS |  |  | 1 |  | 1 |  | 20 |  | 1 |  | 1 |  | 20
Horizontal test system | HTS |  |  | 1 |  | 1.5 |  | 6 |  | 4 |  | 6 |  | 24
CM Assembly tooling | CAT |  |  | 0.5 |  | 1 |  | 20 |  | 1 |  | 1 |  | 20
Cryomodule Test Facility | CTF |  |  | 2 |  | 15 |  | 20 |  | 1 |  | 15 |  | 20
Industrial building | IB |  |  | 2 |  | 10
 | for 20 CM/yr |  |  |  |  |  |  |  | >20 CM cost |  |  | 37.15 | M$