Docstoc

Budget Template 08-04-11 - WSU Extension

Document Sample
Budget Template 08-04-11 - WSU Extension Powered By Docstoc
					Updated 07/06/11

      Budget Template Instructions

      1. Please read Guideline 2: Budget Assistance Information for Preparing Sponsored Program Proposals at
      http://www.ogrd.wsu.edu/guidelines/guideline2/Guideline2.pdf for complete budgeting information.

      2. The personnel sections of the budget are set up to calculate costs based on the information entered into the yellow highlighted
      areas.

      3. There are three benefit rates for Faculty, Exempt, and Civil Service & Barganing Units listed. To view and select the app ropriate
      rate for the person you arerequesting funds for, please click in the cell that shows "30.8%" next to "Benefits". Once you cl ick on the
      cell you will be able to choose one of the following items from the drop down menu:
      FY-2011
      30.8 % - Faculty
      34% - Exempt
      39.65% - Civil Service & Bargaining Units

      If you decide to use an actual benefit rate rather than the weighted average, click on the cell with 30.8%, go to the "Home" task bar
      at the top of the page, go to "Editing", click on "Clear", then click on "Clear All". The cell will now allow you to enter an actual rate
      and the formatting in the remainder of the page will remain the same. Once you click out of the cell, the pop -up box with
      information will disappear.

      4. When calculating the PhD Student and Master Student Salary, QTR, and Health in the first year of your proposed budget, pl ease
      use the appropriate Matrix provided in the Excel workbook for your area (e.g. General, COS, DVM, etc.).

      5. Inflation rates for QTR: for DVM students - 16%; For PharmD, MBA (Pullman Campus only), & Nursing students - 16%,current
      inflation rate for all other students (Grad/PhD)QTR is 16% - please adjust the formulas in the QTR cells as necessary. You will have
      to adjust the inflation rate in each year of the proposed budget after year 1.

      Please note the 16% QTR inflation is recommended through 6/30/2013. Starting 7/1/13, please use a 7% inflation rate.

      6. Column O on the Sponsor and Cost Share budget worksheets is an additional mechanism for "checking" the proposed budget.
      Column O is similar to Column N , however, Column O sums the row (horizontally) rather then the column (vertically).




http://sps.wsu.edu/File/2011%20FA%20Rate%20Agreement.pdf                                                            2011-2015 F&A rates
                 PI's Name:                                                                                                                 7/1/2011           7/1/2012          7/1/2013        7/1/2014       7/1/2015        7/1/2016        TOTAL
                 Agency: NIH R21 - MODULAR                                                                                                  6/30/2012         6/30/2013         6/30/2014       6/30/2015       6/30/2016       6/30/2017

                 SALARIES - 00                      Pay Rate      # Mos.                    % FTE

                 PI:                                       0.00      12.00                  0.00%                                Salary                 -                 -                 -               -               -               -           -

                                                                                                               Benefits           30.8%                 -                 -                 -               -               -               -           -

                 Co-PI:                                    0.00      12.00                  0.00%                                Salary                 -                 -                 -               -               -               -           -

                                                                                                               Benefits           30.8%                 -                 -                 -               -               -               -           -

                 Co-PI:                                    0.00         0.00                0.00%                                Salary                 -                 -                 -               -               -               -           -

                                                                                                               Benefits           30.8%                 -                 -                 -               -               -               -           -

                 Co-PI:                                    0.00         0.00                0.00%                                Salary                 -                 -                 -               -               -               -           -

                                                                                                               Benefits           30.8%                 -                 -                 -               -               -               -           -

                 Co-PI:                                    0.00         0.00                0.00%                                Salary                 -                 -                 -               -               -               -           -

                                                                                                               Benefits           30.8%                 -                 -                 -               -               -               -           -

                 Post-Doc/Research Assoc:                  0.00         0.00                0.00%                                Salary                 -                 -                 -               -               -               -           -

                                                                                                               Benefits           30.8%                 -                 -                 -               -               -               -           -

                 Classfied Staff:                          0.00         0.00                0.00%                                Salary                 -                 -                 -               -               -               -           -

                                                                                                               Benefits         39.65%                  -                 -                 -               -               -               -           -

                 PhD Student ~ Step#                                                                                             Salary                 -                 -                 -               -               -               -           -

                                                    QTR inflation 16% though 6/30/13; 7% starting 7/1/13                             QTR                -                 -                 -               -               -               -           -

                                                                                                                                Health                  -                 -                 -               -               -               -           -

                                                                                                                                     1.5%               -                 -                 -               -               -               -           -

                 Master Student ~ Step#                                                                                          Salary                 -                 -                 -               -               -               -           -

                                                                                                                                     QTR                -                 -                 -               -               -               -           -

                                                                                                                                Health                  -                 -                 -               -               -               -           -
                                                                                                                                     1.5%               -                 -                 -               -               -               -           -

                 WAGES - 01                          $ Per Hr.    Hrs/Wks                   # Wks.

                 Student:                                $0.00              0                        0                          Wages                   -                 -                 -               -               -               -           -

                                                                                                               Benefits              2.0%               -                 -                 -               -               -               -           -

                 Student (enrolled part-time ) :         $0.00              0                        0                          Wages                   -                 -                 -               -               -               -           -

                                                                                                               Benefits              9.6%               -                 -                 -               -               -               -           -

                 *Non-Student Temporary                  $0.00              0                        0                          Wages                   -                 -                 -               -               -               -           -

                                                                                                               Benefits              9.6%               -                 -                 -               -               -               -           -

                 **Non-Student Temporary                 $0.00              0                        0                          Wages                   -                 -                 -               -               -               -           -

                                                                                                               Benefits           14.9%                 -                 -                 -               -               -               -           -

                 ***Non Student Temporary                $0.00              0                        0                          Wages                   -                 -                 -               -               -               -           -

                                                                                                               Benefits           76.6%                 -                 -                 -               -               -               -           -

                                                                                                                           Total Salary                 -                 -                 -               -               -               -           -

                                                                                                                           Total Wages                  -                 -                 -               -               -               -           -

                                                                                                                 Total Salary & Wages                   -                 -                 -               -               -               -           -

                 BENEFITS - 07

                                                                                                                          Total Benefits                -                 -                 -               -               -               -           -
                                                                                                     Total Salaries/Wages/Benefits                      -                 -                 -               -               -               -           -

                 PERSONAL SERVICES CONTRACTS -02

                                                                                                                                                        -                 -                 -               -               -               -           -
                                                                                                  Total Personal Services Contracts                     -                 -                 -               -               -               -           -

                 GOODS/SERVICES - 03

                                                                                                                                                                                                                                                        -

                                                                                                                                                                                                                                                        -

                                                                                                                                                                                                                                                        -

                                                                                                                                                                                                                                                        -

                                                                                                                                                                                                                                                        -

                                                                                                                                                                                                                                                        -

                                                                                                                 Total Goods/Services                   -                 -                 -               -               -               -           -

                 TRAVEL - 04

                 Domestic                                                                                                                                                                                                                               -

                 Foreign                                                                                                                                                                                                                                -

                                                                                                                           Total Travel                 -                 -                 -               -               -               -           -

                 COMPUTER SERVICES - 05

                                                                                                                                                                                                                                                        -

                                                                                                                                                                                                                                                        -

                                                                                                                                                                                                                                                        -

                                                                                                             Total Computer Services                    -                 -                 -               -               -               -           -

                 CAPITAL EQUIPMENT - 06 ($5,000 +)

                                                                                                                                                                                                                                                        -

                                                                                                                                                                                                                                                        -

                                                                                                                                                                                                                                                        -

                                                                                                              Total Capital Equipment                   -                 -                 -               -               -               -           -

                 STIPENDS/SUBSIDES/PARTICIPANT SUPPORT COSTS - 08

                                                                                                                                                                                                                                                        -

                                                                                Total Stipends/Subsides/Participant Support Costs                       -                 -                 -               -               -               -           -

                 SUBCONTRACTS/RESTRICTED - 14

                 University One                       YR-1         YR-1         YR-2        YR-3              YR-4            YR-5

                                              SBCT DC                                                                                                   -                 -                 -               -               -               -           -

                                              SBCT IC (36%)                                                                                             -                 -                 -               -               -               -           -

                 University Two                       YR-1         YR-1         YR-2        YR-3              YR-4            YR-5

                                              SBCT DC                                                                                                   -                 -                 -               -               -               -           -

                                              SBCT IC (26%)                                                                                             -                 -                 -               -               -               -           -

                                                                                                             Total Subcontractor DC                     -                 -                 -               -               -                           -

                                                                                                              Total Subcontractor IC                    -                 -                 -               -               -                           -

                                                                                                     Total Subcontracts/Restricted                      -                 -                 -               -               -                           -
                   Small & Attractive Items - 16
