Docstoc

Salary Cap Worksheet

Document Sample
Salary Cap Worksheet Powered By Docstoc
					                                                                                                                                                                                    LEGEND
                  SALARY DISTRIBUTION WORKSHEET - INCLUDES SALARY CAP CALCULATIONS                                                                     RED               =required input
PI:                   Dr. X                                                                                                                            Percentages (%)   should total 100%
Annual Salary:    $ 229,500.00                                                                                                                         Annual Salary Cap - based on issuance and effective dates
Date Range:           FY13

                                                                                                September-12                                                                                    October-12                                                                                November-12
                                                                                                                                                                               Distribution                                                                              Distribution
                                                                           Distribution based                                                                                   based on                                                                                  based on
                  Cap Amount     SmartKey(s) subject                         on committed                                         Adjusted                                     committed                                              Adjusted                           committed                                             Adjusted
Select Cap Type     (if any)       to Salary Cap        % Distribution            effort          Monthly Cap       Cost Share  Distribution %            % Distribution          effort         Monthly Cap      Cost Share        Distribution %   % Distribution         effort         Monthly Cap     Cost Share        Distribution %
    No Cap                  -       1st Smartkey                5.00%                  956.25           956.25             0.00         5.00%                      10.00%          1,912.50         1,912.50              0.00             10.00%            10.00%          1,912.50         1,912.50             0.00             10.00%
    Old Cap        199,700.00       2nd Smartkey               19.70%                3,767.63         3,278.41           489.22        17.14%                      10.00%          1,912.50         1,664.17            248.33               8.70%           10.00%          1,912.50         1,664.17           248.33               8.70%
    New Cap        179,700.00       3rd Smartkey                4.69%                  896.77           702.18           194.59         3.67%                       5.00%             956.25          748.75            207.50               3.92%            5.00%             956.25          748.75           207.50               3.92%
    New Cap        179,700.00       4th Smartkey                1.00%                  191.25           149.75            41.50         0.78%                       5.00%             956.25          748.75            207.50               3.92%            5.00%             956.25          748.75           207.50               3.92%
    No Cap                  -       5th Smartkey                1.00%                  191.25           191.25             0.00         1.00%                       5.00%             956.25          956.25              0.00               5.00%            5.00%             956.25          956.25             0.00               5.00%
    Old Cap        199,700.00       6th Smartkey                1.00%                  191.25           166.42            24.83         0.87%                       5.00%             956.25          832.08            124.17               4.35%            5.00%             956.25          832.08           124.17               4.35%
    Old Cap        199,700.00       7th Smartkey                1.00%                  191.25           166.42            24.83         0.87%                       5.00%             956.25          832.08            124.17               4.35%            5.00%             956.25          832.08           124.17               4.35%
    No Cap                  -       8th Smartkey                1.00%                  191.25           191.25             0.00         1.00%                       2.00%             382.50          382.50              0.00               2.00%            2.00%             382.50          382.50             0.00               2.00%
    Old Cap        199,700.00       9th Smartkey                1.00%                  191.25           166.42            24.83         0.87%                       2.00%             382.50          332.83             49.67               1.74%            3.00%             573.75          499.25            74.50               2.61%
    Old Cap        199,700.00      10th Smartkey                1.00%                  191.25           166.42            24.83         0.87%                       2.00%             382.50          332.83             49.67               1.74%            2.00%             382.50          332.83            49.67               1.74%
    No Cap                  -      11th Smartkey                5.00%                  956.25           956.25             0.00         5.00%                       2.00%             382.50          382.50              0.00               2.00%            2.00%             382.50          382.50             0.00               2.00%
    No Cap                  -      12th Smartkey                1.00%                  191.25           191.25             0.00         1.00%                       2.00%             382.50          382.50              0.00               2.00%            2.00%             382.50          382.50             0.00               2.00%
    New Cap        179,700.00      13th Smartkey                4.00%                  765.00           599.00           166.00         3.13%                       5.00%             956.25          748.75            207.50               3.92%            5.00%             956.25          748.75           207.50               3.92%
    No Cap                  -      14th Smartkey                1.00%                  191.25           191.25             0.00         1.00%                       5.00%             956.25          956.25              0.00               5.00%            5.00%             956.25          956.25             0.00               5.00%
    No Cap                  -      15th Smartkey                1.00%                  191.25           191.25             0.00         1.00%                       5.00%             956.25          956.25              0.00               5.00%            5.00%             956.25          956.25             0.00               5.00%
    New Cap        179,700.00      16th Smartkey                1.00%                  191.25           149.75            41.50         0.78%                       5.00%             956.25          748.75            207.50               3.92%            5.00%             956.25          748.75           207.50               3.92%
    Old Cap                 -      17th Smartkey                1.00%                  191.25           191.25             0.00         1.00%                       5.00%             956.25          956.25              0.00               5.00%            5.00%             956.25          956.25             0.00               5.00%
    New Cap        179,700.00      18th Smartkey                2.00%                  382.50           299.50            83.00         1.57%                       5.00%             956.25          748.75            207.50               3.92%            5.00%             956.25          748.75           207.50               3.92%
    Old Cap        199,700.00      19th Smartkey                1.00%                  191.25           166.42            24.83         0.87%                       5.00%             956.25          832.08            124.17               4.35%            5.00%             956.25          832.08           124.17               4.35%
    Old Cap        199,700.00      20th Smartkey                1.00%                  191.25           166.42            24.83         0.87%                       5.00%             956.25          832.08            124.17               4.35%            5.00%             956.25          832.08           124.17               4.35%
                                                                                                                       1,164.81                                                                                      1,881.83                0.00%                                                            1,906.67                0.00%
                                                                                                                                                                               Distribution                                                                              Distribution
                                                                           Distribution based                                                                                   based on                                                                                  based on
                                 SmartKey not Subject                        on committed           Monthly                             Adjusted                               committed           Monthly                            Adjusted                           committed          Monthly                            Adjusted
                                       to Cap           % Distribution            effort           Distribution                       Distribution %      % Distribution          effort          Distribution                      Distribution %   % Distribution         effort         Distribution                      Distribution %
                                       XXXXX                   21.57%                4,125.65           4,125.65                             21.57%                 1.00%             191.25             191.25                              1.00%            1.00%             191.25            191.25                              1.00%
                                       XXXXX                    9.38%                1,793.73           1,793.73                              9.38%                 0.00%                0.00              0.00                              0.00%            0.00%                0.00             0.00                              0.00%
                                       XXXXX                    9.05%                1,730.81           1,730.81                              9.05%                 1.00%             191.25             191.25                              1.00%            1.00%             191.25            191.25                              1.00%
                                       XXXXX                    5.61%                1,072.91           1,072.91                              5.61%                 1.00%             191.25             191.25                              1.00%            0.00%                0.00             0.00                              0.00%
                                       XXXXX                    0.00%                    0.00                0.00                             0.00%                 1.00%             191.25             191.25                              1.00%            1.00%             191.25            191.25                              1.00%
                                       XXXXX                    0.00%                    0.00                0.00                             0.00%                 0.00%                0.00              0.00                              0.00%            0.00%                0.00             0.00                              0.00%
                                       XXXXX                    0.00%                    0.00                0.00                             0.00%                 1.00%             191.25             191.25                              1.00%            1.00%             191.25            191.25                              1.00%
                                       XXXXX                    0.00%                    0.00                0.00                             0.00%                 0.00%                0.00              0.00                              0.00%            0.00%                0.00             0.00                              0.00%
                                 Cost Share SmartKey                                                      124.50                              0.65%                                                   1,504.50                               7.87%                                             1,500.00                               7.84%
                                 Cost Share SmartKey                                                    1,040.31                              5.44%                                                      377.33                              1.97%                                                406.67                              2.13%

                                                             100.00%              19,125.00           19,125.00                            100.00%               100.00%         19,125.00          19,125.00                            100.00%           100.00%         19,125.00         19,125.00                            100.00%
                                                         Must total 100%                                                                                     Must total 100%                                                                           Must total 100%


                                                                    Cost Share Balance to be Distributed:                   0.00                                    Cost Share Balance to be Distributed:                 0.00                                Cost Share Balance to be Distributed:                (0.00)
                                                                                                                     Should equal 0                                                                                Should equal 0                                                                           Should equal 0
