Spreadsheet: tracy_geaccone__40387__IPR_JAmbler 2002 budget
Sheet: Detail Expense

2002 Budget Worksheet - EXPENSE
Please enter :
 | KEY ONLY IN BLUE CELLS
 | DO NOT ENTER FIELDS IN RED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2002
 |  | 2001 | 2001 |  |  |  |  |  |  |  |  |  |  |  |  | PLAN
 |  | Plan | Estimate | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
HEADCOUNT
 | HEADCOUNT - FULL TIME | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
 | HEADCOUNT  - PART TIME | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | HEADCOUNT  - VOE/STUDENT LEARNERS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | HEADCOUNT - TEMP/CONTRACTORS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | HEADCOUNT - ANALYST/ASSOCIATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL HEADCOUNT
SALARIES & WAGES
52000500 | SALARIES & WAGES
 | Regular - USE 'SALARY' SHEET | 741469
 | Overtime Pay | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52000500 | TOTAL SALARIES & WAGES
PAYROLL TAXES
59003000 | PAYROLL TAXES (Calculated) | 74054
BENEFITS
52001000 | BENEFITS (Calculated) | 110101
EMPLOYEE EXPENSE
52001500 | EMP - CLUB DUES
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52002000 | EMP - COURSE REG FEES, TUITION
 | Classes for staff | 20604 |  | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52002500 | EMP - OTHER EXPENSE
 | Regional/function meetings | 39996 | 10000 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52003000 | EMP - GROUP MEALS & ENTERTAINMENT
 | Project /work overflow | 13500 |  | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52003500 | EMP - CLIENT MEALS & ENTERTAINMENT
 | Description | 19500 |  | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52004000 | EMP - PROF. MEMBERSHIP DUES
 | PRSA, IABC,IPAD | 5904 | 1820 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52004500 | EMP - TRAVEL & LODGING
 | International/Dom. Travel on Projects | 409464 |  | 25000 | 25000 | 30000 | 30000 | 30000 | 30000 | 30000 | 20000 | 30000 | 30000 | 30000 | 20000
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
 | TOTAL EMPLOYEE EXPENSE
OUTSIDE SERVICES
52507000 | OUTSIDE SERVICES - LEGAL
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52507100 | OUTSIDE SERVICES - AUDIT
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52507200 | OUTSIDE SERVICES - CNTRCT - OH
 | Events, contractors | 150000 |  | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52507300 | OUTSIDE SERVICES - TAX
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52507400 | OUTSIDE SERVICES - IT
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52507500 | OUTSIDE SERVICES - NON PROF. OTHER
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52507600 | OUTSIDE SERVICES - ENGINEERING
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52507700 | OUTSIDE SERVICES - ACCOUNTING
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52508000 | OUTSIDE SERVICES - PROFESSIONAL
 | PR Firms (Int'l/project&regional) | 444996 |  | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
 | TOTAL OUTSIDE SERVICES
GENERAL BUSINESS
52500500 | ADVERTSING EXPENSE
 | Brochures/Ads | 459996 | 170000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52503500 | COMMUNICATIONS EXPENSE
 | GSM/cellular/remote | 15400 |  | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52504000 | COMPANY MEMBERSHIPS & DUES
 | GPAI/HWAC/ | 28896 | 22500 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52504100 | CHARITABLE CONTRIBUTIONS
 | Int'l pilot programs/matches | 60000 | 45000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52504200 | POLITICAL CONTRIBUTIONS
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52504300 | LOBBYING EXPENSES
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52504500 | COMPUTER EXPENSES
 | Description | 7200 |  | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52505000 | [NAME] FEES
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52505500 | FEES & PERMITS
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52506000 | FINES & PENALTIES
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52506500 | INSURANCE
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52508100 | POSTAGE & FREIGHT EXPENSE
 | Description | 4896 | 1684 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52508500 | SUBSCRIPTIONS & PUBLICATIONS
 | Description | 12996 | 7695 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
53600000 | SUPPLIES & EXPENSE
 | Description | 29292 |  | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
53800000 | RENT EXPENSE - PERSONAL PROPERTY
 | Description | 9000 |  | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
53801000 | RENT EXPENSE - REAL PROPERTY
 | Description | 53004 | 22000 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
53900000 | UTILITIES
 | Description | 16404 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
 | TOTAL GENERAL BUSINESS
ALLOCATIONS IN
52502500 | ENRON PROPERTY & SERVICES CO | 53004 | 77966 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52502000 | ENRON INFORMATION SERVICES
 | Long Distance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Plan Based on Headcount (Calculated)
 | Subtotal
52502600 | ANALYST & ASSOCIATE ALLOCATIONS
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
 | TOTAL ALLOCATIONS IN
 | GROSS EXPENSES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Check Sum
 |  |  |  |  |  |  |  |  |  |  |  |  | Check (should equal 0)
69000000 | OTHER INCOME | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0