{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Home","Report","SummaryHidden","CompanyAnalysis"],"not_rendered":{"charts":5,"images":48,"macros":1,"external_links":0,"defined_names":1,"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":"Home","index":0,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":false,"merged":[[5,4,5,14],[6,4,6,14],[8,0,8,20],[9,1,9,19],[14,1,14,9],[14,11,14,19],[48,0,48,20],[29,11,29,19],[15,1,15,9],[16,1,16,9],[17,1,17,9],[18,1,18,9],[19,1,19,9],[27,1,27,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Overview Of OUTGAM3E"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["**References**\nThe icon representing Note is titled ‘Post It: Flaticon.com’, designed by Pixel Perfect from Flaticon.\nThe icon representing Checklist is titled ‘Checklist: Flaticon.com’, designed by Freepik from Flaticon."]

{"sheet":"Report","index":1,"n_rows":767,"n_cols":13,"rows_kept":767,"cut":false,"hidden":true,"merged":[[562,0,564,12],[565,0,567,12],[734,0,737,12],[759,1,760,1],[759,2,760,11],[716,0,719,1],[716,2,719,8],[716,9,719,9],[716,10,719,10],[716,11,719,11],[716,12,719,12],[712,0,715,1],[712,2,715,8],[712,9,715,9],[712,10,715,10],[712,11,715,11],[712,12,715,12],[708,0,711,1],[708,2,711,8],[708,9,711,9],[708,10,711,10],[708,11,711,11],[708,12,711,12],[704,0,707,1],[704,2,707,8],[704,9,707,9],[704,10,707,10],[704,11,707,11],[704,12,707,12],[700,0,703,1],[700,2,703,8],[700,9,703,9],[700,10,703,10],[700,11,703,11],[700,12,703,12],[692,11,695,11],[692,12,695,12],[696,0,699,1],[696,2,699,8],[696,9,699,9],[696,10,699,10],[696,11,699,11],[696,12,699,12],[680,11,683,11],[680,12,683,12],[684,0,687,1],[684,2,687,8],[684,9,687,9],[684,10,687,10],[684,11,687,11],[684,12,687,12],[688,12,691,12],[688,0,691,1],[688,2,691,8],[688,9,691,9],[688,10,691,10],[688,11,691,11],[692,0,695,1],[692,2,695,8],[672,12,675,12],[676,0,679,1],[676,2,679,8],[676,9,679,9],[676,10,679,10],[676,11,679,11],[676,12,679,12],[680,0,683,1],[680,2,683,8],[680,9,683,9],[680,10,683,10],[672,0,675,1],[672,2,675,8],[672,9,675,9],[672,10,675,10],[660,12,663,12],[644,0,647,1],[644,2,647,8],[644,9,647,9],[644,10,647,10],[644,11,647,11],[644,12,647,12],[648,0,651,1],[648,2,651,8],[648,9,651,9],[648,10,651,10],[652,12,655,12],[656,12,659,12],[648,11,651,11],[648,12,651,12],[632,0,635,1],[632,2,635,8],[632,9,635,9],[636,0,639,1],[636,2,639,8],[636,9,639,9],[636,10,639,10],[616,0,619,1],[616,2,619,8],[335,0,340,12],[297,12,300,12],[636,12,639,12],[640,12,643,12],[636,11,639,11],[640,11,643,11],[616,9,619,9],[616,10,619,10],[421,12,424,12],[604,0,607,1],[604,2,607,8],[604,9,607,9],[509,12,512,12],[435,0,436,12],[507,0,508,12],[576,0,579,1],[576,2,579,8],[577,9,579,9],[577,10,579,10],[577,11,579,11],[604,10,607,10],[421,0,424,1],[421,2,424,8],[421,9,424,11],[389,12,392,12],[385,0,388,1],[385,2,388,8],[385,9,388,11],[385,12,388,12],[381,2,384,8],[381,9,384,11],[381,12,384,12],[413,12,416,12],[381,0,384,1],[389,9,392,11],[584,10,587,10],[584,11,587,11],[584,12,587,12],[509,9,512,11],[425,0,428,1],[425,2,428,8],[425,9,428,11],[425,12,428,12],[504,9,506,11],[504,12,506,12],[580,0,583,1],[576,9,576,12],[432,0,434,1],[432,2,434,8],[432,9,434,11],[432,12,434,12],[504,0,506,1],[504,2,506,8],[561,0,561,12],[580,9,583,9],[449,0,452,1],[449,2,452,8],[449,9,452,11],[449,12,452,12],[600,2,603,8],[173,12,176,12],[144,9,146,11],[149,0,152,1],[149,2,152,8],[149,9,152,11],[149,12,152,12],[165,0,168,1],[165,2,168,8],[417,12,420,12],[417,0,420,1],[417,2,420,8],[417,9,420,11],[377,2,380,8],[377,9,380,11],[377,12,380,12],[413,0,416,1],[413,2,416,8],[413,9,416,11],[291,0,292,12],[363,0,364,12],[399,0,400,12],[389,0,392,1],[389,2,392,8],[620,12,623,12],[255,0,256,12],[227,0,232,12],[193,9,196,11],[664,12,667,12],[265,2,268,8],[265,9,268,11],[265,12,268,12],[373,0,376,1],[515,0,516,12],[588,0,591,1],[588,2,591,8],[588,9,591,9],[517,2,520,8],[517,9,520,11],[517,12,520,12],[405,2,408,8],[405,9,408,11],[405,12,408,12],[405,0,408,1],[664,0,667,1],[664,2,667,8],[664,9,667,9],[600,0,603,1],[56,0,57,0],[185,0,188,1],[185,2,188,8],[596,12,599,12],[620,0,623,1],[620,2,623,8],[620,9,623,9],[620,10,623,10],[596,0,599,1],[596,2,599,8],[596,9,599,9],[596,10,599,10],[596,11,599,11],[600,9,603,9],[600,10,603,10],[600,11,603,11],[600,12,603,12],[616,11,619,11],[616,12,619,12],[612,0,615,1],[612,2,615,8],[612,9,615,9],[612,10,615,10],[620,11,623,11],[191,0,192,12],[269,2,272,8],[269,9,272,11],[269,12,272,12],[161,0,164,1],[161,2,164,8],[161,9,164,11],[161,12,164,12],[269,0,272,1],[165,9,168,11],[165,12,168,12],[13,4,14,8],[157,0,160,1],[157,2,160,8],[157,9,160,11],[157,12,160,12],[193,0,196,1],[193,2,196,8],[153,0,156,1],[153,2,156,8],[153,9,156,11],[153,12,156,12],[50,0,51,0],[50,1,51,12],[53,0,54,0],[53,1,54,12],[144,0,146,1],[144,2,146,8],[169,0,172,1],[169,2,172,8],[169,9,172,11],[169,12,172,12],[173,0,176,1],[173,2,176,8],[173,9,176,11],[692,9,695,9],[692,10,695,10],[656,0,659,1],[656,2,659,8],[656,9,659,9],[656,10,659,10],[628,11,631,11],[628,12,631,12],[632,11,635,11],[632,12,635,12],[672,11,675,11],[660,0,663,1],[660,2,663,8],[660,9,663,9],[660,10,663,10],[660,11,663,11],[652,0,655,1],[652,2,655,8],[652,9,655,9],[652,10,655,10],[664,10,667,10],[628,0,631,1],[628,2,631,8],[628,9,631,9],[588,10,591,10],[588,11,591,11],[588,12,591,12],[443,0,444,12],[479,0,484,12],[369,0,372,1],[369,2,372,8],[369,9,372,11],[369,12,372,12],[409,0,412,1],[409,2,412,8],[409,9,412,11],[554,0,557,12],[377,0,380,1],[409,12,412,12],[445,0,448,1],[445,2,448,8],[445,9,448,11],[445,12,448,12],[517,0,520,1],[373,2,376,8],[373,9,376,11],[373,12,376,12],[487,0,490,12],[668,12,671,12],[624,0,627,1],[624,2,627,8],[624,9,627,9],[624,10,627,10],[592,10,595,10],[592,11,595,11],[668,11,671,11],[664,11,667,11],[640,0,643,1],[640,2,643,8],[640,9,643,9],[640,10,643,10],[656,11,659,11],[652,11,655,11],[668,0,671,1],[668,2,671,8],[668,9,671,9],[668,10,671,10],[592,0,595,1],[592,2,595,8],[592,9,595,9],[632,10,635,10],[628,10,631,10],[608,11,611,11],[608,2,611,8],[608,9,611,9],[608,10,611,10],[7,0,10,12],[584,0,587,1],[584,2,587,8],[584,9,587,9],[261,12,264,12],[297,0,300,1],[297,2,300,8],[297,9,300,11],[437,0,440,1],[437,2,440,8],[437,9,440,11],[437,12,440,12],[509,0,512,1],[509,2,512,8],[365,9,368,11],[365,12,368,12],[401,0,404,1],[343,0,346,12],[273,12,276,12],[257,2,260,8],[612,11,615,11],[612,12,615,12],[608,12,611,12],[2,0,5,12],[38,0,41,12],[74,0,77,12],[147,0,148,12],[183,0,184,12],[360,9,362,11],[360,12,362,12],[396,0,398,1],[396,2,398,8],[396,9,398,11],[396,12,398,12],[401,2,404,8],[401,9,404,11],[401,12,404,12],[293,0,296,1],[293,2,296,8],[293,9,296,11],[580,10,583,10],[580,11,583,11],[580,12,583,12],[608,0,611,1],[592,12,595,12],[762,1,764,1],[762,2,764,11],[766,2,768,11],[766,1,768,1],[144,12,146,12],[180,0,182,1],[180,2,182,8],[288,0,290,1],[288,2,290,8],[288,9,290,11],[288,12,290,12],[360,0,362,1],[360,2,362,8],[180,9,182,11],[180,12,182,12],[252,0,254,1],[252,2,254,8],[252,9,254,11],[252,12,254,12],[624,11,627,11],[624,12,627,12],[604,11,607,11],[604,12,607,12],[273,0,276,1],[273,2,276,8],[273,9,276,11],[293,12,296,12],[47,0,48,0],[47,1,48,12],[580,2,583,8],[577,12,579,12],[257,9,260,11],[257,12,260,12],[193,12,196,12],[265,0,268,1],[261,0,264,1],[261,2,264,8],[261,9,264,11],[365,0,368,1],[365,2,368,8],[185,9,188,11],[185,12,188,12],[257,0,260,1],[56,1,57,12],[127,0,130,12],[235,0,238,12],[119,0,124,12]]}
[]
[]
["OUTGAM3E"]
[]
[]
[]
[]
["Outside the Gate Materials Management Model for ELectrical Contractors"]
[]
[]
[]
[]
[]
[null,null,null,null,"Self-Assessment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TABLE OF CONTENT"]
[]
[]
[]
[]
[]
[]
[]
[]
["Page 3","Summary of Self-Assessment"]
[]
[]
["Page 4","Self-Assessment Report"]
[]
[]
["Page 16","Your practices vs. organizations of different sizes"]
[]
[]
["Page 21","Next Steps"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SUMMARY\nSelf-Assessment Results"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Currently doing this, and it is important"]
[null,null,"Currently doing this, but it is not important"]
[null,null,"Not doing this, but it is important"]
[null,null,"Not doing this, and it is not important"]
[null,null,"Not Applicable"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STRATEGY"]
[]
[]
[]
[]
[]
[]
[]
["PLANNING, ORDERING, DELIVERYING \nKEY MATERIALS MANAGEMENT ACTIVITIES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Industry \nCriticality",null,"Key Materials Management Activity",null,null,null,null,null,null,"Self-Assessment",null,null,"Learn\nMore"]
[]
[]
["Planning Key Materials Management Activities"]
[]
[null,null,"Centralize who can issue/submit/approve POs to reduce variation and improve consistency/safety."]
[]
[]
[]
[null,null,"Bulk buy on large items. Combine POs for multiple projects."]
[]
[]
[]
[null,null,"Adopt a kitting approach and work with your vendor(s) to preapre a detailed plan for organizing, packing, and delivering packages to reduce waste on the jobsite."]
[]
[]
[]
[null,null,"Develop and implement a risk mitigation plan for materials at-risk identified by any party."]
[]
[]
[]
[null,null,"Collaborate with a single vendor to build rapport between the PM/Foreman and the vendor for daily materials."]
[]
[]
[]
[null,null,"Increase prefabrication (in-house/outsourced)."]
[]
[]
[]
[null,null,"Negotiate with Owner and GC to pay for storing materials (major packages and commodities purchased in bulk from vendors) to offset the challenges with material shortages and unavailability."]
[]
[]
[]
[]
[]
[]
["Industry \nCriticality",null,"Key Materials Management Activity",null,null,null,null,null,null,"Self-Assessment",null,null,"Learn\nMore"]
[]
[]
["Ordering Key Materials Management Activities"]
[]
[null,null,"Stock using a VMI model - Stock the bulk of the materials at vendor's location and keep a predetermined inventory to supply your downstream processes (pre-fab or field). Once you have pulled enough materials off the shelf, vendor needs to restock."]
[]
[]
[]
[]
[]
["Logistics Key Materials Management Activities"]
[]
[null,null,"Use shark cages. Work with vendors to have the shark cages regularly filled/replenished with items the installation crew will need.  Keep materials on wheels."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PEOPLE"]
[]
[]
[]
[]
[]
[]
[]
["PLANNING, ORDERING, DELIVERYING \nKEY MATERIALS MANAGEMENT ACTIVITIES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Industry \nCriticality",null,"Key Materials Management Activity",null,null,null,null,null,null,"Self-Assessment",null,null,"Learn\nMore"]
[]
[]
["Planning Key Materials Management Activities"]
[]
[null,null,"Work with vendor partners early on (during project pursuit) and communicate your plan to them at bid time. Incorporate your procurement plan/strategy before getting the project, not after you get the contract, and utilize it to ensure that you get the contract."]
[]
[]
[]
[null,null,"Engage suppliers in initial estimate of key projects and precon meetings that you see as critical to win."]
[]
[]
[]
[null,null,"Engage PM/Foreman/Field Leader in estimating when estimators do not come from the field."]
[]
[]
[]
[null,null,"Engage early in the project during Schematic Design (SD) /Design Development (DD)."]
[]
[]
[]
[null,null,"Hire/Have a company-wide purchasing agent who comes from a manufacturing background."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Industry \nCriticality",null,"Key Materials Management Activity",null,null,null,null,null,null,"Self-Assessment",null,null,"Learn\nMore"]
[]
[]
["Logistics Key Materials Management Activities"]
[]
[null,null,"Coordinate between PM/Foreman and pre-fab coordinator to ensure that what is needed for next week is being built this week."]
[]
[]
[]
[null,null,"Provide field leaders visibility into materials status through distributor or other software."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROCESS"]
[]
[]
[]
[]
[]
[]
[]
["PLANNING, ORDERING, DELIVERYING \nKEY MATERIALS MANAGEMENT ACTIVITIES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Industry \nCriticality",null,"Key Materials Management Activity",null,null,null,null,null,null,"Self-Assessment",null,null,"Learn\nMore"]
[]
[]
["Planning Key Materials Management Activities"]
[]
[null,null,"Clearly define expectations from all individuals (procurement, vendors, director of purchasing, fabrication manager, PM, etc.) during kickoff meeting. Communicate the big picture and follow back up throughout the project."]
[]
[]
[]
[null,null,"Have a formal materials process (material submittal record): for every project (besides service jobs), list every piece of equipment that needs to be onsite. The field ties a schedule of need and drop-dead dates to that. This helps PMs manage delivery esp. on large projects."]
[]
[]
[]
[null,null,"Hold a kickoff meeting that includes internal and external stakeholders for materials management."]
[]
[]
[]
[null,null,"Standardize a list of commodity items and selected vendors."]
[]
[]
[]
[null,null,"Plan to get more predictable. Must think of \"Tools, Materials, Information, Flow\" at the task level."]
[]
[]
[]
[null,null,"Develop a formal process for materials planning."]
[]
[]
[]
[null,null,"Evaluate submittals as \"Comply\", \"Deviate\", and \"Exclude\"."]
[]
[]
[]
[]
[]
[]
["Industry \nCriticality",null,"Key Materials Management Activity",null,null,null,null,null,null,"Self-Assessment",null,null,"Learn\nMore"]
[]
[]
["Planning Key Materials Management Activities"]
[]
[null,null,"Standardize the use of Cost Codes."]
[]
[]
[]
[null,null,"Have a formal prefabrication process."]
[]
[]
[]
[null,null,"Establish design and pre-fab principles. Train all to use them. Include procurement, build, and install procedures. Deviations must require approvals."]
[]
[]
[]
[null,null,"Form an early pre-construction services team that consists of: 1) a foreman quality person, 2) an administrative person, and 3) a draftsman to help establish the project for the PM."]
[]
[]
[]
[null,null,"Develop a catalog for your fab shop."]
[]
[]
[]
[null,null,"Develop a standardized, living playbook for assembled items: exact prices, exact timeline of what it takes to assemble them, timeline of what it takes to install in the field. Integrate this information into estimating software."]
[]
[]
[]
[null,null,"Establish a communication plan/model such as the V-Model – a process tool that outlines the what, who, and when."]
[]
[]
[]
[]
[]
[]
["Industry \nCriticality",null,"Key Materials Management Activity",null,null,null,null,null,null,"Self-Assessment",null,null,"Learn\nMore"]
[]
[]
["Ordering Key Materials Management Activities"]
[]
[null,null,"Standardize field request (electronically)."]
[]
[]
[]
[]
[]
["Logistics Key Materials Management Activities"]
[]
[null,null,"Track POs and attach the schedule to the materials."]
[]
[]
[]
[null,null,"Need to properly manage quantities purchased in bulk and constantly update them as the job updates. Meet with the vendor partner on a regular basis to review what has changed and what you need to add."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TECHNOLOGY"]
[]
[]
[]
[]
[]
[]
[]
["PLANNING, ORDERING, DELIVERYING \nKEY MATERIALS MANAGEMENT ACTIVITIES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Industry \nCriticality",null,"Key Materials Management Activity",null,null,null,null,null,null,"Self-Assessment",null,null,"Learn\nMore"]
[]
[]
["Planning Key Materials Management Activities"]
[]
[null,null,"Use Materials Management Software Tools (for example PowerPurchase™, Kojo, Distributor app, StructShare, Remarcable, etc.)."]
[]
[]
[]
[]
[]
["Ordering Key Materials Management Activities"]
[]
[null,null,"Use BIM model to release materials for Pre-fab and Work Packages."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Analysis of Your Practices vs. Company Size"]
[]
[]
[]
[]
[]
["Notes:"]
["* Scores for your company size are bolded."]
["* Activities with high priority have a red \"!\" to indicate that while this activity is perceived as important by your peers, your organization is not implementing it. "]
[]
[]
["* Activities already implemented have a green \"ü\" to indicated that your organization practices align with your peers who perceive this particular activity as critical for the success of the project"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Your Self-Assessment",null,"Key Materials Management Activities",null,null,null,null,null,null,"Criticality Score (emploees)"]
[null,null,null,null,null,null,null,null,null,"1 - 50","51 - 100","101 - 500","> 500"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["What's Next?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Ask different individuals within your organization to take OUTGAM3E."]
[]
[]
[null,2,"Use the \"Company Analysis\" feature in OUTGAM3E to combine all reports and generate a 360 degree view of your company"]
[]
[]
[]
[null,3,"Focus your organization's effort to address the high priority materials management key activities and investigate the activities that are curretnly implemented and how well they are implemented. "]

{"sheet":"SummaryHidden","index":2,"n_rows":36,"n_cols":35,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,null,"STRATEGY","Count","Percentage",null,null,null,null,null,null,null,"BP","Best Practice","1 – 50 employees N/A Count","1 – 50 employees not N/A Count","1 – 50 employees Average score","51 – 100 employees  N/A Count","52 – 100 employees  not N/A Count","53 – 100 employees  Average Score","101– 500 employees N/A Count","101– 500 employees not N/A Count","101– 500 employees Average Score","More than 500 employees N/A Count","More than 500 employees not N/A Count","More than 500 employees Average Score",null,null,null,null,null,"J150",{"$f":"AF1","v":"J150"},null,150]
["Currently doing this, and it is important",null,"Currently doing this, and it is important",{"$f":"COUNTIF(Report!$J$150:$L$177,SummaryHidden!C2)+COUNTIF(Report!$J$186,SummaryHidden!C2)+COUNTIF(Report!$J$194,SummaryHidden!C2)","v":0},{"$f":"D2/$D$7","v":0},null,null,null,null,null,null,null,"BP1","Centralize who can issue/submit/approve POs to reduce variation and improve consistency/safety.",4,30,3,null,24,3.08,1,44,3.39,2,27,3.37,null,null,null,null,null,"J154",{"$f":"\",\"&AF2","v":",J154"},null,154]
["Currently doing this, but it is not important",null,"Currently doing this, but it is not important",{"$f":"COUNTIF(Report!$J$150:$L$177,SummaryHidden!C3)+COUNTIF(Report!$J$186,SummaryHidden!C3)+COUNTIF(Report!$J$194,SummaryHidden!C3)","v":0},{"$f":"D3/$D$7","v":0},null,null,null,null,null,null,null,"BP2","Bulk buy on large items. Combine POs for multiple projects.",7,27,3.04,2,22,3.23,5,40,3.1,2,27,3.19,null,null,null,null,null,"J158",{"$f":"\",\"&AF3","v":",J158"},null,158]
["Not doing this, but it is important",null,"Not doing this, but it is important",{"$f":"COUNTIF(Report!$J$150:$L$177,SummaryHidden!C4)+COUNTIF(Report!$J$186,SummaryHidden!C4)+COUNTIF(Report!$J$194,SummaryHidden!C4)","v":0},0,null,null,null,null,null,null,null,"BP3","Negotiate with Owner and GC to pay for storing materials (major packages and commodities purchased in bulk from vendors) to offset the challenges with material shortages and unavailability.",4,30,2.8,4,22,2.64,5,40,3.1,3,26,2.96,null,null,null,null,null,"J162",",J162",null,162]
["Not doing this, and it is not important",null,"Not doing this, and it is not important",{"$f":"COUNTIF(Report!$J$150:$L$177,SummaryHidden!C5)+COUNTIF(Report!$J$186,SummaryHidden!C5)+COUNTIF(Report!$J$194,SummaryHidden!C5)","v":0},0,null,null,null,null,null,null,null,"BP4","Collaborate with a single vendor to build rapport between the PM/Foreman and the vendor for daily materials.",6,28,3.18,5,23,2.83,2,43,3.12,4,25,2.84,null,null,null,null,null,"J166",",J166",null,166]
["Not Applicable",null,"Not Applicable",{"$f":"COUNTIF(Report!$J$150:$L$177,SummaryHidden!C6)+COUNTIF(Report!$J$186,SummaryHidden!C6)+COUNTIF(Report!$J$194,SummaryHidden!C6)","v":0},0,null,null,null,null,null,null,null,"BP5","Adopt a kitting approach and work with your vendor(s) to preapre a detailed plan for organizing, packing, and delivering packages to reduce waste on the jobsite.",6,28,2.75,6,23,3.13,2,43,3.09,1,28,3.25,null,null,null,null,null,"J170",",J170",null,170]
[null,null,"Total",9,null,null,null,null,null,null,null,null,"BP6","Develop and implement a risk mitigation plan for materials at-risk identified by any party.",6,28,2.64,8,22,3.27,3,42,3,1,28,3.32,null,null,null,null,null,"J174",",J174",null,174]
[null,null,null,null,null,null,null,null,null,null,null,null,"BP7","Increase prefabrication (in-house/outsourced).",5,29,2.48,11,21,3.1,4,41,3.34,1,28,2.96,null,null,null,null,null,"J186",",J186",null,186]
[null,null,"People",null,null,null,null,null,null,null,null,null,"BP8","Stock using a VMI model - Stock the bulk of the materials at vendor's location and keep a predetermined inventory to supply your downstream processes (pre-fab or field). Once you have pulled enough materials off the shelf, vendor needs to restock.",8,26,2.54,12,23,2.65,5,40,3.15,5,24,2.79,null,null,null,null,null,"J194",",J194",null,194]
[null,null,"Currently doing this, and it is important",{"$f":"COUNTIF(Report!$J$258:$L$277,SummaryHidden!C10)+COUNTIF(Report!$J$294:$L$301,SummaryHidden!C10)","v":0},{"$f":"D10/$D$15","v":0},null,null,null,null,null,null,null,"BP9","Use shark cages. Work with vendors to have the shark cages regularly filled/replenished with items the installation crew will need.  Keep materials on wheels.",10,24,2.17,15,21,2.4300000000000002,8,37,2.78,4,25,2.68,null,null,null,null,null,"J258",",J258",null,258]
[null,null,"Currently doing this, but it is not important",{"$f":"COUNTIF(Report!$J$258:$L$277,SummaryHidden!C11)+COUNTIF(Report!$J$294:$L$301,SummaryHidden!C11)","v":0},{"$f":"D11/$D$15","v":0},null,null,null,null,null,null,null,"BP10","Hire/Have a company-wide purchasing agent who comes from a manufacturing background.",12,22,2,18,21,2.14,5,40,2.6,7,22,1.91,null,null,null,null,null,"J262",",J262",null,262]
[null,null,"Not doing this, but it is important",{"$f":"COUNTIF(Report!$J$258:$L$277,SummaryHidden!C12)+COUNTIF(Report!$J$294:$L$301,SummaryHidden!C12)","v":0},0,null,null,null,null,null,null,null,"BP11","Engage early in the project during Schematic Design (SD) /Design Development (DD).",9,25,2.52,21,21,2.62,6,39,2.38,6,23,2.48,null,null,null,null,null,"J266",",J266",null,266]
[null,null,"Not doing this, and it is not important",{"$f":"COUNTIF(Report!$J$258:$L$277,SummaryHidden!C13)+COUNTIF(Report!$J$294:$L$301,SummaryHidden!C13)","v":0},0,null,null,null,null,null,null,null,"BP12","Engage PM/Foreman/Field Leader in estimating when estimators do not come from the field.",5,29,2.5499999999999998,22,23,2.65,5,40,3,3,26,2.85,null,null,null,null,null,"J270",",J270",null,270]
[null,null,"Not Applicable",{"$f":"COUNTIF(Report!$J$258:$L$277,SummaryHidden!C14)+COUNTIF(Report!$J$294:$L$301,SummaryHidden!C14)","v":0},0,null,null,null,null,null,null,null,"BP13","Work with vendor partners early on (during project pursuit) and communicate your plan to them at bid time. Incorporate your procurement plan/strategy before getting the project, not after you get the contract, and utilize it to ensure that you get the contract.",4,30,2.9,23,23,2.78,2,43,2.84,1,28,3.14,null,null,null,null,null,"J274",",J274",null,274]
[null,null,"Total",7,null,null,null,null,null,null,null,null,"BP14","Engage suppliers in initial estimate of key projects and precon meetings that you see as critical to win.",4,30,3,24,23,2.65,4,41,2.98,2,27,2.81,null,null,null,null,null,"J294",",J294",null,294]
[null,null,null,null,null,null,null,null,null,null,null,null,"BP15","Provide field leaders visibility into materials status through distributor or other software.",6,28,3.14,25,23,3.39,3,42,3.26,1,28,3.32,null,null,null,null,null,"J298",",J298",null,298]
[null,null,"Process",null,null,null,null,null,null,null,null,null,"BP16","Coordinate between PM/Foreman and pre-fab coordinator to ensure that what is needed for next week is being built this week.",5,29,3.14,27,22,3.77,4,41,4.12,2,27,3.74,null,null,null,null,null,"J366",",J366",null,366]
[null,null,"Currently doing this, and it is important",{"$f":"COUNTIF(Report!$J$366:$L$393,SummaryHidden!C18)+COUNTIF(Report!$J$402:$L$429,SummaryHidden!C18)+COUNTIF(Report!$J$438,SummaryHidden!C18)+COUNTIF(Report!$J$446:$L$453,SummaryHidden!C18)","v":0},{"$f":"D18/$D$23","v":0},null,null,null,null,null,null,null,"BP17","Form an early pre-construction services team that consists of: 1) a foreman quality person, 2) an administrative person, and 3) a draftsman to help establish the project for the PM.",8,26,2.58,28,23,2.87,6,39,3.15,3,26,2.88,null,null,null,null,null,"J370",",J370",null,370]
[null,null,"Currently doing this, but it is not important",{"$f":"COUNTIF(Report!$J$366:$L$393,SummaryHidden!C19)+COUNTIF(Report!$J$402:$L$429,SummaryHidden!C19)+COUNTIF(Report!$J$438,SummaryHidden!C19)+COUNTIF(Report!$J$446:$L$453,SummaryHidden!C19)","v":0},{"$f":"D19/$D$23","v":0},null,null,null,null,null,null,null,"BP18","Plan to get more predictable. Must think of \"Tools, Materials, Information, Flow\" at the task level.",5,29,3.03,28,24,3.17,4,41,3.51,3,26,3.27,null,null,null,null,null,"J374",",J374",null,374]
[null,null,"Not doing this, but it is important",{"$f":"COUNTIF(Report!$J$366:$L$393,SummaryHidden!C20)+COUNTIF(Report!$J$402:$L$429,SummaryHidden!C20)+COUNTIF(Report!$J$438,SummaryHidden!C20)+COUNTIF(Report!$J$446:$L$453,SummaryHidden!C20)","v":0},0,null,null,null,null,null,null,null,"BP19","Establish a communication plan/model such as the V-Model – a process tool that outlines the what, who, and when.",6,28,2.64,29,23,2.57,8,37,2.92,1,28,2.89,null,null,null,null,null,"J378",",J378",null,378]
[null,null,"Not doing this, and it is not important",{"$f":"COUNTIF(Report!$J$366:$L$393,SummaryHidden!C21)+COUNTIF(Report!$J$402:$L$429,SummaryHidden!C21)+COUNTIF(Report!$J$438,SummaryHidden!C21)+COUNTIF(Report!$J$446:$L$453,SummaryHidden!C21)","v":0},0,null,null,null,null,null,null,null,"BP20","Hold a kickoff meeting that includes internal and external stakeholders for materials management.",6,28,2.64,31,22,3.18,3,42,3.67,2,27,3.48,null,null,null,null,null,"J382",",J382",null,382]
[null,null,"Not Applicable",{"$f":"COUNTIF(Report!$J$366:$L$393,SummaryHidden!C22)+COUNTIF(Report!$J$402:$L$429,SummaryHidden!C22)+COUNTIF(Report!$J$438,SummaryHidden!C22)+COUNTIF(Report!$J$446:$L$453,SummaryHidden!C22)","v":0},0,null,null,null,null,null,null,null,"BP21","Clearly define expectations from all individuals (procurement, vendors, director of purchasing, fabrication manager, PM, etc.) during kickoff meeting. Communicate the big picture and follow back up throughout the project.",5,29,3.38,32,23,3.52,4,41,4.0999999999999996,1,28,3.64,null,null,null,null,null,"J386",",J386",null,386]
[null,null,"Total",17,null,null,null,null,null,null,null,null,"BP22","Standardize a list of commodity items and selected vendors.",4,30,3.43,32,24,3.13,1,44,3.2,3,26,3.38,null,null,null,null,null,"J390",",J390",null,390]
[null,null,null,null,null,null,null,null,null,null,null,null,"BP23","Establish design and pre-fab principles. Train all to use them. Include procurement, build, and install procedures. Deviations must require approvals.",10,24,2.92,35,21,2.86,4,41,3.2,3,26,3.08,null,null,null,null,null,"J402",",J402",null,402]
[null,null,"Technology",null,null,null,null,null,null,null,null,null,"BP24","Develop a standardized, living playbook for assembled items: exact prices, exact timeline of what it takes to assemble them, timeline of what it takes to install in the field. Integrate this information into estimating software.",10,24,3.08,37,22,2.64,5,40,2.85,3,26,2.81,null,null,null,null,null,"J406",",J406",null,406]
[null,null,"Currently doing this, and it is important",{"$f":"COUNTIF(Report!$J$510,SummaryHidden!C26)+COUNTIF(Report!$J$518,SummaryHidden!C26)","v":0},{"$f":"D26/$D$31","v":0},null,null,null,null,null,null,null,"BP25","Evaluate submittals as \"Comply\", \"Deviate\", and \"Exclude\".",6,28,3.5,39,22,2.68,9,36,2.94,2,27,3.33,null,null,null,null,null,"J410",",J410",null,410]
[null,null,"Currently doing this, but it is not important",{"$f":"COUNTIF(Report!$J$510,SummaryHidden!C27)+COUNTIF(Report!$J$518,SummaryHidden!C27)","v":0},{"$f":"D27/$D$31","v":0},null,null,null,null,null,null,null,"BP26","Develop a catalog for your fab shop.",16,18,2.78,45,18,2.44,9,36,2.97,5,24,3.13,null,null,null,null,null,"J414",",J414",null,414]
[null,null,"Not doing this, but it is important",{"$f":"COUNTIF(Report!$J$510,SummaryHidden!C28)+COUNTIF(Report!$J$518,SummaryHidden!C28)","v":0},0,null,null,null,null,null,null,null,"BP27","Have a formal prefabrication process.",16,18,2.67,50,19,2.58,8,37,3.32,4,25,3.44,null,null,null,null,null,"J418",",J418",null,418]
[null,null,"Not doing this, and it is not important",{"$f":"COUNTIF(Report!$J$510,SummaryHidden!C29)+COUNTIF(Report!$J$518,SummaryHidden!C29)","v":0},0,null,null,null,null,null,null,null,"BP28","Have a formal materials process (material submittal record): for every project (besides service jobs), list every piece of equipment that needs to be onsite. The field ties a schedule of need and drop-dead dates to that. This helps PMs manage delivery esp. on large projects.",11,23,3.39,53,21,2.95,4,41,3.46,2,27,3.48,null,null,null,null,null,"J422",",J422",null,422]
[null,null,"Not Applicable",{"$f":"COUNTIF(Report!$J$510,SummaryHidden!C30)+COUNTIF(Report!$J$518,SummaryHidden!C30)","v":0},0,null,null,null,null,null,null,null,"BP29","Standardize the use of Cost Codes.",8,26,3.12,55,22,3,2,43,3.16,1,28,3.07,null,null,null,null,null,"J426",",J426",null,426]
[null,null,"Total",2,null,null,null,null,null,null,null,null,"BP30","Develop a formal process for materials planning.",7,27,3.41,55,24,2.88,2,43,3.33,1,28,3.21,null,null,null,null,null,"J438",",J438",null,438]
[null,null,null,null,null,null,null,null,null,null,null,null,"BP31","Standardize field request (electronically).",6,28,3.36,55,24,2.96,2,43,3.53,2,27,3.37,null,null,null,null,null,"J446",",J446",null,446]
[null,null,null,null,null,null,null,null,null,null,null,null,"BP32","Track POs and attach the schedule to the materials.",4,30,3.6,55,24,3.5,1,44,3.7,1,28,3.54,null,null,null,null,null,"J450",",J450",null,450]
[null,null,null,null,null,null,null,null,null,null,null,null,"BP33","Need to properly manage quantities purchased in bulk and constantly update them as the job updates. Meet with the vendor partner on a regular basis to review what has changed and what you need to add.",6,28,3.04,55,24,2.63,2,43,3.26,2,27,3.41,null,null,null,null,null,"J510",",J510",null,510]
[null,null,"1 – 50",null,null,null,null,null,null,null,null,null,"BP34","Use BIM model to release materials for Pre-fab and Work Packages.",15,19,2.95,57,22,2,7,38,2.37,3,26,3,null,null,null,null,null,"J518",",J518",null,518]
[null,null,null,null,null,null,null,null,null,null,null,null,"BP35","Use Materials Management Software Tools (for example PowerPurchase™, Kojo, Distributor app, StructShare, Remarcable, etc.).",15,19,3,60,21,2.1,8,37,2.27,7,22,2.59]

{"sheet":"CompanyAnalysis","index":3,"n_rows":138,"n_cols":3,"rows_kept":138,"cut":false,"hidden":true,"merged":[[137,2,140,8],[113,2,116,8],[117,2,120,8],[121,2,124,8],[125,2,128,8],[129,2,132,8],[133,2,136,8],[89,2,92,8],[93,2,96,8],[97,2,100,8],[101,2,104,8],[105,2,108,8],[109,2,112,8],[37,2,40,8],[1,2,4,8],[5,2,8,8],[9,2,12,8],[13,2,16,8],[17,2,20,8],[21,2,24,8],[81,2,84,8],[85,2,88,8],[61,2,64,8],[25,2,28,8],[41,2,44,8],[45,2,48,8],[49,2,52,8],[53,2,56,8],[57,2,60,8],[65,2,68,8],[69,2,72,8],[73,2,76,8],[77,2,80,8],[137,9,140,11],[101,9,104,11],[105,9,108,11],[109,9,112,11],[113,9,116,11],[117,9,120,11],[81,9,84,11],[85,9,88,11],[89,9,92,11],[93,9,96,11],[97,9,100,11],[45,9,48,11],[49,9,52,11],[53,9,56,11],[57,9,60,11],[21,9,24,11],[25,9,28,11],[29,9,32,11],[33,9,36,11],[37,9,40,11],[0,48,0,50],[0,51,0,53],[0,54,0,56],[1,0,36,0],[1,1,28,1],[0,33,0,35],[0,36,0,38],[0,39,0,41],[0,42,0,44],[0,45,0,47],[0,18,0,20],[0,21,0,23],[0,24,0,26],[0,27,0,29],[0,30,0,32],[0,2,0,8],[29,2,32,8],[33,2,36,8],[0,9,0,11],[0,12,0,14],[0,15,0,17],[1,9,4,11],[5,9,8,11],[9,9,12,11],[13,9,16,11],[17,9,20,11],[37,0,64,0],[65,0,132,0],[133,0,140,0],[29,1,32,1],[33,1,36,1],[37,1,56,1],[57,1,64,1],[65,1,120,1],[121,1,124,1],[125,1,132,1],[133,1,136,1],[137,1,140,1],[121,9,124,11],[125,9,128,11],[129,9,132,11],[133,9,136,11],[61,9,64,11],[65,9,68,11],[69,9,72,11],[73,9,76,11],[77,9,80,11],[41,9,44,11],[1,12,4,14],[5,12,8,14],[9,12,12,14],[13,12,16,14],[17,12,20,14],[21,12,24,14],[25,12,28,14],[29,12,32,14],[33,12,36,14],[37,12,40,14],[41,12,44,14],[45,12,48,14],[49,12,52,14],[53,12,56,14],[57,12,60,14],[61,12,64,14],[65,12,68,14],[69,12,72,14],[109,12,112,14],[113,12,116,14],[117,12,120,14],[121,12,124,14],[125,12,128,14],[129,12,132,14],[133,12,136,14],[137,12,140,14],[73,12,76,14],[77,12,80,14],[81,12,84,14],[85,12,88,14],[89,12,92,14],[93,12,96,14],[97,12,100,14],[101,12,104,14],[105,12,108,14]]}
["Phase","Category","Key Materials Management Activities"]
["Strategy","Planning","Centralize who can issue/submit/approve POs to reduce variation and improve consistency/safety."]
[]
[]
[]
[null,null,"Bulk buy on large items. Combine POs for multiple projects."]
[]
[]
[]
[null,null,"Collaborate with a single vendor to build rapport between the PM/Foreman and the vendor for daily materials."]
[]
[]
[]
[null,null,"Develop and implement a risk mitigation plan for materials at-risk identified by any party."]
[]
[]
[]
[null,null,"Adopt a kitting approach and work with your vendor(s) to preapre a detailed plan for organizing, packing, and delivering packages to reduce waste on the jobsite."]
[]
[]
[]
[null,null,"Negotiate with Owner and GC to pay for storing materials (major packages and commodities purchased in bulk from vendors) to offset the challenges with material shortages and unavailability."]
[]
[]
[]
[null,null,"Increase prefabrication (in-house/outsourced)."]
[]
[]
[]
[null,"Ordering","Stock using a VMI model - Stock the bulk of the materials at vendor's location and keep a predetermined inventory to supply your downstream processes (pre-fab or field). Once you have pulled enough materials off the shelf, vendor needs to restock."]
[]
[]
[]
[null,"Logsitics","Use shark cages. Work with vendors to have the shark cages regularly filled/replenished with items the installation crew will need.  Keep materials on wheels."]
[]
[]
[]
["People","Planning","Work with vendor partners early on (during project pursuit) and communicate your plan to them at bid time. Incorporate your procurement plan/strategy before getting the project, not after you get the contract, and utilize it to ensure that you get the contract."]
[]
[]
[]
[null,null,"Engage suppliers in initial estimate of key projects and precon meetings that you see as critical to win."]
[]
[]
[]
[null,null,"Engage PM/Foreman/Field Leader in estimating when estimators do not come from the field."]
[]
[]
[]
[null,null,"Engage early in the project during Schematic Design (SD) /Design Development (DD)."]
[]
[]
[]
[null,null,"Hire/Have a company-wide purchasing agent who comes from a manufacturing background."]
[]
[]
[]
[null,"Logistics","Coordinate between PM/Foreman and pre-fab coordinator to ensure that what is needed for next week is being built this week."]
[]
[]
[]
[null,null,"Provide field leaders visibility into materials status through distributor or other software."]
[]
[]
[]
["Process","Planning","Clearly define expectations from all individuals (procurement, vendors, director of purchasing, fabrication manager, PM, etc.) during kickoff meeting. Communicate the big picture and follow back up throughout the project."]
[]
[]
[]
[null,null,"Develop a formal process for materials planning."]
[]
[]
[]
[null,null,"Have a formal materials process (material submittal record): for every project (besides service jobs), list every piece of equipment that needs to be onsite. The field ties a schedule of need and drop-dead dates to that. This helps PMs manage delivery esp. on large projects."]
[]
[]
[]
[null,null,"Standardize a list of commodity items and selected vendors."]
[]
[]
[]
[null,null,"Standardize the use of Cost Codes."]
[]
[]
[]
[null,null,"Plan to get more predictable. Must think of \"Tools, Materials, Information, Flow\" at the task level."]
[]
[]
[]
[null,null,"Hold a kickoff meeting that includes internal and external stakeholders for materials management."]
[]
[]
[]
[null,null,"Evaluate submittals as \"Comply\", \"Deviate\", and \"Exclude\"."]
[]
[]
[]
[null,null,"Establish design and pre-fab principles. Train all to use them. Include procurement, build, and install procedures. Deviations must require approvals."]
[]
[]
[]
[null,null,"Have a formal prefabrication process."]
[]
[]
[]
[null,null,"Develop a standardized, living playbook for assembled items: exact prices, exact timeline of what it takes to assemble them, timeline of what it takes to install in the field. Integrate this information into estimating software."]
[]
[]
[]
[null,null,"Establish a communication plan/model such as the V-Model – a process tool that outlines the what, who, and when."]
[]
[]
[]
[null,null,"Form an early pre-construction services team that consists of: 1) a foreman quality person, 2) an administrative person, and 3) a draftsman to help establish the project for the PM."]
[]
[]
[]
[null,null,"Develop a catalog for your fab shop."]
[]
[]
[]
[null,"Ordering","Standardize field request (electronically)."]
[]
[]
[]
[null,"logistics","Track POs and attach the schedule to the materials."]
[]
[]
[]
[null,null,"Need to properly manage quantities purchased in bulk and constantly update them as the job updates. Meet with the vendor partner on a regular basis to review what has changed and what you need to add."]
[]
[]
[]
["Technology","planning","Use Materials Management Software Tools (for example PowerPurchase™, Kojo, Distributor app, StructShare, Remarcable, etc.)."]
[]
[]
[]
[null,"ordering","Use BIM model to release materials for Pre-fab and Work Packages."]