exel logistic case study

Pages: 16 (5146 words) Published: October 24, 2014
Answer 1 Stalk analyzed the Receiving process and started organizing the data to prepare the Run Chart to display observed data in time sequence. After identifying the 5 sources of error Slotter, Keying, Letdown, ITR ADJ, Putaway, we are trying to notice a trend in the Proportion of errors noticed/Total errors observed. Following are the run charts prepared for this exercise Chart 1 Slotter Errors Chart 2 Keying Errors Chart 3 Letdown Errors Chart 4 ITR ADJ Errors Chart 5 Putaway Errors Chart 6 Other Errors Please open the embedded excel spreadsheet to refer the detailed data. We have provided the corresponding run charts above for quick reference. EMBED Excel.Sheet.8 Answer 2 Margolis and Stalk were able to identify that they are not dealing with measurable variables like length, width or thickness of an object but with the classification of different process stages as being defective or not. This information can help us narrowing down to a particular control chart type. Following is a summarized view of entire exercise which mentions all the calculations required to draw control charts and to reach to conclusion about state of process. Exhibit ProcessSample SizeSubgroupsTotal Sample UnitsTotal ErrosCenterlineStandard ErrorUCLLCLProcess Status3Overall80045360006550.01820.00470.03240.0040In Control4Module 140045180004860.02700.00810.05130.0027Out Of Control5Module 340045180001690.00940.00480.02390.0000Out Of Control Please open the embedded excel spreadsheet to refer the detailed process. Following are given the supportive snapshots of various control charts for a quick reference. EMBED Excel.Sheet.8 Exhibit 3 Overall performance of Receiving process Exhibit 4 Module 1 Performance Exhibit 5 Module 3 Performance Answer 3. Let us have a look at the receiving process of Exel to understand the potential errors during the flow Possible Errors Slotter Errors in any of the slotter functions Keying Errors in receiving officer keying the quantities into the inventory system Letdown Errors in any of the unloader functions ITR ADJ Errors I receiving packet prepared by receiving officer Put away Errors in putting the pallet/stack in the wrong location We have seen above that the receiving process as far as the available data shows is in control and does not have any outliers whatsoever. However the question asks us to identify the percentage of days where the error in receiving goes more than 2. The chart above shows that the process is under control but the data tells that the limits are till 3, whereas we need to put the limit at 2. Out of 45 days we get that on 14 days the receiving error is likely to exceed 2 which is beyond the customer requirement this comes out to be 31.1 of the days. The below chart shows the clear picture Keeping into consideration the USL by the customer i.e 2 we can conclude that the process is not under control. Answer 5 - A-hA9/j (aYm p9eX7J9 2F_ H fXO-9iu9L.jLGOdTY4 F1

F1
F1
F1
GRGZ2zo8uHB9yBaKNGji_dYGCNK@b uuzA_h-PecK2K,rpViZ77suowqH Q-XT _rnB1yz(eou5ARl.r5LryGZ7,yXaukS00@l39ZzD yxOIiYtMUV3I,74ubKuGc2YXw4DEt,_S9IEQRsR1I)NNG89iRNN7Uub Wm@71biWmWmPXjS,zu6Pt,-VG NPItLAY-Vg

CX YL @un0i 7.xy63lCDuqGRhGB-Gae C6W1PjTG@om90ljg,zP0Z7UU
6IhU(sk7/fHczMlJ@f5Py-drNi/D9wOQ58rYAT92vh3u,1gTDZ_,WR yV1ynl qHEMVeftZr aHNvXH(w4hn16.54W)Z9f42QOT9ti3u4W LnD dr6h@V1uh6WS9024yhrk Vdv_Sfcc0LL(eiAVTEc3d,Gvv_vjvd5 uwRvlzVtza aUZI8.)j6-J)runm@IGxgS 7r2 oA0hqzbectsxA3@a/v3@m39kusy9vSg.BXaUg fkIQ8j(FmB_hj@YyF1YkpbBZ7 ,qkU9qvaDZZkWRIDZeMh/mKnn3Z.)jZlt8bH fgEsc53Wmin_3iR Zm,FJru)VGkF TxKvuYDAM).xYEqMs8KwvqLZh33Xc8hqJJ17IKY2miCXg9VX2vMvJZs5WJ9h2ogIcg9R8Uq mzgu8cmjykES2vNrR96eG)VG6)YTC6W KKwCl49T5tQ2fCP/w6Ku d)HcZv_YCi WogT9-9hDch1Lez/E v@Q9GxJvq2aSfrxSNlL3MSf-OiyrnH@z6S PZi6uIbDZJqzWNiZeJ/wZ)hzp3/R7Ds UNE-0i6cCHK-TNBEcWO.MM6q)v f(jYlC(4l)XR0

iElieHpukMgbbkFOi9EW)
acCf
4eZC.nC@cuMea5Fwr_1P,Hg63(kVchhi3X)5SBUA9gAsH6tYg6JhK pzo4cks/CVTeW 7_O)q7sViclTFNVQBTgdQSK9y(H.Fnyg...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • The Hog Problem Case Study: Integrated Logistics Essay
  • case study Essay
  • case study Essay
  • Case Study Essay
  • Logistics Case Study Essay
  • Case Study Logistics Research Paper
  • Essay on Ziepeel Logistics Case Study
  • Logistics Company Case Study Essay

Become a StudyMode Member

Sign Up - It's Free