It appears as if some of the parts are in fact subassemblies.
You can check this by turning on (or recreating the BOM with the option "Detailed Numbering". Your item numbers we then appear like so:
Since it's excel based bom, i don't have the option of detail numbering
Did anyone find some solution to this problem?