Instruction Complete this assignment in Word or Excel

Subject:BusinessPrice:14.89 Bought36

Share With

 

Instruction

Complete this assignment in Word or Excel. Upload into the Assignment 2 Module in Brightspace for grading.  Assignments need to be submitted on or before the due date specified by the instructor. Consult the course calendar for assignment due dates.  This assignment covers the content learned in Lesson 5.

 

1. Pareto Chart (5 marks)

A large number of successful entrepreneurs across Canada and the United States with companies that experienced 150% growth on average for each of the first five years of operation were polled. The entrepreneurs were asked which one single attribute they felt had the greatest impact on their success. The chart below is a record of their responses.

 

	Success Factor Number of Occurrences Experience 18 Education 22 IQ Score 25 EQ Score 38 Presentation Skills 41 Creativity 45 Leadership 50

 

 

 

 

 

 

 

 

 

1. Prepare a Pareto analysis of the data collected from the entrepreneurs. (3 marks)

B) What does this analysis reveal about the responses received? (2 marks)

 

Hint: Here is a site you may find helpful in creating a Pareto Chart:

 http://asq.org/learn-about-quality/cause-analysis-tools/overview/pareto.html

 

2.  Process Control (20 marks)

     A new coin machine printing nickels is being tested by the Mint. Ten samples, with each using 10 nickles, are weighed. Each nickle should weigh 5 g and each sample should weigh 50g. The data collected is shown in the chart below:

 

	Sample Sample Mean (g) Range (g) 1 49.998 0.017 2 50.001 0.011 3 50.025 0.025 4 50.121 0.005 5 50.012 0.001 6 49.953 0.004 7 49.999 0.007 8 50.002 0.022 9 50.007 0.001 10 49.099 0.014

 

 

 

 

 

 

 

 

 

 

 

 

 

A) Determine the upper and lower control limits and the overall mean for the x bar chart and the R chart (10 marks)

B) Draw the charts and plot the values of the sample means and range. (5 marks)

C) Should the mint invest in this new machine? Explain (5 marks)

 

Hint: Use the formulas related to the 3-sigma chart in the text and lesson notes.

The variables A2, D3, and D4 come from the chart. You can determine which row to use based on the value of “n” provided in the question.

See the example in the lessons for a good guideline.

You can draw the charts in Excel. If you are not sure how to do this there are good Youtube videos you can search on “how to draw statistical process control charts on excel”.

 

3. Specification Limits (10 marks)

Ecril Technologies makes car parts using vacuum formed molds. The President wants the process of creating molds to be reviewed to determine if the life span of the molds, or the rate they have to replace molds, is acceptable. Each mold produces on average 1,459 acceptable parts with a standard deviation of 81. The lower and upper control limits are 1,297 and 1,945 parts respectively. Calculate the Cp and Cpk to determine if the mold making process is capable of producing sufficient parts to specification? Explain your results.

 

Hint: Use the formulas for Cp and Cpk from the text.

Interpret both the Cp and Cpk to explain your results.