Page 115 - Budgeting for Managers

Budgeting for Managers
98
C
B
A
D
E
1
Total
March
January
$5,200.00
2 Salary
$500.00
3Utilities $5,000.00 February $4,400.00 SUM(B2:D2) F
$450.00
SUM(B3:D3)
$200.00
4 Insurance $250.00 $250.00 $250.00 SUM(B4:D4)
$450.00
5 Printing $300.00 $100.00 $450.00 SUM(B5:D5)
$5,550.00
6Total SUM(B2:B5) SUM(C2:C5) SUM(D2:D5) SUM(B6:D6) SUM(E2:E5)
7 E6–F6
Table 6-3. Spreadsheet error checking, formulas
A B C D E F
1 January February March Total
2 Salary $5,000.00 $5,200.00 $4,400.00 $14,600.00
3Utilities $500.00 $200.00 $450.00 $1,150.00
4 Insurance $250.00 $250.00 $250.00 $750.00
5 Printing $300.00 $100.00 $450.00$450.00 $850.00
6Total $6,050.00 $5,750.00 $5,550.00 $17,550.00 $17,350.00
$5,750.00
7 $200.00
Table 6-4. Spreadsheet error checking, example of an error
spreadsheet you create will be error-free. But a budget is more
than just one spreadsheet.
There are three more very common mistakes you need to
prevent. The first mistake is completing a budget, but then
sending an earlier version instead of the final, correct version.
The second mistake is having several spreadsheets and budget
documents and not checking to make sure that they match. You
may make sure they match, but then change one and forget to
change the other. The third mistake is allowing two people to
make changes to the same document at the same time. If you
do this, you end up with two different documents, and it’s a real
pain to combine the two to include changes from both editors.
You prevent these problems with good version control,