FS-1500-17B Agreements Financial Plan (Short)

Good Neighbor Agreements With State Cooperators

FS 1500-17b Financial Plan Short Form.xlsx

GOOD NEIGHBOR AGREEMENTS WITH STATE COOPERATORS

OMB: 0596-0239

Document [xlsx]
Download: xlsx | pdf

Overview

Instructions
V.1. Financial Plan
FS Non-Cash Cont. (a)
FS Cash to the Coop. (b)
Coop. Non-Cash Cont. (c)
Coop. In-Kind Cont. (d)
V.2. Financial Plan
V.3. Multiple Cooperators


Sheet 1: Instructions

Instructions: Use this form in conjunction with Forest Service Handbook (FSH) 1509.11, Ch. 70, Financial Planning Requirements, for participating, challenge cost-share, joint venture, and cost-reimbursable agreements. This form may be used for other types of Forest Service Manual 1580 agreements, when useful. Choose one of the three (3) financial plan versions and complete. Each version requires identical information and result in calculations and cost analysis that are the same. Version 1 cost analysis data values are automatically entered into the financial plan matrix. Version 2 requires manual entry of the cost analysis data values into the financial plan matrix. Version 3 should be used if there are multiple Cooperators. Users do not have to use or print versions/sheets that are not applicable to their agreement.











The purpose of this form is to capture the total estimated value of the proposed agreement. Once the agreement is approved, in writing, by the parties, then this financial plan becomes the financial estimates for the agreement. This financial plan must display the parties' expected contributions to the agreement. These contributions should be broken down by party contribution type (e.g., non-cash, in-kind, cash to cooperator), see below for definitions, and cost elements (e.g., salaries, supplies, travel). Cost element values should be the result of documented cost analysis on this form. Each financial plan version provides samples of cost analysis calculations, see associated Excel comment balloons. Additional instructions are located on version 1 cost analysis tabs.










Definitions for the Matrix Column Headings:


















(a) Forest Service Noncash Contribution: Forest Service noncash contributions may consist of employee salaries, overhead (indirect), travel provided, and/or equipment and supplies purchased and provided to the Cooperator for use in the project. These costs are an expense to the Forest Service, but do not include funding for reimbursement of Cooperator expenses.










(b) Forest Service Cash to Cooperator: This is the maximum amount of funding that will be reimbursed or advanced by the Forest Service to the Cooperator. This is an expense to the Forest Service.










(c) Cooperator Noncash Contribution: These are expenses the Cooperator incurs that are contributed to the project in lieu of cash, but for which costs are incurred, such as employee salaries, overhead (indirect costs), travel, equipment, supplies, and so forth. These do not include in-kind contributions from third parties, such as donations from other entities or volunteer labor. All the costs listed here are an expense to the Cooperator.










(d) Cooperator In-Kind Contribution: In-kind contribution provided to the Cooperator from a third party organization(s) for use in the project for which the Cooperator has incurred no expense. Value assessed for volunteer labor and donated materials, equipment and supplies should be valued based on FSH 1509.11, Ch. 70. These values are not reimbursable and can only be used to satisfy the Cooperator's matching requirement. Display these contributions by Cost Element Expenditures.










(e) Total Project Value: The sum of all the values provided toward the project. This figure reflects the true estimated cost of the project.










Definitions for Cost Allowability


















(a) Allowable Cost: A cost, as recorded on the Agreements Financial Plan (Long, Medium, and Short) forms, associated with an agreement, which meets the criteria for authorized expenditures specific in a cost principle methodology. Generally, it meets the cost principle methodology, and is a cost the parties to an agreement intend to charge, and must be: Reasonable for the performance of the award; Necessary and reasonable for proper and efficient performance and administration of the agreement; Consistently treated as either a direct or indirect cost; Generally, determined in accordance with generally accepted accounting principles (GAAP);
Net of all applicable credits (that is, less any future rebates from the purchase of goods or services); Separate from a cost or from a cost-sharing/matching requirement of another Federal award or agreement, unless otherwise permitted by Federal law or regulation; Adequately documented; Authorized or not prohibited by Federal, State, or local laws and regulations; Compliant with limits or exclusions on types or amounts of costs, as set forth in relevant Federal laws, agreement terms and conditions, or other governing regulations (examples of such costs include: entertainment, alcohol, and taxes); and,Consistent with the agency’s and cooperator’s internal policies, regulations, and procedures that apply to both Federal awards or agreements and other cooperator activities.










