{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Form","Instructions","Dropdown List1","Dropdown List"],"not_rendered":{"charts":0,"images":2,"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":77,"n_cols":24,"rows_kept":77,"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],[13,23,13,26],[45,23,45,26],[68,0,68,11],[70,0,70,11],[72,0,72,11],[45,18,45,19],[74,0,74,11],[69,0,69,26],[14,18,14,19],[15,18,15,19],[16,18,16,19],[17,18,17,19],[18,18,18,19],[19,18,19,19],[20,18,20,19],[21,18,21,19],[22,18,22,19],[23,18,23,19],[24,18,24,19],[25,18,25,19],[26,18,26,19],[27,18,27,19],[28,18,28,19],[29,18,29,19],[30,18,30,19],[31,18,31,19],[32,18,32,19],[33,18,33,19],[34,18,34,19],[35,18,35,19],[36,18,36,19],[37,18,37,19],[38,18,38,19],[39,18,39,19],[40,18,40,19],[41,18,41,19],[42,18,42,19],[43,18,43,19],[44,18,44,19],[48,18,48,19],[49,18,49,19],[50,18,50,19],[51,18,51,19],[52,18,52,19],[53,18,53,19],[54,18,54,19],[55,18,55,19],[56,18,56,19],[57,18,57,19],[58,18,58,19],[64,18,64,19],[65,18,65,19],[66,18,66,19],[67,18,67,19],[59,18,59,19],[60,18,60,19],[61,18,61,19],[62,18,62,19],[63,18,63,19]]}
[]
[]
[]
[]
[]
[]
["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 or Grantee.  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 or Grant 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\n(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,null,"=",{"$f":"L15*N15","v":0}]
[null,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,null,"=",0]
[null,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,null,"=",0]
[null,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,"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,null,"=",{"$f":"L28*N28","v":0}]
[null,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,null,"=",{"$f":"L30*N30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Contractual Services",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,null,"]","=",{"$f":"(F35*H35)+(L35*N35)","v":0}]
[null,null,null,null,"[",null,"*",null,"]","+","[",null,null,null,"]","=",{"$f":"(F36*H36)+(L36*N36)","v":0}]
[null,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,null,"=",{"$f":"L42*N42","v":0}]
[null,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,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\n(Basis for Decision)"]
["5. Supplies"]
[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,null,"=",{"$f":"L49*N49","v":0}]
[null,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,null,"=",{"$f":"L51*N51","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Supplies",null,null,{"$f":"SUM(Q49:Q51)","v":0}]
[]
["6.  Miscellaneous/Other Expenses"]
[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,null,"=",{"$f":"L56*N56","v":0}]
[null,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,null,"=",{"$f":"L58*N58","v":0}]
[null,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,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)"]
[]
["7.  Overhead/Indirect",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,null,"*",null,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:___________________________________________________________________________"]

{"sheet":"Instructions","index":1,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[[7,0,7,25],[10,1,10,25],[14,1,14,25],[12,1,12,25],[8,0,8,25],[42,1,42,21],[44,1,44,25],[46,1,46,21],[48,1,48,25],[16,1,16,25],[34,1,34,25],[36,1,36,25],[38,1,38,25],[40,1,40,21],[32,1,32,25],[23,1,23,25],[33,0,33,2],[20,1,21,25],[28,0,28,25],[30,0,30,25]]}
[]
[]
[]
[]
[]
[]
[]
["BUDGET INSTRUCTIONS"]
["A detailed budget is required for any contract (excluding any non-competitively awarded contracts under the Category II threshold) or grant agreement. For cost-reimbursement, fee-schedule contracts or grant agreements the budget must outline the maximum amount needed for each line item. For fixed price contracts, the budget shall outline the minimum amount for each line item. The budget detail should only list the total price funded by the Department or the total project budget when the Department is paying a percentage of the project total. The Department reserves the right to require additional information when necessary for approval of the fixed price, and to require that any part of the project be compensated on a cost-reimbursement basis. Attach a separate sheet to provide any explanation of travel, equipment (especially computers), subcontracts, and other supporting information using the same format and totals used on this form. Breakdowns by task or phase, or other division of work, should be shown on the separate attachment and should provide, at a minimum, the same information and level of detail. "]
[]
[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 $5,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"]
[]
["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 file to support the conclusions reached as shown on this form."]
[]
[9,"For contracts prepared by the Procurement Section, this completed, signed form must be submitted with the Contract 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."]

{"sheet":"Dropdown List1","index":2,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
["Choices"]
["Yes"]
["No"]

{"sheet":"Dropdown List","index":3,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
["Choices"]
["Yes"]
["No"]