Quality Management Tools

This is mostly just creating charts in excel and answering some question based on the data in the charts. chats can be basic. not complicated. See attachment for better view of the questions. https://www.moresteam.com/toolbox/value-added-flow-chart.cfm https://www.moresteam.com/toolbox/trend-chart.cfm https://www.moresteam.com/toolbox/pareto-chart-manufacturing.cfm https://www.moresteam.com/toolbox/pareto-chart-service.cfm https://www.moresteam.com/toolbox/histogram.cfm https://www.moresteam.com/toolbox/fishbone-diagram.cfm 1. An IT manager has classified Helpdesk problems into 5 categories A, B, C, D and E. Reviewing recent helpdesk calls produced the following data A, B, B, B, A, C, E, E, C, D, A, A, B, D, B, B, C, C, B, B, E, B, B, B, C, B, C. Create a Pareto chart to identify the top priority problem for the helpdesk staff. 2. The Best Delivery Corporation has collected the following set of data on Dollars spent on advertisement and the number of units sold in the same period. Create a scatter plot. Indicate if there is any correlation. If so add a trend line and get the equation of the line. Is a linear trend line a good fit? AD in $1000 Sales in units 10 280 15 250 5 220 35 400 20 380 25 360 30 320 40 450 50 500 55 700 3. Create a histogram for the units sold per period 4. You are the marketing manager and want to find out the root causes of drop in sale. Create a fishbone diagram to identify the possible causes. Apply your general knowledge to populate the fishbone. 5. A call center manager has been collecting call data. The following table shows the number of calls received. Please create a trend chart and comment on the call center workload. 6. Please create a detailed process map with all tasks, decision points and loopbacks for a function that you are responsible for or familiar with. Then use the approach illustrated in, Value-added Flow Charting, to analyze its cycle-time. https://www.moresteam.com/toolbox/value-added-flow-chart.cfm