(b) Allocable Cost: A cost, as recorded on the Agreements Financial Plan (Long, Medium, and Short) forms, associated with an agreement, which in accordance with the relative benefit received by either party for the award, is treated consistently with other costs incurred for the same purpose and in like circumstances, and if it: Is incurred specifically for the award; Benefits both the award and other ancillary work, and the cost may be distributed in reasonable proportion to the benefits received (an example of this type of cost is a piece of equipment that is used for multiple projects); or Necessary to the overall operation of the organization, although a direct relationship to any particular cost objective may not be shown.










(c) Reasonable Cost: A cost, as recorded on the Agreements Financial Plan (Long, Medium, and Short) forms, associated with an agreement, that, in its nature and amount, does not exceed an amount that a prudent person, under the circumstances prevailing at the time the decision was made, would incur. Other factors to consider are: Whether the cost is of a type generally recognized as ordinary and necessary for the entity’s operation or agreement performance; The restraints or requirements imposed by factors such as generally accepted, sound, business practices; arms-length bargaining; Federal and State laws and regulations; and the terms and conditions of the agreement; Market prices or industry standard costs for similar goods and services (that is, is the cooperator offering goods or services for an amount that exceeds what is readily available in the marketplace); Whether individuals concerned acted with prudence under the circumstances, considering their responsibilities to the entity; its members, employees, and clients; the public; and the government; and Significant deviations from established practices of the governmental entity that might unjustifiably increase costs charged to the agreement.














Burden Statement













According to the Paperwork Reduction Act of 1995, an agency may not conduct or sponsor, and a person is not required to respond to a collection of information unless it displays a valid OMB control number. The valid OMB control number for this information collection is 0596-0217. The time required to complete this information collection is estimated to average 45 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on the basis of race, color, national origin, age, disability, and where applicable, sex, marital status, familial status, parental status, religion, sexual orientation, genetic information, political beliefs, reprisal, or because all or part of an individual’s income is derived from any public assistance. (Not all prohibited bases apply to all programs.) Persons with disabilities who require alternative means for communication of program information (Braille, large print, audiotape, etc.) should contact USDA’s TARGET Center at 202-720-2600 (voice and TDD). To file a complaint of discrimination, write USDA, Director, Office of Civil Rights, 1400 Independence Avenue, SW, Washington, DC 20250-9410 or call toll free (866) 632-9992 (voice). TDD users can contact USDA through local relay or the Federal relay at (800) 877-8339 (TDD) or (866) 377-8642 (relay voice). USDA is an equal opportunity provider and employer.











Sheet 2: V.1. Financial Plan

Attachment:








USFS Agreement No.:
Mod. No.:



Cooperator Agreement No.:













Note: This Financial Plan may be used when:
(1) No program income is expected and
(2) The Cooperator is not giving cash to the FS and
(3) There is no other Federal funding















Agreements Financial Plan (Short Form)

Financial Plan Matrix: Note: All columns may not be used. Use depends on source and type of contribution(s).






FOREST SERVICE CONTRIBUTIONS COOPERATOR CONTRIBUTIONS



(a) Forest Service Noncash Contribution: Forest Service noncash contributions may consist of employee salaries, overhead (indirect), travel provided, and/or equipment and supplies purchased and provided to the Cooperator for use in the project. These costs are an expense to the Forest Service, but do not include funding for reimbursement of Cooperator expenses. (a) (b) Forest Service Cash to Cooperator: This is the maximum amount of funding that will be reimbursed or advanced by the Forest Service to the Cooperator. This is an expense to the Forest Service. (b) (c) Cooperator Noncash Contribution: These are expenses the Cooperator incurs that are contributed to the project in lieu of cash, but for which costs are incurred, such as employee salaries, overhead (indirect costs), travel, equipment, supplies, and so forth. These do not include in-kind contributions from third parties, such as donations from other entities or volunteer labor. All the costs listed here are an expense to the Cooperator. (c) (d) Cooperator, Third Party In-Kind Contribution: In-kind contribution provided to the Cooperator from a third party organization(s) for use in the project for which the Cooperator has incurred no expense. Value assessed for volunteer labor and donated materials, equipment and supplies should be valued based on FSH 1509.11, Ch. 70. These values are not reimbursable and can only be used to satisfy the Cooperator's matching requirement. Display these contributions by Cost Element Expenditures. (d)




