Salesperson Summary for Forecast vs Ordered

    User:  -     5/18/24 09:17 AM



User Not Secured for this Application




Contact Info
    |     Consumer Website     |       e-Mail

Salesperson Monthly Forecast vs Ordered

    5/18/24  09:17 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
3
18
19
19
11
10
11
11
11
11
10
10
144
Order Qty
1,416
3,445
2,197
3,987
3,565
2,428
3,620
1,692
1,951
2,613
3,844
3,391
34,149
Ship Qty
2,368
3,107
2,236
4,400
2,284
3,084
3,391
2,085
1,478
2,541
3,871
3,130
33,975
F/c Value
$0
$544
$544
$544
$272
$272
$272
$272
$272
$272
$272
$272
$3,808
Ship Value
$79,012
$98,144
$71,873
$128,834
$71,746
$97,081
$107,656
$64,937
$48,961
$85,088
$122,006
$95,655
$1,070,993
 
 
 
 
 
 
 
 
 
 
 
F/c Qty
116
109
125
116
131
108
131
124
117
132
191
182
1,582
Order Qty
0
376
0
618
206
0
411
0
0
278
249
0
2,138
Ship Qty
0
376
0
618
177
26
414
0
0
0
527
0
2,138
F/c Value
$3,238
$3,075
$3,477
$3,238
$3,622
$3,043
$3,622
$3,445
$3,270
$3,654
$5,446
$5,173
$44,303
Ship Value
$0
$10,537
$0
$17,351
$5,478
$736
$11,907
$0
$0
$0
$15,429
$0
$61,438
F/c Qty
743
831
1,302
987
878
615
910
856
764
918
913
904
10,621
Order Qty
0
961
736
571
857
663
1,293
818
671
1,126
2,607
1,684
11,987
Ship Qty
116
1,038
375
957
57
1,338
1,318
796
739
1,120
2,223
2,147
12,224
F/c Value
$22,955
$25,424
$40,383
$30,991
$27,142
$19,175
$28,040
$27,503
$23,975
$28,469
$28,405
$28,151
$330,613
Ship Value
$3,294
$33,579
$11,638
$27,810
$2,045
$38,857
$41,331
$23,320
$22,652
$37,138
$70,050
$65,086
$376,800
F/c Qty
246
268
346
593
633
362
466
455
214
237
239
230
4,289
Order Qty
362
121
282
359
384
317
397
278
291
393
167
103
3,454
Ship Qty
302
133
244
367
291
311
274
273
265
333
124
109
3,026
F/c Value
$10,708
$11,394
$14,681
$21,815
$23,644
$14,749
$19,207
$18,604
$9,450
$10,622
$10,793
$10,425
$176,092
Ship Value
$12,866
$5,907
$10,783
$14,621
$11,605
$12,834
$10,905
$11,879
$11,652
$14,781
$5,564
$4,892
$128,289
F/c Qty
141
186
208
250
272
185
218
203
137
158
191
191
2,340
Order Qty
0
556
0
259
84
309
408
212
39
125
39
0
2,031
Ship Qty
39
255
301
259
84
309
408
212
39
115
49
0
2,070
F/c Value
$2,714
$3,381
$3,826
$4,508
$5,001
$3,460
$4,158
$3,841
$2,650
$3,124
$3,630
$3,630
$43,923
Ship Value
$739
$4,057
$6,051
$4,303
$1,360
$5,703
$5,833
$3,307
$739
$3,546
$1,047
$0
$36,685
F/c Qty
553
579
882
700
685
495
673
608
540
682
405
404
7,206
Order Qty
1,054
1,431
1,179
2,180
2,034
1,139
1,111
384
950
691
782
1,604
14,539
Ship Qty
1,911
1,305
1,316
2,199
1,675
1,100
977
804
435
973
948
874
14,517
F/c Value
$20,188
$21,187
$32,885
$26,105
$25,171
$18,649
$24,337
$22,105
$20,073
$24,826
$14,855
$15,158
$265,539
Ship Value
$62,111
$44,062
$43,398
$64,747
$51,255
$38,949
$37,677
$26,429
$13,916
$29,621
$29,914
$25,676
$467,755

Contact Info
    |     Consumer Website     |       e-Mail