| THE UNIVERSITY OF ARIZONA |
Sample Budget in Excel Format |
| Year 1 Budget--Dr. John Doe, PI |
|
|
|
| Project Title: "Chemical Analyses--Sands of the Southwest" |
|
|
|
| Performance Period: October 1, 2005 - September 30, 2006 |
|
|
|
| |
Sponsor |
UA |
|
| |
Share |
Share |
TOTAL |
| Direct Labor |
|
|
|
| Prof. John Doe, 7% academic year |
|
$7,350 |
$7,350 |
| " 100%, 3 Summer Months |
$35,000 |
|
35,000 |
| Mr. Wm. Smith, GRA, 50%, AcademicYr. |
10,000 |
|
10,000 |
| Ms. Jane Jones, GRA, 50%, Academic Yr. |
10,000 |
|
10,000 |
| Mr. G. Scott, Tech, 200 hrs. @ $18.00 |
3,600 |
|
3,600 |
| Hourly Undergrad. Students, 400 hrs. @ $6.50 |
2,600 |
|
2,600 |
| Subtotal-Direct Labor |
61,200 |
7,350 |
68,550 |
| Fringe Benefits(FY05 rates) Click here for current rates |
|
|
|
| Faculty(J.Doe) |
9,438 |
1,966 |
11,404 |
| Staff(G. Scott) |
1,384 |
|
1,384 |
| GRA (W. Smith, J. Jones) |
5,944 |
|
5,944 |
| Student Workers (Undergrads) |
|
|
|
| Subtotal-Fringe Benefits |
16,851 |
1,966 |
18,817 |
| Subtotal-Labor and Benefits |
78,051 |
9,316 |
87,367 |
| |
|
|
|
| Operations- |
|
|
|
| Materials & Supplies(incl. office-type supplies used on project) |
5,325 |
|
5,325 |
| Communications(incl.toll charges,FAX,Express Mail,postage) |
2,100 |
|
2,100 |
| Publication charges(10 pages @ $220/pg) |
2,200 |
|
2,200 |
| Photocopies($125/mo) |
1,500 |
|
1,500 |
| Computer Services(10 hrs. @ $330/hr) |
3,300 |
|
3,300 |
| Consulting-Dr. Collaborator, 30 days @ $283.33/day |
8,500 |
|
8,500 |
| Other-Subaward to ASU |
40,000 |
|
40,000 |
| Subtotal-Operations |
62,925 |
|
62,925 |
| |
|
|
|
| Travel- |
|
|
|
| Domestic-4 trips to meet with sponsor, Washington,D.C. |
6,000 |
|
6,000 |
| Foreign-International Conference in Sonora, Mexico |
4,000 |
|
4,000 |
| Subtotal-Travel |
10,000 |
|
10,000 |
| |
|
|
|
| Permanent Equipment- |
|
|
|
| Mass Spectrometer(includes shipping/ handling) |
13,000 |
|
13,000 |
| Subtotal-Equipment |
13,000 |
|
13,000 |
| |
|
|
|
| Total Direct Costs(TDC) |
163,976 |
9,316 |
173,292 |
| Calculation of MTDC Base: |
|
|
|
| Total Direct Costs |
163,976 |
9,316 |
173,292 |
| Less: GRA Tuition Remission |
|
|
|
| Less: Amount of Subaward >$25,000 |
(15,000) |
|
(15,000) |
| Less: Equipment |
|
|
|
| MTDC Base |
132,258 |
9,316 |
141,574 |
| |
|
|
|
| F&A Calculations: Oct05-Jun06 (9mos) @ 50.5% |
50,093 |
4,182 |
54,274 |
| F&A Calculations: Jul06-Sep06 (3mos) @ 51% |
|
|
|
| Total F&A Costs |
|
|
|
| |
|
|
|
| TOTAL COSTS |
230,931 |
14,025 |
244,957 |
|