close

Вход

Забыли?

вход по аккаунту

код для вставкиСкачать
Summer Salary Assign Costing Allocation Worksheet
18-Jun-13
Section A:
Brown University-OVPR
Enter information in grey shaded fields (cells C7-C11) for calculating Institutional Base Salary (IBS)
IBS includes academic-year salary and any stipend you receive for performing other administrative duties, e.g. center director, department chair, or program director.
Worker:
FTE Monthly IBS
Academic Year Salary
Approval: Office Of Sponsored Projects
12
Appointment Type
Used for IBS calculation purposes only
Enter full time equivalency factor (FTE); e.g. if full time enter 1, if 67 % time enter .67
FTE
SECTION B: Note if Worker's salary exceeds sponsor imposed salary cap you MUST complete Summer - 1 Job + Over Cap Tab.
Enter Fund, Ledger Code, FRS Legacy Account, and Planned Effort for each award summer salary is assigned to.
JULY
Fund
Ledger
Account
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
Grant
Worktag
Funded Summer Effort-% and Dollars
Planned
Effort
FTE
Calculated
Monthly
Stipend
0.00% $
-
AUGUST
Actual
Monthly
Stipend
$
-
100.00%
Costing
Allocation Planned
Percentage Effort
0.00%
0.00%
FTE
Calculated
Monthly
Stipend
$
-
JUNE
Actual
Monthly
Stipend
$
Costing
Allocation Planned
Percentage Effort
-
100.00%
Unfunded on Primary Job - used for calculations only
* The data reflected in the green shaded fields above are entered in Workday when creating Summer Pay Compensation Plan
* The data reflected in the blue shaded columns above should be entered in Workday when completing Assign Costing Allocations Business Process
COMMENTS-Please provide any additional information supporting costing allocations below.
0.00%
0.00%
100.00%
FTE
Calculated
Monthly
Stipend
$
-
Actual
Monthly
Stipend
$
-
Costing
Allocation
Percentage
0.00%
Summer Salary Assign Costing Allocation Worksheet
21-Jan-15
Section A:
Brown University-OVPR
Enter information in grey shaded fields (cells C7-C11) for calculating Institutional Base Salary (IBS)
IBS includes academic-year salary and any stipend received for performing administrative duties, e.g. center/program director, dept. chair
Worker:
FTE Monthly IBS
Academic Year Salary
Approval: Office Of Sponsored Projects
12
Appointment Type
Used for IBS calculation purposes only
Enter full time equivalency factor (FTE); e.g. if full time enter 1, if 67 % time enter .67
FTE
SECTION B: Note: Worker's salary exceeds sponsor imposed salary cap you MUST complete Section C before this section.
Enter Fund, Ledger Code, FRS Legacy Account, and Planned Effort for each award summer salary is assigned to.
JULY
Fund
Ledger
Account
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
Funded Summer Effort-% and Dollars
Unfunded - used for calculations only
Grant
Worktag
Planned
Effort
FTE
Calculated
Monthly
Stipend
0.00% $
-
AUGUST
Actual
Monthly
Stipend
$
-
100.00%
Costing
Allocation Planned
Percentage Effort
0.00%
0.00%
FTE
Calculated
Monthly
Stipend
$
-
Actual
Monthly
Stipend
$
100.00%
* The data reflected in the green shaded fields above are entered in Workday when creating Summer Pay Compensation Plan
* The data reflected in the blue shaded columns above should be entered in Workday when completing Assign Costing Allocations Business
COMMENTS-Please provide any additional information supporting costing allocations below.
Because Worker's Monthly IBS Exceeds Sponsor Imposed Salary Cap-Please Complete Section C and then enter % Distributions to
Capped Award in Planned Effort %'s in Section B above.
Section C:
JUNE
-
Costing
Allocation Planned
Percentage Effort
0.00%
0.00%
100.00%
FTE
Calculated
Monthly
Stipend
$
-
Actual
Monthly
Stipend
$
-
Costing
Allocation
Percentage
0.00%
NOTE: If multiple salary cap rates apply you will need to complete separate template for the different salary caps.
Enter information in grey shaded fields to determine Planned Effort Percentages for Section B.
Sponsor's Monthly Salary Cap
$
15,275.00 Note-NIH FY 15 Monthly Salary Cap defaults in this field
SUMMER MONTHLY STIPEND 10 MONTH APPOINTMENT
Total
Monthly
$
Monthly
StipendDistributed % Distributed
%
Planned
Monthly
Summer
Planned
to Capped
Distribution
to Capped
Grant Worktag
Award
Effort
Salary Cap
Stipend
Effort
Award
$ Over Cap Over Cap
$ 15,275.00
$ 15,275.00
$ 15,275.00
SUMMER MONTHLY STIPEND 9 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Monthly
Salary Cap
Total
Monthly
Summer
Stipend
Monthly
StipendPlanned
Effort
$
Distributed
to Capped
Award
% Distributed
to Capped
Award
%
Distribution
$ Over Cap Over Cap
$ 15,275.00
$ 15,275.00
$ 15,275.00
Enter information in grey shaded fields to determine Planned Effort Percentages for Section B.
Sponsor's Monthly Salary Cap
$
SUMMER MONTHLY STIPEND 10 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Monthly
Salary Cap
$
$
$
-
Total
Monthly
Summer
Stipend
Monthly
StipendPlanned
Effort
$
Distributed % Distributed
%
to Capped
Distribution
to Capped
Award
Award
$ Over Cap Over Cap
Total
Monthly
Summer
Stipend
Monthly
StipendPlanned
Effort
$
Distributed
to Capped
Award
SUMMER MONTHLY STIPEND 9 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Monthly
Salary Cap
$
$
$
% Distributed
to Capped
Award
%
Distribution
$ Over Cap Over Cap
-
Enter information in grey shaded fields to determine Planned Effort Percentages for Section B.
Sponsor's Monthly Salary Cap
$
SUMMER MONTHLY STIPEND 10 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Monthly
Salary Cap
Total
Monthly
Summer
Stipend
Monthly
StipendPlanned
Effort
$
Distributed % Distributed
%
to Capped
Distribution
to Capped
Award
Award
$ Over Cap Over Cap
$
$
$
-
SUMMER MONTHLY STIPEND 9 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Monthly
Salary Cap
$
$
$
Total
Monthly
Summer
Stipend
Monthly
StipendPlanned
Effort
$
Distributed
to Capped
Award
% Distributed
to Capped
Award
%
Distribution
$ Over Cap Over Cap
-
Enter information in grey shaded fields to determine Planned Effort Percentages for Section B.
Sponsor's Monthly Salary Cap
$
SUMMER MONTHLY STIPEND 10 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Monthly
Salary Cap
$
$
$
-
Total
Monthly
Summer
Stipend
Monthly
StipendPlanned
Effort
$
Distributed % Distributed
%
to Capped
Distribution
to Capped
Award
Award
$ Over Cap Over Cap
Total
Monthly
Summer
Stipend
Monthly
StipendPlanned
Effort
$
Distributed
to Capped
Award
SUMMER MONTHLY STIPEND 9 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Monthly
Salary Cap
$
$
$
-
% Distributed
to Capped
Award
%
Distribution
$ Over Cap Over Cap
Summer Salary Assign Costing Allocation Worksheet
18-Jun-13
Section A:
Brown University-OVPR
Enter information in grey shaded fields (cells C7-C11) for calculating Institutional Base Salary (IBS)
IBS includes academic-year salary and any stipend you receive for performing other administrative duties, e.g. center director, department chair, or program director.
FTE Monthly IBS
Worker:
Academic Year Salary
Appointment Type
12
Approval: Office Of Sponsored Projects
Used for IBS calculation purposes only
Stipends For Other Job(s)
FTE
Enter full time equivalency factor (FTE); e.g. if full time enter 1, if 67 % time enter .67
Planned Effort on Other Job(s) -July
Note: In Workday Costing Allocation Percentage for all other jobs is always entered as 100%.
Planned Effort on Other Job(s) -August
SECTION B: Note if Worker's salary exceeds sponsor imposed salary cap you MUST complete Summer-Multiple Jobs+Over Cap Tab.
Enter Fund, Ledger Code, FRS Legacy Account, and Planned Effort for each award summer salary is assigned to.
JULY
Fund
Ledger
Account
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
Planned
Grant Worktag Effort
Funded Summer Effort-% and Dollars
FTE
Calculated
Monthly
Stipend
0.00% $
-
AUGUST
Actual
Monthly
Stipend
$
-
Costing
Allocation Planned
Percentage Effort
0.00%
0.00%
Planned Effort on Other Job(s)
0.00%
0.00%
Total Planned Effort on All Jobs - If greater than 100%
please provide explanation in comments field.
0.00%
0.00%
Unfunded on Primary Job - used for calculations only
100.00%
FTE
Calculated
Monthly
Stipend
$
-
JUNE
Actual
Monthly
Stipend
$
-
100.00%
* The data reflected in the green shaded fields above are entered in Workday when creating Summer Pay Compensation Plan
* The data reflected in the blue shaded columns above should be entered in Workday when completing Assign Costing Allocations Business Process
COMMENTS-Please provide any additional information supporting costing allocations below.
Costing
Allocation Planned
Percentage Effort
0.00%
0.00%
0.00%
100.00%
FTE
Calculated
Monthly
Stipend
$
-
Actual
Monthly
Stipend
$
-
Costing
Allocation
Percentage
0.00%
Summer Salary Assign Costing Allocation Worksheet
18-Jun-13
Section A:
Brown University-OVPR
Enter information in grey shaded fields (cells C7-C11) for calculating Institutional Base Salary (IBS)
IBS includes academic-year salary and any stipend you receive for performing other administrative duties, e.g. center director, department chair, or program director.
FTE Monthly IBS
Worker:
Academic Year Salary
Appointment Type
12
Approval: Office Of Sponsored Projects
Used for IBS calculation purposes only
Stipends For Other Job(s)
FTE
Enter full time equivalency factor (FTE); e.g. if full time enter 1, if 67 % time enter .67
Planned Effort on Other Job(s) -July
Note: In Workday Costing Allocation Percentage for all other jobs is always entered as 100%.
Planned Effort on Other Job(s) -August
SECTION B: Note if Worker's salary exceeds sponsor imposed salary cap you MUST complete Section C before this section.
Enter Fund, Ledger Code, FRS Legacy Account, and Planned Effort for each award summer salary is assigned to.
JULY
Fund
Ledger
Account
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
FD500 Sponsored Grants &
Contracts
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
50400 Faculty
Summer Salary
Planned
Grant Worktag Effort
Funded Summer Effort-% and Dollars
FTE
Calculated
Monthly
Stipend
0.00% $
-
AUGUST
Actual
Monthly
Stipend
$
-
Costing
Allocation Planned
Percentage Effort
0.00%
0.00%
Planned Effort on Other Job(s)
0.00%
0.00%
Total Planned Effort on All Jobs - If greater than 100%
please provide explanation in comments field.
0.00%
0.00%
Unfunded on Primary Job - used for calculations only
100.00%
FTE
Calculated
Monthly
Stipend
$
-
JUNE
Actual
Monthly
Stipend
$
-
100.00%
* The data reflected in the green shaded fields above are entered in Workday when creating Summer Pay Compensation Plan
* The data reflected in the blue shaded columns above should be entered in Workday when completing Assign Costing Allocations Business Process
COMMENTS-Please provide any additional information supporting costing allocations below.
Because Worker's Monthly IBS Exceeds Sponsor Imposed Salary Cap-Please Complete Section C and then enter % Distributions to
Costing
Allocation Planned
Percentage Effort
0.00%
0.00%
0.00%
100.00%
FTE
Calculated
Monthly
Stipend
$
-
Actual
Monthly
Stipend
$
-
Costing
Allocation
Percentage
0.00%
Capped Award in Planned Effort %'s in Section B above.
Section C:
NOTE: If multiple salary cap rates apply you will need to complete separate template for the different salary caps.
Enter information in grey shaded fields to determine Planned Effort Percentages for Section B.
Sponsor's Monthly Salary Cap
$
15,275.00 Note-NIH FY 15 Monthly Salary Cap defaults in this field
SUMMER MONTHLY STIPEND 10 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Total
Monthly
Monthly Salary Summer
Cap
Stipend
$ 15,275.00
$ 15,275.00
$ 15,275.00
Monthly
StipendPlanned
Effort
$
Distributed % Distributed
to Capped
to Capped
Award
Award
Monthly
StipendPlanned
Effort
$
Distributed
to Capped
Award
$ Over
Cap
%
Distribution
Over Cap
$ Over
Cap
%
Distribution
Over Cap
$ Over
Cap
%
Distribution
Over Cap
$ Over
Cap
%
Distribution
Over Cap
SUMMER MONTHLY STIPEND 9 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Total
Monthly
Monthly Salary Summer
Cap
Stipend
$
$
$
% Distributed to
Capped Award
15,275.00
15,275.00
15,275.00
Enter information in grey shaded fields to determine Planned Effort Percentages for Section B.
Sponsor's Monthly Salary Cap
$
SUMMER MONTHLY STIPEND 10 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Total
Monthly
Monthly Salary Summer
Cap
Stipend
$
$
$
-
Monthly
StipendPlanned
Effort
$
Distributed % Distributed
to Capped
to Capped
Award
Award
Monthly
StipendPlanned
Effort
$
Distributed
to Capped
Award
SUMMER MONTHLY STIPEND 9 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Total
Monthly
Monthly Salary Summer
Cap
Stipend
$
$
$
-
Enter information in grey shaded fields to determine Planned Effort Percentages for Section B.
Sponsor's Monthly Salary Cap
$
SUMMER MONTHLY STIPEND 10 MONTH APPOINTMENT
% Distributed to
Capped Award
Grant Worktag
Planned
Effort
Total
Monthly
Monthly Salary Summer
Cap
Stipend
$
$
$
-
Monthly
StipendPlanned
Effort
$
Distributed % Distributed
to Capped
to Capped
Award
Award
Monthly
StipendPlanned
Effort
$
Distributed
to Capped
Award
$ Over
Cap
%
Distribution
Over Cap
$ Over
Cap
%
Distribution
Over Cap
$ Over
Cap
%
Distribution
Over Cap
$ Over
Cap
%
Distribution
Over Cap
SUMMER MONTHLY STIPEND 9 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Total
Monthly
Monthly Salary Summer
Cap
Stipend
$
$
$
% Distributed to
Capped Award
-
Enter information in grey shaded fields to determine Planned Effort Percentages for Section B.
Sponsor's Monthly Salary Cap
$
SUMMER MONTHLY STIPEND 10 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Total
Monthly
Monthly Salary Summer
Cap
Stipend
$
$
$
-
Monthly
StipendPlanned
Effort
$
Distributed % Distributed
to Capped
to Capped
Award
Award
Monthly
StipendPlanned
Effort
$
Distributed
to Capped
Award
SUMMER MONTHLY STIPEND 9 MONTH APPOINTMENT
Grant Worktag
Planned
Effort
Total
Monthly
Monthly Salary Summer
Cap
Stipend
$
$
$
-
% Distributed to
Capped Award
18-Jun-13
Summer Salary Assign Costing Allocation Worksheet Instructions:
Section A : Purpose: Calculate Monthly Institutional Base Salary (IBS)
In cell C6, enter faculty members's name (In workday a Brown employee is referred to as a Worker).
In cell C7, enter faculty member's (Worker's) Academic Year Salary.
In cell C8, select the appointment type (period) from the drop down box. Note: only faculty with a 9 or 10 month appointment are
In cell C9, if faculty member holds multiple positions, enter faculty stipend amount for ALL other positions. If no other positions ar
In cell C10, enter full time equivalency factor (FTE); e.g. if full time enter 1, if 67 % time enter .67
Cell G6 represents the full time equivalent (FTE) Monthly Institutional Base Salary.
Section B: Purpose: To derive information needed to set up Summer Pay Compensation Plan and Assign Costing in Wo
In cell(s) A15-A21, select the Fund (Source of funding; e.g. sponsored, general operating) from the drop down box . Default is FD50
when assigning costing in Workday.
Cells B15-B21 represent the ledger account for faculty summer salary. This is a predefined value and is entered when assigning cos
In cell(s) C15-C21 enter the grant worktag: e.g. GR523456. This is entered when assigning costing in Workday.
In cell(s) D15-D21 (July)/H15-H21 (August), enter the faculty's (Worker's) % planned effort for the grant worktag.
In cells E15-E21 (July)/I15-I21 (August), the Full Time Equivalent (FTE) Monthly Stipend will automatically populate. No entry requir
In cells F15-F21( July)/J15-J21 (August), the actual monthly summer stipend allocated to each account will automatically populate.
In cells G15-G21 (July)/K15-K21 (August), the Workday Costing Allocation Percentage will automatically populate. This amount is e
Cell D23 (July)/H23 (August) represents the total percentage time of planned effort for the month noted; calculated amount. No en
Cells E23 (July)/I23 (August) represent the full time equivalent summer monthly stipend for month indicated-this amount is entere
Cap Summary Salary Worksheet
Note if Faculty's (Worker's) salary exceeds sponsor imposed salary cap you MUST use THIS WORKSHEET
Section A : Purpose: Calculate Monthly Institutional Base Salary (IBS)
Complete this section as described above
Section B: Purpose: To derive information needed to set up Summer Pay Compensation Plan and Assign Costing in Wo
Complete section C before this section and and then enter % Distributions to Capped Award from section C in Planned Effort %'s
Section C: To derived % Distribution to Capped Award
Note: If you are working with multiple salary caps (more than four different amounts) you will need to complete separate temp
Cell C44 - Worksheet defaults to NIH FY15 Monthly Summer Salary Cap.
Cell(s) C60, C76 & C92- enter sponsor imposed monthly salary cap (if amount is different from amount reflected in C44).
Cell(s) G45, G53, G61, G69, G77, G85, G93 or G101 - the monthly salary stipend defaults to predetermined amount based on inform
Cell(s)A48-A50, A64-A66, A80-A82,A96-A98 (10 month appointment) or A56-A58, A72-A74, A88-A90, A104-A106 (9 month appoint
Cell(s)B48-B50, B64-B66, B80-B82,B96-B98 (10 month appointment) or B56-B58, B72-B74, B88-B90, B104-B106 (9 month appointm
Cell(s)D48-D50, D64-D66, D80-D82,D96-D98 (10 month appointment) or D56-D58, D72-D74, D88-D90, D104-D106 (9 month appoi
from information entered in Section A. No entry required.
Cell(s)E48-E50, E64-E66, E80-E82,E96-E98 (10 month appointment) or E56-E58, E72-E74, E88-E90, E104-E106 (9 month appointme
derived from information entered in Section A. No entry required.
Cell(s)F48-F50, F64-F66, F80-F82,F96-F98 (10 month appointment) or F56-F58, F72-F74, F88-F90, F104-F106 (9 month appointmen
Cell(s)G48-G50, G64-G66, G80-G82,G96-G98 (10 month appointment) or G56-G58, G72-G74, G88-G90, G104-G106(9 month appoin
The information in cells G48-G50, G64-G66, G80-G82,G96-G98 or G56-G58, G72-G74, G88-G90, G104-G106 are entere
Cell(s)H48-H50, H64-H66, H80-H82,H96-H98 (10 month appointment) or H56-H58, H72-H74, H88-H90, H104-H106 (9 month appo
Cell(s)I37-I39 (10 month appointment) or I45-I47 (9 month appointment) represents % distribution over the cap; derived from info
The information in cells I48-I50, I64-I66, I80-I82,I96-I98 or I56-I58, I72-I74, I88-I90, I104-I106 are entered in Section B Pla
1/--страниц
Пожаловаться на содержимое документа