ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Important: How to Use This Editable ADU Budget
3
4
*** You cannot change any cells in this document - you must first make a copy of it for your personal use in order to edit it. To make a copy, go to the Menu above and select "File --> Make a Copy"***
5
6
Do not modify any cells that are shaded in any way - these are automated calculation fields.
7
8
There are two Sheets in this document (see the labeled tabs at the bottom of the document):
(1) Roll up Budget Sheet is largely comprised of amounts pulled from the second sheet, which is the Line Item Budget Sheet
(2) Budget Line Item Sheet -- do not adjust the shaded total cells in this sheet or they will not auto-calculate correctly.
9
10
Most of your work will be done on the Line Item Budget Sheet. Within the Line Item Budget Sheet, you can enter the following:
11
12
ESTIMATED COSTS - This is your projected budget. For each line item you have a space to enter Materials Cost and Labor Cost. You do not need to enter the total - this is calculated for you. The subtotal for each category is calculated and carried onto the Budget Roll Up Sheet for quick reference. You do NOT need to enter 0 for any items you are not including in the budget, the totals are calculated presuming 0s where spaces are empty.
13
14
ACTUAL COST - This is your billed amount. Enter invoices as you receive them on the appropriate line. Subtotals are calculated automatically.
15
16
VARIANCE - This is a calculation showing the difference between the budgeted total and the invoiced total.
17
18
CURRENT PAID - This is the amount you have spent so far. Enter payments on the appropriate line item.
19
20
AMOUNT DUE - This is a calculation column showing invoiced amount minus amount you have paid.
21
22
23
Safe Guards: Safe guards have been built into the workbook so totals can be compared from one page to the other and any errors can be checked
24
25
SUBTOTALS - There are entire columns in the Line Item Budget Sheet dedicated to subtotals: the only cells in these columns that will have data in them are the category totals. These are then used in the Budget Roll Up Sheet as well as in the final rows in the Line Item Budget Sheet. Here each Category Subtotal is added together to get a Total Budget. In addition, each of the columns are totalled separately. These totals should be monitored to ensure they are equal and no line items are being missed in the Budget Roll Up Sheet.
26
27
28
29
30
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