{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["GL Wrap Up","OCIP","Technician 1","Pipe Fitter","Lead Fitter","Inspectors","Management","Corp","Notes","Rate notes","DavisBacon"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":6,"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":"GL Wrap Up","index":0,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":true,"merged":[[6,2,6,10],[0,2,0,10],[1,2,1,10],[2,2,2,10],[3,2,3,10],[4,2,4,10]]}
[null,null,"General Contractor Name"]
[null,null,"Street"]
[null,null,"City State Zip"]
[null,null,"Phone"]
[]
[]
[null,null,"Labor Cost per Hour",null,null,null,null,null,null,null,null,"** GL Wrap Up"]
[]
[]
["Job:",null,null,null,null,null,null,null,null,"Contract #:"]
[]
["Company Name:",null,null,null,null,null,null,"Prepared by:"]
[]
["Trade:",null,null,null,null,null,null,"Rate Effective:",null,null,"to"]
[]
["Classification:",null,null,null,null,null,null,"Union:"]
["(i.e.: Superintendent, journeyman, laborer)"]
[]
[null,null,null,null,null,null,null,"Straight Time",null,"Time & 1/2",null,"Double Time"]
["A.","BASE"]
[null,1,"Base Wage",null,null,null,null,0,null,{"$f":"H21*1.5","v":0},null,0]
[null,null,"Shift Differential ( if applicable)"]
[null,null,"1st Shift",null,null,null,null,0,null,0,null,0]
[null,null,"2nd Shift",null,null,null,null,0,null,0,null,0]
[null,null,"3rd Shift",null,null,null,null,0,null,0,null,0]
[]
["B.","VACATION & HOLIDAY"]
[null,2,"Vacation & Holiday - Add to Base Wage",null,null,null,null,null,null,{"$f":"H28","v":0},null,{"$f":"H28","v":0}]
[null,3,"Subtotal of  \"A1 + B2\" =",null,null,null,null,{"$f":"H21+H28","v":0},null,{"$f":"J21+J28","v":0},null,{"$f":"L21+L28","v":0}]
[]
["C.","BENEFITS  "]
[null,4,"Health & Welfare",null,null,null,null,null,null,{"$f":"H32","v":0},null,{"$f":"H32","v":0}]
[null,5,"Pension",null,null,null,null,null,null,0,null,0]
[null,6,"Apprentice Program",null,null,null,null,null,null,0,null,0]
[null,7,"Grievance Trust",null,null,null,null,null,null,0,null,0]
[null,8,"Contract Administration",null,null,null,null,null,null,0,null,0]
[null,9,"Others (list add'l if applicable)",null,null,null,null,null,null,0,null,0]
[null,10,"Subtotal of \"C\" =",null,null,null,null,{"$f":"SUM(H32:H37)","v":0},null,{"$f":"SUM(J32:J37)","v":0},null,{"$f":"SUM(L32:L37)","v":0}]
[]
["D.","PAYROLL INSURANCE & TAX"]
[null,11,"FICA",null,null,0,null,{"$f":"F41*H29","v":0},null,{"$f":"F41*J29","v":0},null,{"$f":"F41*L29","v":0}]
[null,12,"FUI",null,null,0,null,{"$f":"F42*H29","v":0},null,{"$f":"F42*J29","v":0},null,{"$f":"F42*L29","v":0}]
[null,13,"SUI",null,null,0,null,{"$f":"F43*H29","v":0},null,{"$f":"F43*J29","v":0},null,{"$f":"F43*L29","v":0}]
[null,14,"Modified Business Tax",null,null,0,null,{"$f":"F44*H29","v":0},null,{"$f":"F44*J29","v":0},null,{"$f":"F44*L29","v":0}]
[null,15,"Workers Compensation",null,null,0,null,{"$f":"F45*H29","v":0},null,{"$f":"H45","v":0},null,{"$f":"H45","v":0}]
[null,16,"General Liability Insurance",null,null,0,null,{"$f":"F46*H29","v":0},null,{"$f":"H46","v":0},null,{"$f":"H46","v":0}]
[null,17,"Subtotal \"D\" =",null,null,null,null,{"$f":"SUM(H41:H46)","v":0},null,{"$f":"SUM(J41:J46)","v":0},null,{"$f":"SUM(L41:L46)","v":0}]
[]
["E.","**GL Wrap-Up Program Deduction   **Deduct General Liability Ins."]
[null,18,"Total D16",null,null,null,null,{"$f":"SUM(H46)*-1","v":0},null,{"$f":"SUM(J46)*-1","v":0},null,{"$f":"SUM(L46)*-1","v":0}]
[]
["F.","OVERHEAD & PROFIT"]
[null,null,null,null,"**DO NOT INCLUDE.  To be calculated at end of Change Order Summary."]
[]
[]
["G.","Equipment Rates"]
[null,19,"List as applicable",null,null,null,null,0,null,0,null,0]
[]
[]
["H","Total Billing Rate",null,null,null,null,null,{"$f":"H57+H53+H47+H38+H29+H50","v":0},null,{"$f":"J57+J53+J47+J38+J29+J50","v":0},null,{"$f":"L57+L53+L47+L38+L29+L50","v":0}]

{"sheet":"OCIP","index":1,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":true,"merged":[[6,2,6,10],[0,2,0,10],[1,2,1,10],[2,2,2,10],[4,2,4,10],[3,2,3,10]]}
[null,null,{"$f":"+'GL Wrap Up'!C1:K1","v":"General Contractor Name"}]
[null,null,{"$f":"+'GL Wrap Up'!C2:K2","v":"Street"}]
[null,null,{"$f":"+'GL Wrap Up'!C3:K3","v":"City State Zip"}]
[null,null,{"$f":"+'GL Wrap Up'!C4:K4","v":"Phone"}]
[]
[]
[null,null,"Labor Cost per Hour",null,null,null,null,null,null,null,null,"**OCIP"]
[]
[]
["Job:",null,null,null,null,null,null,null,null,"Contract #:"]
[]
["Company Name:",null,null,null,null,null,null,"Prepared by:"]
[]
["Trade:",null,null,null,null,null,null,"Rate Effective:",null,null,"to"]
[]
["Classification:",null,null,null,null,null,null,"Union:"]
["(i.e.: Superintendent, journeyman, laborer)"]
[]
[null,null,null,null,null,null,null,"Straight Time",null,"Time & 1/2",null,"Double Time"]
["A.","BASE"]
[null,1,"Base Wage",null,null,null,null,0,null,{"$f":"H21*1.5","v":0},null,{"$f":"H21*2","v":0}]
[null,null,"Shift Differential ( if applicable)"]
[null,null,"1st Shift",null,null,null,null,0,null,0,null,0]
[null,null,"2nd Shift",null,null,null,null,0,null,0,null,0]
[null,null,"3rd Shift",null,null,null,null,0,null,0,null,0]
[]
["B.","VACATION & HOLIDAY"]
[null,2,"Vacation & Holiday - Add to Base Wage",null,null,null,null,null,null,{"$f":"H28","v":0},null,{"$f":"H28","v":0}]
[null,3,"Subtotal of  \"A1 + B2\" =",null,null,null,null,{"$f":"H21+H28","v":0},null,{"$f":"J21+J28","v":0},null,{"$f":"L21+L28","v":0}]
[]
["C.","BENEFITS  "]
[null,4,"Health & Welfare",null,null,null,null,null,null,{"$f":"H32","v":0},null,{"$f":"H32","v":0}]
[null,5,"Pension",null,null,null,null,null,null,0,null,0]
[null,6,"Apprentice Program",null,null,null,null,null,null,0,null,0]
[null,7,"Grievance Trust",null,null,null,null,null,null,0,null,0]
[null,8,"Contract Administration",null,null,null,null,null,null,0,null,0]
[null,9,"Others (list add'l if applicable)",null,null,null,null,null,null,0,null,0]
[null,10,"Subtotal of \"C\" =",null,null,null,null,{"$f":"SUM(H32:H37)","v":0},null,{"$f":"SUM(J32:J37)","v":0},null,{"$f":"SUM(L32:L37)","v":0}]
[]
["D.","PAYROLL INSURANCE & TAX"]
[null,11,"FICA",null,null,0,null,{"$f":"F41*H29","v":0},null,{"$f":"F41*J29","v":0},null,{"$f":"F41*L29","v":0}]
[null,13,"FUI",null,null,0,null,{"$f":"F42*H29","v":0},null,{"$f":"F42*J29","v":0},null,{"$f":"F42*L29","v":0}]
[null,14,"SUI",null,null,0,null,{"$f":"F43*H29","v":0},null,{"$f":"F43*J29","v":0},null,{"$f":"F43*L29","v":0}]
[null,15,"Modified Business Tax",null,null,0,null,{"$f":"F44*H29","v":0},null,{"$f":"F44*J29","v":0},null,{"$f":"H44*L29","v":0}]
[null,16,"Workers Compensation",null,null,0,null,{"$f":"F45*H29","v":0},null,{"$f":"F45*J29","v":0},null,{"$f":"F45*L29","v":0}]
[null,17,"General Liability Insurance",null,null,0,null,{"$f":"F46*H29","v":0},null,{"$f":"F46*J29","v":0},null,{"$f":"F46*L29","v":0}]
[null,18,"Subtotal \"D\" =",null,null,null,null,{"$f":"SUM(H41:H46)","v":0},null,{"$f":"SUM(J41:J46)","v":0},null,{"$f":"SUM(L41:L46)","v":0}]
[]
["E.","**OCIP Program Deduction   **Deduct Workers Compensation & General Liability Ins."]
[null,19,"Total D16+D17",null,null,null,null,{"$f":"SUM(H45:H46)*-1","v":0},null,{"$f":"SUM(J45:J46)*-1","v":0},null,{"$f":"SUM(L45:L46)*-1","v":0}]
[]
["F.","OVERHEAD & PROFIT"]
[null,20,"Overhead & Profit",null,null,0,null,{"$f":"(H29+H38+H47+H50)*$F$53","v":0},null,{"$f":"(J47+J38+J29+J50)*$F$53","v":0},null,{"$f":"(L47+L38+L29+L50)*$F$53","v":0}]
[null,null,"(B3+C10+D18+E19)"]
[]
["G.","Equipment Rates"]
[null,21,"List as applicable",null,null,null,null,0,null,0,null,0]
[]
[]
["G.","Total Billing Rate",null,null,null,null,null,{"$f":"H57+H53+H47+H38+H29+H50","v":0},null,{"$f":"J57+J53+J47+J38+J29+J50","v":0},null,{"$f":"L57+L53+L47+L38+L29+L50","v":0}]

{"sheet":"Technician 1","index":2,"n_rows":78,"n_cols":17,"rows_kept":78,"cut":false,"hidden":false,"merged":[[6,3,6,11],[0,3,0,11],[1,3,1,11],[2,3,2,11],[3,3,3,11],[4,3,4,11]]}
[null,null,null,"NAME of General Contractor"]
[null,null,null,"Street City",null,null,null,null,null,null,null,null,null,null,null,null,"Number of employees is a guess"]
[null,null,null,"Utah",null,null,null,null,null,null,null,null,null,null,null,null,"Bard hires some under-the-table"]
[null,null,null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,"# of Employees"]
[]
["-"]
[null,null,null,"Labor Cost per Hour",null,null,null,null,null,null,null,null,"**Non-Union"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alm",3]
[null,"Job:",null,null,null,null,null,null,null,null,"Contract #:",null,null,null,null,"Chem",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FE",3]
[null,"Company Name:",null,null,"Company",null,null,null,"Prepared by:",null,"Compliance Division FSS",null,null,null,null,"Mgm",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Office",4]
[null,"Trade:",null,"Division 21",null,null,null,null,"Rate Effective:",null,null,"to",null,null,null,"Other",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinks",4]
[null,"Classification:",null,null,"Pipe/Alarm Technician",null,null,null,null,null,{"$f":"IF(K17=FALSE,\"Davis-Bacon?\",\"Davis Bacon\")","v":"Davis-Bacon?"},null,null,null,null,"Steam",3]
[null,"(i.e.: Technician, Fitter, Lead or Supervisor)",null,null,null,null,null,null,null,null,false,null,null,null,null,null,{"$f":"+SUM(Q8:Q16)","v":23}]
[]
[null,null,null,null,null,null,null,null,"Straight Time",null,"Time & 1/2",null,"Double Time",null,"Per Annum",null,"Per month"]
[null,"A.","BASE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"160*13","v":2080},"hrs",{"$f":"160","v":160}]
[null,null,1,"Base Wage",null,18,null,null,{"$f":"IF(K17=FALSE,+F21,I67)","v":18},null,{"$f":"I21*1.5","v":27},null,{"$f":"I21*2","v":36},null,{"$f":"+I21*$O$20","v":37440},null,{"$f":"+I21*$Q$20","v":2880}]
[null,null,null,"Shift Differential ( if applicable)"]
[null,null,null,"1st Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"2nd Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"3rd Shift",null,null,null,null,0,null,0,null,0]
[]
[null,"B.","VACATION & HOLIDAY"]
[null,null,2,"Vacation & Holiday - Add to Base Wage",null,null,0.05,null,{"$f":"+I21*G28","v":0.9},null,{"$f":"I28","v":0.9},null,{"$f":"I28","v":0.9},null,{"$f":"+I28*$O$20","v":1872},null,{"$f":"+I28*$Q$20","v":144}]
[null,null,{"$f":"+C28+1","v":3},"Subtotal of  \"A + B\" =",null,null,null,null,{"$f":"I21+I28","v":18.899999999999999},null,{"$f":"K21+K28","v":27.9},null,{"$f":"M21+M28","v":36.9},null,{"$f":"+I29*$O$20","v":39312},null,{"$f":"+I29*$Q$20","v":3024}]
[]
[null,"C.","BENEFITS  "]
[null,null,{"$f":"+C29+1","v":4},"Health & Welfare",null,null,null,null,1.05,null,{"$f":"I32","v":1.05},null,{"$f":"I32","v":1.05},null,{"$f":"+I32*$O$20","v":2184},null,{"$f":"+I32*$Q$20","v":168}]
[null,null,{"$f":"+C32+1","v":5},"Sick",null,null,null,null,null,null,{"$f":"I33","v":0},null,{"$f":"I33","v":0}]
[null,null,{"$f":"+C33+1","v":6}]
[null,null,{"$f":"+C34+1","v":7},"Others (list add'l if applicable)"]
[null,null,{"$f":"+C35+1","v":8},"Subtotal of \"C\" =",null,null,null,null,{"$f":"SUM(I32:I33)","v":1.05},null,{"$f":"SUM(K32:K33)","v":1.05},null,{"$f":"SUM(M32:M33)","v":1.05},null,{"$f":"+I36*$O$20","v":2184},null,{"$f":"+I36*$Q$20","v":168}]
[]
[null,"D.","PAYROLL INSURANCE & TAX"]
[null,null,{"$f":"+C36+1","v":9},"FICA",null,null,7.6499999999999999E-2,null,{"$f":"G39*I29","v":1.4458499999999999},null,{"$f":"G39*K29","v":2.13435},null,{"$f":"G39*M29","v":2.8228499999999999},null,{"$f":"+I39*$O$20","v":3007.3679999999995},null,{"$f":"+I39*$Q$20","v":231.33599999999998}]
[null,null,{"$f":"+C39+1","v":10},"FUI",null,null,6.0000000000000001E-3,null,{"$f":"G40*I29","v":0.11339999999999999},null,{"$f":"G40*K29","v":0.16739999999999999},null,{"$f":"G40*M29","v":0.22139999999999999},null,235.87199999999999,null,18.143999999999998]
[null,null,{"$f":"+C40+1","v":11},"SUI",null,null,6.0000000000000001E-3,null,{"$f":"G41*I29","v":0.11339999999999999},null,{"$f":"G41*K29","v":0.16739999999999999},null,{"$f":"G41*M29","v":0.22139999999999999},null,235.87199999999999,null,18.143999999999998]
[null,null,{"$f":"+C41+1","v":12},"Workers Compensation",null,null,0.04,null,{"$f":"G42*I29","v":0.75600000000000001},null,{"$f":"G42*K29","v":1.1159999999999999},null,{"$f":"G42*M29","v":1.476},null,1572.48,null,120.96000000000001]
[null,null,{"$f":"+C42+1","v":13},"General Liability Insurance",null,null,7.4999999999999997E-2,null,{"$f":"G43*I29","v":1.4174999999999998},null,{"$f":"G43*K29","v":2.0924999999999998},null,{"$f":"G43*M29","v":2.7674999999999996},null,2948.3999999999996,null,226.79999999999995]
[null,null,{"$f":"+C43+1","v":14},"Subtotal \"D\" =",null,null,null,null,{"$f":"SUM(I39:I43)","v":3.8461499999999997},null,{"$f":"SUM(K39:K43)","v":5.6776499999999999},null,{"$f":"SUM(M39:M43)","v":7.50915},null,7999.9919999999993,null,615.38400000000001]
[]
[null,"E.","OVERHEAD & PROFIT"]
[null,null,{"$f":"+C44+1","v":15},"Overhead & Profit",null,null,0,null,{"$f":"(+I29+I36+I44)*$G$47","v":0},null,{"$f":"(+K29+K36+K44)*$G$47","v":0},null,{"$f":"(+M29+M36+M44)*$G$47","v":0},null,{"$f":"+I47*$O$20","v":0}]
[null,null,{"$f":"+C47+1","v":16},"(B3+C8+D14)",null,null,"**DO NOT INCLUDE.  To be calculated at end of Change Order Summary."]
[null,null,{"$f":"+C48+1","v":17}]
[null,null,null,null,null,null,"Monthly",null,null,null,null,null,null,null,null,null,"Per Month"]
[null,"F.","Equipment Rates",null,null,null,"per employee",null,"Per Hour",null,null,null,null,null,{"$f":"+O19","v":"Per Annum"},null," (160 hrs)"]
[null,null,{"$f":"+C49+1","v":18},"Cell Phone",null,null,80,null,{"$f":"+G52/$Q$20","v":0.5},null,{"$f":"+I52","v":0.5},null,{"$f":"+K52","v":0.5},null,{"$f":"+I52*$O$20","v":1040},null,{"$f":"+G52","v":80}]
[null,null,{"$f":"+C52+1","v":19},"Inet Offices",null,null,{"$f":"+(65+N(\"1000E\")+65+N(\"2300E\"))/Q17","v":5.6521739130434785},null,3.5326086956521743E-2,null,3.5326086956521743E-2,null,3.5326086956521743E-2,null,73.478260869565233,null,5.6521739130434785]
[null,null,20,"Licences & Training",null,null,11,null,6.8750000000000006E-2,null,6.8750000000000006E-2,null,6.8750000000000006E-2,null,143,null,11]
[null,null,21,"Tools",null,null,15,null,9.375E-2,null,9.375E-2,null,9.375E-2,null,195,null,15]
[null,null,22,"Uniform",null,null,25,null,0.15625,null,0.15625,null,0.15625,null,325,null,25]
[null,null,23,"Vehicle",null,null,600,null,3.75,null,3.75,null,3.75,null,7800,null,600]
[null,null,24,"Other",null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,25,"Subtotal \"F\" =",null,null,null,null,{"$f":"SUM(I52:I58)","v":4.604076086956522},null,{"$f":"SUM(K52:K58)","v":4.604076086956522},null,{"$f":"SUM(M52:M58)","v":4.604076086956522},null,9576.4782608695659,null,{"$f":"SUM(Q52:Q58)","v":736.6521739130435}]
[]
[null,"G.",{"$f":"+C59+1","v":26},"Bonus",null,null,{"$f":"(+I29+I36+I44+I47+I59)*0.5%","v":0.1420011304347826},null,null,null,null,null,null,null,{"$f":"+G61*$O$20","v":295.36235130434784}]
[]
[null,"H.","Total Billing Rate",null,null,null,null,null,{"$f":"I29+I36+I44+I47+I59+G61","v":28.5422272173913},null,{"$f":"K59+K47+K44+K36+K29+G61","v":39.373727217391306},null,{"$f":"M59+M47+M44+M36+M29+G61","v":50.205227217391304}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours in a year",null,"Hours in a month"]
[null,"I.","Davis Bacon",null,"(per UT170106 2017-10-27)",null,null,null,"Rate",null,"Fringes",null,null,null,2080,null,160]
[null,null,{"$f":"+C61+1","v":27},"SPRINKLER FITTER (Fire Sprinklers)",null,null,null,null,33.14,null,15.84]
[null,null,28,"LV Alarm Techs",null,null,null,null,23.91,null,{"$f":"I68+(1.5%*I68)+10.07","v":34.338650000000001},null,null,null,"Calcs",null,{"$f":"10/160","v":6.25E-2}]
[null,null,null,null,null,null,null,null,"MULTIPLIER is:"]
[null,null,null,null,null,null,null,null,{"$f":"+I63/I21","v":1.5856792898550722}]
[]
[]
[null,null,"Rev: 2018-12-31",null,"19:30:00"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
[]
[null,null,null,null,null,"Note:  Mike Lee UT, has a Repeal of The Davis Bacon Act in front of the Govt.."]
[null,null,null,null,null,null,"sponsers are: T Cruz, J Coryn"]

{"sheet":"Pipe Fitter","index":3,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[6,3,6,11],[0,3,0,11],[1,3,1,11],[2,3,2,11],[3,3,3,11],[4,3,4,11]]}
[null,null,null,{"$f":"+'Technician 1'!D1:L1","v":"NAME of General Contractor"}]
[null,null,null,{"$f":"+'Technician 1'!D2:L2","v":"Street City"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Technician 1'!Q2","v":"Number of employees is a guess"}]
[null,null,null,{"$f":"+'Technician 1'!D3:L3","v":"Utah"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Technician 1'!Q3","v":"Bard hires some under-the-table"}]
[null,null,null,{"$f":"+'Technician 1'!D4:L4","v":"Phone"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Technician 1'!Q4","v":"# of Employees"}]
[]
["-"]
[null,null,null,{"$f":"+'Technician 1'!D7:L7","v":"Labor Cost per Hour"},null,null,null,null,null,null,null,null,{"$f":"+'Technician 1'!M7","v":"**Non-Union"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Technician 1'!P9","v":"Alm"},{"$f":"+'Technician 1'!Q9","v":3}]
[null,"Job:",null,{"$f":"+'Technician 1'!D10","v":0},null,null,null,null,null,null,"Contract #:",null,null,null,null,{"$f":"+'Technician 1'!P10","v":"Chem"},{"$f":"+'Technician 1'!Q10","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Technician 1'!P11","v":"FE"},{"$f":"+'Technician 1'!Q11","v":3}]
[null,"Company Name:",null,null,{"$f":"+'Technician 1'!E12","v":"Company"},null,null,null,"Prepared by:",null,{"$f":"+'Technician 1'!K12","v":"Compliance Division FSS"},null,null,null,null,{"$f":"+'Technician 1'!P12","v":"Mgm"},{"$f":"+'Technician 1'!Q12","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Technician 1'!P13","v":"Office"},{"$f":"+'Technician 1'!Q13","v":4}]
[null,{"$f":"+'Technician 1'!B14","v":"Trade:"},null,"Division 21",null,null,null,null,"Rate Effective:",null,null,"to",null,null,null,{"$f":"+'Technician 1'!P14","v":"Other"},{"$f":"+'Technician 1'!Q14","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Technician 1'!P15","v":"Sprinks"},{"$f":"+'Technician 1'!Q15","v":4}]
[null,"Classification:",null,null,"Alarm Technician/Sprinkler Fitter",null,null,null,null,null,{"$f":"IF(K17=FALSE,\"Davis-Bacon?\",\"Davis Bacon\")","v":"Davis-Bacon?"},null,null,null,null,{"$f":"+'Technician 1'!P16","v":"Steam"},{"$f":"+'Technician 1'!Q16","v":3}]
[null,{"$f":"+'Technician 1'!B17","v":"(i.e.: Technician, Fitter, Lead or Supervisor)"},null,null,null,null,null,null,null,null,false,null,null,null,null,null,{"$f":"+'Technician 1'!Q17","v":23}]
[]
[null,null,null,null,null,null,null,null,"Straight Time",null,"Time & 1/2",null,"Double Time",null,"Per Annum",null,"Per month"]
[null,"A.","BASE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"160*13","v":2080},"hrs",{"$f":"160","v":160}]
[null,null,1,"Base Wage",null,20,null,null,{"$f":"IF(K17=FALSE,+F21,I67)","v":20},null,{"$f":"I21*1.5","v":30},null,{"$f":"I21*2","v":40},null,{"$f":"+I21*$O$20","v":41600},null,{"$f":"+I21*$Q$20","v":3200}]
[null,null,null,"Shift Differential ( if applicable)"]
[null,null,null,"1st Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"2nd Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"3rd Shift",null,null,null,null,0,null,0,null,0]
[]
[null,"B.","VACATION & HOLIDAY"]
[null,null,{"$f":"+C21+1","v":2},"Vacation & Holiday - Add to Base Wage",null,null,{"$f":"+'Technician 1'!G28","v":0.05},null,{"$f":"+I21*G28","v":1},null,{"$f":"I28","v":1},null,{"$f":"I28","v":1},null,{"$f":"+I28*$O$20","v":2080},null,{"$f":"+I28*$Q$20","v":160}]
[null,null,{"$f":"+C28+1","v":3},"Subtotal of  \"A + B\" =",null,null,null,null,{"$f":"I21+I28","v":21},null,{"$f":"K21+K28","v":31},null,{"$f":"M21+M28","v":41},null,{"$f":"+I29*$O$20","v":43680},null,{"$f":"+I29*$Q$20","v":3360}]
[]
[null,"C.","BENEFITS  "]
[null,null,{"$f":"+C29+1","v":4},"Health & Welfare",null,null,null,null,1.05,null,{"$f":"I32","v":1.05},null,{"$f":"I32","v":1.05}]
[null,null,{"$f":"+C32+1","v":5},"Sick"]
[null,null,{"$f":"+C33+1","v":6}]
[null,null,{"$f":"+C34+1","v":7},"Others (list add'l if applicable)",null,null,null,null,null,null,{"$f":"I35","v":0},null,{"$f":"I35","v":0}]
[null,null,{"$f":"+C35+1","v":8},"Subtotal of \"C\" =",null,null,null,null,{"$f":"SUM(I32:I35)","v":1.05},null,{"$f":"SUM(K32:K35)","v":1.05},null,{"$f":"SUM(M32:M35)","v":1.05},null,{"$f":"+I36*$O$20","v":2184},null,{"$f":"+I36*$Q$20","v":168}]
[]
[null,"D.","PAYROLL INSURANCE & TAX"]
[null,null,{"$f":"+C36+1","v":9},"FICA",null,null,{"$f":"+'Technician 1'!G39","v":7.6499999999999999E-2},null,{"$f":"G39*I29","v":1.6065},null,{"$f":"G39*K29","v":2.3715000000000002},null,{"$f":"G39*M29","v":3.1364999999999998},null,{"$f":"+I39*$O$20","v":3341.52},null,{"$f":"+I39*$Q$20","v":257.04000000000002}]
[null,null,{"$f":"+C39+1","v":10},"FUI",null,null,{"$f":"+'Technician 1'!G40","v":6.0000000000000001E-3},null,{"$f":"G40*I29","v":0.126},null,{"$f":"G40*K29","v":0.186},null,{"$f":"G40*M29","v":0.246},null,262.08,null,20.16]
[null,null,{"$f":"+C40+1","v":11},"SUI",null,null,{"$f":"+'Technician 1'!G41","v":6.0000000000000001E-3},null,{"$f":"G41*I29","v":0.126},null,{"$f":"G41*K29","v":0.186},null,{"$f":"G41*M29","v":0.246},null,262.08,null,20.16]
[null,null,{"$f":"+C41+1","v":12},"Workers Compensation",null,null,{"$f":"+'Technician 1'!G42","v":0.04},null,{"$f":"G42*I29","v":0.84},null,{"$f":"G42*K29","v":1.24},null,{"$f":"G42*M29","v":1.6400000000000001},null,1747.2,null,134.4]
[null,null,{"$f":"+C42+1","v":13},"General Liability Insurance",null,null,{"$f":"+'Technician 1'!G43","v":7.4999999999999997E-2},null,{"$f":"G43*I29","v":1.575},null,{"$f":"G43*K29","v":2.3249999999999997},null,{"$f":"G43*M29","v":3.0749999999999997},null,3276,null,252]
[null,null,{"$f":"+C43+1","v":14},"Subtotal \"D\" =",null,null,null,null,{"$f":"SUM(I39:I43)","v":4.2734999999999994},null,{"$f":"SUM(K39:K43)","v":6.3085000000000004},null,{"$f":"SUM(M39:M43)","v":8.3434999999999988},null,8888.8799999999992,null,683.75999999999988]
[]
[null,"E.","OVERHEAD & PROFIT"]
[null,null,{"$f":"+C44+1","v":15},"Overhead & Profit",null,null,{"$f":"+'Technician 1'!G47","v":0},null,{"$f":"(+I29+I36+I44)*$G$47","v":0},null,{"$f":"(+K29+K36+K44)*$G$47","v":0},null,{"$f":"(+M29+M36+M44)*$G$47","v":0}]
[null,null,{"$f":"+C47+1","v":16},"(B3+C8+D14)",null,null,"**DO NOT INCLUDE.  To be calculated at end of Change Order Summary."]
[null,null,{"$f":"+C48+1","v":17}]
[null,null,null,null,null,null,"Monthly",null,null,null,null,null,null,null,null,null,"Per Month"]
[null,"F.","Equipment Rates",null,null,null,"per employee",null,"Per Hour",null,null,null,null,null,{"$f":"+O19","v":"Per Annum"},null,"(160 hrs)"]
[null,null,{"$f":"+C49+1","v":18},"Cell Phone",null,null,80,null,{"$f":"+G52/$Q$20","v":0.5},null,{"$f":"+I52","v":0.5},null,{"$f":"+K52","v":0.5},null,{"$f":"+I52*$O$20","v":1040},null,{"$f":"+G52","v":80}]
[null,null,{"$f":"+C52+1","v":19},"Inet Offices",null,null,{"$f":"+(60+N(\"1000E\")+60+N(\"2300E\"))/Q17","v":5.2173913043478262},null,{"$f":"+G53/$Q$20","v":3.2608695652173912E-2},null,3.2608695652173912E-2,null,3.2608695652173912E-2,null,67.826086956521735,null,5.2173913043478262]
[null,null,20,"Licences & Training",null,null,10,null,6.25E-2,null,6.25E-2,null,6.25E-2,null,130,null,10]
[null,null,21,"Tools",null,null,20,null,0.125,null,0.125,null,0.125,null,260,null,20]
[null,null,22,"Uniform",null,null,20,null,0.125,null,0.125,null,0.125,null,260,null,20]
[null,null,23,"Vehicle",null,null,600,null,3.75,null,3.75,null,3.75,null,7800,null,600]
[null,null,24,"Other",null,null,0,null,{"$f":"+IF(G58>0,G58/$Q$20,0)","v":0},null,0,null,0,null,0,null,0]
[null,null,25,"Subtotal \"F\" =",null,null,null,null,{"$f":"SUM(I52:I58)","v":4.5951086956521738},null,{"$f":"SUM(K52:K58)","v":4.5951086956521738},null,{"$f":"SUM(M52:M58)","v":4.5951086956521738},null,9557.826086956522,null,{"$f":"SUM(Q52:Q58)","v":735.21739130434776}]
[]
[null,"G.",{"$f":"+C59+1","v":26},"Bonus",null,null,{"$f":"(I59+I47+I44+I36+I29)*0.6%","v":0.18551165217391305},null,null,null,null,null,null,null,{"$f":"+G61*$O$20","v":385.86423652173914}]
[]
[null,"H.","Total Billing Rate",null,null,null,null,null,{"$f":"I29+I36+I44+I47+I59+G61","v":31.104120347826086},null,{"$f":"K59+K47+K44+K36+K29+G61","v":43.139120347826093},null,{"$f":"M59+M47+M44+M36+M29+G61","v":55.17412034782609}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours in a year",null,"Hours in a month"]
[null,"I.",{"$f":"+'Technician 1'!C66","v":"Davis Bacon"},null,{"$f":"+'Technician 1'!E66","v":"(per UT170106 2017-10-27)"},null,null,null,"Rate",null,"Fringes",null,null,null,2080,null,160]
[null,null,{"$f":"+C61+1","v":27},"SPRINKLER FITTER LEAD (Fire Sprinklers)",null,null,null,null,33.14,null,15.84]
[null,null,{"$f":"+'Technician 1'!C68","v":28},{"$f":"+'Technician 1'!D68","v":"LV Alarm Techs"},null,null,null,null,{"$f":"+'Technician 1'!I68","v":23.91},null,{"$f":"+'Technician 1'!K68","v":34.338650000000001},null,null,null,"Calcs",null,{"$f":"10/160","v":6.25E-2}]
[null,null,null,null,null,null,null,null,"MULTIPLIER is:"]
[null,null,null,null,null,null,null,null,{"$f":"+I63/I21","v":1.5552060173913043}]
[]
[]
[null,null,{"$f":"+'Technician 1'!C73","v":"Rev: 2018-12-31"},null,{"$f":"+'Technician 1'!E73","v":"19:30:00"}]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]

{"sheet":"Lead Fitter","index":4,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[6,3,6,11],[0,3,0,11],[1,3,1,11],[2,3,2,11],[3,3,3,11],[4,3,4,11]]}
[null,null,null,{"$f":"+'Pipe Fitter'!D1:L1","v":"NAME of General Contractor"}]
[null,null,null,{"$f":"+'Pipe Fitter'!D2:L2","v":"Street City"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Pipe Fitter'!Q2","v":"Number of employees is a guess"}]
[null,null,null,{"$f":"+'Pipe Fitter'!D3:L3","v":"Utah"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Pipe Fitter'!Q3","v":"Bard hires some under-the-table"}]
[null,null,null,{"$f":"+'Pipe Fitter'!D4:L4","v":"Phone"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Pipe Fitter'!Q4","v":"# of Employees"}]
[]
["-"]
[null,null,null,{"$f":"+'Pipe Fitter'!D7:L7","v":"Labor Cost per Hour"},null,null,null,null,null,null,null,null,{"$f":"+'Pipe Fitter'!M7","v":"**Non-Union"}]
[]
[]
[null,"Job:",null,{"$f":"+'Technician 1'!D10","v":0},null,null,null,null,null,null,"Contract #:"]
[]
[null,"Company Name:",null,null,{"$f":"+'Technician 1'!E12","v":"Company"},null,null,null,"Prepared by:",null,{"$f":"+'Technician 1'!K12","v":"Compliance Division FSS"}]
[]
[null,"Trade:",null,"Division 21",null,null,null,null,"Rate Effective:",null,null,"to"]
[]
[null,"Classification:",null,null,"Supervisory Alarm/Wet Systems",null,null,null,null,null,{"$f":"IF(K17=FALSE,\"Davis-Bacon?\",\"Davis Bacon\")","v":"Davis-Bacon?"}]
[null,{"$f":"+'Pipe Fitter'!B17","v":"(i.e.: Technician, Fitter, Lead or Supervisor)"},null,null,null,null,null,null,null,null,false,null,null,null,null,null,{"$f":"+'Pipe Fitter'!Q17","v":23}]
[]
[null,null,null,null,null,null,null,null,"Straight Time",null,"Time & 1/2",null,"Double Time",null,"Per Annum",null,"Per month"]
[null,"A.","BASE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"160*13","v":2080},"hrs",{"$f":"160","v":160}]
[null,null,1,"Base Wage",null,27.5,null,null,{"$f":"IF(K17=FALSE,+F21,I67)","v":27.5},null,{"$f":"I21*1.5","v":41.25},null,{"$f":"I21*2","v":55},null,{"$f":"+I21*$O$20","v":57200},null,{"$f":"+I21*$Q$20","v":4400}]
[null,null,null,"Shift Differential ( if applicable)"]
[null,null,null,"1st Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"2nd Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"3rd Shift",null,null,null,null,0,null,0,null,0]
[]
[null,"B.","VACATION & HOLIDAY"]
[null,null,2,"Vacation & Holiday - Add to Base Wage",null,null,{"$f":"+'Pipe Fitter'!G28","v":0.05},null,{"$f":"+I21*G28","v":1.375},null,{"$f":"I28","v":1.375},null,{"$f":"I28","v":1.375},null,{"$f":"+I28*$O$20","v":2860},null,{"$f":"+I28*$Q$20","v":220}]
[null,null,3,"Subtotal of  \"A + B\" =",null,null,null,null,{"$f":"I21+I28","v":28.875},null,{"$f":"K21+K28","v":42.625},null,{"$f":"M21+M28","v":56.375},null,{"$f":"+I29*$O$20","v":60060},null,{"$f":"+I29*$Q$20","v":4620}]
[]
[null,"C.","BENEFITS  "]
[null,null,{"$f":"+C29+1","v":4},"Health & Welfare",null,null,null,null,1.05,null,{"$f":"I32","v":1.05},null,{"$f":"I32","v":1.05}]
[null,null,{"$f":"+C32+1","v":5},"Sick"]
[null,null,{"$f":"+C33+1","v":6}]
[null,null,{"$f":"+C34+1","v":7},"Others (list add'l if applicable)",null,null,null,null,null,null,{"$f":"I35","v":0},null,{"$f":"I35","v":0}]
[null,null,{"$f":"+C35+1","v":8},"Subtotal of \"C\" =",null,null,null,null,{"$f":"SUM(I32:I35)","v":1.05},null,{"$f":"SUM(K32:K35)","v":1.05},null,{"$f":"SUM(M32:M35)","v":1.05},null,{"$f":"+I36*$O$20","v":2184},null,{"$f":"+I36*$Q$20","v":168}]
[]
[null,"D.","PAYROLL INSURANCE & TAX"]
[null,null,{"$f":"+C36+1","v":9},"FICA",null,null,{"$f":"+'Technician 1'!G39","v":7.6499999999999999E-2},null,{"$f":"G39*I29","v":2.2089374999999998},null,{"$f":"G39*K29","v":3.2608125000000001},null,{"$f":"G39*M29","v":4.3126875},null,{"$f":"+I39*$O$20","v":4594.5899999999992},null,{"$f":"+I39*$Q$20","v":353.42999999999995}]
[null,null,{"$f":"+C39+1","v":10},"FUI",null,null,{"$f":"+'Technician 1'!G40","v":6.0000000000000001E-3},null,{"$f":"G40*I29","v":0.17325000000000002},null,{"$f":"G40*K29","v":0.25575000000000003},null,{"$f":"G40*M29","v":0.33825},null,360.36,null,27.720000000000002]
[null,null,{"$f":"+C40+1","v":11},"SUI",null,null,{"$f":"+'Technician 1'!G41","v":6.0000000000000001E-3},null,{"$f":"G41*I29","v":0.17325000000000002},null,{"$f":"G41*K29","v":0.25575000000000003},null,{"$f":"G41*M29","v":0.33825},null,360.36,null,27.720000000000002]
[null,null,{"$f":"+C41+1","v":12},"Workers Compensation",null,null,{"$f":"+'Technician 1'!G42","v":0.04},null,{"$f":"G42*I29","v":1.155},null,{"$f":"G42*K29","v":1.7050000000000001},null,{"$f":"G42*M29","v":2.2549999999999999},null,2402.4,null,184.8]
[null,null,{"$f":"+C42+1","v":13},"General Liability Insurance",null,null,{"$f":"+'Technician 1'!G43","v":7.4999999999999997E-2},null,{"$f":"G43*I29","v":2.1656249999999999},null,{"$f":"G43*K29","v":3.1968749999999999},null,{"$f":"G43*M29","v":4.2281249999999995},null,4504.5,null,346.5]
[null,null,{"$f":"+C43+1","v":14},"Subtotal \"D\" =",null,null,null,null,{"$f":"SUM(I39:I43)","v":5.8760624999999997},null,{"$f":"SUM(K39:K43)","v":8.6741875000000004},null,{"$f":"SUM(M39:M43)","v":11.472312500000001},null,12222.21,null,940.17]
[]
[null,"E.","OVERHEAD & PROFIT"]
[null,null,{"$f":"+C44+1","v":15},"Overhead & Profit",null,null,{"$f":"+'Technician 1'!G47","v":0},null,{"$f":"(+I29+I36+I44)*$G$47","v":0},null,{"$f":"(+K29+K36+K44)*$G$47","v":0},null,{"$f":"(+M29+M36+M44)*$G$47","v":0}]
[null,null,{"$f":"+C47+1","v":16},"(B3+C8+D14)",null,null,"**DO NOT INCLUDE.  To be calculated at end of Change Order Summary."]
[null,null,{"$f":"+C48+1","v":17}]
[null,null,null,null,null,null,"Monthly",null,null,null,null,null,null,null,null,null,"Per Month"]
[null,"F.","Equipment Rates",null,null,null,"per employee",null,"Per Hour",null,null,null,null,null,{"$f":"+O19","v":"Per Annum"},null,"(160 hrs)"]
[null,null,{"$f":"C49+1","v":18},"Cell Phone",null,null,85,null,{"$f":"+G52/$Q$20","v":0.53125},null,{"$f":"+I52","v":0.53125},null,{"$f":"+K52","v":0.53125},null,{"$f":"+I52*$O$20","v":1105},null,{"$f":"+G52","v":85}]
[null,null,{"$f":"+C52+1","v":19},"Inet Offices",null,null,{"$f":"+(60+N(\"1000E\")+60+N(\"2300E\"))/Q17","v":5.2173913043478262},null,{"$f":"+G53/$Q$20","v":3.2608695652173912E-2},null,3.2608695652173912E-2,null,3.2608695652173912E-2,null,67.826086956521735,null,5.2173913043478262]
[null,null,20,"Licences & Training",null,null,15,null,9.375E-2,null,9.375E-2,null,9.375E-2,null,195,null,15]
[null,null,21,"Tools",null,null,20,null,0.125,null,0.125,null,0.125,null,260,null,20]
[null,null,22,"Uniform",null,null,20,null,0.125,null,0.125,null,0.125,null,260,null,20]
[null,null,23,"Vehicle",null,null,600,null,3.75,null,3.75,null,3.75,null,7800,null,600]
[null,null,24,"Other",null,null,0,null,{"$f":"+IF(G58>0,G58/$Q$20,0)","v":0},null,0,null,0,null,0,null,0]
[null,null,25,"Subtotal \"F\" =",null,null,null,null,{"$f":"SUM(I52:I58)","v":4.6576086956521738},null,{"$f":"SUM(K52:K58)","v":4.6576086956521738},null,{"$f":"SUM(M52:M58)","v":4.6576086956521738},null,9687.826086956522,null,{"$f":"SUM(Q52:Q58)","v":745.21739130434776}]
[]
[null,"G.",{"$f":"+C59+1","v":26},"Bonus",null,null,{"$f":"(I59+I47+I44+I36+I29)*0.6%","v":0.24275202717391303},null,null,null,null,null,null,null,{"$f":"+G61*$O$20","v":504.92421652173908}]
[]
[null,"H.","Total Billing Rate",null,null,null,null,null,{"$f":"I29+I36+I44+I47+I59+G61","v":40.701423222826087},null,{"$f":"K59+K47+K44+K36+K29+G61","v":57.249548222826085},null,{"$f":"M59+M47+M44+M36+M29+G61","v":73.797673222826077}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours in a year",null,"Hours in a month"]
[null,"I.","Davis Bacon",null,null,null,null,null,"Rate",null,"Fringes",null,null,null,2080,null,160]
[null,null,{"$f":"+C61+1","v":27},"SPRINKLER FITTER LEAD (Fire Sprinklers)",null,null,null,null,33.14,null,15.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calcs",null,{"$f":"10/160","v":6.25E-2}]
[null,null,null,null,null,null,null,null,"MULTIPLIER is:"]
[null,null,null,null,null,null,null,null,{"$f":"+I63/I21","v":1.4800517535573123}]
[]
[]
[null,null,{"$f":"+'Technician 1'!C73","v":"Rev: 2018-12-31"},null,{"$f":"+'Technician 1'!E73","v":"19:30:00"}]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]

{"sheet":"Inspectors","index":5,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[6,3,6,11],[0,3,0,11],[1,3,1,11],[2,3,2,11],[3,3,3,11],[4,3,4,11]]}
[null,null,null,{"$f":"+'Lead Fitter'!D1:L1","v":"NAME of General Contractor"}]
[null,null,null,{"$f":"+'Lead Fitter'!D2:L2","v":"Street City"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Lead Fitter'!Q2","v":"Number of employees is a guess"}]
[null,null,null,{"$f":"+'Lead Fitter'!D3:L3","v":"Utah"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Lead Fitter'!Q3","v":"Bard hires some under-the-table"}]
[null,null,null,{"$f":"+'Lead Fitter'!D4:L4","v":"Phone"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Lead Fitter'!Q4","v":"# of Employees"}]
[]
["-"]
[null,null,null,{"$f":"+'Lead Fitter'!D7:L7","v":"Labor Cost per Hour"},null,null,null,null,null,null,null,null,{"$f":"+'Lead Fitter'!M7","v":"**Non-Union"}]
[]
[]
[null,"Job:",null,{"$f":"+'Technician 1'!D10","v":0},null,null,null,null,null,null,"Contract #:"]
[]
[null,"Company Name:",null,null,{"$f":"+'Lead Fitter'!E12","v":"Company"},null,null,null,"Prepared by:",null,{"$f":"+'Technician 1'!K12","v":"Compliance Division FSS"}]
[]
[null,"Trade:",null,"Division 21",null,null,null,null,"Rate Effective:",null,null,"to"]
[]
[null,"Classification:",null,null,"Inspector Wet Systems",null,null,null,null,null,{"$f":"IF(K17=FALSE,\"Davis-Bacon?\",\"Davis Bacon\")","v":"Davis-Bacon?"}]
[null,{"$f":"+'Lead Fitter'!B17","v":"(i.e.: Technician, Fitter, Lead or Supervisor)"},null,null,null,null,null,null,null,null,false,null,null,null,null,null,{"$f":"+'Lead Fitter'!Q17","v":23}]
[]
[null,null,null,null,null,null,null,null,"Straight Time",null,"Time & 1/2",null,"Double Time",null,"Per Annum",null,"Per month"]
[null,"A.","BASE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"160*13","v":2080},"hrs",{"$f":"160","v":160}]
[null,null,1,"Base Wage",null,30.77,null,null,{"$f":"IF(K17=FALSE,+F21,I67)","v":30.77},null,{"$f":"I21*1.5","v":46.155000000000001},null,{"$f":"I21*2","v":61.54},null,{"$f":"+I21*$O$20","v":64001.599999999999},null,{"$f":"+I21*$Q$20","v":4923.2}]
[null,null,null,"Shift Differential ( if applicable)"]
[null,null,null,"1st Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"2nd Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"3rd Shift",null,null,null,null,0,null,0,null,0]
[]
[null,"B.","VACATION & HOLIDAY"]
[null,null,2,"Vacation & Holiday - Add to Base Wage",null,null,{"$f":"+'Lead Fitter'!G28+0.02","v":7.0000000000000007E-2},null,{"$f":"+G28*I21","v":2.1539000000000001},null,{"$f":"I28","v":2.1539000000000001},null,{"$f":"I28","v":2.1539000000000001},null,{"$f":"+I28*$O$20","v":4480.1120000000001},null,{"$f":"+I28*$Q$20","v":344.62400000000002}]
[null,null,3,"Subtotal of  \"A + B\" =",null,null,null,null,{"$f":"I21+I28","v":32.923900000000003},null,{"$f":"K21+K28","v":48.308900000000001},null,{"$f":"M21+M28","v":63.693899999999999},null,{"$f":"+I29*$O$20","v":68481.712},null,{"$f":"+I29*$Q$20","v":5267.8240000000005}]
[]
[null,"C.","BENEFITS  "]
[null,null,{"$f":"+C29+1","v":4},"Health & Welfare",null,null,null,null,2,null,{"$f":"I32","v":2},null,{"$f":"I32","v":2}]
[null,null,{"$f":"+C32+1","v":5},"Sick"]
[null,null,{"$f":"+C33+1","v":6}]
[null,null,{"$f":"+C34+1","v":7},"Others (list add'l if applicable)",null,null,null,null,null,null,{"$f":"I35","v":0},null,{"$f":"I35","v":0}]
[null,null,{"$f":"+C35+1","v":8},"Subtotal of \"C\" =",null,null,null,null,{"$f":"SUM(I32:I35)","v":2},null,{"$f":"SUM(K32:K35)","v":2},null,{"$f":"SUM(M32:M35)","v":2},null,{"$f":"+I36*$O$20","v":4160},null,{"$f":"+I36*$Q$20","v":320}]
[]
[null,"D.","PAYROLL INSURANCE & TAX"]
[null,null,{"$f":"+C36+1","v":9},"FICA",null,null,{"$f":"+'Technician 1'!G39","v":7.6499999999999999E-2},null,{"$f":"G39*I29","v":2.5186783500000001},null,{"$f":"G39*K29","v":3.6956308500000001},null,{"$f":"G39*M29","v":4.8725833500000002},null,{"$f":"+I39*$O$20","v":5238.8509679999997},null,{"$f":"+I39*$Q$20","v":402.98853600000001}]
[null,null,{"$f":"+C39+1","v":10},"FUI",null,null,{"$f":"+'Technician 1'!G40","v":6.0000000000000001E-3},null,{"$f":"G40*I29","v":0.19754340000000004},null,{"$f":"G40*K29","v":0.28985340000000004},null,{"$f":"G40*M29","v":0.38216339999999999},null,410.8902720000001,null,31.606944000000006]
[null,null,{"$f":"+C40+1","v":11},"SUI",null,null,{"$f":"+'Technician 1'!G41","v":6.0000000000000001E-3},null,{"$f":"G41*I29","v":0.19754340000000004},null,{"$f":"G41*K29","v":0.28985340000000004},null,{"$f":"G41*M29","v":0.38216339999999999},null,410.8902720000001,null,31.606944000000006]
[null,null,{"$f":"+C41+1","v":12},"Workers Compensation",null,null,{"$f":"+'Technician 1'!G42","v":0.04},null,{"$f":"G42*I29","v":1.3169560000000002},null,{"$f":"G42*K29","v":1.9323560000000002},null,{"$f":"G42*M29","v":2.5477560000000001},null,2739.2684800000006,null,210.71296000000004]
[null,null,{"$f":"+C42+1","v":13},"General Liability Insurance",null,null,{"$f":"+'Technician 1'!G43","v":7.4999999999999997E-2},null,{"$f":"G43*I29","v":2.4692925000000003},null,{"$f":"G43*K29","v":3.6231675000000001},null,{"$f":"G43*M29","v":4.7770424999999994},null,5136.1284000000005,null,395.08680000000004]
[null,null,{"$f":"+C43+1","v":14},"Subtotal \"D\" =",null,null,null,null,{"$f":"SUM(I39:I43)","v":6.7000136500000007},null,{"$f":"SUM(K39:K43)","v":9.8308611500000005},null,{"$f":"SUM(M39:M43)","v":12.961708649999998},null,13936.028392000002,null,1072.0021840000002]
[]
[null,"E.","OVERHEAD & PROFIT"]
[null,null,{"$f":"+C44+1","v":15},"Overhead & Profit",null,null,{"$f":"+'Technician 1'!G47","v":0},null,{"$f":"(+I29+I36+I44)*$G$47","v":0},null,{"$f":"(+K29+K36+K44)*$G$47","v":0},null,{"$f":"(+M29+M36+M44)*$G$47","v":0}]
[null,null,{"$f":"+C47+1","v":16},"(B3+C8+D14)",null,null,"**DO NOT INCLUDE.  To be calculated at end of Change Order Summary."]
[null,null,{"$f":"+C48+1","v":17}]
[null,null,null,null,null,null,"Monthly"]
[null,"F.","Equipment Rates",null,null,null,"per employee",null,"Per Hour",null,null,null,null,null,{"$f":"+O19","v":"Per Annum"},null,"Per Month (160 hrs)"]
[null,null,{"$f":"+C49+1","v":18},"Cell Phone",null,null,90,null,{"$f":"+Q52/$Q$20","v":0.5625},null,{"$f":"+I52","v":0.5625},null,{"$f":"+K52","v":0.5625},null,{"$f":"+I52*$O$20","v":1170},null,{"$f":"+G52","v":90}]
[null,null,{"$f":"+C52+1","v":19},"Inet Offices",null,null,{"$f":"+(60+60)/Q17","v":5.2173913043478262},null,3.2608695652173912E-2,null,3.2608695652173912E-2,null,3.2608695652173912E-2,null,67.826086956521735,null,5.2173913043478262]
[null,null,20,"Licences & Training",null,null,20,null,0.125,null,0.125,null,0.125,null,260,null,20]
[null,null,21,"Tools",null,null,35,null,0.21875,null,0.21875,null,0.21875,null,455,null,35]
[null,null,22,"Uniform",null,null,20,null,0.125,null,0.125,null,0.125,null,260,null,20]
[null,null,23,"Vehicle",null,null,600,null,3.75,null,3.75,null,3.75,null,7800,null,600]
[null,null,24,"Other",null,null,0,null,{"$f":"+G58/$Q$20","v":0},null,0,null,0,null,0,null,0]
[null,null,25,"Subtotal \"F\" =",null,null,null,null,{"$f":"SUM(I52:I58)","v":4.8138586956521738},null,{"$f":"SUM(K52:K58)","v":4.8138586956521738},null,{"$f":"SUM(M52:M58)","v":4.8138586956521738},null,10012.826086956522,null,{"$f":"SUM(Q52:Q58)","v":770.21739130434776}]
[]
[null,"G.",{"$f":"+C59+1","v":26},"Bonus",null,null,{"$f":"(I59+I47+I44+I36+I29)*0.6%","v":0.27862663407391308},null,null,null,null,null,null,null,{"$f":"+G61*$O$20","v":579.54339887373919}]
[]
[null,"H.","Total Billing Rate",null,null,null,null,null,{"$f":"+I29+I36+I44+I47+I59+G61","v":46.716398979726094},null,{"$f":"K59+K47+K44+K36+K29+G61","v":65.232246479726101},null,{"$f":"M59+M47+M44+M36+M29+G61","v":83.748093979726079}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours in a year",null,"Hours in a month"]
[null,"I.","Davis Bacon",null,null,null,null,null,"Rate",null,"Fringes",null,null,null,2080,null,160]
[null,null,{"$f":"+C61+1","v":27},"Inspectors (BFP & Fire Sprinklers)",null,null,null,null,33.14,null,15.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calcs",null,{"$f":"10/160","v":6.25E-2}]
[null,null,null,null,null,null,null,null,"MULTIPLIER is:"]
[null,null,"REV: 2016-04-19",null,"23:16:00",null,null,null,{"$f":"+I63/I21","v":1.5182450107158301}]
[]
[]
[null,null,{"$f":"+'Technician 1'!C73","v":"Rev: 2018-12-31"},null,{"$f":"+'Technician 1'!E73","v":"19:30:00"}]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]

{"sheet":"Management","index":6,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[6,3,6,11],[0,3,0,11],[1,3,1,11],[2,3,2,11],[3,3,3,11],[4,3,4,11]]}
[null,null,null,{"$f":"+Inspectors!D1","v":"NAME of General Contractor"}]
[null,null,null,{"$f":"+'Technician 1'!D2:L2","v":"Street City"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Inspectors!Q2","v":"Number of employees is a guess"}]
[null,null,null,{"$f":"+'Technician 1'!D3:L3","v":"Utah"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Inspectors!Q3","v":"Bard hires some under-the-table"}]
[null,null,null,{"$f":"+'Technician 1'!D4:L4","v":"Phone"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Inspectors!Q4","v":"# of Employees"}]
[]
["-"]
[null,null,null,{"$f":"+Inspectors!D7","v":"Labor Cost per Hour"},null,null,null,null,null,null,null,null,{"$f":"+Inspectors!M7","v":"**Non-Union"}]
[]
[]
[null,"Job:",null,{"$f":"+'Technician 1'!D10","v":0},null,null,null,null,null,null,"Contract #:"]
[]
[null,"Company Name:",null,null,{"$f":"+Inspectors!E12","v":"Company"},null,null,null,"Prepared by:",null,{"$f":"+'Technician 1'!K12","v":"Compliance Division FSS"}]
[]
[null,"Trade:",null,"Division 21",null,null,null,null,"Rate Effective:",null,null,"to"]
[]
[null,"Classification:",null,null,"Manager"]
[null,"(i.e.: Inspector, Manager etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Inspectors!Q17","v":23}]
[]
[null,null,null,null,null,null,null,null,"Straight Time",null,"Time & 1/2",null,"Double Time",null,"Per Annum",null,"Per month"]
[null,"A.","BASE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"160*13","v":2080},"hrs",{"$f":"160","v":160}]
[null,null,1,"Base Wage",null,18.5,null,null,{"$f":"+IF(F21>0,F21,0)","v":18.5},null,{"$f":"I21*1.5","v":27.75},null,{"$f":"I21*2","v":37},null,{"$f":"+I21*$O$20","v":38480},null,{"$f":"+I21*$Q$20","v":2960}]
[null,null,null,"Shift Differential ( if applicable)"]
[null,null,null,"1st Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"2nd Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"3rd Shift",null,null,null,null,0,null,0,null,0]
[]
[null,"B.","VACATION & HOLIDAY"]
[null,null,{"$f":"+C21+1","v":2},"Vacation & Holiday - Add to Base Wage",null,null,{"$f":"+Inspectors!G28+0.03","v":0.1},null,{"$f":"+G28*I21","v":1.85},null,{"$f":"I28","v":1.85},null,{"$f":"I28","v":1.85},null,{"$f":"+I28*$O$20","v":3848},null,{"$f":"+I28*$Q$20","v":296}]
[null,null,{"$f":"+C28+1","v":3},"Subtotal of  \"A1 + B2\" =",null,null,null,null,{"$f":"I21+I28","v":20.350000000000001},null,{"$f":"K21+K28","v":29.6},null,{"$f":"M21+M28","v":38.85},null,{"$f":"+I29*$O$20","v":42328},null,{"$f":"+I29*$Q$20","v":3256}]
[]
[null,"C.","BENEFITS  "]
[null,null,{"$f":"+C29+1","v":4},"Health & Welfare",null,null,null,null,1.5,null,{"$f":"I32","v":1.5},null,{"$f":"I32","v":1.5}]
[null,null,{"$f":"+C32+1","v":5},"Sick"]
[null,null,{"$f":"+C33+1","v":6}]
[null,null,{"$f":"+C34+1","v":7},"Others (list add'l if applicable)",null,null,null,null,null,null,{"$f":"I35","v":0},null,{"$f":"I35","v":0}]
[null,null,{"$f":"+C35+1","v":8},"Subtotal of \"C\" =",null,null,null,null,{"$f":"SUM(I32:I35)","v":1.5},null,{"$f":"SUM(K32:K35)","v":1.5},null,{"$f":"SUM(M32:M35)","v":1.5},null,{"$f":"+I36*$O$20","v":3120},null,{"$f":"+I36*$Q$20","v":240}]
[]
[null,"D.","PAYROLL INSURANCE & TAX"]
[null,null,{"$f":"+C36+1","v":9},"FICA",null,null,{"$f":"+'Technician 1'!G39","v":7.6499999999999999E-2},null,{"$f":"G39*I29","v":1.556775},null,{"$f":"G39*K29","v":2.2644000000000002},null,{"$f":"G39*M29","v":2.9720249999999999},null,{"$f":"+I39*$O$20","v":3238.0920000000001},null,{"$f":"+I39*$Q$20","v":249.084}]
[null,null,{"$f":"+C39+1","v":10},"FUI",null,null,{"$f":"+'Technician 1'!G40","v":6.0000000000000001E-3},null,{"$f":"G40*I29","v":0.12210000000000001},null,{"$f":"G40*K29","v":0.17760000000000001},null,{"$f":"G40*M29","v":0.2331},null,253.96800000000002,null,19.536000000000001]
[null,null,{"$f":"+C40+1","v":11},"SUI",null,null,{"$f":"+'Technician 1'!G41","v":6.0000000000000001E-3},null,{"$f":"G41*I29","v":0.12210000000000001},null,{"$f":"G41*K29","v":0.17760000000000001},null,{"$f":"G41*M29","v":0.2331},null,253.96800000000002,null,19.536000000000001]
[null,null,{"$f":"+C41+1","v":12},"Workers Compensation",null,null,{"$f":"+'Technician 1'!G42","v":0.04},null,{"$f":"G42*I29","v":0.81400000000000006},null,{"$f":"G42*K29","v":1.1840000000000002},null,{"$f":"G42*M29","v":1.554},null,1693.1200000000001,null,130.24]
[null,null,{"$f":"+C42+1","v":13},"General Liability Insurance",null,null,{"$f":"+'Technician 1'!G43","v":7.4999999999999997E-2},null,{"$f":"G43*I29","v":1.5262500000000001},null,{"$f":"G43*K29","v":2.2200000000000002},null,{"$f":"G43*M29","v":2.9137499999999998},null,3174.6000000000004,null,244.20000000000002]
[null,null,{"$f":"+C43+1","v":14},"Subtotal \"D\" =",null,null,null,null,{"$f":"SUM(I39:I43)","v":4.1412250000000004},null,{"$f":"SUM(K39:K43)","v":6.0236000000000001},null,{"$f":"SUM(M39:M43)","v":7.9059749999999998},null,8613.7480000000014,null,662.596]
[]
[null,"E.","OVERHEAD & PROFIT"]
[null,null,{"$f":"+C44+1","v":15},"Overhead & Profit",null,null,{"$f":"+'Technician 1'!G47","v":0},null,{"$f":"(+I29+I36+I44)*$G$47","v":0},null,{"$f":"(+K29+K36+K44)*$G$47","v":0},null,{"$f":"(+M29+M36+M44)*$G$47","v":0}]
[null,null,{"$f":"+C47+1","v":16},"(B3+C8+D14)",null,null,"**DO NOT INCLUDE.  To be calculated at end of Change Order Summary."]
[null,null,{"$f":"+C48+1","v":17}]
[null,null,null,null,null,null,"Monthly"]
[null,"F.","Equipment Rates",null,null,null,"per employee",null,"Per Hour",null,null,null,null,null,{"$f":"+O19","v":"Per Annum"},null,"Per Month (160 hrs)"]
[null,null,{"$f":"+C49+1","v":18},"Cell Phone",null,null,90,null,{"$f":"+Q52/$Q$20","v":0.5625},null,{"$f":"+I52","v":0.5625},null,{"$f":"+K52","v":0.5625},null,{"$f":"+I52*$O$20","v":1170},null,{"$f":"+G52","v":90}]
[null,null,{"$f":"+C52+1","v":19},"Inet Offices",null,null,{"$f":"+(60+60)/Q17","v":5.2173913043478262},null,3.2608695652173912E-2,null,3.2608695652173912E-2,null,3.2608695652173912E-2,null,67.826086956521735,null,5.2173913043478262]
[null,null,20,"Licences & Training",null,null,25,null,0.15625,null,0.15625,null,0.15625,null,325,null,25]
[null,null,21,"Tools",null,null,30,null,0.1875,null,0.1875,null,0.1875,null,390,null,30]
[null,null,22,"Uniform",null,null,20,null,0.125,null,0.125,null,0.125,null,260,null,20]
[null,null,23,"Vehicle",null,null,600,null,3.75,null,3.75,null,3.75,null,7800,null,600]
[null,null,24,"Other",null,null,null,null,{"$f":"+IF(G58>0,G58/$Q$20,0)","v":0},null,0,null,0,null,0,null,0]
[null,null,25,"Subtotal \"F\" =",null,null,null,null,{"$f":"SUM(I52:I58)","v":4.8138586956521738},null,{"$f":"SUM(K52:K58)","v":4.8138586956521738},null,{"$f":"SUM(M52:M58)","v":4.8138586956521738},null,10012.826086956522,null,{"$f":"SUM(Q52:Q58)","v":770.21739130434776}]
[]
[null,"G.",{"$f":"+C59+1","v":26},"Bonus",null,null,{"$f":"(+I29+I36+I44+I47+I59)*0.6%","v":0.18483050217391303},null,null,null,null,null,null,null,{"$f":"+G61*$O$20","v":384.4474445217391}]
[]
[null,"H.","Total Billing Rate",null,null,null,null,null,{"$f":"+I29+I36+I44+I47+I59+G61","v":30.989914197826085},null,{"$f":"K59+K47+K44+K36+K29+G61","v":42.122289197826092},null,{"$f":"M59+M47+M44+M36+M29+G61","v":53.254664197826095}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours in a year",null,"Hours in a month"]
[null,"I.","Davis Bacon",null,null,null,null,null,"Rate",null,"Fringes",null,null,null,2080,null,160]
[null,null,{"$f":"+C61+1","v":27},"Not at Management Level",null,null,null,null,0,null,0]
[null,null,"They get ALL full benefits as by definition of Management",null,null,null,null,null,null,null,null,null,null,null,"Calcs",null,{"$f":"10/160","v":6.25E-2}]
[null,null,null,null,null,null,null,null,"MULTIPLIER is:"]
[null,null,null,null,null,null,null,null,{"$f":"+I63/I21","v":1.6751304971797885}]
[]
[]
[null,null,{"$f":"+'Technician 1'!C73","v":"Rev: 2018-12-31"},null,{"$f":"+'Technician 1'!E73","v":"19:30:00"}]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]

{"sheet":"Corp","index":7,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[6,3,6,11],[0,3,0,11],[1,3,1,11],[2,3,2,11],[3,3,3,11],[4,3,4,11]]}
[null,null,null,{"$f":"+Management!D1","v":"NAME of General Contractor"}]
[null,null,null,{"$f":"+'Technician 1'!D2:L2","v":"Street City"}]
[null,null,null,{"$f":"+'Technician 1'!D3:L3","v":"Utah"}]
[null,null,null,{"$f":"+'Technician 1'!D4:L4","v":"Phone"}]
[]
["-"]
[null,null,null,{"$f":"+Management!D7","v":"Labor Cost per Hour"},null,null,null,null,null,null,null,null,{"$f":"+Management!M7","v":"**Non-Union"}]
[]
[]
[null,"Job:",null,{"$f":"+'Technician 1'!D10","v":0},null,null,null,null,null,null,"Contract #:"]
[]
[null,"Company Name:",null,null,{"$f":"+Management!E12","v":"Company"},null,null,null,"Prepared by:",null,{"$f":"+'Technician 1'!K12","v":"Compliance Division FSS"}]
[]
[null,"Trade:",null,"Division 21",null,null,null,null,"Rate Effective:",null,null,"to"]
[]
[null,"Classification:",null,null,"Experimental"]
[null,{"$f":"+Management!B17","v":"(i.e.: Inspector, Manager etc.)"},null,null,null,null,null,null,null,null,false,null,null,null,null,null,{"$f":"+'Technician 1'!Q17","v":23}]
[]
[null,null,null,null,null,null,null,null,"Straight Time",null,"Time & 1/2",null,"Double Time",null,"Per Annum",null,"Per month"]
[null,"A.","BASE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"160*13","v":2080},null,{"$f":"160","v":160}]
[null,null,1,"Base Wage",null,45,null,null,{"$f":"IF(F21>0,F21,0)","v":45},null,{"$f":"I21*1.5","v":67.5},null,{"$f":"I21*2","v":90},null,{"$f":"+I21*$O$20","v":93600},null,{"$f":"+I21*$Q$20","v":7200}]
[null,null,null,"Shift Differential ( if applicable)"]
[null,null,null,"1st Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"2nd Shift",null,null,null,null,0,null,0,null,0]
[null,null,null,"3rd Shift",null,null,null,null,0,null,0,null,0]
[]
[null,"B.","VACATION & HOLIDAY"]
[null,null,{"$f":"+C21+1","v":2},"Vacation & Holiday - Add to Base Wage",null,null,{"$f":"+Management!G28+0.1","v":0.2},null,{"$f":"+I21*G28","v":9},null,{"$f":"I28","v":9},null,{"$f":"I28","v":9}]
[null,null,{"$f":"+C28+1","v":3},"Subtotal of  \"A1 + B2\" =",null,null,null,null,{"$f":"I21+I28","v":54},null,{"$f":"K21+K28","v":76.5},null,{"$f":"M21+M28","v":99},null,{"$f":"+I29*$O$20","v":112320},null,{"$f":"+I29*$Q$20","v":8640}]
[]
[null,"C.","BENEFITS  "]
[null,null,{"$f":"+C29+1","v":4},"Health & Welfare",null,null,null,null,2,null,{"$f":"I32","v":2},null,{"$f":"I32","v":2}]
[null,null,{"$f":"+C32+1","v":5},"Sick"]
[null,null,{"$f":"+C33+1","v":6}]
[null,null,{"$f":"+C34+1","v":7},"Others (list add'l if applicable)",null,null,null,null,null,null,{"$f":"I35","v":0},null,{"$f":"I35","v":0}]
[null,null,{"$f":"+C35+1","v":8},"Subtotal of \"C\" =",null,null,null,null,{"$f":"SUM(I32:I35)","v":2},null,{"$f":"SUM(K32:K35)","v":2},null,{"$f":"SUM(M32:M35)","v":2},null,{"$f":"+I36*$O$20","v":4160},null,{"$f":"+I36*$Q$20","v":320}]
[]
[null,"D.","PAYROLL INSURANCE & TAX"]
[null,null,{"$f":"+C36+1","v":9},"FICA",null,null,7.6499999999999999E-2,null,{"$f":"G39*I29","v":4.1310000000000002},null,{"$f":"G39*K29","v":5.8522499999999997},null,{"$f":"G39*M29","v":7.5735000000000001},null,{"$f":"+I39*$O$20","v":8592.48},null,{"$f":"+I39*$Q$20","v":660.96}]
[null,null,{"$f":"+C39+1","v":10},"FUI",null,null,6.0000000000000001E-3,null,{"$f":"G40*I29","v":0.32400000000000001},null,{"$f":"G40*K29","v":0.45900000000000002},null,{"$f":"G40*M29","v":0.59399999999999997},null,673.92000000000007,null,51.84]
[null,null,{"$f":"+C40+1","v":11},"SUI",null,null,6.0000000000000001E-3,null,{"$f":"G41*I29","v":0.32400000000000001},null,{"$f":"G41*K29","v":0.45900000000000002},null,{"$f":"G41*M29","v":0.59399999999999997},null,673.92000000000007,null,51.84]
[null,null,{"$f":"+C41+1","v":12},"Workers Compensation",null,null,1.4500000000000001E-2,null,{"$f":"G42*I29","v":0.78300000000000003},null,{"$f":"G42*K29","v":1.1092500000000001},null,{"$f":"G42*M29","v":1.4355},null,1628.64,null,125.28]
[null,null,{"$f":"+C42+1","v":13},"General Liability Insurance",null,null,4.0000000000000002E-4,null,{"$f":"G43*I29","v":2.1600000000000001E-2},null,{"$f":"G43*K29","v":3.0600000000000002E-2},null,{"$f":"G43*M29","v":3.9600000000000003E-2},null,44.928000000000004,null,3.4560000000000004]
[null,null,{"$f":"+C43+1","v":14},"Subtotal \"D\" =",null,null,null,null,{"$f":"SUM(I39:I43)","v":5.5836000000000006},null,{"$f":"SUM(K39:K43)","v":7.910099999999999},null,{"$f":"SUM(M39:M43)","v":10.236599999999999},null,11613.888000000001,null,893.37600000000009]
[]
[null,"E.","OVERHEAD & PROFIT"]
[null,null,{"$f":"+C44+1","v":15},"Overhead & Profit",null,null,"**DO NOT INCLUDE.  To be calculated at end of Change Order Summary."]
[null,null,{"$f":"+C47+1","v":16},"(B3+C8+D14)"]
[null,null,{"$f":"+C48+1","v":17}]
[null,null,null,null,null,null,"Monthly"]
[null,"F.","Equipment Rates",null,null,null,"per employee",null,"Per Hour",null,null,null,null,null,{"$f":"+O19","v":"Per Annum"},null,"Per Month (160 hrs)"]
[null,null,{"$f":"+C47+1","v":16},"Cell Phone",null,null,90,null,{"$f":"+G52/$Q$20","v":0.5625},null,{"$f":"+I52","v":0.5625},null,{"$f":"+K52","v":0.5625},null,{"$f":"+I52*$O$20","v":1170},null,{"$f":"+G52","v":90}]
[null,null,{"$f":"+C52+1","v":17},"Inet Offices",null,null,{"$f":"+(60+60)/Q17","v":5.2173913043478262},null,{"$f":"+G53/$Q$20","v":3.2608695652173912E-2},null,3.2608695652173912E-2,null,3.2608695652173912E-2,null,67.826086956521735,null,5.2173913043478262]
[null,null,18,"Licences & Training",null,null,100,null,0.625,null,0.625,null,0.625,null,1300,null,100]
[null,null,19,"Tools",null,null,35,null,0.21875,null,0.21875,null,0.21875,null,455,null,35]
[null,null,20,"Uniform",null,null,20,null,0.125,null,0.125,null,0.125,null,260,null,20]
[null,null,21,"Vehicle",null,null,600,null,3.75,null,3.75,null,3.75,null,7800,null,600]
[null,null,22,"Other",null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,21,"Subtotal \"F\" =",null,null,null,null,{"$f":"SUM(I52:I58)","v":5.3138586956521738},null,{"$f":"SUM(K52:K58)","v":5.3138586956521738},null,{"$f":"SUM(M52:M58)","v":5.3138586956521738},null,{"$f":"+I59*$O$20","v":11052.826086956522},null,{"$f":"SUM(Q52:Q58)","v":850.21739130434776}]
[]
[null,"G.",{"$f":"+C58+1","v":23},"Bonus",null,null,{"$f":"(I59+I47+I44+I36+I29)*0.6%","v":0.40138475217391306},null,null,null,null,null,null,null,{"$f":"+G61*$O$20","v":834.88028452173921}]
[]
[null,"H.","Total Billing Rate",null,null,null,null,null,{"$f":"I59+I47+I44+I36+I29+G61","v":67.298843447826087},null,{"$f":"K59+K47+K44+K36+K29+G61","v":92.125343447826083},null,{"$f":"M59+M47+M44+M36+M29+G61","v":116.95184344782608}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours in a year",null,"Hours in a month"]
[null,"I.","Davis Bacon",null,null,null,null,null,"Rate",null,"Fringes",null,null,null,2080,null,160]
[null,null,21,"None at Management Corp Level",null,null,null,null,0,null,0]
[null,null,"They get ALL full benefits as by definition of Management",null,null,null,null,null,null,null,null,null,null,null,"Calcs",null,{"$f":"10/160","v":6.25E-2}]
[null,null,null,null,null,null,null,null,"MULTIPLIER is:"]
[null,null,null,null,null,null,null,null,{"$f":"+I63/I21","v":1.4955298543961353}]
[]
[]
[null,null,{"$f":"+'Technician 1'!C73","v":"Rev: 2018-12-31"},null,{"$f":"+'Technician 1'!E73","v":"19:30:00"}]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]

{"sheet":"Notes","index":8,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"# of",null,null,"Cost",null,"Total"]
["Annual","Hrs","Day","Wk","Actual",null,"Billable",null,"2017-11-22 Updated Davis Bacon"]
["Norm",8,5,52,{"$f":"+B3*C3*D3","v":2080}]
["Office/Shop Mtg",2,1,52,104,{"$f":"+E4","v":104}]
["Public Hols",8,5,1,40,{"$f":"+E5","v":40}]
["Safety Training",0.3,1,52,15.6,{"$f":"+E6","v":15.6}]
["Sick",8,5,2,80,{"$f":"+E7","v":80}]
["Training-Trade Shows",8,5,1,40,{"$f":"+E8","v":40}]
["Communication time",0.5,5,52,130]
["Vacation",8,5,2,80,{"$f":"+E10","v":80}]
[]
[]
["Per Employee",null,null,null,{"$f":"SUM(E2:E12)","v":2569.6},{"$f":"SUM(F2:F12)","v":359.6},{"$f":"E3-F13","v":1720.4}]
[null,null,null,null,null,null,null,null,"I often start with my estimated costs then add the desired markup"]
[58000,"Fuel 2018",null,null,null,null,null,null,"One needs to include the costs of:"]
[null,"Wage increase"]
[null,"Auto Insurance",null,null,null,null,null,null,"Paid time-off"]
[null,"Reserve Account for New Vehicles",null,null,null,null,null,null,"Health, workers comp and other insurances"]
[null,null,null,null,null,null,null,null,"Retirement and/or union benefits"]
[null,null,null,null,null,null,null,null,"Training (e.g., initial or basic training, training to stay up-to-speed or to enhance skills in a current position, certifications training, ‘transition’ training, and safety training)"]
[null,null,null,null,null,null,null,null,"Company equipment and general supplies utilized by individuals, or by groups of employees"]
[null,null,null,null,null,null,null,null,"If an employee utilizes office or shop space, the cost of their workspace (facilities cost per employee)"]
[null,null,null,null,null,null,null,null,"Errors, rework, and warranty costs"]
[null,null,null,null,null,null,null,null,"Supervision and support"]
[null,null,null,null,null,null,null,null,"Transportation time and costs"]
[null,null,null,null,null,null,null,null,"Client communication time and costs (time spent communicating with clients while not on site)"]
[null,null,null,null,null,null,null,null,"Time and cost not assigned to jobs for administration, company meetings, and “no work available”."]
[]
[]
[]
[null,null,null,null,null,null,null,"If","you don’t have the job or the employee,"]
[null,null,null,null,null,null,null,"then"," do you still have the expense?"]
[]
[null,null,null,null,null,null,null,"if ","YES"]
[null,null,null,null,null,null,null,"then","Overhead  (Fixed)"]
[null,null,null,null,null,null,null,"else"]
[null,null,null,null,null,null,null,null,"Labor"]
[null,null,null,null,null,null,null,null,"add 50 hr, 1 hr a week for meetings"]

{"sheet":"Rate notes","index":9,"n_rows":103,"n_cols":6,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Labour Rates.txt"]
[null,"Mods: 22:28 2017-07-06"]
[null,"Mods: 2017-04-25"]
[]
[null,null,"1. Put neither Overhead, nor burden, nor Profit Burden on labor.",null,null,"FSS"]
[null,null,"It will not work!"]
[null,null,"Don't play games with the numbers."]
[]
[null,null,"Charge Out' is hourly Rate times",2.6,"(income)",{"$f":"+D10","v":2.6}]
[null,null,"      'Labor Burden' is",{"$f":"1.48","v":1.48},"(an EXPENSE)",{"$f":"+D11+0.02","v":1.5}]
[]
[null,null,"( just remember: Charge out is INCOME.  Burden is EXPENDITURE)"]
[]
[null,null,"So for a $20/$25 per hr employee:"]
[null,null,"You would charge work out at:"]
[null,null,"20 x 2.6 or:",{"$f":"20*$D$10","v":52},"per hour",{"$f":"20*$F$10","v":52}]
[null,null,"25 x 2.6 or:",{"$f":"25*$D$10","v":65},{"$f":"+E17","v":"per hour"},{"$f":"20*$F$11","v":30}]
[null,null,"OR"]
[null,null,"Better yet:"]
[null,null,"Labor Burden is:"]
[null,null,"20 x 1.48 or:",{"$f":"20*$D$11","v":29.6},{"$f":"+E17","v":"per hour"},{"$f":"20*$F$11","v":30}]
[null,null,"25 x 1.48 or:",{"$f":"25*$D$11","v":37},{"$f":"+E22","v":"per hour"},{"$f":"25*$F$11","v":37.5}]
[null,null," (this would be the number that you put on your estimate sheet)"]
[]
[null,null,"SO"]
[null,null,"Total Labor Cost for an 8 hr job for one $20 or $25 per hour employee is"]
[null,null,{"$f":"+D22&\" x 8 or \"","v":"29.6 x 8 or "},{"$f":"+D22*8","v":236.8},"per day",{"$f":"+F22*8","v":240}]
[null,null,{"$f":"+D23&\" x 8 or \"","v":"37 x 8 or "},{"$f":"+D23*8","v":296},{"$f":"+E28","v":"per day"},{"$f":"+F23*8","v":300}]
[]
[null,null,"And so:"]
[null,null," to the above you add the correct markup:",{"$f":"+$D$11","v":1.48},null,{"$f":"+D32+0.02","v":1.5}]
[null,null,"i.e:"]
[null,null,{"$f":"+D28&\" *\"","v":"236.8 *"},{"$f":"+$D$32","v":1.48},{"$f":"+D28*D34","v":350.464},{"$f":"+F28*F32","v":360}]
[null,null,{"$f":"+D29&\" *\"","v":"296 *"},{"$f":"+$D$32","v":1.48},{"$f":"+D29*D35","v":438.08},{"$f":"+F29*F32","v":450}]
[null,null,"This is the TOTAL price to quote to the Customer/Client."]
[null,null,"       (as you can see this is NOT an hourly rate!)"]
[]
[]
[null,null,"Per Hour"]
[null,null,"        Employee Pay:",20,25]
[null,null,"  Plus Labor Burden:",{"$f":"+D22","v":29.6},{"$f":"+D23","v":37}]
[null,null,"          Plus MarkUp:",{"$f":"SUM(D41:D42)","v":49.6},55.5]
[]
[]
[null,null,"IN the FSS Costing Shhets, for the Multiplier on the Labour Rate, I use:"]
[null,null," 1.50 * 1.75 =",{"$f":"1.5*1.75","v":2.625}]
[null,null,"SO"]
[null,null,"     $20 pay =",{"$f":"+D41*D47","v":52.5},"and"]
[null,null,"     $25 pay =",{"$f":"+E41*D47","v":65.625}]
[]
[null,null,"Note:"]
[null,null,"2. if you disclose your rate per hour, which you should never do, "]
[null,null,"   you are setting yourself up for a fight near the end of the job when they decide"]
[null,null,"   you are charging too much for your work."]
[]
[null,null,"3. When you put your overhead burden on labor, "]
[null,null,"   your overhead is dependent on every employee working every day. "]
[null,null,"   If someone misses work, the overhead expense is still incurred, "]
[null,null,"   but the opportunity to recover overhead for that day is gone."]
[null,null,"   Overhead is a 24 hours a day, seven days a week, 52 weeks a year monster."]
[null,null,"   It doesn’t stop because somebody doesn’t show up for work."]
[]
[null,null,"SO ..."]
[]
[null,null,"4. Instead use a flat markup; it provides the overhead dollars,"]
[null,null,"regardless of who shows up for work."]
[null,null,"Jobs will get done, you get paid, and"]
[null,null," no fights at the end of the job about your labour rate."]
[]
[]
[null,null,"Arun"]
[null,null,"Ref: US bureau of Statistics"]
[]
[null,null,"Definition:"]
[null,null,"Burden rate is defined as the total indirect contract costs,"]
[null,null," calculated as a percentage of the construction company's direct labor. "]
[null,null,"In other words, for every dollar of direct labor allocated to a contract,"]
[null,null," burden is applied as a percentage of the direct labor. "]
[null,null,"But before a contactor can accurately calculate burden rate,"]
[null,null," all contract costs assumed by the company must be fully accounted for"]
[null,null," and factored into the final burden rate equation."]
[]
[null,null,"Indirect contract costs that should be part of the final burden rate calculation include: "]
[null,null,"•Workers' compensation "]
[null,null,"•General liability and automobile insurances "]
[null,null,"•Motor vehicle and equipment repairs and maintenance "]
[null,null,"•Depreciation"]
[null,null,"•Field communications expenses "]
[null,null,"•Employee benefits such as health, life, disability, profit sharing, bonuses and 401(k) match "]
[null,null,"•Payroll taxes "]
[null,null,"•FICA"]
[]
[null,null,"The National Labor Relations Act says that employers cannot prevent employees "]
[null,null,"from discussing wages and working conditions among themselves. "]
[null,null,"The idea is that employees need to be free to organize, "]
[null,null,"and preventing them from discussing these topics would prevent them from organizing."]
[null,null,"Arun 2014-10-08"]
[]
[]
[null,"Mods: 2017-07-28   21:28"]
[null,"Mods: 2017-07-06   22:28"]
[null,"Mods: 2017-04-25"]

{"sheet":"DavisBacon","index":10,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,"Holidays"]
[null,null,null,null,"a: Vacation Pay:"]
[null,null,null,null," 8% with 5 or more years based on regular hourly rate for all hours worked"]
[null,null,null,null," 6% under 5 years based on regular hourly rate for all hours worked."]
[]
[null,null,null,null,"b: Paid holidays:"]
[null,null,null,null,"New Year's Day",1]
[null,null,null,null,"Memorial Day",{"$f":"++F11+1","v":2}]
[null,null,null,null,"Independence Day",{"$f":"++F12+1","v":3}]
[null,null,null,null,"Labor Day",4]
[null,null,null,null,"Veteran's Day",5]
[null,null,null,null,"Thanksgiving Day",6]
[null,null,null,null,"Friday after Thanksgiving Day",7]
[null,null,null,null,"Christmas Day",8]
[]
[]
[]
[]
[]
[null,null,null,null,"Note: Executive Order (EO) 13706, Establishing Paid Sick Leave"]
[null,null,null,null,"for Federal Contractors applies to all contracts subject to the"]
[null,null,null,null,"DavisBacon"]
[null,null,null,null,"Act for which the contract is awarded (and any"]
[null,null,null,null,"solicitation was issued) on or after January 1, 2017. If this"]
[null,null,null,null,"contract is covered by the EO,"]
[null,null,null,null," the contractor must provide employees with:"]
[null,null,null,null,"   one (1) hour of paid sick leave for every 30 hours"]
[null,null,null,null,"   they work, up to 56 hours of paid sick leave each year."]
[null,null,null,null,"Employees must be permitted to use paid sick leave for their"]
[null,null,null,null,"  own illness, injury or other healthrelated needs, including"]
[null,null,null,null,"preventive care; to assist a family member (or person who is"]
[null,null,null,null,"like family to the employee) who is ill, injured, or has other"]
[null,null,null,null,"healthrelated needs, including preventive care; or for reasons"]
[null,null,null,null,"resulting from, or to assist a family member (or person who is"]
[null,null,null,null,"like family to the employee) who is a victim of, domestic"]
[null,null,null,null,"violence, sexual assault, or stalking."]
[]
[null,null,null,null,"a: Vacation Pay: 8% with 5 or more years based on regular"]
[null,null,null,null,"hourly rate for all hours worked, 6% under 5 years based on"]
[null,null,null,null,"regular hourly rate for all hours worked. b: Paid"]
[null,null,null,null,"holidays: New Year's Day; Memorial Day; Independence Day;"]
[null,null,null,null,"Labor Day; Veteran's Day; Thanksgiving Day; Friday after"]
[null,null,null,null,"Thanksgiving and Christmas Day"]