 |
 |
||
| Inventory Manager | |||
 |
|
|
|
| Analyze by Product | Analyze by Customer | Seller Data Load | Configure | |
 |
|
 Show
Tools |
Analyze Inventory Performance
by Customer History
|
|
|
||
| Customer | McClouds | |
| Brand | Top Shelf Scotch Whiskey | |
|
1 2 3 4 5 6 7 8 9 ...
|
|||||||||
|
Period
Ending |
Opening
Inventory |
Seller
Shipments |
Distributor
Shipments |
Computed
Ending Inventory |
Actual
Ending Inventory |
Actual
+/- |
% +/-
|
Turns
|
Annual
Turns |
|
05/31/02
|
100
|
160
|
85
|
175 |
170
|
(5)
|
(3.0)
|
0.63
|
7.56
|
|
06/30/02
|
170 | 0 |
93
|
77 |
70
|
(7)
|
(9.0)
|
0.78
|
9.30
|
|
07/31/02
|
70 | 185 |
91
|
164 |
154
|
(10)
|
(6.0)
|
0.81
|
9.75
|
|
08/30/02
|
154 | 0 |
89
|
65 |
61
|
(4)
|
(6.0)
|
0.83
|
9.93
|
|
09/30/02
|
61 | 145 |
84
|
122 |
115
|
(7)
|
(6.0)
|
0.95
|
11.45
|
|
10/31/02
|
115 | 80 |
92
|
103 |
94
|
(9)
|
(9.0)
|
0.88
|
10.56
|
|
Totals
|
534
|
|
4.89
|
9.79
|
|||||