Embed
Email

Salary Calculator

Document Sample

Shared by: cuiliqing
Categories
Tags
Stats
views:
8
posted:
10/31/2011
language:
English
pages:
7
Grant Buyout for Grant Buyout

Nine Month Employee Worksheet Nine Month Employee Worksheet

EPAF Labor Distribution Effort showing in ERS



Annual Salary $50,000.00 Annual Salary $50,000.00

Minus Stipend $0.00 Minus Stipend $0.00

Annual Salary $50,000.00 Annual Salary $50,000.00

Monthly Pay $4,166.67 9/12 Monthly $5,555.56

Semi-Monthly Pay $2,083.33 9/12 Semi Monthly $2,777.78



Reassigned Effort (% FTE) 50.000% Reassigned Effort (% FTE) 50.000%

Annual Salary Funded $25,000.00 Annual Salary Funded $25,000.00

Monthly Pay to be Reassigned $2,083.33 Monthly Pay to be Reassigned $2,777.78

Semi-Monthly Pay $1,041.67 Semi-Monthly Pay $1,388.89





Annual Salary 12 Annual Salary 12

% FTE for Grant 50.000% % FTE for Grant 50.000%

Semi-Monthly Distr. Amount for Grant $1,041.67 Semi-Monthly Distr. Amount for Grant $1,388.89

Annual Salary for Grant $25,000.00 Annual Salary for Grant $33,333.33

% FTE for State 50.000% % FTE for State 50.000%

Semi-Monthly Distr. Amount for State $1,041.67 Semi-Monthly Distr. Amount for State $1,388.89

Annual Salary for State $25,000.00 Annual Salary for State $16,666.67

Grant Buyout for Six Month Employee Worksheet



Part Time to Full Time Conversion



Annual Salary $7,500.00

FTE 0.5

Semester Salary $15,000.00



Buyout Calculation EPAF Percentage Check



Annual Salary $125,000.00 FTE Annual Salary Percentage

Minus Stipend 0.00%

Adjusted Salary $125,000.00 0.00%

Monthly Pay $20,833.33 0.00%

Semi-Monthly Pay $10,416.67 0.05 $6,000.00 5.00%

0.55 $66,000.00 55.00%

Reassigned Effort (% FTE) 15.00% 0.25 $30,000.00 25.00%



Annual Salary Funded $18,750.00 0.15 $18,000.00 15.00%

Monthly Pay to be Reassigned $3,125.00 0.00%

Semi-Monthly Pay $1,562.50 1.00 $120,000.00 100.00%



Annual Salary 12

% FTE for Grant 15.000%

Semi-Monthly Distr. Amount for Grant $1,562.50

Annual Salary for Grant $37,500.00

% FTE for State 85.000%

Semi-Monthly Distr. Amount for State $8,854.17

Annual Salary for State $87,500.00



Check $125,000.00

Expenditure Check

No. Pays

FTE Semi-Mo Pay 12 Total

0.00 $0.00 12 $0.00

0.00 $0.00 12 $0.00

0.00 $0.00 12 $0.00

0.05 $250.00 12 $3,000.00

0.55 $2,750.00 12 $33,000.00

0.25 $1,250.00 12 $15,000.00



0.15 $750.00 12 $9,000.00

0.00 $1,562.50 12 $18,750.00

1.00 $6,562.50 $78,750.00

Grant Buyout

Nine Month Employee Worksheet

***Only change figures highlighted in yellow.





Annual Salary $85,536.00

Minus Stipend $0.00

Annual Salary $85,536.00

9/12 Monthly $9,504.00

9/12 Semi Monthly $4,752.00



Reassigned Effort (% FTE) 25.000%

Annual Salary Funded $21,384.00

Monthly Pay to be Reassigned $2,376.00

Semi-Monthly Pay $1,188.00



Section 5:

Annual Salary 12

% FTE for Grant 25.000%

Semi-Monthly Distr. Amount for Grant $1,188.00

Annualized $28,512.00

% FTE for State 75.000%

Semi-Monthly Distr. Amount for State $3,564.00

Annual Salary for State $57,024.00

Grant Buyout

Nine Month Employee Worksheet

***Only change figures highlighted in yellow.





Annual Salary $44,795.00

10/12 Monthly $3,732.92

