Page 124 - Budgeting for Managers

Preparing for Presentation
D
E
C
B
A
F
New
Year
Expenses
2003
Codes
Project
Computers
Replacement Computers Account Support Computers Warehouse 107
$30,000
101
$30,000
New Computers 102 $15,000 $15,000
Warehouse Computers 103 $7,500 $7,500
Warehouse Servers 104 $12,000 $12,000
Computers Subtotal $64,500
Less bulk purchase discount (4%) 191 -$2,580
Total Computers 100 $61,920
Parts
Monitors 201 $3,000 $900 $3,900
Hard Drives 202 $1,800 $1,500 $3,300
Graphics Monitors 203 $1,000 $1,000
Other 210 $1,200 $500 $1,700
Total Parts 200 $9,900
Tools
Total Tools 300 $800 $800
Supplies
Computer Cleaning 401 $1,000 $1,000
Other 410 $500 $500
Total Supplies 400 $1,500
Specialized Software
Inventory Software 501 $30,000 $30,000
Total Specialized Software 500 $30,000
Subcontractor Services
Analysis and design 601 $20,000 $20,000
Development 602 $15,000 $15,000
Installation 603 $7,000 $7,000
Total Subcontractor services 600 $42,000
Shipping
Total Shipping 800 $1,200 $400 $1,600
Sales Tax
Sales Tax 901 $2,625 $1,253 $3,535 $7,413
Adjustment due to discount 991 -$103
Total Sales Tax 900 $7,310
Total Computer Department
Budget $155,030
Table 7-4. Computer department consolidated budget
Revising Budgetary Assumptions
As you work on the details of your budget, it’s good to take
notes and keep track of your thinking. Initially, you write notes