Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Formulas

Rw ui expands macro
Rw expand
titleEligibility for Fee Remission

When students leave their appointments early, we may need to determine if they have worked enough days to be eligible for a fee remission. We use a dollar amount at the 25% rate as a benchmark to determine eligibility. Contact the Grad Employment team at grademployment@ucsd.edu if you have questions about this spreadsheet or this process.


View file
nameGSR fee remission eligibility.xlsx

Rw expand
titleFixed Dollar Amount for Split-Funded GSRTF

Sometimes a fund source has only enough money to pay a certain amount during a particular month or quarter.  You can use the following formula for these situations.

  1. Determine the total sum of monthly GSR salary and GSR assessment

  2. Divide the fund source A amount by #1 answer

  3. Multiply #2 answer x % employed = % to employ on fund source A

        Example:                   Fund source A can only pay $500.00.

                                         Student is paid 48% at $2795/mo; Remission = $840

                                         a.  $1341.60 + $840 = $2181.60

                                         b.  $500 divided by $2181.60 = 22.9189

                                         c.  22.9189 x 48% = 11.00%

         Answer:               Fund source A = 11% ($307.45 salary + $192.50 remission = Total $499.95)

                                    Fund source B = 37%

Rw expand
titleGSR Partial Month Payment Formula

You can use the following Partial Month Factor Chart to calculate how much a GSR will be paid when employed for only part of a month.

To determine the number of days in a month, count all Mondays – Fridays; including holidays.

For all calculations; figure to 6 decimals and round to 4 decimals.

The payroll formula is:

  1. (Partial Month Factor) x (Percent Time Employed) = Y

  2. (Y) x (Monthly Pay rate) = Amount paid

        Example:

        Student worked 7 days out of 22 day month; 49.31% at $2966/month

  1. (.3182) x (.4931) = .1569

  2. (.1569) x ($2966) = $465.37

Chart of Partial Month Factors

Days Worked

Days per Month

20

21

22

23

1

0.0500

0.0476

0.0455

0.0435

2

0.1000

0.0952

0.0909

0.0870

3

0.1500

0.1429

0.1364

0.1304

4

0.2000

0.1905

0.1818

0.1739

5

0.2500

0.2381

0.2273

0.2174

6

0.3000

0.2857

0.2727

0.2609

7

0.3500

0.3333

0.3182

0.3043

8

0.4000

0.3810

0.3636

0.3478

9

0.4500

0.4286

0.4091

0.3913

10

0.5000

0.4762

0.4545

0.4348

11

0.5500

0.5238

0.5000

0.4783

12

0.6000

0.5714

0.5455

0.5217

13

0.6500

0.6190

0.5909

0.5652

14

0.7000

0.6667

0.6364

0.6087

15

0.7500

0.7143

0.6818

0.6522

16

0.8000

0.7619

0.7273

0.6957

17

0.8500

0.8095

0.7727

0.7391

18

0.9000

0.8571

0.8182

0.7826

19

0.9500

0.9048

0.8636

0.8261

20

1.0000

0.9524

0.9091

0.8696

21

n/a

1.0000

0.9545

0.9130

22

n/a

n/a

1.0000

0.9565

Rw expand
titleProrated Monthly Assessment

The GSRTF monthly assessment is prorated when a GSR's total pay for a month is less than 25% time.

                (a)          Amount paid during a month     =    % of total month worked

                                    100% Monthly Rate   

                (b)          (% of total month worked) x 4 x (GSRTF Mo. Assessment)    =    Prorated Mo. Assessment

Another way to calculate this is as follows:

                (a)          (Partial Month Factor) x (% Employed)    =    % of total month worked

                (b)          (% of total mo. worked) x 4 x (GSRTF Monthly Assessment)    =    Prorated Monthly Assessment

Rw expand
titleSplit-Funded GSRTF

The GSRTF monthly assessment is prorated when an eligible GSR is paid from more than one fund source during the same month.  If the GSR is split funded, the system will calculate the monthly assessment for each fund source as follows:

  1.                 100%                        =   Factor (to 4 decimal places)

Total % Worked

  1. Factor x (% worked on one fund source) x (GSRTF Mo. Assessment) = Split funded Mo. Assessment

Rw expand
titleSplit-Funding a GSR and TA Appointment

Effective Fall 2021: "Graduate students remain eligible for tuition and fee payments and other benefits according to the criteria of their appointment(s). The cost of the tuition and fee payments and other benefits will be charged proportionally across the funding sources of the student’s support." 

Learn more about the Graduate Funding Reform here.