Responses
Buck1985
Jamiebudget.xlsParticipant Support Costs
| The table can be completed either by completing # and cost or by inserting totals into years. These are linked to overall budget page. | ||||||||
| No. of budget periods | 5 | Please set to correct number of budget periods | ||||||
| Inflation Costs ============> | 0% | 3% | . | |||||
| Participant/Trainee Support Costs | # of Participants | Cost per Participant | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total |
| 1. Tuitiion/Fees/Health Insurance | - 0 | - 0 | - 0 | 0 | 0 | 0 | 0 | - 0 |
| 2, Stipend | - 0 | - 0 | - 0 | 0 | 0 | 0 | 0 | - 0 |
| 3. Travel | - 0 | - 0 | - 0 | 0 | 0 | 0 | 0 | - 0 |
| 4. Subsistence | - 0 | - 0 | - 0 | 0 | 0 | 0 | 0 | - 0 |
| 5 Other | - 0 | - 0 | - 0 | 0 | 0 | 0 | 0 | - 0 |
| Total | - 0 | - 0 | - 0 | 0 | 0 | 0 | 0 | - 0 |
| Inflation costs apply to year 2 through 5. Change D3 to 0 if don't need inflation increase | ||||||||
| If participants change by year use this to calculate totals for above. | ||||||||
| Participant Support Cost Calculator | #of Participants | Cost | Total | |||||
| 1. Tuition/Fees/Health Insurance | - 0 | - 0 | - 0 | |||||
| 2, Stipend | - 0 | - 0 | - 0 | |||||
| 3. Travel | - 0 | - 0 | - 0 | |||||
| 4. Subsistence | - 0 | - 0 | - 0 | |||||
| 5 Other | - 0 | - 0 | - 0 | |||||
| Total | - 0 | - 0 | - 0 |
Main Budget Sheet
| Personnel: | % | Person | Base | Salary | ||
| Name | Effort | months | Salary | Requested | ||
| Faculty 1 Counselor- Academic | 30.00% | 2.70 | 75,000 | 22,500 | ||
| Faculty 1 Counslor - Summer * | 30.00% | 0.90 | 75,000 | 7,500 | ||
| Faculty 2 -Counselor Academic | 40.00% | 3.60 | 80,000 | 32,000 | ||
| Faculty 2 - Counselor Summer * | 40.00% | 1.20 | 80,000 | 10,667 | ||
| Faculty 3 - 12 month appointment | 75.00% | 9.00 | 80,000 | 60,000 | ||
| Staff (including postdocs) | 100.00% | 12.00 | 40,000 | 40,000 | ||
| Staff | 100.00% | 12.00 | 30,000 | 30,000 | ||
| Temporary Staff/Part time Faculty | 100.00% | 12.00 | 15,000 | 15,000 | ||
| GRA | 0.00% | - 0 | - 0 | |||
| GRA | 0.00% | - 0 | - 0 | |||
| Student Assistants | 100.00% | 12.00 | 9,360 | 9,360 | ||
| Total Personnel | 227,027 | |||||
| Base salary is institutional base contract salary (e.g., 9 month salary for academic faculty). GRAs cannot work more than 50% effort. Base Salary for a GRA therefore should be double what students receive as their GRA salary | ||||||
| * Summer Faculty is expressed as a % of effort in the summer which can range from 1 to 100% of the 3 months. This is not to be confused with % of academic year salary (the way salary is calculated). | ||||||
| Non-Personnel Direct Costs: | ||||||
| Equipment (items over $4999) | ||||||
| Travel | ||||||
| Participant Support Costs | ||||||
| Other Direct Costs: | ||||||
| Materials and Supplies | 5,850 | 4 computers @900 each and 5 headsets for $50 each 1500 for projector screen + $500 for misc | ||||
| Publication Costs | ||||||
| Consultant Services | 250 | Webinar training via zoom for all employees | ||||
| Marketing materials | 9,000 | 25,000 postcards at .36 mailing | ||||
| Alterations/Renovations/Rental Use | ||||||
| Other: Human Subject Support (expenses related to payment for research subjects) | ||||||
| Other | ||||||
| Subtotal, Other Direct Costs | 15,100 | |||||
| Total Direct Costs | 15,100 | |||||
| Grand Total | 242,127 |
&L&K000000&G
&COffice of the Associate V.P. for Research
Last revised October 11, 2012
Sheet1
| Personnel | Fringe Plan TRS/ORP | Effort person months | Annual Salary | Salary | Fringe amount | |||
| Faculty 1 | ||||||||
| Academic | TRS | 0 | 0 | |||||
| Summer | TRS | |||||||
| Faculty 2 | ||||||||
| Academic | ORP | |||||||
| Summer | ORP | |||||||
| Staff 1 | ||||||||
| Staff 2 | ||||||||
| Staff 3 | ||||||||
| GRA | ||||||||
| Student Assistants | ||||||||
| Subtotal Personnel | 0 | 0 | ||||||
| Fringe Benefits for all personnel | 0 | |||||||
| Subtotal Personnel and Benefits | 0 | 0 |
Salary Work
| Salary Inflation | ||||||
| Faculty 1 Counselor- Academic | 0 | months @ | 0.22 | - | ||
| 0 | months @ | 0.23 | - | |||
| - | ||||||
| Faculty 1 Counslor - Summer * | 0 | months @ | 0.08 | - | ||
| 0 | months @ | 0.08 | - | |||
| - | ||||||
| Staff | 0 | months @ | 1.00 | - | ||
| 0 | months @ | 1.03 | - | |||
| - | ||||||
| GRA | 0 | months @ | - 0 | - | ||
| 0 | months @ | - 0 | - | |||
| - | ||||||
| GRA | 0 | months @ | - 0 | - | ||
| 0 | months @ | - 0 | - | |||
| - | ||||||
| Student Assistants | 0 | months @ | 1.00 | - | ||
| 0 | months @ | 1.03 | - | |||
| - | ||||||
| 0 | 0 | months @ | - 0 | - | ||
| 0 | months @ | - 0 | - | |||
| - | ||||||
| 0 | 0 | months @ | - 0 | - | ||
| 0 | months @ | - 0 | - | |||
| - | ||||||
| 9 | - | months @ | - 0 | - | ||
| 0 | months @ | - 0 | - | |||
| - | ||||||
| 0 | 0 | months @ | - 0 | - | ||
| 0 | months @ | - 0 | - | |||
| - | ||||||
| Personnel | ||||||
| Faculty | ||||||
| Academic | ||||||
| Summer | ||||||
| Staff | ||||||
| Graduate Students | ||||||
| Student Assistants | ||||||
| Subtotal Personnel | 0 | 0 | ||||
| Fringe Benefits for all personnel | ||||||
| Subtotal Personnel and Benefits | 0 | 0 |
