FS-1500-NEW11B Financial Plan B

Federal and Non-Federal Financial Assistance Instruments

fs_1500_NEW11B.xls

State, Local, and Tribal Govt. - Federal and Non-Federal Financial Assistance Instruments

OMB: 0596-0217

Document [xlsx]
Download: xlsx | pdf

Overview

Financial Plan-Short Form-Vert
Financial Plan-Short Form-Horiz


Sheet 1: Financial Plan-Short Form-Vert

USFS Agreement No.:
Mod. No.

Cooperator Agreement No.:










Agreements Financial Plan (Short Form)
1. Financial Plan Matrix:





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

FOREST SERVICE CONTRIBUTIONS COOPERATOR CONTRIBUTIONS


FSDefaultUser: (a) Forest Service Non-Cash Contribution: Forest Service employee salaries, travel, equipment, supplies, etc., provided toward completion of the project. Total Forest Service indirect cost (overhead) is also included in this column. All the costs listed here are an expense to the Forest Service. (a) FSDefaultUser: (c) Reimbursable Cooperator Expenses: The figure(s) listed are both the maximum Forest Service funds to be obligated for reimbursement and Cooperator expenses that are not included anywhere else on this form. This is an expense to the Forest Service. (b) FSDefaultUser: Forest Service Noncash Contribution. Forest Service noncash contributions may consist of employee salaries, overhead, 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. (c) FSDefaultUser: (e) Value of Cooperator In-Kind Contribution: Cooperator non-cash contributions provided toward completion of the project for which the Cooperator has incurred no expense. These contributions can be made from the Cooperator or through the Cooperator by other entities and include such items as volunteer labor, donated materials, equipment, supplies, etc. These values are not reimbursable and can only be used to satisfy the Cooperator's matching requirement. (d)



Reimb.



COST ELEMENTS Non-Cash Coop. Non-Cash In-Kind (e)
Total

Direct Costs
Expenses


Salaries/Labor



$0.00
Travel



$0.00
Equipment Use



$0.00
Supplies



$0.00
Materials



$0.00
Printing



$0.00
FSDefaultUser: This cost element can be replaced with a cost element unique to your agreement. Other


$25.00 $25.00

$0.00 $0.00 $0.00 $25.00 $25.00
Indirect Costs



$0.00
Total $0.00 $0.00 $0.00 $25.00

Total Project Value: $25.00







Matching Costs Determination



Total Forest Service Share =
(f)



(a+b) ÷ (e) = (f)
0.00%

















Total Cooperator Share
(g)



(c+d) ÷ (e) = (g)
100.00%

















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





100.00%
























Reimbursement Calculation
Forest Service reimbursement percent (as % of expenses directly incurred by the Cooperator-- i.e., Cooperator's non-cash contributions only -- that are subject to Forest Service reimbursement)

(b) ÷ (b+c) = (i)



(i)





#DIV/0!
Cooperator expenses not reimbursed by Forest Service
(j)
(c) ÷ (c+d) = (j)



#DIV/0!







Reimbursable Amount = Total actual cost incurred to date (sum of cost elements from the Cooperator's invoice as





prescribed in agreement provisions

and
multiplied by
#DIV/0! (u) minus any previous Forest Service payments, not to exceed the subtotal amount listed in




column (c) minus any estimated program income.)





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) 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, that is being analyzed, e.g. Salary/Labor = hrs or days x rate; Travel = miles x rate or months x FOR rate, 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.




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 (a)
























(b)
























(c)
























EXAMPLE Column (d): Salary G&F Habitat Biologist 40 hrs. x $18/hr = $720; Travel: 200 mi. x $.375 = $75 + 5 days field per diem x $30/day = $150 (d)


























3. Instructions: Use this form in conjunction with ID 1509.11-2007-1.






Use Cost Elements that apply to the particular project. The Cost Elements listed are examples of those commonly used. Delete those that don't apply. Value assessed for volunteer labor should be commensurate with local labor rates for similar work. Donated materials, equipment and supplies should be valued at rates and prices available in the current local market.








(a) Forest Service Non-Cash Contribution: Forest Service employee salaries, travel, equipment, supplies, etc., provided toward completion of the project. Total Forest Service indirect cost (overhead) is also included in this column. All the costs listed here are an expense to the Forest Service.








(b) Reimbursable Cooperator Expenses: The figure(s) listed are both the maximum Forest Service funds to be obligated for reimbursement and Cooperator expenses that are not included anywhere else on this form. This is an expense to the Forest Service.








(c) Cooperator Non-Cash Contribution: Cooperator employee salaries, travel, equipment, supplies, etc., provided toward completion of the project. Total Cooperator indirect cost (overhead) is also included in this column. All the costs listed here are an expense to the Cooperator.








