{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INSTRUCTIONS ","Cost Reimbursable ECC Template","Subcontractor Summary Template","Sample Cost ECC","General Ledger Detail Sample","Sample Subcontractor Summary "],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"INSTRUCTIONS ","index":0,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[[14,0,14,9],[6,0,6,1],[9,2,9,10],[13,0,13,9],[1,0,1,9],[2,0,2,9],[2,10,2,11],[3,0,3,9],[12,0,12,9],[7,0,8,9],[10,0,10,9],[11,0,11,9],[3,10,3,11],[5,0,5,9],[5,10,5,11],[26,0,26,9],[15,0,15,9],[16,0,16,9],[17,0,17,9],[18,0,18,9],[19,0,19,9],[20,0,20,9],[21,0,21,9],[22,0,22,9],[23,0,23,9],[24,0,24,9],[25,0,25,9],[35,0,35,9],[40,0,40,9],[41,0,41,9],[27,0,27,9],[28,0,28,9],[29,0,29,9],[36,0,36,10],[33,0,33,9]]}
[]
[" Sandia National Laboratories"]
["Contract Audit"]
["ECC Instructions "]
[]
["Cost Reimbursable Type Contracts"]
["User Information:"]
["The following information does not supersede any statute, regulation or policy that is, was or will be in effect. It is designed as a tool to answer general questions that are commonly posed by contractors that are subject to audits from the Sandia Contract Audit Department, Organization 851 (hereinafter, Contract Audit). For specific questions pertaining to your contract, contact the appropriate Subcontracting Professional (SP) listed on your contract."]
[]
[]
["In preparing the ECC, we require each contractor reconcile their claim to the general ledger amount to ensure that all costs are properly accounted for. Costs previously invoiced/not invoiced in error can be adjusted on your claim. "]
["**All ECCs should be submitted in a single Excel workbook with separate worksheets for each contract. There should be a separate submission for each fiscal year."]
["If extra rows are needed:  Ctrl + Shift + R "]
["1. Header: Please fill out the company name, contract number, period of performance of the contract (beginning and end dates of contract), contract ceiling price and fiscal year for which the claimed costs apply."]
["2. Month: This will auto populate once the Fiscal Year End is updated. "]
["3. Direct Labor: Insert actual direct labor costs by labor category. "]
["4. Direct Labor Fringe: Insert the fringe rates associated with your claimed direct labor charges if these are being billed and claimed. If there is more than one direct labor fringe rate used, list them separately. Examples include: Off-site direct labor fringe, on-site direct labor fringe, overtime direct labor fringe. All claimed indirect rates must be allowable, allocable, and audited or approved by your cognizant agency. Please see the “Indirect Rate” section below in this document for additional information."]
["5. Direct Supplies/Materials: List the actual direct material costs for each accounting period."]
["6. Direct Material Handling Rate: If you are claiming a direct material-handling rate, show that separately. All claimed indirect rates must be allowable, allocable, and audited or approved by your cognizant agency. "]
["7. Direct Travel: List applicable domestic and foreign travel charges for each accounting period.  Domestic travel charges should be listed on a separate row than foreign travel charges."]
["8. Subcontracts/Consultant/Temporary Labor: List the costs incurred by Subcontractors/Consultants. If subcontractor costs are being claimed, complete the \"Subcontractor Summary\" template tab. "]
["9. ODCs (Other Direct Costs): For any other direct costs that you are claiming, segregate those costs accordingly. Some examples may include: Licensing fees, equipment leases, shipping and handling, taxes, etc. All other direct costs should be grouped together in this column. If you need to explain what the group consists of please include a comment in the comments section (use column S)."]
["10.On-Site, Off-site & other F&A costs: must be segregated according to their rates and basis. All claimed indirect rates must be allowable, allocable, and audited or approved by your cognizant agency. Please see the “Indirect Rate” section below in this document for additional information."]
["11. Fee: Total amount of fee earned at the rate specified in your contract."]
["12. Fee Withheld: Amount of fee earned that has not yet been billed."]
["13. Total per General Ledger: This will auto populate. "]
["13. Adjustments by month and cost element: Include any amounts that you have over billed or under billed to Sandia and discovered subsequent to the billings. This could be due to errors or omissions. This is an opportunity to claim any corrections noted as part of your review. Please provide a detailed explanation in the comments column indicating which cost category the adjustment is in reference to and why the adjustment was made."]
["14.Total Amount Claimed: This will auto populate."]
["15.Comments: Use this column to describe any adjustments or other important aspects of your electronic cost claim."]
["16. Indirect Rates. If Sandia is the cognizant agency and you are claiming and billing indirect rates, then an indirect rate cost claim (must include indirect base by account, pool by account, and the unallowable expenses by account) and General Ledger are required to be submitted in conjunction with your ECC.  If Sandia is not the cognizant agency, you are required to provide the latest rate report(s) from the cognizant agency as part of your cost claim.  The rate report sheets may be e-mailed to us. Additionally, please provide the cognizant agency’s contact information including auditor’s name and phone number."]
[null,null,null,"Please email any questions to snlaudit@sandia.gov "]
[]
["Submission Requirements "]
["ECCs should be submitted annually for each contract to which Sandia has audit rights. The annual submissions are due 90 days after a contractor’s fiscal year end.  Please note that it is imperative that you check for accuracy and completeness prior to your submission.  "]
["Please include any indirect rate sheets and General Ledger Detail with submission."]
["Additional information and points of contact may be found at the Contract Audit website at: http://www.sandia.gov/working_with_sandia/current_suppliers/contract_audit/index.html"]
["Send ECCs via e-mail to: snlaudit@sandia.gov"]
[]
[]
[]
["Sandia is a multiprogram laboratory operated for the U.S. Department of Energy’s National Nuclear Security Administration"]
["by National Technology and Engineering Solutions of Sandia LLC under Contract DE-NA0003525. "]
[]
[]
[]
[{"$f":"'Cost Reimbursable ECC Template'!A52","v":"Template Revised: 12/4/2020"}]
["SAND2020-13745 W"]

{"sheet":"Cost Reimbursable ECC Template","index":1,"n_rows":52,"n_cols":29,"rows_kept":52,"cut":false,"hidden":false,"merged":[[8,1,8,2]]}
["Contractor Name",null,null,"Please fill out one cost claim template for each auditable contract that you have with Sandia National Laboratories. "]
["Contract Number: "]
["Period of Performance: ",null,"Fiscal year end","2020-09-30"]
["Contract Ceiling Amount: $",null,"Current Fiscal Year"]
[]
["Send to: snlaudit@sandia.gov ",null,null,"Enter amounts as recorded on your General Ledger (make any corrections in the adjustment row with comments)"]
[]
[null,null,null,{"$f":"EDATE(D3,1)","v":"2020-10-30"},{"$f":"EDATE(D8,1)","v":"2020-11-30"},{"$f":"EDATE(E8,1)","v":"2020-12-30"},{"$f":"EDATE(F8,1)","v":"2021-01-30"},{"$f":"EDATE(G8,1)","v":"2021-02-28"},"2021-03-28","2021-04-28","2021-05-28","2021-06-28","2021-07-28","2021-08-28","2021-09-28"]
[null,"Month",null,{"$f":"TEXT(D8,\"mmmm\")","v":"October"},{"$f":"TEXT(E8,\"mmmm\")","v":"November"},"December","January","February","March","April","May","June","July","August","September"]
[null,null,"Accounting Period",1,2,3,4,5,6,7,8,9,10,11,12]
["Account Title","GL Acct. Number","Indirect Rate %",null,null,null,null,null,null,null,null,null,null,null,null,"Total Per General Ledger","Adjustments by Cost Element","Total Amount Claimed","Comments"]
["Cost Structure - see Samples",null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(D12:O12),2)","v":0},0,{"$f":"ROUND(P12+Q12,2)","v":0},null,null,null,null,null,null,null,null,"Labor Category",null,"Fiscal Year End"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(D13:O13),2)","v":0},0,{"$f":"ROUND(P13+Q13,2)","v":0},null,null,null,null,null,null,null,null,"Level of Effort",null,"2020-01-31"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"Non-Level of Effort",null,"2020-02-28"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-03-31"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-04-30"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(D17:O17),2)","v":0},0,{"$f":"ROUND(P17+Q17,2)","v":0},null,null,null,null,null,null,null,null,null,null,"2020-05-31"]
[null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-06-30"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-07-31"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-08-31"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-09-30"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-10-31"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(D23:O23),2)","v":0},0,{"$f":"ROUND(P23+Q23,2)","v":0},null,null,null,null,null,null,null,null,null,null,"2020-11-30"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-12-31"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(D29:O29),2)","v":0},0,{"$f":"ROUND(P29+Q29,2)","v":0}]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Costs",null,null,{"$f":"SUM(D12:D31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Fee (if applicable)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Fee Withheld (if applicable)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Adjustments by Month",null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(D38:O38),2)","v":0},0,{"$f":"ROUND(P38+Q38,2)","v":0}]
[]
["Total Claimed",null,null,{"$f":"SUM(D32,D34,D36,D38)","v":0},{"$f":"SUM(E32,E34,E36,E38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
["(1) Refer to the Instructions tab for assistance in filling this out."]
["(2) Provide indirect rate substantiation as discussed in the Electronic Cost Claim Instructions if you are claiming any indirect rates."]
["(3) The adjustments by month should agree with the Adjustments by Cost Elements."]
[]
["Template Revised: 12/4/2020"]

{"sheet":"Subcontractor Summary Template","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,2,6]]}
["Summary of Subcontractor/Consultant/Temp Labor Charges"]
["List all subcontractors/consultants/temporary labor used on the contract. (A cost claim for these may be required during the audit.)"]
[]
[null,"Dollar Amount"]
["Subcontractor A (Insert name here)",0]
["Subcontractor B  (Insert name here)"]
["Subcontractor C  (Insert name here)"]
["Subtotal",{"$f":"SUM(B5:B7)","v":0}]
[]
["Consultant A  (Insert name here)"]
["Consultant B  (Insert name here)"]
["Subtotal",{"$f":"SUM(B10:B11)","v":0}]
[]
["Temp A  (Insert name here)"]
["Temp B  (Insert name here)"]
["Subtotal",{"$f":"SUM(B14:B15)","v":0}]
[]
["Total Charges",{"$f":"SUM(B8,B12,B16)","v":0}]
[]
[]
[{"$f":"'Cost Reimbursable ECC Template'!A52","v":"Template Revised: 12/4/2020"}]

{"sheet":"Sample Cost ECC","index":3,"n_rows":54,"n_cols":29,"rows_kept":54,"cut":false,"hidden":false,"merged":[[8,1,8,2]]}
["ABC Company Cost Claim",null,null,"Please fill out one cost claim template for each auditable contract that you have with Sandia National Laboratories. "]
["Contract Number: 1234  Acct. # 0000-0001"]
["Period of Performance: 01/01/2018-01/01/2020",null,"Fiscal year end","2020-06-30"]
["Contract Ceiling Amount: $1,000,000",null,"Current Fiscal Year",2019]
[]
["Send to: snlaudit@sandia.gov ",null,null,"Enter amounts as recorded on your General Ledger (make any corrections in the adjustment row with comments)"]
[]
[null,null,null,{"$f":"EDATE(D3,1)","v":"2020-07-30"},{"$f":"EDATE(D8,1)+1","v":"2020-08-31"},{"$f":"EDATE(E8,1)","v":"2020-09-30"},{"$f":"EDATE(F8,1)","v":"2020-10-30"},{"$f":"EDATE(G8,1)","v":"2020-11-30"},"2020-12-30","2021-01-30","2021-02-28","2021-03-28","2021-04-28","2021-05-28","2021-06-28"]
[null,"Month",null,{"$f":"TEXT(D8,\"mmmm\")","v":"July"},{"$f":"TEXT(E8,\"mmmm\")","v":"August"},"September","October","November","December","January","February","March","April","May","June"]
[null,null,"Accounting Period",1,2,3,4,5,6,7,8,9,10,11,12]
["Account Title","GL Acct. Number","Indirect Rate %",null,null,null,null,null,null,null,null,null,null,null,null,"Total Per General Ledger","Adjustments by Cost Element","Total Amount Claimed","Comments"]
["Labor On-site",2001,null,28660.12,31152.28,30139.360000000001,30648.15,29784.240000000002,31440.54,28879.040000000001,32163.29,26374.9,23836.89,28002,39353.449999999997,{"$f":"ROUND(SUM(D12:O12),2)","v":360434.26},0,{"$f":"ROUND(P12+Q12,2)","v":360434.26}]
["Labor Off-site",2002,null,null,null,null,5900,5900,5900,null,null,null,null,null,null,{"$f":"ROUND(SUM(D13:O13),2)","v":17700},0,{"$f":"ROUND(P13+Q13,2)","v":17700},null,null,null,null,null,null,null,null,"Labor Category",null,"Fiscal Year End"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"Level of Effort",null,"2020-01-31"]
["Labor On-site Fringe",2003,0.02,{"$f":"D12*$C15","v":573.20240000000001},623.04560000000004,602.78719999999998,612.96300000000008,595.6848,628.81080000000009,577.58080000000007,643.26580000000001,527.49800000000005,476.73779999999999,560.04,787.06899999999996,7208.69,0,7208.69,null,null,null,null,null,null,null,null,"Non-Level of Effort",null,"2020-02-28"]
["Labor Off-site Fringe",2004,0.04,{"$f":"D13*$C16","v":0},{"$f":"E13*$C16","v":0},0,236,236,236,0,0,0,0,0,0,708,0,708,null,null,null,null,null,null,null,null,null,null,"2020-03-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-04-30"]
["Supplies/Materials",3001,null,500,200,320,880,265,0,0,0,0,0,0,0,2165,0,2165,null,null,null,null,null,null,null,null,null,null,"2020-05-31"]
["Domestic Direct Travel",3003,null,1153.1400000000001,261.3,2894.54,872.36,810.17,1252.02,623.82000000000005,541,2669.8,551.39,341.09,1689.03,13659.66,0,13659.66,null,null,null,null,null,null,null,null,null,null,"2020-07-31"]
["Foreign Direct Travel",3004,null,0,0,2500,0,0,0,0,0,0,0,0,0,2500,0,2500,null,null,null,null,null,null,null,null,null,null,"2020-08-31"]
["Other Direct Costs",3005,null,550,895,5544,624,333,945,55,210,120,356,888,678,11198,0,11198,null,null,null,null,null,null,null,null,null,null,"2020-09-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-10-31"]
["General & Administrative (G&A)",5005,0.44500000000000001,14345.225767999998,15099.573392,19046.305804,18055.195485000004,17232.222186000003,18335.055005999999,13766.271156000001,15289.112331,13569.028110000001,11579.352921,13613.05285,19271.859304999998,189202.25,0,189202.25,null,null,null,null,null,null,null,null,null,null,"2020-11-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,"2020-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Subcontracts",3006,null,5000,2500,3000,4000,7500,0,1500,200,500,2500,300,0,27000,0,27000]
["Capital Equipment",3007,null,7000,0,0,0,0,0,0,0,0,0,0,0,7000,0,7000]
["Non-Capital Equipment",3008,null,0,0,862,0,0,3000,0,0,0,0,0,0,3862,0,3862]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Costs",null,null,{"$f":"SUM(D12:D30)","v":57781.688167999993},50731.198991999998,64908.993004000004,61828.668485000009,62656.316986000005,61737.425805999999,45401.711955999999,49046.668130999999,43761.226110000003,39300.370720999999,43704.182849999997,61779.408304999997,642637.86,0,642637.86]
[]
["Fee (if applicable)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Fee Withheld (if applicable)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Adjustments by Month",null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(D37:O37),2)","v":0},0,{"$f":"ROUND(P37+Q37,2)","v":0}]
[]
["Total Claimed",null,null,{"$f":"SUM(D31,D33,D35,D37)","v":57781.688167999993},{"$f":"SUM(E31,E33,E35,E37)","v":50731.198991999998},64908.993004000004,61828.668485000009,62656.316986000005,61737.425805999999,45401.711955999999,49046.668130999999,43761.226110000003,39300.370720999999,43704.182849999997,61779.408304999997,642637.86,0,642637.86]
[]
[]
[]
[]
[]
[]
[]
["(1) Refer to the Instructions tab for assistance in filling this out."]
["(2) Provide indirect rate substantiation as discussed in the Electronic Cost Claim Instructions if you are claiming any indirect rates."]
["(3) In the \"Credits/Payments resulting from prior audit adjustments\" column, report any payments you made to Sandia as a result of audit findings in Sandia's favor"]
["     and report any credits you received as a result of findings in your favor. "]
["     If you made no payments or have chosen to net any audit findings at the close-out of your contract, please state this in the \"Comments\" section."]
["(4) The adjustments by month should agree with the Adjustments by Cost Elements."]
[]
[{"$f":"'Cost Reimbursable ECC Template'!A52","v":"Template Revised: 12/4/2020"}]

{"sheet":"General Ledger Detail Sample","index":4,"n_rows":88,"n_cols":10,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["GL. Account Number","Account Name","Cost Category","DESCRIPTION","TRANSACTION DATE","REF.","REV/EXP","Contract #","Month","FY "]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2018-07-01",1,28660.12,1234,"July",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2018-08-15",2,31152.28,1234,"August",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2018-09-15",3,30139.360000000001,1234,"September",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2018-10-15",4,30648.15,1234,"October",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2018-11-15",5,29784.240000000002,1234,"November",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2018-12-15",6,31440.54,1234,"December",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2019-01-15",7,28879.040000000001,1234,"January",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2019-02-15",8,32163.29,1234,"February",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2019-03-15",9,26374.9,1234,"March",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2019-04-15",10,23836.89,1234,"April",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2019-05-15",11,28002,1234,"May",2019]
[2001,"Labor - Onsite","On-site Labor","Direct labor","2019-06-15",12,39353.449999999997,1234,"June",2019]
[2002,"Labor-Offsite","Off-site Labor","Off Site Labor","2018-10-15",13,5900,1234,"October",2019]
[2002,"Labor-Offsite","Off-site Labor","Off Site Labor","2018-11-15",14,5900,1234,"November",2019]
[2002,"Labor-Offsite","Off-site Labor","Off Site Labor","2018-12-15",15,5900,1234,"December",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2018-07-01",16,573.20240000000001,1234,"July",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2018-08-15",17,623.04560000000004,1234,"August",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2018-09-15",18,602.78719999999998,1234,"September",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2018-10-15",19,612.96300000000008,1234,"October",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2018-11-15",20,595.6848,1234,"November",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2018-12-15",21,628.81080000000009,1234,"December",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2019-01-15",22,577.58080000000007,1234,"January",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2019-02-15",23,643.26580000000001,1234,"February",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2019-03-15",24,527.49800000000005,1234,"March",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2019-04-15",25,476.73779999999999,1234,"April",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2019-05-15",26,560.04,1234,"May",2019]
[2003,"Fringe- Onsite Labor","Fringe","Fringe Onsite","2019-06-15",27,787.06899999999996,1234,"June",2019]
[2004,"Fringe - offsite labor","Fringe","Fringe Offsite","2018-10-15",28,236,1234,"October",2019]
[2004,"Fringe - offsite labor","Fringe","Fringe Offsite","2018-11-15",29,236,1234,"November",2019]
[2004,"Fringe - offsite labor","Fringe","Fringe Offsite","2018-12-15",30,236,1234,"December",2019]
[3001,"Supplies & Materials","Supplies & Materials","Materials purchase ","2018-07-01",31,500,1234,"July",2019]
[3001,"Supplies & Materials","Supplies & Materials","Materials purchase ","2018-08-15",32,200,1234,"August",2019]
[3001,"Supplies & Materials","Supplies & Materials","Materials purchase ","2018-09-15",33,320,1234,"September",2019]
[3001,"Supplies & Materials","Supplies & Materials","Materials purchase ","2018-10-15",34,880,1234,"October",2019]
[3001,"Supplies & Materials","Supplies & Materials","Materials purchase ","2018-11-15",35,265,1234,"November",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2018-07-01",36,1153.1400000000001,1234,"July",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2018-08-15",37,261.3,1234,"August",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2018-09-15",38,2894.54,1234,"September",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2018-10-15",39,872.36,1234,"October",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2018-11-15",40,810.17,1234,"November",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2018-12-15",41,1252.02,1234,"December",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2019-01-15",42,623.82000000000005,1234,"January",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2019-02-15",43,541,1234,"February",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2019-03-15",44,2669.8,1234,"March",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2019-04-15",45,551.39,1234,"April",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2019-05-15",46,341.09,1234,"May",2019]
[3003,"Domestic Direct Travel","Travel","CONUS Travel","2019-06-15",47,1689.03,1234,"June",2019]
[3004,"Foreign Travel","Travel","OCONUS Travel","2018-09-15",48,2500,1234,"September",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2018-07-01",49,550,1234,"July",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2018-08-15",50,895,1234,"August",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2018-09-15",51,5544,1234,"September",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2018-10-15",52,624,1234,"October",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2018-11-15",53,333,1234,"November",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2018-12-15",54,945,1234,"December",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2019-01-15",55,55,1234,"January",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2019-02-15",56,210,1234,"February",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2019-03-15",57,120,1234,"March",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2019-04-15",58,356,1234,"April",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2019-05-15",59,888,1234,"May",2019]
[3005,"Other Direct Costs","ODCs","ODCs","2019-06-15",60,678,1234,"June",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2018-07-01",61,14345.225767999998,1234,"July",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2018-08-15",62,15099.573392,1234,"August",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2018-09-15",63,19046.305804,1234,"September",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2018-10-15",64,18055.195485000004,1234,"October",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2018-11-15",65,17232.222186000003,1234,"November",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2018-12-15",66,18335.055005999999,1234,"December",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2019-01-15",67,13766.271156000001,1234,"January",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2019-02-15",68,15289.112331,1234,"February",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2019-03-15",69,13569.028110000001,1234,"March",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2019-04-15",70,11579.352921,1234,"April",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2019-05-15",71,13613.05285,1234,"May",2019]
[5005,"G&A","Indirect Costs","G&A 44.50%","2019-06-15",72,19271.859304999998,1234,"June",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor A","2018-07-01",73,5000,1234,"July",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor A","2018-08-15",74,2500,1234,"August",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor A","2018-09-15",75,3000,1234,"September",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor A","2018-10-15",76,4000,1234,"October",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor C","2018-11-15",77,7000,1234,"November",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor B","2018-11-15",78,500,1234,"November",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor B","2019-01-15",79,1500,1234,"January",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor B","2019-02-15",80,200,1234,"February",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor A","2019-03-15",81,500,1234,"March",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor B","2019-04-15",82,2500,1234,"April",2019]
[3006,"Subcontracts","Subcontractor costs","Subcontractor B","2019-05-15",83,300,1234,"May",2019]
[3007,"Capital Eqpt","Eqpt > $5K","Lab Eqpt","2018-07-01",84,7000,1234,"July",2019]
[3008,"Non- Capital Equipment","Eqpt < $5K","Computer","2018-09-15",85,862,1234,"September",2019]
[3008,"Non- Capital Equipment","Eqpt < $5K ","Computer","2018-12-15",86,3000,1234,"December",2019]
[null,null,null,null,null,null,{"$f":"SUM(G2:G87)","v":642637.85951400013}]

{"sheet":"Sample Subcontractor Summary ","index":5,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Summary of Subcontractor/Consultant/Temp Labor Charges"]
[]
[null,null,null,null,"This is a Sample \"Summary of Subcontractor/Consultant/Temp Labor Charges\" - (These numbers serve only as an example)"]
[null,"Dollar Amount",null,null,"Use the \"Subcontractor Summary Template\" Sheet"]
["Subcontractor A",15000]
["Subcontractor B",5000]
["Subcontractor C",7000]
["Subtotal",{"$f":"SUM(B5:B7)","v":27000}]
[]
["Consultant A",0]
["Consultant B",0]
["Subtotal",{"$f":"SUM(B10:B11)","v":0}]
[]
["Temp A"]
["Temp B"]
["Subtotal",{"$f":"SUM(B14:B15)","v":0}]
[]
["Total Charges",{"$f":"SUM(B8,B12,B16)","v":27000}]
[]
[]
["Total Charges need to reconcile to the total Subcontractor/Consultant/Temp Labor Charges on your ECC."]
[]
["During an audit, a detailed ECC may be required for any of the subcontractors/consultants/temp labor listed above."]
[]
[{"$f":"'Cost Reimbursable ECC Template'!A52","v":"Template Revised: 12/4/2020"}]