Reports_img1.gif Reports
Forecast-Replenish generates various reports.  The main reports are the Summary report, Long report, Short report, Specific report and Parameter report. 

Summary Report
The Summary report includes tallies on all parts processed.   The tallies are mostly in dollars and often are listed in $1,000s.   The data reported here are h1 = the oldest 12 months of demand history and h2 = most recent 12 months of history.  The most current monthly demand is in row h2 column 12.  The row labeled f1 lists the 12 monthly forecasts where the first entry is for future month 1.  The row with rls lists the 12 future projected release quantities and the row labeled cr is the current release.
The parts are partitioned into seven mutually exclusive categories and listed in the bottom portion of the table.  These categories are listed as follows:  Low Inv. = parts with on-hand plus on-order below the order point.  High OO = parts with on-order > 0 and the on-hand plus on order exceeds the order level plus the first months forecast.  Surp Inv = parts whose on-hand plus on-order inventory exceeds the 12 month forecast plus the order level. Rels Mo1. = parts with a release in month 1.   Rel Mo2 = parts with the first release in month 2.  Other = all other parts. 
For each category, various aggregate entries are listed as follows:   # Pns = number parts.  Demand of history years 1 and 2 and forecast for future year 1. On- hand and on-order inventory.  Releases for future months 1 and 2.  Amount of inventory for Low inventory, High on-order and  Surplus.  The measures of the service level where c = current service level and p = planned service level.  End OH and OO = projected on-hand and on-order inventory after 12 months.

        Summary Report  ($000)

Mo......1.......2.......3.......4......5.......6.......7.......8...... 9......10......11......12       sum  
h1      2302    2460    2725    2820   3210    3378    3702    3691    3746   3752    3576    3512     38880
h2      3450    3666    3863    4125   4512    4787    5147    5122    5173   5113    4840    4841     54646
f1 .    4696    4882    4897    4901   4923    4929    4946    4954    4981   4983    5002    5015     59113
rls     6344    3419    3828    4096   4358    4383    4566    4673    4624   4775    4838    4908     54817
cr      4189

                                                                                                     Service
                        demand  forecast    On        On        release                               Level
        #Pn's     year 1 year 2  year 1    Hand     Order     Mo.1   Mo.2      Lo      Hi   Surp       c     p
Low Inv  2475   11437.2 17131.1 19356.4    452.2     297.5   4525.6 1531.8  275.1     0.0    0.0    0.38  0.95
High OO  2002    8345.7 10923.9 11279.4   5694.2    2764.0      0.0    4.6    0.0  1910.6 1058.0    1.00  0.95
Surp Inv  241     738.2   667.8   492.8   1165.6       6.1      0.0    0.0    0.0     0.0  494.7    1.00  0.95
Rels Mo1 1663    7347.7 10832.9 12124.3   1282.6     369.4   1818.4  736.6    0.0     0.0    0.0    0.82  0.95
Rel Mo2  1141    5138.6  7379.2  8085.5   1415.8     380.6      0.0 1146.2    0.0     0.0    0.0    0.98  0.95
Other    1855    5872.6  7711.6  7774.6   3595.6     308.5      0.0    0.0    0.0     0.0    0.0    0.99  0.95
Sum      9377   38880.2 54646.6 59113.2  13606.2    4126.4   6344.0 3419.3 1275.1  1910.6 1552.7    0.76  0.95
End OH, OO                                8528.1    4908.5
         
Long part report
The long part number report lists the input data and calculations associated with each part number.  Eight part numbers are printed on a page.  The data includes the part number code pn and description pnd, the supplier code sc, the cost per unit c, the on-hand oh, on-order inventory oo, lead time lt, number months history nmh, additional cost per order aco, multiple mult, and sets of (q,c) quantity and costs for price break data. When the part number is coded as a critical part, the notation cp is printed.  Also listed are 24 months of demand history (h1 and h2), 12 months of forecasts f1 and projected releases rls.  When a seasonal forecast model is selected, an s is printed just to the right of f1, the year-one forecasts, and so becomes f1 s.  Also, an o indicates that other requirements are used and an a indicates the same for advance demands.  The current release cr is a replenishment needed  now, the month 1 release is needed during month 1, and the releases for months 2 to 12 are for planning purposes by the management and perhaps by the supplier.

pn
sc
c
oh
oo
cr
lo
hi
srpl
op
ol
cov
slp
lt
nmh
RB134-   2
x032
47.480
20
8
0
0
0
0
17
35
0.21
0.95
1.00
24
ROLLER HANDLE     aco = 0.00  mult = 1   (q,c) (1, 47.48)  (cp)

Mo.
1
2
3
4
5
6
7
8
9
10
11
12
sum
h1
4
6
7
5
5
12
6
7
11
20
8
  12
103
h2
18
13
14
11
18
16
11
18
15
12
14
  16
176
f1
16
18
17
18
18
18
19
19
20
19
20
  20
222
rls
0
24
18
18
18
19
19
20
19
20
20
  21
216


