| 12/20/1999 | ||||||||||
| WORKSHEET FOR CALCULATING GROSS PROJECT COSTS | ||||||||||
| Fiscal Year = | 2000 | Project Name = | ||||||||
| Account/Project Number = | ||||||||||
| The shaded areas need to be filled by district personnel--percentages must be entered as .0454 not 4.540. | ||||||||||
| Cost Center Full Assessment Rate - (to be filled by each District) | 0.000% | |||||||||
| Cost Center Special Assessment Rate | 12.088% | |||||||||
| Other Cost Center Pre-approved Reduced Rate | 0.000% | |||||||||
| Pass-through Rate | 1.000% | |||||||||
| Division Assessment Rate | 10.500% | |||||||||
| Reimbursable Facility Assessment Rate (to be filled by each District) | 0.000% | |||||||||
| Federal Coop Match Facility Rate + Science Support Assessment Rate | 16.991% | |||||||||
| SPECIFY the Type of Project: 1= FED, 2=COOP, 3=OFA | 0 | |||||||||
| Direct State Services (ONLY for COOP) | 0.00 | 0.00 | ||||||||
| Unmatched (in gross amount from agreement only for COOP) | 0.00 | 0.00 | ||||||||
| 1. CALCULATE TOTAL WORKING COSTS (NET FUNDS) | ||||||||||
| A. Costs charged reduced cost center overhead (special rate): | ||||||||||
| Laboratory analysis, drilling, instrumentation, etc. | 0.00 | |||||||||
| Direct state services | 0.00 | |||||||||
| Pass-through | 0.00 | |||||||||
| B. Costs charged full cost center overhead: | ||||||||||
| Laboratory analyses | 0.00 | |||||||||
| Salary | 0.00 | |||||||||
| Leave | 0.00 | |||||||||
| Overtime | 0.00 | |||||||||
| Travel | 0.00 | |||||||||
| Transportation | 0.00 | |||||||||
| Communications | 0.00 | |||||||||
| Utilities | 0.00 | |||||||||
| Printing | 0.00 | |||||||||
| Supplies and materials | 0.00 | |||||||||
| Equipment | 0.00 | |||||||||
| Rental of Equipment (ADR) | 0.00 | |||||||||
| Reimbursements (SVs) | 0.00 | |||||||||
| Other (such as contingency amount) | 0.00 | |||||||||
| TOTAL NET FUNDS | 0.00 | |||||||||
| 2. CALCULATE GROSS FUNDS TO THE PROJECT | ||||||||||
| A. Subtotal: Costs subject to special cost center assessment rate | 0.00 | |||||||||
| Apply Cost Center Assessment | 0.00 | 0.00 | ||||||||
| B. Subtotal: Costs subject to full cost center assessment rate | 0.00 | |||||||||
| Apply Cost Center Assessment | 0.00 | 0.00 | ||||||||
| C. Apply Division Assessment | 0.00 | 0.00 | ||||||||
| D. Apply Facility and Science Support Assessment | 0.00 | 0.00 | ||||||||
| E. Add costs not subject to assessment at any level (direct state services) | 0.00 | 0.00 | ||||||||
| TOTAL GROSS FUNDS NEEDED FOR THE PROJECT | 0.00 | |||||||||
| 12/20/1999 | ||||||||||
| EXAMPLE - CALCULATING GROSS FEDERAL PROJECT COSTS | ||||||||||
| Fiscal Year = | 2000 | Project Name = | ||||||||
| Account/Project Number = | ||||||||||
| The shaded areas need to be filled by district personnel--percentages must be entered as .0454 not 4.540. | ||||||||||
| Cost Center Full Assessment Rate - (to be filled by each District) | 29.537% | |||||||||
| Cost Center Special Assessment Rate | 12.088% | |||||||||
| Other Cost Center Pre-approved Reduced Rate | 0.000% | |||||||||
| Pass-through Rate | 1.000% | |||||||||
| Division Assessment Rate | 10.500% | |||||||||
| Reimbursable Facility Assessment Rate (to be filled by each District) | 4.540% | |||||||||
| Federal Coop Match Facility Rate + Science Support Assessment Rate | 16.991% | |||||||||
| SPECIFY the Type of Project: 1= FED, 2=COOP, 3=OFA | 1 | |||||||||
| Direct State Services (ONLY for COOP) | 0.00 | 0.00 | ||||||||
| Unmatched (in gross amount from agreement only for COOP) | 0.00 | 0.00 | ||||||||
| 1. CALCULATE TOTAL WORKING COSTS (NET FUNDS) | ||||||||||
| A. Costs charged reduced cost center overhead (special rate): | ||||||||||
| Laboratory analysis, drilling, instrumentation, etc. | 300,000.00 | |||||||||
| Direct state services | 0.00 | |||||||||
| Pass-through | 0.00 | |||||||||
| B. Costs charged full cost center overhead: | ||||||||||
| Laboratory analyses | 0.00 | |||||||||
| Salary | 909,092.53 | |||||||||
| Leave | 50,000.00 | |||||||||
| Overtime | 0.00 | |||||||||
| Travel | 5,000.00 | |||||||||
| Transportation | 0.00 | |||||||||
| Communications | 0.00 | |||||||||
| Utilities | 0.00 | |||||||||
| Printing | 500.00 | |||||||||
| Supplies and materials | 1,000.00 | |||||||||
| Equipment | 5,000.00 | |||||||||
| Rental of Equipment (ADR) | 0.00 | |||||||||
| Reimbursements (SVs) | 0.00 | |||||||||
| Other (such as contingency amount) | 1,923.00 | |||||||||
| TOTAL NET FUNDS | 1,272,515.53 | |||||||||
| 2. CALCULATE GROSS FUNDS TO THE PROJECT | ||||||||||
| A. Subtotal: Costs subject to special cost center assessment rate | 300,000.00 | |||||||||
| Apply Cost Center Assessment | 41,250.34 | 341,250.34 | ||||||||
| B. Subtotal: Costs subject to full cost center assessment rate | 972,515.53 | |||||||||
| Apply Cost Center Assessment | 407,669.35 | 1,380,184.88 | ||||||||
| C. Apply Division Assessment | 201,956.09 | 1,923,391.31 | ||||||||
| D. Apply Facility and Science Support Assessment | 0.00 | 1,923,391.31 | ||||||||
| E. Add costs not subject to assessment at any level (direct state services) | 0.00 | 1,923,391.31 | ||||||||
| TOTAL GROSS FUNDS NEEDED FOR THE PROJECT | 1,923,391.31 | |||||||||
| 12/20/1999 | ||||||||||
| EXAMPLE - CALCULATING GROSS COOP PROJECT COSTS | ||||||||||
| Fiscal Year = | 2000 | Project Name = | ||||||||
| Account/Project Number = | ||||||||||
| The shaded areas need to be filled by district personnel--percentages must be entered as .0454 not 4.540. | ||||||||||
| Cost Center Full Assessment Rate - (to be filled by each District) | 29.537% | |||||||||
| Cost Center Special Assessment Rate | 12.088% | |||||||||
| Other Cost Center Pre-approved Reduced Rate | 0.000% | |||||||||
| Pass-through Rate | 1.000% | |||||||||
| Division Assessment Rate | 10.500% | |||||||||
| Reimbursable Facility Assessment Rate (to be filled by each District) | 4.540% | |||||||||
| Federal Coop Match Facility Rate + Science Support Assessment Rate | 16.991% | |||||||||
| SPECIFY the Type of Project: 1= FED, 2=COOP, 3=OFA | 2 | |||||||||
| Direct State Services (ONLY for COOP) | 25,000.00 | 25,000.00 | ||||||||
| Unmatched (in gross amount from agreement only for COOP) | 231,520.00 | 231,520.00 | ||||||||
| 1. CALCULATE TOTAL WORKING COSTS (NET FUNDS) | ||||||||||
| A. Costs charged reduced cost center overhead (special rate): | ||||||||||
| Laboratory analysis, drilling, instrumentation, etc. | 105,985.00 | |||||||||
| Direct state services | 25,000.00 | |||||||||
| Pass-through | 0.00 | |||||||||
| B. Costs charged full cost center overhead: | ||||||||||
| Laboratory analyses | 0.00 | |||||||||
| Salary | 978,000.93 | |||||||||
| Leave | 50,000.00 | |||||||||
| Overtime | 0.00 | |||||||||
| Travel | 15,000.00 | |||||||||
| Transportation | 0.00 | |||||||||
| Communications | 0.00 | |||||||||
| Utilities | 0.00 | |||||||||
| Printing | 1,000.00 | |||||||||
| Supplies and materials | 15,000.00 | |||||||||
| Equipment | 15,000.00 | |||||||||
| Rental of Equipment (ADR) | 0.00 | |||||||||
| Reimbursements (SVs) | 10,000.00 | |||||||||
| Other (such as contingency amount) | 2,092.00 | |||||||||
| TOTAL NET FUNDS | 1,217,077.93 | |||||||||
| 2. CALCULATE GROSS FUNDS TO THE PROJECT | ||||||||||
| A. Subtotal: Costs subject to special cost center assessment rate | 105,985.00 | |||||||||
| Apply Cost Center Assessment | 14,573.06 | 120,558.06 | ||||||||
| B. Subtotal: Costs subject to full cost center assessment rate | 1,086,092.93 | |||||||||
| Apply Cost Center Assessment | 455,279.92 | 1,541,372.85 | ||||||||
| C. Apply Division Assessment | 194,975.13 | 1,856,906.05 | ||||||||
| D. Apply Facility and Science Support Assessment | 209,614.35 | 2,066,520.40 | ||||||||
| E. Add costs not subject to assessment at any level (direct state services) | 25,000.00 | 2,091,520.40 | ||||||||
| TOTAL GROSS FUNDS NEEDED FOR THE PROJECT | 2,091,520.40 | |||||||||
| 12/20/1999 | ||||||||||
| EXAMPLE - CALCULATING GROSS OFA PROJECT COSTS | ||||||||||
| Fiscal Year = | 2000 | Project Name = | ||||||||
| Account/Project Number = | ||||||||||
| The shaded areas need to be filled by district personnel--percentages must be entered as .0454 not 4.540. | ||||||||||
| Cost Center Full Assessment Rate - (to be filled by each District) | 29.537% | |||||||||
| Cost Center Special Assessment Rate | 12.088% | |||||||||
| Other Cost Center Pre-approved Reduced Rate | 0.000% | |||||||||
| Pass-through Rate | 1.000% | |||||||||
| Division Assessment Rate | 10.500% | |||||||||
| Reimbursable Facility Assessment Rate (to be filled by each District) | 4.540% | |||||||||
| Federal Coop Match Facility Rate + Science Support Assessment Rate | 16.991% | |||||||||
| SPECIFY the Type of Project: 1= FED, 2=COOP, 3=OFA | 3 | |||||||||
| Direct State Services (ONLY for COOP) | 0.00 | 0.00 | ||||||||
| Unmatched (in gross amount from agreement only for COOP) | 0.00 | 0.00 | ||||||||
| 1. CALCULATE TOTAL WORKING COSTS (NET FUNDS) | ||||||||||
| A. Costs charged reduced cost center overhead (special rate): | ||||||||||
| Laboratory analysis, drilling, instrumentation, etc. | 88,000.00 | |||||||||
| Direct state services | 0.00 | |||||||||
| Pass-through | 9,900.00 | |||||||||
| B. Costs charged full cost center overhead: | ||||||||||
| Laboratory analyses | 0.00 | |||||||||
| Salary | 383,599.11 | |||||||||
| Leave | 5,000.00 | |||||||||
| Overtime | 0.00 | |||||||||
| Travel | 15,000.00 | |||||||||
| Transportation | 0.00 | |||||||||
| Communications | 0.00 | |||||||||
| Utilities | 0.00 | |||||||||
| Printing | 5,000.00 | |||||||||
| Supplies and materials | 10,000.00 | |||||||||
| Equipment | 14,000.00 | |||||||||
| Rental of Equipment (ADR) | 0.00 | |||||||||
| Reimbursements (SVs) | 0.00 | |||||||||
| Other (such as contingency amount) | 1,000.00 | |||||||||
| TOTAL NET FUNDS | 531,499.11 | |||||||||
| 2. CALCULATE GROSS FUNDS TO THE PROJECT | ||||||||||
| A. Subtotal: Costs subject to special cost center assessment rate | 97,900.00 | |||||||||
| Apply Cost Center Assessment | 12,200.10 | 110,100.10 | ||||||||
| B. Subtotal: Costs subject to full cost center assessment rate | 433,599.11 | |||||||||
| Apply Cost Center Assessment | 181,760.66 | 615,359.77 | ||||||||
| C. Apply Division Assessment | 83,936.63 | 809,396.51 | ||||||||
| D. Apply Facility and Science Support Assessment | 38,018.65 | 847,415.15 | ||||||||
| E. Add costs not subject to assessment at any level (direct state services) | 0.00 | 847,415.15 | ||||||||
| TOTAL GROSS FUNDS NEEDED FOR THE PROJECT | 847,415.15 | |||||||||