SAMPLE BILL OF LADING DATA OF ADM RICE INC 

Analysis and Recommendations for the Adm Rice Corporation Trade Data:

• Missing HS Codes:

  Issue: All entries lack HS codes (Harmonized System codes), crucial for customs and trade compliance.

• Action: Investigate and populate correct HS codes. For example:

  PP woven bags may fall under 6305.33 (if for bulk packaging), but confirm applicability for polypropylene (PP) instead of ethylene polymers.
• PP bulk/sling bags may require codes like 6305.33 or 6305.32 (verify with local customs guidelines).

Data Quality Issues:

• Null Supplier Entries: Two entries lack supplier information.

• Action: Collect complete supplier details for traceability and compliance.

• Duplicate Records: The 30.11.2024 entry appears twice with identical data.

• Action: Verify if duplicates are intentional (e.g., split shipments) or errors needing removal.

Date Anomaly:

• Future Dates: All trade dates are in November–December 2024 (beyond the current 2023 date).

• Action: Confirm if these are forecasts or correct historical data (potential typo: 2024 → 2023?).

Product and Weight Consistency:

• Product Descriptions: Inconsistent formatting (e.g., "PP BULK BAGS,PP SLING BAGS" as a single entry). 

• Action: Split multi-product entries into separate rows for clarity.

• Weight/Qty Ratios: Weight per unit averages ~495 units (likely kilograms) per bag, which is unusually high for PP bags.

• Action: Confirm units (e.g., kg vs. pounds) and validate data accuracy.

Supplier Standardization:

• Discrepant Names: "shuangzhou shanghai packaging" vs. "shuangzhou packaging international ltd."

• Action: Standardize naming to avoid fragmentation (e.g., confirm if these are subsidiaries or typos).

Country of Origin:

One shipment originates from Vietnam (supplier: shuangzhou packaging international ltd.), while others are from China.

• Action: Verify if the Vietnamese supplier is a subsidiary or a distinct entity to ensure accurate origin labeling.

HS Code in Product Field:

The 4.12.2024 entry manually lists "HS CODE: 630533" in the product description.

• Action: Move this to the HS code column and validate its correctness for PP (not ethylene-based products).

• Populate HS codes and validate classifications.
• Fix date discrepancies and supplier names.
• Investigate weight/qty units and duplicates.
• Split combined product entries for granularity.