Development of a quality control application
An Excel development that provides the following features:
- Enter the number of defective parts by type of defect for each Work Order (OF). Defects are automatically preloaded by selecting a finished product.
- Visualize the results on a Pareto chart and record the OF summary in a database.
- Ability to create an action plan and assign it to a failure cause.
- Generate graphs showing the effect of closed actions on the occurrence frequency of defects.
- Generate Pareto charts summarizing by item and by type of defect.
- Generate a summary report of the TOP 5 defects (monthly, quarterly, and annually).