{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Prime Budget","Other Orgs"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":13,"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":"Prime Budget","index":0,"n_rows":63,"n_cols":16,"rows_kept":63,"cut":false,"hidden":false,"merged":[[61,0,61,15],[62,0,62,15],[63,0,63,15],[18,4,18,5],[30,8,30,9],[48,8,48,9],[43,8,43,9],[18,10,18,11],[37,12,37,13],[38,12,41,12],[42,12,42,13],[30,12,30,13],[43,0,43,1],[57,0,57,1],[21,0,21,1],[23,0,23,1],[30,14,30,15],[59,0,59,1],[25,14,25,15],[21,14,23,14],[19,14,20,15],[48,0,48,1],[48,2,48,3],[43,2,43,3],[22,0,22,1],[25,0,25,1],[28,0,28,1],[29,0,29,1],[18,6,18,7],[52,0,52,1],[4,12,4,13],[18,12,18,13],[4,10,4,11],[5,10,5,11],[27,0,27,1],[5,0,5,1],[21,6,23,6],[21,8,23,8],[26,4,29,4],[26,6,29,6],[25,4,25,5],[25,6,25,7],[42,0,42,1],[42,2,42,3],[30,4,30,5],[25,2,25,3],[49,0,49,1],[24,0,24,1],[2,0,2,15],[4,14,4,15],[5,14,5,15],[4,0,4,1],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[18,0,18,1],[18,2,18,3],[4,6,4,7],[4,8,4,9],[5,12,5,13],[17,0,17,1],[18,14,18,15],[18,8,18,9],[4,2,4,5],[30,0,30,1],[58,0,58,1],[48,6,48,7],[44,6,47,6],[24,14,24,15],[26,14,29,14],[26,8,29,8],[25,8,25,9],[25,12,25,13],[26,12,29,12],[25,10,25,11],[26,10,29,10],[43,14,43,15],[43,12,43,13],[44,12,47,12],[44,4,47,4],[43,4,43,5],[43,6,43,7],[42,14,42,15],[37,6,37,7],[42,8,42,9],[37,14,37,15],[38,14,41,14],[38,4,41,4],[19,4,20,5],[21,2,23,2],[21,4,23,4],[24,6,24,7],[19,8,20,9],[24,8,24,9],[19,12,20,13],[21,12,23,12],[24,12,24,13],[19,10,20,11],[21,10,23,10],[24,10,24,11],[37,4,37,5],[42,4,42,5],[30,10,30,11],[59,2,59,3],[59,4,59,5],[59,6,59,7],[44,2,47,2],[37,10,37,11],[38,10,41,10],[42,10,42,11],[31,10,31,11],[36,10,36,11],[43,10,43,11],[59,14,59,15],[49,8,49,9],[49,2,49,3],[49,14,49,15],[59,10,59,11],[48,14,48,15],[44,10,47,10],[48,10,48,11],[49,10,49,11],[44,14,47,14],[44,8,47,8],[49,4,49,5],[49,6,49,7],[48,4,48,5],[59,12,59,13],[59,8,59,9],[48,12,48,13],[49,12,49,13],[19,0,20,1],[19,2,20,3],[24,2,24,3],[24,4,24,5],[26,0,26,1],[42,6,42,7],[37,8,37,9],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[36,0,36,1],[36,2,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[38,2,41,2],[37,2,37,3],[30,2,30,3],[30,6,30,7],[19,6,20,7],[26,2,29,2],[38,6,41,6],[38,8,41,8],[36,12,36,13],[36,14,36,15],[31,12,31,13],[31,14,31,15],[32,2,35,2],[32,4,35,4],[32,6,35,6],[32,8,35,8],[32,10,35,10],[32,12,35,12],[32,14,35,14]]}
[]
[]
["Prime Contract Budget Detail ACPTP Project No. _______________"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
["(a) Salaries and Wages (Prime)\n",null,"Task",null,"Task",null,"Task",null,"Task",null,"Task",null,"Task"]
["Name"," Hourly Rate","Hours","Cost","Hours","Cost","Hours","Cost","Hours","Cost","Hours","Cost","Hours","Cost","Hours","Cost"]
[null,0,null,{"$f":"+$B8*C8","v":0},null,{"$f":"+$B8*E8","v":0},null,{"$f":"+$B8*G8","v":0},null,{"$f":"+$B8*I8","v":0},null,{"$f":"+$B8*K8","v":0},null,{"$f":"+$B8*M8","v":0},{"$f":"C8+E8+G8+I8+K8+M8","v":0},{"$f":"B8*O8","v":0}]
[null,0,null,{"$f":"+$B9*C9","v":0},null,{"$f":"+$B9*E9","v":0},null,{"$f":"+$B9*G9","v":0},null,{"$f":"+$B9*I9","v":0},null,{"$f":"+$B9*K9","v":0},null,{"$f":"+$B9*M9","v":0},{"$f":"C9+E9+G9+I9+K9+M9","v":0},{"$f":"B9*O9","v":0}]
[null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,0,0,0,0,{"$f":"C13+E13+G13+I13","v":0},{"$f":"B13*I13","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
["Subtotal",null,{"$f":"SUM(C8:C17)","v":0},0,0,0,0,{"$f":"SUM(H8:H17)","v":0},0,0,0,0,0,0,{"$f":"SUM(O8:O17)","v":0},{"$f":"SUM(P8:P17)","v":0}]
[]
["(b) Consultants"]
[]
["-",null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D22+F22+H22+J22+L22+N22","v":0}]
["-",null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D23+F23+H23+J23+L23+N23","v":0}]
["Subtotal",null,null,{"$f":"SUM(D22:D23)","v":0},null,{"$f":"SUM(F22:F23)","v":0},null,{"$f":"SUM(H22:H23)","v":0},null,{"$f":"SUM(J22:J23)","v":0},null,{"$f":"SUM(L22:L23)","v":0},null,{"$f":"SUM(N22:N23)","v":0},null,{"$f":"SUM(P22:P23)","v":0}]
[]
["(c ) Subcontracts "]
["-",null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D27+F27+H27+J27+L27+N27","v":0}]
["-",null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D28+F28+H28+J28+L28+N28","v":0}]
["-",null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D29+F29+H29+J29+L29+N29","v":0}]
["Subtotal",null,null,{"$f":"SUM(D27:D29)","v":0},null,{"$f":"SUM(F27:F29)","v":0},null,{"$f":"SUM(H27:H29)","v":0},null,{"$f":"SUM(J27:J29)","v":0},null,{"$f":"SUM(L27:L29)","v":0},null,{"$f":"SUM(N27:N29)","v":0},null,{"$f":"SUM(P27:P29)","v":0}]
[]
["(d) Materials and Supplies (Prime)"]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D33+F33+H33+J33+L33+N33","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D34+F34+H34+J34+L34+N34","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D33:D35)","v":0},null,{"$f":"SUM(F33:F35)","v":0},null,{"$f":"SUM(H33:H35)","v":0},null,{"$f":"SUM(J33:J35)","v":0},null,{"$f":"SUM(L33:L35)","v":0},null,{"$f":"SUM(N33:N35)","v":0},null,{"$f":"SUM(P33:P35)","v":0}]
[]
["(e) Services (Prime)"]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D39+F39+H39+J39+L39+N39","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D40+F40+H40+J40+L40+N40","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D39:D41)","v":0},null,{"$f":"SUM(F39:F41)","v":0},null,{"$f":"SUM(H39:H41)","v":0},null,{"$f":"SUM(J39:J41)","v":0},null,{"$f":"SUM(L39:L41)","v":0},null,{"$f":"SUM(N39:N41)","v":0},null,{"$f":"SUM(P39:P41)","v":0}]
[]
["(f) Travel (Prime)"]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D45+F45+H45+J45+L45+N45","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D46+F46+H46+J46+L46+N46","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Subtotal",null,null,{"$f":"SUM(D45:D47)","v":0},null,{"$f":"SUM(F45:F47)","v":0},null,{"$f":"SUM(H45:H47)","v":0},null,{"$f":"SUM(J45:J47)","v":0},null,{"$f":"SUM(L45:L47)","v":0},null,{"$f":"SUM(N45:N47)","v":0},null,{"$f":"SUM(P45:P47)","v":0}]
[]
[]
["(g) Employee Benefit Plan (Prime)",null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D51+F51+H51+J51+L51+N51","v":0}]
[]
["TOTAL DIRECT COSTS",null,null,{"$f":"D18+D24+D30+D36+D42+D48+D51","v":0},null,{"$f":"F18+F24+F30+F36+F42+F48+F51","v":0},null,{"$f":"H18+H24+H30+H36+H42+H48+H51","v":0},null,{"$f":"J18+J24+J30+J36+J42+J48+J51","v":0},null,{"$f":"L18+L24+L30+L36+L42+L48+L51","v":0},null,{"$f":"N18+N24+N30+N36+N42+N48+N51","v":0},null,{"$f":"P18+P24+P30+P36+P42+P48+P51","v":0}]
["Overhead on Subcontracts",null,null,{"$f":"#REF!/#REF!*$B54","v":{"$error":"#REF!"}},null,{"$f":"#REF!/#REF!*$B54","v":{"$error":"#REF!"}},null,{"$f":"#REF!/#REF!*$B54","v":{"$error":"#REF!"}},null,{"$f":"#REF!/#REF!*$B54","v":{"$error":"#REF!"}},null,{"$f":"#REF!/#REF!*$B54","v":{"$error":"#REF!"}},null,{"$f":"#REF!/#REF!*$B54","v":{"$error":"#REF!"}},null,{"$f":"D54+F54+H54+J54","v":{"$error":"#REF!"}}]
[]
["(h) Overhead (Prime)",null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D56+F56+H56+J56+L56+N56","v":0}]
["(i) Profit (Prime) (not to exceed 10%)",null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"D57+F57+H57+J57+L57+N57","v":0}]
[]
["TOTAL PROJECT COSTS",null,null,{"$f":"D53+D56+D57","v":0},null,{"$f":"F53+F56+F57","v":0},null,{"$f":"H53+H56+H57","v":0},null,{"$f":"J53+J56+J57","v":0},null,{"$f":"L53+L56+L57","v":0},null,{"$f":"N53+N56+N57","v":0},null,{"$f":"P53+P57+P56","v":0}]
[null,null," "]
[]
["Overhead/Indirect Costs:  Projects will be subject to federal flow-through funding regulations.  Entities are required to provide documentation of a federally negotiated indirect cost rate agreement or federally approved rates, or acceptance of 10% de minimus rate indirect costs."]
["Costs under this Agreement are subject to FAA Contract Cost Principles AMS T3.3.2.  These funds will serve to reimburse all reasonable, allowable, and allocable costs, profit or fee not to exceed 10%."]

{"sheet":"Other Orgs","index":1,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[12,0,13,2],[12,3,13,4],[12,5,13,6],[12,7,13,8],[12,9,13,10],[12,15,13,16],[0,0,0,16],[2,0,2,16],[4,0,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[11,15,11,16],[4,11,4,12],[4,13,4,14],[4,15,4,16],[10,0,10,2],[11,0,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[3,0,3,16],[14,15,17,15],[15,0,15,2],[16,0,16,2],[17,0,17,2],[14,0,14,2],[14,3,17,3],[14,5,17,5],[14,7,17,7],[14,9,17,9],[18,0,18,2],[19,0,20,2],[19,3,20,4],[19,5,20,6],[19,7,20,8],[19,9,20,10],[14,11,17,11],[14,13,17,13],[25,0,25,2],[25,3,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[21,5,24,5],[21,7,24,7],[21,9,24,9],[23,0,23,2],[24,0,24,2],[26,15,27,16],[28,15,31,15],[29,0,29,2],[30,0,30,2],[31,0,31,2],[28,0,28,2],[28,3,31,3],[28,5,31,5],[47,0,47,16],[48,0,48,16],[32,7,32,8],[32,9,32,10],[32,15,32,16],[42,0,42,2],[43,0,43,2],[43,3,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[41,0,41,2],[41,3,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[41,15,41,16],[43,15,43,16],[36,0,36,2],[32,0,32,2],[32,3,32,4],[32,5,32,6],[39,0,39,2],[40,0,40,2],[1,0,1,16],[38,0,38,2],[38,3,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,15,38,16],[34,0,34,2],[35,0,35,2],[33,0,33,2],[37,0,37,2],[28,7,31,7],[28,9,31,9],[26,0,27,2],[26,3,27,4],[26,5,27,6],[26,7,27,8],[25,15,25,16],[26,9,27,10],[19,15,20,16],[21,0,21,2],[21,3,24,3],[21,15,24,15],[22,0,22,2]]}
[" Consultant and Subcontract Budget Detail ACPT Project No. _______"]
[]
["Organization Name:  "]
[]
["Salaries and Wages",null,null,{"$f":"'Prime Budget'!C6","v":"Task"},null,{"$f":"'Prime Budget'!E6","v":"Task"},null,{"$f":"'Prime Budget'!G6","v":"Task"},null,{"$f":"'Prime Budget'!I6","v":"Task"},null,{"$f":"'Prime Budget'!K6","v":"Task"},null,{"$f":"'Prime Budget'!M6","v":"Task"},null,"TOTAL"]
["Name","Role in Study","Direct Hourly Rate","Hours","Cost","Hours","Cost","Hours","Cost","Hours","Cost","Hours","Cost","Hours","Cost","Hours","Cost"]
[null,null,0,null,{"$f":"$C7*D7","v":0},null,{"$f":"$C7*F7","v":0},null,{"$f":"$C7*H7","v":0},null,{"$f":"$C7*J7","v":0},null,{"$f":"$C7*L7","v":0},null,{"$f":"$C7*N7","v":0},{"$f":"+D7+F7+H7+J7+L7+N7","v":0},{"$f":"+$C7*P7","v":0}]
[null,null,0,null,{"$f":"$C8*D8","v":0},null,0,null,{"$f":"$C8*H8","v":0},null,{"$f":"$C8*J8","v":0},null,{"$f":"$C8*L8","v":0},null,{"$f":"$C8*N8","v":0},{"$f":"+D8+F8+H8+J8+L8+N8","v":0},{"$f":"+$C8*P8","v":0}]
[null,null,0,null,0,null,{"$f":"$C9*F9","v":0},null,0,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
["Subtotal",null,null,{"$f":"SUM(D7:D10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Materials and Supplies"]
[]
[null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+E15+G15+I15+K15+M15+O15","v":0}]
[null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+E16+G16+I16+K16+M16+O16","v":0}]
[null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Subtotal",null,null,null,{"$f":"SUM(E15:E17)","v":0},null,{"$f":"SUM(G15:G17)","v":0},null,{"$f":"SUM(I15:I17)","v":0},null,{"$f":"SUM(K15:K17)","v":0},null,{"$f":"SUM(M15:M17)","v":0},null,{"$f":"SUM(O15:O17)","v":0},null,{"$f":"SUM(Q15:Q17)","v":0}]
[]
["Services "]
[]
[null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+E22+G22+I22+K22+M22+O22","v":0}]
[null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+E23+G23+I23+K23+M23+O23","v":0}]
[null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Subtotal",null,null,null,{"$f":"SUM(E22:E24)","v":0},null,{"$f":"SUM(G22:G24)","v":0},null,{"$f":"SUM(I22:I24)","v":0},null,{"$f":"SUM(K22:K24)","v":0},null,{"$f":"SUM(M22:M24)","v":0},null,{"$f":"SUM(O22:O24)","v":0},null,{"$f":"SUM(Q22:Q24)","v":0}]
[]
["Travel"]
[]
[null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+E29+G29+I29+K29+M29+O29","v":0}]
[null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+E30+G30+I30+K30+M30+O30","v":0}]
[null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Subtotal",null,null,null,{"$f":"SUM(E29:E31)","v":0},null,{"$f":"SUM(G29:G31)","v":0},null,{"$f":"SUM(I29:I31)","v":0},null,{"$f":"SUM(K29:K31)","v":0},null,{"$f":"SUM(M29:M31)","v":0},null,{"$f":"SUM(O29:O31)","v":0},null,{"$f":"SUM(Q29:Q31)","v":0}]
[]
[]
["Employee Benefit Plan",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"E35+G35+I35+K35+M35+O35","v":0}]
[]
["Total Direct Costs",null,null,null,{"$f":"E11+E18+E25+E32+E35","v":0},null,{"$f":"G11+G18+G25+G32+G35","v":0},null,0,null,0,null,0,null,0,null,{"$f":"Q11+Q18+Q25+Q32+Q35","v":0}]
[]
[]
["Overhead",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+E40+G40+I40+K40+M40+O40","v":0}]
["Profit (not to exceed 10%)",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+E41+G41+I41+K41+M41+O41","v":0}]
[]
["TOTAL PROJECT COSTS",null,null,null,{"$f":"E37+E41","v":0},null,{"$f":"G37+G41","v":0},null,{"$f":"I37+I41","v":0},null,{"$f":"K37+K41","v":0},null,{"$f":"M37+M41","v":0},null,{"$f":"O37+O41","v":0},null,{"$f":"Q37+Q40+Q41","v":0}]
[]
[]
["*Use this form for consultants, and subcontractors, one form per entity."]
[]
["Overhead/Indirect Costs:  Projects will be subject to federal flow-through funding regulations.  Entities are required to provide documentation of a federally negotiated indirect cost rate agreement or federally approved rates, or acceptance of 10% de minimus rate indirect costs."]
["Costs under this Agreement are subject to FAA Contract Cost Principles AMS T3.3.2.  These funds will serve to reimburse all reasonable, allowable, and allocable costs, and may include a reasonable profit, not to exceed 10%."]