http://public.wsu.edu/~forms/HTML/BPPM/70_Purchasing/70.09_Expenditure_Objects_and_Subobjects.htm#state

                 Laptop (agency approval required)                                                                                                                                                                                                      -

                                                                                                                             Total S&A                  -                 -                 -               -               -               -           -

                 MODULAR amount to request (HAND ENTER; do not include Consortium F&A)                                                          50,000              50,000          100,000         100,000                                     300,000

                 TOTAL DIRECTS (DCs & Consortium F&A)- before exclusions                                                                        50,000              50,000          100,000         100,000                 -               -   300,000
                 ACTUAL DIRECT COSTS                                                                                                                    -                 -                 -               -               -               -           -

                 Direct Cost Variance (+/-)    Last Column (cumulative) should equal zero                                                       50,000              50,000          100,000         100,000                 -               -   300,000

                 EXCLUSIONS

                 QTR                                                                                                                                    -                 -                 -               -               -               -           -

                 Equipment (Over 5k)                                                                                                                    -                 -                 -               -               -               -           -

                 Subcontracts, amt excluding first 25K (per subcontract), HAND ENTER.                                                                                                                                                                   -

                 Other (Off-Site Rental & Stipends, Etc)                                                                                                -                 -                 -               -               -               -           -

                                                                                                                       Total Exclusions                 -                 -                 -               -               -               -           -

                                                                                                                                  Base                  -                 -                 -               -               -               -           -

                                                                                                                               50.000%                  -                                                                                               -
                 Modular F&A to request F&A - 13 CHECK FOR F&A RATE INCREASE 7/1/2012 - ON CAMPUS RATE
                                                     INCREASES TO 51%                                                          51.000%                                    -                 -               -               -               -           -

                 TOTAL ACTUAL COSTS                                                                                                                     -                 -                 -               -               -               -           -

                 TOTAL MODULAR COSTS, rounding could result in $1 difference-adj manually                                                       50,000               50,000          100,000        100,000                 -               -    300,000

                           F&A Base Type:                         MTDC           TD          TC                SWB           Other

                                            0.500       0.510       X                                                                                       Cognizant Agency DHHS - Helen Fung, 415-437-7820



                                                                                                         Category/Object                     Year 1             Year 2            Year 3          Year 4          Year5                         Total

                                                                                                                           Salaries - 00                -                 -                 -               -               -               -           -
                 Approved By:                                                                                              Wages - 01                   -                 -                 -               -               -               -           -
                                                                                                         Personal Service Contract - 02                 -                 -                 -               -               -               -           -

                                                                                                                 Goods/Services - 03                    -                 -                 -               -               -               -           -
                 Date:                                                                                                       Travel - 04                -                 -                 -               -               -               -           -

                                                                                                               Computer Services - 05                   -                 -                 -               -               -               -           -

                                                                                                                       Equipment - 06                   -                 -                 -               -               -               -           -

                                                                                                                           Benefits - 07                -                 -                 -               -               -               -           -

                                                                                                               Stipends/Subsides - 08                   -                 -                 -               -               -               -           -

                                                                                                         Subcontracts/Restricted - 14                   -                 -                 -               -               -               -           -

                                                                                                            Small/Attractive Items - 16                 -                 -                 -               -               -               -           -

                                                                                                                     Total Direct Costs                 -                 -                 -               -               -               -           -

                                                                                                                               F&A - 13                 -                 -                 -               -               -               -           -

                                                                                                                            Total Costs                 -                 -                 -               -               -               -           -



                                                                                                                                                                                                                                                                                                     Approved by
                                                                                                                                                                                                                                                                                                       11/21/2011
                                                                                                                                                                                                                                                  C:\Docstoc\Working\pdf\0b4a3338-19ae-4f2e-8521-ee2057320b71.xlsx
                 PI's Name:                                                                                                                    7/1/2011           7/1/2012          7/1/2013         7/1/2014            7/1/2015          7/1/2016           TOTAL
                 Agency:                                                                                                                       6/30/2012         6/30/2013         6/30/2014        6/30/2015           6/30/2016         6/30/2017
                 SALARIES - 00                      Pay Rate        # Mos.                    % FTE
                 PI:                                  6,513.50             12.00              25.00%                                 Salary         19,541              20,322                                                       -                 -         39,863
                                                                                                                 Benefits             30.8%          6,018               6,259                                                       -                 -         12,278
                 Co-PI:                                     0.00           12.00              0.00%                                  Salary                -                  -                 -               -                    -                 -                 -
                                                                                                                 Benefits             30.8%                -                  -                 -               -                    -                 -                 -
                 Co-PI:                                     0.00            0.00              0.00%                                  Salary                -                  -                 -               -                    -                 -                 -
                                                                                                                 Benefits             30.8%                -                  -                 -               -                    -                 -                 -
                 Co-PI:                                     0.00            0.00              0.00%                                  Salary                -                  -                 -               -                    -                 -                 -
                                                                                                                 Benefits             30.8%                -                  -                 -               -                    -                 -                 -
                 Co-PI:                                     0.00            0.00              0.00%                                  Salary                -                  -                 -               -                    -                 -                 -
                                                                                                                 Benefits             30.8%                -                  -                 -               -                    -                 -                 -
                 Post-Doc/Research Assoc:                   0.00            0.00              0.00%                                  Salary                -                  -                 -               -                    -                 -                 -
                                                                                                                 Benefits             30.8%                -                  -                 -               -                    -                 -                 -
                 Classfied Staff:                           0.00            0.00              0.00%                                  Salary                -                  -                 -               -                    -                 -                 -
                                                                                                                 Benefits           39.65%                 -                  -                 -               -                    -                 -                 -
                 PhD Student ~ Step#                                                                                                 Salary                -                  -                 -               -                    -                 -                 -
                                                    QTR inflation 16% though 6/30/13; 7% starting 7/1/13                               QTR                 -                  -                 -               -                    -                 -                 -
                                                                                                                                    Health                 -                  -                 -               -                    -                 -                 -
                                                                                                                                       1.5%                -                  -                 -               -                    -                 -                 -
                 Master Student ~ Step#                                                                                              Salary                -                  -                 -               -                    -                 -                 -
                                                                                                                                       QTR                 -                  -                 -               -                    -                 -                 -
                                                                                                                                    Health                 -                  -                 -               -                    -                 -                 -
                                                                                                                                       1.5%                -                  -                 -               -                    -                 -                 -
                 WAGES - 01                          $ Per Hr.      Hrs/Wks                   # Wks.
                 Student:                                  $0.00              0                        0                            Wages                  -                  -                 -               -                    -                 -                 -
                                                                                                                 Benefits              2.0%                -                  -                 -               -                    -                 -                 -
                 Student (enrolled part-time ) :        $15.00     1.92307692                          1                            Wages                750                780               811             844                 877               913           4,975
                                                                                                                 Benefits              9.6%               72                 75                78             81                    84                88               478
                 *Non-Student Temporary                    $0.00              0                        0                            Wages                  -                  -                 -               -                    -                 -                 -
                                                                                                                 Benefits              9.6%                -                  -                 -               -                    -                 -                 -
                 **Non-Student Temporary                   $0.00              0                        0                            Wages                  -                  -                 -               -                    -                 -                 -
                                                                                                                 Benefits             14.9%                -                  -                 -               -                    -                 -                 -
                 ***Non Student Temporary                  $0.00              0                        0                            Wages                  -                  -                 -               -                    -                 -                 -
                                                                                                                 Benefits             76.6%                -                  -                 -               -                    -                 -                 -
                                                                                                                                Total Salary        19,541              20,322                  -               -                    -                 -         39,863
                                                                                                                               Total Wages               750                780               811             844                 877               913           4,975
                                                                                                                   Total Salary & Wages             20,291              21,102                811             844                 877               913          44,837
                 BENEFITS - 07
                                                                                                                              Total Benefits         6,090               6,334                 78             81                    84                88         12,755
                                                                                                           Total Salaries/Wages/Benefits            26,381              27,436                889             925                 962             1,000          57,593
                 PERSONAL SERVICES CONTRACTS -02
                                                                                                                                                           -                  -                 -               -                    -                 -                 -
                                                                                                     Total Personal Services Contracts                     -                  -                 -               -                    -                 -                 -
                 GOODS/SERVICES - 03
                                                                                                                                                                                                                                                                         -
                                                                                                                                                                                                                                                                         -
                                                                                                                                                                                                                                                                         -
                                                                                                                                                                                                                                                                         -
                                                                                                                                                                                                                                                                         -
                                                                                                                                                                                                                                                                         -
                                                                                                                  Total Goods/Services                     -                  -                 -               -                    -                 -                 -
                 TRAVEL - 04
                 Domestic                                                                                                                                                                                                                                                -
                 Foreign                                                                                                                                                                                                                                                 -
                                                                                                                                Total Travel               -                  -                 -               -                    -                 -                 -
                 COMPUTER SERVICES - 05
                                                                                                                                                                                                                                                                         -
                                                                                                                                                                                                                                                                         -
                                                                                                                                                                                                                                                                         -
                                                                                                               Total Computer Services                     -                  -                 -               -                    -                 -                 -
                 CAPITAL EQUIPMENT - 06 ($5,000 +)
                                                                                                                                                                                                                                                                         -
                                                                                                                                                                                                                                                                         -
                                                                                                                                                                                                                                                                         -
                                                                                                                Total Capital Equipment                    -                  -                 -               -                    -                 -                 -
                 STIPENDS/SUBSIDES/PARTICIPANT SUPPORT COSTS - 08
                                                                                                                                                                                                                                                                         -
                                                                                   Total Stipends/Subsides/Participant Support Costs                       -                  -                 -               -                    -                 -                 -
                 SUBCONTRACTS/RESTRICTED - 14




                                                                                          Total Subcontracts/Restricted                                    -                  -                 -               -                    -                 -                 -
                   Small & Attractive Items - 16
http://public.wsu.edu/~forms/HTML/BPPM/70_Purchasing/70.09_Expenditure_Objects_and_Subobjects.htm#state
                 Laptop (agency approval required)                                                                                                                                                                                                                       -
                                                                                                                                  Total S&A                -                  -                 -               -                    -                 -                 -
                 TOTAL DIRECT COSTS                                                                                                                 26,381              27,436                889             925                 962             1,000          57,593
                 EXCLUSIONS
                 QTR                                                                                                                                       -                  -                 -               -                    -                 -                 -
                 Equipment (Over 5k)                                                                                                                       -                  -                 -               -                    -                 -                 -
                 Subcontracts, amt excluding first 25K (per subcontract), HAND ENTER                                                                                                                                                                                     -
                 Other (Off-Site Rental & Stipends, Etc)                                                                                                   -                  -                 -               -                    -                 -                 -
                                                                                                                            Total Exclusions               -                  -                 -               -                    -                 -                 -
                                                                                                                                      Base          26,381              27,436                889             925                 962             1,000          57,593
                 F&A - 13 CHECK FOR F&A RATE INCREASE 7/1/2012 - ON CAMPUS RATE INCREASES TO 51%                                   50.000%          13,190                                                                                                       13,190
                 F&A - 13 CHECK FOR F&A RATE INCREASE 7/1/2012 - ON CAMPUS RATE INCREASES TO 51%                                   51.000%                              13,992                453             472                 490               510          15,918
                 TOTAL COSTS                                                                                                                        39,571              41,429            1,343           1,396                1,452              1,510          86,701
                           F&A Base Type:                           MTDC           TD           TC              SWB              Other
                                            0.500       0.510          X                                                                                       Cognizant Agency DHHS - Helen Fung, 415-437-7820


                                                                                                           Category/Object                      Year 1             Year 2            Year 3          Year 4               Year5                                Total
                                                                                                                               Salaries - 00        19,541              20,322                  -               -                    -                 -         39,863
                 Approved By:                                                                                                  Wages - 01                750                780               811             844                 877               913           4,975
                                                                                                           Personal Service Contract - 02                  -                  -                 -               -                    -                 -                 -
                                                                                                                   Goods/Services - 03                     -                  -                 -               -                    -                 -                 -
                 Date:                                                                                                           Travel - 04               -                  -                 -               -                    -                 -                 -
                                                                                                                Computer Services - 05                     -                  -                 -               -                    -                 -                 -
                                                                                                                        Equipment - 06                     -                  -                 -               -                    -                 -                 -
                                                                                                                               Benefits - 07         6,090               6,334                 78             81                    84                88         12,755
                                                                                                                 Stipends/Subsides - 08                    -                  -                 -               -                    -                 -                 -
                                                                                                           Subcontracts/Restricted - 14                    -                  -                 -               -                    -                 -                 -
                                                                                                              Small/Attractive Items - 16                  -                  -                 -               -                    -                 -                 -
                                                                                                                      Total Direct Costs            26,381              27,436                889             925                 962             1,000          57,593
                                                                                                                                   F&A - 13         13,190              13,992                453             472                 490               510          29,108
                                                                                                                                Total Costs         39,571              41,429            1,343           1,396                1,452             1,510          86,701Approved by
                                                                                                                                                                                                                                                                         11/21/2011
                                                                                                                                                                                                                    C:\Docstoc\Working\pdf\0b4a3338-19ae-4f2e-8521-ee2057320b71.xlsx
                 PI's Name:                                                                                                                  7/1/2011           7/1/2012         7/1/2013         7/1/2014       7/1/2015        7/1/2016             TOTAL

                 Agency:                                                                                                                     6/30/2012         6/30/2013         6/30/2014       6/30/2015       6/30/2016       6/30/2017

                 SALARIES - 00                      Pay Rate       # Mos.                    % FTE                                                                                 cost share budget
                 PI: David Prabu                    12,222.22         10.00                 5.00%                                  Salary         6,111               6,356                                                  -               -           12,467

                                                                                                               Benefits             30.8%         1,882               1,970                                                  -               -            3,852

                 Co-PI:                                     0.00      12.00                 0.00%                                  Salary                -                 -                 -               -               -               -                 -

                                                                                                               Benefits             30.8%                -                 -                 -               -               -               -                 -

                 Co-PI:                                     0.00         0.00               0.00%                                  Salary                -                 -                 -               -               -               -                 -

                                                                                                               Benefits             30.8%                -                 -                 -               -               -               -                 -

                 Co-PI:                                     0.00         0.00               0.00%                                  Salary                -                 -                 -               -               -               -                 -

                                                                                                               Benefits             30.8%                -                 -                 -               -               -               -                 -

                 Co-PI:                                     0.00         0.00               0.00%                                  Salary                -                 -                 -               -               -               -                 -

                                                                                                               Benefits             30.8%                -                 -                 -               -               -               -                 -

                 Post-Doc/Research Assoc:                   0.00         0.00               0.00%                                  Salary                -                 -                 -               -               -               -                 -

                                                                                                               Benefits             30.8%                -                 -                 -               -               -               -                 -

                 Classfied Staff:                           0.00         0.00               0.00%                                  Salary                -                 -                 -               -               -               -                 -

                                                                                                               Benefits           39.65%                 -                 -                 -               -               -               -                 -

                 PhD Student ~ Step#                                                                                               Salary                -                 -                 -               -               -               -                 -

                                                    QTR inflation 16% though 6/30/13; 7% starting 7/1/13                             QTR                 -                 -                 -               -               -               -                 -

                                                                                                                                  Health                 -                 -                 -               -               -               -                 -

                                                                                                                                     1.5%                -                 -                 -               -               -               -                 -

                 Master Student ~ Step#                                                                                            Salary                -                 -                 -               -               -               -                 -

                                                                                                                                     QTR                 -                 -                 -               -               -               -                 -

                                                                                                                                  Health                 -                 -                 -               -               -               -                 -
                                                                                                                                     1.5%                -                 -                 -               -               -               -                 -

                 WAGES - 01                          $ Per Hr.     Hrs/Wks                  # Wks.

                 Student:                                  $0.00             0                       0                            Wages                  -                 -                 -               -               -               -                 -

                                                                                                               Benefits              2.0%                -                 -                 -               -               -               -                 -

                 Student (enrolled part-time ) :           $0.00             0                       0                            Wages                  -                 -                 -               -               -               -                 -

                                                                                                               Benefits              9.6%                -                 -                 -               -               -               -                 -

                 *Non-Student Temporary                    $0.00             0                       0                            Wages                  -                 -                 -               -               -               -                 -

                                                                                                               Benefits              9.6%                -                 -                 -               -               -               -                 -

                 **Non-Student Temporary                   $0.00             0                       0                            Wages                  -                 -                 -               -               -               -                 -

                                                                                                               Benefits             14.9%                -                 -                 -               -               -               -                 -

                 ***Non Student Temporary                  $0.00             0                       0                            Wages                  -                 -                 -               -               -               -                 -

                                                                                                               Benefits             76.6%                -                 -                 -               -               -               -                 -

                                                                                                                             Total Salary         6,111               6,356                  -               -               -               -           12,467

                                                                                                                             Total Wages                 -                 -                 -               -               -               -                 -
                                                                                                                 Total Salary & Wages             6,111               6,356                  -               -               -               -           12,467

                 BENEFITS - 07

                                                                                                                           Total Benefits         1,882               1,970                  -               -               -               -            3,852
                                                                                                         Total Salaries/Wages/Benefits            7,993               8,326                  -               -               -               -           16,319

                 PERSONAL SERVICES CONTRACTS -02

                                                                                                                                                         -                 -                 -               -               -               -                 -
                                                                                                   Total Personal Services Contracts                     -                 -                 -               -               -               -                 -

                 GOODS/SERVICES - 03

                                                                                                                                                                                                                                                               -

                                                                                                                                                                                                                                                               -

                                                                                                                                                                                                                                                               -

                                                                                                                                                                                                                                                               -

                                                                                                                                                                                                                                                               -

                                                                                                                                                                                                                                                               -

                                                                                                                Total Goods/Services                     -                 -                 -               -               -               -                 -

                 TRAVEL - 04

                 Domestic                                                                                                                                                                                                                                      -

                 Foreign                                                                                                                                                                                                                                       -

                                                                                                                             Total Travel                -                 -                 -               -               -               -                 -

                 COMPUTER SERVICES - 05

                                                                                                                                                                                                                                                               -

                                                                                                                                                                                                                                                               -

                                                                                                                                                                                                                                                               -

                                                                                                             Total Computer Services                     -                 -                 -               -               -               -                 -

                 CAPITAL EQUIPMENT - 06 ($5,000 +)

                                                                                                                                                                                                                                                               -

                                                                                                                                                                                                                                                               -

                                                                                                                                                                                                                                                               -

                                                                                                             Total Capital Equipment                     -                 -                 -               -               -               -                 -

                 STIPENDS/SUBSIDES/PARTICIPANT SUPPORT COSTS - 08

                                                                                                                                                                                                                                                               -

                                                                                 Total Stipends/Subsides/Participant Support Costs                       -                 -                 -               -               -               -                 -

                 SUBCONTRACTS/RESTRICTED - 14




                                                                                                      Total Subcontracts/Restricted                      -                 -                 -               -               -               -                 -
                   Small & Attractive Items - 16
