Building BT’s Price Elasticity Tool
Excel to enterprise-ready web app through design, development, and data engineering
Building BT’s Price Elasticity Tool
Excel to enterprise-ready web app through design, development, and data engineering
The Challenge
BT used an Excel-based tool to forecast price sensitivity across products and competitors. The spreadsheet supported complex calculations but lacked scalability, interactivity, and a responsive interface.
The team needed a complete redesign—modern UI, robust backend infrastructure, and a performant web-based tool to visualize data simulations instantly.
The Solution
Topcoder delivered a complete tool modernization in three challenges:
A visual design challenge reimagined the Excel workbook into an intuitive UI across 13 user stories.
A frontend challenge built a responsive Angular web app integrated with API endpoints and dynamic chart visualizations.
A backend challenge generated over 620,000 pricing scenarios from Excel, storing the results in MongoDB and exposing them via a Flask-based API.
Challenges we ran:
• Price Elasticity Tool Design Challenge
• Price Elasticity - Frontend
• Price Elasticity - Data Generation and Backend API
3
Challenges
130
Participants
24
Submissions
The Impact
BT’s pricing teams now use an interactive, browser-based simulation tool that replaces manual spreadsheet workflows. Teams can:
Quickly simulate pricing strategies for products and competitors.
Visualize revenue, volume, and ARPU changes in real time.
Filter, compare, and export data across thousands of permutations.
Access consistent UI across desktop devices with built-in validation and guided workflows.
Reduce time-to-decision by eliminating reliance on offline tools and manual data merging.
This modernization supports faster analysis cycles, better collaboration across pricing and strategy teams, and a clearer view of market elasticity at scale.
Achieve high-quality outcomes with
Topcoder.
Achieve high-quality outcomes with Topcoder.