All Case Studies
Case Study 03Internal Tooling · Sales Enablement

Real-Time Pricing Calculator for U.S. Sales

How a 1–2 day quote turnaround was killing custom furniture conversions — and the internal tool that generated ₹1.5 crore in additional monthly revenue.

Company

Sierra Living Concepts

Timeline

Jun 2025 – Sep 2025

My Role

MT → Product Manager

Teams

US Sales · Pricing · IT

The quote flow, before → after

1

Customer requests custom quote

2

Pricing team calculates — 1–2 days

3

Sales enters config into calculator

4

Instant price, live on the call

~₹1.5Cr

Additional monthly revenue

~30%

Conversion rate improvement

1–2d→0

Quote turnaround eliminated

1

The Background

Sierra Living Concepts sells custom furniture to the U.S. market — pieces configurable by dimensions, materials, fabrics, and finishes. A significant portion of revenue comes from custom order requests handled by the U.S. customer support and sales team.

During my Management Trainee period, while coordinating with operations and finance teams, I noticed the U.S. sales team frequently flagged a recurring issue: custom quote requests were taking 1–2 days to close, and a meaningful percentage of customers didn't wait.

"A customer calls, excited about a custom sectional. We say 'we'll email you a quote tomorrow.' By tomorrow, they've bought from Article or Crate & Barrel."

2

Understanding the Root Cause

I mapped the entire custom quote process end-to-end by interviewing the sales team and pricing team. The problem had three layers:

Layer 1 — Manual Calculation Dependency: Every custom quote required the pricing team to manually calculate the price. There was no tool — just spreadsheets and mental math.
Layer 2 — Async Communication Loop: Sales → Pricing → Sales → Customer was a chain of emails and messages. Even a 30-minute response meant the customer was already off the phone.
Layer 3 — Decision Delay = Drop-off: Premium buyers spending $5,000–$6,000 on custom pieces are comparison shopping. Every hour of delay was a competitor's opportunity.
3

Requirements Definition

I gathered requirements through structured sessions with the U.S. sales team and pricing team — understanding exactly how they calculated quotes manually, what variables were involved, and what edge cases existed:

RequirementDescriptionPriority
Real-Time Price CalculationSales agent enters config — calculator outputs exact price instantly, no pricing team dependencyHigh
All Custom Variables SupportedCover all configurable parameters: dimensions, material, finish, quantity, delivery zoneHigh
Pricing Logic AccuracyOutput must match pricing team's manual methodology exactly — validated with 20+ test casesHigh
Quote GenerationCalculator generates a shareable quote summary sendable to customer during or after the callMedium
Sales Team UsabilityInterface usable by sales agents during a live call — simple inputs, instant output, no training requiredMedium
Pricing Update MechanismWhen material costs change, pricing logic updatable by pricing team without IT involvementLow
4

Sprint Planning & Execution

📋 Sprint 1 — Pricing Logic DocumentationCompleted

Sprint Goal: Fully document the pricing team's manual calculation methodology — every variable, every formula, every edge case — so IT can build it accurately.

As a developer, I need a complete pricing logic specification covering all product types, materials, dimensions before writing any code
As a pricing team member, I want to review and sign off on the documented logic before build begins
As a PM, I want a list of 20+ test cases with expected outputs to use for QA validation
🔨 Sprint 2 — Calculator BuildCompleted

Sprint Goal: Build the calculator tool with all required input variables and real-time price output. Sales team usability testing in the last 2 days of sprint.

As a sales agent, I can input a custom configuration and get an accurate price in under 10 seconds while on a live call
As a sales agent, the interface is simple enough that I don't need documentation while using it
As a pricing manager, calculated prices match my manual calculations for all standard configurations
Sprint 3 — QA, Validation & DeploymentCompleted

Sprint Goal: Run all 20+ test cases, fix any pricing logic errors, get pricing team sign-off, train U.S. sales team, and deploy.

As a PM, I want to validate calculator output against manual pricing for all 20+ test cases with zero tolerance for errors on high-frequency configs
As a US sales team member, I want a 30-minute walkthrough before go-live so I'm confident on real customer calls
As a pricing manager, I want a simple way to update material cost inputs when supplier prices change without raising an IT ticket
5

Project Timeline

Week 1–2

Problem Identification & Stakeholder Alignment

Mapped the full custom quote process, quantified delay impact, aligned US sales, pricing, and IT teams on the solution approach.

Week 3–4

Pricing Logic Documentation

Worked with pricing team to document all calculation formulas, variables, and edge cases. Compiled 20+ QA test cases with expected outputs.

Week 5–7

Build & Iteration

IT team built the calculator. Two rounds of logic corrections identified during internal testing. Sales team usability testing conducted in week 7.

Week 8

QA, Sign-off & Deployment

All 20+ test cases passed. Pricing team signed off on logic accuracy. US sales team trained. Tool deployed to production.

Month 2–3 Post-Launch

Impact Measurement

Custom order closures increased from ~110 to ~142/month. Pricing team no longer on the critical path for any custom quote.

Custom orders closed / month

Before — manual quoting110
After — real-time calculator142

+32 orders/month — ~30% close-rate improvement

6

Results

~₹1.5Cr

Additional monthly revenue (32 incremental orders × $5,500 AOV × ₹85)

↑ From baseline monthly revenue

~30%

Improvement in custom order close rate (110 → 142 orders/month)

32 additional closed orders/month

1–2d→0

Quote turnaround — now generated real-time during customer calls

Pricing team removed from quote critical path

100%

Custom quotes generated without pricing team dependency post-launch

Full sales team autonomy on custom pricing

What I Learned

1

The biggest conversion lever is often in the sales process, not the product UI.

We spent time optimizing PDPs and checkout — rightfully — but a broken sales ops process was losing premium customers at the very last mile. Internal tooling can have higher ROI than customer-facing features.

2

Requirements quality determines build quality.

The most important sprint was Sprint 1 — documenting the pricing logic. Every error found during QA traced back to an edge case not captured in documentation. Investing time upfront saves multiples in rework.

3

Speed is a feature for high-consideration purchases.

Premium furniture buyers have high intent but fragile attention. A competitor with a faster, more confident sales experience wins. Removing friction from the sales process is product work.