Production/Operations Management and Business Policy advice for Excelsior

[bmills072200]

Okay guys,

I am in a temporary state of paralysis with this Op Management class at CSU-Pueblo. I am having a hard time with motivation and setting aside time to work on this class.

So, I am committed to getting everything done in the next 2 weeks, but I need help because Dr. Billington is out of the country. I have already completed the first 6 AEs and I am done with everything on the first exam except for questions 7 and 8. I am not great with Excel and I am not sure if I am doing this correctly.

Question 7 reads:

7. Construct the appropriate control chart for the observations listed below, using 3 sigma limits.
Product number 1 2 3 4 5 6 7 8 9 10 11
Number of defects 7 6 3 5 6 5 4 1 3 2 3
a. (10 points) Determine the upper and lower control limits.
b. (10 points) Plot the control limits and the observations on the chart provided. Proper scaling, labeling and neatness counts.
c. (5 pts) Discuss the chart you have plotted. What conclusions and recommendations do you make from the chart and the data?

I have attached the Excel OM page that I made for this question. Can you guys tell me if I am on the correct track? From my graph I have determined:

A The UCL is 10.15871 and the LCL is 0

B: I assume that I can you the chart that is created on the excel sheet for my answer to the question.

C: Not really sure what he is looking for here, but I would probably say something like: No one product is outside of the control limits, but product numbers 1, 2, and 5 with 7, 6, and 6 defects respectively require attention in order to improve operations.

Please give me some feedback…

Thanks in advance