Residential BOM PL Sheet Format.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Date
2	Dealer Name
3	System Size					KW
4	Customer Name
5	Address
6	Location
7	GB Kit Price (Incl. GST)	₹ 0.00				Rs
8	End Customer final (Incl. GST)	₹ 0.00				Rs
9	Dealer Invoice Amount Total	₹0.00				Rs
10	Sr. No	Items	Make	Unit	Qty	Unit Rate	Price	GST (%)	GST	Total
11	1	No of Panels	GB 590 Wp	Nos			₹ 0.00	5%	₹ 0.00	₹ 0.00
12	2	Inverter	GB (4 KW)	Nos			₹ 0.00	5%	₹ 0.00	₹ 0.00
13	3	GI 60*40mm	Hindustan / Star	Nos			₹ 0.00	18%	₹ 0.00	₹ 0.00
14	4	GI 40*40mm	Hindustan / Star	Nos			₹ 0.00	18%	₹ 0.00	₹ 0.00
15	5	DC 4mm	Anand International / Polycab / Equivalent	Meter			₹ 0.00	18%	₹ 0.00	₹ 0.00
16	6	AC 2C2.5mm (Single Phase) / 4C2.5mm(Three Phase)	Polycab/ equivalent	Meter			₹ 0.00	18%	₹ 0.00	₹ 0.00
17	7	Earthing 2.5mm	Johnson / Kranberry / Equivalent	Meter			₹ 0.00	18%	₹ 0.00	₹ 0.00
18	8	LA Earthing 16mm	Johnson / Kranberry / Equivalent	Meter			₹ 0.00	18%	₹ 0.00	₹ 0.00
19	9	ACDB-DCDB 1-4KW (Single Phase) / 6-10KW (Three Phase)	Elmex and Schalten / Equivalent	Nos			₹ 0.00	18%	₹ 0.00	₹ 0.00
20	10	Earthing Set	Pragati / Rudra	Lot			₹ 0.00	18%	₹ 0.00	₹ 0.00
21	11	PVC Pipe (25 MM)	Crown/Equivalent	Nos			₹ 0.00	18%	₹ 0.00	₹ 0.00
22	12	Elbow,	Crown/Equivalent	Nos			₹ 0.00	18%	₹ 0.00	₹ 0.00
23	13	Tee	Crown/Equivalent	Nos			₹ 0.00	18%	₹ 0.00	₹ 0.00
24	14	SADDLE	Crown/Equivalent	Lot			₹ 0.00	18%	₹ 0.00	₹ 0.00
25	15	Cable Lugs(Set)	Local Vendor	Lot			₹ 0.00	18%	₹ 0.00	₹ 0.00
26	16	MC4 connectors	Ningbo / equivalent	Nos			₹ 0.00	18%	₹ 0.00	₹ 0.00
27	17	Cable Tie	Local Vendor	Lot			₹ 0.00	18%	₹ 0.00	₹ 0.00
28	18	J BOLT	Local Vendor	Nos			₹ 0.00	18%	₹ 0.00	₹ 0.00
29	20	Base Plate/engal	Local Vendor	Nos			₹ 0.00	18%	₹ 0.00	₹ 0.00
30	21	Zink Sprey	Local Vendor	Lot			₹ 0.00	18%	₹ 0.00	₹ 0.00
31	22	Anchor Fastner	Local Vendor	Nos			₹ 0.00	18%	₹ 0.00	₹ 0.00
32	23	Transportation (incl loading/unloading if applicable)		Transportation			₹ 0.00	18%	₹ 0.00	₹ 0.00
33	24
34	25
35	26
36									Total	₹ 0.00
37									GB Profit	₹ 0.00
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