{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Form","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Form","index":0,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[10,19,10,26],[8,0,8,16],[8,19,8,26],[12,23,12,26],[5,1,5,5],[5,7,5,9],[6,0,6,26],[12,18,12,19],[76,0,76,2],[45,23,45,26],[69,0,69,22],[68,0,68,11],[70,0,70,11],[72,0,72,11],[45,18,45,19],[74,0,74,11],[25,23,29,26],[14,23,22,26],[53,23,59,26]]}
[]
[]
[]
[]
[]
[null,"Required Signatures:",null,null,null,null,null,"Original Ink"]
["PROJECT TITLE:_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________"]
[]
["BUDGET DETAIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST ANALYSIS"]
[]
["Budget items below to be provided by the Contractor.  See attached instructions.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Analysis to be completed by the Department Contract Manager. See attached instructions."]
[]
["1.  PERSONNEL EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Allocation",null,"Allowable","Reasonable","Necessary","COMMENTS                                                (Basis for Decision)"]
[null,"A.  Salaries - (Name/Title/Position)",null,null,null,null,null,null,null,null,null,"Hourly Cost ($)",null,"Hours",null,null,"Totals ($)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L15*N15","v":0},null,null,null,null,null,null,"This project was determined to be allowable under the guidance of 23 CFR 206 and §62S-2. All costs have been deemed reasonable and allowable, and are considered necessary in enhancing Florida's recreational trail system."]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Salaries",null,null,{"$f":"SUM(Q15:Q20)","v":0}]
[null,"B.  Fringe Benefits (Rate% * Total salaries applicable)",null,null,null,null,null,null,null,null,null,"Rate %",null,"Total Sal. App.",null,null,"Total $"]
[null,null,null,null,null,null,null,null,null,null,null,0,"*",0,null,null,{"$f":"SUM(L23*N23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Personnel Expenses (A+B)",null,null,{"$f":"Q21+Q23","v":0}]
[]
["2. Contractual Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This project was determined to be allowable under the guidance of 23 CFR 206 and §62S-2. All costs have been deemed reasonable and allowable, and are considered necessary in enhancing Florida's recreational trail system."]
[null,"Description",null,null,null,null,null,null,null,null,null,"Fee/Rate $",null,"Quantity",null,null,"Totals $"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L28*N28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L29*N29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L30*N30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Supplies",null,null,{"$f":"SUM(Q28:Q30)","v":0}]
[]
["3.  Travel",null,null,null,null,null,null,"Per",null,null,null,"Fare/"]
[null,"Purpose/Destination",null,null,null,"Days",null,"Diem $",null,null,null,"Rate $",null,"Mileage",null,null,"Totals $"]
[null,null,null,null,"[",null,"*",null,"]","+","[",null,"*",null,"]","=",{"$f":"(F35*H35)+(L35*N35)","v":0}]
[null,null,null,null,"[",null,"*",null,"]","+","[",null,"*",null,"]","=",{"$f":"(F36*H36)+(L36*N36)","v":0}]
[null,null,null,null,"[",null,"*",null,"]","+","[",null,"*",null,"]","=",{"$f":"(F37*H37)+(L37*N37)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Travel",null,null,{"$f":"SUM(Q35:Q37)","v":0}]
[]
["4.  Equipment"]
[null,"Description",null,null,null,null,null,null,null,null,null,"Unit Cost $",null,"Quantity",null,null,"Totals $"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L42*N42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L43*N43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L44*N44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Equipment",null,null,{"$f":"SUM(Q42:Q44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Allocation",null,"Allowable","Reasonable","Necessary","COMMENTS                                                (Basis for Decision)"]
["5. Rental/Lease of Equipment"]
[null,"Description",null,null,null,null,null,null,null,null,null,"Fee/Rate $",null,"Quantity",null,null,"Totals $"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L49*N49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L50*N50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L51*N51","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Contractual",null,null,{"$f":"SUM(Q49:Q51)","v":0}]
[]
["6.  Miscellaneous/Other Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This project was determined to be allowable under the guidance of 23 CFR 206 and §62S-2. All costs have been deemed reasonable and allowable, and are considered necessary in enhancing Florida's recreational trail system."]
[null,"Description",null,null,null,null,null,null,null,null,null,"Unit Cost $",null,"Quantity",null,null,"Totals $"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L56*N56","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L57*N57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L58*N58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L59*N59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L60*N60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Miscellaneous",null,null,{"$f":"SUM(Q56:Q60)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAL (1 thru 6)",null,null,{"$f":"Q24+Q31+Q45+Q38+Q52+Q61","v":0}]
[]
["7.  Overhead/Indirect  - Base: _____________________________",null,null,null,null,null,null,null,null,null,null,"Rate %",null,"Base $",null,null,"Total $"]
[null,null,null,null,null,null,null,null,null,null,null,0,"*",0,null,"=",{"$f":"SUM(L66*N66)","v":0}]
[]
["8.  Total Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"SUM(Q63+Q66)","v":0}]
["CERTIFICATION"]
["I certify that the cost for each line item budget category has been evaluated and determined to be allowable, reasonable, and necessary as required by Section 216.3475, Florida Statutes.  Documentation is on file evidencing the methodology used and the conclusions reached."]
["Name:_______________________________________________________________"]
[]
["Signature:____________________________________________________________"]
[]
["Title:_______________________________________________________________"]
[]
["Date:___________________________________________________________________________"]
[]
["BGS DEP 55-229",null,null,"Effective 8-30-2016"]

{"sheet":"Instructions","index":1,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":false,"merged":[[7,0,7,25],[8,0,15,25],[17,1,17,25],[21,1,21,25],[19,1,19,25],[49,1,49,21],[51,1,51,25],[53,1,53,21],[55,1,55,25],[23,1,23,25],[41,1,41,25],[43,1,43,25],[45,1,45,25],[47,1,47,21],[39,1,39,25],[30,1,30,25],[40,0,40,2],[27,1,28,25],[35,0,35,25],[37,1,37,25]]}
[]
[]
[]
[]
[]
[]
[]
["BUDGET INSTRUCTIONS"]
["A detailed budget is required for DEP fixed price contracts; however, this form shall also be used for determining the maximum amount needed under cost-reimbursement and fee-schedule contracts and to complete the required cost analysis for non-competitively awarded contracts over the Category II threshold.  For fixed price contracts, this budget form is intended to provide the minimum information needed for budget approval. The DEP reserves the right to require additional information when necessary for approval of the fixed price, and also to require that any part of the project be compensated on a cost-reimbursement basis. Attach a separate sheet to provide an explanation of travel, equipment (especially computers), subcontracts, and other supporting information, and when needed for extra space (use same format and show totals on this form). This form should list the total fixed price to be funded by DEP, or the total project budget when the DEP is to pay a percentage of the project total. Breakdowns by task or phase, or other division of work, should be shown on the separate attachment. The use of this particular form is not a requirement for the budget, however any other budget form or format used should provide, at a minimum, the same information and level of detail.  This form is required for completion of the cost analysis."]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"PERSONNEL - A. Salaries - Identify the persons to be compensated for work on this project by name (if known), position, and title. Show the hourly cost and total hours to be charged for each person or position. If more space is needed, use a separate sheet to list individual positions and salaries, and show here the total hours for each title or position. Divide annual salaries by 2080 hours, and nine month academic salaries by 1560 hours, to find the hourly rate.  B. Fringe Benefits - Multiply the rate by the total salaries to which fringe benefits apply. If the rate is variable, explain and show calculations on an attachment. "]
[]
[2,"CONTRACTUAL SERVICES - Subcontractors should provide the same information required by this budget form, with the following exceptions: (a) when professional services are provided at a pre-existing approved rate or fee shown on the budget; or (b) the subcontract is to be obtained competitively. For either (a) or (b), show an estimated maximum amount and provide an attached explanation as to how it was or will be determined. Contractual services other than fixed price will be compensated by the DEP on a cost-reimbursement basis. "]
[]
[3,"TRAVEL - List trips by their purpose and/or destination. Unless travel details are included in the Scope of Services, a separate narrative should be attached. Indicate the number of days for each trip and the per diem. Keep in mind the DEP can only pay for travel at the approved State rate (Section 112.061, Florida Statutes). Use \"Fare/Rate\" for mileage rate and multiply by \"Mileage\", or for travel fare and leave \"Mileage\" blank."]
[]
[4,"EQUIPMENT - List non-expendable personal property/equipment valued at $1,000 or more that will be directly purchased by description, unit cost, and quantity. Computers and data-processing equipment should be described in detail in an attached explanation."]
[]
[5,"SUPPLIES - List expendable supplies by category description, unit costs and quantity."]
[]
[6,"MISCELLANEOUS/OTHER EXPENSES - List miscellaneous and/or expenses not included in any of the above categories, by category description, unit costs and quantity. Examples may include materials, supplies, printing, copying, postage, communications, signage, educational and instructional materials, etc. Non-expendable equipment valued at less than $1,000 may be listed also. Include only expenses directly related to the project, not expenses of a general nature."]
[]
[]
[7,"OVERHEAD/INDIRECT - Indicate the approved overhead/indirect cost rate, the dollar amount of the base to which it is applied, and the resulting total. Identify the base (cost categories) to which the rate is applied on the line indicated. "]
[]
[8,"TOTAL BUDGET - Show the total of categories 1 through 7."]
[]
[]
["COST ANALYSIS INSTRUCTIONS"]
[]
[null,"A cost analysis must be completed for any non-competitively procured agreement in excess of Category II, as well as any amendments that affect the amount of compensation and/or the level of services provided. "]
[]
[1,"Each separate line item must be evaluated to determine the cost allocation and whether the cost is allowable, reasonable and necessary.  Each miscellaneous cost must be specifically identified."]
[]
[2,"To be allocated to a program, a cost must be related to the services provided.  If the cost benefits more than one program, a determination must be made that the cost is distributed in a reasonable and consistent manner across all benefiting programs."]
[]
[3,"To be allowable, a cost must be allowable pursuant to state and federal expenditure laws, rules and regulations and authorized by the agreement between the state and the contractor/grantee."]
[]
[4,"To be reasonable, a cost must be evaluated to determine that the amount does not exceed what a prudent person would incur given the specific circumstances."]
[]
[5,"To be necessary, a cost must be essential to the successful completion of the project."]
[]
[6,"Indirect costs/overhead should be evaluated to determine that the rate is reasonable."]
[]
[7,"Once the analysis of each budget item has been completed, identify the percent allocated to this agreement and indicate (by Yes or No) in the boxes to the right if the cost is allowable, reasonable and necessary.  Use the comment box to provide comments on the basis for your decision."]
[]
[8,"Documentation must be maintained in the Contract/Grant Manager's files to support the conclusions reached as shown on this form."]
[]
[9,"For contracts/grants prepared by the Procurement Section, this completed, signed form must be submitted with the Contract or Grant Initiation Form.  For those grant agreements prepared from approved templates, this completed, signed form must be maintained in the grant file in the Program Area."]