November 11, 2009

A Complex Pricing Model Made Easy by Excel (part 2)

We are now ready, having performed a historical analysis in part 1 of this post, to create a useful system for pricing. Depending on how comfortable you are with statistics and mathematical operations with standard deviations, you may or may not understand why the excel formulas are set up the way that they are. A full explanation of the mathematics is not our purpose here, however; we just want to

Read More
November 10, 2009

A Complex Pricing Model Made Easy by Excel (part 1)

Pricing is perhaps one of the hardest aspects of marketing to get right. And even though it’s impossible to keep control over and measure all of the variables involved, using analytics can help you track and predict enough of those variables so you can set the price where it needs to be. Here, we will outline an example of how to set up a pricing model for a service –

Read More