http://public.wsu.edu/~forms/HTML/BPPM/70_Purchasing/70.09_Expenditure_Objects_and_Subobjects.htm#state

                 Laptop (agency approval required)                                                                                                                                                                                                             -

                                                                                                                                Total S&A                -                 -                 -               -               -               -                 -

                 TOTAL DIRECT COSTS                                                                                                               7,993               8,326                  -               -               -               -           16,319

                 EXCLUSIONS

                 QTR                                                                                                                                     -                 -                 -               -               -               -                 -

                 Equipment (Over 5k)                                                                                                                     -                 -                 -               -               -               -                 -

                 Subcontracts, amt excluding first 25K (per subcontract), HAND ENTER                                                                                                                                                                           -

                 Other (Off-Site Rental & Stipends, Etc)                                                                                                 -                 -                 -               -               -               -                 -

                                                                                                                          Total Exclusions               -                 -                 -               -               -               -                 -

                                                                                                                                    Base          7,993               8,326                  -               -               -               -           16,319

                 F&A - 13 CHECK FOR F&A RATE INCREASE 7/1/2012 - ON CAMPUS RATE INCREASES TO 51%                                 50.000%          3,997                                                                                                   3,997

                 F&A - 13 CHECK FOR F&A RATE INCREASE 7/1/2012 - ON CAMPUS RATE INCREASES TO 51%                                 51.000%                              4,246                  -               -               -               -            4,246

                 TOTAL COSTS                                                                                                                     11,990              12,572                  -               -               -               -           24,562

                           F&A Base Type:                          MTDC          TD           TC               SWB              Other

                                            0.500       0.510        X                                                                                       Cognizant Agency DHHS - Helen Fung, 415-437-7820



                                                                                                         Category/Object                      Year 1             Year 2            Year 3          Year 4          Year5                               Total

                                                                                                                             Salaries - 00        6,111               6,356                  -               -               -               -           12,467
                 Approved By:                                                                                                Wages - 01                  -                 -                 -               -               -               -                 -
                                                                                                         Personal Service Contract - 02                  -                 -                 -               -               -               -                 -

                                                                                                                 Goods/Services - 03                     -                 -                 -               -               -               -                 -
                 Date:                                                                                                         Travel - 04               -                 -                 -               -               -               -                 -

                                                                                                              Computer Services - 05                     -                 -                 -               -               -               -                 -

                                                                                                                      Equipment - 06                     -                 -                 -               -               -               -                 -

                                                                                                                             Benefits - 07        1,882               1,970                  -               -               -               -            3,852

                                                                                                               Stipends/Subsides - 08                    -                 -                 -               -               -               -                 -

                                                                                                         Subcontracts/Restricted - 14                    -                 -                 -               -               -               -                 -
                                                                                                           Small/Attractive Items - 16                   -                 -                 -               -               -               -                 -

                                                                                                                     Total Direct Costs           7,993               8,326                  -               -               -               -           16,319

                                                                                                                                 F&A - 13         3,997               4,246                  -               -               -               -            8,243

                                                                                                                              Total Costs        11,990              12,572                  -               -               -               -           24,562



                                                                                                                                                                                                                                                                                                    Approved by
                                                                                                                                                                                                                                                                                                      11/21/2011
                                                                                                                                                                                                                                                 C:\Docstoc\Working\pdf\0b4a3338-19ae-4f2e-8521-ee2057320b71.xlsx
                 PI's Name:                                                                                                                  7/1/2011           7/1/2012          7/1/2013        7/1/2014            7/1/2015          7/1/2016           TOTAL
                 Agency:                                                                                                                     6/30/2012         6/30/2013         6/30/2014       6/30/2015           6/30/2016         6/30/2017
                 SALARIES - 00                      Pay Rate       # Mos.                   % FTE
                 PI:                                        0.00         12.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Co-PI:                                     0.00         12.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Co-PI:                                     0.00          0.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Co-PI:                                     0.00          0.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Co-PI:                                     0.00          0.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Post-Doc/Research Assoc:                   0.00          0.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Classfied Staff:                           0.00          0.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits           39.65%                 -                 -                 -               -                   -                  -               -
                 PhD Student ~ Step#                                                                                               Salary                -                 -                 -               -                   -                  -               -
                                                    QTR inflation 16% though 6/30/13; 7% starting 7/1/13                             QTR                 -                 -                 -               -                   -                  -               -
                                                                                                                                  Health                 -                 -                 -               -                   -                  -               -
                                                                                                                                     1.5%                -                 -                 -               -                   -                  -               -
                 Master Student ~ Step#                                                                                            Salary                -                 -                 -               -                   -                  -               -
                                                                                                                                     QTR                 -                 -                 -               -                   -                  -               -
                                                                                                                                  Health                 -                 -                 -               -                   -                  -               -
                                                                                                                                     1.5%                -                 -                 -               -                   -                  -               -
                 WAGES - 01                          $ Per Hr.     Hrs/Wks                  # Wks.
                 Student:                                  $0.00             0                       0                            Wages                  -                 -                 -               -                   -                  -               -
                                                                                                               Benefits              2.0%                -                 -                 -               -                   -                  -               -
                 Student (enrolled part-time ) :           $0.00             0                       0                            Wages                  -                 -                 -               -                   -                  -               -
                                                                                                               Benefits              9.6%                -                 -                 -               -                   -                  -               -
                 *Non-Student Temporary                    $0.00             0                       0                            Wages                  -                 -                 -               -                   -                  -               -
                                                                                                               Benefits              9.6%                -                 -                 -               -                   -                  -               -
                 **Non-Student Temporary                   $0.00             0                       0                            Wages                  -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             14.9%                -                 -                 -               -                   -                  -               -
                 ***Non Student Temporary                  $0.00             0                       0                            Wages                  -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             76.6%                -                 -                 -               -                   -                  -               -
                                                                                                                              Total Salary               -                 -                 -               -                   -                  -               -
                                                                                                                             Total Wages                 -                 -                 -               -                   -                  -               -
                                                                                                                 Total Salary & Wages                    -                 -                 -               -                   -                  -               -
                 BENEFITS - 07
                                                                                                                            Total Benefits               -                 -                 -               -                   -                  -               -
                                                                                                         Total Salaries/Wages/Benefits                   -                 -                 -               -                   -                  -               -
                 PERSONAL SERVICES CONTRACTS -02
                                                                                                                                                         -                 -                 -               -                   -                  -               -
                                                                                                   Total Personal Services Contracts                     -                 -                 -               -                   -                  -               -
                 GOODS/SERVICES - 03
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                Total Goods/Services                     -                 -                 -               -                   -                  -               -
                 TRAVEL - 04
                 Domestic                                                                                                                                                                                                                                           -
                 Foreign                                                                                                                                                                                                                                            -
                                                                                                                              Total Travel               -                 -                 -               -                   -                  -               -
                 COMPUTER SERVICES - 05
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                             Total Computer Services                     -                 -                 -               -                   -                  -               -
                 CAPITAL EQUIPMENT - 06 ($5,000 +)
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                              Total Capital Equipment                    -                 -                 -               -                   -                  -               -
                 STIPENDS/SUBSIDES/PARTICIPANT SUPPORT COSTS - 08
                                                                                                                                                                                                                                                                    -
                                                                                 Total Stipends/Subsides/Participant Support Costs                       -                 -                 -               -                   -                  -               -
                 SUBCONTRACTS/RESTRICTED - 14




                                                                                          Total Subcontracts/Restricted                                  -                 -                 -               -                   -                  -               -
                   Small & Attractive Items - 16
