Make the PLC: A Free Excel Template

The product life cycle template for Excel – available for free download Often students want to graph multiple products onto the product life cycle using an Excel spreadsheet or some other charting approach. Perhaps surprisingly, this is sometimes awkward to produce easily, given the focus on the Excel spreadsheet to produce graphs rather than images. … Read more…

How to decompose market share: VIDEO

Market share can be decomposed into three components, namely: Penetration Share Share of Customer Usage Index The following video explains how these three components work together to calculate overall market share.

Calculating customer lifetime value on a step-by-step basis

Customer lifetime value is often called marketing’s golden metric. Certainly in most service industries, customer lifetime value would be a very important marketing metric. Customer lifetime value can be calculated quite simply at times, with a ballpark estimate. This may be appropriate for quick calculations and for general comments within a meeting, but is not … Read more…