Transcript Document

PILOT Demo
c. September 1990
Arthur M. Schneiderman
Next
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 1
title
Navigation Rules
Click on:
Table entry number:
Entity name in column:
Entity name in row:
Result:
Time history of that entry
Re-graph for that entity only
Entity scorecard for metric category
Next
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 2
Pilot-1 Navigation rules
Predefined Graphics
average for month
(12 month window)
Category
Metric
•Lateness
(by mfg. division)
% late
how late?
% early
how early?
% early or late
age of late backlog
size of late backlog
(turns)







•Responsibility
(by entity)
% late

•Lead time
% CRDs not matched
Excess lead time
Requested lead time
Quoted lead time




Time to quote lead
time

•Responsiveness
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
histogram
(selected month)






Next
Slide 3
Pilot-2 pre-defined graphics
Ad Hoc Queries
(slice-n-dice)
Select one or more from each criteria:
•Measure (~100)
–e.g.: Number Of Lines Late Due To Credit Referrals
•Time period (end date)
–end date or year
•Entity
–individual division, warehouse, credit, or corporate total
•Product
–individual: e.g. AD575
–type: standard or custom
•Customer
–all foreign affiliates: Japan, Italy, etc.
–account categories: domestic key, corporate key, etc.
–~400 individual key accounts: HP, IBM, etc.
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Next
Slide 4
Pilot-3 ad hoc queries
ANALOG DEVICES, INC.
Corporate Scorecard
Customer Service
Metrics
Product Tracking
System
Set Printer
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
EXIT
Slide 5
Pilot-4 opening screen
1
2
1990 Scorecard
ADI
Qtr 3 1990
?
Line Item
QIP:
On Time Delivery (To FCD)
CRDs Not Matched
Excess Leadtime
Employee Turnover
IC Outgoing PPM
IC Process PPM
IC Cycle Time
IC Yield
AP Outgoing PPM
Plug In Yield
AP Cycle Time
Scrap/Rework
Retrace
Utilities
Actual
Budget
Variance
% Var.
%
%
WKS
%
95.30
51.70
2.70
19.70
97.70
29.20
2.40
16.80
-2.40
22.50
.30
2.90
-2.46
77.05
12.50
17.26
DYS
%
706.00
1116.00
62.60
38.00
984.00
1350.00
45.80
43.30
-278.00
-234.00
16.90
-5.30
%
DYS
%
1744.00
90.80
23.90
8.40
1276.00
92.20
19.90
7.40
468.00
-1.40
4.00
1.00
1989 Scorecard
Commentary
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 6
#
#
#
#
-28.25
-17.33
36.68 #
-12.24 #
36.68
-1.52
30.10
13.51
#
#
#
#
Return
Pilot-5 scorecard-1
1
2
1990 Scorecard
ADI
Qtr 3 1990
?
Line Item
Actual
Budget
Variance
% Var.
NEW PRODUCTS:
Post 1985 Products
Forecasted 3rd Year
$M
$M
45.90
.00
46.70
-.80
-1.71 #
FINANCIALS:
Sales
Sales Growth (YTY)
Contribution Margin
ROA (Contribution Margin)
$M
%
%
%
120.70
6.50
6.30
7.80
120.20
6.00
8.80
10.40
.50
.50
-2.50
-2.60
.42
8.33
-28.41 #
-25.00 #
Retrace
Utilities
1989 Scorecard
Commentary
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 7
Return
Pilot-6 scorecard-2
1990 Scorecard
ADI
QtrADBV
3 1990
?
Line Item
Actual
QIP:
On Time Delivery (To FCD)
CRDs Not Matched
Excess Leadtime
Employee Turnover
IC Outgoing PPM
IC Process PPM
IC Cycle Time
IC Yield
AP Outgoing PPM
Plug In Yield
AP Cycle Time
Scrap/Rework
Retrace
Utilities
1
2
Budget
Variance
% Var.
97.70
29.20
2.40
16.80
-2.40
22.50
.30
2.90
-2.46
77.05
12.50
17.26
DYS
%
706.00
1116.00
IPD
62.60
38.00
984.00
1350.00
45.80
43.30
-278.00
-234.00
16.90
-5.30
%
DYS
%
1744.00
MED
90.80
23.90
Return
8.40
1276.00
92.20
19.90

