Assume you are John Adams of ADS. Based on the following analysis, prepare a report to be submitted to both ADS and DCI executives regarding the status of the filling process at ADS and recommend method to improve quality control at the filling station and estimate the amount of credit to DCI. Use the data provided in the Excel data file.
Insert all graphs and provide analysis in this word file after every question. Only The Word file is graded.
a- Calculate the Range Column in Excel (Largest-Smallest) and find mean and standard deviations for Average Weight, Smallest, Largest, and Range columns.
b- What is the standard deviation of individual bags if sample averages are based on 6 bags? Explain your finding. Hint: x-bar = /sqrt(n). Having x-bar based on part (a) calculation, solve for given n= 6. So = (x-bar)*(sqrt(n)).
c- Construct a time series plot of all four variables (make two graphs: one includes avg., smallest, and largest and the other has range) and discuss your findings based on the graphs.
d- Construct X-bar and R Charts, graph, and discuss your findings based on the control charts. Make sure to include the control limit calculations below. Is the process out of control? Why? Explain.
e- Is there any differences between performances of three shifts? Hint: (Carve out the morning, afternoon, and night shift data into three columns and graph their averages. Explain your findings based on graph.
f- Use One Way Analysis of Variance (ANOVA) to compare the three groups (shifts) to test if there is significant differences in the performance of three shift averages. Use Alpha =0.01. Indicate the Null and Alt. hypotheses and explain your findings based on ANOVA table.
g- Assume Tolerance limits of 25±1.25 lbs. is specified in the sales contract and find the Process Capability index Cpk. Discuss if this process is capable to meet contractual agreement.
h- Redo part g for all three shifts separately and determine their Cpk. Note that you must carve out the three shifts and find the mean and standard deviations for each shift separately and go through part b calculations for each shift.
i- If the process average is adjusted to 25.0 lbs. and process standard deviation (answer in part b) is reduced by 80%, what is the new Cp? Are you comfortable for making such recommendation to management? Explain.
j- Find the control limits for an X-bar and R chart if a new improved process has average of 25.0 lbs. and R-bar of 1.0 lbs. Assume n=4 for new process control. No graph needed.
k- Estimate the amount of credit ($) must be given to DCI (for the past 24 months) if it purchased 10,000 bags per month at cost of $3 per lb.
l- Provide complete conclusion regarding your findings and make recommendations regarding the filling process in your conclusion paragraph.
Quality of Interpretations/Analysis 20%
General Quality of Report/graphs/writing 10%
Due Date: Sunday April 26, 2020
Professional homework help features
Our ExperienceHowever the complexity of your assignment, we have the right professionals to carry out your specific task. ACME homework is a company that does homework help writing services for students who need homework help. We only hire super-skilled academic experts to write your projects. Our years of experience allows us to provide students with homework writing, editing & proofreading services.
Free revision policy$10
Free bibliography & reference$8
Free title page$8
How our professional homework help writing services work
You first have to fill in an order form. In case you need any clarifications regarding the form, feel free to reach out for further guidance. To fill in the form, include basic informaion regarding your order that is topic, subject, number of pages required as well as any other relevant information that will be of help.Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.Completing the order and download