Spreadsheet: richard_shapiro__32386__Worksheet Shapiro 100072
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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 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 | 0 | 0
 | 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) | 0 | 0
BENEFITS
52001000 | BENEFITS (Calculated) | 0 | 0
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
 | Description | 0 | 8000 | 666.67 | 666.67 | 666.67 | 666.67 | 666.67 | 666.67 | 666.67 | 666.67 | 666.67 | 666.67 | 666.67 | 666.67
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52002500 | EMP - OTHER EXPENSE
 | 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
52003000 | EMP - GROUP MEALS & ENTERTAINMENT
 | Description | 0 | 14000 | 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
52003500 | EMP - CLIENT MEALS & ENTERTAINMENT
 | Description | 0 | 19000 | 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
52004000 | EMP - PROF. MEMBERSHIP DUES
 | Description | 0 | 0 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52004500 | EMP - TRAVEL & LODGING
 | Description | 300000 | 117000 | 20833.33 | 20833.33 | 20833.33 | 20833.33 | 20833.33 | 20833.33 | 20833.33 | 20833.33 | 20833.33 | 20833.33 | 20833.33 | 20833.33
 | 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
 | 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
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
 | Description | 0 | 12000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
 | TOTAL OUTSIDE SERVICES
GENERAL BUSINESS
52500500 | ADVERTSING EXPENSE
 | Description | 0 | 10000 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52503500 | COMMUNICATIONS EXPENSE
 | Description | 0 | 12000 | 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
52504000 | COMPANY MEMBERSHIPS & DUES
 | Description | 0 | 0 | 416.67 | 416.67 | 416.67 | 416.67 | 416.67 | 416.67 | 416.67 | 416.67 | 416.67 | 416.67 | 416.67 | 416.67
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
52504100 | CHARITABLE CONTRIBUTIONS
 | Description | 0 | 21750 | 1812.5 | 1812.5 | 1812.5 | 1812.5 | 1812.5 | 1812.5 | 1812.5 | 1812.5 | 1812.5 | 1812.5 | 1812.5 | 1812.5
 | 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 | 9996 | 3000 | 541.67 | 541.67 | 541.67 | 541.67 | 541.67 | 541.67 | 541.67 | 541.67 | 541.67 | 541.67 | 541.67 | 541.67
 | 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 | 0 | 250 | 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
52508500 | SUBSCRIPTIONS & PUBLICATIONS
 | Description | 0 | 10000 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33 | 833.33
 | Description | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal
53600000 | SUPPLIES & EXPENSE
 | Description | 45552 | 600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Description | 0 | 9400 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
 | Subtotal
53800000 | RENT EXPENSE - PERSONAL PROPERTY
 | Chad Landry living expenses | 0 | 8500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Copier/fax lease/purchase | 0 | 0 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67 | 166.67
 | Subtotal
53801000 | RENT EXPENSE - REAL PROPERTY
 | Description | 26520 | 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
53900000 | UTILITIES
 | Description | 0 | 1700 | 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 | 0 | 8000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52502000 | ENRON INFORMATION SERVICES
 | Long Distance | 0 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Plan Based on Headcount (Calculated) | 0 | 0
 | 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