Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
214x Filetype XLSX File size 0.41 MB Source: sc.edu
Sheet 1: Effort Converter
| Percent of Time & Effort to Person Months (PM) | ||||||||||||||||
| Interactive Conversion Table | ||||||||||||||||
| 3 month | 9 month | 10 month | 10.5 month | 11 month | 12 month | |||||||||||
| Summer Term | Appointment | Appointment | Academic Year | Appointment | Calendar Year | |||||||||||
| % effort | PM | % effort | PM | % effort | PM | % effort | PM | % effort | PM | % effort | PM | |||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | ||||||
| Instructions: | ||||||||||||||||
| To use the chart simply insert the percent effort that you want to convert into the -0- of the 3 mo. Summer Term % effort line and | ||||||||||||||||
| hit enter. The person month for 3, 6, 8, 9, 10, and 12 will be displayed simultaneously. | ||||||||||||||||
| There are three basic salary (wage) bases: Calendar Year, Academic Year and Summer Term. Here is a month/week/days | ||||||||||||||||
| breakout for each: | ||||||||||||||||
| Academic Year (AY) | 9 months | 39 weeks | 273 days | |||||||||||||
| Summer Term (SM) | 3 months | 13 weeks | 90 days | |||||||||||||
| Calendar Year (CY) | 12 months | 52 weeks | 365 days | |||||||||||||
| To fill out the budget forms for the SF 424 R&R grantees will need to convert percent-of-effort to person months. Below are | ||||||||||||||||
| a two examples of how person months are applied: | ||||||||||||||||
| Example 1: | A PI on an AY appointment at a salary of $63,000 will have a monthly salary of $7,000 (one-ninth of the AY). | |||||||||||||||
| 25% of AY effort would equate to 2.25 person months (9x.25=2.25). The Budget figure for that effort would be | ||||||||||||||||
| $15,750 (7,000 multiplied by 2.25 AY months). | ||||||||||||||||
| Example 2: | A PI on a CY appointment at a salary of $72,000 will have a monthly salary of $6,000 (one-twelfth of total CY | |||||||||||||||
| salary). 25% of CY effort would equate to 3 CY months (12x.25=3). The budget figure for that effort would | ||||||||||||||||
| be$18,000 (6,000 multiplied by 3 CY months). | ||||||||||||||||
| Modules | |||||||||||
| Item | Rate/Cost | Detail | Instructions: | $25,000 | |||||||
| ENTER INFORMATION | $50,000 | ||||||||||
| Faculty/Staff Fringe | 31.99% | Effective | $75,000 | ||||||||
| Grad Student Fringe | 0.50% | 7/1/2022-12/31/2023 | Do NOT Enter Information | $100,000 | |||||||
| Temporary Fringe | 8.23% | The green spaces have formulas in them. Do not type in these spaces. | $125,000 | ||||||||
| Ugrad Fringe N/Enroll | 8.18% | $150,000 | |||||||||
| Ugrad Fringe Enroll | 0.50% | Single | With Child | With Spouse | Effective | $175,000 | |||||
| Full Family Insurance | $1,381 | Monthly / 9 month appt | $559.63 | $856.67 | $1,094.77 | 7/1/2022-12/31/2023 | $200,000 | ||||
| Full Family Insurance | $1,036 | Monthly / 12 month appt | $419.72 | $642.50 | $821.08 | $225,000 | |||||
| Per Semester | Per Year Academic | Summer | $250,000 | ||||||||
| Tuition Yr 1 | $4,500 | $9,000 | $569 | ANNUAL TUITION INCREASE | |||||||
| Tuition Yr 2 | $4,635 | $9,270 | $586 | 1 HOUR CREDIT | 568.75 | 3% | |||||
| Tuition Yr 3 | $4,774 | $9,548 | $603 | Number of Hours | 1 | ||||||
| Tuition Yr 4 | $4,917 | $9,835 | $621 | ||||||||
| Tuition Yr 5 | $5,065 | $10,130 | $640 | ||||||||
| Undergraduate hourly | $7.50 | ||||||||||
| Hours per week | 20 | ||||||||||
| IDC Yr 1 | 49.0% | Current IDC Rates | |||||||||
| IDC Yr 2 | 49.0% | ON CAMPUS | Research | 49.0% | Columbia Campus | ||||||
| IDC Yr 3 | 49.0% | 49.0% | School of Medicine | ||||||||
| IDC Yr 4 | 49.0% | 38.0% | Senior & Regional Campuses | ||||||||
| IDC Yr 5 | 49.0% | OFF CAMPUS | 26.0% | Entire USC System | |||||||
| SUM PAGE | 49.0% | ||||||||||
| ON CAMPUS | Other Sponsored | 36.0% | Entire USC System | ||||||||
| Activities | |||||||||||
| OFF CAMPUS | 26.0% | Entire USC System | |||||||||
| ON CAMPUS | Instruction | 49.5% | Entire USC System | ||||||||
| OFF CAMPUS | 26.0% | Entire USC System | |||||||||
| Please make sure that the fringe rates and the health insurance rates are up to date on the RATES tab. | Instructions: | ||||||||||||||||||||||||
| NOTES: | |||||||||||||||||||||||||
| BUDGET PAGE | Enter information in the yellow cells only | 1. Choose the appointment in column R from the drop down menu. Appointments 9-11 months use ACAD / SUMR person-months. Appointments 11.5-12 months use CAL person-months. | |||||||||||||||||||||||
| Green cells are locked with formulas | 2. Only enter information in YELLOW cells. The GREEN spaces are locked with formulas and will cause the spreadsheet to not work properly if overwritten. | ||||||||||||||||||||||||
| Orange cells are locked from Cost Share tab | 3. Fill in the subcontract worktables on the right to get the subcontract into the budget. USC uses the first $25000 of EACH subcontract over the course of the proposed period in our calculation for IDC. | ||||||||||||||||||||||||
| YEAR 1 | Pink cells are locked with formulas for subcontracts | 4. If you do not need all 5 years, either leave the other years blank or "hide" the tabs. Do not delete the other years as it will cause the summary page to malfunction. | |||||||||||||||||||||||
| ORGANIZATION | Project Period (months) | This cell contains DIRECT COST ONLY (including subcontracts) | 5. To change IDC, Tuition, or Undergraduate Hourly rates, go to the RATES tab. | ||||||||||||||||||||||
| UNIVERSITY OF SOUTH CAROLINA | MODULAR BUDGET CALCULATIONS | 6. The latest version of this spreadsheet, as well as other helpful grant information, can be found on the SAM website. | |||||||||||||||||||||||
| Requested Duration: | https://sc.edu/about/offices_and_divisions/sponsored_awards_management/index.php | ||||||||||||||||||||||||
| PRINCIPAL INVESTIGATOR/PROJECT DIRECTOR | From: | ||||||||||||||||||||||||
|
|
To: | YEAR 1 TOTAL DIRECT COST | $0 | ||||||||||||||||||||||
| A. SENIOR PERSONNEL: PI/PD, Co-PI's, Faculty and Other Senior Associates | Agency Funded | ||||||||||||||||||||||||
| Person-mos. | Funds Requested | COST SHARE | FEDERAL | ANNUAL | Dropdown Menu | ||||||||||||||||||||
| USC PERSONNEL ONLY | CAL | ACAD | SUMR | Monthly | SALARY | APPOINTMENT | |||||||||||||||||||
| 1 | 0 | $0 | $0 | PI | 0 | 0.00 | 9 | Appointments 9-11 months use ACAD / SUMR person-months | |||||||||||||||||
| 2 | $0 | $0 | coPI | 0 | 0.00 | 9 | Appointments 11.5-12 months use CAL person-months | ||||||||||||||||||
| 3 | $0 | $0 | coPI | 0 | 0.00 | 9 | |||||||||||||||||||
| 4 | $0 | $0 | coPI | 0 | 0.00 | 9 | |||||||||||||||||||
| 5 | $0 | $0 | coPI | 0 | 0.00 | 9 | |||||||||||||||||||
| 6 | $0 | $0 | coPI | 0 | 0.00 | 9 | |||||||||||||||||||
| 7 | $0 | $0 | coPI | 0 | 0.00 | 9 | |||||||||||||||||||
| 8 | $0 | $0 | coPI | 0 | 0.00 | 9 | |||||||||||||||||||
| 9 | $0 | $0 | coPI | 0 | 0.00 | 9 | |||||||||||||||||||
| 10 | $0 | $0 | coPI | 0 | 0.00 | 9 | |||||||||||||||||||
| Postdoc | $0 | $0 | Postdoc | 0.00 | |||||||||||||||||||||
| Postdoc | $0 | $0 | Postdoc | 0.00 | |||||||||||||||||||||
| Postdoc | $0 | $0 | Postdoc | 0.00 | |||||||||||||||||||||
| Postdoc | $0 | $0 | Postdoc | 0.00 | |||||||||||||||||||||
| TOTAL SENIOR PERSONNEL | 0 | 0 | 0 | $0 | $0 | Other Professional | 0.00 | ||||||||||||||||||
| Other Professional | 0.00 | ||||||||||||||||||||||||
| B. | OTHER PERSONNEL (Show Quantity in Column B) | Graduate Students | 0.00 | ||||||||||||||||||||||
| 1 | OTHER PROFESSIONAL | $0 | $0 | Secretary /Clerical | 0.00 | ||||||||||||||||||||
| 2 | OTHER PROFESSIONAL | $0 | $0 | ||||||||||||||||||||||
| 3 | GRADUATE STUDENTS | $0 | @ month | $0 | $0 | ||||||||||||||||||||
| 4 | UNDERGRADUATE STUDENTS |
|
weeks | $0 | $0 | Fringe: | |||||||||||||||||||
| UNDERGRAD STUDENTS - SUMMER / NOT ENROLLED(May 16-Aug 16) | weeks | $0 | $0 | PI | 0 | $0 | |||||||||||||||||||
| 5 | SECRETARIAL - CLERICAL | months | $0 | $0 | coPI | 0 | $0 | ||||||||||||||||||
| TOTAL SALARIES AND WAGES (A+B) | $0 | $0 | coPI | 0 | $0 | ||||||||||||||||||||
| C. | FRINGE BENEFITS | $0 | $0 | coPI | 0 | $0 | |||||||||||||||||||
| TOTAL SALARIES, WAGES AND FRINGE BENEFITS (A+B+C) | $0 | $0 | coPI | 0 | $0 | ||||||||||||||||||||
| D. | PERMANENT EQUIPMENT (LIST ITEM AND DOLLAR AMOUNT FOR EACH ITEM.) | coPI | 0 | $0 | |||||||||||||||||||||
| Description | amount | coPI | 0 | $0 | |||||||||||||||||||||
| ENTER | coPI | 0 | $0 | ||||||||||||||||||||||
| coPI | 0 | $0 | |||||||||||||||||||||||
| coPI | 0 | $0 | |||||||||||||||||||||||
| Postdoc | $0 | ||||||||||||||||||||||||
| TOTAL PERMANENT EQUIPMENT | $0 | $0 | Postdoc | $0 | |||||||||||||||||||||
| E. | TRAVEL | 1. DOMESTIC (INCL. CANADA AND U.S. POSSESSIONS) | $0 | Postdoc | $0 | ||||||||||||||||||||
| 2. FOREIGN | $0 | Postdoc | $0 | ||||||||||||||||||||||
| Other Professional | $0 | ||||||||||||||||||||||||
| TOTAL TRAVEL | $0 | $0 | Other Professional | $0 | |||||||||||||||||||||
| F. | TRAINEE/PARTICIPANT COSTS |
|
Graduate Students | $0 | |||||||||||||||||||||
| 1 | STIPENDS (Itemize levels, types + totals on budget justification page) | $0 | Undergraduate Students | $0 | |||||||||||||||||||||
| 2 | TUITION & FEES | $0 | Undergraduate Students Not Enrolled | $0 | |||||||||||||||||||||
| 3 | TRAINEE TRAVEL | $0 | Secretary /Clerical | $0 | |||||||||||||||||||||
| 4 | OTHER (fully explain on justification page) | $0 | Total Fringe: | $0 | |||||||||||||||||||||
| TOTAL PARTICIPANTS | TOTAL COST | $0 | $0 | ||||||||||||||||||||||
| G. | OTHER DIRECT COSTS | ||||||||||||||||||||||||
| 1 | MATERIALS AND SUPPLIES (Chemicals, gases) | $0 | |||||||||||||||||||||||
| 2 | PUBLICATION COSTS/DOCUMENTATION/DISSEMINATION | $0 | O | P | Q | R | S | T | U | ||||||||||||||||
| 3 | CONSULTANT SERVICES | $0 | Sub #1 | Sub #2 | Sub #3 | Sub #4 | Sub #5 | Totals | |||||||||||||||||
| 4 | CONTRACTUAL SERVICES/COMPUTER SERVICES | $0 | 62 | SUBCONTRACT WORK TABLES | $0 | ||||||||||||||||||||
| 5 | SUBCONTRACTS | First $25,000 per subcontract | $0 | $0 | 63 | DIRECT COST |
|
$0 | |||||||||||||||||
| OVER $25,000 | Over $25,000 per subcontract | $0 | $0 | 64 | INDIRECT COST |
|
$0 | ||||||||||||||||||
| TOTAL SUBCONTRACTS | $0 | $0 | 65 | TOTAL | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
| 6 | OTHER | $0 | 66 | Total for all subs | |||||||||||||||||||||
| 7 | GRADUATE STUDENT TUITION | Tuition | $0 | $0 | 67 |
|
$0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||
| TOTAL OTHER DIRECT COSTS | $0 | $0 | 68 | Remaining | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
| H. | TOTAL DIRECT COSTS (A THROUGH G) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||
| I. | INDIRECT COSTS (SPECIFY RATE AND BASE) | ||||||||||||||||||||||||
| 49.0% | $0 | $0 | $0 | ||||||||||||||||||||||
| TOTAL INDIRECT COSTS | $0 | $0 | |||||||||||||||||||||||
| J. | TOTAL DIRECT AND INDIRECT COSTS (H+I) | $0 | $0 | ||||||||||||||||||||||
| K. | AMOUNT OF ANY REQUIRED COST SHARING FROM NON-FEDERAL SOURCES | $0 | $0 |
|
|||||||||||||||||||||
| L. | TOTAL COST OF PROJECT (J+K) | $0 | Modular module |
|
|||||||||||||||||||||
| Subcontract IDC | $0 | ||||||||||||||||||||||||
| Total Direct Costs | $0 | ||||||||||||||||||||||||
| YEAR 1 TOTAL DIRECT COST | $0 | MTDC Indirect Base (F&A) | $0 | ||||||||||||||||||||||
| (SUBTRACTING SUB IDC) | USC IDC | $0 | |||||||||||||||||||||||
| Total Cost of Project | $0 | ||||||||||||||||||||||||
