Tag: demand fulfillment

May 14, 2009   Posted by: Roy Marsten

What is sales history, exactly?

We often talk about the sales history of a product, so let’s explain exactly what it means. There is a raw sales history and a collapsed sales history. The sales history, raw or collapsed, is the starting point for all the analytics we will be introducing later.

Raw sales history

A product is a collection of features, where each feature has a set of mutually exclusive options (one of which may be “no,”  “none” or “none of the above”). A sales history consists of a record for each unit of the product that has been sold, with a list of the options that were included. Since each record is for a specific unit, there may be a serial number feature. So imagine a table with a row for each unit sold and a column for each feature. The entries in a column are the different option choices for the corresponding feature. Blank cells indicate a “none” choice.

salesorders1

continue reading »

Comments Off