http://public.wsu.edu/~forms/HTML/BPPM/70_Purchasing/70.09_Expenditure_Objects_and_Subobjects.htm#state
                 Laptop (agency approval required)                                                                                                                                                                                                                  -
                                                                                                                                Total S&A                -                 -                 -               -                   -                  -               -
                 TOTAL DIRECT COSTS                                                                                                                      -                 -                 -               -                   -                  -               -
                 EXCLUSIONS
                 QTR                                                                                                                                     -                 -                 -               -                   -                  -               -
                 Equipment (Over 5k)                                                                                                                     -                 -                 -               -                   -                  -               -
                 Subcontracts, amt excluding first 25K (per subcontract), HAND ENTER                                                                                                                                                                                -
                 Other (Off-Site Rental & Stipends, Etc)                                                                                                 -                 -                 -               -                   -                  -               -
                                                                                                                          Total Exclusions               -                 -                 -               -                   -                  -               -
                                                                                                                                    Base                 -                 -                 -               -                   -                  -               -
                 F&A - 13 CHECK FOR F&A RATE INCREASE 7/1/2012 - ON CAMPUS RATE INCREASES TO 51%                                 50.000%                 -                                                                                                          -
                 F&A - 13 CHECK FOR F&A RATE INCREASE 7/1/2012 - ON CAMPUS RATE INCREASES TO 51%                                 51.000%                                   -                 -               -                   -                  -               -
                 TOTAL COSTS                                                                                                                             -                 -                 -               -                   -                  -               -
                           F&A Base Type:                          MTDC          TD           TC              SWB              Other
                                            0.500       0.510        X                                                                                       Cognizant Agency DHHS - Helen Fung, 415-437-7820


                                                                                                         Category/Object                      Year 1             Year 2            Year 3          Year 4              Year5                                Total
                                                                                                                             Salaries - 00               -                 -                 -               -                   -                  -               -
                 Approved By:                                                                                                Wages - 01                  -                 -                 -               -                   -                  -               -
                                                                                                         Personal Service Contract - 02                  -                 -                 -               -                   -                  -               -
                                                                                                                 Goods/Services - 03                     -                 -                 -               -                   -                  -               -
                 Date:                                                                                                         Travel - 04               -                 -                 -               -                   -                  -               -
                                                                                                              Computer Services - 05                     -                 -                 -               -                   -                  -               -
                                                                                                                      Equipment - 06                     -                 -                 -               -                   -                  -               -
                                                                                                                             Benefits - 07               -                 -                 -               -                   -                  -               -
                                                                                                               Stipends/Subsides - 08                    -                 -                 -               -                   -                  -               -
                                                                                                         Subcontracts/Restricted - 14                    -                 -                 -               -                   -                  -               -
                                                                                                            Small/Attractive Items - 16                  -                 -                 -               -                   -                  -               -
                                                                                                                    Total Direct Costs                   -                 -                 -               -                   -                  -               -
                                                                                                                                 F&A - 13                -                 -                 -               -                   -                  -               -
                                                                                                                              Total Costs                -                 -                 -               -                   -                  -              -Approved by
                                                                                                                                                                                                                                                                      11/21/2011
                                                                                                                                                                                                                 C:\Docstoc\Working\pdf\0b4a3338-19ae-4f2e-8521-ee2057320b71.xlsx
                 PI's Name:                                                                                                                  7/1/2011           7/1/2012          7/1/2013        7/1/2014            7/1/2015          7/1/2016           TOTAL
                 Agency:                                                                                                                     6/30/2012         6/30/2013         6/30/2014       6/30/2015           6/30/2016         6/30/2017
                 SALARIES - 00                      Pay Rate       # Mos.                   % FTE
                 PI:                                        0.00         12.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Co-PI:                                     0.00         12.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Co-PI:                                     0.00          0.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Co-PI:                                     0.00          0.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Co-PI:                                     0.00          0.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Post-Doc/Research Assoc:                   0.00          0.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             30.8%                -                 -                 -               -                   -                  -               -
                 Classfied Staff:                           0.00          0.00              0.00%                                  Salary                -                 -                 -               -                   -                  -               -
                                                                                                               Benefits           39.65%                 -                 -                 -               -                   -                  -               -
                 PhD Student ~ Step#                                                                                               Salary                -                 -                 -               -                   -                  -               -
                                                    QTR inflation 16% though 6/30/13; 7% starting 7/1/13                             QTR                 -                 -                 -               -                   -                  -               -
                                                                                                                                  Health                 -                 -                 -               -                   -                  -               -
                                                                                                                                     1.5%                -                 -                 -               -                   -                  -               -
                 Master Student ~ Step#                                                                                            Salary                -                 -                 -               -                   -                  -               -
                                                                                                                                     QTR                 -                 -                 -               -                   -                  -               -
                                                                                                                                  Health                 -                 -                 -               -                   -                  -               -
                                                                                                                                     1.5%                -                 -                 -               -                   -                  -               -
                 WAGES - 01                          $ Per Hr.     Hrs/Wks                  # Wks.
                 Student:                                  $0.00             0                       0                            Wages                  -                 -                 -               -                   -                  -               -
                                                                                                               Benefits              2.0%                -                 -                 -               -                   -                  -               -
                 Student (enrolled part-time ) :           $0.00             0                       0                            Wages                  -                 -                 -               -                   -                  -               -
                                                                                                               Benefits              9.6%                -                 -                 -               -                   -                  -               -
                 *Non-Student Temporary                    $0.00             0                       0                            Wages                  -                 -                 -               -                   -                  -               -
                                                                                                               Benefits              9.6%                -                 -                 -               -                   -                  -               -
                 **Non-Student Temporary                   $0.00             0                       0                            Wages                  -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             14.9%                -                 -                 -               -                   -                  -               -
                 ***Non Student Temporary                  $0.00             0                       0                            Wages                  -                 -                 -               -                   -                  -               -
                                                                                                               Benefits             76.6%                -                 -                 -               -                   -                  -               -
                                                                                                                              Total Salary               -                 -                 -               -                   -                  -               -
                                                                                                                             Total Wages                 -                 -                 -               -                   -                  -               -
                                                                                                                 Total Salary & Wages                    -                 -                 -               -                   -                  -               -
                 BENEFITS - 07
                                                                                                                            Total Benefits               -                 -                 -               -                   -                  -               -
                                                                                                         Total Salaries/Wages/Benefits                   -                 -                 -               -                   -                  -               -
                 PERSONAL SERVICES CONTRACTS -02
                                                                                                                                                         -                 -                 -               -                   -                  -               -
                                                                                                   Total Personal Services Contracts                     -                 -                 -               -                   -                  -               -
                 GOODS/SERVICES - 03
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                Total Goods/Services                     -                 -                 -               -                   -                  -               -
                 TRAVEL - 04
                 Domestic                                                                                                                                                                                                                                           -
                 Foreign                                                                                                                                                                                                                                            -
                                                                                                                              Total Travel               -                 -                 -               -                   -                  -               -
                 COMPUTER SERVICES - 05
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                             Total Computer Services                     -                 -                 -               -                   -                  -               -
                 CAPITAL EQUIPMENT - 06 ($5,000 +)
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                                                                                                                                                                                    -
                                                                                                              Total Capital Equipment                    -                 -                 -               -                   -                  -               -
                 STIPENDS/SUBSIDES/PARTICIPANT SUPPORT COSTS - 08
                                                                                                                                                                                                                                                                    -
                                                                                 Total Stipends/Subsides/Participant Support Costs                       -                 -                 -               -                   -                  -               -
                 SUBCONTRACTS/RESTRICTED - 14




                                                                                          Total Subcontracts/Restricted                                  -                 -                 -               -                   -                  -               -
                   Small & Attractive Items - 16
http://public.wsu.edu/~forms/HTML/BPPM/70_Purchasing/70.09_Expenditure_Objects_and_Subobjects.htm#state
                 Laptop (agency approval required)                                                                                                                                                                                                                  -
                                                                                                                                Total S&A                -                 -                 -               -                   -                  -               -
                 TOTAL DIRECT COSTS                                                                                                                      -                 -                 -               -                   -                  -               -
                 EXCLUSIONS
                 QTR                                                                                                                                     -                 -                 -               -                   -                  -               -
                 Equipment (Over 5k)                                                                                                                     -                 -                 -               -                   -                  -               -
                 Subcontracts, amt excluding first 25K (per subcontract), HAND ENTER                                                                                                                                                                                -
                 Other (Off-Site Rental & Stipends, Etc)                                                                                                 -                 -                 -               -                   -                  -               -
                                                                                                                          Total Exclusions               -                 -                 -               -                   -                  -               -
                                                                                                                                    Base                 -                 -                 -               -                   -                  -               -
                 F&A - 13 CHECK FOR F&A RATE INCREASE 7/1/2012 - ON CAMPUS RATE INCREASES TO 51%                                 50.000%                 -                                                                                                          -
                 F&A - 13 CHECK FOR F&A RATE INCREASE 7/1/2012 - ON CAMPUS RATE INCREASES TO 51%                                 51.000%                                   -                 -               -                   -                  -               -
                 TOTAL COSTS                                                                                                                             -                 -                 -               -                   -                  -               -
                           F&A Base Type:                          MTDC          TD           TC              SWB              Other
                                            0.500       0.510        X                                                                                       Cognizant Agency DHHS - Helen Fung, 415-437-7820


                                                                                                         Category/Object                      Year 1             Year 2            Year 3          Year 4              Year5                                Total
                                                                                                                             Salaries - 00               -                 -                 -               -                   -                  -               -
                 Approved By:                                                                                                Wages - 01                  -                 -                 -               -                   -                  -               -
                                                                                                         Personal Service Contract - 02                  -                 -                 -               -                   -                  -               -
                                                                                                                 Goods/Services - 03                     -                 -                 -               -                   -                  -               -
                 Date:                                                                                                         Travel - 04               -                 -                 -               -                   -                  -               -
                                                                                                              Computer Services - 05                     -                 -                 -               -                   -                  -               -
                                                                                                                      Equipment - 06                     -                 -                 -               -                   -                  -               -
                                                                                                                             Benefits - 07               -                 -                 -               -                   -                  -               -
                                                                                                               Stipends/Subsides - 08                    -                 -                 -               -                   -                  -               -
                                                                                                         Subcontracts/Restricted - 14                    -                 -                 -               -                   -                  -               -
                                                                                                            Small/Attractive Items - 16                  -                 -                 -               -                   -                  -               -
                                                                                                                    Total Direct Costs                   -                 -                 -               -                   -                  -               -
                                                                                                                                 F&A - 13                -                 -                 -               -                   -                  -               -
                                                                                                                              Total Costs                -                 -                 -               -                   -                  -              -Approved by
                                                                                                                                                                                                                                                                      11/21/2011
                                                                                                                                                                                                                 C:\Docstoc\Working\pdf\0b4a3338-19ae-4f2e-8521-ee2057320b71.xlsx
       Enter Monthly Salary-->      $3,353.40                                                  Benefit Calculations
       For less than full-time employees use                                                      Updated 8-4-11
       part-time salary.

                                  Retirement plan may differ from employment category. To determine retirement plan for current employees review DEPPS "qprexp" screen.
             Civil Service/Bargaining Unit                     Administrative Professional                                 Faculty                         Limited Number of Extension Faculty
       PERS 1, 2, or 3                  Rate       TIAA-CREF                                Rate      TIAA-CREF                               Rate       FEDERAL                       Rate
       OASI - .062                 $     207.91    OASI - .062                          $    207.91   OASI - .062                         $    207.91    OASI - n/a                $        -
       Medicare - .0145                   48.62    Medicare - .0145                           48.62   Medicare - .0145                          48.62    Medicare - .0145                48.62
       PERS - .0725                      243.12    TIAA-CREF .05 (< age 35)                  167.67   TIAA-CREF .05 (< age 35)                 167.67    CSRS .07                       234.74
       Unempl - .005                      16.77    Unempl - .005                              16.77   Unempl - .005                             16.77    Unempl - .005                   16.77
       Med. Aid - .2113 x 160             33.81    Med. Aid - .2113 x 160                     33.81   Med. Aid - .2113 x 160                    33.81    Med. Aid - .2113 x 160          33.81
       Health                            850.00    Health                                    850.00   Health                                   850.00    Federal Life*                   12.00
       TOTAL BENEFITS              $ 1,400.23      TOTAL BENEFITS                         $1,324.78   TOTAL BENEFITS                        $1,324.78    Health                         850.00
                                                                                                                                                                  TOTAL BENEFITS              $ 1,195.94
         Benefit Rate                     0.41756         Benefit Rate                       0.39506        Benefit Rate                             0.39506
                                                        OASI - .062                        $   207.91     OASI - .062                             $    207.91       Benefit Rate                0.35663
                                                        Medicare - .0145                        48.62     Medicare - .0145                              48.62     OASI - .062                 $   207.91
                                                        TIAA-CREF .075 (age 35 +)              251.51     TIAA-CREF .075 (age 35 +)                    251.51     Medicare - .0145                 48.62
                                                        Unempl - .005                           16.77     Unempl - .005                                 16.77     FERS .119                       399.05
                                                        Med. Aid - .2113 x 160                  33.81     Med. Aid - .2113 x 160                        33.81     TSP - .05                       167.67
                                                        Health                                 850.00     Health                                       850.00     Unempl - .005                    16.77
                                                        TOTAL BENEFITS                     $ 1,408.62     TOTAL BENEFITS                            $1,408.62     Med. Aid - .2113 x 160           33.81
                                                                                                                                                                  Federal Life*                    12.00
                                                          Benefit Rate                         0.42006      Benefit Rate                               0.42006    Health                          850.00
                                                        OASI - .062                        $    207.91    OASI - .062                             $     207.91    TOTAL BENEFITS              $ 1,735.83
                                                        Medicare - .0145                          48.62   Medicare - .0145                                48.62
                                                        TIAA-CREF .1 (option age 50 +)          335.34    TIAA-CREF .1 (option age 50 +)                335.34      Benefit Rate                   0.51763
                                                        Unempl - .005                             16.77   Unempl - .005                                   16.77   *$12.00 is the average contribution for
                                                        Med. Aid - .2113 x 160                    33.81   Med. Aid - .2113 x 160                          33.81   federal life insurance. For actual $
                                                        Health                                  850.00    Health                                        850.00    review DEPPS "qprexp" screen.
                                                        TOTAL BENEFITS                     $ 1,492.45     TOTAL BENEFITS                          $ 1,492.45

                                                           Benefit Rate                        0.44506       Benefit Rate                              0.44506

                                                        Option for AP hired after 7-1-11                  Option for Faculty hired after 7-1-11
                                                        PERS 3                                  Rate      TRS 3
                                                        OASI - .062                        $    207.91    OASI - .062                                  $207.91
                                                        Medicare - .0145                         48.62    Medicare - .0145                               48.62
                                                        PERS 3 - .0725                          243.12    TRS 3 - .0804                                 269.61
                                                        Unempl - .005                            16.77    Unempl - .005                                  16.77
                                                        Med. Aid - .2113 x 160                   33.81    Med. Aid - .2113 x 160                         33.81
                                                        Health                                  850.00    Health                                        850.00
                                                        TOTAL BENEFITS                     $ 1,400.23     TOTAL BENEFITS                              $1,426.72

                                                           Benefit Rate                        0.41756    Benefit Rate                                 0.42546

       Caution: For employees with less than a 12-month appointment; factor in health insurance cost for non-pay months.