10/12 Semi Monthly $1,866.46



Reassigned Effort (% FTE) 100.000%

Annual Salary Funded $44,795.00

Monthly Pay to be Reassigned $8,959.00

Semi-Monthly Pay $2,239.75



Section 5:

Annual Salary 12

% FTE for Grant 100.000%

Semi-Monthly Distr. Amount for Grant $2,239.75

Annualized $53,754.00

% FTE for State 0.000%

Semi-Monthly Distr. Amount for State -$373.29

Annual Salary for State -$8,959.00

Grant Buyout for Twelve Month Employee Worksheet



Part Time to Full Time Conversion



Annual Salary

FTE

Full time Salary #DIV/0!



Buyout Calculation EPAF Percentage Check Expenditure Check

No. Pays

Annual Salary $70,954.00 FTE Annual Salary Percentage FTE Semi-Mo Pay 12 Total

Minus Stipend $0.00 0.2 $14,191.00 40.00% 0.20 $591.29 12 $7,095.50

Adjusted Salary $70,954.00 0.3 $21,286.00 60.00% 0.30 $886.92 12 $10,643.00

Monthly Pay $5,912.83 0.00% 0.00 $0.00 12 $0.00

Semi-Monthly Pay $2,956.42 0.00% 0.00 $0.00 12 $0.00

0.00% 0.00 $0.00 12 $0.00

Reassigned Effort (% FTE) 50.00% 0.00% 0.00 $0.00 12 $0.00



Annual Salary Funded $35,477.00 0.00% 0.00 $0.00 12 $0.00

Monthly Pay to be Reassigned $2,956.42 0.00% 0.00 $0.00 12 $0.00

Semi-Monthly Pay $1,478.21 0.500 $35,477.00 100.00% 0.50 $1,478.21 $17,738.50



Annual Salary 12

% FTE for Grant 50.000%

Semi-Monthly Distr. Amount for Grant $1,478.21

Annual Salary for Grant $35,477.00

% FTE for State 50.000%

Semi-Monthly Distr. Amount for State $1,478.21

Annual Salary for State $35,477.00



Check $70,954.00

Summer Pay Employee Worksheet







Annual Salary $50,000.00 EPAF Percentage Check Expenditure Check

Minus Stipend $0.00 No. Pays

Adjusted Annual Salary $50,000.00 FTE Supplemental Pay Percentage FTE Special Rate 2 Total

Monthly Pay $5,555.56 0.25 $1,388.89 50.00% 0.25 $694.45 2 $1,388.89

Semi-Monthly Pay $2,777.78 0.25 $1,388.89 50.00% 0.25 $694.45 2 $1,388.89

0.00% 0.00 $0.00 2 $0.00

Reassigned Effort (% FTE) 25% 0.00% 0.00 $0.00 2 $0.00



Annual Salary Funded $12,500.00 0.00% 0.00 $0.00 2 $0.00

Monthly Pay to be Reassigned $1,388.89 0.00% 0.00 $0.00 2 $0.00

Semi-Monthly Pay $694.44 0.00% 0.00 $0.00 2 $0.00

0.00% 0.00 $0.00 2 $0.00

# of Working Months 1 0.500 $2,777.78 100.00% 0.50 $1,388.89 $2,777.78

Amount of Supplemental Pay (Summer) $1,388.89

Number of Pays 2

Special Rate $694.44



Rules

133% $66,500.00

Yearly Allowable $16,500.00

Monthly Pay Allowable $5,541.67

Total Allowable on Request $5,541.67

Funds from Additional Pay Source

Total request for pay $2,777.78

Available to Earn $13,722.22









***Only change figures highlighted in yellow.



Other docs by cuiliqing
7 Recipes from Joe A.
Views: 2  |  Downloads: 0
Re-installingXPMode
Views: 3  |  Downloads: 0
telefonica_en
Views: 4  |  Downloads: 0
3220 Chap 6 demos
Views: 2  |  Downloads: 0
chap history.docx
Views: 3  |  Downloads: 0
Subcontractor Bid Form - The Fountains
Views: 1  |  Downloads: 0
English
Views: 1  |  Downloads: 0
DESIGNER'S SCHEDULE USE
Views: 1  |  Downloads: 0
Security Service Providers
Views: 45  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!