Salesperson Summary for Forecast vs Ordered

    User:  -     5/15/24 07:23 AM



User Not Secured for this Application




Contact Info
    |     Consumer Website     |       e-Mail

Salesperson Monthly Forecast vs Ordered

    5/15/24  07:23 AM     User:

Salesperson Monthly Forecast vs Ordered

Download Excel    
Summary Year   
Select Forecast Type: Annual Revised Annual
Account or Warehouse: Key Account Warehouse


Salesman Type Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Ytd
F/c Qty
1
1
1
1
1
1
1
1
1
1
1
1
12
Order Qty
1
23
14
19
144
60
60
26
23
86
34
265
755
Ship Qty
3
22
10
18
76
128
55
35
4
42
59
84
536
F/c Value
$40
$40
$40
$40
$40
$40
$40
$40
$40
$40
$40
$40
$480
Ship Value
$120
$1,096
$379
$1,249
$4,604
$9,990
$2,804
$2,260
$213
$2,193
$3,147
$4,438
$32,493
 
 
 
 
 
 
 
 
 
 
 
F/c Qty
136
173
205
245
240
155
196
214
174
194
139
161
2,232
Order Qty
123
141
167
244
257
283
235
287
384
92
248
146
2,607
Ship Qty
142
100
192
125
230
182
135
97
207
96
163
118
1,787
F/c Value
$6,236
$7,796
$9,327
$10,580
$10,186
$6,606
$8,447
$9,291
$7,976
$8,930
$6,370
$7,325
$99,070
Ship Value
$5,593
$4,283
$7,876
$5,138
$9,395
$7,282
$6,240
$4,114
$8,236
$4,431
$7,218
$5,424
$75,230
F/c Qty
21
21
21
21
21
21
21
21
21
21
21
21
252
Order Qty
0
42
0
81
0
0
22
0
42
0
10
0
197
Ship Qty
33
0
37
66
15
0
22
0
42
0
0
10
225
F/c Value
$1,500
$1,500
$1,500
$1,500
$1,500
$1,500
$1,500
$1,500
$1,500
$1,500
$1,500
$1,500
$18,000
Ship Value
$2,162
$0
$2,131
$5,077
$977
$0
$1,322
$0
$2,474
$0
$0
$651
$14,794
F/c Qty
924
1,617
2,392
1,692
1,225
803
1,053
1,205
1,415
1,442
1,065
1,202
16,035
Order Qty
1,416
1,043
1,406
0
0
2,031
1,483
2,837
1,986
0
2,472
500
15,174
Ship Qty
1,429
125
909
1,259
152
1,865
1,351
1,684
1,044
2,131
2,026
1,088
15,063
F/c Value
$31,833
$54,992
$83,139
$59,720
$43,507
$28,572
$37,179
$42,194
$48,592
$50,137
$37,138
$41,677
$558,680
Ship Value
$49,045
$3,935
$28,180
$45,145
$4,551
$63,900
$48,758
$64,136
$33,378
$82,005
$67,444
$41,688
$532,165
F/c Qty
6
6
6
6
6
6
6
6
6
6
6
6
72
Order Qty
0
0
0
0
31
30
0
0
0
0
0
20
81
Ship Qty
6
0
0
0
31
30
0
0
0
0
0
20
87
F/c Value
$463
$463
$463
$463
$463
$463
$463
$463
$463
$463
$463
$463
$5,556
Ship Value
$379
$0
$0
$0
$2,287
$2,140
$0
$0
$0
$0
$0
$1,734
$6,540
F/c Qty
1,468
1,850
2,077
2,043
1,845
1,279
1,569
2,001
1,733
1,964
1,353
1,554
20,736
Order Qty
1,975
2,155
2,554
3,383
3,639
3,855
547
178
728
408
490
614
20,526
Ship Qty
2,691
2,074
1,940
2,049
3,768
4,038
1,641
47
962
537
427
421
20,595
F/c Value
$28,037
$34,697
$39,469
$38,737
$34,134
$24,323
$30,109
$37,831
$33,379
$37,734
$26,044
$29,860
$394,354
Ship Value
$51,431
$36,888
$34,857
$38,605
$67,329
$83,235
$38,273
$1,584
$29,740
$15,038
$11,964
$11,996
$420,940
F/c Qty
0
0
0
0
0
0
0
0
0
0
0
0
0
Order Qty
0
0
0
12
91
36
41
6
1
14
0
34
235
Ship Qty
0
0
0
12
43
84
33
12
3
10
0
18
215
F/c Value
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Ship Value
$0
$0
$0
$1,032
$3,131
$7,911
$1,947
$1,137
$153
$416
$0
$819
$16,546
F/c Qty
0
0
0
0
0
0
0
0
0
0
0
0
0
Order Qty
0
0
0
0
0
0
0
0
0
0
0
0
0
Ship Qty
0
0
0
0
0
0
0
0
0
0
0
0
0
F/c Value
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Ship Value
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Contact Info
    |     Consumer Website     |       e-Mail