Online spare parts calculation
Online Spare Parts Calculation
Calculating the required quantity of spare parts is not a simple task; it requires fairly complex mathematics and optimization algorithms. If a failure occurs and the necessary spare part is not at hand, production or business stops, leading to losses. If there are too many spare parts and they are never needed, they just sit as dead stock, incurring storage costs, taking up warehouse space, and tying up money that could have been spent on growing the business. Therefore, it is very important to correctly estimate the required number of spare parts. Our online calculator will help you do just that – quickly calculate the required number of spare parts online.
The calculator is based on Standart “Reliability in engineering. Spare parts, tools and accessories. Estimation and calculation of stocks.”
How to use it?
1. Decide for which components of your system you want to determine the optimal number of spare parts. For example, you want to know how many light bulbs you need to keep in stock for lighting a basement warehouse.
2. Look at what data you have about your light bulbs. You might have MTBF (mean time between failures) or service life. This information can be found in technical specifications, datasheets, reliability handbooks, or on the manufacturer’s website. You can also use similar products as references.
3. If you calculate using service life, also enter the utilization factor. For example, if your warehouse is visited 12 hours a day, 365 days a year, the utilization factor is 0.5.
4. Delivery and replacement time – the time it takes for your purchasing department to order new bulbs, for them to be delivered, and for installation. The longer this time, the more spare parts you need to keep on hand.
5. Required quantity – if your warehouse uses 10 bulbs and all 10 are needed for normal operation, enter 10. If you have 3 adjacent warehouses and all need to be lit, enter 30.
6. Spare parts availability factor – the probability that when a failure occurs, the necessary spare parts will be on hand and available. The higher this factor, the more spares are needed and the more expensive the spares kit.
7. Part cost – self‑explanatory.
8. Downtime cost – how much your business and production lose while the warehouse is dark, waiting for new bulbs that, unfortunately, were not in your spares stock.
Online Spare Parts Calculation
I think you have quickly figured it out and succeeded. The spare parts calculation is correct, but for ideal operating conditions. As you well understand, in reality the failure rate of equipment depends heavily on whether your equipment operates in a clean, air‑conditioned room, or outdoors at +40 °C, or on board a helicopter. Consequently, the required number of spare parts can differ by orders of magnitude. Our professional version takes all this into account – a powerful tool for your business and your enterprise.
What our tool for calculating the optimal number of spare parts can do:
1. Works offline, without white‑lists, without any network access at all.
2. No installation required on your computer – only Excel is needed. Works on Windows and MacOS.
3. Quickly calculates the optimal number of spare parts even when your system consists of hundreds or thousands of unique items.
4. Not only calculates the optimal number of spare parts but also estimates their total weight, cost, and volume (provided you specify how much one item weighs and costs).
5. Performs optimization of the spare parts set according to availability, cost, weight, and volume criteria.
6. Calculates the overall mean time between failures (MTBF) of your entire system, the probability of failure‑free operation, and downtime costs.
7. Takes into account the temperature at which your equipment operates.
8. Accounts for operating conditions (indoor, outdoor, ground mobile, marine, aviation, etc.).
9. Considers the quality class of your equipment (commercial, industrial, military).
10. Intuitive, clear, user‑friendly interface.
11. Most importantly – the tool answers the question: should you buy spare parts at all or not? If production losses during downtime would be much greater than the cost of purchasing spare parts, then of course you should. But there are different scenarios…
The worst thing you can do is to plan spare parts “by guesswork” or using fortune-telling on coffee grounds. We have seen this picture many times at some companies during our reliability training sessions – estimating spare parts quantities was very confusing. One recent example: expensive sensors (costing more than 2.000 USD) required for a production process. The company needed 100 such sensors, but they bought 117. When asked why 117 (17% more), no one could answer for a long time. Eventually someone remembered that they had discussed it with the purchasing department and decided that 17% was a nice number – without any further justification. Those sensors had an MTBF of 30.000 hours and a delivery time of about a month. You can use the online calculator yourself to assess whether the spares calculation was correct and how much money the enterprise wasted.
Why do you need our product?
1. You will save significant money by not buying unnecessary spare parts. They will not sit as dead stock taking up space. You can spend the money much more wisely, e.g., on enterprise development.
2. You will save significant money by avoiding production downtime due to equipment failures and the lack of necessary spares in your warehouse.
3. You will save at least 50 hours per month that would otherwise be spent on guesswork and trying to justify spares quantities. You will immediately have a well‑reasoned answer obtained in accordance with Standart methodology and taking into account the real operating conditions of your equipment.
Our spare parts calculation tool will pay for itself within the first week of use at your company.
Our powerful tool is already used by our customers. Let them speak:
Buy our spare parts calculation tool and forget about your spare parts calculation problems!
Final price – no hidden fees or commissions: 490 USD
Our advantages:
1. No subscriptions or license renewals. You pay only once.
2. Unlimited access – both in time and number of users.
3. Possibility to integrate the product into your internal systems.
4. The product works accurately and reliably on any computer without installation or network access.
5. The product does not collect analytics, does not study your data, and does not send it anywhere.
What you get after purchase:
1. English Windows version – Excel macro for spares calculations.
2. English MacOS version – Excel macro for spares calculations.
3. English technical support for product usage questions for one year after purchase via email and Telegram.
4. Access to updates and new product features.
5. Clear English user manual.
Information about the developer:
Alexey M. Glazachev. Graduated from Moscow Aviation Institute (MAI), Aerospace Faculty. Since 2008, he has been working in the field of reliability and failure management. Author and instructor of courses on technical system reliability.
Quality Progress, November 2020
Pipeline equipment and hardware, January 2023
Presentations at industry conferences:
1. International Forum “Safety of Automotive Electronic Systems: Russian Experience and Global Trends”: https://forum.ekvarta.ru/forumtwo#reports
2. Conference “Embedded Real‑Time Systems”: https://kpda.ru/conf-2025/#days2
Selected experience:
1. Reliability, spare parts, and FMECA calculations for an anechoic test chamber for a spacecraft for a European customer. 2019.
2. Reliability and spare parts calculations for the safety system of the Balakovo Nuclear Power Plant (Saratov). Common‑cause failures and human error probability were taken into account. 2022.
3. Reliability, spare parts calculations for the emergency warning system for the Xudapu Nuclear Power Plant (China). 2022.
4. Reliability, spare parts and FMECA calculations for a wheeled security and perimeter patrol robot. 2019.
5. Remote reliability training for Gazprom specialists (Saint Petersburg). 2023.
6. Live training for Epiroc specialists in Astana, Kazakhstan. Covered reliability calculations, FMEA, RCM. 2022.
7. Live training for ERG, Kazchrome, Kazakhstan Aluminum, and Ekibastuz GRES specialists (Almaty, Kazakhstan). Letter of appreciation. 2021.
