As per a prior post I'm tracking Priceline sales. All revenue...

As per a prior post I'm tracking Priceline sales.
All revenue quoted is Priceline revenue,not CDY revenue
While the system allows I will collate the data and publish every 30 days.

Assumptions and parameters:
(1) A decrement in stock level is assumed to be consumer sales, not stock transfers to stores.

(2) When stock levels have increased average consumption has been used as the actual consumption is unknown.

(3) Stock-levels determined by ordering to stock-out levels.

	Column 1	Column 2	Column 3	Column 4
0	Item	Product	Total Usage
1	1	Womens Shampoo	195	21%
2	2	Mens Shampoo	90	10%
3	3	Womens pack	27	3%
4	4	Mens Tonic	152	17%
5	5	Womens Tonic	444	49%
6		Total units	908
7
8		Sales Value		$   48,610.00
9		Days		29
10		Annualised		$ 611,815.52