SuperBOM

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Part	Source	Link	Description	Quantity	Price/Part	Cost/Module	Cost/Run	#Modules worth of parts	Inv Post Production	Inventory	Cost Needed Parts	Percent Module Cost
2	potentiometer	JLCPCB			1	$1.00	$1.00	$10.00	12	2	12	$0.00	6.10%
3	jacks	Thonk			2	$1.00	$2.00	$20.00	5	-10	10	$10.00	12.20%
4	buttons	PCBWay			3	$1.00	$3.00	$30.00	16	19	49	$0.00	18.29%
5	knobs	Aliexpress			4	$1.00	$4.00	$40.00	3	-28	12	$28.00	24.39%
6	LEDs	Thonk			7	$0.10	$0.70	$7.00	4	-41	29	$4.10	4.27%
7	widget	Mouser			5	$0.50	$2.50	$25.00	14	21	71	$0.00	15.24%
8	test1	Digikey			4	$0.30	$1.20	$12.00	5	-20	20	$6.00	7.32%
9	dac	Digikey			2	$1.00	$2.00	$20.00	0	-20		$20.00	12.20%
10	Production Quantity	Hours/Module	Hour Price	Hours/Run	Labor/Module	Labor+Cost/Module	Cost/Module	Cost/Run	Labor/Run	Cost+Labor/Run
11	10	1	$20	10	$20	$36	$16.40	$164.00	$200	$364
12	MSRP	My Revenue%	Revenue/Module	Revenue/Run	Profit-L/Module	Profit-L/Run	Profit+L/Module	Profit+L/Run	Profit-L/Hour	Profit-L Margin	Profit+L Margin
13	$100	80.00%	$80	$800	$64	$636	$27	$272	$64	0.795	0.34
14	Unique Parts	Parts/Module	Parts/Run	Inventory Capacity	Quantity Needed	Bottleneck Part	Quantity Needed	Abundant Part
15	8	28	280	0	20	dac	-19	buttons
16	Totals	Aliexpress	Suppliers	Thonk	Sales Tax Rate	Digikey		JLCPCB		PCBWay		Other
17	$68.10	$28.00	Part Cost	$14.10	7%	$26.00		$0.00		$0.00		$0.00
18	$37.00	$15.00	Shipping+Fees	$15.00	Sales Tax Cost	$7.00		$8.00		$8.00		$0.00
19	$4.71	5%	Tariff %	5%	$4.43	10%		2%		5%		5%
20	$125.81	$44.40	Total Price	$29.81		$35.60		$8.00		$8.00		$0.00
21	Quantity	Shopping List	Quantity	Shopping List	Quantity	Shopping List	Quantity	Shopping List	Quantity	Shopping List	Quantity	Shopping List
22	28	knobs	10	jacks	20	test1	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
23			41	LEDs	20	dac
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