{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Output","Input","Home","Company","Sentiment","Operations","Income","Workforce"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Output","index":0,"n_rows":161,"n_cols":4,"rows_kept":161,"cut":false,"hidden":true,"merged":[]}
["Question","Response"]
["Year",{"$f":"+Input!C3","v":2025}]
["Company Name",{"$f":"+Company!N14","v":"Enter company name here"}]
["Address",{"$f":"+Company!N15","v":"Enter address here"}]
["City",{"$f":"+Company!N16","v":"Enter city here"}]
["State/Province",{"$f":"+Company!N17","v":"Enter state / province here"}]
["Postal Code",{"$f":"+Company!N18","v":"Enter postal code here"}]
["Country",1]
["Contact",{"$f":"+Company!N22","v":"Enter contact name here"}]
["Contact Email",{"$f":"+Company!N23","v":"Enter contact email here"}]
["Contact Role",{"$f":"+Company!N24","v":"Enter contact role here"}]
["Currency Code",1]
["Currency Name",{"$f":"+VLOOKUP(B12,Input!$B$12:$C$17,2,FALSE)","v":"* Select *"}]
["Currency Other",{"$f":"+Company!S26","v":"If 'other' enter currency here"}]
["FTEs",{"$f":"+Company!N28","v":"Enter number of FTE employees here"}]
["PY Revenue",{"$f":"+Company!N31","v":"Enter actual revenue here"}]
["CY Revenue",{"$f":"+Company!N32","v":"Enter estimated revenue here"}]
["Years In Business",{"$f":"+Company!N34","v":"Enter years in business here"}]
["Market Segment Code",1]
["Market Segment Name",{"$f":"+VLOOKUP(B19,Input!$F$12:$G$31,2,FALSE)","v":"* Select *"}]
["Market Segment Other",{"$f":"+Company!S36","v":"If 'other enter primary source here"}]
["INNERGY Customer Code",1]
["INNERGY Customer Status",{"$f":"+VLOOKUP(B22,Input!$J$12:$K$14,2,FALSE)","v":"* Select *"},null,"x"]
["Overall Conditions Next 6 Code",1]
["Overall Conditions Next 6",{"$f":"+VLOOKUP(B24,Input!$M$12:$N$15,2,FALSE)","v":"* Select *"}]
["Overall Conditions Last 6 Code",1]
["Overall Conditions Last  6",{"$f":"VLOOKUP(B26,Input!$M$18:$N$21,2,FALSE)","v":"* Select *"}]
["Sales Pipeline Next 6 Code",1]
["Sales Pipeline Next 6",{"$f":"VLOOKUP(B28,Input!$M$24:$N$27,2,FALSE)","v":"* Select *"}]
["Sales Pipeline Last 6 Code",1]
["Sales Pipeline Last  6",{"$f":"VLOOKUP(B30,Input!$M$30:$N$33,2,FALSE)","v":"* Select *"}]
["Cash Flow Next 6 Code",1]
["Cash Flow Next 6",{"$f":"VLOOKUP(B32,Input!$Q$12:$R$15,2,FALSE)","v":"* Select *"}]
["Cash Flow Last 6 Code",1]
["Cash Flow Last  6",{"$f":"VLOOKUP(B34,Input!$Q$18:$R$21,2,FALSE)","v":"* Select *"}]
["Quality Labor Next 6 Code",1]
["Quality Labor Next 6",{"$f":"VLOOKUP(B36,Input!$Q$24:$R$27,2,FALSE)","v":"* Select *"}]
["Quality Labor Last 6 Code",1]
["Quality Labor Last  6",{"$f":"VLOOKUP(B38,Input!$Q$30:$R$33,2,FALSE)","v":"* Select *"}]
["Bid Success",{"$f":"+Operations!K13","v":"%"}]
["Backlog",{"$f":"+Operations!K15","v":"$"}]
["AR",{"$f":"+Operations!K17","v":"$"}]
["AP",{"$f":"+Operations!K19","v":"$"}]
["Assets",{"$f":"+Operations!K21","v":"$"}]
["Long Term Debt",{"$f":"+Operations!K23","v":"$"}]
["AdvanceWare",false]
["Allmoxy",false]
["Artis",false]
["AutoCAD",false]
["Cabinet Vision",false]
["Cienapps",false]
["Crows Nest",false]
["CutRite",false]
["CynCly",false]
["Empower",false]
["Epicore",false]
["Global Shop",false]
["Jobman",false]
["Microvellum",false]
["Mozaik",false]
["Production Coach",false]
["Quick Books",false]
["Sage",false]
["Seradex",false]
["Trackware",false]
["Tradesoft",false]
["WoodCadCam",false]
["INNERGY",false]
["Other",false]
["Other Name",{"$f":"+Operations!U31","v":"If 'other' enter software here"}]
["Engineering Software Code",1]
["Engineering Software",{"$f":"+VLOOKUP(B71,Input!$U$12:$V$16,2,FALSE)","v":"* Select *"}]
["Education Topics",{"$f":"+Operations!L36","v":"Enter education topics here"}]
["Business Operations - Cash Flow Code",1]
["Business Operations - Cash Flow",{"$f":"+VLOOKUP(B74,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Business Operations - Economy Code",1]
["Business Operations - Economy",{"$f":"+VLOOKUP(B76,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Business Operations - Sales and Revenue Code",1]
["Business Operations - Sales and Revenue",{"$f":"+VLOOKUP(B78,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Business Operations - Profitability Code",1]
["Business Operations - Profitability",{"$f":"+VLOOKUP(B80,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Business Operations - Project / Resource Scheduling  Code",1]
["Business Operations - Project / Resource Scheduling ",{"$f":"+VLOOKUP(B82,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Business Operations - Slippage Code",1]
["Business Operations - Slippage",{"$f":"+VLOOKUP(B84,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Business Operations - AI Automation Code",1]
["Business Operations - AI Automation",{"$f":"+VLOOKUP(B86,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Employee Value Proposition - Organization Code",1]
["Employee Value Proposition - Organization",{"$f":"+VLOOKUP(B88,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Employee Value Proposition - Culture Code",1]
["Employee Value Proposition - Culture",{"$f":"+VLOOKUP(B90,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Employee Value Proposition - People Code",1]
["Employee Value Proposition - People",{"$f":"+VLOOKUP(B92,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Employee Value Proposition - Learning & Development Code",1]
["Employee Value Proposition - Learning & Development",{"$f":"+VLOOKUP(B94,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Employee Value Proposition - Compensation Code",1]
["Employee Value Proposition - Compensation",{"$f":"+VLOOKUP(B96,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Employee Value Proposition - Benefits Code",1]
["Employee Value Proposition - Benefits",{"$f":"+VLOOKUP(B98,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Employee Value Proposition - Career Code",1]
["Employee Value Proposition - Career",{"$f":"+VLOOKUP(B100,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Employee Value Proposition - Work Code",1]
["Employee Value Proposition - Work",{"$f":"+VLOOKUP(B102,Input!$U$19:$V$23,2,FALSE)","v":"* Select *"}]
["Shop Drawing Outsourced",{"$f":"+Operations!M59","v":"Nearest 5%"}]
["Purchase 12m - ERP System - Code",1]
["Purchase 12m - ERP System",{"$f":"+VLOOKUP(B105,Input!$U$26:$V$30,2,FALSE)","v":"* Select *"}]
["Purchase 12m - CNC / Saw - Code",1]
["Purchase 12m - CNC / Saw",{"$f":"+VLOOKUP(B107,Input!$U$26:$V$30,2,FALSE)","v":"* Select *"}]
["Purchase 12m - Robotics - Code",1]
["Purchase 12m - Robotics",{"$f":"+VLOOKUP(B109,Input!$U$26:$V$30,2,FALSE)","v":"* Select *"}]
["Purchase 12m - Material Management (Storage) - Code",1]
["Purchase 12m - Material Management (Storage)",{"$f":"+VLOOKUP(B111,Input!$U$26:$V$30,2,FALSE)","v":"* Select *"}]
["Purchase 12m - Automated Finishing  - Code",1]
["Purchase 12m - Automated Finishing ",{"$f":"+VLOOKUP(B113,Input!$U$26:$V$30,2,FALSE)","v":"* Select *"}]
["Estimator - n",{"$f":"+Workforce!J18","v":0}]
["Engineer / Drafter - n",{"$f":"+Workforce!J19","v":0}]
["Project Manager - n",{"$f":"+Workforce!J20","v":0}]
["Machine Operator - n",{"$f":"+Workforce!J21","v":0}]
["Journeyman/Custom Assembler - n",{"$f":"+Workforce!J22","v":0}]
["Casegood Assembler/Production Worker - n",{"$f":"+Workforce!J23","v":0}]
["Material Handler - n",{"$f":"+Workforce!J24","v":0}]
["Finisher - n",{"$f":"+Workforce!J25","v":0}]
["Installer - n",{"$f":"+Workforce!J26","v":0}]
["Plant Manager / Foreman - n",{"$f":"+Workforce!J27","v":0}]
["Estimator - hourly rate",{"$f":"+Workforce!L18","v":0}]
["Engineer / Drafter - hourly rate",{"$f":"+Workforce!L19","v":0}]
["Project Manager - hourly rate",{"$f":"+Workforce!L20","v":0}]
["Machine Operator - hourly rate",{"$f":"+Workforce!L21","v":0}]
["Journeyman/Custom Assembler - hourly rate",{"$f":"+Workforce!L22","v":0}]
["Casegood Assembler/Production Worker - hourly rate",{"$f":"+Workforce!L23","v":0}]
["Material Handler - hourly rate",{"$f":"+Workforce!L24","v":0}]
["Finisher - hourly rate",{"$f":"+Workforce!L25","v":0}]
["Installer - hourly rate",{"$f":"+Workforce!L26","v":0}]
["Plant Manager / Foreman - hourly rate",{"$f":"+Workforce!L27","v":0}]
["Recruit and Retain Challenge",{"$f":"+Workforce!L30","v":"Enter most difficult role to recruit and retain here"}]
["Employee Wants",{"$f":"+Workforce!N32","v":"Enter what your employees want the most (other than compensation and benefits) here"}]
["Turnover",{"$f":"+Workforce!K34","v":0}]
["Consider Asking",{"$f":"+Workforce!K39","v":"Enter what we should consider asking next year"}]
["Minutes To Complete",{"$f":"+Workforce!M41","v":0}]
[{"$f":"+Income!E21","v":"Plant-Processed Sales"},{"$f":"+Income!H21","v":0}]
[{"$f":"+Income!E22","v":"Non-Plant Sales"},{"$f":"+Income!H22","v":0}]
[{"$f":"+Income!E23","v":"Installation Sales"},{"$f":"+Income!H23","v":0}]
[{"$f":"+Income!E24","v":"Total Revenue"},{"$f":"+Income!H24","v":0}]
[{"$f":"+Income!E28","v":"Plant Material"},{"$f":"+Income!H28","v":0}]
[{"$f":"+Income!E29","v":"Non-Plant Material"},{"$f":"+Income!H29","v":0}]
[{"$f":"+Income!E30","v":"Total Direct Material"},{"$f":"+Income!H30","v":0}]
[{"$f":"+Income!E32","v":"Direct Factory Staff"},{"$f":"+Income!H32","v":0}]
[{"$f":"+Income!E33","v":"In-House Installation"},{"$f":"+Income!H33","v":0}]
[{"$f":"+Income!E34","v":"Outsourced Installation"},{"$f":"+Income!H34","v":0}]
[{"$f":"+Income!E35","v":"Total Direct Labor"},{"$f":"+Income!H35","v":0}]
[{"$f":"+Income!E36","v":"Other Direct Cost"},{"$f":"+Income!H36","v":0}]
[{"$f":"+Income!E37","v":"Total Variable Cost"},{"$f":"+Income!H37","v":0}]
[{"$f":"+Income!E39","v":"Contribution Margin"},{"$f":"+Income!H39","v":0}]
[{"$f":"+Income!E42","v":"Overhead"},{"$f":"+Income!H42","v":0}]
[{"$f":"+Income!E44","v":"Indirect Factory Staff"},{"$f":"+Income!H44","v":0}]
[{"$f":"+Income!E45","v":"SG&A Staff"},{"$f":"+Income!H45","v":0}]
[{"$f":"+Income!E46","v":"Total Fixed Labor"},{"$f":"+Income!H46","v":0}]
[{"$f":"+Income!E47","v":"Total Fixed Cost"},{"$f":"+Income!H47","v":0}]
[{"$f":"+Income!E49","v":"Operating Income (EBITDA)"},{"$f":"+Income!H49","v":0}]
["INNERGY Customer Years Code",1]
["INNERGY Customer Years",{"$f":"+VLOOKUP(B160,Input!$J$18:$K$21,2,FALSE)","v":"* Select *"}]

{"sheet":"Input","index":1,"n_rows":33,"n_cols":22,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Version","Version 2025.1.2"]
[null,"CY",2025]
[null,"PY",2024]
[null,"Due","*** Your submission must be received by May 1, 2025 ***"]
[null,"Results","Results will be emailed to you by June 15, 2025."]
[]
[]
[]
[]
[null,"Survey Currency",null,null,null,"Primary Source Of Revenue",null,null,null,"INNERGY Customer",null,null,"Overall Conditions",null,"Next 6",null,"Cash Flow",null,"Next 6",null,"Engineering Software"]
[null,1,"* Select *",null,null,1,"* Select *",null,null,1,"* Select *",null,1,"* Select *",null,null,1,"* Select *",null,null,1,"* Select *"]
[null,{"$f":"+B12+1","v":2},"Australian Dollar (AUD)",null,null,{"$f":"+F12+1","v":2},"Architectural Doors",null,null,{"$f":"+J12+1","v":2},"Yes",null,2,"Improve",null,null,2,"Improve",null,null,2,"Not Satisfied"]
[null,{"$f":"+B13+1","v":3},"Canadian Dollar (CAD)",null,null,{"$f":"+F13+1","v":3},"Closets",null,null,{"$f":"+J13+1","v":3},"No",null,3,"Stay The Same",null,null,3,"Stay The Same",null,null,3,"Somewhat Satisfied"]
[null,{"$f":"+B14+1","v":4},"New Zealand Dollar (NZD)",null,null,4,"Commercial Architectural Millwork",null,null,null,null,null,4,"Decline",null,null,4,"Decline",null,null,4,"Satisfied"]
[null,{"$f":"+B15+1","v":5},"United States Dollar (USD)",null,null,5,"Custom Windows & Restoration",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Very Satisifed"]
[null,{"$f":"+B16+1","v":6},"Other",null,null,6,"High-End Residential",null,null,"INNERGY Customer Years",null,null,"Overall Conditions",null,"Last 6",null,"Cash Flow",null,"Last 6"]
[null,null,null,null,null,7,"Installation Firm",null,null,1,"* Select *",null,1,"* Select *",null,null,1,"* Select *",null,null,"Improvement Topics (all)"]
[null,null,null,null,null,8,"Mass Production Residential",null,null,{"$f":"+J18+1","v":2},"Less Than 1 Year",null,2,"Improved",null,null,2,"Improved",null,null,1,"* Select *"]
[null,"Country Location",null,null,null,9,"Mixed Commercial / Residential",null,null,{"$f":"+J19+1","v":3},"1 - 2 Years",null,3,"Stayed The Same",null,null,3,"Stayed The Same",null,null,2,"Not Important"]
[null,1,"* Select *",null,null,10,"Monumental Stairs",null,null,4,"More Than 2 Years",null,4,"Declined",null,null,4,"Declined",null,null,3,"Somewhat Important"]
[null,{"$f":"+B21+1","v":2},"Australia",null,null,11,"Moulding & Trim",null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Important"]
[null,{"$f":"+B22+1","v":3},"Canada",null,null,12,"Office Furniture",null,null,null,null,null,"Sales Pipeline",null,"Next 6",null,"Quality Labor",null,"Next 6",null,5,"Very Important"]
[null,{"$f":"+B23+1","v":4},"New Zealand",null,null,13,"Solid Surface",null,null,null,null,null,1,"* Select *",null,null,1,"* Select *"]
[null,{"$f":"+B24+1","v":5},"United States",null,null,14,"Specialty Productss",null,null,null,null,null,2,"Improve",null,null,2,"Improve",null,null,"Purchase Next 12 Months"]
[null,{"$f":"+B25+1","v":6},"Other",null,null,15,"Stone Fabrication",null,null,null,null,null,3,"Stay The Same",null,null,3,"Stay The Same",null,null,1,"* Select *"]
[null,null,null,null,null,16,"Store Fixtures",null,null,null,null,null,4,"Decline",null,null,4,"Decline",null,null,2,"Not Likely"]
[null,null,null,null,null,17,"Tradeshow Booths & Signs",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Somewhat Likely"]
[null,null,null,null,null,18,"Upholstered Furniture",null,null,null,null,null,"Sales Pipeline",null,"Last 6",null,"Quality Labor",null,"Last 6",null,4,"Likely"]
[null,null,null,null,null,19,"Components, Drawers, Parts",null,null,null,null,null,1,"* Select *",null,null,1,"* Select *",null,null,5,"Very Likely"]
[null,null,null,null,null,20,"Other",null,null,null,null,null,2,"Improved",null,null,2,"Improved"]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Stayed The Same",null,null,3,"Stayed The Same"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Declined",null,null,4,"Declined"]

{"sheet":"Home","index":2,"n_rows":33,"n_cols":25,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,17,13,20],[32,7,32,19]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Input!$C$2","v":"Version 2025.1.2"}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,{"$f":"Input!$C$3 & \" INNERGY Industry Benchmarking Tool (IIBT)\"","v":"2025 INNERGY Industry Benchmarking Tool (IIBT)"},null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,"1.  You must use a Microsoft Windows machine to complete this survey.  Do NOT use an Apple MAC."]
[]
[null,null,null,null,null,null,null,"2.  If you see a 'Security Risk' warning, please enable macros (solely used for navigation).",null,null,null,null,null,null,null,null,null,"How Do I Enable Macros?"]
[]
[]
[]
[null,null,null,null,null,null,null,"3.  If you see a 'Read-Only' warning, please click the 'Edit Workbook' button."]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"\"4.  Complete each tab, save your file locally and email it to IIBT@inverra.com.  \"&Input!C6","v":"4.  Complete each tab, save your file locally and email it to IIBT@inverra.com.  Results will be emailed to you by June 15, 2025."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Input!$C$5","v":"*** Your submission must be received by May 1, 2025 ***"}]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,"Your information is completely private and confidential.  Only aggregated results will be available to participants.",null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"We use Inverra, a third-party administrator to collect company data in order to peserve annonymity.  INNERGY will never have access to your personal data."]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,"Have a question?  Please email IIBT@inverra.com with your detailed information and we will respond shortly",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Company","index":3,"n_rows":51,"n_cols":25,"rows_kept":51,"cut":false,"hidden":false,"merged":[[18,18,18,21],[16,13,16,17],[21,13,21,17],[13,13,13,17],[14,13,14,17],[15,13,15,17],[17,13,17,17],[46,7,46,19],[35,18,35,21],[22,13,22,17],[23,13,23,17],[27,13,27,17],[30,13,30,17],[31,13,31,17],[33,13,33,17],[25,18,25,21]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Input!$C$2","v":"Version 2025.1.2"}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,{"$f":"+Home!$N$4","v":"2025 INNERGY Industry Benchmarking Tool (IIBT)"},null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," "," "," "," "," "," "," "," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Please tell us about your company (9 questions)."]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",1,"Where is your primary business location?",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "]
[null,null,null,null,null,"Company Name",null,null,null,null,null,null,null,"Enter company name here",null,null,null,null," "," "," "," "," "," "]
[null,null," ",null,null,"Address",null,null,null,null,null,null,null,"Enter address here",null,null,null,null," "," "," "," "," "," "," "]
[null,null,null,null,null,"City",null,null,null,null,null,null,null,"Enter city here",null,null,null,null," "]
[null,null,null,null,null,"State / Province",null,null,null,null,null,null,null,"Enter state / province here",null,null,null,null," "," "," "," "," "," "]
[null,null,null,null,null,"Postal Code",null,null,null,null,null,null,null,"Enter postal code here",null,null,null,null," "]
[null,null,null,null,null,"Country",null,null,null,null,null,null,null,null,null,null,null,null,"If 'other' enter country here",null,null,null," "," "]
[]
[null,null,null,2,"Who should we contact if we have questions regarding your survey responses?"]
[null,null,null,null,null,"Contact Name",null,null,null,null,null,null,null,"Enter contact name here",null,null,null,null," "]
[null,null,null,null,null,"Contact Email",null,null,null,null,null,null,null,"Enter contact email here",null,null,null,null," "]
[null,null,null,null,null,"Contact Role (what is your primary role in your company)",null,null,null,null,null,null,null,"Enter contact role here",null,null,null,null," "]
[]
[null,null,null,4,"When you entered dollar amounts in this survey, what currency did you use?",null,null,null,null,null,null,null,null,null,null,null,null,null,"If 'other' enter currency here",null,null,null," "]
[]
[null,null,null,5,"How many full-time equivalent employees do you currently have?",null,null,null,null,null,null,null,null,"Enter number of FTE employees here",null,null,null,null," "]
[]
[null,null,null,6,"What is your annual revenue (January 1 to December 31)?"]
[null,null,null,null,null,{"$f":"+Input!$C$4 & \" Actual\"","v":"2024 Actual"},null,null,null,null,null,null,null,"Enter actual revenue here",null,null,null,null," "]
[null,null,null,null,null,{"$f":"Input!$C$3 & \" Estimated\"","v":"2025 Estimated"},null,null,null,null,null,null,null,"Enter estimated revenue here",null,null,null,null," "]
[]
[null,null,null,7,"How many years has your company been in business?",null,null,null,null,null,null,null,null,"Enter years in business here",null,null,null,null," "]
[]
[null,null,null,8,"What is your primary source of revenue?",null,null,null,null,null,null,null,null,null,null,null,null,null,"If 'other enter primary source here",null,null,null,null," "]
[]
[null,null,null,9,"Are you currently a customer of INNERGY?"]
[]
[null,null,null,null,"If Yes, how long have you been a customer of INNERGY?"]
[]
[]
[]
[]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,{"$f":"+Home!$H$33","v":"Have a question?  Please email IIBT@inverra.com with your detailed information and we will respond shortly"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"ok , but duplicative with the software section"]
[null,null,null,null,null,null,null,null,null,null,"Can you please add a question that states: “How long have you been an INNERGY User?” with answers of “less than 1 year, 1-2 years, more than  2 years"]

{"sheet":"Sentiment","index":4,"n_rows":34,"n_cols":25,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,7,33,19]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Input!$C$2","v":"Version 2025.1.2"}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,{"$f":"+Home!$N$4","v":"2025 INNERGY Industry Benchmarking Tool (IIBT)"},null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"What is your CEO's view of the economy and business conditions (4 questions)?"]
[]
[null,null," ",1,"Economic Conditions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"We believe economic conditions will _____ over the next 6 months"]
[null,null,null,null,"Overall economic conditions have _____ over the past 6 months"]
[]
[null,null,null,2,"Sales Pipeline"]
[null,null,null,null,"We believe our sales pipeline will _____ over the next 6 months"]
[null,null,null,null,"Our sales pipeline _____ over the past 6 months"]
[]
[null,null,null,3,"Cash Flow"]
[null,null,null,null,"We believe our cash flow will _____ over the next 6 months"]
[null,null,null,null,"Our cash flow has _____ over the past 6 months"]
[]
[null,null,null,4,"Quality Labor"]
[null,null,null,null,"We believe availability of quality labor will _____ over the next 6 months"]
[null,null,null,null,"Availability of quality labor has _____ over the past 6 months"]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,{"$f":"+Home!$H$33","v":"Have a question?  Please email IIBT@inverra.com with your detailed information and we will respond shortly"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Operations","index":5,"n_rows":73,"n_cols":25,"rows_kept":73,"cut":false,"hidden":false,"merged":[[16,10,16,11],[14,10,14,11],[12,10,12,11],[20,10,20,11],[22,10,22,11],[72,7,72,19],[35,11,35,17],[58,12,58,13],[30,20,30,22],[18,10,18,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Input!$C$2","v":"Version 2025.1.2"}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,{"$f":"+Home!$N$4","v":"2025 INNERGY Industry Benchmarking Tool (IIBT)"},null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,"Please tell us about your current operations (12 questions).",null,null,null,null,null,null,null,null,null,"Definitions (Tip:  click the first word and press F2 button to see full text)",null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null," ",1,"What is your bid success rate?",null,null,null,null,null,"%",null,null,"Over the past 12 months, estimated $ value of proposals which were successful / $ value of proposals submitted.",null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",{"$f":"+D13+1","v":2},"What is your current backlog?",null,null,null,null,null,"$",null,null,"Backlog = $ of contracted work that has yet to be invoiced.  For the purposes of this survey, backlog is the value of sales orders that have been 'won' but have not been invoiced including those projects that are in-progess but you have not recognized revenue.  We will convert this to months of backlog automatically as part of the aggregated results. ",null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"+D15+1","v":3},"What is the amount you currently have in AR?",null,null,null,null,null,"$",null,null,"$ of invoices that you have not yet collected at the time you completed this survey.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"+D17+1","v":4},"What is the amount you currently have in AP?",null,null,null,null,null,"$",null,null,"$ of bills you owe that you have not yet paid at the time you completed this survey.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"+D19+1","v":5},{"$f":"\"What is your total amount of assets as of 12/31/\" &RIGHT(Input!$C$4,2)&\"?\"","v":"What is your total amount of assets as of 12/31/24?"},null,null,null,null,null,"$",null,null,"Value of your current assets (cash, securities, accounts receivable, inventories and the like) and the value of your long-term assets (land, buildings, plant equipment, office equipment, vehicles and the like).",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"+D21+1","v":6},"How much do you currently owe in long-term debt?",null,null,null,null,null,"$",null,null,"$ of long-term debt / loans / capital leases / obligations that you have entered in to that repayment extends more than one year out at the time you completed this survey.  Long-term liabilities differ from current liabilities, which are what a company expects to pay back within one year.  DO NOT include these types of current liabilities in this long-term debt number.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"+D23+1","v":7},"What software do you currently use?  Select all that apply.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"INNERGY"]
[null,null,null,null,null,"AdvanceWare",null,null,null,"Crows Nest",null,null,null,"Jobman",null,null,null,"Seradex",null,null,null,null,null," "]
[null,null,null,null,null,"Allmoxy",null,null,null,"CutRite",null,null,null,"Microvellum",null,null,null,"Trackware",null,null,null,null,null," "]
[null,null,null,null,null,"Artis",null,null,null,"CynCly",null,null,null,"Mozaik",null,null,null,"Tradesoft",null,null,null,null,null," "]
[null,null,null,null,null,"AutoCAD",null,null,null,"Empower",null,null,null,"Production Coach",null,null,null,"WoodCadCam",null,null,null,null,null," "]
[null,null,null,null,null,"Cabinet Vision",null,null,null,"Epicore",null,null,null,"Quick Books",null,null,null,"Other",null,null,"If 'other' enter software here",null,null," "]
[null,null,null,null,null,"Cienapps",null,null,null,"Global Shop",null,null,null,"Sage",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"+D25+1","v":8},"How satisfied are you with your current engineering software (features, training and support)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",{"$f":"+D34+1","v":9},"What education topics would be most helpful to your company?",null,null,null,null,null,null,"Enter education topics here",null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"+D36+1","v":10},"How important are each of these for your company to significantly improve in the next 12 months?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Business Operations",null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Cash Flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Economy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Sales and Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Profitability",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Project / Resource Scheduling ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Slippage",null,null,null,null,null,null,null,null,"Slippage = failure to meet a standard or deadline",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"AI Automation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Employee Value Proposition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Organization",null,null,null,null,null,null,null,null,"Teamwork, remote work, technology, employee experience",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Culture",null,null,null,null,null,null,null,null,"Values, mission/purpose, behavior/norms",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"People",null,null,null,null,null,null,null,null,"Camaraderie, senior leadership, reputation/brand",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Learning & Development",null,null,null,null,null,null,null,null,"Formal learning, informal learning, on-the-job experience",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Compensation",null,null,null,null,null,null,null,null,"Salary, bonus, evaluation",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Benefits",null,null,null,null,null,null,null,null,"Holidays, insurance, retirement, family, time-off",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Career",null,null,null,null,null,null,null,null,"Promotion, career path, opportunities, challenges",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Work",null,null,null,null,null,null,null,null,"Recognition, work-life balance, location, facilities",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"+D38+1","v":11},"What percentage of your shop drawings are outsourced (nearest 5%)?",null,null,null,null,null,null,null,"Nearest 5%",null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"+D59+1","v":12},"In the next 12 months, do you intend to purchase any of the following?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"ERP System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"CNC / Saw",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Robotics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Material Management (Storage)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Automated Finishing ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null," ",null,null,null,null,{"$f":"+Home!$H$33","v":"Have a question?  Please email IIBT@inverra.com with your detailed information and we will respond shortly"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Income","index":6,"n_rows":95,"n_cols":25,"rows_kept":95,"cut":false,"hidden":false,"merged":[[54,8,54,9],[55,7,56,9],[94,7,94,19]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Input!$C$2","v":"Version 2025.1.2"}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,{"$f":"+Home!$N$4","v":"2025 INNERGY Industry Benchmarking Tool (IIBT)"},null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Please tell us about your most recent income statement (12 input fields in gray)."]
[]
[null,null,null,null,"Enter your annual revenue and expense items in the gray cells (ignore all accounting provisions for interest income(expense), federal/state income taxes, deferral and amoritization)."]
[null,null,null,null,"See the definitions to the right of each item (Tip:  click the first word and press F2 button to see full text)."]
[null,null,null,null,"See the Position Chart at the bottom of this page to determine where to put labor costs for Lines 8, 9, 16 and 17."]
[null,null," ",null,"All labor costs should be fully loaded labor cost (base compensation, bonuses, state and federal payroll taxes and the cost of all employee benefits).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Tip:  pro-rate your overall employee benefits costs if you do not break employee benefits costs out out by position (use the labor costs you entered on lines 8, 9, 16 and 17)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Revenue",null,null,null,null,null,"Revenue for the last full fiscal year, generally January 1 - December 31.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,1,"Plant-Processed Sales",null,null,0,{"$f":"IFERROR(H21/$H$24,\"\")","v":""},null,"Revenue from products produced or which have value added on the plant floor.  Includes casework, millwork, stairs, doors, panels and countertops.  Includes custom product which incorporate specialty materials, solid surfaces, acrylics, metals or other materials applied to the items that either completely or partially manufactured, assembled or finished on your plant floor.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,2,"Non-Plant Sales",null,null,0,{"$f":"IFERROR(H22/$H$24,\"\")","v":""},null,"Revenue from products not produced internally nor have any value added to by your company.  Examples may include casework, metal, door and trim packages manufactured by another company and delivered fully assembled to your company without needing any additional processing in your plant.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,3,"Installation Sales",null,null,0,"",null,"Revenue from the installation of products by your own employees or by supplemental contract installation labor.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,4,"Total Revenue",null,null,{"$f":"+SUM(H21:H23)","v":0},"",null,"Calculated.  Plant-Process Sales + Non-Plant Sales + Installation Sales.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Variable Cost",null,null,null,null,null,"Variable costs depend on how many projects are sold and can increase (decrease) to support the company's revenue and backlog.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Direct Material",null,null,null,null,null,"Direct material costs include material used in your plant and materials not produced internally.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,5,"Plant Material",null,null,0,{"$f":"IFERROR(H28/$H$24,\"\")","v":""},null,"Material cost for products produced or which have value added on the plant floor.  Includes casework, millwork, stairs, doors, panels and countertops.  Includes custom product which incorporate specialty materials, solid surfaces, acrylics, metals or other materials applied to the items that either completely or partially manufactured, assembled or finished on your plant floor.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,6,"Non-Plant Material",null,null,0,"",null,"Material cost for products not produced internally nor have any value added to by your company.  Examples may include casework, metal, door and trim packages manufactured by another company and delivered fully assembled to your company without needing any additional processing in your plant.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,7,"Total Direct Material",null,null,{"$f":"+SUM(H28:H29)","v":0},"",null,"Calculated.  Plant Material + Non-Plant Material.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Direct Labor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,8,"Direct Factory Staff",null,null,0,{"$f":"IFERROR(H32/$H$24,\"\")","v":""},null,"Direct labor on the factory floor (people who actually produce the product).  These do not include indirect factory staff (see line 17).  See the Position Chart at the bottom of the page to determine which roles are included here.  Compensation, payroll taxes and employee benefits for these roles employed directly by your company.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,9,"In-House Installation",null,null,0,"",null,"Compensation, payroll taxes and employee benefits for installers employed directly by your company.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,10,"Outsourced Installation",null,null,0,"",null,"Amount of invoices paid for external installation not employed directly by your company.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,11,"Total Direct Labor",null,null,{"$f":"+SUM(H32:H34)","v":0},"",null,"Calculated.  Direct Factory Staff + In-House Installation + Outsourced Installation.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,12,"Other Direct Cost",null,null,0,"",null,"Other costs directly related to manufacturing and installing products, including special bonding, insurance requirements, sales tax and project general condition costs (site lifts, site scaffolding, project licenses, fees, project travel, per diems, site housing, on-site storage, third party shipping and the like).  Do not include any indirect costs here (sales, admin, legal, etc.) or direct labor / material costs you entered above.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,13,"Total Variable Cost",null,null,{"$f":"+H30+H35+H36","v":0},"",null,"Calculated.  Direct Material + Direct Labor + Other Direct Cost.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,14,"Contribution Margin",null,null,{"$f":"+H24-H37","v":0},{"$f":"IFERROR(H39/$H$24,\"\")","v":""},null,"Calculated.  Total Revenue - Total Variable Cost.  Contribution margin is the amount of revenue that remains after variable costs related to production of a project / product are deducted.  Contribution Margin pays for a company's fixed costs and any remaining amount is operating profit.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Fixed Cost",null,null,null,null,null,"Fixed costs are 'regular' costs the business must pay and are not generally affected by how much the business produces.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,15,"Overhead",null,null,0,{"$f":"IFERROR(H42/$H$24,\"\")","v":""},null,"Total rent, leases, utiliities, property taxes, machines, technology / software, licensing, accounting fees and all other overhead (supplies, repairs, maintenance, vehicles, shipping, delivery and the like).  Do NOT include depreciation or amortization expense.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Fixed Labor",null,null,null,null,null,"Fixed labor costs include compensation, payroll taxes and employee benefits for staff which support the workers on the factory floor.  These include front office roles like estimating, sales and finance as well as indirect factory support role like project management, engineering and supervision.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,16,"Indirect Factory Staff",null,null,0,{"$f":"IFERROR(H44/$H$24,\"\")","v":""},null,"Indirect labor on the factory floor.  These are people who support the direct labor on the factory floor.  See the Position Chart at the bottom of the page to determine which roles are considered direct and indirect.  Compensation, payroll taxes and employee benefits for these roles employed directly by your company.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,17,"SG&A Staff",null,null,0,"",null,"Sales, General & Administrative staff.  These are people who support the general operations of the business and do not work on the factory floor.  See the Position Chart at the bottom of the page to determine which roles are considered SG&A.  Compensation, payroll taxes and employee benefits for these roles employed directly by your company.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,18,"Total Fixed Labor",null,null,{"$f":"+SUM(H44:H45)","v":0},"",null,"Calculated.  Indirect Factory Staff + SG&A Staff.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,19,"Total Fixed Cost",null,null,{"$f":"+H42+H46","v":0},"",null,"Calcuated.  Overhead + Fixed Labor.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,20,"Operating Income (EBITDA)",null,null,{"$f":"+H39-H47","v":0},{"$f":"IFERROR(H49/$H$24,\"\")","v":""},null,"Calculated.  Contribution Margin - Fixed Cost.  Operating Income shown here should match what is on your Income Statement.  This will ensure that all costs are accounted for.  This amount is considered 'EBITDA' and DOES NOT reflect accounting provisions for interest income(expense), federal/state income taxes, deferral or amoritization.",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Position Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," ",null,"Who goes in which labor cost bucket?",null,null,null,"Line Number:",null,null,null,8,null,null,9,null,null,16,null,null,17,null," "," "]
[null,null," ",null,null,null,null,"Labor Cost Type:",null,null,null,null,"Direct",null,null,"Direct",null,null,"Indirect",null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Factory",null,null,"Installation",null,null,"Factory",null,null,"SG&A",null," "]
[]
[null,null,null,null,null,1,"CEO / President",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null," "]
[null,null,null,null,null,2,"Estimator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null," "]
[null,null,null,null,null,3,"Sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null," "]
[null,null,null,null,null,4,"Finance / Accounting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null," "]
[null,null,null,null,null,5,"IT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,6,"HR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,7,"Legal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,8,"Administrative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[]
[null,null,null,null,null,9,"Plant Manager / Foreman",null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,10,"Engineer / Drafter",null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,11,"Project Manager",null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,12,"Material Purchasing",null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,13,"Product Quality",null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,14,"Safety / Security",null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,15,"Maintenance / Repair",null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,16,"Sanitation / Waste",null,null,null,null,null,null,null,null,null,null,null,"x"]
[]
[null,null,null,null,null,17,"Machine Operator",null,null,null,null,null,"x"]
[null,null,null,null,null,18,"Journeyman / Custom Assembler",null,null,null,null,null,"x"]
[null,null,null,null,null,19,"Casegood Assembler / Production Worker",null,null,null,null,null,"x"]
[null,null,null,null,null,20,"Material Handler",null,null,null,null,null,"x"]
[null,null,null,null,null,21,"Sander / Finish Preparation",null,null,null,null,null,"x"]
[null,null,null,null,null,22,"Finisher",null,null,null,null,null,"x"]
[null,null,null,null,null,23,"Shipping",null,null,null,null,null,"x"]
[null,null,null,null,null,24,"Truck Driver",null,null,null,null,null,"x"]
[]
[null,null,null,null,null,25,"Installer",null,null,null,null,null,null,null,null,"x"]
[]
[]
[]
[]
[]
[]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null," ",null,null,null,null,{"$f":"+Home!$H$33","v":"Have a question?  Please email IIBT@inverra.com with your detailed information and we will respond shortly"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Workforce","index":7,"n_rows":50,"n_cols":25,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,7,49,19],[38,10,38,22],[40,12,40,13],[33,10,33,11],[29,11,29,17],[31,13,31,22]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Input!$C$2","v":"Version 2025.1.2"}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,{"$f":"+Home!$N$4","v":"2025 INNERGY Industry Benchmarking Tool (IIBT)"},null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Please tell us about your workforce (6 questions)."]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,1,"How many employees do you have in these roles?  How much do you pay them, on average, per hour?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Definitions (Tip:  click the first word and press F2 button to see full text)",null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,"Estimator",null,null,null,null,0,null,0,null,"Responsible for selecting which jobs to bid, job costing, preparing take-offs and \npricing estimates, may be involved in sourcing / selling / closing some sales.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Engineer / Drafter",null,null,null,null,0,null,0,null,"Responsible for shop drawing submittals, bill of materials, material optimizations, production engineering. Works closely with estimators to determine customer requirements and supporting project managers with changes and add-ons.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Project Manager",null,null,null,null,0,null,0,null,"Responsible for coordinating all aspects of the job including scheduling, budget, production, and installation (if applicable) once the bid has been awarded.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Machine Operator",null,null,null,null,0,null,0,null,"Responsible for the operation of a specialized manufacturing machines (molder, PTP, CNC, beam saw, edgebander, etc) including complicated set-ups, computer programming, and material processing.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Journeyman/Custom Assembler",null,null,null,null,0,null,0,null,"Responsible for advanced/custom work in the production process.  Competent in uses of all machinery and tools.  Manages complete projects.  Supervises quality of production workers.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Casegood Assembler/Production Worker",null,null,null,null,0,null,0,null,"Responsible for general production work. Operates most basic machinery including performing own setups on basic machines and learning setups of more intricate machines. Working toward reading shop drawings, setting up complex machinery and building custom projects independently (i.e. Journeyman responsibilities).",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Material Handler",null,null,null,null,0,null,0,null,"Responsible for stocking, storage, selection, staging, and logistics of material movement to the plant floor.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Finisher",null,null,null,null,0,null,0,null,"Responsible for preparing work to enter the finishing area and / or sands between coats of finish. Applies uniform coats of stain and / or finish on work. Has responsibility for mixing colors in some companies.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Installer",null,null,null,null,0,null,0,null,"Responsible for installation of wood and wood products according to working drawings.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Plant Manager / Foreman",null,null,null,null,0,null,0,null,"Responsible for the day-to-day operation, scheduling and supervision of the production facility.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"* Enter as hourly rate (e.g. $20.50).  If salaried, divide annual salary by 2,080 hours to convert to an hourly rate.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,2,"What is the most difficult role for you to recruit and retain?",null,null,null,null,null,null,"Enter most difficult role to recruit and retain here"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,3,"Other than compensation and benefits, what do your employees want the most?",null,null,null,null,null,null,null,null,"Enter what your employees want the most (other than compensation and benefits) here",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,4,"Turnover.  What % of your employees left last year?",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,"Survey Conclusion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
[null,null," ",5,"What didn't we ask that we should consider next year?",null,null,null,null,null,"Enter what we should consider asking next year",null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
[null,null," ",6,"Approximately how long did it take to complete the survey (minutes)?",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Thank you for participating!  Please make sure all questions have been answered."]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,"Save your file locally and email it to IIBT@inverra.com.",null,null,null,null,null,null,null,null,null," "," "]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null," ",null,null,null,null,{"$f":"+Home!$H$33","v":"Have a question?  Please email IIBT@inverra.com with your detailed information and we will respond shortly"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]