← Work
Pricing · Scenario analysis
Pricing model for 100+ prices
A membership and events business needed one model for pricing and budget planning.
WorkPricing model and scenario analysis
Built inExcel
Review5.0 on Upwork
Sanitized pricing model visual
Project
One place for pricing.
The client used several pricing sources across memberships, events and other paid offers.
The model needed to support the questions raised during budget planning and show how pricing changes affected modeled revenue.
Model
Pricebook and scenarios.
Pricebook
More than 100 prices in one model.
Scenarios
Pricing assumptions can be changed and compared.
Revenue
The modeled revenue result updates with the scenario.
Workbook views will be added here
Result
Finished model.
The client could change pricing assumptions and compare the modeled result before making a pricing decision.
The Upwork review highlighted the simplified pricebook and scenario planner.
Public version
Client data removed.
The public screenshots will show the structure of the model. Client data and identifying details will be removed.