There are several different types of SFC expenditure types. Most of our expenses fall into the "minor equipment" category (equipment that costs less than $5,000 per item).
Note that the following table is generated from the attached budget.ods file. Please edit the file, save as a .csv file, and run the following command to turn it into wiki format:
sed 's/\*/'\'\'\''/g; s/\("[^"]*"\|[^,]*\),\("[^"]*"\|[^,]*\),\("[^"]*"\|[^,]*\),\("[^"]*"\|[^,]*\),\("[^"]*"\|[^,]*\),\("[^"]*"\|[^,]*\)/|| \1 || \2 || \3 || \4 || \5 || \6 ||/; s/"//g' budget.csv > /tmp/budget.wiki
Then you can cat the file in your tmp directory and copy and paste the contents into the wiki.
|
2007 Budget |
|||||
|
total # of launches |
2 |
||||
|
# launches at Blackrock |
1 |
||||
|
# paid students per launch |
5 |
||||
|
# non-paid PSAS members per launch |
10 |
||||
|
# airframes per year |
2 |
||||
|
# avionics stacks per year |
2 |
||||
|
# recruitment events per year |
4 |
||||
|
# other events per year |
3 |
||||
|
Description |
Formula |
Total |
Category Total |
Amount Paid By IBM Grant |
SFC Expenditure Type |
|
Airframe |
|||||
|
Airframe – epoxy |
$50 per rocket |
$100.00 |
Minor Equipment |
||
|
Airframe – fiberglass |
$100 per rocket |
$200.00 |
Minor Equipment |
||
|
Airframe – fasteners |
$20 per rocket |
$40.00 |
Minor Equipment |
||
|
Airframe – parachute material |
$100 per rocket |
$200.00 |
Minor Equipment |
||
|
Airframe – gas generator (for deployment) |
$100 per rocket |
$200.00 |
Minor Equipment |
||
|
Airframe – pyrotechnics |
$100 per rocket |
$200.00 |
Minor Equipment |
||
|
$940.00 |
|||||
|
Flight Computer |
|||||
|
Flight Computer – TQM MCP5200 |
$500 per rocket |
$1,000.00 |
$1,000.00 |
Minor Equipment |
|
|
$1,000.00 |
|||||
|
Inertial Measurement Unit (IMU) |
|||||
|
Inertial Measurement Unit – accelerometers |
$30 x 2 per avionics stack |
$120.00 |
Minor Equipment |
||
|
Inertial Measurement Unit – rate gyroscopes |
$75 x 2 per avionics stack |
$300.00 |
Minor Equipment |
||
|
Inertial Measurement Unit – pressure sensors |
$50 per avionics stack |
$100.00 |
Minor Equipment |
||
|
Inertial Measurement Unit – magnetic sensors |
$50 x 3 per avionics stack |
$300.00 |
Minor Equipment |
||
|
Inertial Measurement Unit – thermal sensors |
$10 per avionics stack |
$20.00 |
Minor Equipment |
||
|
Inertial Measurement Unit – support components |
$20 x 2 per avionics stack |
$40.00 |
Minor Equipment |
||
|
$880.00 |
|||||
|
Sensor Nodes |
|||||
|
Sensor Node Front End – switching power supply components |
$50 x 6 nodes per rocket x number of avionics stacks |
$600.00 |
$600.00 |
Minor Equipment |
|
|
Sensor Node Front End – ARM processor |
$12 x 6 nodes per rocket x number of avionics stacks |
$144.00 |
$144.00 |
Minor Equipment |
|
|
Sensor Node Front End – PC Board |
$20 x 6 nodes per rocket x number of avionics stacks |
$240.00 |
$240.00 |
Minor Equipment |
|
|
Sensor Node Front End – Board Connectors |
$5 x 6 nodes per rocket x number of avionics stacks |
$60.00 |
$60.00 |
Minor Equipment |
|
|
Sensor Node Front End – support components |
$20 x 6 nodes per rocket x number of avionics stacks |
$240.00 |
$240.00 |
Minor Equipment |
|
|
$1,284.00 |
|||||
|
Power system |
|||||
|
Power system – lithium ion battery |
$400 per avionics stack |
$800.00 |
$800.00 |
Minor Equipment |
|
|
Power system – switching power supply components |
$80 per avionics stack |
$160.00 |
$160.00 |
Minor Equipment |
|
|
Power system – ARM processor |
$12 per avionics stack |
$24.00 |
$24.00 |
Minor Equipment |
|
|
Power system – PC Board |
$20 per avionics stack |
$40.00 |
$40.00 |
Minor Equipment |
|
|
Power system – Board Connectors |
$50 per avionics stack |
$100.00 |
$100.00 |
Minor Equipment |
|
|
$1,124.00 |
|||||
|
Communications equipment |
|||||
|
Ground Support – Wifi antenna |
$450 each |
$450.00 |
$450.00 |
Minor Equipment |
|
|
Communications – 2.4 GHz Power Amplifier |
$350 per avionics stack |
$700.00 |
$700.00 |
Minor Equipment |
|
|
Communications – patch antennas |
$200 x 3 antennas per rocket x number of airframes |
$1,200.00 |
$1,200.00 |
Minor Equipment |
|
|
Communications – SMA connectors |
$75 per rocket |
$150.00 |
$150.00 |
Minor Equipment |
|
|
Ground Support – antennas |
$200 each x 2 antennas |
$400.00 |
$400.00 |
Minor Equipment |
|
|
$2,900.00 |
|||||
|
Amateur TV |
|||||
|
Amateur TV – Camera 1 |
$300 per avionics stack |
$600.00 |
$600.00 |
Minor Equipment |
|
|
Amateur TV – Camera 2 |
$100 per avionics stack |
$200.00 |
$200.00 |
Minor Equipment |
|
|
Amateur TV – Overlay board |
$100 per avionics stack |
$200.00 |
$200.00 |
Minor Equipment |
|
|
Amateur TV – TX Exciter |
$100 per avionics stack |
$200.00 |
$200.00 |
Minor Equipment |
|
|
Amateur TV – power amplifier |
$50 per avionics stack |
$100.00 |
$100.00 |
Minor Equipment |
|
|
$1,300.00 |
|||||
|
GPS |
|||||
|
GPS – OEM board |
$250 per avionics stack |
$500.00 |
Minor Equipment |
||
|
GPS – Low Noise amplifier |
$300 per avionics stack |
$600.00 |
Minor Equipment |
||
|
$1,100.00 |
|||||
|
Motor |
|||||
|
Motor |
$1000 per launch |
$2,000.00 |
Minor Equipment |
||
|
$2,000.00 |
|||||
|
Publicity |
|||||
|
Vanguard Ads |
$28.50/run for 1/16 of a page x number of recruitment events |
$114.00 |
Advertising (Vanguard) |
||
|
Fliers |
$0.03 per flier x 50 fliers x number of events |
$10.50 |
Duplicating/Copy Services |
||
|
$124.50 |
|||||
|
Travel |
|||||
|
Car rental to launch site |
$300 for eastern Oregon, $600 for Nevada |
$900.00 |
Travel |
||
|
Food at launches |
$15 per day x 3 days x number of students at launch x number launches |
$300.00 |
Travel |
||
|
Trailer Rental for launch tower |
$300 per launch |
$600.00 |
Travel |
||
|
$1,800.00 |
|||||
|
Range Fees |
|||||
|
Range fees for Blackrock Launch site |
$40 per student x number launches at Blackrock Desert |
$600.00 |
Competition Entry Fees |
||
|
Range fees for Bend Launch site |
$10 per student x number launches at Bend |
$150.00 |
Competition Entry Fees |
||
|
$750.00 |
|||||
|
Catering |
|||||
|
Recruitment event food |
$100 per event x number of events per year |
$400.00 |
Food Service |
||
|
$400.00 |
|||||
|
Office Supplies |
|||||
|
business cards |
$20 per 1000 |
$20.00 |
Office and Administrative Supplies |
||
|
Clamps |
$3 each x 6 clamps for banner |
$18.00 |
Office and Administrative Supplies |
||
|
Duck Tape + Paper |
$4 each |
$7.00 |
Office and Administrative Supplies |
||
|
$45.00 |
|||||
|
Merchandise for Resale |
|||||
|
T-shirts |
$7 each x 30 t-shirts |
$210.00 |
Merchandise for Resale |
||
|
$210.00 |
|||||
|
Totals |
Paid by SFC |
$7,149.50 |
Paid by IBM Grant |
$7,608.00 |
|
|
Revenue |
|||||
|
T-shirt sales |
30 t-shirts @ $20 each |
$600.00 |
Sales |
||
|
Range fees for Blackrock Launch |
$40 x 10 people x number launches at Blackrock Desert |
$400.00 |
Tuitions/Fees |
||
|
Range fees for Bend Launch |
$10 x 10 people x number launches at Bend |
$100.00 |
Tuitions/Fees |
||
|
Total Revenue |
$1,100.00 |