Assignment:
In a service company, employees are complaining about the limitations of an internally developed Excel-based program used in the Production Part Approval Process.
The Software Product is supposed to provides a statistical summary of the part characteristics to verify production readiness. A Six Sigma team was formed to identify causes of the complaints. The team interviewed various users for input. The team came up with these complaints after several brainstorming sessions:
1. Difficult to navigate
2. No standardized summary reports
3. Limited graphical summary reports
4. Cannot analyze multiple characteristics
5. Difficult to change part specifications
6. Cannot handle blank cells within data range
7. Few user friendly features
8. Difficult to import/export data
9. No formula protection
10. No outlier analysis
11. Takes too long to setup print feature
12. Data Files too big (programming in every file)
13. Too much manual input
14. No customized features to perform analysis
15. No customized naming of files
What is the next step for the team to do? what tool(s) that should be used at this stage? Apply your suggested tool(s) on the previous data and comment on how this tool(s) will help identifying the problem.