Reference no: EM132562692

Problem 1. The ABC Corporation has been tracking its average weekly customer satisfaction rating on scale of 1 to 5. The data for the past 20 weeks are listed below. Please create a trend chart and comment on the company's customer satisfaction performance.

		Week	Average customer Satisfaction Rating
		1	3.5
		2	3.8
		3	4.2
		4	4
		5	2.8
		6	3.3
		7	3.7
		8	2.9
		9	2.5
		10	3.4
		11	3.6
		12	3.7
		13	4.2
		14	4.5
		15	3.9
		16	4.7
		17	4.8
		18	4.6
		19	4
		20	4.1

Problem 2. 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.

Problem 3. 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 trendline 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

Problem 4. Create a histogram for the units sold per period

Problem 5. 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.

Problem 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.