SAMPLE BUDGET
The following is a sample budget that uses the generally accepted budget structure. Although Excel is most commonly used, you can use this format to develop a budget in the software of your choice. EES has excel worksheets they can provide with the correct fringe rates, F & A rates, etc. upon request if you would like a skeleton spreadsheet to begin planning your budget. PreAwards also has developed a fillable Budget Worksheet that can create the individual budget years and a summary budget per information entered into the budget worksheet.
INTERNAL BUDGET (Insert this statement if budget is to be used only for internal KSU purposes)
Proposed Budget to (SPONSOR)
For the period (DATES)
Dates for Year 1 |
Dates for Year 2 |
Dates for Year 3 |
Totals |
|||||||
Sponsor |
KSU |
Sponsor |
KSU |
Sponsor |
KSU |
Sponsor |
KSU |
|||
| . | ||||||||||
| A. Personnel | ||||||||||
| 1. I. M. Investigator | ||||||||||
| 1.0 time, 1 mo. summer | 10,875 |
11,419 |
11,990 |
34,284 |
||||||
| 0.1 time. 9 mos. acad. yr. | 9,321 |
9,321 |
9,321 |
27,963 |
||||||
| 2. I. M. Copi | ||||||||||
| 1.0 time, 1 mo. summer | 6,665 |
6,998 |
7,348 |
21,011 |
||||||
| 3. Graduate Research Assistants(2) | ||||||||||
| 0.5 time, 12 mos. cal. yr. | 32,000 |
33,600 |
35,280 |
100,880 |
||||||
| 4. Fringe Benefits | ||||||||||
| 32.0% of A1-2 and 5.5% of A3 | 7,373 |
2,983 |
7,741 |
2,983 |
8,129 |
2,983 |
23,243 |
8,949 |
||
| Subtotal Personnel | 56,913 |
12,304 |
59,758 |
12,304 |
62,747 |
12,304 |
179,418 |
36,912 |
||
| . | ||||||||||
| B. Equipment | ||||||||||
| 1. Test Machine | 10,000 |
10,000 |
||||||||
| 2. Measurement Tooling Device | 7,500 |
7,500 |
||||||||
| Subtotal Equipment | 17,500 |
17,500 |
||||||||
| . | ||||||||||
| C. Travel | ||||||||||
| 1. Domestic | 2,000 |
2,000 |
4,000 |
|||||||
| 2. Foreign | 3,000 |
3,000 |
||||||||
| Subtotal Travel | 2,000 |
2,000 |
3,000 |
7,000 |
||||||
| . | ||||||||||
| D. Other Direct Costs | ||||||||||
| 1. Materials and supplies | 3,500 |
2,500 |
1,500 |
7,500 |
||||||
| a. Programmable pump | 2,000 |
2,000 |
||||||||
| b. Continuous flow turbidimeter | 1,950 |
1,950 |
||||||||
| c. Pentium computer | 3,500 |
3,500 |
||||||||
| d. Pressure Transducer | 1,950 |
1,950 |
||||||||
| Subtotal Materials and Supplies | 12,900 |
2,500 |
1,500 |
16,900 |
||||||
| 2. Publication costs | 500 |
500 |
500 |
1,500 |
||||||
| 3. Tuition | 5,123 |
5,635 |
6,199 |
16,957 |
||||||
| 4. Duplication and communication | 250 |
250 |
250 |
750 |
||||||
| Subtotal Other Direct Costs | 18,773 |
8,885 |
8,449 |
36,107 |
||||||
| . | ||||||||||
| Total Direct Costs | 95,186 |
12,304 |
70,643 |
12,304 |
74,196 |
12,304 |
240,025 |
36,912 |
||
| . | ||||||||||
| E. Facilities and Administrative Costs (46 % of MTDC) | 33,379 |
5,660 |
29,904 |
5,660 |
31,279 |
5,660 |
94,562 |
16,980 |
||
| . | ||||||||||
| . | ||||||||||
| TOTAL PROJECT COSTS | 128,565 |
17,964 |
100,547 |
17,964 |
105,475 |
17,964 |
334,587 |
53,892 |
||