Space Hotel Calculator - Google Drive


1
2	# of guests	18	Revenue per guest per night	$50,000	Expenses
3	# of crew	3	Occupancy rate per year	90%	Resupply launch costs	$91,720,656
4	total human capacity	21	Annual Revenue	344,925,000	Resupply cost of goods	$18,000,000	guess ($1,000,000 per guest)
5					Operations & Maintenance	$289,737,000	guess (84.6% of revenue)
6	mass per person (kg)	31,105	how to link habitable volume to mass?		Annual Expenses	399,457,656
7	total mass (kg)	653,205	phasing construction?
8					Annual Profit BTIA	-54,532,656
9	Cost to construct per kg	$5,000
10	Cost to launch per kg to 28 deg LEO	$2,542
11	Capital cost per kg	$7,542
12	Total capital cost	4,926,472,110
13
14
15
16
17
18	Year to reach Breakeven point (assuming no operating costs)	14
19
20
21	Habitable Volume m3 per person	55
22	Total habitable volume (m3)	1155
23	Total habitable volume (ft3)	40,788


1	Maintenance costs per year
2	Resupply Flights per year per person aboard		There have been 89 "resupply" flights (i.e. non-Shuttle) since the ISS was launched in November 1998, or 89 flights over 168 months.
3	ISS	1.06	http://www.nasa.gov/mission_pages/station/expeditions/expedition26/resupply_feature.html
4	Bigelow
5	Mir
6	Skylab
7		pounds
8	Propellant	1918
9	Oxygen	110
10	Water	926
11	Dry cargo	3080
12	Total	6034
13	Total dry cargo	3080
14	Total dry cargo per person per resupply ship	513
15	Total nondry cargo per person per resupply ship	492
16
17	Total resupply ships per year per person	1.06
18
19	Total people aboard	21
20
21	Total dry cargo delivered per year (kg)	25,128	Total nondry cargo required per year (kg)	10,954
22	Cost to deliver dry cargo per year	$63,874,529	Cost to deliver nondry cargo per year	$27,846,127	total maintenance flight costs	$91,720,656


1	Mass per person aboard	kg/crewmember
2	ISS	64,286		Ratio of average mass to average volume per person	62.762
3	Bigelow	3,333		Ratio of ISS mass to ISS volume per person	76.80491551
4	Skylab	25,696		Ratio of average mass to average volume per person
5
6	Average	31,105
7
8
9	Volume	Total m3	m3/crewmember
10	ISS	837	120
11	Bigelow	330	55
12	Skylab	319.8	107
13	Double ISS		239
14	Average	495.6	130
15
16	Ratio of average mass to average volume per person	239.125


1	Launch cost to LEO	per kg	per lb	Total per trip
2	Atlas V	$7,637	$3,471	225,000,000
3	Falcon 9	$4,297	$1,949	56,500,000
4	Falcon Heavy	$2,547	$1,154	135,000,000
5	Conceptual	$455	$1,000
6	Average	$3,734	$1,893	138,833,333
7
8	Grasshopper	$76	$34	1,000,000
9	Falcon 9R		$242
10
11
12
13
14	Rocket type	Cost per pound to closest point in space (low earth orbit)
15	Atlas V	$3,471
16	Falcon 9	$1,949
17	Falcon Heavy	$1,154
18	Conceptual	$1,000
19	Average	$1,893
20
21		Max payload to Orbit
22		kg	lbs	Cost per launch	Cost per lb	Source
23	Atlas V 401	18810	41382	99000000	$2,392	http://breakingdefense.com/2014/05/ula-fires-back-at-spacex-at-space-symposium-details-launch-costs/
24	Falcon 9 v1.1	13150	28930	61200000	$2,115	http://www.spacex.com/about/capabilities
25	Falcon 9-R	13150	28930	7000000	$242	http://en.wikipedia.org/wiki/Falcon_9#Falcon_9-R