The attached template provides the basis for product portfolio analysis as follows:

- key statistics: total, average, median, standard deviation (total and by feature)
- variance analysis: price, mix and volume effects (total and by feature)

- building trends

- analyzing and forecasting seasonalities

- measuring historic volatilities and translating them into model scenarios with a desired level of confidence

- ascribing volatilities to a timeline, measuring standard error