Cash




COST ELEMENTS Noncash to Noncash In-Kind (e) Total Project Value: The sum of all the values provided toward the project. This figure reflects the true estimated cost of the project. (e)
Total


Direct Costs
Cooperator



Salaries/Labor $0.00 $0.00 $0.00 $0.00 $0.00

Travel $0.00 $0.00 $0.00 $0.00 $0.00

Equipment $0.00 $0.00 $0.00 $0.00 $0.00

Supplies/Materials $0.00 $0.00 $0.00 $0.00 $0.00

Printing $0.00 $0.00 $0.00 $0.00 $0.00

This cost element can be replaced with a cost element unique to your agreement, for example 'sub-contracts'. Other $0.00 $0.00 $0.00 $0.00 $0.00

This cost element can be replaced with a cost element unique to your agreement. Other



$0.00

Subtotal $0.00 $0.00 $0.00 $0.00 $0.00

Coop Indirect Costs
$0.00 $0.00
$0.00

FS Overhead Costs $0.00


$0.00

Total $0.00 $0.00 $0.00 $0.00


Total Project Value: $0.00










Matching Costs Determination



Total Forest Service Share = (f)



(a+b) ÷ (e) = (f)
#DIV/0!



Total Cooperator Share
(g)



(c+d) ÷ (e) = (g)
#DIV/0!



Total (f+g) = (h)
(h)





#DIV/0!


Sheet 3: FS Non-Cash Cont. (a)

WORKSHEET FOR
FS Non-Cash Contribution Cost Analysis, Column (a)






Use this worksheet to perform the cost analysis that supports the lump sum figures provided in the matrix. NOTE: This worksheet auto populates the relevant and applicable matrix cells.






Cost element sections may be deleted or lines may be hidden, if not applicable. Line items may be added or deleted as needed. The Standard Calculation sections provide a standardized formula for determing a line item's cost, e.g. cost/day x # of days=total, where the total is calculated automatically. The Non-Standard Calculation sections provide a write-in area for line items that require a calculation formula that is other than the standardized formules, e.g. instead of salaries being calculated by cost/day x # of days, costs may be calculated simply by a contracted value that is not dependent on days worked, such as 1 employee x $1,200/contract= $1,200. Be sure to review your calculations when entering in a Non-Standard Calculation, and provide a brief explanation of units used to make calculation, e.g. '1 month contract,' on a line below the figures.






Salaries/Labor



Standard Calculation




Job Description
Cost/Day # of Days
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation
















Total Salaries/Labor



$0.00












Travel



Standard Calculation




Travel Expense Employees Cost/Trip # of Trips
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation
















Total Travel



$0.00












Equipment



Standard Calculation
Piece of Equipment # of Units Cost/Day # of Days
Total





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation


















Total Equipment



$0.00












Supplies/Materials



Standard Calculation
Supplies/Materials
# of Items Cost/Item
Total





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Supplies/Materials



$0.00












Printing



Standard Calculation
Paper Material
# of Units Cost/Unit
Total





$0.00
Non-Standard Calculation






Total Printing



$0.00












Other Expenses



Standard Calculation
Item
# of Units Cost/Unit
Total





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Other



$0.00






Subtotal Direct Costs $0.00












Forest Service Overhead Costs









Current Overhead Rate Subtotal Direct Costs

Total

$0.00

$0.00
Total FS Overhead Costs



$0.00












TOTAL COST $0.00

Sheet 4: FS Cash to the Coop. (b)

WORKSHEET FOR
FS Cash to the Cooperator Cost Analysis, Column (b)






