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.
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):
FIRM™ Software
