PRIORITY-MATRIX

Analysis Of Pending Assignments

29-11-98

A) CLIENT-WISE

Client	No. of Positions	Prof. Fees (Est.)
Cadilla	18 positions
Rubamin	6 positions
Pidilite	5 positions
Schindler	5 positions
Kuwait Invt. Autho.	3 positions
CCT	2 positions
Tata Interactive	2 positions
Gujarat Guardian	2 positions
Luprn	2 positions
M&M (Tractor)	1 position
Lucent	1 position
ICC Kesar	1 position
Permronics	1 position
Kirloskar AAF	1 position
Total	52

 

In terms of No. of Positions & Est. Value of Prof. Fees, which are our "important" clients? Obviously, more important clients need:

• more frequent Verbal interaction
• more frequent Written feedback / position statements

---

B) CONSULTANT-WISE

Nikmit	Thakur	Mitchelle	Shankar
Total

How much "workload" does each Consultant have at any given point of time?

This analysis can be extended to the REVENUE (est. professional fees) that each consultant is handling (apart from the "no. of vacancies" that he is handling).

This could help us to decide:

• to provide "temporary" help/assistance to a particular consultant in case of OVERLOAD
• to "shift" some of the assignments to another consultant who might be UNDERLOADED
• to hire additional consultants in case of situations of PERMANENT/CONTINUOUS OVERLOAD
• to "even-out" workload on different Consultants

AGE-WISE (CHRONOLOGY)

Pending From Since	No. of Assignments
April 98
May 98	We aim at executing assignments within 2 months of receipt (later on even faster - once ORDER EXECUTION MODULE software gets installed). Till such time, at each month's end, we must manually compile this statement, so that, we may conclude (based on FACTS & not on hunches/guess) that:
June 98
July 98
Aug. 98	- We need to put in extra efforts and "clear" very old backlog
Sept. 98	- We need to add more consultants (Permanent / Temporary)
Oct 98	- We have no "work" beyond 2 months and therefore we need to step-up our "marketing" efforts
Nov. 98
TOTAL

Cyril $\rightarrow$ "Let us target to compile this statement automatically." $\quad$ 7/5/99

D) PROFESSIONAL FEES-WISE (Estimated)

Descending order of Value

Assignment PO No.	Position	Most likely salary	Prof. Fees
			Basis
Total $\rightarrow$

 

E) EXPECTED JOINING-DATE WISE

To figure out CASH INFLOW statement

PO No.	Position	Expected Joining Date
		Nov

Assuming, we will receive our prof. fees within 30 days of the executive joining duty, this chart will help us in determining our CASH INFLOW.

F) FUNCTION-WISE (DEMAND SCENARIO)

AS ON -

PO No.	Function
	Production / Operations / QC/QA

Monthly / Quarterly / Annual analysis like this, will tell us, in which FUNCTIONAL-AREA do we need to build-up an "inventory" of executives.

G) HIERARCHY LEVEL-WISE (DESIGNATION)

PO No.	Level
	MD

 

PRIORITY MATRIX

Y-axis: Prof. Fees (Est.) (Low Fees, Medi. Fees, High Fees)

X-axis: Assignment Age (Pending Since) (Recent, 1 Month, 2 Month, 3 Month (cold), 4 Month)

	Recent	1 Month	2 Month	3 Month (cold)	4 Month
High Fees	Medium Priority	High Priority	V. High Priority	Extreme Priority
Medi. Fees	LOW	Medium	Medium	High
Low Fees	Low Fees (V. Low Priority)	Low Priority	Medium Priority	Medium Priority

(Arrows indicate: V. Low Priority is Low Fees / Recent; Extreme Priority is High Fees / 3 Month+)

PENDING ASSIGNMENTS

Position as on 30-11-98

Sr.	PO No.	PO Date	Client Name	Position / Vacancy	No. of Vac.	Mode	Target	Consultant	Prof. Fees	Advance Received	Progress / Remarks
1.	KIA-FC-001		Kuwait Invest. Authority	Manager-Financial Control	1	D	7-12-98		₹ 10,000
2.	KIA-OM-002		”	Operations Manager	1	”
3.	KIA-RM-003		”	Comp. Project Manager	1	D
4.	KAAF-SMM-001		Kirloskar AAF Ltd.	Sr. Mgr. Mktg-M. Region	1	D	27-11-98		20%	NIL
5.	P-CEO-001		Permronics	CEO-Marketing	1	D/H
6.	ICK-PI-001		ICC Kesar	President - Indenting	1	H
7.	PID-HPCD-001		Pidilite	Head-Paints/Chem. Division	1	D/H			16.66%	25000
8.	PID-SMS-002		”	Sr. Mgr. Sales-Cons. Pr. Div.	1	D/H			20%	7000
9.	PID-H-ISD-003		”	Head-Info Services Div.	1	”			2.5 L	50,000
10.	PID-DM-004		”	Distribution-Manager	1	”			16.66%
11.	PID-PM-CPD-005		”	Product Mgr-Cons. Pr. Div.	1	”			16.66%	7000
12.	GG-PM-001		Gujarat Guardian	Production-Manager	1	H	19-11-98
13.	GG-PM-002		”	Production Manager	1	H
14.	SCH-SE-001		Schindler	Sales Executive	2	”			32,000
15.	SCH-SE-002		”	”	1	H
16.	SCH-SE-003		”	”	1	H
17.	SCH-SE-E-004		”	Service Executive	1	H
18.	SCH-SE-E-005		”	”	1	H
19.	LUC-SM-001		Lucent	Sr. Mgr.-Bus. Dev.	1	H
20.	TIT-CTO-001		Tata Interactive Systems	CTO	1	H
21.	LUP-HWM-002		Luprn	Head-Web Mktg	1	H
22.	MM-BPR-E-001		M&M (Tractor Div.)	BPR Engineer	1	D	15-9-98			7000
23.	RUB/OP/001		Rubamin	Oracle Programmer	1	H				NIL
24.	RUB/OP/002		”	”	1	H				NIL
25.	RUB/OP/003		”	”	1	H				NIL
26.	RUB/OP/004		”	Oracle Analyst	1	H				NIL
27.	RUB/OP/005		”	”	1	H
28.	RUB/OP/006		”	”	1	H
29.	CAD/GM/001	21-9-98	Cadilla Corporation	GM-Materials	1	H	15-9-98			7500
30.	CAD/PE/001		”	Executive-Personnel	1	H	Urgent			7500

 

PENDING ASSIGNMENTS (Continuation from Scan_0009.jpg)

Sr.	PO No.	PO Date	Client	Position / Vacancy	No. of Vac.	Mode	Target	Consultant	Terms	Progress / Remarks
									Prof. Fees	Min/Fixed Fees
31.	AS/PM/002		Anil Starch Products	Project Manager	1	D	1-11-98
32.	AS/UM/002		”	Utilities Manager	1	D	1-11-98		20%	7000
33.	CAD/GM/002	21-9-98	Cadilla Pharma	GM-Marketing	1	H	30-11-98		16.66%
34.	CAD/GM/003		”	”	1	H
35.	CAD/PM/003	21-9-98	”	Product Manager	1	D
36.	CAD/PM/004		”	”	1	D
37.	CAD/GM/005		”	GM-Mfg. Technology	1	”
38.	CAD/PM/006		”	”	1	”
39.	CAD/PM/007		”	”	1	”
40.	CAD/PM/008		”	”	1	”
41.	CAD/Sr-M/009		”	Sr. Mgr.-Mfg. Technology	1	”
42.	CAD/QA/010		”	Manager-Q.A.	1	”
43.	CAD/DGM/011	21-9-98	”	Dy. GM-Mktg (Sulfolane)	1	H	30-11-98
44.	CAD/EE/012		”	Environment Engineer	1	H
45.	CAD/GM/013		”	GM (Finance & Accounts)	1	H
46.	CAD/MS/014		”	Manager-Sourcing	1	H
47.	CAD/M-SER/015		”	Mktg Services Mgr. (ZBN Pharma)	1	H
48.	CAD/PM-H/036		”	Product Manager-Herbal	1	H
49.	CAD/SM-H/037		”	Sales Manager-Herbal	1	H
50.	CAD/GM/018		”	GM-Mktg (CHPL)	1	H
51.	LUP/MP/003	16-9-98	Luprn Laboratories	Manager - Personnel	1	D
52.	LUP/Sr-M/002		”	Sr. Mgr-HRD	1	D