# Forecasting of Product Returns and Warranty Costs

L

#### lord85

Hi Everyone,

We are a pump products manufacturer and we are planning to release new products to the market. I will put some targets for product' performance. I want to forecast possible product returns and warranty costs after some months. Are there anybody who can help to calculate this or suggest a formula? Which forecast models (weibull, waterfall, weighted average etc.) do you use?

#### Bev D

##### Heretical Statistician
Staff member
Super Moderator
straightforward return rates are best. Weibull can put some more statistical precision to the estimate. but the first place to start is: what data do you have so far? have done stress testing? do you have initial life data? The formula you use is dependent on the data you have

L

#### lord85

Dear Bev D,

We are at the start of the project and planning to release the product at the beginning of the 2016. We have done some calculations and tests about the product life but the real life doesn't match generally the calculations because of the production inputs. The base formula for product returns will be [(total failure quantity after sale / total sold product or total produced product) * 1000000] (ppm) and be calculated for every month. Also it should take into account previous produced products for 6 months. I mean the performance review will be for example from 6th month of the year 2015 to 6th month of the year 2016 for whole year of 2016. But the forecast should say to me the possible rates for next period. The system is alive and changeable.

#### Steve Prevette

##### Deming Disciple
Staff member
Super Moderator
Yes, some form of reliability analysis ought to be able to predict failure rates from results of your intial product testing data and/or specifications , in conjunction with project sales figures.

Then, once you start gathering actual returns and warranty costs, some form of statistical analysis (such as SPC) is in order to see if the returns and warranty costs (after some form of start up ramp) reach stability and actual predicatability.

Yes, I'd be willing to by PM assist, but yes, would need access to your existing data.

#### charanjit singh

##### Involved In Discussions
I have a few questions for you on this subject:

1. Is this pump a totally a new design?
2. Is it a modified/improved version of some of your existing products? Have
you at least theoretically evaluated the effect of the changes on the
performance/useful-life of the modified model?
3. If it is modified version, do you have performance/field returns/warranty
failure data of the old version?.
4. Is this pump meant for a new application? If so, have you evaluated some
prototype models under the anticipated application/environment? How
does the performance of prototypes compare with the design
specifications?
5. What is your field-experience (customer complaints, warranty
replacements etc.) with various products that you manufacture
and supply to market?

There could be some more questions to consider, but for the present these. I think these are of primary consideration.

Hope this helps.

S Forecasting and Material Planning - Are formal procedures required? Document Control Systems, Procedures, Forms and Templates 3
O Sales Forecasting by Using Time Series Decomposition [Minitab] Using Minitab Software 4
R Forecasting as an improvement project Preventive Action and Continuous Improvement 5
New Product Launch - Safe Launch Customer and Company Specific Requirements 1
How do I know if my product is required be RoHS certified? REACH and RoHS Conversations 6
Control Plan (Product/Process specification/ Tolerance) acceptance FMEA and Control Plans 27
Technical Data Package vs Digital Product Definition APQP and PPAP 0
ISO 11135:2014, B.1.4, BI resistance x product bioburden ISO 13485:2016 - Medical Device Quality Management Systems 6
How to interpret '8.3 Control of nonconforming product' for SaMD device while implementing ISO 13485 & MDSAP ISO 13485:2016 - Medical Device Quality Management Systems 4
Product Recall - medical devices in the hospital warehouse Canada Medical Device Regulations 2
Software bug fixes after shipping a product EU Medical Device Regulations 3
How to measure severity if my product is designed for emergency use and failure would result in death? ISO 14971 - Medical Device Risk Management 9
IATF16949 7.5.3.2.1 Record Retention - Our Product or Customer Product? Elsmar Cove Forum Suggestions, Complaints, Problems and Bug Reports 1
Operational planning and product and service provision when things happen so fast ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
Letter to file for Product Certification CE Marking (Conformité Européene) / CB Scheme 0
Scope of ISO 9001 clause 10.2 in the product life cycle ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
Can a Contract Manufacturer "release" product on behalf of client to the market? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 4
Formal Q Self Assessment - Problem with assigning Product and Process Customer and Company Specific Requirements 1
California Cleaning Product Right to Know Act - Product Label advice needed Miscellaneous Environmental Standards and EMS Related Discussions 1
Definition of "worldwide" in view of IATF 16949 and Product conformity IATF 16949 - Automotive Quality Systems Standard 3
PCD remains valid for new product ISO 13485:2016 - Medical Device Quality Management Systems 11
MDR EU Distributor for our CE Mark product in the for Netherlands EU Medical Device Regulations 6
How do you determine if hipot is necessary for a cable product? Manufacturing and Related Processes 8
Does Manufacture can submit CE mark application under MDD with NB for his New product after May 2020? EU Medical Device Regulations 3
CE Mark Requirements on Kits (off the shelf product requirements met) CE Marking (Conformité Européene) / CB Scheme 2
Authorised Representative details on product label? EU Medical Device Regulations 1
Importing a general wellness low risk product Other US Medical Device Regulations 3
Process, component or full product re-qualification: leaded to unleaded solder Qualification and Validation (including 21 CFR Part 11) 8
Brazil - Product Code (and brand) Change Other Medical Device Regulations World-Wide 0
Audit non-compliance API Q1 - Use of External Documents 4.4.4 in Product Realization Oil and Gas Industry Standards and Regulations 4
A clinical performance evaluation study with an IVD product as Investagional Use product - Clinical Monitor requirements 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 4
Remote product audits in Coivd-19 - IATF 16949 9.2.2.4 IATF 16949 - Automotive Quality Systems Standard 3
EU MDR Perscription product guidance EU Medical Device Regulations 1
Product audit sampling plans IATF 16949 - Automotive Quality Systems Standard 3
Interesting Discussion Requirements for selling a Food product in USA Food Safety - ISO 22000, HACCP (21 CFR 120) 0
How to list multi-product sample pack in GUDID 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
What is our product classification? (Does Unclassified classification still exists) Other US Medical Device Regulations 14
Definition of Done - New Product Phase to the sustaining phase Manufacturing and Related Processes 3
Product Safety Responsibility - Job shop such as a machine shop AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 10
Quality checks of product QR codes FMEA and Control Plans 2
ISO 13485 - Clause 8.3.3 appropriate actions in response to nonconforming product ISO 13485:2016 - Medical Device Quality Management Systems 2
Handling Unpacked (Additive Chemical) Product For Automotive Applications IATF 16949 - Automotive Quality Systems Standard 3
Risk Assessment Checklist for Non product Software IEC 62304 - Medical Device Software Life Cycle Processes 1
Modification of a product on the market EU Medical Device Regulations 2
CE Marked product considered a Drug in India Other Medical Device Regulations World-Wide 0
Differences in post market safety reporting for Combination Product Applicants Medical Device and FDA Regulations and Standards News 1
Product (Device) Life cycle - Product Life AFTER the Post Market Phase Medical Device and FDA Regulations and Standards News 3
Physical Address on Product Labels (EU MDR perspective) EU Medical Device Regulations 2
How do you record your Nonconforming product? Batch production of staged processes Nonconformance and Corrective Action 2
Must product name be listed the same name in FURLS, UDI, GUDID and Company Website? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1