IC-IT-Portfolio-Status-Report-Template_Google-Sheet

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

2	IT PORTFOLIO STATUS REPORT TEMPLATE				https://bit.ly/3zHE5CM
3	FOR PROJECT PERIOD STARTING
4	Monday, May 5th
5	THROUGH
6	Tuesday, February 10th
7
8	LIVE PROJECTS TIMELINE
9		TIMELINE				PROJECT NOTES
10	PROJECT TITLE	START DATE	END DATE	DURATION in days	STATUS	SCHEDULE	BUDGET	RESOURCES	RISKS	ISSUES	COMMENTS
11	Project A	05/05	07/01	58	Proposed							STATUS KEY
12	Project B	05/10	08/10	93	In Progress							Proposed
13	Project C	06/10	02/01	237	Complete							In Progress
14	Project D	06/22	08/04	44	On Hold							Complete
15	Project E	07/14	11/01	111	Overdue							On Hold
16	Project F	07/14	01/20	191	Needs Review							Overdue
17	Project G	08/01	10/01	62	Scheduled							Needs Review
18	Project H	08/14	08/30	17								Scheduled
19	Project I	09/01	12/10	101
20	Project J	10/01	11/15	46
21	Project K	10/01	12/01	62
22	Project L	11/01	12/01	31
23	Project M	11/10	12/10	31
24	Project N	12/01	02/10	72
25
26	IT PORTFOLIO TIMELINE
27
28	PLANNED PROJECTS TIMELINE
29	PROJECT TITLE	PLANNED START DATE	PLANNED ENDING DATE	DURATION in days	STATUS	PERCENT COMPLETE	RISKS/CONCERNS
30	Project A	05/05	07/01	58	Proposed	0%						STATUS KEY
31	Project B	05/10	08/10	93	In Progress	50%						Proposed
32	Project C	06/10	03/01	265	Complete	100%						In Progress
33	Project D	06/22	08/04	44	On Hold	24%						Complete
34	Project E	07/14	11/01	111	Overdue	10%						On Hold
35	Project F	07/14	01/20	191	Needs Review	95%						Overdue
36	Project G	08/01	10/01	62	Scheduled	0%						Needs Review
37	Project H	08/14	08/30	17								Scheduled
38	Project I	09/01	12/10	101
39	Project J	10/01	11/15	46
40	Project K	10/01	12/01	62
41	Project L	11/01	12/01	31
42	Project M	11/10	12/10	31
43	Project N	12/01	02/10	72
44
45	PROJECT FINANCIAL STATUS
46	PROJECT TITLE	BUDGETED COSTS	ACTUAL COSTS	FORECAST	VARIANCE
47	Project A	$ 4,500	$ 5,000	$ 5,000	$ (500)
48	Project B	$ 5,000	$ 6,500	$ 4,500	$ (1,500)
49	Project C	$ 2,600	$ 1,700	$ 2,300	$ 900
50	Project D	$ 4,300	$ 4,000	$ 6,000	$ 300
51	Project E	$ 8,500	$ 9,750	$ 10,000	$ (1,250)
52	Project F	$ 18,750	$ 17,000	$ 18,500	$ 1,750
53	Project G	$ 15,000	$ 14,985	$ 16,000	$ 15
54	Project H	$ 26,000	$ 28,000	$ 30,000	$ (2,000)
55	Project I	$ 3,900	$ 4,500	$ 4,000	$ (600)
56	Project J	$ 2,750	$ 3,000	$ 3,000	$ (250)
57	Project K	$ 25,600	$ 29,500	$ 30,000	$ (3,900)
58	Project L	$ 6,700	$ 6,000	$ 7,000	$ 700
59	Project M	$ 29,000	$ 32,000	$ 30,000	$ (3,000)
60	Project N	$ 48,000	$ 35,000	$ 45,000	$ 13,000
61	TOTALS	$ 200,600	$ 196,935	$ 211,300	$ 3,665
62
63	CLICK HERE TO CREATE IN SMARTSHEET
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