7.40
468.00
-1.40
4.00
1.00
ADS
%
%
WKS
%
95.30
51.70
2.70
CTS
19.70
CLD
DSP
1989 Scorecard
MDL
Commentary
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 8
#
#
#
#
-28.25
-17.33
36.68 #
-12.24 #
36.68
-1.52
30.10
13.51
#
#
#
#
Return
Pilot-7 select division scorecard
1
2
1990 Scorecard
ADS
Qtr 3 1990
?
Line Item
QIP:
On Time Delivery (To FCD)
CRDs Not Matched
Excess Leadtime
Employee Turnover
IC Outgoing PPM
IC Process PPM
IC Cycle Time
IC Yield
NEW PRODUCTS:
Post 1985 Products
Forecasted 3rd Year
Retrace
Utilities
Actual
Budget
Variance
%
%
WKS
%
96.50
44.70
2.10
21.30
97.60
22.00
2.20
17.00
-1.10
22.70
-.10
4.30
-1.13 #
103.10 #
-4.55
25.29 #
DYS
%
1052.00
1694.00
91.60
39.00
1580.00
1675.00
49.70
46.70
-448.00
19.00
11.90
-7.70
-29.87
1.13 #
23.94 #
-16.49 #
12.00
12.90
-.90
-6.98 #
$M
$M
1989 Scorecard
Commentary
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 9
% Var.
Return
Pilot-8 ADS scorecard-1
1
2
1990 Scorecard
ADI
Qtr 1 1990
?
Line Item
FINANCIALS:
Sales
Sales Growth (YTY)
Contribution Margin
ROA (Contribution Margin)
Retrace
Utilities
$M
%
%
%
1989 Scorecard
Actual
Budget
39.40
-5.40
10.40
9.70
41.00
-1.60
11.60
11.20
Commentary
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 10
Variance % Var.
-1.60 -3.90 #
-3.80 -237.50 #
-1.20 -10.34 #
-1.50 -13.39 #
Return
Pilot-9 ADS scorecard-2
1
2
1990 Scorecard
ADI
Qtr 3 1990
?
Line Item
Actual
Budget
Variance
% Var.
%
%
WKS
%
95.30
51.70
2.70
19.70
97.70
29.20
2.40
16.80
-2.40
22.50
.30
2.90
-2.46
77.05
12.50
17.26
DYS
%
706.00
1116.00
62.60
38.00
984.00
1350.00
45.80
43.30
-278.00
-234.00
16.90
-5.30
%
DYS
%
1744.00
90.80
23.90
8.40
1276.00
92.20
19.90
7.40
468.00
-1.40
4.00
1.00
Layout Report
QIP:
On Time Delivery (To FCD)
Edit Notes
CRDs Not Matched
Excess Leadtime
Print at System
Employee Turnover
Print to File
IC Outgoing PPM
IC Process
PPMLocally
Print
IC Cycle Time
IC Yield
Download to LOTUS
AP Outgoing
PPM
Calendar
Plug In Yield
AP Cycle Time
Scrap/Rework
Return
Retrace
Utilities
#
#
#
#
-28.25
-17.33
36.68 #
-12.24 #
36.68
-1.52
30.10
13.51
#
#
#
#

