Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Authentication
digital resources
184x Filetype XLSX File size 0.05 MB Source: www.purdue.edu
Sheet 1: 2008
| NSF Summer Salary Calculator | ||||
| Faculty Name: | Professor Perfect - 2008 | |||
| SS1 | SS2 | TSS | AR1 | AR2 |
| 2.000000000 | 9.442424815 | 11.442424815 | $100,000.00 | $105,905.00 |
| SS1 $: | $1,000.00 | MAX Days: | 44.44 | |
| SS2 $: | $5,000.00 | |||
| TSS (TOTAL): | $6,000.00 | |||
| MAX $: | $23,305.08 | |||
| Difference: | $17,305.08 | |||
| Data should only be entered in cells B3, B8, B9, D6, and E6. | ||||
| Assumptions: based on calculations from summer payroll calculator | ||||
| 1) 1 day = 0.5% of AY salary, or 200 days = 100% of AY salary | ||||
| 2) AR1 and AR2 = 100% Annual Rate x FTE | ||||
| Definitions: | ||||
| AR1 (Academic Rate 1) – The applicable Academic Year Salary received by the faculty member during the fiscal period ending in the prior spring semester. | ||||
| NOTE: | AR1 cannot equal zero. If the faculty member was hired after the Spring semester, enter $1 for AR1 and $0 for SS1. | |||
| AR2 (Academic Rate 2) – The applicable Academic Year Salary received by the faculty member during the fall semester following the summer period. | ||||
| SS1 (Summer Salary 1) – The number of NSF-funded days paid on summer salary during the first fiscal period (through June 30th). | ||||
| SS2 (Summer Salary 2) – The number of NSF-funded days paid on summer salary during the second fiscal period (after July 1st). | ||||
| TSS (Total Summer Salary) – The total of NSF-funded days paid on summer salary to the faculty member during the entire summer period. | ||||
| NSF Salary Calculator | Data should only be entered in the highlighted cells. | AY | |||||||
| Fiscal Year | 2009 | FY | |||||||
| Faculty Name: | Professor Perfect | MAX Allowable AY Salary: | 0.00 | ||||||
| Pernr: | 12345678 | Summer | |||||||
| Org Unit/Name: | ### - Name | Annual Salary (Input highest FY salary): | $0.00 | AY | |||||
| Appointment: | AY | Monthly AY Salary: | $0.00 | ||||||
| Monthly Summer Salary: | $0.00 | ||||||||
| Grant | Valid From Date | Valid To Date | Sponsored Prgm Name | SPS Acct Number | Additional Months | Summer or AY Salary? | Additional Budgeted Sal | NSF Budget Notes | |
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| NSF Total by PAR Period | |||||||||
| Month | Jul | August Summer | August AY | ||||||
| % NSF | 0.0% | 0.0% | 0.0% | Summer | |||||
| $ NSF | $0.00 | $0.00 | $0.00 | $- | |||||
| Month | Sep | Oct | Nov | Dec | |||||
| % NSF | 0.0% | 0.0% | 0.0% | 0.0% | Fall | ||||
| $ NSF | $0.00 | $0.00 | $0.00 | $0.00 | $- | ||||
| Month | Jan | Feb | Mar | Apr | |||||
| % NSF | 0.0% | 0.0% | 0.0% | 0.0% | Spring | ||||
| $ NSF | $0.00 | $0.00 | $0.00 | $0.00 | $- | ||||
| Month | May AY | May Summer | June | ||||||
| % NSF | 0.0% | 0.0% | 0.0% | Summer | |||||
| $ NSF | $0.00 | $0.00 | $0.00 | $- | |||||
| Links: | Annual NSF Salary | $- | |||||||
| NSF Salary Policy | Available Balance | $- | |||||||
| SPS NSF Webpage | |||||||||
| NSF Salary Calculator | Data should only be entered in the highlighted cells. | AY | |||||||
| Fiscal Year | 2010 | FY | |||||||
| Faculty Name: | Professor Perfect | MAX Allowable AY Salary: | 0.00 | ||||||
| Pernr: | 12345678 | Summer | |||||||
| Org Unit/Name: | ### - Name | Annual Salary (Input highest FY salary): | $0.00 | AY | |||||
| Appointment: | AY | Monthly AY Salary: | $0.00 | ||||||
| Monthly Summer Salary: | $0.00 | ||||||||
| Grant | Valid From Date | Valid To Date | Sponsored Prgm Name | SPS Acct Number | Additional Months | Summer or AY Salary? | Additional Budgeted Sal | NSF Budget Notes | |
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| $- | |||||||||
| NSF Total by PAR Period | |||||||||
| Month | Jul | August Summer | August AY | ||||||
| % NSF | 0.0% | 0.0% | 0.0% | Summer | |||||
| $ NSF | $0.00 | $0.00 | $0.00 | $- | |||||
| Month | Sep | Oct | Nov | Dec | |||||
| % NSF | 0.0% | 0.0% | 0.0% | 0.0% | Fall | ||||
| $ NSF | $0.00 | $0.00 | $0.00 | $0.00 | $- | ||||
| Month | Jan | Feb | Mar | Apr | |||||
| % NSF | 0.0% | 0.0% | 0.0% | 0.0% | Spring | ||||
| $ NSF | $0.00 | $0.00 | $0.00 | $0.00 | $- | ||||
| Month | May AY | May Summer | June | ||||||
| % NSF | 0.0% | 0.0% | 0.0% | Summer | |||||
| $ NSF | $0.00 | $0.00 | $0.00 | $- | |||||
| Links: | Annual NSF Salary | $- | |||||||
| NSF Salary Policy | Available Balance | $- | |||||||
| SPS NSF Webpage | |||||||||
no reviews yet
Please Login to review.
