IC-Simple-Project-Budget-Template_Google-Sheets

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

2	SIMPLE PROJECT BUDGET TEMPLATE					https://www.smartsheet.com/try-it?trp=11292&utm_source=integrated+content&utm_campaign=/content/project-budget-templates&utm_medium=Simple+Project+Budget+google+sheets+11292&lpa=Simple+Project+Budget+google+sheets+11292&lx=PFpZZjisDNTS-Ddigi3MyABAgeTPLDIL8TQRu558b7w							https://www.smartsheet.com/try-it?trp=11292&utm_source=integrated-content&utm_campaign=/content/project-budget-templates&utm_medium=Simple+Budget+Plan+google+sheets+11292&lpa=Simple+Budget+Plan+google+sheets+11292
3	User to complete non-shaded cells only.						LABOR			MATERIALS			FIXED			BALANCE
4	TASK	DESCRIPTION	STATUS	PLANNED START DATE	ACTUAL START DATE	END DATE	HR	$/HR	TOTAL LABOR	UNITS	$/UNITS	TOTAL MATERIALS	TRAVEL	EQUIPMENT / SPACE	MISC.	BUDGET	ACTUAL	UNDER/OVER
5	PROJECT 1
6	Task		Not Started				4.0	$40.00	$160	12.0	$15.00	$180	$500	$600	$50	$ 200	$ 1,490	$ 1,290
7	Task		In Progress				8.0	$15.00	$120	22.0	$14.00	$308	$200	$600	$100	$ 1,500	$ 1,328	$ (172)
8	Task		Complete						$0	50.0	$11.00	$550			$300	$ 100	$ 850	$ 750
9	Subtask		Needs Review				6.0	$10.00	$60	44.0	$45.00	$1,980				$ 2,040	$ 2,040	$ -
10	Subtask		Approved						$0	3.0	$500.00	$1,500			$7,500	$ 12,500	$ 9,000	$ (3,500)
11	Subtask		Overdue						$0			$0					$ -	$ -
12	Subtask		On Hold						$0			$0					$ -	$ -
13	Task								$0			$0					$ -	$ -
14	Task								$0			$0					$ -	$ -
15	SUBTOTAL								$340			$4,518	$700	$1,200	$7,950	$ 16,340	$ 14,708	$ (1,632)
16
17	User to complete non-shaded cells only.						LABOR			MATERIALS			FIXED			BALANCE
18	TASK	DESCRIPTION	STATUS	PLANNED START DATE	ACTUAL START DATE	END DATE	HR	$/HR	TOTAL LABOR	UNITS	$/UNITS	TOTAL MATERIALS	TRAVEL	EQUIPMENT / SPACE	MISC.	BUDGET	ACTUAL	UNDER/OVER
19	PROJECT 2
20	Task		Not Started				5.0	$50.00	$250			$0				$ 200	$ 250	$ 50
21	Task		In Progress						$0			$0		$1,100		$ 1,500	$ 1,100	$ (400)
22	Task		Complete						$0	1.0	$150.00	$150				$ 100	$ 150	$ 50
23	Subtask		Needs Review						$0			$0	$1,800			$ 2,040	$ 1,800	$ (240)
24	Subtask		Approved						$0			$0		$25,000		$ 23,500	$ 25,000	$ 1,500
25	Subtask		Overdue				85.0	$75.50	$6,418			$0				$ 2,500	$ 6,418	$ 3,918
26	Subtask		On Hold						$0			$0					$ -	$ -
27	Task								$0			$0					$ -	$ -
28	Task								$0			$0					$ -	$ -
29	SUBTOTAL								$6,668			$150	$1,800	$26,100	$0	$ 29,840	$ 34,718	$ 4,878
30
31	CLICK HERE TO CREATE IN SMARTSHEET
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