Use this worksheet to perform the cost analysis that supports the lump sum figures provided in the matrix. NOTE: This worksheet auto populates the relevant and applicable matrix cells.






Cost element sections may be deleted or lines may be hidden, if not applicable. Line items may be added or deleted as needed. The Standard Calculation sections provide a standardized formula for determing a line item's cost, e.g. cost/day x # of days=total, where the total is calculated automatically. The Non-Standard Calculation sections provide a write-in area for line items that require a calculation formula that is other than the standardized formules, e.g. instead of salaries being calculated by cost/day x # of days, costs may be calculated simply by a contracted value that is not dependent on days worked, such as 1 employee x $1,200/contract= $1,200. Be sure to review your calculations when entering in a Non-Standard Calculation, and provide a brief explanation of units used to make calculation, e.g. '1 month contract,' on a line below the figures.






Salaries/Labor



Standard Calculation
Job Description
Cost/Day # of Days
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Salaries/Labor



$0.00












Travel



Standard Calculation
Travel Expense Employees Cost/Trip # of Trips
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Travel



$0.00












Equipment



Standard Calculation
Piece of Equipment # of Units Cost/Day # of Days
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Equipment



$0.00












Supplies/Materials



Standard Calculation
Supplies/Materials
# of Items Cost/Item
Total





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Supplies/Materials



$0.00












Printing



Standard Calculation
Paper Material
# of Units Cost/Unit
Total





$0.00
Non-Standard Calculation





$0.00
Total Printing



$0.00












Other Expenses



Standard Calculation
Item
# of Units Cost/Unit
Total





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Other



$0.00






Subtotal Direct Costs $0.00












Cooperator Indirect Costs









Current Overhead Rate Subtotal Direct Costs

Total

$0.00

$0.00
Total Coop. Indirect Costs


$0.00












TOTAL COST $0.00

Sheet 5: Coop. Non-Cash Cont. (c)

WORKSHEET FOR
Cooperator Non-Cash Contribution Cost Analysis, Column (c)






Use this worksheet to perform the cost analysis that supports the lump sum figures provided in the matrix. NOTE: This worksheet auto populates the relevant and applicable matrix cells.






Cost element sections may be deleted or lines may be hidden, if not applicable. Line items may be added or deleted as needed. The Standard Calculation sections provide a standardized formula for determing a line item's cost, e.g. cost/day x # of days=total, where the total is calculated automatically. The Non-Standard Calculation sections provide a write-in area for line items that require a calculation formula that is other than the standardized formules, e.g. instead of salaries being calculated by cost/day x # of days, costs may be calculated simply by a contracted value that is not dependent on days worked, such as 1 employee x $1,200/contract= $1,200. Be sure to review your calculations when entering in a Non-Standard Calculation, and provide a brief explanation of units used to make calculation, e.g. '1 month contract,' on a line below the figures.






Salaries/Labor



Standard Calculation
Job Description
Cost/Day # of Days
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Salaries/Labor



$0.00












Travel



Standard Calculation
Travel Expense Employees Cost/Trip # of Trips
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Travel



$0.00












Equipment



Standard Calculation
Piece of Equipment # of Units Cost/Day # of Days
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Equipment



$0.00












Supplies/Materials



Standard Calculation
Supplies/Materials
# of Items Cost/Item
Total





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Supplies/Materials



$0.00












Printing



Standard Calculation
Paper Material
# of Units Cost/Unit
Total





$0.00
Non-Standard Calculation





$0.00
Total Printing



$0.00












Other Expenses



Standard Calculation
Item
# of Units Cost/Unit
Total





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Other



$0.00






Subtotal Direct Costs $0.00












Cooperator Indirect Costs









Current Overhead Rate Subtotal Direct Costs

Total

$0.00

$0.00
Total Coop. Indirect Costs


$0.00












TOTAL COST $0.00

Sheet 6: Coop. In-Kind Cont. (d)

WORKSHEET FOR
Cooperator In-Kind Contribution Cost Analysis, Column (d)






