Responses
Buck1985
Michaelexcelsheet.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 - Academic | 15.00% | 1.35 | 80,000 | 12,000 | |
| Faculty 1 - Summer * | 100.00% | 3.00 | 80,000 | 26,667 | |
| Faculty 2 - Academic | 0.00% | - 0 | - 0 | ||
| Faculty 2 - Summer * | 100.00% | 3.00 | 80,000 | 26,667 | |
| Faculty 3 - 12 month appointment | 0.00% | - 0 | - 0 | ||
| Staff (including postdocs) | 0.00% | - 0 | - 0 | ||
| Staff | 100.00% | 12.00 | 46,500 | 46,500 | |
| Temporary Staff/Part time Faculty | 25.00% | 3.00 | 46,500 | 11,625 | |
| GRA | 0.00% | - 0 | - 0 | ||
| GRA | 0.00% | - 0 | - 0 | ||
| Student Assistants | 25.00% | 3.00 | 25,000 | 6,250 | |
| Total Base Personnel Cost | 129,709 | ||||
| Benefit and Tax Rate | 34% | 41,358.77 | |||
| Total Net Personnel Cost | 171,068 | ||||
| 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) | - 0 | ||||
| Travel | 940 | (2 vans rented for 2 weeks at $235/week) | |||
| Participant Support Costs | |||||
| Other Direct Costs: | |||||
| Materials and Supplies | 1,625 | ($65 per student @ 25 students) | |||
| Marketing Costs | 188 | (250 postcards @ $.75 each) | |||
| Dining Services | 7,560 | (25 students and 5 personnel @ $18 per day/14 days) | |||
| Subaward (total) | |||||
| Alterations/Renovations/Rental Use | |||||
| Other: Human Subject Support (expenses related to payment for research subjects) | |||||
| Other | |||||
| Subtotal, Other Direct Costs | 9,373 | ||||
| Total Direct Costs | 10,313 | ||||
| Grand Total | 181,380 |
&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 - Academic | 0 | months @ | 0.11 | - | ||
| 0 | months @ | 0.12 | - | |||
| - | ||||||
| Faculty 1 - Summer * | 0 | months @ | 0.25 | - | ||
| 0 | months @ | 0.26 | - | |||
| - | ||||||
| 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 @ | 0.25 | - | ||
| 0 | months @ | 0.26 | - | |||
| - | ||||||
| 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 |
