Can you explain how to get the answers for the Process Control at Polaroid (A) case using word and excel?

1. Discuss, the magnitude of cost of quality in R2 plant. And, how Rolf's project Greenlight is supposed to reduce the cost of quality. Especially, discuss what Rolf has been doing in light of difference between the providing quality products by after the fact sample testing and rejecting vs. controlling the production process using SPC techniques. (Hint Read chapter 10 and also skim through chapter 11 of your textbook. Think which the two process is more representative of Toyota Production System.) 2. You have to construct SPC charts for weight and height. Construction, analysis and insights from SPC are the center piece of this case. Data are on Exhibit 3 and Exhibit 6. (In have shown you how to draw SPC using the example in the book. It is slightly different here, because they use different data to calculate the x double bar, R bar, upper and lower control limits for x bar charts and R chart. Otherwise the process is not very different.) a. Use data on exhibit 3 to find x double bar, R bar, upper and lower control limits for x bar charts and R chart. b. Use data on Exhibit 6 to make SPC charts (x bar and R), for weight and height. c. Most important is analyze the Charts. d. In order to analyze, in detail, you have to draw separate charts (x bar and R), for weights as well as height for each of the different shifts. e. Give detail analysis of whether the process is in control. You should analyze for height, for weight for each of the shifts here. 3. One of the very important methods for brainstorming in order to find the root cause of the problems is Ishikawa Diagram (refer to page 238 in your text book.) In order to find the cause you have to identify all the issues (related to people, machine, method and materials). Please try to draw the diagram and use this to suggest improvements. 4. Conclusion.