SALARY DISTRIBUTION WORKSHEET - INCLUDES SALARY CAP CALCULATIONS                                                                                                     RED               =required input
                                                                                                                                                                                       = cost share
                                                                                                                                                                     Percentages (%) should total 100%
PI:                                                           Dr. X                                                                                                  Annual Salary Cap - based on issuance and effective dates
Annual Salary                                                  229,500.00                                                                                            # of days         = # of weekdays in the month (include holidays,
                                                                                                                                                                                          sick and vacation)
                                                                                                                                                                                       = adj distribution to set up salary distribution


Period                                                                               July-10       August-10      September-10
Monthly Salary                                                                    19,125.00        19,125.00         20,250.00
Number of Days                                                                           22               22                21
Number of Hours                                                                         176              176               168
Annual Salary Cap                                                                      0.00       199,700.00        199,700.00
Monthly Salary Cap                                                                     0.00        16,641.67         16,641.67
Hourly Salary Cap                                                                      0.00            96.01             96.01


                                                                                                July-10                                                                                                  August-10                                                                                         September-10
                                                                                                                                                                                          Distribution
                                                                           Distribution based                                                                                              based on                                                                                        Distribution based
                                   SmartKey(s) subject                       on committed                                                                                                 committed                                                                                          on committed
                                      to Salary Cap       % Distribution          effort        Monthly Cap       Cost Share     Adj Distribution %   # of Days        % Distribution        effort       Monthly Cap     Cost Share      Adj Distribution   # of Days     % Distribution         effort        Monthly Cap    Cost Share    Adj Distribution   # of Days
      New Cap                -        First Smartkey                 9.38%          1,793.93             0.00         1,793.93               0.00%            0.00             10.00%        1,912.50        1,664.17         248.33                8.70%           1.91            50.00%         10,125.00      8,320.83      1,804.17              41.09%          8.63
      Old Cap         199,700.00     Second Smartkey                40.32%          7,711.20             0.00         7,711.20               0.00%            0.00             35.00%        6,693.75        5,824.58         869.17              30.46%            6.70             8.00%          1,620.00      1,331.33        288.67                6.57%         1.38
      New Cap         179,700.00      Third Smartkey                 4.69%            896.77             0.00           896.77               0.00%            0.00              5.00%           956.25         832.08         124.17                4.35%           0.96             0.00%               0.00          0.00          0.00               0.00%         0.00
       No Cap         179,700.00     Fourth Smartkey
       No Cap                -        Fifth Smartkey
      Old Cap         199,700.00      Sixth Smartkey
      Old Cap         199,700.00    Seventh Smartkey
      Old Cap                -       Eighth Smartkey
     Select Type      199,700.00      Ninth Smartkey
      Old Cap         199,700.00      Tenth Smartkey                                                                 10,401.90                                                                                               1,241.67                                                                                           2,092.83

                                   SmartKey not Subject                                          Monthly                                                                                                   Monthly                                                                                               Monthly
                                         to Cap                                                 Distribution                                                                                              Distribution                                                                                          Distribution
                                                 XXXXX             21.57%          4,125.65           4,125.65                             21.57%            4.75              20.00%         3,825.00       3,825.00                             20.00%           4.40            15.00%           3,037.50       3,037.50                          15.00%          3.15
                                         XXXXX                      9.38%          1,793.73           1,793.73                              9.38%            2.06                                 0.00             0.00                            0.00%           0.00                                 0.00            0.00                          0.00%          0.00
                                         XXXXX                      9.05%          1,730.81           1,730.81                              9.05%            1.99              10.00%         1,912.50       1,912.50                             10.00%           2.20             0.00%               0.00            0.00                          0.00%          0.00
                                         XXXXX                      5.61%          1,072.91           1,072.91                              5.61%            1.23              10.00%         1,912.50       1,912.50                             10.00%           2.20             0.00%               0.00            0.00                          0.00%          0.00
                                         XXXXX                      0.00%              0.00                0.00                             0.00%            0.00               5.00%           956.25          956.25                             5.00%           1.10            15.00%           3,037.50       3,037.50                          15.00%          3.15
                                         XXXXX                      0.00%              0.00                0.00                             0.00%            0.00                                 0.00             0.00                            0.00%           0.00                                 0.00            0.00                          0.00%          0.00
                                         XXXXX                      0.00%              0.00                0.00                             0.00%            0.00               5.00%           956.25          956.25                             5.00%           1.10            12.00%           2,430.00       2,430.00                          12.00%          2.52
                                         XXXXX                      0.00%              0.00                0.00                             0.00%            0.00                                 0.00             0.00                            0.00%           0.00                                 0.00            0.00                          0.00%          0.00
