Product Analysis Worksheet - Excel by zyp96255


More Info
                                                                                                                                                                      Tool Box
                                                                                                                                                           Root Cause Analysis Sheet v 1.0

Department: ______________________
Unit Leader: ______________________

                       May 2008                                                                                                                                              Review date
                                                                           ROOT CAUSE ANALYSIS WORKSHEET                                                                      5/19/2008
Product Delivery - Low Accuracy

          A. Possible causes of variance:                                         Weight %               B. Fishbone
            1 Sales Department is not informed about stock availability               20%
                                                                                                                                        1                   3                     5
            2 Sales Department is late with bringing orders from the market           30%            Product Delivery - Low           20%                  20%                    10%
            3 Order Entry Clerk typing mistakes                                       20%                  Accuracy

            4 Warehouse Laborer Loading mistakes                                      20%                 100.00%
            5 Inventory actual different than stock in system                         10%
                                                                                                                                        2                   4                     6
            6                                                                           0%                                            30%                  20%                    0%

          C. Corrective Action Plan

CAUSE                            WHAT                                                        HOW                                              WHO                              WHEN
          Sales Department to have daily update of Stock        System Report                                                 Stock Coordinator                      Every morning on
   1      Inventory                                                                                                                                                  working dayby 8:30

          Sales Department needs to bring orders from the       Sales Supervisor to collect and check all orders, then to     Sales Supervisor, Salesmen             Every working day, not
   2      market in timely manner                               submit them to Order Entry Clerk                                                                     later than 16:30

          Order Entry to improve typing accuracy                Training                                                      Order Entry                            ASAP

                                                                Order Entry to do Double Checking                             Order Entry                            Daily
   4      Improve Loading Accuracy
                                                                Checking 10% of Orders Entered                                Finance Supervisor                     Daily

                                                                Daily Inventory Check                                         Warehouse Laborer                      Daily, 18h

   5      Regular Inventory Check
                                                                Weekly Invenrory Check                                        Warehouse Supervisor                   Weekly, Friday 18h


       17f882a2-4292-4140-aba1-3c24826989ec.xls                                               1/1                                                                              7/11/2011

To top