STEAM Camp Template - Jeremy

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		Update Costs in Yellow Fields to Customize Estimate
2
3	Fixed Costs
4		Travel and Lodging	0			Projected Total Net Revenue based on Sign ups and price (before 50/50 split)
5		Insurance (if needed)	600
6		Admin - reg + remote management	1000				Number sign ups
7		Advertising + Video	1000			Workshop Price	1	6	9	12	13	18	21	24
8		Facility/Venue	1000			500	-5655	-5455	-5335	-5215	-5175	-4975	-4855	-4735
9		Critical Spares/Instructor Kit	100			600	-5555	-4855	-4435	-4015	-3875	-3175	-2755	-2335
10						700	-5455	-4255	-3535	-2815	-2575	-1375	-655	65
11					2 Day Camps	800	-5355	-3655	-2635	-1615	-1275	425	1445	2465
12		Fixed Subtotal	3700			950	-5205	-2755	-1285	185	675	3125	4595	6065
13						1000	-5155	-2455	-835	785	1325	4025	5645	7265
14					4 Day Camps	1100	-5055	-1855	65	1985	2625	5825	7745	9665
15	Variable Costs					1200	-4955	-1255	965	3185	3925	7625	9845	12065
16		Dev Kit ($300 each)	300			1300	-4855	-655	1865	4385	5225	9425	11945	14465
17		Project Materials ($100 each)	100			1400	-4755	-55	2765	5585	6525	11225	14045	16865
18					9 Day Camps	1500	-4655	545	3665	6785	7825	13025	16145	19265
19		Variable Subtotal	400			1600	-4555	1145	4565	7985	9125	14825	18245	21665
20						1700	-4455	1745	5465	9185	10425	16625	20345	24065
21		Number of 8 hour days camp will run	9			1800	-4355	2345	6365	10385	11725	18425	22445	26465
22		Number additional instructors	1	1440
23		Assistant Instructor (hourly)	20
24		Contengency %	0.15
25
26						Instructor Per Class Hour Net after 50% split (# days is main variable)
27							Number sign ups
28	Notes:					Workshop Price	1	6	9	12	13	18	21	24
29	9 day camps should have a venue provided at 0 cost or venue cost is large factor					500	-39	-38	-37	-36	-36	-35	-34	-33
30	It seems shorter camps more likely to be profitable for instructors					600	-39	-34	-31	-28	-27	-22	-19	-16
31	Some flex around admin and marketing fixed costs improves net for small # of participants					700	-38	-30	-25	-20	-18	-10	-5	0
32	Discounted price make sense when large captive audience guaranteed					800	-37	-25	-18	-11	-9	3	10	17
33	Genearlly need between 6 and 9 signups to make it work					900	-36	-21	-12	-3	0	15	25	34
34	Fixed costs are the major barrier to events with 6 or less sign ups					1000	-36	-17	-6	5	9	28	39	50
35	Consider promotional bonus i.e. if 12+ sign ups, free xyz hardware on last day					1100	-35	-13	0	14	18	40	54	67
36	Instructors should lower hourly rate by 25% - 30% for self employment/income taxes					1200	-34	-9	7	22	27	53	68	84
37						1300	-34	-5	13	30	36	65	83	100
38						1400	-33	0	19	39	45	78	98	117
39						1500	-32	4	25	47	54	90	112	134
40						1600	-32	8	32	55	63	103	127	150
41						1700	-31	12	38	64	72	115	141	167
42						1800	-30	16	44	72	81	128	156	184
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100