Page 122 - Budgeting for Managers

Account
Year 2003
Expenses
Codes
$30,000
Replacement Computers
101
Parts
Monitors Preparing for Presentation 105
201
$3,000
Hard drives 202 $1,800
Other 210 $1,200
Total Parts 200 $6,000
Tools 300 $800
Supplies
Computer cleaning 401 $1,000
Other 410 $500
Total Supplies 400 $1,500
Shipping 800 $1,200
Sales Tax 900 $2,625
Expense Total $42,125
Table 7-1. Computer support expenses
Account
Expenses Year 2003
Codes
New Computers 102 $15,000
Parts
Monitors 201 $900
Hard Drives 202 $1,500
Other 210 $500
Total Parts 200 $2,900
Shipping 800 $400
Sales Tax 900 $1,253
Expense Total $19,553
Table 7-2. New staff computer project budget

the columns by budget. Then we enter and total the numbers,
as described in the instructions below.
Table 7-4 illustrates all of the steps for consolidating a budg-
et except #10, putting in cross-check calculations. We leave this
as an exercise for you. Pay close attention to the discounts that
appear only in the totals column.