Cost Share SmartKey                                                                                        0.00                             0.00%            0.00                                               312.50                             1.63%           0.36                                                 0.00                          0.00%          0.00
Cost Share SmartKey                                                                                   1,350.66                              7.06%            1.55                                               929.17                             4.86%           1.07                                            3,146.50                          15.54%          3.26

                                                                  100.00%         19,125.00         10,073.76                              52.67%           11.59             100.00%       19,125.00        19,125.00           (0.00)         100.00%           22.00          100.00%          20,250.00       21,303.67                         105.20%         22.09

                                                                         Cost Share Balance to be Distributed:        9,051.24                                                 Cost Share Balance to be Distributed:             (0.00)                                              Cost Share Balance to be Distributed:      (1,053.67)
Select Type
New Cap       179,700
Old Cap       199,700
No Cap              0
Calculations
1st smartkey    No Cap
1st Cap         0.00
2nd smartkey    Old Cap
2nd Cap          199,700.00
3rd smartkey    New Cap
3rd Cap          179,700.00
4th smartkey    New Cap
4th Cap         179700
5thsmartkey     No Cap
5th Cap                 -
6th smartkey    Old Cap
6th Cap         199700.00
7thsmartkey     Old Cap
7th Cap          199,700.00
8th smartkey    No Cap
8th Cap         0.00
9thsmartkey     Old Cap
9th Cap         199700.00
10th smartkey   Old Cap
10th Cap        199700.00
11th smartkey   No Cap
11th Cap        0.00
12th smartkey   No Cap
12th Cap        0.00
13th smartkey   New Cap
13th Cap        179700.00
14th smartkey   No Cap
14th Cap        0.00
15th smartkey   No Cap
15th Cap        0.00
16th smartkey   New Cap
16th Cap        179700.00
17th smartkey   Old Cap
17th Cap        199700.00
18th smartkey   New Cap
18th Cap             179700
19th smartkey   Old Cap
19th Cap             199700
20th smartkey   Old Cap
20th Cap             199700

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:10/4/2012
language:Japanese
pages:5