STEAM Camp Finances - Revision history

Jeremyd: /* March 2020 */

2020-03-07T14:43:59Z

March 2020

← Older revision		Revision as of 14:43, 7 March 2020
Line 7:		Line 7:
	<iframe src="https://docs.google.com/spreadsheets/d/1Vven0eMArgjbrps68_Lw9-c_Z2zP9u525a4n_DVpeDc/edit?usp=sharing&single=true&widget=true&headers=false&rm=minimal"height=800 width=1200></iframe>		<iframe src="https://docs.google.com/spreadsheets/d/1Vven0eMArgjbrps68_Lw9-c_Z2zP9u525a4n_DVpeDc/edit?usp=sharing&single=true&widget=true&headers=false&rm=minimal"height=800 width=1200></iframe>
	</html>		</html>

			[https://docs.google.com/spreadsheets/d/1Vven0eMArgjbrps68_Lw9-c_Z2zP9u525a4n_DVpeDc/edit?usp=sharing Edit]

	=September 2019=		=September 2019=

2020-03-04T16:39:11Z

March 2020

← Older revision		Revision as of 16:39, 4 March 2020
Line 1:		Line 1:
	=March 2020=		=March 2020=
	*Steam Camp Cost - Revenue Visualizer/Calculator		*Steam Camp Cost - Revenue Visualizer/Calculator
	*This embed is editable directly. Update the yellow fields to change the calculations!		*This embed is editable directly. Update the yellow fields to change the calculations! [https://wiki.opensourceecology.org/wiki/Jeremy_Log#Tue_Mar_03: How to embed editable Google Sheet Here]
	**Change fixed and variable costs to see total Net Revenue in upper table		**Change fixed and variable costs to see total Net Revenue in upper table
	**Adjust # days and extra instructor count to see hourly return on time in lower table		**Adjust # days and extra instructor count to see hourly return on time in lower table
Line 7:		Line 7:
	<iframe src="https://docs.google.com/spreadsheets/d/1Vven0eMArgjbrps68_Lw9-c_Z2zP9u525a4n_DVpeDc/edit?usp=sharing&single=true&widget=true&headers=false&rm=minimal"height=800 width=1200></iframe>		<iframe src="https://docs.google.com/spreadsheets/d/1Vven0eMArgjbrps68_Lw9-c_Z2zP9u525a4n_DVpeDc/edit?usp=sharing&single=true&widget=true&headers=false&rm=minimal"height=800 width=1200></iframe>
	</html>		</html>


	=September 2019=		=September 2019=

2020-03-04T16:36:20Z

← Older revision		Revision as of 16:36, 4 March 2020
Line 5:		Line 5:
	**Adjust # days and extra instructor count to see hourly return on time in lower table		**Adjust # days and extra instructor count to see hourly return on time in lower table
	<html>		<html>
	<iframe src="https://docs.google.com/spreadsheets/d/1Vven0eMArgjbrps68_Lw9-c_Z2zP9u525a4n_DVpeDc/edit?usp=sharing&single=true&widget=true&headers=false"height=800 width=1200></iframe>		<iframe src="https://docs.google.com/spreadsheets/d/1Vven0eMArgjbrps68_Lw9-c_Z2zP9u525a4n_DVpeDc/edit?usp=sharing&single=true&widget=true&headers=false&rm=minimal"height=800 width=1200></iframe>
	</html>		</html>

2020-03-04T15:37:53Z

September 2019

← Older revision		Revision as of 15:37, 4 March 2020
Line 1:		Line 1:
			=March 2020=
			*Steam Camp Cost - Revenue Visualizer/Calculator
			*This embed is editable directly. Update the yellow fields to change the calculations!
			**Change fixed and variable costs to see total Net Revenue in upper table
			**Adjust # days and extra instructor count to see hourly return on time in lower table
			<html>
			<iframe src="https://docs.google.com/spreadsheets/d/1Vven0eMArgjbrps68_Lw9-c_Z2zP9u525a4n_DVpeDc/edit?usp=sharing&single=true&widget=true&headers=false"height=800 width=1200></iframe>
			</html>


	=September 2019=		=September 2019=
	This is for initial STEAM Camps during the development phase of the STEAM Camps.		This is for initial STEAM Camps during the development phase of the STEAM Camps.

2020-02-15T03:09:36Z

Prototyping Kit BOM

← Older revision		Revision as of 03:09, 15 February 2020
Line 15:		Line 15:

	=Prototyping Kit BOM=		=Prototyping Kit BOM=
			The January STEAM Camp had a $521 cost of materials.
	*Around 500 in materials for D3D Universal package + experiments + project materials; $250 printer, $200 Pi Tablet		*Around 500 in materials for D3D Universal package + experiments + project materials; $250 printer, $200 Pi Tablet

2020-02-15T03:09:01Z

Prototyping Kit BOM

← Older revision		Revision as of 03:09, 15 February 2020
Line 16:		Line 16:
	=Prototyping Kit BOM=		=Prototyping Kit BOM=

	*Around ~~400~~ in materials for D3D ~~Simple~~ package + ~~experiment; plus 100 in~~ project materials ~~for the 5 project days.~~		*Around 500 in materials for D3D Universal package + experiments + project materials; $250 printer, $200 Pi Tablet
	*Printer parts - 200
	*Motor parts - 20
	*Motor controller parts - 20
	*Circuit maker parts - 20
	*Battery pack parts - 20
	*Tools - 20
	*Universal Power Supply Parts - 100

	=Evolution Notes=		=Evolution Notes=

2019-10-24T23:24:43Z

Evolution Notes

← Older revision		Revision as of 23:24, 24 October 2019
Line 28:		Line 28:
	*Once the video instructionals for the STEAM Camp are perfected, then the Remote Participation option becomes much more attractive. Both on-site and remote people should be watching the instructional videos for the builds instead of listening to the instructor - the instructor is there only for clarification. Video person attends and works on inserting the clarifications into the videos for future events.		*Once the video instructionals for the STEAM Camp are perfected, then the Remote Participation option becomes much more attractive. Both on-site and remote people should be watching the instructional videos for the builds instead of listening to the instructor - the instructor is there only for clarification. Video person attends and works on inserting the clarifications into the videos for future events.
	*Another future product could be video collections. Otherwise, all video is published freely.		*Another future product could be video collections. Otherwise, all video is published freely.

			=Links=
			*[[Hong Kong STEAM Camp]]

2019-10-24T23:21:32Z

Prototyping Kit BOM

← Older revision		Revision as of 23:21, 24 October 2019
Line 24:		Line 24:
	*Tools - 20		*Tools - 20
	*Universal Power Supply Parts - 100		*Universal Power Supply Parts - 100

			=Evolution Notes=
			*Once the video instructionals for the STEAM Camp are perfected, then the Remote Participation option becomes much more attractive. Both on-site and remote people should be watching the instructional videos for the builds instead of listening to the instructor - the instructor is there only for clarification. Video person attends and works on inserting the clarifications into the videos for future events.
			*Another future product could be video collections. Otherwise, all video is published freely.

2019-10-24T23:16:14Z

October 2019

← Older revision		Revision as of 23:16, 24 October 2019
Line 1:		Line 1:
	~~=October 2019=~~
	*Revenue per person - 9 days, $1000
	*Kits for 9 days - $500-$600
	*30 person event plan

	=September 2019=		=September 2019=
	This is for initial STEAM Camps during the development phase of the STEAM Camps.		This is for initial STEAM Camps during the development phase of the STEAM Camps.

2019-10-24T23:14:36Z

← Older revision		Revision as of 23:14, 24 October 2019
Line 1:		Line 1:
			=October 2019=
			*Revenue per person - 9 days, $1000
			*Kits for 9 days - $500-$600
			*30 person event plan

			=September 2019=
	This is for initial STEAM Camps during the development phase of the STEAM Camps.		This is for initial STEAM Camps during the development phase of the STEAM Camps.

Line 14:		Line 20:

	=Prototyping Kit BOM=		=Prototyping Kit BOM=

	*Around 400 in materials for D3D Simple package + experiment; plus 100 in project materials for the 5 project days.		*Around 400 in materials for D3D Simple package + experiment; plus 100 in project materials for the 5 project days.
	*Printer parts - 200		*Printer parts - 200