Contribution Analysis Report
Contribution Analysis Report - User Guide
1. Introduction 💰
The Contribution Analysis Report is a vital tool for Cost Accountants and Management to understand the true profitability of products. By stripping away indirect overheads, it focuses on the Contribution Margin—the difference between the sales price and the variable cost of production.
ℹ️
Purpose of this Report:
- Profitability Benchmarking: Compare actual sale values against standard costing methods.
- Cost Efficiency: Identify products with thin margins or negative contributions.
- Price vs. Cost Analysis: Contrast the latest “Price List” with current input costs.
- BOM Cost Explosions: Understand how input material costs roll up into the finished product.
This report is essential for Price Revision Decisions and Product Mix Optimization.
2. Costing Methodologies 🚀
Users can choose between two critical costing benchmarks to evaluate performance:
A. Contribution by Weighted Average Cost (WAC)
- Logic: Uses the cumulative average cost of all inventory purchased over time.
- Best For: Understanding long-term profitability and smoothing out short-term market price fluctuations.
B. Contribution by Last Purchase Cost (LPC)
- Logic: Uses the most recent cost at which the item was procured.
- Best For: “Replacement Cost” analysis. It helps understand if current sale prices are sustainable given the latest market trends.
3. Report Structure & Key Sheets 🔍
The generated Excel report contains three distinct layers of analysis:
Sheet 1: Contribution by Sales
- Purpose: Analyzes the actual invoices issued during the period.
- Analysis: Compares the Invoiced Value against the calculated Cost (Qty × WAC/LPC).
- Key Data: Sales Qty, Sales Amount, Calculated Item Rate, Cost Amount, Net Margin, and Margin %.
Sheet 2: Contribution by Product (Price Master vs. Cost)
- Purpose: Benchmarks the current Price Master (List Prices) against inventory costs.
- Analysis: Checks if the “Recommended Selling Price” for each customer/item combination leaves a sufficient buffer.
- Key Data: Item Name, Party Name, List Price, Item Rate (Cost), and Theoretical Margin.
Sheet 3: Cost Recovery (BOM Analysis)
- Purpose: A deep-dive into the “Recipe” of the product.
- Analysis: Explodes the Bill of Materials (BOM) up to 4 levels to show exactly which sub-components or raw materials are driving the final cost.
- Key Data: Product, Input Item, Consumption Qty, Input Item Rate, and Total Cost Contribution.
4. Data Visibility & Insights 📊
| Data Category | Key Fields Visible |
|---|---|
| Profitability | Gross Sales, Total Variable Cost, Margin Value, and Margin Percentage. |
| Item Metadata | Item Group, Short Name, Stage (RM/SFG/FP), and Brand. |
| BOM Details | Input Item ID, Input Type (SA/PM/RM), Base Consumption, and Exploded Qty. |
| Competitive Data | Latest Purchase Price, Last Purchase Party, and Weighted Average Rate. |
5. Source Transactions 🔄
This report aggregates data from several core system modules:
- Sales Invoicing: Actual revenue and sales quantity (
Invoice). - Item Rates: Pre-calculated costing data (
ItemRates- updated via the Inventory Valuation engine). - Bill of Materials (BOM): The engineering definition of the product structure (
BOM). - Price Master: Customer-specific price agreements (
Price Master).
6. Best Practices / Tips 💡
- Spot Margin Erosion: Use the Margin % column and look for any product where the margin is lower than your company’s fixed overhead percentage.
- Audit your BOMs: If the Cost Recovery sheet shows an unusually high cost for a sub-component, verify if the BOM consumption qty or the input item’s rate is accurate.
- Replacement Pricing: During periods of high inflation, always use Option B (Last Purchase Cost) to ensure your sales prices reflect the current market reality.
- Top Down Review: Use the Grand Total row in the Sales sheet to see the overall health of a specific Item Group before drilling down into individual items.