Parts & Accessories Gross Profit

Cascade Parts & Service — 2-Store Group

Last Updated

Dec 15, 2024 08:30 AM

Retail Counter Margin

38.2%

-1.8% vs target

Fill Rate (First Request)

84%

-8% vs target

Obsolescence Value

$312K

11% of Inventory

Special Order Cycle

4.2d

+0.7d vs Q3

Lost Sales (Monthly)

127

+19 vs Nov

Wholesale Mix

34%

Retail Mix

48%

Internal RO Mix

18%

Counter Upsell Rate

12%

Target: 18%

Parts Gross Margin Bridge Analysis

Fill Rate by Category

Week 1

Week 2

Week 3

Week 4

Brakes

76%

78%

74%

77%

Filters

88%

89%

87%

90%

Lighting

92%

93%

91%

94%

Belts/Hoses

82%

84%

81%

83%

Wipers

96%

97%

95%

98%

Batteries

86%

88%

85%

89%

≥95%

90-94%

80-89%

<80%

Special Order Cycle Time (Days)

Top 10 Obsolescence SKUs

SKU	Description	Age (Days)	Value	% of Total	Action
BR-4782	Brake Rotor Kit (Legacy)	487	$38,420	12.3%	Return Candidate
FL-2193	Oil Filter OEM (Disc.)	412	$27,890	8.9%	Return Candidate
LT-8821	Headlamp Assembly (Old Gen)	391	$24,100	7.7%	Discount Sale
BH-5512	Serpentine Belt (Overstock)	356	$19,640	6.3%	Discount Sale
WP-3401	Wiper Blade Multi-Pack	334	$16,280	5.2%	Bundle Promo
BT-7702	Battery AGM (Slow Turn)	298	$14,920	4.8%	Wholesaler Push
AC-6634	AC Compressor (OEM Repl.)	276	$13,450	4.3%	Return Candidate
SP-9182	Spark Plug Set (Superseded)	251	$11,670	3.7%	Discount Sale

Inventory Turn (Annual)

5.8x

Target: 6.5x

Price Override Rate

8.4%

Target: ≤5%

Parts Gross per RO

$142

Target: $165

Lost Sales by Reason Code

Counter Upsell Rate Trend

Pricing Matrix Version: v2.8.1 | Last Sync: Dec 15, 2024 06:15 AM

Data Source: DMS Parts Module + Inventory Aging Report