| COST CENTER ASSESSMENT RATE WORKSHEET FOR
FISCAL YEAR 2000 |
| (Completed
shaded areas only--spreadsheet will calculate remaining values) |
|
|
|
|
|
|
|
|
|
12/14/1999 |
| Funding |
Total gross |
Net funds subject to… |
Rates |
| Standard reduced rate |
Other
pre-approved reduced rate |
Pass-through rate |
| Federal (excl. HRI) |
|
1,923,391.00 |
300,000.00 |
0.00 |
0.00 |
Facilities |
|
|
|
| Human Resources
Initiative or Institutes funds |
0.00 |
0.00 |
0.00 |
0.00 |
On
Augmented Fed-Match Funds |
8.878% |
| Non Direct/Non
Reimbursable (excl. WCF/Tech Support) |
0.00 |
0.00 |
0.00 |
0.00 |
On
Reimbursable Funds--District-specific |
4.540% |
| WCF outlays |
|
0.00 |
0.00 |
0.00 |
0.00 |
Science Support on Augmented Fed-Match Funds |
8.113% |
| Tech Support |
|
100,000.00 |
0.00 |
0.00 |
0.00 |
Division Assessment |
|
10.500% |
| OFA funds (excl.
FOIA and pass-through) |
837,415.00 |
88,000.00 |
0.00 |
0.00 |
Cost Center Assessment |
|
|
| FOIA requests |
|
0.00 |
0.00 |
0.00 |
0.00 |
Full |
|
|
29.537% |
| Pass-through funds |
|
10,000.00 |
0.00 |
0.00 |
9,900.00 |
Standard reduced rate |
|
12.088% |
| Augmented
Federal Matching funds (FMF) |
930,000.00 |
52,882.50 |
0.00 |
0.00 |
Other
reduced rate (requires prior CH approval) |
5.000% |
| Cooperator Repay funds |
|
905,000.00 |
52,882.50 |
0.00 |
0.00 |
Pass-through rate |
|
1.000% |
| Direct services |
|
25,000.00 |
0.00 |
0.00 |
0.00 |
FY 1999 Cost Common Services Budget |
1,300,000.00 |
| Unmatched funds |
|
231,520.00
|
220.00 |
0.00 |
0.00 |
Less FY 1999 Facilities Costs |
|
191,000.00 |
| TOTAL |
4,962,326.00
|
493,985.00 |
0.00 |
9,900.00 |
Plus 3% Inflation |
|
33,270.00 |
| |
|
|
|
|
|
FY 2000 Common Services Estimate |
1,142,270.00 |
| |
| Check cost
categories on which standard cost center special rate will be charged: |
x |
|
|
|
|
|
|
| |
|
|
Laboratory
svcs |
Drilling contracts |
Geologic mapping svcs |
Hydrologic instrumentation |
Other--specify |
Other--specify |
Other-specify |
|
| |
|
Federal |
NonDirect/
NonReimbursable |
OFA |
Federal Match |
Cooperator Repay |
Direct Services |
Unmatched |
Total |
| Projected total funding (gross) |
1,923,391.00 |
100,000.00 |
847,415.00 |
930,000.00 |
905,000.00 |
25,000.00 |
231,520.00 |
4,962,326.00 |
| Less: |
|
|
|
|
|
|
|
|
|
| Gross funds not subject to overhead at any level |
|
|
|
|
|
|
|
|
| Direct Services in the Fed-State Coop Program |
|
|
|
|
|
-25,000.00 |
|
-25,000.00 |
| Working Capital Fund outlays |
|
0.00 |
|
|
|
|
|
0.00 |
| Human Resources Initiative or Institutes funds |
0.00 |
|
|
|
|
|
|
0.00 |
| FOIA requests |
|
|
|
0.00 |
|
|
|
|
0.00 |
| Less: |
|
|
|
|
|
|
|
|
|
| Gross funds not subject to Tier 1 or Tier 2 Assessments |
|
|
|
|
|
|
|
|
| Gross technical support funds |
|
-100,000.00 |
|
|
|
|
|
-100,000.00 |
| Gross pass-through funds |
|
|
|
-10,000.00 |
|
|
|
|
-10,000.00 |
| Gross funds subject to Tier 1 Assessment |
1,923,391.00 |
0.00 |
837,415.00 |
930,000.00 |
905,000.00 |
0.00 |
231,520.00 |
4,827,326.00 |
| Less Tier
1 Assessments: |
|
|
|
|
|
|
|
|
|
| Facilities assessment |
|
0.00 |
0.00 |
-38,018.64 |
-82,565.40 |
-41,087.00 |
0.00 |
-10,511.01 |
-172,182.05 |
| Science Support assessment on augmented FMF |
0.00 |
0.00 |
0.00 |
-75,450.90 |
0.00 |
0.00 |
0.00 |
-75,450.90 |
| Subgross 1 |
|
1,923,391.00 |
0.00 |
799,396.36 |
771,983.70 |
863,913.00 |
0.00 |
221,008.99 |
4,579,693.05 |
| Division assessment |
|
-201,956.06 |
0.00 |
-83,936.62 |
-81,058.29 |
-90,710.87 |
0.00 |
-23,205.94 |
-480,867.77 |
| Plus: |
|
|
|
|
|
|
|
|
|
| Funds not subject to Tier 1 or Tier 2 Assessments |
0.00 |
100,000.00 |
10,000.00 |
0.00 |
0.00 |
0.00 |
0.00 |
110,000.00 |
| Subgross 2 |
|
1,721,434.95 |
100,000.00 |
725,459.74 |
690,925.41 |
773,202.14 |
0.00 |
197,803.05 |
4,208,825.28 |
| Less: |
|
|
|
|
|
|
|
|
|
| Subgross 2 funds subject to reduced cost center rates |
-341,250.34 |
0.00 |
-110,100.10 |
-60,153.90 |
-60,153.90 |
0.00 |
-250.25 |
-571,908.50 |
| Subgross 2 funds
subject to full cost center assessment |
1,380,184.60 |
100,000.00 |
615,359.64 |
630,771.51 |
713,048.23 |
0.00 |
197,552.80 |
3,636,916.78 |
| Cost Center
Common Services Budget |
|
|
|
|
|
|
|
1,142,270.00 |
| Cost Center
assessment derived from reduced rate activities |
|
|
|
|
|
|
|
|
| Standard reduced
rate activities |
-41,250.34 |
0.00 |
-12,100.10 |
-7,271.40 |
-7,271.40 |
0.00 |
-30.25 |
-67,923.50 |
| Other reduced
rate activities |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
| Pass-through funding |
|
0.00 |
0.00 |
-100.00 |
0.00 |
0.00 |
0.00 |
0.00 |
-100.00 |
| Total cost
center assessment levied at reduced rates |
-41,250.34 |
0.00 |
-12,200.10 |
-7,271.40 |
-7,271.40 |
0.00 |
-30.25 |
-68,023.50 |
| Cost center
assessment levied on fully assessable funds |
|
|
|
|
|
|
|
1,074,246.50 |
| Gross cost
center assessment rate on funds subject to full assessment |
|
|
|
|
|
29.537% |
| Total Indirect Costs |
|
650,875.47 |
29,537.29 |
315,915.89 |
432,658.77 |
349,684.36 |
0.00 |
92,098.94 |
1,870,770.72 |
| Total Direct Costs |
|
1,272,515.53 |
70,462.71 |
531,499.11 |
497,341.23 |
555,315.64 |
25,000.00 |
139,421.06 |
3,091,555.28 |
|
|
|
|
|
|
|
|
|
|