Krishna,
Looks like there is your data is incomplete or incorrect somewhere.
A good way to diagnose is to check out one of the end items, and verify that the “supply path” report is correct. Similarly check one of the raw materials, and verify that the “where used” report shows all end items you expect to see.
Another good way to analyze is to generate the plan and use the “view log” button to check for errors.
Johan