Excel Logistics Services Case Study

Question 1 1. First construct a run chart of the data from the receiving area Question 2: 2. Construct a p-chart to obtain an estimate for the proportion defective across the set of X sample points (given) a. Total number defective = ? b. Total Transactions evaluated = ? c. Proportion defective = p = a/b 3. The next step is to obtain the standard deviation of proportion defective for a sample of size 800 per page 3 where Stalk is analyzing 800 per day for 45 days. a. Standard deviation of proportion defective for sample size 800, std deviation = sqrt (p(1-p)/800) = ? 4. The next step is to obtain the upper and lower control limits as follows: a. UCL= p 3 (std dev) = ? b. LCL = p-3 (std dev) = ? 5. Now you can check whether the receiving process overall is in control. Question 3: Since the process is under control, we assume that the average proportion defective is likely to be p=0.0182. 1, What is the standard deviation for a set of 8000 transactions per day? std deviation = sqrt (p(1-p)/8000) = ? 2. Now evaluate the proportion of days that exceed 2% defectives using normal distribution curve. Using excel 1-NORM.DIST (0.02,0.0182,0.00149,1) =?

Is this the question you were looking for? If so, place your order here to get started!

Related posts

New Technologies in Nursing

New Technologies in Nursing New Technologies in Nursing Introduction The current nursing technologies have transformed how nurses conduct their duties. Evidently, such technologies and new healthcare systems have endured establishing better services to patients. According to the reports of...