traffic light chart

							                                                                                                          Ampelfunktion Fa. ....


                                                             ppm - progress - (name of the company or department)
                                                                                                       quality/logistic
            Month                          Jan.     Feb.           March             April    May        June             July         August        Sept.      Oct.            Nov.             Dez.     yearly average      Supplier name
 date of scrap evaluation
       ppm-red-area                   #DIV/0!      #DIV/0!         #DIV/0!       #DIV/0!     #DIV/0!    #DIV/0!         #DIV/0!            #DIV/0!   #DIV/0!   #DIV/0!         #DIV/0!          #DIV/0!        #DIV/0!                                      #DIV/0!
      ppm-yellow-area                  250          250             250           250         250        250             250                250       250       250             250              250            250
      ppm-green-area                   100          100             100           100         100        100             100                100       100       100             100              100            100
      ppm ( quality )                 #DIV/0!      #DIV/0!         #DIV/0!       #DIV/0!     #DIV/0!    #DIV/0!         #DIV/0!        #DIV/0!       #DIV/0!   #DIV/0!         #DIV/0!          #DIV/0!        #DIV/0!             Ø
      ppm ( logistic )                #DIV/0!      #DIV/0!         #DIV/0!       #DIV/0!     #DIV/0!    #DIV/0!         #DIV/0!        #DIV/0!       #DIV/0!   #DIV/0!         #DIV/0!          #DIV/0!        #DIV/0!             Ø
    compl. Pieces (Q)                                                                                                                                                                                               0      sum of complaints
    compl. Pieces (L)                                                                                                                                                                                               0      sum of complaints
 plan pieces per month                                                                                                                                                                                              0      quantity deliefered
     statement date:
                500




                400




                300

     p
     p
     m          200




                100




                   0
                                                                                               May




                                                                                                                June




                                                                                                                                                                                         Oct.
                                                           March




                                                                                                                                    July




                                                                                                                                                                                                             Nov.




                                                                                                                                                                                                                           Dez.
                       Jan.




                                            Feb.




                                                                                                                                                                                                                                           yearly average
                                                                             April




                                                                                                                                                                       Sept.
                                                                                                                                                      August




____________________________________________________________
Rev. 00 von 01/2007
                             ___                                                                                       Ersteller:                                                                                                      Seite 1/1
33725d7f-123c-491d-9110-956fcdcf9cec.xls