Purpose
This card provides a detailed breakdown of completed orders, splitting results between In Stock and Brokered sales. It highlights the share of each, monthly changes, and the associated dollar amounts, giving managers a complete picture of sales mix and order value trends.
Key Metrics
-
Parts Sold (In Stock vs. Brokered) – Number of parts sold from yard inventory compared to brokered parts.
-
% of Total Parts Sold – Share of overall completions from each category.
-
Sold Parts % Diff vs Prior Month – Month-to-month growth or decline in completions.
-
Order Amount (In Stock vs. Brokered) – Total dollar value of sales tied to each category.
-
Purchase Amount (Brokered only) – Cost of acquiring brokered parts, used to assess gross margin.
-
Totals – Consolidates all data for quick overall view.
Insights to Look For
-
Sales mix health: High in-stock percentages typically indicate strong internal inventory utilization, while heavy brokered reliance may point to stocking gaps.
-
Profit margin implications: Brokered orders include a purchase amount that cuts into margin, so rising broker reliance may mean lower profitability per sale.
-
Month-to-month performance: Growth or decline percentages highlight sales momentum and areas where demand is shifting.
-
Operational signals: Sudden spikes or dips (e.g., a sharp drop in completions) may indicate external supply challenges, seasonal patterns, or data entry anomalies.