ABCDEFGHIJKL
1
HOW TO USE THIS SPREADSHEET: Enter information ONLY into those boxes with a blue outline/fill. All other cells will autopopulate. Additional information and instructions are given on the "INSTRUCTIONS" sheet (second sheet tab)

If you have questions about how a quantity is calculated, or what information should go in certain rows, see the "HELP COLUMN" in the row you want to know more about.
2
Additional Information
HELP
COLUMN
3
 Phase C Phase C Phase C-D Phase D Phase E Phase F
4
# People on Team FY 1 FY 2 FY 3 FY 4 FY 5 FY 6 ?
5
Science Personnel:1010551515
6
Engineering Personnel:151515151010
7
Technicians:3030303000
8
Administration Personnel:555555
9
Management Personnel:444444
10
11
NASA L'SPACE Mission Concept Academy Budget - YOUR MISSION NAME HERE
12
Mission Phase Phase C Phase C Phase C-D Phase D Phase E Phase F ?
13
Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
Cumulative Total
14
PERSONNEL
15
Science Personnel $ 800,000 $ 820,800 $ 420,800 $ 431,200 $ 1,324,800 $ 1,356,000 $ 5,153,600
16
Engineering Personnel $ 1,200,000 $ 1,231,200 $ 1,262,400 $ 1,293,600 $ 883,200 $ 904,000 $ 6,774,400
17
Technicians $ 1,800,000 $ 1,846,800 $ 1,893,600 $ 1,940,400 $ - $ - $ 7,480,800
18
Administration Personnel $ 300,000 $ 307,800 $ 315,600 $ 323,400 $ 331,200 $ 339,000 $ 1,917,000
19
Project Management $ 480,000 $ 492,480 $ 504,960 $ 517,440 $ 529,920 $ 542,400 $ 3,067,200
20
21
Total Salaries $ 4,580,000 $ 4,699,080 $ 4,397,360 $ 4,506,040 $ 3,069,120 $ 3,141,400 $ 24,393,000
22
Total ERE $ 1,278,278 $ 1,311,513 $ 1,227,303 $ 1,257,636 $ 856,591 $ 876,765 $ 6,808,086 ?
23
Personnel Margin $ -
24
25
TOTAL PERSONNEL $ 5,858,278 $ 6,166,869 $ 5,917,146 $ 6,213,242 $ 4,333,985 $ 4,540,526 $ 33,030,046
26
TRAVEL
27
Total Flights Cost $ - ?
28
Total Hotel Cost $ - ?
29
Total Transportation Cost $ - ?
30
Total Per Diem Cost $ - ?
31
Travel Margin $ -
32
33
Total Travel Costs $ - $ - $ - $ - $ - $ - $ -
34
OUTREACH
35
Total Outreach Materials $ - ?
36
Total Outreach Venue Costs $ -
37
Total Outreach Travel Costs $ -
38
Total Outreach Services Costs $ -
39
Total Outreach Personnel Costs $ -
40
Outreach Margin $ -
41
 $ -
42
Total Outreach Costs $ - $ - $ - $ - $ - $ - $ -
43
DIRECT COSTS
44
Mechanical Subsystem $ - ?
45
Power Subsystem $ - ?
46
Thermal Control Subsystem $ - ?
47
Comms & Data Handling Subsystem
 $ - ?
48
Guidance, Nav, & Control Subsystem
 $ - ?
49
Science Instrumentation $ - ?
50
Spacecraft Cost Margin $ - ?
51
Total Spacecraft Direct Costs $ - $ - $ - $ - $ - $ - $ -
52
Manufacturing Facility Cost $ - ?
53
Test Facility Cost $ - ?
54
Facility Cost Margin $ - ?
55
Total Facilities Costs $ - $ - $ - $ - $ - $ - $ -
56
57
Total Direct Costs $ - $ - $ - $ - $ - $ - $ - ?
58
Total MTDC $ - $ - $ - $ - $ - $ - $ - ?
59
FINAL COST CALCULATIONS
60
Total F&A $ - $ - $ - $ - $ - $ - $ - ?
61
62
Total Projected Cost $ 5,858,278 $ 6,166,869 $ 5,917,146 $ 6,213,242 $ 4,333,985 $ 4,540,526 $ 33,030,046
63
Total Cost Margin $ - $ - $ - $ - $ - $ - $ - ?
64
0.0%0.0%0.0%0.0%0.0%0.0%
65
66
Total Project Cost $ 5,858,278 $ 6,166,869 $ 5,917,146 $ 6,213,242 $ 4,333,985 $ 4,540,526 $ 33,030,046 ?
67
68
********** Do not change the numbers in the cells below unless mission concept instructions specify otherwise.
69
F&A %10%10%10%10%10%10%?
70
ERE - Staff28%28%28%28%28%28%?
71
Inflation Rate0.0%2.6%5.2%7.8%10.4%13.0%?
72
Science Personnel Salary $ 80,000
73
Engineering Personnel Salary $ 80,000
74
Technicians Salary $ 60,000
75
Administration Personnel Salary $ 60,000
76
Project Management Salary $ 120,000
77