Do some Excel Work, QUALITY ASSURANCE PROJECT ASSEMBLY LINE SAMPLING

I have done part 1 and 2 and need you to check them if they are correct. If so, want you to do part 3. Need the project done in 8 hours or less

Using the Matlab Simulink software, design an assembly line operation to produce cans with a mean of 13.5 oz and a variance of 0.5. The cans are going to be produced at a rate of 1 can per minute and the operation will run for a full 8 hour day. Each day, samples of size 5 are to be taken every hour. For example, the first sample will occur at time 60, 61, 62, 63, and 64 minutes. The second sample should occur at time 120, 121, 122, 123, 124 and so on. Repeat the sampling pattern for five days (a full week).

Note that by changing the seed value in the random number generator, a different set of normal random numbers are going to be generated and this will simulate a different production output for each day. To make it more credible, choose a different mean and a variance for each day along with a different seed number. Pick a mean value for each day that is different but must lie in the range

of 12 oz to 14 oz and pick a variance that will range from 0.5 to 0.75.

Part I) Transfer the output to an excel chart and label each sample properly (day and time collected). For every production day, construct statistical process controls (SPC) charts: a X-Bar, a R (Range) and a S- Charts. (Determine if the processes are within control). X-Bar measures the central tendencies of the data. R and S charts measures the tendencies to deviate from the mean.

Part 2) Perform an Analysis of Variance (ANOVA) on the five days of production. Use as representative sample for the entire day, the full 8 samples (@5 values each) = 40 values.

Using the full 40 values sampled for each day, determine the 95% confidence interval for the mean of the production for each day.

Part 3) Modify the existing Simulink model to simulate the production of chemical C in a chemical reactor. The reactor operates for eight hours each day and each hour, it is required to select three samples of the chemical (a minute apart). These samples are analyzed separately in the lab for the content of chemical C and the average value is obtained as the representative concentration of chemical C for that hour. The reactor company recognizes that the production of chemical C depends on pressure and temperature of the reactor but does not know exactly at what temperature and pressure the reactor should be set to maximize production of chemical C. In front of the reactor panel, assume that there are two buttons. One controls temperature and one controls pressure. The temperature setting has only two options: 80°C and 120°C. The pressure settings options are: 35 psia, 75 psia and 100 psia.

For simulation purposes, the past lab results have generated the following parameters:

T °C P (psia) Production Follows a Normal with

80 35 μ = 120 grams/cc σ= 10 grams/cc

80 75 μ = 100 grams/cc σ= 15 grams/cc

80 100 μ = 125 grams/cc σ= 12 grams/cc

120 35 μ = 135 grams/cc σ= 25 grams/cc

120 75 μ = 120 grams/cc σ= 5 grams/cc

120 100 μ = 125 grams/cc σ= 18grams/cc

For each scenario generate eight data concentration points (average of three samples is one data point) and perform a full factorial design to determine which factors are significant in the production of chemical C. Determine the predicted model for the production of chemical factor as a function of the significant values found. At what T and P should the reactor be set to maximize production of chemical C?

Write a formal report on this project and incorporate all three

Data Entry Data Processing Excel

Project ID: #6775731

About the project