Salesperson Summary for Forecast vs Ordered

    User:  -     5/14/24 05:32 PM



User Not Secured for this Application




Contact Info
    |     Consumer Website     |       e-Mail

Salesperson Monthly Forecast vs Ordered

    5/14/24  05:32 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
7,668
10,800
14,027
12,144
10,243
6,899
8,964
10,404
10,394
11,231
8,256
9,298
120,328
Order Qty
6,976
16,756
14,838
7,874
17,043
10,342
7,448
8,944
15,681
4,953
7,845
9,832
128,532
Ship Qty
7,586
13,568
14,667
8,097
16,549
10,816
8,517
6,011
17,361
7,496
5,219
12,050
127,937
F/c Value
$223,440
$314,740
$422,192
$357,929
$298,793
$202,914
$264,515
$302,096
$309,540
$334,324
$248,350
$276,920
$3,555,753
Ship Value
$192,488
$372,622
$449,625
$239,034
$458,506
$296,752
$261,539
$206,651
$538,287
$245,949
$173,094
$448,038
$3,882,585
 
 
 
 
 
 
 
 
 
 
 
F/c Qty
1,366
1,597
2,003
1,811
1,764
1,170
1,597
1,787
2,006
2,109
1,680
1,797
20,687
Order Qty
901
1,601
4,234
0
3,285
312
2,426
1,955
4,768
0
1,119
406
21,007
Ship Qty
1,039
1,601
4,075
146
2,974
603
2,224
774
4,901
1,252
920
346
20,855
F/c Value
$43,754
$51,334
$65,730
$59,350
$57,269
$38,229
$52,043
$58,110
$64,668
$68,815
$54,730
$58,118
$672,150
Ship Value
$29,199
$48,281
$116,572
$4,224
$88,341
$17,951
$70,292
$24,200
$147,319
$39,760
$30,335
$12,482
$628,956
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,457
2,722
4,399
3,165
1,983
1,309
1,697
1,912
2,343
2,309
1,732
1,961
26,989
Order Qty
148
5,773
5,417
2,083
1,401
2,179
893
1,415
1,650
1,242
3,036
5,939
31,176
Ship Qty
148
3,801
5,717
2,694
3,272
1,325
1,408
1,748
1,751
1,290
119
8,205
31,478
F/c Value
$50,602
$88,191
$145,315
$109,526
$70,039
$47,866
$60,576
$68,071
$81,085
$80,996
$61,116
$68,310
$931,693
Ship Value
$6,720
$141,612
$211,913
$119,992
$136,360
$44,816
$49,352
$64,304
$59,901
$45,396
$4,427
$320,399
$1,205,192
F/c Qty
1,816
1,937
2,324
2,405
2,238
1,549
2,142
2,401
2,333
2,658
1,932
2,218
25,953
Order Qty
1,910
2,605
2,035
1,125
4,490
2,975
2,341
2,960
4,610
1,756
1,055
2,037
29,899
Ship Qty
1,740
2,717
1,053
1,790
3,424
2,915
2,092
1,954
6,324
1,742
2,151
2,087
29,989
F/c Value
$53,315
$56,761
$67,617
$69,797
$66,524
$45,377
$63,014
$70,782
$68,599
$78,390
$57,389
$65,637
$763,202
Ship Value
$53,608
$79,098
$30,437
$51,094
$92,452
$94,930
$60,981
$67,931
$190,466
$55,576
$75,372
$65,909
$917,854
F/c Qty
2,412
3,196
3,582
3,705
3,319
2,283
2,768
3,464
2,864
3,221
2,238
2,568
35,620
Order Qty
3,035
5,312
2,883
4,666
6,865
4,684
715
1,401
2,358
1,556
1,132
945
35,552
Ship Qty
3,587
5,183
2,277
3,461
6,197
5,474
1,786
565
2,335
2,387
844
722
34,818
F/c Value
$47,711
$61,315
$69,770
$71,857
$62,912
$44,648
$54,793
$67,451
$57,188
$64,186
$44,655
$51,175
$697,661
Ship Value
$63,671
$94,860
$41,574
$63,553
$115,592
$117,092
$40,667
$17,075
$68,882
$69,205
$24,277
$21,047
$737,495
F/c Qty
617
1,348
1,719
1,058
939
588
760
840
848
934
674
754
11,079
Order Qty
982
1,465
269
0
1,002
192
1,073
1,213
2,295
399
1,503
505
10,898
Ship Qty
1,072
266
1,545
6
682
499
1,007
970
2,050
825
1,185
690
10,797
F/c Value
$28,058
$57,139
$73,760
$47,399
$42,049
$26,794
$34,089
$37,682
$38,000
$41,937
$30,460
$33,680
$491,047
Ship Value
$39,287
$8,769
$49,128
$169
$25,759
$21,961
$40,246
$33,138
$71,717
$36,010
$38,680
$28,200
$393,064

Contact Info
    |     Consumer Website     |       e-Mail