Attached is the SRJ Logistics case study. You should review the case study and using the data in Exhibits 3, 4, and 5, complete the five discussion questions located on page 4 of the case study. Your response must be in a Word document. You will want to create your charts and graphs in Excel and copy them into the Word document.
1. The formulae should be written, and calculations should be in a detailed form.
Discussion Questions
1) Help Marsh organize the data by preparing a run chart.
2) Prepare appropriate process control charts to see if the process is in control. Is th receiving process in or out of control?
a. Process control charts should reflect the control limits as well as the spec limits.
b. Question 3 helps you identify the spec limits.
3) Customer service requirements determine that receiving process errors should never exceed 2 percent on any given day. What percentage of the days is likely to exceed 2 percent error, given the current performance of receiving? Assume a total of 8,000 transactions per day, 4,000 in each module. 4) Prioritize the set of actions you would take to ensure that more than 99 percent of the days have less than 2 percent receiving process error.
5) Can you think of a continuous improvement framework that Marsh can use as an engine to improve performance in the receiving process and other processes at Springfield
Overall
| Date | Slotter Errors | Keying Errors | Letdown Errors | ITR ADJ Errors | Putaway Errors | Other Errors | Total Errors | Total Slots Checked | |||||||||
| 6/1 | 4 | 1 | 1 | 1 | 0 | 3 | 10 | 800 | |||||||||
| 6/2 | 11 | 2 | 1 | 2 | 2 | 7 | 25 | 800 | |||||||||
| 6/3 | 11 | 2 | 0 | 2 | 4 | 4 | 23 | 800 | |||||||||
| 6/4 | 6 | 6 | 0 | 0 | 2 | 11 | 25 | 800 | |||||||||
| 6/5 | 6 | 0 | 0 | 1 | 3 | 4 | 14 | 800 | |||||||||
| 6/6 | 19 | 0 | 0 | 0 | 1 | 5 | 25 | 800 | |||||||||
| 6/7 | 11 | 0 | 0 | 0 | 2 | 2 | 15 | 800 | |||||||||
| 6/8 | 3 | 1 | 2 | 0 | 1 | 16 | 23 | 800 | |||||||||
| 6/9 | 3 | 0 | 3 | 0 | 1 | 3 | 10 | 800 | |||||||||
| 6/10 | 3 | 0 | 3 | 0 | 0 | 5 | 11 | 800 | |||||||||
| 6/11 | 5 | 0 | 3 | 0 | 0 | 7 | 15 | 800 | |||||||||
| 6/12 | 0 | 1 | 1 | 0 | 1 | 22 | 25 | 800 | |||||||||
| 6/13 | 4 | 1 | 3 | 0 | 4 | 5 | 17 | 800 | |||||||||
| 6/14 | 2 | 0 | 2 | 0 | 0 | 19 | 23 | 800 | |||||||||
| 6/15 | 0 | 2 | 2 | 0 | 0 | 1 | 5 | 800 | page 373 | ||||||||
| 6/16 | 2 | 2 | 0 | 0 | 1 | 0 | 5 | 800 | |||||||||
| 6/17 | 4 | 0 | 1 | 0 | 2 | 0 | 7 | 800 | |||||||||
| 6/18 | 3 | 1 | 4 | 2 | 0 | 0 | 10 | 800 | |||||||||
| 6/19 | 4 | 0 | 3 | 0 | 2 | 1 | 10 | 800 | |||||||||
| 6/20 | 7 | 2 | 2 | 0 | 3 | 3 | 17 | 800 | |||||||||
| 6/21 | 13 | 0 | 2 | 0 | 1 | 9 | 25 | 800 | |||||||||
| 6/22 | 7 | 0 | 2 | 0 | 2 | 5 | 16 | 800 | |||||||||
| 6/23 | 4 | 0 | 4 | 0 | 1 | 6 | 15 | 800 | |||||||||
| 6/24 | 7 | 0 | 0 | 0 | 2 | 7 | 16 | 800 | |||||||||
| 6/25 | 2 | 0 | 1 | 0 | 4 | 2 | 9 | 800 | |||||||||
| 6/26 | 2 | 0 | 1 | 0 | 4 | 1 | 8 | 800 | |||||||||
| 6/27 | 2 | 0 | 2 | 0 | 0 | 8 | 12 | 800 | |||||||||
| 6/28 | 8 | 1 | 1 | 0 | 0 | 6 | 16 | 800 | |||||||||
| 6/29 | 7 | 1 | 1 | 0 | 0 | 7 | 16 | 800 | |||||||||
| 6/30 | 1 | 1 | 1 | 0 | 1 | 4 | 8 | 800 | |||||||||
| 7/1 | 10 | 0 | 2 | 0 | 1 | 8 | 21 | 800 | |||||||||
| 7/2 | 7 | 0 | 2 | 0 | 2 | 4 | 15 | 800 | |||||||||
| 7/3 | 4 | 0 | 1 | 0 | 6 | 1 | 12 | 800 | |||||||||
| 7/4 | 6 | 0 | 2 | 0 | 1 | 1 | 10 | 800 | |||||||||
| 7/5 | 3 | 0 | 1 | 0 | 0 | 2 | 6 | 800 | |||||||||
| 7/6 | 0 | 2 | 2 | 0 | 0 | 1 | 5 | 800 | |||||||||
| 7/7 | 1 | 0 | 5 | 0 | 0 | 19 | 25 | 800 | |||||||||
| 7/8 | 5 | 0 | 2 | 0 | 0 | 3 | 10 | 800 | |||||||||
| 7/9 | 5 | 2 | 2 | 0 | 1 | 6 | 16 | 800 | |||||||||
| 7/10 | 6 | 0 | 0 | 0 | 1 | 2 | 9 | 800 | |||||||||
| 7/11 | 9 | 0 | 3 | 0 | 0 | 8 | 20 | 800 | |||||||||
| 7/12 | 9 | 0 | 3 | 0 | 0 | 8 | 20 | 800 | |||||||||
| 7/13 | 4 | 0 | 2 | 0 | 5 | 0 | 11 | 800 | |||||||||
| 7/14 | 0 | 0 | 3 | 0 | 8 | 1 | 12 | 800 | |||||||||
| 7/15 | 0 | 0 | 2 | 0 | 0 | 5 | 7 | 800 | |||||||||
| Total | 230 | 28 | 78 | 8 | 69 | 242 | 655 | 36000 |
Module 1
| Date | Slotter Errors | Keying Errors | Letdown Errors | ITR ADJ Errors | Putaway Errors | Other Errors | Total Errors | Total Slots Checked |
| 6/1 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 400 |
| 6/2 | 10 | 2 | 1 | 2 | 1 | 1 | 17 | 400 |
| 6/3 | 9 | 1 | 0 | 2 | 4 | 2 | 18 | 400 |
| 6/4 | 6 | 6 | 0 | 0 | 2 | 7 | 21 | 400 |
| 6/5 | 3 | 0 | 0 | 1 | 3 | 0 | 7 | 400 |
| 6/6 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 400 |
| 6/7 | 7 | 0 | 0 | 0 | 1 | 2 | 10 | 400 |
| 6/8 | 1 | 1 | 2 | 0 | 1 | 16 | 21 | 400 |
| 6/9 | 3 | 0 | 3 | 0 | 1 | 1 | 8 | 400 |
| 6/10 | 3 | 0 | 3 | 0 | 0 | 3 | 9 | 400 |
| 6/11 | 5 | 0 | 3 | 0 | 0 | 3 | 11 | 400 |
| 6/12 | 0 | 1 | 1 | 0 | 1 | 21 | 24 | 400 |
| 6/13 | 4 | 1 | 3 | 0 | 3 | 5 | 16 | 400 |
| 6/14 | 2 | 0 | 2 | 0 | 0 | 0 | 4 | 400 |
| 6/15 | 0 | 2 | 2 | 0 | 0 | 1 | 5 | 400 |
| 6/16 | 2 | 2 | 0 | 0 | 0 | 0 | 4 | 400 |
| 6/17 | 1 | 0 | 1 | 0 | 1 | 0 | 3 | 400 |
| 6/18 | 3 | 1 | 4 | 2 | 0 | 0 | 10 | 400 |
| 6/19 | 3 | 0 | 3 | 0 | 2 | 1 | 9 | 400 |
| 6/20 | 7 | 2 | 2 | 0 | 2 | 2 | 15 | 400 |
| 6/21 | 13 | 0 | 2 | 0 | 0 | 8 | 23 | 400 |
| 6/22 | 7 | 0 | 2 | 0 | 2 | 1 | 12 | 400 |
| 6/23 | 4 | 0 | 4 | 0 | 1 | 4 | 13 | 400 |
| 6/24 | 5 | 0 | 0 | 0 | 1 | 5 | 11 | 400 |
| 6/25 | 2 | 0 | 1 | 0 | 4 | 2 | 9 | 400 |
| 6/26 | 1 | 0 | 1 | 0 | 3 | 1 | 6 | 400 |
| 6/27 | 2 | 0 | 2 | 0 | 0 | 5 | 9 | 400 |
| 6/28 | 6 | 0 | 1 | 0 | 0 | 4 | 11 | 400 |
| 6/29 | 5 | 0 | 1 | 0 | 0 | 5 | 11 | 400 |
| 6/30 | 1 | 0 | 1 | 0 | 0 | 4 | 6 | 400 |
| 7/1 | 8 | 0 | 2 | 0 | 1 | 7 | 18 | 400 |
| 7/2 | 7 | 0 | 2 | 0 | 2 | 4 | 15 | 400 |
| 7/3 | 2 | 0 | 1 | 0 | 6 | 1 | 10 | 400 |
| 7/4 | 4 | 0 | 2 | 0 | 1 | 1 | 8 | 400 |
| 7/5 | 2 | 0 | 1 | 0 | 0 | 1 | 4 | 400 |
| 7/6 | 0 | 2 | 2 | 0 | 0 | 0 | 4 |