Salesperson Summary for Forecast vs Ordered

    User:  -     5/15/24 07:30 PM



User Not Secured for this Application




Contact Info
    |     Consumer Website     |       e-Mail

Salesperson Monthly Forecast vs Ordered

    5/15/24  07:30 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
1,952
2,972
4,339
3,595
2,799
1,813
2,357
2,623
2,662
2,852
2,176
2,342
32,482
Order Qty
2,058
2,738
3,891
1,299
2,218
1,806
4,402
3,019
2,955
1,811
4,063
4,259
34,519
Ship Qty
2,623
2,762
1,881
1,690
2,961
1,413
3,465
1,986
3,664
2,733
1,079
5,517
31,774
F/c Value
$71,108
$107,746
$158,173
$129,514
$100,034
$64,687
$84,686
$94,046
$96,681
$104,223
$80,008
$85,415
$1,176,321
Ship Value
$86,245
$71,464
$59,812
$65,105
$93,642
$53,867
$120,629
$69,982
$117,175
$103,579
$41,332
$196,345
$1,079,177
 
 
 
 
 
 
 
 
 
 
 
F/c Qty
154
172
196
197
196
134
184
204
227
248
201
202
2,315
Order Qty
305
0
481
0
471
282
0
302
544
0
0
131
2,516
Ship Qty
292
13
481
0
360
393
0
87
672
57
30
131
2,516
F/c Value
$4,944
$5,535
$6,654
$6,672
$6,725
$4,296
$5,888
$6,540
$7,242
$7,912
$6,522
$6,452
$75,382
Ship Value
$8,672
$377
$14,010
$0
$10,656
$12,642
$0
$2,629
$21,070
$1,718
$1,346
$2,988
$76,108
F/c Qty
753
1,085
1,892
1,548
1,049
660
851
963
1,118
1,136
855
947
12,857
Order Qty
0
708
1,568
0
93
777
1,158
1,127
1,393
1,196
2,736
1,656
12,412
Ship Qty
51
708
196
0
1,208
257
1,727
898
1,345
1,428
131
3,927
11,876
F/c Value
$23,616
$33,437
$59,967
$49,641
$33,442
$21,250
$27,096
$30,669
$35,774
$36,405
$27,643
$30,294
$409,234
Ship Value
$2,246
$22,355
$5,574
$0
$37,819
$12,019
$59,704
$32,433
$40,539
$52,742
$5,670
$136,549
$407,650
F/c Qty
190
240
278
335
336
212
276
292
236
264
193
225
3,077
Order Qty
152
167
206
258
295
235
256
225
271
145
202
141
2,553
Ship Qty
170
111
226
137
261
180
151
134
150
194
150
111
1,975
F/c Value
$8,938
$11,001
$12,914
$14,594
$14,292
$9,035
$11,942
$12,762
$11,033
$12,430
$9,064
$10,402
$138,407
Ship Value
$7,199
$4,893
$9,788
$6,345
$11,159
$8,046
$6,731
$5,683
$6,496
$9,247
$7,012
$4,802
$87,401
F/c Qty
109
153
181
255
246
170
195
217
134
153
106
119
2,038
Order Qty
0
1,245
369
84
301
39
469
81
0
192
0
0
2,780
Ship Qty
0
1,245
285
84
301
39
56
206
81
192
0
0
2,489
F/c Value
$1,766
$2,443
$2,907
$4,213
$4,002
$2,836
$3,217
$3,582
$2,150
$2,470
$1,698
$1,912
$33,196
Ship Value
$0
$19,530
$6,734
$1,360
$6,051
$739
$651
$5,798
$2,283
$5,248
$0
$0
$48,394
F/c Qty
746
1,322
1,792
1,260
972
637
851
947
947
1,051
821
849
12,195
Order Qty
1,601
796
1,267
957
1,058
473
2,519
1,284
747
278
1,125
2,331
14,436
Ship Qty
2,110
863
693
1,469
831
544
1,531
661
1,416
862
768
1,348
13,096
F/c Value
$31,844
$55,330
$75,731
$54,394
$41,573
$27,270
$36,543
$40,493
$40,482
$45,006
$35,081
$36,355
$520,102
Ship Value
$68,127
$29,580
$23,703
$57,399
$27,954
$20,418
$53,540
$23,437
$46,786
$34,622
$27,303
$52,005
$464,874

Contact Info
    |     Consumer Website     |       e-Mail