Use this worksheet to perform the cost analysis that supports the lump sum figures provided in the matrix. NOTE: This worksheet auto populates the relevant and applicable matrix cells.






Cost element sections may be deleted or lines may be hidden, if not applicable. Line items may be added or deleted as needed. The Standard Calculation sections provide a standardized formula for determing a line item's cost, e.g. cost/day x # of days=total, where the total is calculated automatically. The Non-Standard Calculation sections provide a write-in area for line items that require a calculation formula that is other than the standardized formules, e.g. instead of salaries being calculated by cost/day x # of days, costs may be calculated simply by a contracted value that is not dependent on days worked, such as 1 employee x $1,200/contract= $1,200. Be sure to review your calculations when entering in a Non-Standard Calculation, and provide a brief explanation of units used to make calculation, e.g. '1 month contract,' on a line below the figures.






Salaries/Labor



Standard Calculation
Job Description
Cost/Day # of Days
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Salaries/Labor



$0.00












Travel



Standard Calculation
Travel Expense Employees Cost/Trip # of Trips
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Travel



$0.00












Equipment



Standard Calculation
Piece of Equipment # of Units Cost/Day # of Days
Total





$0.00





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Equipment



$0.00












Supplies/Materials



Standard Calculation
Supplies/Materials
# of Items Cost/Item
Total





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Supplies/Materials



$0.00












Printing



Standard Calculation
Paper Material
# of Units Cost/Unit
Total





$0.00
Non-Standard Calculation






Total Printing



$0.00












Other Expenses



Standard Calculation
Item
# of Units Cost/Unit
Total





$0.00





$0.00





$0.00





$0.00
Non-Standard Calculation












Total Other



$0.00






Subtotal Direct Costs $0.00












TOTAL COST $0.00

Sheet 7: V.2. Financial Plan

Attachment:








USFS Agreement No.:
Mod. No.:



Cooperator Agreement No.:













Note: This Financial Plan may be used when:
(1) No program income is expected and
(2) The Cooperator is not giving cash to the FS and
(3) There is no other Federal funding















Agreements Financial Plan (Short Form)

Financial Plan Matrix: Note: All columns may not be used. Use depends on source and type of contribution(s).






FOREST SERVICE CONTRIBUTIONS COOPERATOR CONTRIBUTIONS



(a) Forest Service Noncash Contribution: Forest Service noncash contributions may consist of employee salaries, overhead (indirect), travel provided, and/or equipment and supplies purchased and provided to the Cooperator for use in the project. These costs are an expense to the Forest Service, but do not include funding for reimbursement of Cooperator expenses. (a) (b) Forest Service Cash to Cooperator: This is the maximum amount of funding that will be reimbursed or advanced by the Forest Service to the Cooperator. This is an expense to the Forest Service. (b) (c) Cooperator Noncash Contribution: These are expenses the Cooperator incurs that are contributed to the project in lieu of cash, but for which costs are incurred, such as employee salaries, overhead (indirect costs), travel, equipment, supplies, and so forth. These do not include in-kind contributions from third parties, such as donations from other entities or volunteer labor. All the costs listed here are an expense to the Cooperator. (c) (d) Cooperator, Third Party In-Kind Contribution: In-kind contribution provided to the Cooperator from a third party organization(s) for use in the project for which the Cooperator has incurred no expense. Value assessed for volunteer labor and donated materials, equipment and supplies should be valued based on FSH 1509.11, Ch. 70. These values are not reimbursable and can only be used to satisfy the Cooperator's matching requirement. Display these contributions by Cost Element Expenditures. (d)




Cash




COST ELEMENTS Noncash to Noncash In-Kind (e) Total Project Value: The sum of all the values provided toward the project. This figure reflects the true estimated cost of the project. (e)
Total


Direct Costs
Cooperator



Salaries/Labor



$0.00

Travel



$0.00

Equipment



$0.00

Supplies/Materials



$0.00

Printing



$0.00

This cost element can be replaced with a cost element unique to your agreement, for example 'sub-contracts'. Other



$0.00

This cost element can be replaced with a cost element unique to your agreement. Other



$0.00

Subtotal $0.00 $0.00 $0.00 $0.00 $0.00

