Question: please i need this i really confuse . Use MS Excel to answer all the questions to each problem, including building the control charts. All

please i need this i really confuse . Use MS

please i need this i really confuse

. Use MS Excel to answer all the questions to each problem, including building the control charts. All the calculations must be performed using MS Excel and the formulas must be left in the cells. After completing the assignment, upload a copy of your Excel file on Moodle for grading. Any file that is not an Excel file will not be considered. Plagiarism and cheating (including sharing answers) are highly prohibited. . Problem 1 The accounts receivable department at Rick Wing Manufacturing has been having difficulty getting customers to pay the full amount of their bills. Many customers complain that the bills are not correct and do not reflect the materials that arrived at their receiving docks. The department has decided to implement SPC in its billing process. To set up control charts, 10 samples of 50 bills each were taken over a month's time and the items on the bills checked against the bill of lading sent by the company's shipping department to determine the number of bills that were not correct. The results were: SAMPLE NUMBER OF INCORRECT BILLS 6 1 2 5 11 4 4 5 0 5 3 8 4 9 7 10 2 1. Which control chart must you use to monitor the billing process at Rick Wing Manufacturing? Justify your choice. 2. Determine the control limits for the control chart you selected in question 1 using 30 and then build the chart. Has this process been in control? If not, which samples were out of control? 3. How might you use the quality tools discussed in Chapter 2 to determine the source of the billing defects and where you might start your improvement efforts to eliminate the causes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!