(d) Value of Cooperator In-Kind Contribution: Cooperator non-cash contributions provided toward completion of the project for which the Cooperator has incurred no expense. These contributions can be made from the Cooperator or through the Cooperator by other entities and include such items as volunteer labor, donated materials, equipment, supplies, etc. These values are not reimbursable and can only be used to satisfy the Cooperator's matching requirement.








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
















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-New. The time required to complete this information collection is estimated to average 1 hour 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: Financial Plan-Short Form-Horiz




USFS Agreement No.:


Mod. No.



Cooperator Agreement No.:















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








FOREST SERVICE CONTRIBUTIONS COOPERATOR CONTRIBUTIONS





FSDefaultUser: (a) Forest Service Non-Cash Contribution: Forest Service employee salaries, travel, equipment, supplies, etc., provided toward completion of the project. Total Forest Service indirect cost (overhead) is also included in this column. All the costs listed here are an expense to the Forest Service. (a) FSDefaultUser: (c) Reimbursable Cooperator Expenses: The figure(s) listed are both the maximum Forest Service funds to be obligated for reimbursement and Cooperator expenses that are not included anywhere else on this form. This is an expense to the Forest Service. (b) FSDefaultUser: Forest Service Noncash Contribution. Forest Service noncash contributions may consist of employee salaries, overhead, 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. (c) FSDefaultUser: (e) Value of Cooperator In-Kind Contribution: Cooperator non-cash contributions provided toward completion of the project for which the Cooperator has incurred no expense. These contributions can be made from the Cooperator or through the Cooperator by other entities and include such items as volunteer labor, donated materials, equipment, supplies, etc. These values are not reimbursable and can only be used to satisfy the Cooperator's matching requirement. (d)






Reimb.






COST ELEMENTS Non-Cash Coop. Non-Cash In-Kind (e)
Total




Direct Costs
Expenses





Salaries/Labor



$0.00



Travel



$0.00



Equipment Use



$0.00



Supplies



$0.00



Materials



$0.00



Printing



$0.00



FSDefaultUser: 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



Indirect Costs



$0.00



Total $0.00 $0.00 $0.00 $0.00




Total Project Value: $0.00












Matching Costs Determination Reimbursement Calculation
Total Forest Service Share = (f) Forest Service reimbursement percent (as % of expenses directly incurred by the Cooperator-- i.e., Cooperator's non-cash contributions only -- that are subject to Forest Service reimbursement)
(a+b) ÷ (e) = (f)
#DIV/0!



(b) ÷ (b+c) = (i)




(i)









#DIV/0!
Total Cooperator Share
(g) Cooperator expenses not reimbursed by Forest Service

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




#DIV/0!













Reimbursable Amount = Total actual cost incurred to date (sum of cost elements from the Cooperator's





Total (f+g) = (h)
(g) invoice as prescribed in agreement provisions



and multiplied by


#DIV/0! #DIV/0! (u) minus any previous Forest Service payments, not to exceed the subtotal amount







listed in column (c) minus any estimated program income.)

























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) 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, that is being analyzed, e.g. Salary/Labor = hrs or days x rate; Travel = miles x rate or months x FOR rate, 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.


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 (a)
(a)















(b)















(c)















EXAMPLE Column (d): Salary G&F Habitat Biologist 40 hrs. x $18/hr = $720; Travel: 200 mi. x $.375 = $75 + 5 days field per diem x $30/day = $150 (d)















3. Instructions: Use this form in conjunction with ID 1509.11-2007-1.









Use Cost Elements that apply to the particular project. The Cost Elements listed are examples of those commonly used. Delete those that don't apply. Value assessed for volunteer labor should be commensurate with local labor rates for similar work. Donated materials, equipment and supplies should be valued at rates and prices available in the current local market.











(a) Forest Service Non-Cash Contribution: Forest Service employee salaries, travel, equipment, supplies, etc., provided toward completion of the project. Total Forest Service indirect cost (overhead) is also included in this column. All the costs listed here are an expense to the Forest Service.











(b) Reimbursable Cooperator Expenses: The figure(s) listed are both the maximum Forest Service funds to be obligated for reimbursement and Cooperator expenses that are not included anywhere else on this form. This is an expense to the Forest Service.











(c) Cooperator Non-Cash Contribution: Cooperator employee salaries, travel, equipment, supplies, etc., provided toward completion of the project. Total Cooperator indirect cost (overhead) is also included in this column. All the costs listed here are an expense to the Cooperator.











(d) Value of Cooperator In-Kind Contribution: Cooperator non-cash contributions provided toward completion of the project for which the Cooperator has incurred no expense. These contributions can be made from the Cooperator or through the Cooperator by other entities and include such items as volunteer labor, donated materials, equipment, supplies, etc. These values are not reimbursable and can only be used to satisfy the Cooperator's matching requirement.











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























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-New. The time required to complete this information collection is estimated to average 1 hour 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.
File Typeapplication/vnd.ms-excel
AuthorFSDefaultUser
Last Modified ByFSDefaultUser
File Modified2008-09-15
File Created2007-01-22

© 2024 OMB.report | Privacy Policy