Spreadsheet: sally_beck__36190__Consolidated Analytics - 2
Sheet: VP

 |  | Cost Center NAME: | 105170 |  |  | Due Date: | 2000-09-29 00:00:00
 |  | Cost Center OWNER: | [NAME]
STAFFING SUMMARY |  |  | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
Sr Director
Director
Manager
Sr Specialist
Specialist
Administrative Asst.
Associates/Analysts
Administrative Asst.
Subtotal Employee Headcount |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contractors
TOTAL HEADCOUNT |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DIRECT EXPENSES | Account Number |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Total |  | 2000 Annualized
Salaries & Wages |  |  | 18900 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 237360 |  |  |  | 185737.5
Special Pays |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal Compensation |  |  | 18900 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 19860 | 237360
Benefits |  |  | 2567.15 | 2656.91 | 2656.91 | 2656.91 | 2656.91 | 2656.91 | 2656.91 | 2656.91 | 2656.91 | 2656.91 | 2656.91 | 2656.91 | 31793.16 |  |  |  | 17619.05
Payroll Taxes |  |  | 1701 | 6059.88 | 1787.4 | 1787.4 | 1787.4 | 1787.4 | 1787.4 | 1787.4 | 1787.4 | 1787.4 | 1787.4 | 1787.4 | 25634.88
Subtotal Benefits and Payroll Taxes |  |  | 4268.15 | 8716.79 | 4444.31 | 4444.31 | 4444.31 | 4444.31 | 4444.31 | 4444.31 | 4444.31 | 4444.31 | 4444.31 | 4444.31 | 57428.04
Club Dues | 52001500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Tuition Reimbursement/Registration Fee/Ed | 52002000 |  | 370 | 370 | 370 | 370 | 370 | 370 | 370 | 370 | 370 | 370 | 370 | 370 | 4440 |  |  |  | 3502.95
Expenses Other | 52002500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 469.5
Group Meals & Entertainment | 52003000 |  | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 2400 |  |  |  | 1785.06
Client Meals & Entertainment | 52003500 |  | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 1800 |  |  |  | 1333.38
Professional Memberships | 52004000 |  | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 300 |  |  |  | 178.77
Travel & Lodging | 52004500 |  | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 19200 |  |  |  | 13784.95
General Business & Admin Expenses | 54005000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal Employee Expenses |  |  | 2345 | 2345 | 2345 | 2345 | 2345 | 2345 | 2345 | 2345 | 2345 | 2345 | 2345 | 2345 | 28140
Legal | 52507000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Audit | 52507100 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Contract for Overhead | 52507200 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Tax | 52507300 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
IT | 52507400 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other | 52507500 |  | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 12600 |  |  |  | 9187.6
Engineering | 52507600 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Accounting | 52507700 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Professionals | 52508000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 8.89
Subtotal Outside Services |  |  | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 12600
Subscriptions & Publications | 52508500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Postage & Freight Expense | 52508100 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 119.19
Fees & Permits | 52505500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Company Membership & Dues | 52504000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Materials & Supplies - Stock | 53500000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Materials & Supplies - Non Stock | 53500500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Price [NAME] | 53550000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Supplies & Expense | 53600000 |  | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 10200 |  |  |  | 7083.21
Provision for Scrap | 53551000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal Materials & Supplies |  |  | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 10200
Advertising Expense | 52500500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal Marketing |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rent - Personal Property | 53800000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 1528.07
Rent - Real Property | 53801000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | -1229.6
Subtotal Rent (3rd Party) |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Communications Expense | 52503500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 5884.89
Computer Expense | 52504500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal Technology |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Vehicle/Equpment Fuel | 54000000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal Transportation |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bad Debt
Corporate Charges |  |  | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 9000
Other Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 73371.04
Subtotal Corporate Expenses
Depreciation |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Amortization |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal Depreciation & Amortization |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL DIRECT EXPENSES |  |  | 28163.15 | 33571.79 | 29299.31 | 29299.31 | 29299.31 | 29299.31 | 29299.31 | 29299.31 | 29299.31 | 29299.31 | 29299.31 | 29299.31 | 354728.04
 |  | [ position | 9
 |  | ] position | 32
 |  | difference | 23
 |  | total length | 43
 |  |  | 2001 Plan - 105170
 |  |  | [NAME]