Assignment $11\mathrm{.}2$: Case Excel Logistics

Case Excel Logistics Services, Sunil Chopra, $2004,$ KEL$019$

Submit your graphical plots to Questions $1($Run Chart$)$ and $4($a$)$ Pareto Chart along with the calculation for all the remaining questions here and answer them in the MCQ Assignment.

Discussion Questions:

$1.$ Help Stalk organize the data by preparting a run chart from the receiving area $($plot proportion defective$)$ Submit your graph here.

$2.$ Prepare appropriate process control charts to see if the process is in control. Is the receiving process in or out of control.

Hint : Construct a p$-$chart for the receiving area $($use Exhibit $3$ data$).$

a$)$ Compute p $=$ proportion defective

b$)$ Compute standard deviation $(\backslash$sigma $)$ of proportion defectives.

c$)$ Compute $($Upper Control Limit$)$ and Lower Control Limit $($LCL$)$

d$)$ Is the receiving process in control?

$3.$ Customer service requirements determine that receiving process errors should never exceed $2$ percent on anyy given day. What percentage of the days is likely to exceed $2$ percent error, given the current performance at receiving? Assume a total of $8000$ transactions per day, $4000$ in each module.

a$)$ Compute p