{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Budget Cost Analysis Form"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":"Budget Cost Analysis Form","index":0,"n_rows":77,"n_cols":23,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[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. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"See attached instructions."]
["1.  PERSONNEL EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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)"]
[]
["2.  Supplies"]
[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":"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.  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":"L35*N35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L36*N36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"*",null,null,"=",{"$f":"L37*N37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Equipment",null,null,{"$f":"SUM(Q35:Q37)","v":0}]
[]
["4.  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":"(F42*H42)+(L42*N42)","v":0}]
[null,null,null,null,"[",null,"*",null,"]","+","[",null,"*",null,"]","=",{"$f":"(F43*H43)+(L43*N43)","v":0}]
[null,null,null,null,"[",null,"*",null,"]","+","[",null,"*",null,"]","=",{"$f":"(F44*H44)+(L44*N44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Travel",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,null,"Allowable","Reasonable","Necessary","COMMENTS                                                (Basis for Decision)"]
["5.  Contractual"]
[null,"Name or Services",null,null,null,null,null,null,null,null,null,"Fee/Rate $",null,"Hours",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"]
[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":"Q21+Q31+Q38+Q45+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 attached evidencing the methodology used and the conclusions reached."]
["Name:_______________________________________________________________"]
[]
["Signature:____________________________________________________________"]
[]
["Date:___________________________________________________________________________"]
["BGS DEP 55-229",null,null,"Effective 2-3-2014",null,null,"BGS DEP 55-229",null,null,"Effective 2-3-2014"]