Coop Indirect Costs



$0.00

FS Overhead Costs



$0.00

Total $0.00 $0.00 $0.00 $0.00


Total Project Value: $0.00









Matching Costs Determination




Total Forest Service Share = (f)




(a+b) ÷ (e) = (f)
#DIV/0!




Total Cooperator Share
(g)




(c+d) ÷ (e) = (g)
#DIV/0!




Total (f+g) = (h)
(h)






#DIV/0!



2. Cost Analysis:






Use the following section to show additional information that supports the lump sum figures provided above. The following Cost Analysis boxes, (a)-(d), should provide a cost analysis of the corresponding matrix columns, (a)-(d), above, e.g. matrix column (a) FS Non-Cash Contribution should be analyzed under block (a), below, and matrix column (b) FS In-Kind Contribution should be analyzed under block (b), below, etc. Furthermore, each cost analysis box, below, should have clear labels indicating which cost element, above, is being analyzed, e.g. Salary/Labor = hrs or days x rate; Travel = miles x rate, or months x FOR rate (that is, days x per diem rate; Equipment Use = hrs or days x rate; Supplies & Materials--list of items and estimated cost; Printing = estimated cost per item; Indirect Cost = Direct cost x current indirect rate.









If necessary, add additional sheets for cost analysis. To compress any unwanted portion(s) of this section, highlight the section to be hidden, then select "Format", "Row", and "Hide" from the toolbar.

FS Non-Cash Contributions ONLY: EXAMPLE Column (a): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (a)
Forest Service
Noncash Contribution










FSDefaultUser: FS Obligation to Pay Cooperator ONLY: EXAMPLE Column (b): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (b)
Forest Service Cash to Cooperator










FSDefaultUser: Cooperator Non-Cash Contributions ONLY: EXAMPLE Column (c): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (c)
Cooperator
Noncash Contribution










Cooperator In-Kind Contributions ONLY: EXAMPLE Column (d): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (d)
Cooperator
Third Party
In-Kind
Contribution



Sheet 8: V.3. Multiple Cooperators

Attachment:










USFS Agreement No.:
Mod. No.:





Cooperator Agreement No.:


















Note: This Financial Plan may be used when:
(1) No program income is expected and
(2) The Cooperator is not giving cash to the FS and
(3) There is no other Federal funding
































Agreements Financial Plan (Short Form)

Financial Plan Matrix: Note: All columns may not be used. Use depends on source and type of contribution(s).








FOREST SERVICE CONTRIBUTIONS ashleejackson: You can edit this cell to include the Cooperator's name. COOPERATOR 1 CONTRIBUTIONS ashleejackson: You can edit this cell to include the Cooperator's name. COOPERATOR 2 CONTRIBUTIONS



(a) Forest Service Noncash Contribution: Forest Service noncash contributions may consist of employee salaries, overhead (indirect), travel provided, and/or equipment and supplies purchased and provided to the Cooperator for use in the project. These costs are an expense to the Forest Service, but do not include funding for reimbursement of Cooperator expenses. (a) (b) Forest Service Cash to Cooperator: This is the maximum amount of funding that will be reimbursed or advanced by the Forest Service to the Cooperator. This is an expense to the Forest Service. This language can be edited to specify the Cooperator. (b) (c) Cooperator Noncash Contribution: These are expenses the Cooperator incurs that are contributed to the project in lieu of cash, but for which costs are incurred, such as employee salaries, overhead (indirect costs), travel, equipment, supplies, and so forth. These do not include in-kind contributions from third parties, such as donations from other entities or volunteer labor. All the costs listed here are an expense to the Cooperator. (c) (d) Cooperator, Third Party In-Kind Contribution: In-kind contribution provided to the Cooperator from a third party organization(s) for use in the project for which the Cooperator has incurred no expense. Value assessed for volunteer labor and donated materials, equipment and supplies should be valued based on FSH 1509.11, Ch. 70. These values are not reimbursable and can only be used to satisfy the Cooperator's matching requirement. Display these contributions by Cost Element Expenditures. (d) (e) Cooperator Noncash Contribution: These are expenses the Cooperator incurs that are contributed to the project in lieu of cash, but for which costs are incurred, such as employee salaries, overhead (indirect costs), travel, equipment, supplies, and so forth. These do not include in-kind contributions from third parties, such as donations from other entities or volunteer labor. All the costs listed here are an expense to the Cooperator. (e) (f) Cooperator, Third Party In-Kind Contribution: In-kind contribution provided to the Cooperator from a third party organization(s) for use in the project for which the Cooperator has incurred no expense. Value assessed for volunteer labor and donated materials, equipment and supplies should be valued based on FSH 1509.11, Ch. 70. These values are not reimbursable and can only be used to satisfy the Cooperator's matching requirement. Display these contributions by Cost Element Expenditures. (f)




Cash






COST ELEMENTS Noncash to Noncash In-Kind Noncash In-Kind (e) Total Project Value: The sum of all the values provided toward the project. This figure reflects the true estimated cost of the project. (g)
Total


Direct Costs
Cooperator





Salaries/Labor





$0.00

Travel





$0.00

Equipment





$0.00

Supplies/Materials





$0.00

Printing





$0.00

This cost element can be replaced with a cost element unique to your agreement, for example 'sub-contracts'. Other





$0.00

This cost element can be replaced with a cost element unique to your agreement. Other





$0.00

Subtotal $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Coop Indirect Costs





$0.00

FS Overhead Costs





$0.00

Total $0.00 $0.00 $0.00 $0.00 $0.00 $0.00


Total Project Value:

$0.00











Matching Costs Determination






Total Forest Service Share = (h)






(a+b) ÷ (g) = (h)
#DIV/0!
















Total Cooperator Share
(i)






(c+d+e+f) ÷ (g) = (i)
#DIV/0!
















Total (h+i) = (j)
(j)








#DIV/0!





2. Cost Analysis:








Use the following section to show additional information that supports the lump sum figures provided above. The following Cost Analysis boxes, (a)-(d), should provide a cost analysis of the corresponding matrix columns, (a)-(d), above, e.g. matrix column (a) FS Non-Cash Contribution should be analyzed under block (a), below, and matrix column (b) FS In-Kind Contribution should be analyzed under block (b), below, etc. Furthermore, each cost analysis box, below, should have clear labels indicating which cost element, above, is being analyzed, e.g. Salary/Labor = hrs or days x rate; Travel = miles x rate, or months x FOR rate (that is, days x per diem rate; Equipment Use = hrs or days x rate; Supplies & Materials--list of items and estimated cost; Printing = estimated cost per item; Indirect Cost = Direct cost x current indirect rate.











If necessary, add additional sheets for cost analysis. To compress any unwanted portion(s) of this section, highlight the section to be hidden, then select "Format", "Row", and "Hide" from the toolbar.

FS Non-Cash Contributions ONLY: EXAMPLE Column (a): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (a)
Forest Service
Noncash Contribution





















FSDefaultUser: FS Obligation to Pay Cooperator ONLY: EXAMPLE Column (b): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (b)
Forest Service Cash to Cooperator












FSDefaultUser: Cooperator Non-Cash Contributions ONLY: EXAMPLE Column (c): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (c)
Cooperator
Noncash Contribution












Cooperator In-Kind Contributions ONLY: EXAMPLE Column (d): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (d)
Cooperator
Third Party
In-Kind
Contribution






















FSDefaultUser: Cooperator Non-Cash Contributions ONLY: EXAMPLE Column (e): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (e)
Cooperator
Noncash Contribution












Cooperator In-Kind Contributions ONLY: EXAMPLE Column (f): Salary: GS 11 Biologist @ 40 hrs x $25.02/hr = $1,000.80, GS 5 Crew Leader @ 80 hrs x $12.79/hr = $1,023.20, GS 3 Crew 3 x 80hrs x $10.19/hr = $2445.60; Travel: 12 round trips x 50 miles x $.375/mi. = $225; Indirect Cost: $4,694.60 x 19.2% = $901.36 Column (f)
Cooperator
Third Party
In-Kind
Contribution

File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2022 OMB.report | Privacy Policy