Something went wrong!
Hang in there while we get back on track
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:
- Full file path to beginning inventory CSV (you mentioned
/data/beginning_inv.csv) - Full file path to sales data CSV (you mentioned
/data/sales_dec.csv) - 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
About This Skill
Consolidate multiple CSV files from different operational systems into unified datasets with summary reports and key metrics.
View Skill DetailsMore Examples
Carrier Performance Dashboard
Compare on-time delivery rates, costs, and transit times across multiple carriers (FedEx, UPS, DHL) to optimize carrier routing and reduce shipping costs.
Shipping Cost Analysis
Consolidate FedEx invoices with Shopify sales data to identify unprofitable shipping zones and generate recommendations for zone-based pricing optimization.