Excel Assignment with Small Essay

profiledfaert
kt-templates.xlsx
Home>Business & Finance homework help>Operations Management homework help>Excel Assignment with Small Essay

KT-Templates

Kepner-Tregoe Templates
(Copyright Kepner-Tregoe, Inc., 1994. Reprinted with permission.)
Situation Analysis
Problems Timing (H,M,L) Trend (H,M, L) Impact (H,M, L) Process (PA ,DA, or PPA)
1.
2.
3.
Problem Analysis
Problem Statement:
IS IS NOT Distinction Probable Cause
What?
Where?
When ?
Extent?
Decision Analysis
Alternative: A B C
Musts 1. 2. GO GO GO NO GO GO GO
Wants Weight Rating Score Rating Score Rating Score
1.
2.
Total A = Total B = Total C =
Potential Problem Analysis
Potential Problems Consequences Possible Causes Preventive Actions Contingency Plan
A. 1. 2. 1. 2. 1. 2.
B. 1. 2. 1. 2. 1. 2.

Situation

Kepner-Tregoe Templates
(Copyright Kepner-Tregoe, Inc., 1994. Reprinted with permission.)
Situation Analysis
Situations / Problems / Projects Timing (H,M,L) Trend (H,M, L) Impact (H,M, L) Process (PA ,DA, or PPA)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.

Problem

Kepner-Tregoe Templates
(Copyright Kepner-Tregoe, Inc., 1994. Reprinted with permission.)
Problem Analysis
Problem Statement:
IS IS NOT Distinction Probable Cause
What?
Where?
When ?
Extent?
Problem Analysis
Problem Statement:
IS IS NOT Distinction Probable Cause
What?
Where?
When ?
Extent?
Problem Analysis
Problem Statement:
IS IS NOT Distinction Probable Cause
What?
Where?
When ?
Extent?

Decision

Kepner-Tregoe Templates
(Copyright Kepner-Tregoe, Inc., 1994. Reprinted with permission.)
Decision Analysis
Alternative: A B C
Musts 1. 2. 3. 4. 5. 6. 7. 8. 9. GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO GO / NO GO
Wants Weight Rating Score Rating Score Rating Score
1.
2
3
4
5
6
7
8
9
Total A = Total B = Total C =

Potential Problem

Kepner-Tregoe Templates
(Copyright Kepner-Tregoe, Inc., 1994. Reprinted with permission.)
Potential Problem Analysis
Potential Problems Consequences Possible Causes Preventive Actions Contingency Plan
A. 1. 2. 3. 1. 2. 3. 1. 2. 3.
B. 1. 2. 3. 1. 2. 3. 1. 2. 3.
C. 1. 2. 3. 1. 2. 3. 1. 2. 3.
D. 1. 2. 3. 1. 2. 3. 1. 2. 3.
E. 1. 2. 3. 1. 2. 3. 1. 2. 3.
F. 1. 2. 3. 1. 2. 3. 1. 2. 3.
G. 1. 2. 3. 1. 2. 3. 1. 2. 3.
H. 1. 2. 3. 1. 2. 3. 1. 2. 3.
I. 1. 2. 3. 1. 2. 3. 1. 2. 3.

Adv Consequences

Adverse Consequences
Consequence Probability of Occurrence Seriousness P times S
A1
A2
A3
B1
B2
B3
C1
C2
C3
D1
D2
D3
E1
E2
E3
F1
F2
F3