Revenue-Maximising Pricing System
1,776 price combinations
Quote Details Manually enter quote reference info
● Loading live FX rates…
Quote Line Items Add multiple products — each line is priced independently
Saved Quotes —
Saved Saved by Quote # Customer Date Ccy Lines Units Distributor Total Tender Total Weight Actions
Showing 1,776 of 1,776 combinations
Carrier ↕ Size ↕ Ballistic Package ↕ Bal. Size ↕ Category ↕ Carrier kg ↕ Ballistic kg ↕ Areal Density ↕ Total kg ↕ Carrier Cost ↕ Ballistic Cost ↕ Labour ↕ Landed Cost ↕ Carrier Price ↕ Ballistic Price ↕ Floor ↕ Recommended ↕ Stretch ↕ Margin ↕
Cost Drivers
Labour Rate (Carrier minutes)
Workbook Inputs!B30 — £22.0011736111/hr
£/hr
Labour Rate (Ballistic minutes)
Workbook Inputs!B30 — £22.0011736111/hr
£/hr
Monthly Interest Rate
Rules!B2 — applied to Materials × Lead Time
%
Lead Time (Months)
Inputs!B21 — drives material financing
mo
Contribution Margin (CM)
Rules!B3 — MSP = Variable Cost ÷ (1 − CM)
%
QA & Packaging
Not in workbook — leave 0 to match Excel
£
Overhead Percent
Not in workbook — leave 0 to match Excel
%
Sales Commission
Not in workbook — leave 0 to match Excel
%
Currency Buffer
Not in workbook — leave 0 to match Excel
%
Strategic Premium
Extra uplift on the recommended price
%
Rounding Step
Final list prices rounded to (GBP)
£
Category Target Margins (CM)
Soft Armour
Workbook Rules!B3 = 23.8988%
%
Stab
%
Ballistic + Stab
%
Demining
%
Channel Multipliers (Workbook Rules!B4–B8)
MSP
Inputs!B32 — base price ÷ (1 − CM)
×
Distributor
Rules!B4 — 1.08
×
Tender
Rules!B5 — 1.12
×
Dealer
Rules!B6 — 1.20
×
LE/EU
Rules!B7 — 1.25
×
Retail
Rules!B8 — 2.45
×
Size Margin Uplifts
All sizes
Uniform uplift added to every size's target margin
+%
Pricing Logic
COST BUILD-UP (Workbook Inputs sheet)
Total Materials = Panel Cost + Cover Cost.
Financed Materials = Materials × (1 + 2% × Lead Time months).
Labour Cost = (Labour Minutes ÷ 60) × £22.0011736111.
Variable Cost = Financed Materials + Labour Cost.
MSP (Inputs!B32)
MSP = Variable Cost ÷ (1 − CM). Workbook CM = 23.8988% (Rules!B3).
CHANNEL OUTPUTS (Outputs sheet)
Distributor = MSP × 1.08 (Rules!B4)
Tender = MSP × 1.12 (Rules!B5)
Dealer = MSP × 1.20 (Rules!B6)
LE/EU = MSP × 1.25 (Rules!B7)
Retail = MSP × 2.45 (Rules!B8)
FX RATES (Workbook FX_Rates)
GBPUSD = 1.27, GBPEUR = 1.16. Live ECB rates may override these in the Quote Builder header.