Home
 Annual Forecast
 Revised Forecast
 Sales Infor
 Inventory
 Order Information
 Accounts Receivable
 Admin
 Help
 Log Out

Salesperson Summary for Forecast vs Ordered

    User:  -     5/15/24 05:12 AM



User Not Secured for this Application




Contact Info    |     Consumer Website     |       e-Mail

Salesperson Monthly Forecast vs Ordered
Home
 Annual Forecast
 Revised Forecast
 Sales Infor
 Inventory
 Order Information
 Accounts Receivable
 Admin
 Help
 Log Out

    5/15/24  05:12 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
11,820
16,594
22,917
22,239
17,388
12,134
14,838
17,272
16,447
17,028
12,355
13,940
194,972
Order Qty
13,480
24,319
19,903
19,579
15,738
22,411
25,825
14,634
16,075
11,399
12,477
12,529
208,369
Ship Qty
12,916
18,679
20,458
11,839
17,655
20,475
13,907
18,852
16,997
15,255
8,071
15,420
190,524
F/c Value
$337,310
$477,295
$687,345
$666,758
$510,283
$358,994
$434,845
$502,298
$481,222
$492,895
$360,630
$403,942
$5,713,817
Ship Value
$354,245
$503,247
$596,616
$312,623
$493,644
$527,284
$406,718
$577,144
$532,420
$454,776
$240,623
$517,299
$5,516,639
 
 
 
 
 
 
 
 
 
 
 
F/c Qty
1,515
2,227
3,082
2,407
2,007
1,316
1,741
1,992
2,363
2,383
1,843
2,034
24,910
Order Qty
2,323
1,154
4,076
0
1,599
1,391
3,148
1,316
3,945
702
425
1,283
21,362
Ship Qty
2,089
1,380
3,737
223
1,713
704
2,387
1,985
4,269
946
241
1,340
21,014
F/c Value
$51,660
$75,114
$106,721
$84,687
$69,083
$46,719
$60,834
$69,288
$80,625
$82,310
$63,461
$69,502
$860,004
Ship Value
$62,683
$45,777
$114,757
$6,618
$52,324
$22,443
$83,467
$68,421
$135,151
$35,064
$9,039
$50,555
$686,299
F/c Qty
703
1,154
2,434
1,978
1,002
624
806
920
1,105
1,108
851
939
13,624
Order Qty
0
1,592
1,857
0
0
181
811
1,131
1,018
1,134
2,220
1,246
11,190
Ship Qty
128
934
755
0
980
0
1,521
215
1,846
1,164
333
3,228
11,104
F/c Value
$22,184
$35,382
$77,105
$64,385
$32,434
$20,626
$26,237
$29,745
$35,342
$35,539
$27,828
$30,095
$436,902
Ship Value
$4,267
$30,098
$23,582
$0
$31,721
$0
$48,972
$7,844
$56,518
$40,293
$12,048
$113,507
$368,850
F/c Qty
2,491
4,114
7,450
5,699
3,322
2,150
2,818
3,222
3,824
3,912
2,880
3,294
45,176
Order Qty
3,783
3,448
5,503
3,270
10,885
11,828
3,287
7,932
0
1,431
1,697
5,194
58,258
Ship Qty
3,550
3,512
5,122
0
11,422
12,190
4,057
6,859
3,255
1,655
1,733
3,467
56,822
F/c Value
$82,490
$133,715
$254,712
$198,219
$112,961
$73,767
$95,027
$108,073
$126,384
$130,565
$96,876
$109,692
$1,522,481
Ship Value
$107,079
$103,860
$163,252
$0
$388,291
$415,325
$162,886
$219,588
$102,738
$64,933
$55,903
$140,208
$1,924,063
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,590
2,365
4,313
3,491
2,304
1,435
1,845
2,099
2,597
2,524
1,923
2,160
28,646
Order Qty
1,227
3,637
2,841
0
184
3,852
6,277
2,040
2,945
1,014
2,916
1,050
27,983
Ship Qty
1,495
2,944
3,021
487
229
1,533
4,167
2,917
5,155
1,548
2,537
1,263
27,296
F/c Value
$53,446
$78,587
$149,635
$122,546
$79,945
$50,424
$63,782
$72,176
$87,533
$86,115
$65,632
$72,999
$982,820
Ship Value
$50,249
$94,742
$98,596
$21,410
$7,341
$51,403
$131,200
$102,220
$163,741
$58,971
$72,371
$50,354
$902,598
F/c Qty
4,837
6,719
8,170
8,071
6,787
4,265
5,527
6,234
6,234
6,910
4,856
5,527
74,137
Order Qty
3,776
5,361
4,752
10,159
6,362
8,328
12,598
7,593
5,669
5,380
4,353
5,957
80,288
Ship Qty
2,837
3,403
6,385
6,121
5,738
10,343
2,639
11,887
2,066
8,967
3,134
6,322
69,842
F/c Value
$131,557
$188,378
$228,166
$224,963
$190,550
$116,567
$150,330
$169,631
$169,631
$187,946
$132,180
$150,330
$2,040,229
Ship Value
$76,898
$90,139
$175,004
$152,500
$156,706
$290,709
$65,839
$340,546
$55,711
$240,203
$86,261
$188,650
$1,919,166
F/c Qty
459
522
635
1,902
1,531
1,837
1,695
2,076
873
440
324
357
12,651
Order Qty
2,400
5,553
2,090
5,399
2,810
1,039
105
1,132
1,545
995
2,210
1,700
26,978
Ship Qty
2,250
2,920
3,322
1,998
4,926
346
120
180
1,966
588
1,210
2,436
22,262
F/c Value
$17,283
$19,994
$24,311
$68,535
$55,904
$65,891
$61,277
$74,623
$33,144
$17,438
$12,778
$14,304
$465,482
Ship Value
$79,266
$102,855
$116,361
$69,832
$172,123
$11,756
$4,077
$5,925
$68,953
$20,430
$42,429
$85,364
$779,371
F/c Qty
2,204
2,934
3,259
3,435
3,059
2,190
2,622
3,270
2,611
2,930
2,034
2,338
32,886
Order Qty
3,349
6,209
3,697
3,936
4,753
7,268
2,611
554
865
2,012
264
708
36,226
Ship Qty
3,727
6,265
2,718
2,855
4,039
7,199
2,896
1,376
1,062
2,028
341
316
34,822
F/c Value
$42,202
$54,730
$61,616
$64,427
$56,288
$41,289
$49,994
$61,600
$50,447
$56,536
$39,253
$45,050
$623,432
Ship Value
$68,789
$111,516
$50,348
$56,313
$70,997
$140,043
$65,239
$41,744
$32,400
$59,306
$9,787
$9,371
$715,853
F/c Qty
512
673
1,024
955
698
467
602
681
664
733
524
585
8,118
Order Qty
405
635
590
85
30
352
275
868
88
162
89
585
4,164
Ship Qty
390
655
520
155
30
350
177
292
633
14
275
515
4,006
F/c Value
$18,978
$25,110
$39,791
$37,215
$26,079
$17,478
$22,391
$25,235
$24,500
$27,011
$19,498
$21,662
$304,948
Ship Value
$12,090
$22,844
$17,965
$5,947
$2,430
$10,928
$7,921
$10,442
$19,943
$506
$8,685
$19,496
$139,197

Contact Info    |     Consumer Website     |       e-Mail