C:\Docstoc\Working\pdf\0b4a3338-19ae-4f2e-8521-ee2057320b71.xlsx 11/21/20117:22 PM
                                                                                          Percent of Time & Effort to Person Months (PM)
                                                                                                   Interactive Conversion Table




       3 month                                   6 month                                   8 month                               9 month                      10 month                    12 month
     Summer Term                               Appointment                               Appointment                          Academic Year                  Appointment                Calendar Year

   % effort           PM                   % effort              PM                    % effort          PM                   % effort        PM           % effort         PM         % effort         PM

           0         0.00                             0         0.00                          0         0.00                        0         0.00               0         0.00              0          0.00


Instructions:

To use the chart simply insert the percent effort that you want to convert into the -0- of the 3 mo. Summer Term % effort line and
hit enter. The person month for 3, 6, 8, 9, 10, and 12 will be displayed simultaneously.


There are three basic salary (wage) bases: Calendar Year, Academic Year and Summer Term. Here is a month/week/days
breakout for each:

Academic Year (AY)             9 months                   39 weeks                273 days
Summer Term (SM)               3 months                   13 weeks                90 days
Calendar Year (CY)            12 months                   52 weeks                365 days

To fill out the budget forms for the SF 424 R&R grantees will need to convert percent-of-effort to person months. Below are
a two examples of how person months are applied:


                                          Example 1:                   A PI on an AY appointment at a salary of $63,000 will have a monthly salary of $7,000 (one-ninth of the AY).
                                                                       25% of AY effort would equate to 2.25 person months (9x.25=2.25). The Budget figure for that effort would be
                                                                       $15,750 (7,000 multiplied by 2.25 AY months).


                                          Example 2:                   A PI on a CY appointment at a salary of $72,000 will have a monthly salary of $6,000 (one-twelfth of total CY
                                                                       salary). 25% of CY effort would equate to 3 CY months (12x.25=3). The budget figure for that effort would
                                                                       be$18,000 (6,000 multiplied by 3 CY months).




     Created by George Gardner
     Latest Update 11/21/2011
                                                                                                Washington State University
                                                                              Draft General Benefits Model for FY 2011
                                                                                                                                                                       Updated 07/06/11
Benefits = Faculty, AP,CS,BU= DA+DK+(DB or DC or DD or DE or DF or DM or DH or DJ or DL)+MA+DG+(MB or MC) where:
           *or* Grad=DG+MC where:
           *or* Non-Student Temporary=DA+DK+(HE or HF) + MD, where:
                                                                                                           Rate      Multiplied by
                1,5
                       DA = OASI, $ 106,800 max.                                                            0.0620      x Salary
                   5
                       DK = Medicare, no max.                                                               0.0145      x Salary
                       DB = TIAA/CREF 5%                                                                    0.0500      x Salary
                       DC = TIAA/CREF 7.5%                                                                  0.0750      x Salary
                       DD = TIAA/CREF 10%                                                                   0.1000      x Salary
                       DE = PERS I                                                                          0.0531      x Salary
                       DF = PERS II                                                                         0.0531      x Salary
                       DM = PERS III                                                                        0.0531      x Salary
                       DH = WSTRS I                                                                         0.0614      x Salary
                       DJ = WSTRS II                                                                        0.0614      x Salary
                       DL = LEOFF II                                                                        0.0862      x Salary
                       HE = PERS I                                                                          0.0531      x Wages
                       HF = PERS II                                                                         0.0531      x Wages
                       MA = Unemployment Ins.                                                               0.0045      x Salary
                       DG = Med Aid / Wkr. Comp                                                             $27.33   x FTE x Term
                       MB = Health Insurance (not grads)                                                   $850.00 x 12 (if FTE >= 0.50)
                       MC = Health Ins. (Grads)                                                            $710.00 x 2 (if FTE >= 0.50 and term = 9.0)
                       MD = Health Ins. (NSTE)                                                             $850.00 x 12 (if >= .5 FTE for 6 consec. months)
                   2
                       Annual Benefits Calculations by Employee Type, given that FTE >= 0.50
                                                   ((OASI%+Medcr%+Retrmt%+Unempl%)*Salary) + (Med Aid $* FTE*Term) + (Health Ins. rate x 12)
                       Classified Benefits                           =        (0.1341 x Salary) + (27.33 x FTE x Term) + 10200
                       Exempt Benefits                               =        (0.15440 x Salary) + (27.33 x FTE x Term) + 10200
                       Faculty Benefits                              =        (0.1614 x Salary) + (27.33 x FTE x Term) + 10200
                       Graduate Benefits                             =                          -0-   + (27.33 x FTE x Term) + 1420 (+ 7834 if QTR)
                   3
                       Estimated Benefit Percentages by Employee Type
                                                                                                             FY 09            FY 10                 FY 11
                       Civil Service                                                                         34.6%           37.2%                  40.7%
                       Bargaining Units                                                                      33.3%           35.1%                  38.6%
                       Exempt                                                                                27.9%           31.3%                  34.0%
                       Faculty                                                                               25.5%           28.7%                  30.8%

                       Weighted Average                                                                      29.4%           32.3%                   35.1%
                                                                                                                                                  without QTR          with QTR
                   4
                       Graduate Student                                                                      11.3%           10.8%                  10.6%                 64.7%
                   6
                       Student hourly (no Grad Appt.) Full-time FT, Part-time PT                                                             FT= 2.%        PT= 9.6%
                                                                 No Pers/Hlth No Pers/Hlth                                            No PERS/No Hlth   | With PERS     with both
                   6
                       Non-Student Temporary                                                                  9.1%             9.5%        9.6%            14.9%          76.6%

                   1
                       The $106,800 OASI maximum is the fiscal year average of 2010 at $106,800 and 2011 at $106,800.
                   2
                       The civil service/bargaining unit retirement plan rate used is PERS (0.0531).
                       The A/P and faculty retirement plan rate used is the WSU weighted average (0.0734 and 0.0804, respectively).
                   3
                       Civil Service, Bargaining Unit, Exempt, Faculty and Graduate rates were calculated using average salary, FTE, and term by
                       employee type from "Sept 30, 2009" employee / appointment data obtained from the data warehouse. No such data
                       are available for students and Non-Student Temporary Employees (NSTE) so these rates are rough estimates.
                       The Non-Student Temporary rate shows with and without PERS and medical insurance. (Non-Student Temporary Employees (NSTEs)
                       become eligible for PERS if they work 70 or more hours per month in any five months of a 12 month period.
                       NSTEs become eligible for medical insurance in the seventh month if they work 480 or more hours in a consecutive six month period. They must
                       work in the first month of the six month period. These WSU contributions are absorbed by the departments in subobjects HE, HF, HM and MD)
                   4
                       The graduate rate listed shows with and without the Qualified Tuition Reduction, an additional benefit
                       added to those >=.5FTE grads who did not receive an Operating Fee Waiver. The QTR for this FY is $7,834.
                   5
                       OASI and Medicare will be taken for all non-student employees for any non-business related meals
                       reimbursed for non-overnight travel.
                   6
                       Rates for temporary employees are based on the average minimum wage over the fiscal year times 160 hrs/month times 12 months.
11/21/2011 7:22 PM rg Z:\Benefits\benefits model\FY07\FY07 fall final.xls tab: Benefits Model
                                                             RATES TO BE USED FOR ESTIMATING EMPLOYEE BENEFITS FOR FY 2011
                                                                                          (Rates ar e th e em p lo yer c o n tr ib u tio n fo r n o n -fed er al em p lo yees )

                    WSU                                                                                                                                                                   Stu d en t   No n -s tu d en t
              Su b o b jec t                        B en efit Item                                 Rate               Clas s ified       Fac u lty        Ex em p t        Gr ad u ate    Ho u r ly        Ho u r ly

   1,10
                      DA                 OASI, $106,800 max                               .062 x SALARY                    X                 X                 X                                              X
       2
                      DB                 TIAA/CREF, 5%                                    .0500 x Salar y                  X                 X                 X
       2
                      DC                 TIAA/CREF, 7.5%                                  .0750 x Salary                   X                 X                 X
       2
                      DD                 TIAA/CREF, 10%                                   .1000 x Salar y                  X                 X                 X
       3
                      DE                 PERS I                                           .0531 X Salary                   X                 X                 X
       3
                      DF                 PERS II                                          .0531 x Salar y                  X                 X                 X
       3
                     DM                  PERS III                                         .0531 x Salary                   X                 X                 X
       4
                     DG                  Med Aid /Wr k Co m p                             27.33/FTE/Mo n th                X                 X                 X                  X           X               X
       5
                      DH                 W STRS I                                         .0614 x Salary                   X                 X                 X
       5
                      DJ                 WSTRS II                                         .0614 X Salar y                  X                 X                 X
     10
                      DK                 MEDICARE, no max                                 .0145 x Salary                   X                 X                 X                                              X
                      DL                 L EOFF II                                        .0862 X Salar y                  X
       6
                      HE                 PERS I                                           .0531 x Salary                                                                                                      X
       6
                      HF                 PERS II                                          .0531 X Salar y                                                                                                     X
       7
                     MA                  Unemploy. Insurance                              .004523 X Salary                 X                 X                 X                                              X
       8
                     MB                  Health In s u r an c e                           850./Mo n th Es t.               X                 X                 X
                     MC                  Gr ad Health In s u r an c e 1,420./Year Es t.                                                                                           X
       9
                     MD                  Health In s u r an c e                           850./Mo n th                                                                                                        X


                                                                                                                    Mo s t Co m m o n Retir em en t Plan s
                                   See footnote #7
                                                                                                                                                                           Weig h ted
                                   below.
                                                                                          Em p lo yee Typ e                                Plan                            Avg Rate
                                                                                          Civ Ser /B ar g Un it                      PERS II (5.31%)                              5.41%
                                                                                               Ad m in /Pr o f                    TIAA/CREF (7.5%)                                7.34%
                                                                                                  Fac u lty                       TIAA/CREF (7.5%)                                8.04%


