SMT Reel and MOQ Buy Quantity Calculator
Component prices look low per piece until you are forced to buy a full reel for a small job. This calculator rounds a requirement to the MOQ and order multiple and shows how much excess that creates, what it is worth and what it costs to carry.
Your numbers
Net requirement from MRP for the buy period.
Allowance for pick-and-place loss and setup.
Standard pack: a full reel for most SMT parts.
Use the price break that applies to the rounded quantity.
Cost of capital, storage, obsolescence and handling.
Your results
Assumes the excess is eventually consumed at the annual usage rate. If the part is at end of life or has limited shelf life, treat the excess as a write-off risk instead.
Order quantity and excess versus requirement
Sweeps Quantity required from 100 to 12000, holding your other inputs fixed.
Check lot sizing rules against reality
Optional: review how MOQ and multiples are set in your ERP item data.
Optional. The tool and every export work without this. No spam.
How to use the calculator
Enter the net requirement from MRP, an overage for placement loss and the supplier's minimum order quantity and order multiple. For SMT parts the multiple is usually the reel quantity. Add the unit price at the rounded quantity, annual usage and your carrying cost rate. The order quantity is the larger of the MOQ and the requirement rounded up to a whole multiple. The excess pieces and their value show what you are buying beyond the job. The chart sweeps the requirement to show the sawtooth pattern of excess as you cross reel boundaries.
The formulas
Requirement with overage equals required quantity times one plus the overage percent. Order quantity equals the maximum of the MOQ and the ceiling of requirement over multiple times the multiple. Excess equals order quantity minus requirement. Months to consume equals excess divided by monthly usage. Carrying cost equals the value of the excess times the annual carry rate times the months held divided by twelve. The carry rate should reflect capital, storage, handling and the risk of obsolescence.
Reading the result
If the months to consume are a few, the excess is cheap inventory that will be used. If it is measured in years, compare against the savings from the reel price. A cut tape or partial reel price from a distributor can be better for low usage parts even though the unit price is higher. For low-cost passives the excess is negligible, for expensive devices it can dominate. Check the shelf life and moisture limits before holding long.
- Compare reel versus cut tape pricing
- Ask the supplier for a mixed reel or a split pack
- Consolidate demand across products to use the excess
- Keep the excess where MRP can see it
Common mistakes
Common errors are using the unit price from the wrong quantity break, leaving the overage at zero for parts that suffer placement loss, and ignoring that the excess may already be sitting in stock from a previous buy. Also remember that tape width and reel size affect feeder setup, so a smaller reel is not always a drop-in.
Frequently Asked Questions
Why does the order quantity jump at certain requirements?
Because you can only buy whole multiples. Once the requirement exceeds one reel, you need two, so the excess resets near zero and grows again. The chart on this page shows that sawtooth.
What carrying cost percentage should I use?
Use your finance team's figure if you have one. Many companies use a range of about 15 to 30 percent per year, including capital cost, storage, handling and obsolescence risk.
Does this handle price breaks?
Not automatically. Enter the unit price that applies at the rounded order quantity. If the next break is close, change the requirement and compare order value.
Should I always avoid excess?
No. Excess on cheap, long-life parts is often the lowest total cost, since it avoids small-order fees and shortage risk. The key is to know the number and make the choice on purpose.
If your ERP lot sizing rules already apply MOQ and multiples, Netray can help check whether they match what suppliers actually ship, and review the excess they create.
Related Tools
Electronic Component Distributor Quote Comparison Worksheet
Line up quotes from up to three distributors by part, find the lowest price, price spread and total spend, and export to Excel.
Electronics ManufacturingLast Time Buy Quantity Worksheet
Size last time buy quantities for end-of-life parts from annual demand, months of cover, growth and buffer. Editable rows, exports to Excel.
Electronics ManufacturingElectronic Component RFQ Request Template
A fill-in request for quotation to send to franchised distributors and manufacturers, with traceability and compliance requirements built in.
Supply Chain & InventorySupplier MOQ vs Demand Cost Calculator
Weigh a price break or minimum order quantity against the extra inventory it forces you to hold, and see the net annual benefit.
More Supply Chain & Inventory tools
See all- PCBA RFQ Request for Quote Template
- Component Lead Time Risk Worksheet
- Approved Vendor List (AVL) Template
- Broker vs Franchise Component Buy Cost Calculator
- Reel MOQ Overbuy and Carrying Cost Calculator
- Component Shortage Line-Down and Expedite Cost Calculator
- Electronic Component Sourcing Resilience Assessment
- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator