Insurance Company.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	U	W	Y	AA	AB	AD	AE	AG	AH
1
2	Project Portfolio for Insurance Company

3	DEPARTMENT		Operations Research Analyst			PORTFOLIO FINANCIAL HEALTH
4	DEPARTMENT LEAD		Director of Operations			$ 50,000	BUDGET
5	NUMBER OF PROJECTS		20.00			$ 100,000	ACTUAL
6	DATE OF LAST UPDATE		27/07/2026			$ (50,000)	BALANCE
7
8	PROJECT HEALTH LEVEL	PRIORITY	PROJECT ID	PROJECT NAME	STATUS	PROJECT SUMMARY	PROJECT MANAGER	BUDGET	ACTUAL	BUDGET LESS ACTUAL	EXPECTED DATE OF COMPLETION	NUMBER OF DAYS REMAINING	PERCENT OF PROJECT COMPLETE	ASSOCIATED RISKS	COST BENEFIT ANALYSIS OUTCOME	COMMENTARY/Estimated Completion Duration	ATTACHMENTS / LINKS	PROJECT HEALTH LEVEL KEY	STATUS KEY	PRIORITY KEY	PROJECT HEALTH LEVEL CT	QTY	STATUS COUNT	QTY	PRIORITY KEY	QTY
9	1	EXTREME	1	Premium Pricing Optimization	PLANNING PHASE	Status: Under Implementation Optimize risk-based pricing models. (Potential Future Project)	AHSAN KHAN	$ 100,000	$ 50,000	$ 50,000	01/01/26	(180)	10%			3-6 months		1	REQUEST PLACED	LOW	1	5	REQUEST PLACED	0	LOW	4
10	1	MEDIUM	2		ON HOLD			$ -	$ -	$ -	01/01/26	(180)	0%			4-8 months		2	APPROVED	MEDIUM	2	3	APPROVED	0	MEDIUM	4
11	1	HIGH	3		ON HOLD			$ -	$ -	$ -	01/03/26	(178)	0%			2-4 months		3	PLANNING PHASE	HIGH	3	3	PLANNING PHASE	1	HIGH	2
12	1	EXTREME	4		ON HOLD			$ -	$ -	$ -	01/04/26	(177)	0%			3-5 months		4	ON HOLD	EXTREME	4	3	ON HOLD	17	EXTREME	8
13	5	MEDIUM	5		ON HOLD			$ -	$ -	$ -	01/05/26	(176)	0%			4-7 months		5	COMPLETE		5	4	COMPLETE	0
14	4	LOW	6		ON HOLD			$ -	$ -	$ -	01/06/26	(175)	0%			2-4 months			MONITOR				MONITOR	0
15	4	EXTREME	7		ON HOLD			$ -	$ -	$ -	01/07/26	(174)	0%			5-9 months			OTHER				OTHER	0
16	5	MEDIUM	8		ON HOLD			$ -	$ -	$ -	01/08/26	(173)	0%			6-12 months
17	5	MEDIUM	9		ON HOLD			$ -	$ -	$ -	01/09/26	(172)	0%			6-10 months
18	4	HIGH	10		ON HOLD			$ -	$ -	$ -	01/10/26	(171)	0%			2-3 months
19	1	LOW	11		ON HOLD			$ -	$ -	$ -	01/11/26	(170)	0%			5-8 months
20	2	LOW	12		ON HOLD			$ -	$ -	$ -	01/12/26	(169)	0%			6-12 months
21	3	LOW	13		ON HOLD			$ -	$ -	$ -	01/13/26	(168)	0%			3-6 months
22	5	EXTREME	14		ON HOLD			$ -	$ -	$ -	01/14/26	(167)	0%			3-5 months
23	3	EXTREME	15		ON HOLD			$ -	$ -	$ -	01/15/26	(166)	0%			4-7 months
24	3	EXTREME	16		ON HOLD			$ -	$ -	$ -	01/16/26	(165)	0%			3-6 months
25	2	EXTREME	17		ON HOLD			$ -	$ -	$ -	01/17/26	(164)	0%			3-6 months
26	2	EXTREME	18		ON HOLD			$ -	$ -	$ -	01/18/26	(163)	0%			2-4 months
27	1	EXTREME	19	Educational Tour Planning	ON HOLD	Potential Future Project: Logistically planning student educational tours.		$ -	$ -	$ -	01/19/26	(162)	0%			2-3 months
28	1	LOW	20	Outsourcing Services Analysis	ON HOLD	Potential Future Project: Analyzing the performance and cost-effectiveness of outsourced services.		$ -	$ -	$ -	01/20/26	(161)	0%			3-5 months
29			21		OTHER			$ -	$ -	$ -	01/21/26	(160)	0%
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100