Spreadsheet: rick_buy__32749__Summary Budget Analysis v2
Sheet: Comparison

RAC
2002 Operating & Strategic Plan
Executive Review Summary
(Thousands of Dollars)
 |  |  | CREDIT RISK |  |  |  |  |  |  |  |  |  | ASSURANCE SERVICES |  |  |  | PORTFOLIO |  |  |  | UNDERWRITING |  |  |  | MARKET RISK |  |  |  | TOTAL RAC |  |  |  |  | Original
 |  |  |  |  | Proposed |  |  |  | Proposed |  |  | Proposed |  |  | Proposed |  |  |  | Proposed |  |  |  | Proposed |  |  |  | Proposed |  |  |  | Proposed |  |  | Proposed
 |  |  | 2001 | 2001 | Plan |  | 2001 | 2001 | Plan | 2001 | 2001 | Plan | 2001 | 2001 | Plan |  | 2001 | 2001 | Plan |  | 2001 | 2001 | Plan |  | 2001 | 2001 | Plan |  | 2001 | 2001 | Plan |  |  | Plan
 | Cost Categories |  | Plan | Estimate | 2002 |  | Plan | Estimate | 2002 | Plan | Estimate | 2002 | Plan | Estimate | 2002 |  | Plan | Estimate | 2002 |  | Plan | Estimate | 2002 |  | Plan | Estimate | 2002 |  | Plan | Estimate | 2002 |  | G/L Accounts | 2002
 |  |  |  |  |  |  | 100053 | 100053 | 100053 | 100872 | 100872 | 100872
Salaries & Wages |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52000500 | 12601
Employee Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52001500 - 52004500 | 1892
Outside Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52507000 - 52508000 | 2783
General Business Expense
Supplies & Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53600000 | 164
Rents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53800000, 53801000 | 13
Other Computer Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52504500 | 203
Advertising & Promotion |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52500500 | 1
Other Business Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52503500, 52504000, 52504100, 52504200, 52504300, 52505000, 52505500, 52506000, 52506500, 52508100, 52508500, 53900000 | 330
 | Subtotal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17987
Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59003000 | 576
Benefits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52001000 | 1823
EIS Charges |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52502000 | 1614
EPSC Charges |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52502500 | 1311
Analyst & Associate Allocations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52502600 | 1300
 | Total Gross Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24611
Less: distributions to business units |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22553
 | Net Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2058
Capital Expenditures |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69000000 | 0
Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141
Plus:  Analysts & Associates |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 151
 | Notes: |  | Salaries & Wages calculated at average salary per position obtained from HR.
 |  |  | Payroll taxes and benefits are calculated automatically based on monthly salaries.
 |  |  | Analyst and Associates budgeted at 2002 allocation rates of $7,800 per Analyst and $12,000 per Associate.
ORIGINAL BUDGET
Headcount |  |  | 36 | 49 | 60 |  | 21 | 15 | 15 | 8 | 9 | 9 | 0 | 0 | 0 |  | 29 | 24 | 24 |  | 34 | 21 | 22 |  | 35 | 24 | 35 |  | 134 | 118 | 141
Plus:  Analysts & Associates |  |  | 0 | 1 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 11 | 10 |  | 0 | 0 | 0 |  | 0 | 12 | 10
Total Headcount |  |  | 36 | 50 | 60 |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 29 | 24 | 24 |  | 34 | 32 | 32 |  | 35 | 24 | 35 |  | 134 | 130 | 151