Pricing Workbench
- What it is
A live pricing analysis application with three modules that run in order: a revenue and margin forecast for bundle and subscription price changes, a research module that measures the assumption the forecast depends on most, and a volume, mix, and price variance model for forecast misses.
- What I built
Every formula is on screen: each result appears as a row of input fields with the operators between them. Each term is defined once, with a formula and a worked example. An automated test fails if a displayed formula and the calculation engine disagree. List prices are cited, and every other input is marked as an estimate until a study or real data replaces it.
The research module takes a pricing study from the decision through the readout: method choice, sample size and cost, the price ladder, a fielding tracker, response import and cleaning, results, and calibration. It supports Van Westendorp with the Newton-Miller-Smith purchase questions, Gabor-Granger, monadic price cells, structured interviews, and MaxDiff. Shares carry exact confidence intervals at any sample size, with a finite-population version when respondents come from a known list of accounts, and ranges on derived price points appear only once a group reaches 30 responses. The Van Westendorp calculations reproduce the R package pricesensitivitymeter on a fixture checked into the repository.
- Why it is built this way
It runs a pricing analysis as a loop: forecast the change, measure the assumption that decides it, launch, then split any miss into volume, mix, and price. The forecast's sensitivity step shows which assumption is worth paying to measure. Stated willingness to pay runs higher than real purchasing, so the study converts it with a calibration factor whose source is shown, then sends the result to the forecast labeled with its method, sample size, factor, and date. The module does not field surveys, and it never estimates churn, because a survey cannot measure it.