In addition, the long report gives calculated quantities on low inventory lo,  high on-order hi, surplus inventory srpl, the coefficient of variation cov and the planned service level slp.  Further, the report lists the order-point op and order- level ol  for future month 1.  In essence, when the on-hand plus on-order inventory falls to  the order-point or below, the replenishment release quantity should bring the on-hand plus on-order up to the order-level quantity.
When the promotion forecast model is active and promotion history data is available for a part and location, the long promotion report can be printed.  This report contains all the data in the long report plus all 36 promotion entries (history and plan).

Specific part report
This report is like the long report, but also lists all of the part number data -- the other requirements, advance demands, pieces per order, safety stock and safety time stock.   The user enters the part number and the report is printed for all locations that carry the part. 

Short part report
The short part number report lists pertinent inventory data for each part number.  About 60 part numbers are printed on one- page.  For every part number, the part number code pn, description pnd and supplier code sc are listed.  Also the cost per unit c, the sum demand from each of the 2 history years h1 and h2, and the corresponding sum for the forecast year f1 is printed.  Further, the on-hand oh, on-order oo, release for future month 1 rl1 and for future  month 2  rl2 are given.  In addition, the amount of low-inventory lo, high on-order hi, and surplus inventory srpl are shown.  Finally, the order-point op and order-level ol are listed. 

pn
pnd
sc
c
h1
h2
f1
oh
oo
rl1
rl2
lo
hi
srpl
op
ol
M12201
MX- SHAFT
00001
21.00
0
31
24
5
0
0
0
0
0
0
2
11
M122800
M- SWITCH
00001
51.40
0
39
45
48
0
0
0
0
0
0
6
13
M124000
DAMPER
00001
68.00
0
100
83
0
0
24
0
14
0
0
14
24
M134010
DAMPER 1/2
00001
76.00
0
29
24
1
0
6
0
1
0
0
2
7
M144025
DIAFRAME 3/4
00001
26.25
0
1
1
1
0
0
0
0
0
0
0
1
N14428
BOLT 24
00001
3.34
0
1
1
4
0
0
0
0
0
3
0
1
N14650
FASTENER
00001
15.75
31
113
128
14
0
0
30
0
0
0
11
33
P12328
GALLON SIZER
00011
44.02
230
428
491
22
12
49
39
11
0
0
45
83
P1248/PS
PROTRACTOR-     SW
00011
29.22
51
843
1472
86
90
0
164
0
0
0
123
230
P135128
OMITRON
00011
115.56
0
5
8
8
0
0
0
0
0
0
0
3
01950
KEY CASE 111
00002
6.45
90
136
160
3
0
51
0
12
0
0
15
54
01952
ROLL HOSE 2/4
00002
8.00
139
228
240
84
0
0
0
0
0
0
48
92
01000
RAISER GAUGE
00002
20.40
93
145
181
12
20
0
0
0
0
0
13
36
01115
PAD MODIFIED 2
00002
5.56
7
13
14
12
0
0
0
0
0
0
1
14
01116
PAD MODIFIED 3
00002
5.56
506
347
176
30
0
0
61
0
0
0
21
76
01117
PAD MODIFIED 4
00002
5.56
331
235
208
55
0
0
0
0
0
0
23
74
01118
PAD MODIFIED 5
00002
5.56
53
17
6
22
0
0
0
0
0
13
0
6
01126
LEVER
00002
8.82
73
70
71
1
20
0
0
0
0
0
6
30
02127
LEVER 2
00002
8.82
451
307
253
47
0
0
49
0
0
0
26
74
02128
SUCKER LIFT
00002
105.84
15
13
12
3
0
0
0
0
0
0
1
4
03143
TAPE HOLDER 1/2
00002
7.85
18
13
11
8
0
0
0
0
0
0
1
10
03145
TAPE HOLDER 2 S
00002
7.85
93
458
678
0
620
0
0
0
273
0
222
294
04146
TAPE HOLDER 3 S
00002
7.85
4
6
7
8099
0
0
0
0
0
8083
0
8
05797
GENERATOR
00002
610.85
25
31
35
6
0
0
3
0
0
0
4
6
05801
SWITCH BOX B-1
00002
60.14
3
5
5
2
0
0
0
0
0
0
0
3
07802
VACUMN
00002
9.22
19
21
25
9
0
0
0
0
0
0
2
15
07803
CAUTERY HANDLE
00002
48.98
9
9
4
2
0
0
0
0
0
0
0
4
07812
SWIVEL BRUSH
00002
35.65
58
41
43
20
0
0
0
0
0
0
5
14


Short_cr  part report
This is the same as the short report above, with exception, the current release (cr and rl1) is printed in place (rl1 and rl2).   Recall, the current release cr should be ordered now, and is a portion of the projected month 1 release rl1.  

Parameter Report
An example of the Forecast-Replenish Parameter Report is given below.
graphic

Lost Sales Report
This report is generated with each run of Forecast-Replenish and compares the aggregate current inventory status with a 12 month projected status of the following measures:  12 month forecasts, on-hand inventory, on-order inventory, surplus, lost sales, turnover and return-on- inventory.

Most of the remaining routines include the following reports (with some variations):
  • Part
  • Summary
  • Parameter