Spreadsheet Dashboard MRP Account
Analyze manufacturing costs and accounting with custom dashboards
Spreadsheet Dashboard MRP Account Overview
Spreadsheet Dashboard MRP Account is a powerful analysis tool in Odoo, combining data from Manufacturing (MRP) and Accounting to create detailed manufacturing cost reports. This module allows you to track cost of goods manufactured, analyze variances, calculate production costs, and manage manufacturing accounting in an intuitive spreadsheet interface.
Key points
• Integrate data from MRP, Inventory, and Accounting in one dashboard
• Track cost of goods manufactured (COGM) by product and work order
• Analyze variance between standard cost and actual cost
• Calculate material, labor, and overhead costs
• Track work in progress (WIP) inventory valuation
• Compare production costs between periods and products
• Analyze profitability by product and production order
• Export data to Excel for advanced analysis
Terminology Reference
Key terminology in Spreadsheet Dashboard MRP Account:
Creating MRP Account Dashboard
Process to create manufacturing cost analysis dashboard in Odoo:
Steps
1. Access Spreadsheet > Dashboards or Manufacturing > Reporting > Cost Analysis
2. Click "Create" to create new dashboard
3. Select "MRP Cost Analysis" template or start from blank
4. Add pivot table with data source from mrp.production or stock.move
5. Configure rows: Product, Work Order, BOM
6. Configure columns: Cost Type (Material, Labor, Overhead), Date
7. Select measures: Standard Cost, Actual Cost, Variance, Quantity
8. Add filters: Date range, Product Category, Work Center
9. Create charts: Waterfall chart for cost breakdown, Line chart for trends
10. Add formulas to calculate COGM, variance %, efficiency
11. Format dashboard with conditional formatting for variances
12. Save and share dashboard with production and finance teams
Cost of Goods Manufactured (COGM)
Calculate and analyze COGM to understand manufacturing costs:
COGM Components
| Component | Formula | Description |
|---|---|---|
| Direct Materials Used | =Beginning RM + Purchases - Ending RM | Materials used in production |
| Direct Labor | =Sum of labor hours × labor rate | Direct labor costs |
| Manufacturing Overhead | =Indirect materials + Indirect labor + Other | Manufacturing overhead |
| Total Manufacturing Cost | =DM + DL + MOH | Total manufacturing cost |
| COGM | =Beginning WIP + Total Mfg Cost - Ending WIP | Cost of goods manufactured |
Variance Analysis
Analyze variances to identify cost overruns and opportunities:
Key points
• Material Price Variance: (Actual Price - Standard Price) × Actual Quantity
• Material Quantity Variance: (Actual Qty - Standard Qty) × Standard Price
• Labor Rate Variance: (Actual Rate - Standard Rate) × Actual Hours
• Labor Efficiency Variance: (Actual Hours - Standard Hours) × Standard Rate
• Overhead Spending Variance: Actual Overhead - Budgeted Overhead
• Overhead Volume Variance: Budgeted Overhead - Applied Overhead
• Identify favorable vs unfavorable variances
• Root cause analysis for significant variances
Cost Breakdown Analysis
Detailed analysis of product cost structure:
Key points
• Material costs: Breakdown by component and supplier
• Labor costs: Analysis by work center and operation
• Overhead allocation: Distribution by cost drivers
• Cost per unit: Calculate unit cost for each product
• Cost trends: Track cost changes over time
• Product profitability: Compare cost vs selling price
• Make vs buy analysis: Evaluate outsourcing decisions
• Scrap and waste costs: Identify improvement opportunities
Work in Progress (WIP) Tracking
Track and valuate WIP inventory:
WIP Metrics
| Metric | Formula | Purpose |
|---|---|---|
| Beginning WIP | From previous period | Beginning WIP |
| Costs Added | DM + DL + MOH for period | Costs incurred in period |
| Ending WIP | Beginning WIP + Costs Added - COGM | Ending WIP |
| WIP Turnover | COGM / Average WIP | WIP turnover ratio |
| Days in WIP | 365 / WIP Turnover | Days in WIP |
Production Efficiency Metrics
Evaluate production efficiency through metrics:
Key points
• Overall Equipment Effectiveness (OEE): Availability × Performance × Quality
• Cycle time: Time to complete one production cycle
• Throughput: Number of products completed in time period
• Yield rate: (Good units / Total units produced) × 100
• Scrap rate: (Scrapped units / Total units) × 100
• Capacity utilization: (Actual output / Maximum capacity) × 100
• Labor productivity: Output / Labor hours
• Cost per unit trends: Monitor unit cost improvements
Product Profitability Analysis
Analyze profitability of each product:
Profitability Metrics
| Metric | Formula | Insight |
|---|---|---|
| Gross Margin | (Selling Price - COGM) / Selling Price | Gross profit margin |
| Contribution Margin | Selling Price - Variable Costs | Contribution to fixed costs |
| Break-even Quantity | Fixed Costs / Contribution Margin | Break-even quantity |
| Profit per Unit | Selling Price - Total Cost | Profit per unit |
Best Practices
Tips and strategies to optimize MRP Account dashboard:
Key points
• Regular standard cost reviews to ensure accuracy
• Investigate variances > 5% to identify root causes
• Track cost trends to anticipate price changes
• Use ABC analysis to focus on high-value items
• Monitor WIP levels to optimize cash flow
• Compare actual vs budgeted costs monthly
• Analyze scrap and rework costs to reduce waste
• Benchmark costs against industry standards
• Document cost reduction initiatives and track results
• Integrate with quality data to correlate cost and quality