IC-Project-Portfolio-Scorecard-Template_Google_Sheets

	B	C	D	E	F	G	H	I	J	K	L	M
1

2	PROJECT PORTFOLIO SCORECARD TEMPLATE								https://www.smartsheet.com/try-it?trp=11548&utm_source=integrated-content&utm_campaign=/content/project-scorecard-templates&utm_medium=Project+Portfolio+Scorecard+google+sheets+11548&lpa=Project+Portfolio+Scorecard+google+sheets+11548&lx=PFpZZjisDNTS-Ddigi3MyABAgeTPLDIL8TQRu558b7w
3	PROJECT MANAGEMENT OVERVIEW
4	OVERVIEW			PLANNED	ACTUAL	PLANNED LESS ACTUAL	COMMENTARY		OVERALL RISK ANALYSIS OUTCOMES	OVERALL BUDGET IMPACT	OVERALL COST BENEFIT ANALYSIS
5	TOTAL NUMBER OF PROJECTS COMPLETE			6	2	4	We've completed two of the six projects planned through Q3.
6	TOTAL TIME TO MOBILIZE IN HOURS			1800	720	1080	Mobilization is occurring one day faster than planned through Q3.
7	TOTAL QUALITY INDEX MEASURES			291	21	270
8	TOTAL PORTFOLIO COST SAVINGS			$8,060	$9,130	-$1,070	The additional benefits gained in Project Alpha more than offset the overruns in Project Beta.
9	PROJECTS AND KEY PERFORMANCE INDICATORS (KPIs)
10	PROJECTS	PRIORITY	STATUS	PLANNED	ACTUAL	PLANNED LESS ACTUAL	OWNER	COMMENTARY	OUTCOMES OF RISK ANALYSIS	BUDGET IMPACT	COST BENEFIT ANALYSIS	DATE MODIFIED
11	PROJECT ALPHA
12	Costs/Savings Realized ($)	LOW	YELLOW	$ 1,200	$ 430	$ 770	Chris K.	The cost savings continue to come in more than planned.				MM/DD/YY
13	Scheduled Hours (hours)	MEDIUM	RED	600	240	360	Chris K.	The effort is less than budgeted.				MM/DD/YY
14	Quality Index (1-100)	HIGH	GREY	97	7	90	Greta L.	#1 in sight by EOY on current growth trend				MM/DD/YY
15	Key Performance Measure	LOW	GREEN									MM/DD/YY
16	Key Performance Measure	HIGH	GREEN									MM/DD/YY
17	PROJECT BETA
18	Costs/Savings Realized ($)	HIGH	YELLOW	$ 5,560	$ 6,200	$ (640)	Chris K.	Cost overruns are because the work is more complex than anticipated.				MM/DD/YY
19	Scheduled Hours (hours)	MEDIUM	GREY	600	240	360	Chris K.	The effort involved in Project Beta continues to be more than planned.				MM/DD/YY
20	Quality Index (1-100)	ON HOLD	GREEN	97	7	90	Greta L.	Our QA processes are currently under review.				MM/DD/YY
21	Key Performance Measure	MEDIUM	GREEN									MM/DD/YY
22	Key Performance Measure	HIGH	YELLOW									MM/DD/YY
23	PROJECT SIGMA
24	Costs/Savings Realized ($)	MEDIUM	GREEN	$ 1,300	$ 2,500	$ (1,200)	Chris K.					MM/DD/YY
25	Scheduled Hours (hours)	MEDIUM	RED	600	240	360	Chris K.					MM/DD/YY
26	Quality Index (1-100)	ON HOLD	GREY	97	7	90	Greta L.					MM/DD/YY
27	Key Performance Measure	HIGH	YELLOW									MM/DD/YY
28	Key Performance Measure	MEDIUM	GREEN									MM/DD/YY
29
30	CLICK HERE TO CREATE IN SMARTSHEET
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