IC-Multiple-Project-Budget-Tracking_Google_Sheets

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	X
1

2	Multiple Project Budget Gantt Chart Template Example								https://www.smartsheet.com/try-it?trp=12402&utm_source=template-google-sheet&utm_medium=content&utm_campaign=SEO
3							LABOR			MATERIALS			OTHER					BUDGET vs. ACTUAL		BALANCE
4	TASK ID	DESCRIPTION	STATUS	START DATE – PLANNED –	START DATE – ACTUAL –	END DATE	HOURS	$ / HR	LABOR TOTAL	UNITS	$ / UNITS	MATERIALS TOTAL	TRAVEL	EQUIP. / SPACE	FIXED	MISC.	OTHER TOTAL	BUDGET	ACTUAL	UNDER / OVER
5	1.0	PROJECT 1
6	1.1	Task	Not Started				5.00	$ 50.00	$ 250.00	5,000.0	$ 0.03	$ 150.00					$ -	$ 800.00	$ 400.00	$ 400.00
7	1.2	Task	In Progress				25.00	$ 35.00	$ 875.00			$ -					$ -	$ 1,000.00	$ 875.00	$ 125.00
8	1.3	Task	Complete				40.00	$ 75.00	$ 3,000.00	1.0	$ 2,600.00	$ 2,600.00					$ -	$ 6,000.00	$ 5,600.00	$ 400.00
9	1.3a	Subtask	On Hold						$ -			$ -		$ 5,200.00			$ 5,200.00	$ 5,000.00	$ 5,200.00	$ (200.00)
10	1.3b	Subtask	Overdue						$ -			$ -			$ 4,000.00		$ 4,000.00	$ 4,000.00	$ 4,000.00	$ -
11	1.3c	Subtask	In Progress						$ -			$ -				$ 1,600.00	$ 1,600.00	$ 500.00	$ 1,600.00	$ (1,100.00)
12	1.3d	Subtask	In Progress						$ -			$ -		$ 3,200.00			$ 3,200.00	$ 2,500.00	$ 3,200.00	$ (700.00)
13	1.4	Task	In Progress						$ -	5.0	$ 350.00	$ 1,750.00					$ -	$ 1,500.00	$ 1,750.00	$ (250.00)
14	1.5	Task	Not Started				17.00	$ 85.00	$ 1,445.00			$ -					$ -	$ 2,000.00	$ 1,445.00	$ 555.00
15									$ 5,570.00			$ 4,500.00	$ -	$ 8,400.00	$ 4,000.00	$ 1,600.00	$ 14,000.00	$ 23,300.00	$ 24,070.00	$ (770.00)
16
17							LABOR			MATERIALS			OTHER					BUDGET vs. ACTUAL		BALANCE
18	TASK ID	DESCRIPTION	STATUS	START DATE – PLANNED –	START DATE – ACTUAL –	END DATE	HOURS	$ / HR	LABOR TOTAL	UNITS	$ / UNITS	MATERIALS TOTAL	TRAVEL	EQUIP. / SPACE	FIXED	MISC.	OTHER TOTAL	BUDGET	ACTUAL	UNDER / OVER
19	2.0	PROJECT 2
20	2.1	Task	Complete						$ -	15.0	$ 480.00	$ 7,200.00					$ -	$ 8,500.00	$ 7,200.00	$ 1,300.00
21	2.2	Task	On Hold						$ -			$ -	$ 1,800.00				$ 1,800.00	$ 2,200.00	$ 1,800.00	$ 400.00
22	2.3	Task	Overdue				72.00	$ 150.00	$ 10,800.00			$ -					$ -	$ 14,000.00	$ 10,800.00	$ 3,200.00
23	2.4	Task	In Progress						$ -			$ -				$ 1,650.00	$ 1,650.00	$ 2,000.00	$ 1,650.00	$ 350.00
24	2.5	Task	Not Started						$ -	2.0	$ 8,000.00	$ 16,000.00					$ -	$ 10,000.00	$ 16,000.00	$ (6,000.00)
25	2.6	Task	Not Started						$ -			$ -			$ 8,600.00		$ 8,600.00	$ 8,600.00	$ 8,600.00	$ -
26	2.7	Task	Not Started				40.00	$ 50.00	$ 2,000.00			$ -					$ -	$ 3,000.00	$ 2,000.00	$ 1,000.00
27	2.8	Task	Not Started				160.00	$ 40.00	$ 6,400.00			$ -					$ -	$ 7,500.00	$ 6,400.00	$ 1,100.00
28	2.9	Task	Not Started						$ -			$ -		$ 14,000.00			$ 14,000.00	$ 18,000.00	$ 14,000.00	$ 4,000.00
29									$ 19,200.00			$ 23,200.00	$ 1,800.00	$ 14,000.00	$ 8,600.00	$ 1,650.00	$ 26,050.00	$ 73,800.00	$ 68,450.00	$ 5,350.00
30
31	CLICK HERE TO CREATE IN SMARTSHEET
32
33
34
35
36
37
38
39
40
41																					STATUS KEY
42																					Not Started
43																					In Progress
44																					Complete
45																					On Hold
46																					Overdue
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