iSixSigma

QFD

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #50941

    Udayan rastogi
    Member

    Dear All
    what is the logical relation in Quality fucntion Deployment.we have to select how on the bases of there score.Is there any way to find out priority number in QFD.
     
     

    0
    #175763

    Xgames
    Member

    Udayan,
    Use the sumproduct function (=SUMPRODUCT($D4:$D23,F4:F23) where the “D” column would represent your weights for your customer requirements and “F” column being what you scored your design requirements (how’s). That will give you the weighted importance of your “how”. Then divide the weight importance of that “how” by the sum of all the weighted importance of all “how’s” and that will give you the percent importance of the “how”. From there you can see which are the most important.

    0
Viewing 2 posts - 1 through 2 (of 2 total)

The forum ‘General’ is closed to new topics and replies.