{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Capacity Review Template","Capacity Improvement Plan"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":3,"defined_names":12,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,0,5,10],[8,0,8,10]]}
[]
[]
[]
[]
[]
["Supplier Capacity Assessment Report (SCAR) "]
[]
[]
["Instructions"]

{"sheet":"Capacity Review Template","index":1,"n_rows":310,"n_cols":34,"rows_kept":310,"cut":false,"hidden":false,"merged":[[5,0,5,33],[1,8,1,14],[1,0,1,7],[1,15,1,20],[1,21,1,24],[1,25,1,27],[1,28,1,33]]}
[]
["Part list",null,null,null,null,null,null,null,"Monthly Demand",null,null,null,null,null,null,"Modine Plant Usage (Y/N)",null,null,null,null,null,"Supplier Facility Name & Location",null,null,null," Facility Operational Schedule (not part specific)",null,null,"Capacity Information *"]
["Part number","Part Description","Supplier ID#","Supplier Name","Modine Supply Chain Contact Name","Dual tier 1 part (Y/N)","If Yes, what is sub-contracted part number","Supplier has been Tier 1 to Modine before (Y/N)","2020-04-01","2020-05-02","2020-06-03","2020-06-04","2020-07-05","2020-08-06","MAX Monthly Volume","NA","Europe","Brazil","UK","India","China","Shipping Facility","City ","State","Country","Hours/shift","Shifts/day","days/week","Max Monthly Capacity ","First constraint if you were to increase capacity","Planned capacity improvement projects (Y/N)","If yes, expected monthly capacity gain","Max Monthly Forecast","Capacity greater than Forecast? (Y/N)"]
[12345678,"Tank",123456,"XYZ","Peter","No","N/A","Yes",500,600,2000,3000,4000,3000,{"$f":"MAX(I4:N4)*1.1","v":4400},"Yes","No","No","Yes","Yes","Yes","City Name","New York","New York","US",7.5,3,6,3500,"Facility Operation Time","No",0,{"$f":"O4","v":4400},{"$f":"IF(AC4<=0,\"Incomplete\",IF(AG4<=0,\"Incomplete\",IF(AC4+AF4>AG4,\"Yes\",\"No\")))","v":"No"}]
[23456789,"Connector",234567,"YZX","Hannes","Yes","XXXXXXX","Yes",200,50,250,150,300,150,{"$f":"MAX(I5:N5)*1.1","v":330},"Yes","Yes","Yes","Yes","Yes","Yes",{"$f":"V4","v":"City Name"},{"$f":"W4","v":"New York"},{"$f":"X4","v":"New York"},{"$f":"Y4","v":"US"},7.5,3,6,300,"Facility Operation Time","Yes",40,{"$f":"O5","v":330},"Yes"]
["See examples above, but provide your information below.  Hold your cursor over each title block to view a note on how to complete that column."]
["Part number","Part Description","Supplier ID#","Supplier Name","Modine Supply Chain Contact Name","Dual tier 1 part (Y/N)","If Yes, what is sub-contracted part number","Supplier has been Tier 1 to Modine before (Y/N)","mm/year","mm/year","mm/year","mm/year","mm/year","mm/year","MAX Monthly Volume","NA","Europe","Brazil","UK","India","China","Shipping Facility","City ","State","Country","Hours/shift","Shifts/day","days/week","Max Monthly Capacity ","First constraint if you were to increase capacity","Planned capacity improvement projects (Y/N)","If yes, expected monthly capacity gain","Max Monthly Forecast","Capacity greater than Forecast? (Y/N)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(I8:N8)*1.1","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"O8","v":0},{"$f":"IF(AC8<=0,\"Incomplete\",IF(AG8<=0,\"Incomplete\",IF(AC8+AF8>AG8,\"Yes\",\"No\")))","v":"Incomplete"}]
[null,null,null,null,null,null,null,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,{"$f":"O9","v":0},{"$f":"IF(AC9<=0,\"Incomplete\",IF(AG9<=0,\"Incomplete\",IF(AC9+AF9>AG9,\"Yes\",\"No\")))","v":"Incomplete"}]
[null,null,null,null,null,null,null,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,0,{"$f":"IF(AC10<=0,\"Incomplete\",IF(AG10<=0,\"Incomplete\",IF(AC10+AF10>AG10,\"Yes\",\"No\")))","v":"Incomplete"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Do Not Delete","Do Not Delete"]
["N/A"]
["Yes","Facility Operation Time"]
["No","Insufficient Personnel"]
[null,"Machine Capacity"]
[null,"Packaging"]
[null,"Raw Material"]
["Do Not Delete","Do Not Delete"]

{"sheet":"Capacity Improvement Plan","index":2,"n_rows":310,"n_cols":7,"rows_kept":310,"cut":false,"hidden":false,"merged":[]}
["Part number","Part Description","Additional Planned Capacity Improvement Project details","Incremental Weekly Capacity","Timeline","Responsibility","Remarks"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Do Not Delete","Do Not Delete"]
["N/A"]
["Yes","Facility Operation Time"]
["No","Insufficient Personnel"]
[null,"Machine Capacity"]
[null,"Packaging"]
[null,"Raw Material"]
["Do Not Delete","Do Not Delete"]