Parts Purchasing

Martin Company normally buys parts for each project during the design process in order to verify the Bill of Materials is completely correct, and that all of the parts price and delivery times are acceptable. When we have finished a project the production documentation including the Bill of Materials should be able to be used by any assembly house to build the design.

Following is a non-proprietary spreadsheet much like the ones we normally buy parts with.

Production Quote						Customer	MARTIN CO.		Rate Lookup Table Key				5

Production of Quantity of			------------>	15		Project #	1103		Delivery
									Time:
						Name	Xilinx Devel. Board

Item No.	Qty	Ref.	Mfg. Part Number	Manufacturer	Description	Price Each	Total Price	Qty On Hand	Qty Needed	Min Qty Order	Qty To Order	Qty Remain	Cost of This Build	Vendor + Ld tm	STATUS
1	13	C1 C2 C3 C4 C5 C6 C7 C8 C9 C10 C11 C12 C13	C320C104K5R5CA	KEMET	CAP MONO 50V .1uF	0.13	$1.69	0	195	0	195	0	$25.35	Newark	Ordered
2	2	C14 C15	TAC225K025P02 sub- K020	MALLORY	CAP TANT 25V 2.2uF	1.38	$2.76	0	30	0	30	0	$41.40	Newark	Ordered
3	1	DIS1	LB-402VD Sub LDS-A416RI	ROHM	DUAL 7 SEG DSPL 10mm	2.31	$2.31	0	15	0	15	0	$34.65	Digikey
4	2	DS1 DS3	LTL-4203	LITE ON	RED LED T1_3/4	0.17	$0.34	0	30	0	30	0	$5.10	Digikey
5	1	DS2	LTL-4233	LITE ON	GREEN LED T1_3/4	0.17	$0.17	0	15	0	15	0	$2.55	Digikey
6	2	H1 H2	71363-302	BERG	JUMPER SHUNT	0.13	$0.26	0	30	0	30	0	$3.90	Newark	Ordered
7	2	J1 J2	22-03-2091	MOLEX	9 PIN HEADER	1.00	$2.00	2	30	0	28	0	$28.00	On Hand
8	1	J3	H5R09RA29BS	T&B	DB9 PLUG	5.00	$5.00	17	15	0	0	2	$0.00	On Hand
9	2	JP9 JP10	69190-402	BERG	2 PIN JUMPER	0.50	$1.00	56	30	0	0	26	$0.00	On Hand
10	1	N1	4610X-101-103	BOURNS	R NETWORK 10K	0.31	$0.31	0	15	0	15	0	$4.65	Allied	Received
11	2	N2 N3	4116R-1-471	BOURNS	R NETWORK 470ohms	0.49	$0.98	0	30	0	30	0	$14.70	Mouser
11	2	R1 R2	RN55D-1001F	DALE	RES 1% 1/4W 1K	0.04	$0.08	30	30	0	0	0	$0.00	On Hand