{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Financial Plan-Short Form-Vert","Financial Plan-Short Form-Horiz"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":14,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Financial Plan-Short Form-Vert","index":0,"n_rows":118,"n_cols":6,"rows_kept":118,"cut":false,"hidden":false,"merged":[[53,1,55,5],[42,0,42,3],[49,0,49,1],[38,0,39,5],[50,0,51,5],[100,1,100,5],[56,1,64,5],[66,1,74,5],[76,1,84,5],[86,1,95,5],[98,1,98,5],[102,1,102,5],[104,1,104,5],[106,1,106,5],[108,1,108,5],[0,0,0,1],[1,0,1,1],[0,2,0,3],[1,2,1,3],[37,0,37,5],[3,0,3,5],[5,1,5,5],[9,5,10,5],[23,0,23,2],[21,0,21,4],[4,0,4,1],[6,1,6,2],[6,3,6,4],[113,0,113,5],[115,0,115,5],[117,0,117,5],[111,2,111,3],[114,0,114,5],[116,0,116,5]],"flags":["formulas_cached_only"]}
["USFS Agreement No.:",null,null,null,"Mod. No."]
["Cooperator Agreement No.:"]
[]
["Agreements Financial Plan (Short Form)"]
["1. Financial Plan Matrix:"]
[null,"Note: All columns may not be used. Use depends on source and type of contribution(s)."]
[null,"FOREST SERVICE CONTRIBUTIONS",null,"COOPERATOR CONTRIBUTIONS"]
[null,"(a) ","(b)","(c)","(d)"]
[null,null,"Reimb."]
["COST ELEMENTS","Non-Cash","Coop.","Non-Cash","In-Kind ","(e)\nTotal"]
["Direct Costs",null,"Expenses"]
["Salaries/Labor",{"$nulls":4},0]
["Travel",{"$nulls":4},0]
["Equipment Use",{"$nulls":4},0]
["Supplies",{"$nulls":4},0]
["Materials",{"$nulls":4},0]
["Printing",{"$nulls":4},0]
["Other",null,null,null,25,25]
[null,0,0,0,25,25]
["Indirect Costs",{"$nulls":4},0]
["Total",0,0,0,25]
["Total Project Value:",{"$nulls":4},25]
[]
["Matching Costs Determination"]
["Total Forest Service Share =",null,"(f)"]
["(a+b) ÷ (e) = (f)",null,0]
[]
[]
["Total Cooperator Share",null,"(g)"]
["(c+d) ÷ (e) = (g)",null,1]
[]
[]
["Total (f+g) = (h)",null,"(g)"]
[null,null,1]
[]
[]
[]
["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)",{"$nulls":4},"(i)"]
[{"$nulls":5},{"$error":"#DIV/0!"}]
["Cooperator expenses not reimbursed by Forest Service",{"$nulls":4},"(j)"]
["(c) ÷ (c+d) = (j)",{"$nulls":4},{"$error":"#DIV/0!"}]
[]
["Reimbursable Amount = Total actual cost incurred to date (sum of cost elements from the Cooperator's invoice as  "]
["prescribed in agreement provisions ",null,null,"and",null,"multiplied  by"]
[{"$error":"#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."]
[]
[]
[null,"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."]
[]
[]
["(a)"]
{"$rows_empty":9}
["(b)"]
{"$rows_empty":9}
["(c)"]
{"$rows_empty":9}
["(d)"]
{"$rows_empty":10}
["3. Instructions:   Use this form in conjunction with ID 1509.11-2007-1."]
[null,"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."]
[]
[null,"(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."]
[]
[null,"(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."]
[]
[null,"(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."]
[]
[null,"(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."]
[]
[null,"(e) Total Project Value:   The sum of all the values provided toward the project.  This figure reflects the true estimated cost of the project."]
[]
[]
[null,null,"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":"Financial Plan-Short Form-Horiz","index":1,"n_rows":91,"n_cols":10,"rows_kept":91,"cut":false,"hidden":false,"merged":[[0,5,0,6],[1,5,1,6],[3,1,3,8],[22,0,22,2],[22,3,22,9],[4,0,4,1],[20,1,20,5],[23,0,23,1],[23,3,24,9],[27,3,27,6],[36,0,36,1],[75,1,75,8],[37,1,37,8],[41,1,47,9],[49,1,54,9],[39,1,40,8],[81,1,81,8],[8,6,9,6],[5,2,5,3],[5,4,5,5],[56,1,61,9],[63,1,68,9],[77,1,77,8],[79,1,79,8],[71,1,71,8],[73,1,73,8],[86,0,86,8],[88,0,88,8],[90,0,90,8],[84,3,84,4],[87,0,87,8],[89,0,89,8]],"flags":["formulas_cached_only"]}
[null,null,null,"USFS Agreement No.:",{"$nulls":4},"Mod. No."]
[null,null,null,"Cooperator Agreement No.:"]
[]
[null,"Agreements Financial Plan (Short Form)"]
["1. Financial Plan Matrix:",null,"Note: All columns may not be used. Use depends on source and type of contribution(s)."]
[null,null,"FOREST SERVICE CONTRIBUTIONS",null,"COOPERATOR CONTRIBUTIONS"]
[null,null,"(a) ","(b)","(c)","(d)"]
[null,null,null,"Reimb."]
[null,"COST ELEMENTS","Non-Cash","Coop.","Non-Cash","In-Kind ","(e)\nTotal"]
[null,"Direct Costs",null,"Expenses"]
[null,"Salaries/Labor",{"$nulls":4},0]
[null,"Travel",{"$nulls":4},0]
[null,"Equipment Use",{"$nulls":4},0]
[null,"Supplies",{"$nulls":4},0]
[null,"Materials",{"$nulls":4},0]
[null,"Printing",{"$nulls":4},0]
[null,"Other",{"$nulls":4},0]
[null,"Subtotal",0,0,0,0,0]
[null,"Indirect Costs",{"$nulls":4},0]
[null,"Total",0,0,0,0]
[null,"Total Project Value:",{"$nulls":4},0]
[]
["Matching Costs Determination",null,null,"Reimbursement Calculation"]
["Total Forest Service Share =",null,"(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)",null,{"$error":"#DIV/0!"}]
[null,null,null,"(b) ÷ (b+c) = (i)",{"$nulls":5},"(i)"]
[{"$nulls":9},{"$error":"#DIV/0!"}]
["Total Cooperator Share",null,"(g)","Cooperator expenses not reimbursed by Forest Service",{"$nulls":5},"(j)"]
["(c+d) ÷ (e) = (g)",null,{"$error":"#DIV/0!"},"(c) ÷ (c+d) = (j)",{"$nulls":5},{"$error":"#DIV/0!"}]
[]
[null,null,null,"Reimbursable Amount = Total actual cost incurred to date (sum of cost elements from the Cooperator's  "]
["Total (f+g) = (h)",null,"(g)","invoice as prescribed in agreement provisions ",{"$nulls":4},"and","multiplied  by"]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"(u) minus any previous Forest Service payments, not to exceed the subtotal amount "]
[null,null,null," listed in column (c) minus any estimated program income.)"]
[]
[]
["2. Cost Analysis:"]
[null,"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."]
[]
[null,"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."]
[]
["(a)"]
["(a)"]
[]
[]
[]
[]
[]
[]
["(b)"]
[]
[]
[]
[]
[]
[]
["(c)"]
[]
[]
[]
[]
[]
[]
["(d)"]
[]
[]
[]
[]
[]
[]
["3. Instructions:   Use this form in conjunction with ID 1509.11-2007-1."]
[null,"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."]
[]
[null,"(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."]
[]
[null,"(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."]
[]
[null,"(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."]
[]
[null,"(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."]
[]
[null,"(e) Total Project Value:   The sum of all the values provided toward the project.  This figure reflects the true estimated cost of the project."]
[]
[]
[null,null,null,"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."]