1989 Scorecard
Commentary
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 11
Return
Pilot-10 PILOT utilities
CUSTOMER SERVICE METRICS – ON TIME/RESPONSIBILITY
September 1990
Early %
On Time %
Not Late %
Division %
Warehse. %
Credit %
ADBV
ADS
CLD
CTS
DSP
IPD
MDL
MED
ADI
16.22
8.47
30.60
16.76
7.58
5.14
47.29
13.79
11.15
75.72
86.99
67.45
75.68
87.79
88.79
35.66
51.81
83.23
91.95
95.46
98.05
92.43
95.37
93.93
82.95
95.60
94.38
8.13
5.73
4.19
8.65
5.05
7.93
15.50
5.59
6.70
.37
.34
.29
.00
.63
.98
.00
.24
.46
.31
.32
.19
.00
.63
.43
.00
.36
.34
ALL
11.15
83.23
94.38
6.70
.46
.34
Utilities
Change Metrics
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Return
Slide 12
Pilot-11 customer service
Percent Of Lines Shipped Late (Oct 89 through Sep 90)
100
ADBV
ADS
CLD
DSP
IPD
MDL
MED
ADI
++
+
10
+
+
++
+
+
++
+
+
++
+++
+
++
+++
1
0.1
Half
N/A
Life (In months)
NS
4
N/A
N/A
NS
NS
N/A
Return
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 13
Pilot-12 late
ADS Half lives by month 10/89 to 9/90
Hlf Life
10/89
19
11/89
22
12/89
30
1/90
50
2/90
45
30
3/90
26
20
4/90
19
5/90
15
6/90
14
7/90
18
8/90
22
9/90
NS
60
50
40
10
0
Oct Nov Dec Jan Feb Mar Apr May Jun
89
Jul
Aug Sep
90
Return
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 14
Pilot-13 ADS half-life
Time Phased Late Shipments In Weeks
Lines
600-
500-
400-
300-
200-
100-
01
2
3
4
Weeks
Value
September 1990 - ADI
1
474
%
-100
2
204
3
98
-90
4
67
-80
5
36
6
24
-70
7
20
-60
8
13
9
13
-50
10
12
-40
11
9
12
6
-30
13
4
-20
14
16
21
4
-10
27
2
-0
34
0
40
2
5 6 7 8 9 10 11 12 13 14- 21- 27- 34- 40+
WEEKS
20 26 33 39
Return
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 15
Pilot-14 lateness histogram
?
ADI CUSTOMER SERVICE MEASURES
ASAP
ASAP_PCT
AVG_SHIP
BACKLOG
CRD_HOLD_PCT
CRED_REF_PCT
CREDIT
CREDIT_HOLD
CREDIT_PCT
CREDIT_REF
CUST_STOP
CUST_STP_PCT
CUSTOMER
CUSTOMER_LT
CUSTOMER_PCT
DISTRIBUTION
DISTRN_PCT
DIV_WAREHSE
DIV_WE_PCT
DIVISION
\/
Number Of ASAP Orders Placed During The Period
Percent Of Orders Received That Were ASAP
Weighted Average Number of Shipments Per Period
Total Number Of Unshipped Orders
Percent Of Lines Late Due To Credit Hold
Percent Of Lines Late Due To Credit Referrals
Number Of Lines Late Due To All Credit Causes
Number Of Lines Late Due To Credit Hold Causes
Percent Of Lines Late Due To All Credit Causes
Number Of Lines Late Due To Credit Referrals
Number Of Lines Late Due To Customer Stops
Percent Of Lines Late Due To Customer Stops
Number Of Lines Late Due To All Customer Causes
Average Customer Requested Lead Time
Percent Of Lines Late Due To All Customer Causes
Number Of Lines Late Due To All Distribution Causes
Percent Of Lines Late Due To All Distribution Causes
Lines Late Due To Divisional Warehouse Error
Percent Of Lines Late Due To Divisional Warehouse Error
Number Of Lines Late Due To All Divisional Causes
END
CANCEL CLEAR
DONE
Select label, composite, or new key field
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 16
Pilot-15 slice-n-dice: choose
measure
Print
/ADI
CUSTOMER SERVICE TABLE
ENTITY
LATEST PERIOD
ADI
Reset
PILOT DIMENSION
CUSTOMER
TYPE
?
ERY_SHIP_PCT ON_TIME_PCT NOT_LATE_PCT DIVISION_PCT
(9/90)
(9/90)
(9/90)
(9/90)
TOTAL
TOTAL
TOTAL
TOTAL
11.15
83.23
94.38
6.70
Metrics
Views
Calendar
Return
Select label, composite, or new key field.
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 17
Pilot-16 slice-n-dice
PILOT DIMENSION
CUSTOMER
TYPE
Print
/ADI
ADI
QtrADBV
3 1990
ADS
CUSTOMER SERVICE TABLE
ENTITY
CLD
LATEST PERIOD
ADI
CTS
?
ERY_SHIP_PCT ON_TIME_PCT NOT_LATE_PCT DIVISION_PCT
(9/90)
(9/90)
(9/90)
(9/90)
TOTAL
TOTAL
TOTAL
TOTAL
11.15
83.23
94.38
6.70
DSP
IPD
MDL
MED
Return
Reset

