| Attachment 1 | 3 | |||||||||
| Budget Redirection and Assessment Changes | ||||||||||
| In Two Coop Projects | ||||||||||
| Table 1--Matched Project | Table 2--Unmatched Project | |||||||||
| FY 1999 | FY 1999 | |||||||||
| USGS | Cooperator | Total | USGS | Cooperator | Total | |||||
| Gross Project Funding | $ 100,000 | $ 100,000 | $ 200,000 | Gross Project Funding | $0 | $ 100,000 | $ 100,000 | |||
| Headquarters-level Indirect Costs (12.5% x gross funding) | (12,500) | (12,500) | (25,000) | Headquarters-level Indirect Costs (12.5% x gross funding) | 0 | (12,500) | (12,500) | |||
| Subgross 1a--Assessable Income | 87,500 | 87,500 | 175,000 | Subgross 1a--Assessable Income | 0 | 87,500 | 87,500 | |||
| District level Indirect Costs--Facilities (6% x gross funding or 6.857% x subgross 1a in this example) | (6,000) | (6,000) | (12,000) | District level Indirect Costs--Facilities (6% x gross funding or 6.857% x subgross 1a in this example) | 0 | (6,000) | (6,000) | |||
| Subgross 2--Income Available for District Expenditure | 81,500 | 81,500 | 163,000 | Subgross 2--Income Available for District Expenditure | 0 | 81,500 | 81,500 | |||
| District-level Indirect Costs--Other (29.141% x subgross 2 in this example) | (23,750) | (23,750) | (47,500) | District-level Indirect Costs--Other (29.141% x subgross 2 in this example) | 0 | (23,750) | (23,750) | |||
| Net Project Funding | 57,750 | 57,750 | 115,500 | Net Project Funding | 0 | 57,750 | 57,750 | |||
| Notes: | ||||||||||
| 1. District-level Indirect Costs are divided in this example for illustration purposes. The actual District overhead rate in this example is 34% x subgross 1a (gross funding less Headquarters-level Indirect costs). This rate is district-specific and will vary among districts. | ||||||||||
| FY 2000 | FY 2000 | |||||||||
| USGS | Cooperator | Total | USGS | Cooperator | Total | |||||
| Gross Project Funding | $ 100,000 | $ 100,000 | 200,000 | Gross Project Funding | $0 | $ 100,000 | 100,000 | |||
| Facilities Costs (8.841% x gross USGS funding; 6% x gross cooperator funding in this example) | (8,841) | (6,000) | (14,841) | Facilities Costs (8.841% x gross USGS funding; 6% x gross cooperator funding in this example) | 0 | (6,000) | (6,000) | |||
| Science Support Costs (8.079% x gross USGS funding; 0% of cooperator funding) | (8,079) | 0 | (8,079) | Science Support Costs (8.079% x gross USGS funding; 0% of cooperator funding) | 0 | 0 | 0 | |||
| Subgross 1b--Assessable Income | 83,080 | 94,000 | 177,080 | Subgross 1b--Assessable Income | 0 | 94,000 | 94,000 | |||
| Headquarters-level Indirect Costs (11% x subgross 1b) | (9,139) | (10,340) | (19,479) | Headquarters-level Indirect Costs (11% x subgross 1b) | 0 | (10,340) | (10,340) | |||
| Subgross 2--Income Available for District Expenditure | 73,941 | 83,660 | 157,601 | Subgross 2--Income Available for District Expenditure | 0 | 83,660 | 83,660 | |||
| District-level Indirect Costs--Other (29.141% x subgross 2 in this example) | (21,547) | (24,379) | (45,927) | District-level Indirect Costs--Other (29.141% x subgross 2 in this example) | 0 | (24,379) | (24,379) | |||
| Net Project Funding | 52,394 | 59,281 | 111,675 | Net Project Funding | 0 | 59,281 | 59,281 | |||
| Notes: | ||||||||||
| 1. No inflationary increases are factored into the analysis. | ||||||||||
| 2. The gross project funding on the USGS side for all coop projects will be made up of the federal matching fund line item (83.080% of the augmented total), facilities line item (8.841% of the augmented total), and science support line item (8.079% of the augmented total). | ||||||||||
| 3. The cooperator’s facilities costs will be based on actual costs (set at 6% in this example) and will vary from district to district. | ||||||||||
| 4. The district overhead rate (set at 29.141% of subgross 2 in this example) does not collect the same amount of income for this project as it did in FY 1999. The rate was held constant to reflect the fact that overhead should rise and fall along with the dollars available for science. The district overhead rate is established based on local costs and will vary from district to district. | ||||||||||