Salesperson Summary for Forecast vs Ordered

    User:  -     5/18/24 12:24 PM



User Not Secured for this Application




Contact Info
    |     Consumer Website     |       e-Mail

Salesperson Monthly Forecast vs Ordered

    5/18/24  12:24 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
5,342
6,642
9,668
9,267
8,857
5,913
7,804
7,233
5,361
6,453
5,787
5,736
84,063
Order Qty
4,010
4,055
6,554
11,229
12,776
9,044
8,083
6,537
6,898
12,106
2,986
14,267
98,545
Ship Qty
4,806
4,058
6,571
12,490
10,983
9,888
9,254
3,576
9,653
8,415
6,198
12,133
98,025
F/c Value
$189,739
$229,226
$333,702
$315,422
$304,399
$208,770
$273,291
$259,090
$190,929
$227,934
$201,433
$200,924
$2,934,859
Ship Value
$116,590
$112,180
$183,061
$344,888
$307,683
$263,687
$245,074
$90,332
$252,052
$252,368
$151,040
$371,231
$2,690,186
 
 
 
 
 
 
 
 
 
 
 
F/c Qty
765
783
1,000
1,828
1,977
1,028
1,342
1,271
680
790
769
753
12,986
Order Qty
1,010
499
860
858
1,059
800
1,137
934
906
1,156
523
494
10,236
Ship Qty
884
565
682
966
836
805
810
809
726
926
432
420
8,861
F/c Value
$31,281
$31,736
$40,555
$62,497
$68,677
$40,264
$53,028
$50,022
$27,880
$32,552
$32,389
$31,709
$502,590
Ship Value
$36,210
$23,080
$29,115
$38,877
$32,567
$32,846
$30,408
$34,252
$30,457
$40,206
$18,889
$18,392
$365,299
F/c Qty
1,686
2,309
3,545
2,610
2,227
1,887
2,406
2,088
1,799
2,179
2,042
2,051
26,829
Order Qty
0
2,109
3,407
6,832
2,242
2,917
1,424
2,468
3,164
1,169
1,869
5,948
33,549
Ship Qty
393
1,940
3,390
6,916
1,959
2,881
1,666
150
5,197
1,314
1,574
5,836
33,216
F/c Value
$52,150
$71,532
$111,290
$83,576
$70,460
$56,739
$71,998
$67,008
$57,011
$68,477
$63,882
$65,064
$839,187
Ship Value
$13,045
$60,246
$106,271
$212,182
$57,380
$87,820
$52,463
$4,856
$153,241
$42,151
$52,554
$178,871
$1,021,080
F/c Qty
2,631
2,671
3,220
3,400
3,883
2,833
3,569
3,392
2,717
3,267
3,522
3,513
38,618
Order Qty
2,950
1,447
2,137
2,579
1,621
5,327
2,698
3,135
2,828
4,386
594
2,397
32,099
Ship Qty
3,283
1,553
2,349
3,769
2,599
4,571
3,353
2,617
3,645
1,226
3,738
1,287
33,990
F/c Value
$52,054
$51,388
$62,630
$64,446
$74,657
$54,383
$69,755
$65,961
$53,831
$65,354
$70,807
$70,574
$755,840
Ship Value
$62,818
$28,853
$42,099
$66,650
$47,603
$83,067
$60,212
$51,223
$65,077
$23,690
$66,268
$23,791
$621,351
F/c Qty
1,421
2,218
3,492
2,682
1,799
1,275
1,813
1,957
1,472
1,822
698
705
21,354
Order Qty
50
0
150
960
7,854
0
2,824
0
0
5,395
0
5,428
22,661
Ship Qty
246
0
150
839
5,589
1,631
3,425
0
85
4,949
454
4,590
21,958
F/c Value
$44,015
$70,892
$109,821
$85,528
$56,289
$39,923
$56,429
$61,021
$45,889
$56,659
$21,265
$21,816
$669,547
Ship Value
$4,516
$0
$5,574
$27,178
$170,131
$59,952
$101,990
$0
$3,275
$146,319
$13,327
$150,176
$682,438
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
376
405
481
414
493
378
477
503
419
493
394
373
5,206
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
$18,055
$19,303
$22,811
$19,719
$23,724
$18,246
$22,116
$22,734
$19,628
$22,962
$15,515
$14,714
$239,527
Ship Value
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Contact Info
    |     Consumer Website     |       e-Mail