Departmental Finance Budget Allocation Template.xlsx

	B	C	D	E	G	H	I	J	L	M	N	O
1
2	DEPARTMENTAL FINANCE BUDGET
3
4	SUMMARY
5	Description	Budget	Actual	Variance
6	SALES	$600.00	$400.00	$200.00
7	OPERATIONS	$400.00	$400.00	$0.00
8	HUMAN RESOURCE	$380.00	$500.00	-$120.00
9	FINANCE	$500.00	$380.00	$120.00
10	IT	$200.00	$180.00	$20.00
11	ADMINISTRATIVE	$900.00	$600.00	$300.00
12
13	DEPARTMENT		SALES		DEPARTMENT		OPERATIONS		DEPARTMENT		HUMAN RESOURCE
14	CATEGORY	BUDGET	ACTUAL	VARIANCE	CATEGORY	BUDGET	ACTUAL	VARIANCE	CATEGORY	BUDGET	ACTUAL	VARIANCE
15	Marketing	$ 100.00	$ 100.00	$ -	Salaries	$ 100.00	$ 100.00	$ -	Salaries	$ 80.00	$ 100.00	$ (20.00)
16	Sales Promotions	$ 200.00	$ 100.00	$ 100.00	Rent	$ 100.00	$ 100.00	$ -	Training & Development	$ 100.00	$ 100.00	$ -
17	Travel	$ 300.00	$ 200.00	$ 100.00	Utilities	$ 200.00	$ 200.00	$ -	Recruitment	$ 200.00	$ 300.00	$ (100.00)
18	Training & Development			$ -	Equipment			$ -				$ -
19				$ -				$ -				$ -
20				$ -				$ -				$ -
21	Total:	$ 600.00	$ 400.00	$ 200.00	Total:	$ 400.00	$ 400.00	$ -	Total:	$ 380.00	$ 500.00	$ (120.00)
22
23	DEPARTMENT		FINANCE		DEPARTMENT		IT		DEPARTMENT		ADMINISTRATIVE
24	CATEGORY	BUDGET	ACTUAL	VARIANCE	CATEGORY	BUDGET	ACTUAL	VARIANCE	CATEGORY	BUDGET	ACTUAL	VARIANCE
25	Salaries	$ 300.00	$ 200.00	$ 100.00	Salaries	$ 100.00	$ 80.00	$ 20.00	Office Supplies	$ 300.00	$ 200.00	$ 100.00
26	Software Licenses	$ 100.00	$ 80.00	$ 20.00	Hardware	$ 100.00	$ 100.00	$ -	Utilities	$ 600.00	$ 400.00	$ 200.00
27	Professional Fees	$ 100.00	$ 100.00	$ -	Software			$ -				$ -
28				$ -				$ -				$ -
29				$ -				$ -				$ -
30				$ -				$ -				$ -
31				$ -				$ -				$ -
32	Total:	$ 500.00	$ 380.00	$ 120.00	Total:	$ 200.00	$ 180.00	$ 20.00	Total:	$ 900.00	$ 600.00	$ 300.00
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