Salesperson Summary for Forecast vs Ordered

    User:  -     5/13/24 04:23 PM



User Not Secured for this Application




Contact Info
    |     Consumer Website     |       e-Mail

Salesperson Monthly Forecast vs Ordered

    5/13/24  04:23 PM     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
2,676
4,031
6,234
5,417
3,894
2,579
3,228
3,753
3,696
3,916
2,839
3,190
45,453
Order Qty
2,077
6,392
6,843
1,981
3,966
3,777
4,825
2,082
4,176
2,672
4,502
4,126
47,419
Ship Qty
2,707
5,089
6,169
2,107
3,716
3,125
4,770
2,872
3,550
4,128
1,739
6,360
46,332
F/c Value
$74,770
$112,538
$187,333
$159,969
$108,526
$72,385
$90,596
$104,137
$106,759
$112,518
$82,591
$91,213
$1,303,335
Ship Value
$59,964
$145,068
$179,094
$47,676
$93,681
$87,329
$157,976
$95,415
$109,555
$135,101
$51,807
$221,881
$1,384,547
 
 
 
 
 
 
 
 
 
 
 
F/c Qty
2,141
3,553
6,255
4,855
3,013
1,927
2,483
2,826
3,263
3,307
2,459
2,752
38,834
Order Qty
0
5,421
8,304
0
984
3,522
3,240
3,138
3,601
3,432
6,041
4,988
42,671
Ship Qty
186
5,020
6,215
885
1,449
1,241
4,135
2,589
5,300
3,783
861
9,651
41,315
F/c Value
$67,035
$109,141
$199,292
$157,767
$97,655
$63,818
$80,358
$91,267
$104,350
$106,166
$78,679
$86,465
$1,241,993
Ship Value
$5,542
$163,822
$195,671
$31,905
$46,281
$46,308
$142,481
$85,264
$164,504
$129,224
$30,868
$336,373
$1,378,243
F/c Qty
40
49
59
66
66
40
56
58
49
59
41
48
631
Order Qty
28
31
30
40
69
35
59
57
79
36
74
22
560
Ship Qty
33
21
36
14
61
35
35
32
44
47
57
35
450
F/c Value
$1,860
$2,236
$2,760
$2,971
$2,892
$1,791
$2,497
$2,589
$2,252
$2,773
$1,904
$2,198
$28,723
Ship Value
$1,350
$926
$1,459
$618
$2,564
$1,511
$1,534
$1,334
$1,774
$2,079
$2,699
$1,467
$19,315
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
F/c Qty
673
1,001
1,919
1,565
887
571
748
884
1,049
1,078
799
902
12,076
Order Qty
1,315
1,538
80
0
1,061
752
0
1,164
1,761
0
0
1,460
9,131
Ship Qty
1,398
1,235
382
28
861
807
50
860
1,534
363
213
1,405
9,136
F/c Value
$23,473
$34,628
$68,488
$56,517
$31,494
$20,775
$26,749
$31,011
$36,433
$37,427
$27,913
$31,637
$426,545
Ship Value
$45,498
$40,611
$13,644
$1,355
$31,556
$28,394
$1,902
$30,151
$47,478
$13,895
$7,882
$48,564
$310,930
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
F/c Qty
1,049
1,395
1,578
1,722
1,582
1,111
1,334
1,599
1,261
1,425
986
1,123
16,165
Order Qty
1,304
1,700
1,666
1,941
2,304
1,067
365
97
573
865
386
792
13,060
Ship Qty
1,672
1,580
1,278
1,657
2,082
1,437
625
204
350
1,088
324
305
12,602
F/c Value
$20,543
$26,521
$30,397
$32,757
$29,363
$21,158
$25,709
$30,592
$24,883
$28,031
$19,417
$22,127
$311,498
Ship Value
$28,261
$28,545
$23,813
$29,805
$38,583
$26,324
$21,031
$6,085
$10,421
$31,077
$9,959
$9,191
$263,095
F/c Qty
232
366
606
500
337
207
270
301
301
331
247
268
3,966
Order Qty
745
851
0
0
842
867
2,556
0
1,292
0
608
773
8,534
Ship Qty
941
46
833
0
777
852
2,191
435
100
970
765
720
8,630
F/c Value
$9,704
$15,317
$26,255
$21,945
$14,140
$8,926
$11,507
$12,702
$12,696
$13,999
$10,617
$11,407
$169,215
Ship Value
$28,354
$1,909
$27,091
$0
$26,366
$29,758
$69,245
$15,184
$3,240
$32,592
$18,694
$25,302
$277,735

Contact Info
    |     Consumer Website     |       e-Mail