wiki/ PsuStudentClub/ BudgetRequest2007

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