Formulas
Rw ui expands macro | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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.
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.
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%
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:
Example: Student worked 7 days out of 22 day month; 49.31% at $2966/month
Chart of Partial Month Factors
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
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:
Total % Worked
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. |