Advanced BLE-CELL Blocks and Budget v2

	A	B	C	D	G	H	I	J	L	M	N	O	P	Q	R	S	T	U	W	X
1	Block	Component Type/Name	MPN	QTY	1K Price	1K Subtotal	Low quantity price	10 pcs cost		15%		40%		5%	10%				200
2	Cellular	BG95	BG95	1	$8.0000	$8.0000	$15.0000	$15.0000
3	Cellular	Level translator	TXS0108ERG	1	$0.6006	$0.6006	$1.2660	$1.2660	1K Chip only	Passives	Total	Assembly cost (int'l)	Assembled Subtotal	Overhead	Returns	COGS	Selling price	Margin	Parts/boards	Assembly
4	Cellular	SIM Card Holder	SIM8051-6-0-14-01-A	1	$0.5130	$0.5130	$1.0900	$1.0900	$23.8075	$3.57	$27.38	$3.80	$31.18	$1.56	$3.12	$35.86	$99.00	63.78%	$5,475.73	$760.00
5	Cellular	uFL Connectors	A-1JB	2	$0.3633	$0.7266	$0.8130	$1.6260
6	Cellular	USB for Modem	10103594-0001LF	1	$0.3586	$0.3586	$0.7400	$0.7400	10 pcs Chip only	Passives	Total	Assembly cost (domestic)	Assembled Subtotal	Overhead	Returns	COGS	Selling price	Margin
7	Bluetooth	nRF52840	NRF52840-QIAA-R	1	$3.2890	$3.2890	$5.5660	$5.5660	$43.9410	$6.59	$50.53	$115.00	$165.53	$8.28	$16.55	$190.36	$299.00	36.33%
8	Bluetooth	SD Card Holder	1041681620	1	$1.6198	$1.6198	$2.9490	$2.9490
9	Bluetooth	2.4GHz Antenna	ACAG0201-2450-T	1	$0.2800	$0.2800	$0.5780	$0.5780
10	USB	USB connector	USB4105-GF-A	1	$0.9877	$0.9877	$1.5660	$1.5660
11	Power	3V8 Regulator Controller	BQ25895RTWT	1	$1.5770	$1.5770	$3.3720	$3.3720
12	Power	3V8 Regulator Inductor	XAL5030-222MEB	1	$0.8500	$0.8500	$1.7500	$1.7500
13	Power	3V3 Regulator Controller	TPS62821DLCR	1	$0.5054	$0.5054	$1.1210	$1.1210
14	Power	3V3 Regulator Inductor	ASMPM-0806-R47M-T	1	$0.1411	$0.1411	$0.3660	$0.3660
15	Daughtercard	Connector	DF23C-50DS-0.5V(51)	1	$0.7540	$0.7540	$1.1000	$1.1000
16	PCB	4 layer PCB from JLC	-	1	$0.3658	$0.3658	$0.7500	$0.7500
17	Raspberry Pi	EEPROM	CAT24C32WI-GT3	1	$0.1321	$0.1321	$0.1880	$0.1880
18	Raspberry Pi	Power FET	DMG2305UX-13	1	$0.0483	$0.0483	$0.3050	$0.3050
19	Raspberry Pi	Power BJTs	DMMT5401-7-F	1	$0.0924	$0.0924	$0.3080	$0.3080
20	Raspberry Pi	40 pin female connector	2222	1	$1.5000	$1.5000	$1.5000	$1.5000
21	LEDs	0402 LEDs		7	$0.0800	$0.5600	$0.1600	$1.1200
22	Mechanical	Threaded screw mounts	4881	4	$0.1998	$0.7992	$0.4200	$1.6800
23	Various	ESD diodes	DF5A6.8CJE,LM	2	$0.0536	$0.1071		$0.0000
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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