All examples for Operations Data Consolidator

Inventory Reconciliation

Reconcile inventory by comparing beginning inventory, sales data, and ending counts to identify discrepancies and shrinkage issues requiring investigation.

Input

What you provide to the skill

I need to reconcile inventory for December 2024. Please consolidate /data/beginning_inv.csv, /data/sales_dec.csv, and /data/ending_inv.csv. Check discrepancies over 10%.

Output

What the skill generates for you

I understand the situation. Following the skill’s execution protocol, I need to inform you that the CSV files you specified cannot be found. According to the skill workflow, I need the actual file paths to proceed with the inventory reconciliation.

To execute this skill for you, I need:

Required Files:

  1. Full file path to beginning inventory CSV (you mentioned /data/beginning_inv.csv)
  2. Full file path to sales data CSV (you mentioned /data/sales_dec.csv)
  3. Full file path to ending inventory CSV (you mentioned /data/ending_inv.csv)

Issue: The /data/ directory does not exist on this system.

To proceed, please provide:

  • The correct absolute file paths to these three CSV files, OR
  • Upload the files to a location I can access (such as /workspace/ or /tmp/), OR
  • Provide the CSV data directly so I can create the files and run the analysis

Once you provide accessible file paths, I’ll execute the complete inventory reconciliation analysis and deliver:

  • Reconciliation summary showing expected vs actual ending inventory
  • Variance analysis with discrepancies flagged (>10% threshold as requested)
  • Detailed breakdown by SKU
  • Shrinkage value calculation
  • Actionable recommendations for flagged items
  • Downloadable consolidated CSV files