Metrics
Views
Calendar
Return
Select label, composite, or new key field.
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 18
Pilot-17 slice-n-dice: choose entity
PILOT DIMENSION
TYPE
CUSTOMER
Print
ENTITY
?
CUSTOMER SERVICE TABLE
CUSTOMER
LATEST PERIOD Finished
CORPORATE KEY ACCOUNT
DOMESTIC KEY ACCOUNT
FOREIGN KEY ACCOUNT
KEY ACCOUNT
NON KEY ACCOUNT
ADKK
ALLEN BRADLEY
AMOCO
ARMCO
ATT
BECKMAN
BENDIX
BETHLEHEM STEEL
Reset
\/
END Metrics
Views
Calendar
Return
Select up to nine labels for composite group.
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 19
Pilot-18 slice-n-dice: choose
customer
Print
/ADI
PILOT DIMENSION
/OEM/DIST
/HEWLETT PACKARD
CUSTOMER SERVICE TABLE
TYPE
LATEST PERIOD
DIST – ADI – HEWLETT
OEM – ADI - HEWLETT
Reset
?
CUSTOMER_LT
(9/90)
TOTAL
7.56
8.00
Metrics
Views
Calendar
Return
Select label, composite, or new key field.
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 20
Pilot-19 example
DIST – ADI – HEWLETT PACKARD
METRIC: CUSTOMER_LT (9/90)
10/89 10.47
24
11/89 10.99
20
12/89 10.77
16
1/90
11.75
12
2/90
9.36
8
3/90
11.11
4
4/90
7.52
5/90
7.88
0
Oct
89
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
90
Aggregate time-series - N
6/90 19.82
7/90
5.74
8/90
5.05
9/90
7.56
Return
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 21
Pilot-20 example – vs time
ADI PRODUCT TRACKING SYSTEM
FY89 PLAN
ACTUAL
VARIANCE
% VAR
RPCC Pre 86 Products
RPCC 1986-1992 Products
77,707.1
46,114.0
73,073.9
33,130.4
-4,633.2
-12,983.6
-6.0%
-28.2%
PSTF Pre 86 Products
PSTF 1986-1992 Products
77,707.1
46,114.0
73,073.9
33,130.4
-4,633.2
-12,983.6
-6.0%
-28.2%
Division Pre 86 Products
Division 1986-1992 Products
77,707.1
46,114.0
73,073.9
33,130.4
-4,633.2
-12,983.6
-6.0%
-28.2%
1st Quarter 1990
Retrace
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Return
Slide 22
Pilot-21 pts top level
QUARTERLY BOOKINGS ($K) : 1986-1992 VINTAGE PRODUCTS
1st Quarter 1990
DAC
DSP
SYS
SENSE
ADC
ASP
AMP
MIL
ASIC
COMM
MISC
ADI
Retrace
FY89 PLAN
ACTUAL
VARIANCE
% VAR
9,821.1
4,621.4
6,410.4
2,616.9
10,599.9
2,781.4
6,745.0
1,474.8
1,043.2
0.0
0.0
46,114.0
6,192.4
2,564.0
4,761.5
1,416.2
9,400.0
1,717.6
5,785.7
556.5
733.4
0.0
3.0
33,130.4
-3,629.0
-2,057.0
-1,648.9
-1,200.7
-1,199.9
-1,063.8
-959.3
-918.3
-309.8
0.0
3.0
-12,983.6
-37.0%
-44.5%
-25.7%
-45.9%
-11.3%
-38.2%
-14.2%
-62.3%
-29.7%
Pareto
Vintage Chart
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
-28.2%
Return
Slide 23
Pilot-22 by strategy
900000
BOOKINGS CHART BY VINTAGE (Actuals through 1/90)
ADI
Vintage
FY89 Actual
Forecast
1992
1991
750000
1990
600000
1989
1988
450000
1987
300000
1986
150000
0
Data Sheet
89
90
91
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
92
Slide 24
Print
Return
Pilot-23 vintage chart-actual
FY89 Plan Bookings By Vintage
ADI
Vintage
1990
Actual*
1989
Forecast
1990
Forecast
1991
Forecast
1992
Forecast
1986
30,207.0
45,049.5
51,320.0
56,665.8
57,457.2
1987
33,130.4
49,107.3
40,113.1
47,264.7
50,164.8
1988
35,000.0
25,521.3
50,003.5
68,844.9
87,395.8
1989
35,000.0
19,881.5
55,106.2
91,382.2
124,901.1
1990
35,000.0
46,771.2
149,741.5
242,945.1
23,101.2
73,783.6
1991
1992
14,909.0
* Actual data annualized
Print
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 25
Return
Pilot-24 vintage chart data sheet
QUARTERLY BOOKINGS ($K) : 1986-1992 VINTAGE PRODUCTS
ASP
1st Quarter 1990
1986 Vintage
1987 Vintage
1988 Vintage
1989 Vintage
1990 Vintage
1991 Vintage
1992 Vintage
ASP
Retrace
FY89 PLAN
ACTUAL
VARIANCE
% VAR
95.5
691.2
563.3
1260.9
170.5
113.9
843.2
461.4
299.1
18.4
152.0
-101.9
-961.8
19.2%
22.0%
-18.1%
-76.3%
2781.4
1717.6
1063.8
-38.2%
Pareto
Vintage Chart
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Return
Slide 26
Pilot-25 vintage chart
1986-1992 VINTAGE PRODUCTS – BOOKINGS ASP
QUARTERLY VARIANCE FOR 901 (Actual-Plan)
1989 Vintage
1990 Vintage
1988 Vintage
1991 Vintage
1992 Vintage
1986 Vintage
1987 Vintage
-1000
-800
-600
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
-400
-200
Slide 27
0
200
Return
Pilot-26 vintage variance
1
2
QUARTERLY BOOKINGS ($K) : 1986-1992 VINTAGE PRODUCTS
Vintage: 1989
ASP
1st Quarter 1990
FY89 PLAN
ACTUAL
VARIANCE
% VAR
412.8
276.1
89.1
89.1
79.2
100.5
35.5
78.3
31.9
19.3
14.8
14.0
12.3
0.0
63.7
3.2
5.2
0.0
70.1
0.0
47.8
5.8
0.0
0.0
19.0
21.1
-412.8
-212.8
-85.9
-83.9
-79.2
-38.4
-35.5
-30.5
-26.1
-19.3
-14.8
5.0
8.8
-100.0%
-76.9%
-96.4%
-94.2%
-100.0%
-35.4%
-100.0%
-38.9%
-81.7%
-100.0%
-100.0%
35.9%
71.8%
AD1322
AD892
AD7371
AD7341
AD1315
AD834
AD1320
AD640
AD689
AD9590
AD688
AD9501
AD9901
Retrace
Pareto
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Return
Slide 28
Pilot-27 by product
AD585
: SHA
ADS
Sourcing:
Margin:
Revenue Risk:
Start Date:
Planned Release: 843
Planned Time to Market:
Actual Release:
Actual Time to Market:
Release Window:
Earliest Date:
Latest Date:
Development Risk:
Development Cost:
Die Size:
Product Type:
Technology: BIPOLAR
PSTF: ADC
Forecast Data
Print
ZOOM
Return
Plan vs. Actual
900
750
600
450
300
150
0
1
2
88
3
4
1
89
2
3
4
1
2
90
ACTUAL
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
3
4
1
2
91
3
4
1
2
3
4
92
FY89 PLAN
Slide 29
Pilot-28 product forecast
ADS QUARTERLY BOOKINGS
1984 Vintage: AD585
900
750
600
450
300
150
0
1
2
88
ACTUAL
3
4
1
89
2
3
4
1
2
3
4
90
1
2
3
4 1
91
FY89 PLAN
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Slide 30
1/88
2/88
3/88
4/88
1/89
2/89
3/89
4/89
1/90
2/90
3/90
4/90
1/91
2/91
3/91
4/61
1/92
ACTUAL
396
355
440
465
466
456
649
576
452
FY89
468
479
488
495
471
477
483
490
523
533
545
558
559
Return
Pilot-29 product actuals
PRODUCT DATA SHEET
1Q90 Bookings:
471.2
Division: ADS
AD585
SHA
ACTUAL
Bookings
Bookings
1Q88
2Q88
3Q88
4Q88
396.1
354.8
440.0
464.8
FY88
1,655.7
1Q89
2Q89
3Q89
4Q89
466.2
456.0
649.1
576.4
468.2
478.9
487.8
495.0
FY89
2,147.7
1,929.9
FY89 PLAN
ASP
Units
Return
\/
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Vintage: 843
Slide 31
Pilot-30 product data sheet
PRODUCT DATA SHEET
1Q90 Bookings:
471.2
Division: ADS
AD585
SHA
ACTUAL
Bookings
1Q90
2Q90
3Q90
4Q90
451.9
Bookings
FY89 PLAN
ASP
Units
471.2
476.8
482.6
489.5
FY90
1,920.1
1Q91
2Q91
3Q91
4Q91
523.2
533.3
545.2
558.3
FY91
2,160.0
/\
Vintage: 843
\/
©1987-2000 Arthur M. Schneiderman All Rights Reserved.
Return
Slide 32
Pilot-31 product data sheet –cont.