Forecasting & Inventory Worksheet
Distributor
Sales Trend Comparison (% vs YAG)
Actual Weeks
Forecast Weeks
Last 52
Last 8
Next 4
Next 8




Commodity
Calendar
Prior Year
Current Year Sales
Arrivals
Ending Inventory
Transfers
Other
wk
Monday
Date
Sales
Promo
Company
Forecast
Dist Act/
Forecast
Promo
Scheduled
SAQ
Requested
Actual/
Projected
  DOI  
DOI
Range
In
Out
Inventory
Variance
23 05/31 870 *
953 * 1,440

527   - 0 0 -959
24 06/07 1,150 *
1,021 * 1,315

2,261   - 0 0 1,440
25 06/14 860 *
699 * 0

2,162   - 0 0 600
26 06/21 829 *
1,087 * 1,440

1,914   - 0 0 -601
27 06/28 1,669 * 0 * 1,080

  -
28 07/05 1,039 * 977 * 1,560


  -

29 07/12 527 * 647 * 0 120
  11-17
30 07/19 1,115 * 1,179 * 0 960
  11-17
31 07/26 897 * 1,123 * 0 960
  11-17
32 08/02 912 * 872 * 0 960
  11-17
33 08/09 885 * 798 * 0

  -
34 08/16 949 * 1,206 * Green =Orders
Blue =Planned
35 08/23 1,174 * 1,282 *

XYZ Help: ned@csc.com
  Return to XYZ Distributors Home Page
July 7, 1999
All Rights Reserved | Copyright 1999 | Computer Sciences Corporation