Notes:
       1
           The $106,800 OASI maximum is the fiscal year average of 2010 at $106,800 and 2011 at $106,800.
       2
           Faculty up to 35 years of age are on TIAA/CREF 5%; faculty aged 35 and above are on TIAA/CREF 7.5%. At age 50, faculty have
           the option of participating in TIAA/CREF 10%. Exempt employees may elect PERS or TIAA/CREF with the same percentage/age
           distribution as faculty. Some classified employees with a lengthy employment history of state service may be covered by
           TIAA/CREF with the same percentage/age distribution.
       3
           This is the PERS rate changed 9/1/09 from .0529
       4
           Medical Aid/W orker's Compensation is a per hour cost of .1708; monthly maximum hours are 160, for a monthly
           maximum of $27.33. The rate applies to productive hours, so a person working full-time on a 9-month appointment
           would expense $27.33 x 9 = $245.97 annually.
       5
           Some employees with a lengthy employment history of state service may be covered by the W ashington State
           Teachers Retirement System.
       6
           Non-Student Temporary Employees (NSTE) employees become eligible for PERS if they work 70 or more hours per month in any five months of a
           12-month period. The W SU contributions are absorbed by the departments in subobjects HE, HF and HM.
       7
           Unemployment insurance is a rate based on historical patterns by program. The weighted average for all programs is .004523.
           To calculate unemployment more accurately, open cell note                                                    here. (Press Shift-F2 and page up to the top of the note.)
       8
           Health Insurance is a FIXED rate over 12 months. For employees working at 0.50 FTE or above, the full monthly rate
           of $850. applies over 12 months, even if the employee is on a 9-month appointment.
       9
           Non student temporary employees become eligible for medical insurance in the seventh month if they work 480 or more hours in a consecutive six
           month period. They must work at least 8 hours in each of the consecutive six months. These W SU contributions are absorbed by the departments
           in subobject MD)
     10
           OASI and Medicare will be taken for all non-student employees for any non-business related meals
           reimbursed for non-overnight travel.




11/21/2011 7:22 PM rg Z:\Benefits\benefits model\FY07\FY07 fall final.xls tab: Est Bens
                     PI, Co-Pis
Name (Last, First)
     Column 1
                                                           PI, Co-Pis, Other Person
Title for Project (PI, Co-PI, Associate Researcher, Key Personnel)   WSU Area
                             Column 2                                Column 3
Pis, Other Personnel
       WSU Department
          Column 4
rsonnel
          WSU Split Appointment? If yes, list other area/department in column to the right
                                              Column 5
Column 6
MATRICES FOR GRADUATE RESEARCH ASSISTANTSHIP APPOINTMEN
GRA SALARIES (Assuming Salary Increase 7/1)

STEP-60      Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt       7/1/2011   7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011
AY + 3 SUM          12       24054      24094      24134       24174      24214       24294       24374
AY + 2 SUM          11       22050      22050      22050       22090      22130       22210       22290
AY + 1 SUM          10       20045      20045      20045       20045      20085       20165       20245
AY                   9       18041      18041      18041       18041      18081       18161       18241
3 SUM                3        6014       6054       6094        6134       6134        6134        6134
2 SUM                2        4009       4009       4009        4049       4049        4049        4049
1 SUM                1        2005       2005       2005        2005       2005        2005        2005

STEP-51      Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt       7/1/2011   7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011
AY + 3 SUM         12        21978      22015      22052       22088      22125       22199       22272
AY + 2 SUM         11        20147      20147      20147       20183      20220       20294       20367
AY + 1 SUM         10        18315      18315      18315       18315      18352       18425       18499
AY                  9        16484      16484      16484       16484      16520       16594       16667
3 SUM               3         5495       5531       5568        5605       5605        5605        5605
2 SUM               2         3663       3663       3663        3700       3700        3700        3700
1 SUM               1         1832       1832       1832        1832       1832        1832        1832

STEP-49      Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt       7/1/2011   7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011
AY + 3 SUM          12       21558      21594      21630       21666      21702       21774       21846
AY + 2 SUM          11       19762      19762      19762       19798      19834       19906       19978
AY + 1 SUM          10       17965      17965      17965       17965      18001       18073       18145
AY                   9       16169      16169      16169       16169      16205       16277       16349
3 SUM                3        5390       5426       5462        5498       5498        5498        5498
2 SUM                2        3593       3593       3593        3629       3629        3629        3629
1 SUM                1        1797       1797       1797        1797       1797        1797        1797

STEP-47      Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt       7/1/2011    7/1/2011   8/1/2006   8/16/2011   9/1/2011   10/1/2011   11/1/2011
AY + 3 SUM          12       21144      21179      21215       21250      21285       21356       21426
AY + 2 SUM          11       19382      19382      19382       19417      19453       19523       19594
AY + 1 SUM          10       17620      17620      17620       17620      17655       17726       17796
AY                   9       15858      15858      15858       15858      15893       15964       16034
3 SUM                3        5286       5321       5357        5392       5392        5392        5392
2 SUM                2        3524       3524       3524        3559       3559        3559        3559
1 SUM                1        1762       1762       1762        1762       1762        1762        1762

STEP-42      Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
           Apptmt         7/1/2011    7/1/2011   8/1/2006   8/16/2011   9/1/2011   10/1/2011   11/1/2011
AY + 3 SUM       12         20100       20134      20167       20201      20234       20301       20368
AY + 2 SUM       11         18425       18425      18425       18459      18492       18559       18626
AY + 1 SUM       10         16750       16750      16750       16750      16784       16851       16918
AY                9         15075       15075      15075       15075      15109       15176       15243
3 SUM             3          5025        5059       5092        5126       5126        5126        5126
2 SUM             2          3350        3350       3350        3384       3384        3384        3384
1 SUM             1          1675        1675       1675        1675       1675        1675        1675

STEP-32      Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt       7/1/2011   7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011
AY + 3 SUM          12      18204       18234      18265       18295      18325       18386       18446
AY + 2 SUM          11      16687       16687      16687       16717      16748       16808       16869
AY + 1 SUM          10      15170       15170      15170       15170      15200       15261       15321
AY                   9      13653       13653      13653       13653      13683       13744       13804
3 SUM                3       4551        4581       4612        4642       4642        4642        4642
2 SUM                2       3034        3034       3034        3064       3064        3064        3064
1 SUM                1       1517        1517       1517        1517       1517        1517        1517

STEP-26      Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt       7/1/2011   7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011
AY + 3 SUM          12      17154       17183      17211       17240      17268       17325       17382
AY + 2 SUM          11      15725       15725      15725       15753      15782       15839       15896
AY + 1 SUM          10      14295       14295      14295       14295      14324       14381       14438
AY                   9      12866       12866      12866       12866      12894       12951       13008
3 SUM                3       4289        4317       4346        4374       4374        4374        4374
2 SUM                2       2859        2859       2859        2888       2888        2888        2888
1 SUM                1       1430        1430       1430        1430       1430        1430        1430


GRA QUALIFIED TUITION REDUCTION
NOTE: Inflate 16% per year   *Please note the 16% QTR inflation is recommended throug

Resident QTR
             Apptmt/Grant Begins:
             Apptmt       7/1/2011   7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011

AY + SUM            12      10322       10322      10322       10519      10600       10762       10923
AY + SUM            11      10322       10322      10322       10519      10600       10762       10923
AY ONLY             10       9088        9088       9088        9088       9169        9330        9492
AY ONLY              9       9088        9088       9088        9088       9169        9330        9492
SUM ONLY           1-3       1234        1234       1234        1431       1431        1431        1431

Non-Resident QTR
             Apptmt/Grant Begins:
             Apptmt       7/1/2011   7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011

AY + SUM            12      23506       23506      23506       23708      23906       24301       24697
AY + SUM            11      23506       23506      23506       23708      23906       24301       24697
AY ONLY            10     22242       22242      22242       22242      22440       22835       23231
AY ONLY             9     22242       22242      22242       22242      22440       22835       23231
SUM ONLY          1-3      1264        1264       1264        1466       1466        1466        1466


GRA HEALTH INSURANCE
     NOTE: Inflate 4% per year
           Apptmt/Grant Begins:
           Apptmt       7/1/2011   7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011

   Any > 9month            1480        1480       1480        1480       1483        1490        1496
P APPOINTMENTS ~ EXCLUDES NURSING
                                                                                           Updated 07/06/11


equent Years)

          12/1/2011     1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012    6/1/2012   6/16/2012
                24454     24534      24614      24694      24774      24854       24894       24934       24974
                22370     22450      22530      22610      22690      22770       22810       22850       22890
                20325     20405      20485      20565      20645      20725       20765       20765       20805
                18321     18401      18481      18561      18641      18721       18761       18761       18761
                 6134      6134       6134       6134       6134       6134        6134        6174        6214
                 4049      4049       4049       4049       4049       4049        4049        4089        4129
                 2005      2005       2005       2005       2005       2005        2005        2005        2045

quent Years)

          12/1/2011     1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012    6/1/2012   6/16/2012
                22346     22419      22493      22566      22640      22713       22750       22787       22823
                20441     20514      20588      20661      20735      20808       20845       20882       20918
                18572     18646      18719      18793      18866      18940       18977       18977       19013
                16741     16814      16888      16961      17035      17108       17145       17145       17145
                 5605      5605       5605       5605       5605       5605        5605        5642        5678
                 3700      3700       3700       3700       3700       3700        3700        3737        3773
                 1832      1832       1832       1832       1832       1832        1832        1832        1868

quent Years)

          12/1/2011     1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012    6/1/2012   6/16/2012
                21918     21990      22062      22134      22206      22278       22314       22350       22386
                20050     20122      20194      20266      20338      20410       20446       20482       20518
                18217     18289      18361      18433      18505      18577       18613       18613       18649
                16421     16493      16565      16637      16709      16781       16817       16817       16817
                 5498      5498       5498       5498       5498       5498        5498        5534        5570
                 3629      3629       3629       3629       3629       3629        3629        3665        3701
                 1797      1797       1797       1797       1797       1797        1797        1797        1833

quent Years)

          12/1/2011     1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012    6/1/2012   6/16/2012
                21497     21567      21638      21708      21779      21849       21884       21920       21955
                19664     19735      19805      19876      19946      20017       20052       20087       20122
                17867     17937      18008      18078      18149      18219       18255       18255       18290
                16105     16175      16246      16316      16387      16457       16493       16493       16493
                 5392      5392       5392       5392       5392       5392        5392        5427        5462
                 3559      3559       3559       3559       3559       3559        3559        3595        3630
                 1762      1762       1762       1762       1762       1762        1762        1762        1797

