KRISPY ANALYTICS

Chris is a business analyst who likes to practice data modeling in her free time.

She particularly enjoys building analytical models to achieve marketing objectives. For example: clustering models for auto segmentation, propensity models for customer lifetime value predictions, and attribution models for channel evaluations.

This is a blog for Chris to practice her analytical skills and connect with like-minded people.

All in Pricing

Jan 28

Jan 28 Price Bundling with Excel

Kristopia

Pricing

Today we’ll be building this model using a sample dataset mobilecarrier.xls, it gives the amount 77 representative are willing to pay per month for each service. The key to this model is to set up a spreadsheet that tells me, for any set of prices for each possible product combination, how much revenue we can obtain from this sample of customers. Then we’ll will use the Solver plug-in to determine the set of prices for the product combinations that maximizes the revenue.