Inventory Variance Analysis & Cost Reconciliation
Identify inventory discrepancies and reconcile costs with variance analysis
What You Can Do
This skill analyzes the gap between expected and actual inventory levels, pinpoints root causes of variance, and reconciles cost differences across your supply chain. You'll discover hidden shrinkage, pricing misalignments, and data entry errors—then generate actionable corrective reports to improve inventory accuracy and reduce financial loss.
Features
Automatically calculate percentage and dollar variances between book inventory and physical counts, flagging high-variance SKUs for investigation
Analyze transaction logs and patterns to identify likely causes—theft, damaged goods, mislabeling, receiving errors, or system discrepancies
Reconcile inventory valuations using FIFO, LIFO, or weighted-average costing methods; identify pricing conflicts between systems
Track variance trends over time and by location, product category, or supplier to reveal systemic problems versus one-time anomalies
Generate prioritized remediation reports with specific steps—process fixes, staff retraining, system updates, or write-off decisions
Create detailed variance reports suitable for internal audit, compliance reviews, and financial statement reconciliation
Simulate the impact of proposed inventory corrections on financial statements and working capital before implementation
Example Output
Example 1: Variance Summary Report
SKU ABC-2450 | Expected: 500 units | Physical: 420 units | Variance: -16% (-80 units)
- Root cause: Receiving process gap (items logged but not shelf-stocked)
- Financial impact: $2,400 at $30/unit cost
- Recommendation: Audit receiving workflow; recount shelves in zone 3
Example 2: Cost Reconciliation Analysis
Inventory valuation method: Weighted-Average | Discrepancy found: $15,780
- GL balance (Mar 31): $247,950 | Physical inventory value: $232,170
- Cause: Overhead allocation error in costing system (incorrect labor rates applied)
- Adjustment: Credit COGS $15,780; update labor rates in ERP system
Example 3: Trend Analysis Dashboard
Variance rate by quarter: Q1 2.3% → Q2 3.1% → Q3 4.8% (trending up)
- High-risk categories: Electronics (6.2%), Perishables (5.1%)
- Action: Increase physical counts in high-variance areas; implement cycle counting program
What's Included
- Variance Calculation Engine: Automated computation of inventory deltas with built-in formulas for absolute and percentage variance, by SKU and category
- Root Cause Decision Tree: Guided workflow to systematically narrow down variance sources—shrinkage, obsolescence, process errors, or data quality issues
- Cost Reconciliation Templates: Pre-built analysis frameworks for FIFO/LIFO/WAC methods, with automatic GL account mapping and journal entry suggestions
- Audit-Ready Report Generator: Produces compliance-friendly documentation with source data, methodology, and sign-off fields for internal/external auditors
- Trend Analysis & Visualization Prep: Data formatting and summary tables ready to import into your BI tool for variance trending and multi-location comparisons
Who It's For
- Inventory Managers & Planners
- Supply Chain Operations Teams
- Finance & Accounting Managers
- Internal Auditors & Compliance Officers
- Retail & Warehouse Operations Leaders
Best For
- Monthly or quarterly inventory reconciliation
- Investigating unexplained discrepancies in count vs. system records
- Identifying shrinkage hotspots before they impact margins
- Preparing financial statements with accurate inventory valuations
- Post-audit analysis and corrective action planning
You might also like
You can perform deep audits of your project dependencies across multiple package ecosystems, identifying security vulnerabilities with CVSS scores, outdated versions, license incompatibilities, and unused packages. The skill generates a prioritized upgrade roadmap that balances security urgency, stability risk, and effort cost—helping you reduce supply chain risk and technical debt without destabilizing production.
Analyze your menu's cost structure, identify profit margins by item, and discover pricing optimization opportunities. You'll uncover which menu items are profit drivers versus margin drains, and receive data-driven recommendations for pricing adjustments, menu engineering, and cost reduction strategies. This helps you increase gross profit while maintaining competitive pricing.
You can comprehensively evaluate healthcare datasets for open data readiness, generating detailed assessment reports with actionable remediation steps. Claude analyzes data quality, metadata completeness, privacy compliance, and accessibility standards, then produces structured documentation that meets FAIR principles and healthcare governance requirements. You'll accelerate your open data initiatives by automating compliance checks and creating publication-ready documentation in minutes.
This skill analyzes your F&B operations across food costs, labor expenses, waste patterns, and menu pricing to uncover hidden savings opportunities. It generates actionable recommendations with potential impact calculations, helping you optimize margins without compromising quality. Use it to benchmark performance against industry standards and prioritize cost reduction initiatives by department and product line.
You can analyze actual versus standard food costs to identify exactly where variance is occurring—whether it's portion creep, supplier price hikes, waste, or other factors. Claude generates a structured root cause analysis, categorizes the variance drivers, and recommends targeted corrective actions ranked by impact and ease of implementation. This helps you recover margins without guessing.
Deliver personalized wine pairing guidance that matches your guests' preferences, budgets, and cuisine in seconds. You'll receive professional sommelier recommendations with tasting notes, pricing strategy, and upsell language tailored to your hotel's wine program. The skill also helps you analyze your current wine list for gaps, optimize margins, and train service staff to confidently recommend selections.
This skill analyzes your food and beverage costs against established standards, pinpointing variances and their root causes with quantified financial impact. You get detailed variance reports, root cause analysis, and prioritized corrective actions ranked by profitability impact. It's designed for restaurant managers, food service directors, and cost analysts who need to optimize F&B spending and quickly identify where money is leaking.
You'll centralize food cost analysis across multiple F&B locations, identify opportunities to standardize pricing and negotiate better supplier agreements. Claude helps you track waste patterns, consolidate purchasing power, and create actionable cost reduction strategies that increase margins without sacrificing quality.