Back to Templates
COMPETITOR ANALYSIS
Weighted Price Index Calculator
Calculate your exact price position relative to the market using volume-weighted baskets.
LIVE PREVIEW
| SKU | Sales Weight (%) | My Price | Comp A Price | Comp B Price | Index vs A | Index vs B |
|---|---|---|---|---|---|---|
| SKU-101 | 50% | $10.00 | $11.00 | $9.50 | 90.9 (Value) | 105.2 (Premium) |
| SKU-102 | 30% | $20.00 | $20.00 | $18.00 | 100.0 (Parity) | 111.1 (Premium) |
| SKU-103 | 20% | $5.00 | $4.00 | $4.00 | 125.0 (Premium) | 125.0 (Premium) |
| Weighted Avg | 100% | - | - | - | 100.4 (Parity) | 110.9 (Premium) |
| -- | -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | -- | -- |
Instructions
- 1Assign Weights: Give high-volume SKUs higher percentage weights.
- 2Index Formula: (My Price / Competitor Price) * 100.
- 3Interpret: >100 means you are more expensive. <100 means cheaper.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Stop looking at simple averages. Use weighted indices to understand your true market position based on what actually sells.
Key Features
Weighted Logic: Prioritize best-sellers.
Multi-Competitor: Compare vs 2 rivals.
Common Use Cases
Quarterly Business Reviews: Market position update.
Category Management: Shelf pricing.
Frequently Asked Questions
What is a 'Basket'?
A representative collection of products used to track overall price levels.