Add prices to BOM

While going through the requirements before submitting, I got to know that I must include prices and the total cost in the BOM too. So, my BOM already had the exact quantity required for a single PCB. But as almost all parts were SMD, and some were even QFNs or smaller, I needed some spares. Because I don’t really have a good history with QFNs and extremely tiny packages. So, I made another column for Quantity including spares. I added 1-4 spares for 0805 LEDs, resistors, inductors and capacitors based on how many were used. For example, I was using 39 100nf caps, so I added 4 spares to get 43 while only 1 2nf cap was being used so it had 1 spare only. I had the headers with me, so I set their quantity to 0. I did the same for the CS43L22. The two crystals are a bit harder and they had 2 spares each. I listed 6 spares for the QFN as somehow, QFNs just get blown away, or burnt out or misaligned most of the time. I could of course use assembly from the Fab house, but that would end up being more expensive and I don’t gain any soldering skills. Then for the two STM32s, I only had 1 spare each as LQFP packages are much better than QFNs. The ETHERNET connector didn’t need spares at all. It is such a big package, that too through hole, so, that’s quite easy. I was also about to keep no spare for the B2B-XH-A(LF)(SN), but I remembered how easily it’s plastic melts if it accidentally gets touched by a soldering iron. Accidents happen! The TBC was supposed to receive the power, and it is also relatively easy to solder. But as it is such a critical part, and the whole board relies on it, I added a spare for it too. The ESD diodes just needed 2 spares only. They are neither too small, or too large. Then while writing this out, I suddenly remembered that I also had to include a power supply. I had already decided on the LRS-100-12. But Digikey didn’t have it, and I was using Digikey to source all parts, so I had to look for a replacement. I could go with the RS-100-12, which is the older generation of the LRS-100-12, but it is less efficient and bulkier. So, I used Digikey’s part browsing tools, and decided to use the PMT-12V100W2BA which seems like a drop-in replacement for the LRS-100-12, looking at it’s specs. Anyways, after that, my BOM was finally done! Now the requirements also says that I must also have firmware in the project, but as this was meant to be a generic dev board that can be used for anything, I didn’t think it was right for this to have one. For some components, digikey had quantity discounts, and buying at that quantity was cheaper than the quantity I needed, so I added in the cart that way, so the overall price is reduced. Also, as the total amount now exceeds ₹7000 (around $73.75), shipping is free! The BOM now says $220.81. I went to the JLCPCB to get a quote, and noticed that on the JLCONE desktop app, it’s cost around $2 less. Respecting the Code of Conduct, I downloaded JLCONE. Then I checked out the cost by a reputed Indian manufacturer, Lion Circuits, and the price was $29.01. JLCPCB is known to be one of the cheapest manufacturers, but with shipping and other hidden cost, it was turning out to be slightly more expensive. Shipping was free. So, the total cost now, is $249.82.