UA

Sponsored Projects Services
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)
84
84
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
(3,718)
(3,718)
Less: Amount of Subaward >$25,000
(15,000)
(15,000)
Less: Equipment
(13,000)
(13,000)
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%
16,863
528
17,391
Total F&A Costs
66,956
4,710
71,665
TOTAL COSTS
230,931
14,025
244,957