PLOTS balloon kits - Kickstarter & Breadpig

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2								Units sold		Revenue per unit	Average paid (inc. shipping)			Net earned from Breadpig per kit
3	Breadpig Revenue to date (Apr 27, 2012)	$5,865.00						69		$85	93			73
4
5	Cost/revenue for 100 kits:	Price					Per-box cost	Quantity		Notes	Per kit
6	Balloons 3	$2,529.54						100
7	Swivels(#)	$112.20					$18.70	100		6 boxes of 50	3
8	Reels w/ String 1	$2,038.15						100		20.38 each	1
9	Steel rings	$57.00					$0.57	100			1
10	Carabiners	$62.00					$0.62	100			1
11	Cable ties	$101.00					$5.05	1,000		20 packs of 50	10
12	Gloves	394					$3.94	100			1
13	Rubber bands	$27.96					$9.32	1,140		3 packs of 380	10
14	Amplifier Assembly, Receiving, Shipping, Fees, Printing	$441.83								$17.47 Rough estimate based on 1/3 of what we paid for 350
15										Proposed new retail price	120
16	Total cost	$5,763.68					Cost per unit	$57.64		prop. cost/unit	$57.64
17	Earnings	$8,500.00					Earnings per unit	$85		prop. earning/unit	98
18	Profit	$2,736.32					Profit per unit	$27.36		prop. profit/unit	$40.36
19	Profit margin	32.19%								prop. profit margin	33.64%
20
21
22	100 kits with new balloon discount:	Price			quantity/box	# of boxes	Per-box cost	Quantity		Notes	Per kit	Overstock	overstock value
23	Balloons 3	$2,383.54						100
24	Swivels(#)	$112.20			50	6	$18.70	100		6 boxes of 50	3
25	Reels w/ String 1	$2,038.15						100			1
26	Steel rings	$57.00					$0.57	100			1
27	Carabiners	$62.00					$0.62	100			1
28	Cable ties	$101.00			50	20	$5.05	1,000		20 packs of 50	10
29	Gloves	394					$3.94	100			1
30	Rubber bands	$27.96			380	3	$9.32	1,140		3 packs of 380	10
31	Amplifier Assembly, Receiving, Shipping, Fees, Printing	$441.83								Rough estimate based on 1/3 of what we paid for 350
32										New retail price	95
33	Total cost	$5,617.68					Cost per unit	$56.18		prop. cost/unit	$56.18
34	Earnings	$9,500.00					Earnings per unit	$95		prop. earning/unit	95
35	Profit	$3,882.32					Profit per unit	$38.82		prop. profit/unit	$38.82
36	Profit margin	40.87%								prop. profit margin	40.87%
37
38	# of v1.5 kits	Retail Kit price
39	150	$95.00
40	Item for v1.5 kits	Price	tax	Shipping	quantity/box	# of boxes	Per-box cost	Quantity for kits	cost per item (w/ship)	Notes	Per kit	Overstock	overstock value	Links	supplier SKU
41	Balloons 3	$3,575.31			1	150		150			1	0
42	Swivels(270#)	$219.90		$0.00	50	10	$21.99	450	$0.44	free shipping @ $200 order. 450 cost $197 + $17 shipping... ordered extra	3	50	$21.99
43	Reels w/ String 1	$3,057.23			1	150	$20.38	150	$20.38		1	0	$0
44	O-rings	$37.83			60	3	$12.61	150	$0.21		1	30	$6.305	http://www.mcmaster.com/#epdm-o-rings/=iu1prc
45	Carabiners	$93.00			1	150	$0.62	150	$0.62		1	0	$0
46	Mini-carabiners	$88.75		$0.00	12	25	$3.55	300	$0.30		2	0	$0
47	Cable ties	$95.70			100	15	$6.38	1,500	$0.06		10	0	$0
48	Gloves	$307.32		30.85	12	13	$23.64	150	$2.17		1	6	$13.0065384615385	http://www.mcmaster.com/#leather-gloves/=iu1v0h
49	Rubber bands	$74.56			380	8	$9.32	3,000	$0.02		20	40	$0.981052631578947
50	Boxes with handles	$233.60	$25.20	$50.89	20	8	$29.20	150	$1.78	8 bundles of 20	1	10	$17.780625	http://www.uline.com/Product/Detail/S-650/Indestructo-Literature-Mailers/11-3-4-x-10-3-4-x-2-1-4-White-Literature-Mailers	S-13485
51	Box label stickers	$22.61			1000	1	$226.11	150	$0.23	1 order of 1000 (split up)	1	850	$192.1935
52	Uline ziploc bag	$21.00		$0.00	1000	1	$21.00	300	$0.02		2	700	$14.7	http://www.uline.com/Product/Detail/S-1302/Poly-Bags-Reclosable/4-x-6-4-Mil-Reclosable-Bags	S-1294
53	Amplifier Assembly, Receiving, Shipping, Fees, Printing	$662.74			1	150	$4.42	150	$4.42	Rough estimate based on what we paid for 350	1	0	$0
54	Balloon Kit instructions
55										Retail price	$95			http://publiclaboratory.org/wiki/balloon-mapping-kit-retail
56	Total cost	$8,596.49					Cost per unit	$57.31		prop. cost/unit	$57.31
57	Earnings	$14,250.00					Earnings per unit	$95		prop. earning/unit	$95
58	Profit	$5,653.51					Profit per unit	$37.69		prop. profit/unit	$37.69
59	Profit margin	39.67%								prop. profit margin	39.67%
60
61	overstock value	$266.96
62	profit w/o overstock value	41.55%
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