quent Years)
          12/1/2011    1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012   6/1/2012   6/16/2012
               20435     20502      20569      20636      20703      20770       20804      20837       20871
               18693     18760      18827      18894      18961      19028       19062      19095       19129
               16985     17052      17119      17186      17253      17320       17353      17353       17387
               15310     15377      15444      15511      15578      15645       15678      15678       15678
                5126      5126       5126       5126       5126       5126        5126       5159        5193
                3384      3384       3384       3384       3384       3384        3384       3417        3451
                1675      1675       1675       1675       1675       1675        1675       1675        1709

quent Years)

          12/1/2011    1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012   6/1/2012   6/16/2012
               18507     18567      18628      18688      18749      18809       18839      18870       18900
               16929     16990      17050      17111      17171      17232       17262      17292       17322
               15382     15442      15503      15563      15624      15684       15715      15715       15745
               13865     13925      13986      14046      14107      14167       14198      14198       14198
                4642      4642       4642       4642       4642       4642        4642       4672        4702
                3064      3064       3064       3064       3064       3064        3064       3095        3125
                1517      1517       1517       1517       1517       1517        1517       1517        1547

quent Years)

          12/1/2011    1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012   6/1/2012   6/16/2012
               17439     17496      17553      17610      17667      17724       17753      17781       17810
               15953     16010      16067      16124      16181      16238       16266      16295       16323
               14495     14552      14609      14666      14723      14780       14808      14808       14837
               13065     13122      13179      13236      13293      13350       13379      13379       13379
                4374      4374       4374       4374       4374       4374        4374       4403        4431
                2888      2888       2888       2888       2888       2888        2888       2916        2945
                1430      1430       1430       1430       1430       1430        1430       1430        1458



ecommended through 6/30/2013. Starting 7/1/13, please use a 7% inflation rate.


          12/1/2011    1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012   6/1/2012   6/16/2012

               11085     11246      11408      11570      11731      11893       11973      11973       11973
               11085     11246      11408      11570      11731      11893       11973      11973       11973
                9653      9815       9977      10138      10300      10461       10542      10542       10542
                9653      9815       9977      10138      10300      10461       10542      10542       10542
                1431      1431       1431       1431       1431       1431        1431       1431        1431




          12/1/2011    1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012   6/1/2012   6/16/2012

               25092     25488      25883      26279      26674      27070       27267      27267       27267
               25092     25488      25883      26279      26674      27070       27267      27267       27267
   23626      24022      24417      24812      25208      25603       25801      25801       25801
   23626      24022      24417      24812      25208      25603       25801      25801       25801
    1466       1466       1466       1466       1466       1466        1466       1466        1466




12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012   6/1/2012   6/16/2012

    1503       1510       1516       1523       1529       1536        1539       1539        1539
MATRICES FOR GRADUATE RESEARCH ASSISTANTSHIP APPOINTMENTS
GRA SALARIES             (Assuming Salary Increase 7/1) for GRA and MBA                                                                                                                   Updated 07/06/11


STEP-32 Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011        8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012
AY + 3 SUM         12       18204       18234      18265       18295      18325       18386       18446       18507      18567      18628      18688      18749      18809       18839        18870       18900
AY + 2 SUM         11       16687       16687      16687       16717      16748       16808       16869       16929      16990      17050      17111      17171      17232       17262        17292       17322
AY + 1 SUM         10       15170       15170      15170       15170      15200       15261       15321       15382      15442      15503      15563      15624      15684       15715        15715       15745
AY                  9       13653       13653      13653       13653      13683       13744       13804       13865      13925      13986      14046      14107      14167       14198        14198       14198
3 SUM               3        4551        4581       4612        4642       4642        4642        4642        4642       4642       4642       4642       4642       4642        4642         4672        4702
2 SUM               2        3034        3034       3034        3064       3064        3064        3064        3064       3064       3064       3064       3064       3064        3064         3095        3125
1 SUM               1        1517        1517       1517        1517       1517        1517        1517        1517       1517       1517       1517       1517       1517        1517         1517        1547

STEP-26 Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt       7/1/2011   7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012
AY + 3 SUM       12         17154       17183      17211       17240      17268       17325       17382       17439      17496      17553      17610      17667      17724       17753        17781       17810
AY + 2 SUM       11         15725       15725      15725       15753      15782       15839       15896       15953      16010      16067      16124      16181      16238       16266        16295       16323
AY + 1 SUM       10         14295       14295      14295       14295      14324       14381       14438       14495      14552      14609      14666      14723      14780       14808        14808       14837
AY                9         12866       12866      12866       12866      12894       12951       13008       13065      13122      13179      13236      13293      13350       13379        13379       13379
3 SUM             3          4289        4317       4346        4374       4374        4374        4374        4374       4374       4374       4374       4374       4374        4374         4403        4431
2 SUM             2          2859        2859       2859        2888       2888        2888        2888        2888       2888       2888       2888       2888       2888        2888         2916        2945
1 SUM             1          1430        1430       1430        1430       1430        1430        1430        1430       1430       1430       1430       1430       1430        1430         1430        1458


GRA QUALIFIED TUITION REDUCTION
NOTE: Inflate 16% per year   *Please note the 16% QTR inflation is recommended through 6/30/2013. Starting 7/1/13, please use a 7% inflation rate.

Resident QTR
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011        8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

AY + SUM            12      10322       10322      10322       10519      10600       10762       10923       11085      11246      11408      11570      11731      11893       11973        11973       11973
AY + SUM            11      10322       10322      10322       10519      10600       10762       10923       11085      11246      11408      11570      11731      11893       11973        11973       11973
AY ONLY             10       9088        9088       9088        9088       9169        9330        9492        9653       9815       9977      10138      10300      10461       10542        10542       10542
AY ONLY              9       9088        9088       9088        9088       9169        9330        9492        9653       9815       9977      10138      10300      10461       10542        10542       10542
SUM ONLY           1-3       1234        1234       1234        1431       1431        1431        1431        1431       1431       1431       1431       1431       1431        1431         1431        1431

Non-Resident QTR
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011        8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

AY + SUM            12      23506       23506      23506       23708      23906       24301       24697       25092      25488      25883      26279      26674      27070       27267        27267       27267
AY + SUM            11      23506       23506      23506       23708      23906       24301       24697       25092      25488      25883      26279      26674      27070       27267        27267       27267
AY ONLY             10      22242       22242      22242       22242      22440       22835       23231       23626      24022      24417      24812      25208      25603       25801        25801       25801
AY ONLY              9      22242       22242      22242       22242      22440       22835       23231       23626      24022      24417      24812      25208      25603       25801        25801       25801
SUM ONLY           1-3       1264        1264       1264        1466       1466        1466        1466        1466       1466       1466       1466       1466       1466        1466         1466        1466


GRA HEALTH INSURANCE
NOTE: Inflate 4% per year
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011        8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

    Any > 9month             1480        1480       1480        1480       1483        1490        1496        1503       1510       1516       1523       1529       1536        1539         1539        1539
COLLEGE OF SCIENCES - MATRICES FOR GRADUATE RESEARCH ASSISTANTSHIP
GRA SALARIES             (Assuming Salary Increase 7/1) for COS                                                                                                                      Updated 07/06/11


STEP-47 Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012
AY + 3 SUM         12       21144   21179     21215       21250      21285       21356       21426       21497      21567      21638      21708      21779      21849       21884        21920       21955
AY + 2 SUM         11       19382   19382     19382       19417      19453       19523       19594       19664      19735      19805      19876      19946      20017       20052        20087       20122
AY + 1 SUM         10       17620   17620     17620       17620      17655       17726       17796       17867      17937      18008      18078      18149      18219       18255        18255       18290
AY                  9       15858   15858     15858       15858      15893       15964       16034       16105      16175      16246      16316      16387      16457       16493        16493       16493
3 SUM               3        5286    5321      5357        5392       5392        5392        5392        5392       5392       5392       5392       5392       5392        5392         5427        5462
2 SUM               2        3524    3524      3524        3559       3559        3559        3559        3559       3559       3559       3559       3559       3559        3559         3595        3630
1 SUM               1        1762    1762      1762        1762       1762        1762        1762        1762       1762       1762       1762       1762       1762        1762         1762        1797

STEP-42 Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012
AY + 3 SUM         12       20100   20134     20167       20201      20234       20301       20368       20435      20502      20569      20636      20703      20770       20804        20837       20871
AY + 2 SUM         11       18425   18425     18425       18459      18492       18559       18626       18693      18760      18827      18894      18961      19028       19062        19095       19129
AY + 1 SUM         10       16750   16750     16750       16750      16784       16851       16918       16985      17052      17119      17186      17253      17320       17353        17353       17387
AY                  9       15075   15075     15075       15075      15109       15176       15243       15310      15377      15444      15511      15578      15645       15678        15678       15678
3 SUM               3        5025    5059      5092        5126       5126        5126        5126        5126       5126       5126       5126       5126       5126        5126         5159        5193
2 SUM               2        3350    3350      3350        3384       3384        3384        3384        3384       3384       3384       3384       3384       3384        3384         3417        3451
1 SUM               1        1675    1675      1675        1675       1675        1675        1675        1675       1675       1675       1675       1675       1675        1675         1675        1709


GRA QUALIFIED TUITION REDUCTION
NOTE: Inflate 16% per year   *Please note the 16% QTR inflation is recommended through 6/30/2013. Starting 7/1/13, please use a 7% inflation rate.

Resident QTR
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

AY + SUM            12      10322   10322     10322       10519      10600       10762       10923       11085      11246      11408      11570      11731      11893       11973        11973       11973
AY + SUM            11      10322   10322     10322       10519      10600       10762       10923       11085      11246      11408      11570      11731      11893       11973        11973       11973
AY ONLY             10       9088    9088      9088        9088       9169        9330        9492        9653       9815       9977      10138      10300      10461       10542        10542       10542
AY ONLY              9       9088    9088      9088        9088       9169        9330        9492        9653       9815       9977      10138      10300      10461       10542        10542       10542
SUM ONLY           1-3       1234    1234      1234        1431       1431        1431        1431        1431       1431       1431       1431       1431       1431        1431         1431        1431

Non-Resident QTR
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

AY + SUM            12      23506   23506     23506       23708      23906       24301       24697       25092      25488      25883      26279      26674      27070       27267        27267       27267
AY + SUM            11      23506   23506     23506       23708      23906       24301       24697       25092      25488      25883      26279      26674      27070       27267        27267       27267
AY ONLY             10      22242   22242     22242       22242      22440       22835       23231       23626      24022      24417      24812      25208      25603       25801        25801       25801
AY ONLY              9      22242   22242     22242       22242      22440       22835       23231       23626      24022      24417      24812      25208      25603       25801        25801       25801
SUM ONLY           1-3       1264    1264      1264        1466       1466        1466        1466        1466       1466       1466       1466       1466       1466        1466         1466        1466


GRA HEALTH INSURANCE
NOTE: Inflate 4% per year
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

    Any > 9month             1480    1480      1480        1480       1483        1490        1496        1503       1510       1516       1523       1529       1536        1539         1539        1539
MATRICES FOR GRADUATE RESEARCH ASSISTANTSHIP APPOINTMENTS
GRA SALARIES             (Assuming Salary Increase 7/1) For DVM                                                                                                                      Updated 07/06/11


STEP-60 Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012
AY + 3 SUM         12       24054   24094     24134       24174      24214       24294       24374       24454      24534      24614      24694      24774      24854       24894        24934       24974
AY + 2 SUM         11       22050   22050     22050       22090      22130       22210       22290       22370      22450      22530      22610      22690      22770       22810        22850       22890
AY + 1 SUM         10       20045   20045     20045       20045      20085       20165       20245       20325      20405      20485      20565      20645      20725       20765        20765       20805
AY                  9       18041   18041     18041       18041      18081       18161       18241       18321      18401      18481      18561      18641      18721       18761        18761       18761
3 SUM               3        6014    6054      6094        6134       6134        6134        6134        6134       6134       6134       6134       6134       6134        6134         6174        6214
2 SUM               2        4009    4009      4009        4049       4049        4049        4049        4049       4049       4049       4049       4049       4049        4049         4089        4129
1 SUM               1        2005    2005      2005        2005       2005        2005        2005        2005       2005       2005       2005       2005       2005        2005         2005        2045

STEP-49 Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012
AY + 3 SUM         12       21558   21594     21630       21666      21702       21774       21846       21918      21990      22062      22134      22206      22278       22314        22350       22386
AY + 2 SUM         11       19762   19762     19762       19798      19834       19906       19978       20050      20122      20194      20266      20338      20410       20446        20482       20518
AY + 1 SUM         10       17965   17965     17965       17965      18001       18073       18145       18217      18289      18361      18433      18505      18577       18613        18613       18649
AY                  9       16169   16169     16169       16169      16205       16277       16349       16421      16493      16565      16637      16709      16781       16817        16817       16817
3 SUM               3        5390    5426      5462        5498       5498        5498        5498        5498       5498       5498       5498       5498       5498        5498         5534        5570
2 SUM               2        3593    3593      3593        3629       3629        3629        3629        3629       3629       3629       3629       3629       3629        3629         3665        3701
1 SUM               1        1797    1797      1797        1797       1797        1797        1797        1797       1797       1797       1797       1797       1797        1797         1797        1833


GRA QUALIFIED TUITION REDUCTION
NOTE: Inflate 16% per year   *Please note the 16% QTR inflation is recommended through 6/30/2013. Starting 7/1/13, please use a 7% inflation rate.

Resident QTR
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

AY + SUM            12      10322   10322     10322       10519      10600       10762       10923       11085      11246      11408      11570      11731      11893       11973        11973       11973
AY + SUM            11      10322   10322     10322       10519      10600       10762       10923       11085      11246      11408      11570      11731      11893       11973        11973       11973
AY ONLY             10       9088    9088      9088        9088       9169        9330        9492        9653       9815       9977      10138      10300      10461       10542        10542       10542
AY ONLY              9       9088    9088      9088        9088       9169        9330        9492        9653       9815       9977      10138      10300      10461       10542        10542       10542
SUM ONLY           1-3       1234    1234      1234        1431       1431        1431        1431        1431       1431       1431       1431       1431       1431        1431         1431        1431

Non-Resident QTR
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

AY + SUM            12      23506   23506     23506       23708      23906       24301       24697       25092      25488      25883      26279      26674      27070       27267        27267       27267
AY + SUM            11      23506   23506     23506       23708      23906       24301       24697       25092      25488      25883      26279      26674      27070       27267        27267       27267
AY ONLY             10      22242   22242     22242       22242      22440       22835       23231       23626      24022      24417      24812      25208      25603       25801        25801       25801
AY ONLY              9      22242   22242     22242       22242      22440       22835       23231       23626      24022      24417      24812      25208      25603       25801        25801       25801
SUM ONLY           1-3       1264    1264      1264        1466       1466        1466        1466        1466       1466       1466       1466       1466       1466        1466         1466        1466


GRA HEALTH INSURANCE
NOTE: Inflate 4% per year
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

    Any > 9month             1480    1480      1480        1480       1483        1490        1496        1503       1510       1516       1523       1529       1536        1539         1539        1539
MATRICES FOR GRADUATE RESEARCH ASSISTANTSHIP APPOINTMENTS
GRA SALARIES             (Assuming Salary Increase 7/1) For Pharmacy                                                                                                                 Updated 07/06/11


STEP-60 Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012
AY + 3 SUM         12       24054   24094     24134       24174      24214       24294       24374       24454      24534      24614      24694      24774      24854       24894        24934       24974
AY + 2 SUM         11       22050   22050     22050       22090      22130       22210       22290       22370      22450      22530      22610      22690      22770       22810        22850       22890
AY + 1 SUM         10       20045   20045     20045       20045      20085       20165       20245       20325      20405      20485      20565      20645      20725       20765        20765       20805
AY                  9       18041   18041     18041       18041      18081       18161       18241       18321      18401      18481      18561      18641      18721       18761        18761       18761
3 SUM               3        6014    6054      6094        6134       6134        6134        6134        6134       6134       6134       6134       6134       6134        6134         6174        6214
2 SUM               2        4009    4009      4009        4049       4049        4049        4049        4049       4049       4049       4049       4049       4049        4049         4089        4129
1 SUM               1        2005    2005      2005        2005       2005        2005        2005        2005       2005       2005       2005       2005       2005        2005         2005        2045

STEP-49 Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012
AY + 3 SUM         12       21558   21594     21630       21666      21702       21774       21846       21918      21990      22062      22134      22206      22278       22314        22350       22386
AY + 2 SUM         11       19762   19762     19762       19798      19834       19906       19978       20050      20122      20194      20266      20338      20410       20446        20482       20518
AY + 1 SUM         10       17965   17965     17965       17965      18001       18073       18145       18217      18289      18361      18433      18505      18577       18613        18613       18649
AY                  9       16169   16169     16169       16169      16205       16277       16349       16421      16493      16565      16637      16709      16781       16817        16817       16817
3 SUM               3        5390    5426      5462        5498       5498        5498        5498        5498       5498       5498       5498       5498       5498        5498         5534        5570
2 SUM               2        3593    3593      3593        3629       3629        3629        3629        3629       3629       3629       3629       3629       3629        3629         3665        3701
1 SUM               1        1797    1797      1797        1797       1797        1797        1797        1797       1797       1797       1797       1797       1797        1797         1797        1833


GRA QUALIFIED TUITION REDUCTION
NOTE: Inflate 16% per year   *Please note the 16% QTR inflation is recommended through 6/30/2013. Starting 7/1/13, please use a 7% inflation rate.

Resident QTR
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

AY + SUM            12      10322   10322     10322       10519      10600       10762       10923       11085      11246      11408      11570      11731      11893       11973        11973       11973
AY + SUM            11      10322   10322     10322       10519      10600       10762       10923       11085      11246      11408      11570      11731      11893       11973        11973       11973
AY ONLY             10       9088    9088      9088        9088       9169        9330        9492        9653       9815       9977      10138      10300      10461       10542        10542       10542
AY ONLY              9       9088    9088      9088        9088       9169        9330        9492        9653       9815       9977      10138      10300      10461       10542        10542       10542
SUM ONLY           1-3       1234    1234      1234        1431       1431        1431        1431        1431       1431       1431       1431       1431       1431        1431         1431        1431

Non-Resident QTR
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

AY + SUM            12      23506   23506     23506       23708      23906       24301       24697       25092      25488      25883      26279      26674      27070       27267        27267       27267
AY + SUM            11      23506   23506     23506       23708      23906       24301       24697       25092      25488      25883      26279      26674      27070       27267        27267       27267
AY ONLY             10      22242   22242     22242       22242      22440       22835       23231       23626      24022      24417      24812      25208      25603       25801        25801       25801
AY ONLY              9      22242   22242     22242       22242      22440       22835       23231       23626      24022      24417      24812      25208      25603       25801        25801       25801
SUM ONLY           1-3       1264    1264      1264        1466       1466        1466        1466        1466       1466       1466       1466       1466       1466        1466         1466        1466


GRA HEALTH INSURANCE
NOTE: Inflate 4% per year
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/16/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

    Any > 9month             1480    1480      1480        1480       1483        1490        1496        1503       1510       1516       1523       1529       1536        1539         1539        1539
MATRICES FOR GRADUATE RESEARCH ASSISTANTSHIP APPOINTMENTS
GRA SALARIES             (Assuming Salary Increase 7/1) for Nursing                                                                                                                  Updated 07/06/11


STEP-77 Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/15/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012
AY + 3 SUM         12       21144   21179     21215       21250      21285       21356       21426       21497      21567      21638      21708      21779      21849       21884        21920       21955
AY + 2 SUM         11       19382   19382     19382       19417      19453       19523       19594       19664      19735      19805      19876      19946      20017       20052        20087       20122
AY + 1 SUM         10       17620   17620     17620       17620      17655       17726       17796       17867      17937      18008      18078      18149      18219       18255        18255       18290
AY                  9       15858   15858     15858       15858      15893       15964       16034       16105      16175      16246      16316      16387      16457       16493        16493       16493
3 SUM               3        5286    5321      5357        5392       5392        5392        5392        5392       5392       5392       5392       5392       5392        5392         5427        5462
2 SUM               2        3524    3524      3524        3559       3559        3559        3559        3559       3559       3559       3559       3559       3559        3559         3595        3630
1 SUM               1        1762    1762      1762        1762       1762        1762        1762        1762       1762       1762       1762       1762       1762        1762         1762        1797

STEP-60 Level Research Assistant -- 50% Appointment (Inflate 4% for Subsequent Years)
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/15/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012
AY + 3 SUM         12       20100   20134     20167       20201      20234       20301       20368       20435      20502      20569      20636      20703      20770       20804        20837       20871
AY + 2 SUM         11       18425   18425     18425       18459      18492       18559       18626       18693      18760      18827      18894      18961      19028       19062        19095       19129
AY + 1 SUM         10       16750   16750     16750       16750      16784       16851       16918       16985      17052      17119      17186      17253      17320       17353        17353       17387
AY                  9       15075   15075     15075       15075      15109       15176       15243       15310      15377      15444      15511      15578      15645       15678        15678       15678
3 SUM               3        5025    5059      5092        5126       5126        5126        5126        5126       5126       5126       5126       5126       5126        5126         5159        5193
2 SUM               2        3350    3350      3350        3384       3384        3384        3384        3384       3384       3384       3384       3384       3384        3384         3417        3451
1 SUM               1        1675    1675      1675        1675       1675        1675        1675        1675       1675       1675       1675       1675       1675        1675         1675        1709


GRA QUALIFIED TUITION REDUCTION
NOTE: Inflate 16% per year   *Please note the 16% QTR inflation is recommended through 6/30/2013. Starting 7/1/13, please use a 7% inflation rate.

Resident QTR
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/15/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

AY + SUM            12      16224   16224     16224       16421      16555       16821       17088       17354      17620      17887      18153      18420      18686       18819        18819       18819
AY + SUM            11      16224   16224     16224       16421      16555       16821       17088       17354      17620      17887      18153      18420      18686       18819        18819       18819
AY ONLY             10      14990   14990     14990       14990      15123       15390       15656       15923      16189      16455      16722      16988      17255       17388        17388       17388
AY ONLY              9      14990   14990     14990       14990      15123       15390       15656       15923      16189      16455      16722      16988      17255       17388        17388       17388
SUM ONLY           1-3       1234    1234      1234        1431       1431        1431        1431        1431       1431       1431       1431       1431       1431        1431         1431        1431

Non-Resident QTR
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/15/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

AY + SUM            12      31016   31016     31016       31218      31483       32012       32540       33069      33598      34127      34656      35185      35714       35978        35978       35978
AY + SUM            11      31016   31016     31016       31218      31483       32012       32540       33069      33598      34127      34656      35185      35714       35978        35978       35978
AY ONLY             10      29752   29752     29752       29752      30016       30545       31074       31603      32132      32661      33190      33719      34248       34512        34512       34512
AY ONLY              9      29752   29752     29752       29752      30016       30545       31074       31603      32132      32661      33190      33719      34248       34512        34512       34512
SUM ONLY           1-3       1264    1264      1264        1466       1466        1466        1466        1466       1466       1466       1466       1466       1466        1466         1466        1466


GRA HEALTH INSURANCE
NOTE: Inflate 4% per year
             Apptmt/Grant Begins:
             Apptmt    7/1/2011 7/15/2011   8/1/2011   8/16/2011   9/1/2011   10/1/2011   11/1/2011   12/1/2011   1/1/2012   2/1/2012   3/1/2012   4/1/2012   5/1/2012   5/16/2012     6/1/2012   6/16/2012

    Any > 9month             1480    1480      1480        1480       1483        1490        1496        1503       1510       1516       1523       1529       1536        1539         1539        1539

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:22
posted:11/19/2011
language:English
pages:26