{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["C2 Instructions","C2 System Level Capacity","C2 Example","Instructions","Constraint Capacity","Run@Rate ATI Validation"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":6,"comments":3,"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":"C2 Instructions","index":0,"n_rows":57,"n_cols":1,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
["The purpose of this sheet is to analyze the operations and determine any Constraints within the System Level Analysis."]
[]
["A Constraint is defined as the operation with highest utilization in the Production Line.  "]
["A Concern Constraint is any operation where the utilization is over 85%"]
["A Problem Constraint is any operation where the utilization is over 90%. "]
[]
["This sheet is to be used to estimate the capacity at the system level.  "]
["It should be noted that this spreadsheet provides an initial estimate only as it ignores all interactions between component lines."]
["Please input data into NON-SHADED cells only.  The shaded cells are calculated automatically and are password protected."]
["Some column headings have comments associated with them in order to explain the headings better which show up as little red marks on the top right hand corner of the cell they are associated with.  "]
["To view the comment, point the mouse at the cell (or the red mark) and hover.  There is no need to click on the field to see the comment."]
["There are four sheets in this workbook."]
["C2 Instructions "]
["C2 System Level Capacity "]
["C2 Example - an example of what a completed System Level Capacity Estimate looks like."]
[]
[]
["Description of NON-Calculating Input Data fields in this capacity estimation tool:"]
["Supplier Name:  input the name & location of supplier production for this part."]
["Part(s) Name: input the part name based on the part contract.  When the sheet applies to multiple parts, specify name of all the parts."]
["Part(s) Number: input the Allison's part number (not the supplier's internal part number).  "]
["When the sheet applies to multiple (family) parts, specify number of all the parts, starting with the part with the highest production quantity and ending with the part with the lowest quantity."]
["Working Days per Year:  input the number of working days per year the supplier operates as agreed upon in the contract."]
["Contracted Capacity : input the CONTRACTED yearly and daily capacity.  "]
["CONTRACTED CAPACITY SHOULD BE YEARLY CAPACITY/WORKING DAYS PER YEAR"]
["Increased Contracted Capacity: input the increased CONTRACTED yearly and daily capacity.  "]
["INCREASED CONTRACTED CAPACITY SHOULD BE YEARLY CAPACITY/WORKING DAYS PER YEAR"]
[]
[]
["Production System: input each separate production/or operation line separately."]
[]
["System Availability - Where there is no value to enter in each field, enter a 0."]
["Shifts per Week: input the number of working shifts per week for this production line."]
["Shifts per Day: input the number of working shifts per day for this production line."]
["Minutes per shift: input the number of total minutes per shift for this production line."]
["Scheduled Breaks: input in minutes the time spent PER DAY for breaks, lunches, meetings, any other scheduled breaks on this production line if production stops during these events."]
["Changeovers/Tool change: input in minutes the time spent PER DAY for tool changes, setups on this production line, if production stops during tool changes & setups."]
["Planned Maintenance: input in minutes the time spent PER DAY for planned/scheduled maintenance on this production line."]
["Unscheduled Downtime: input an ESTIMATE in minutes the time spent PER DAY for all UNSCHEDULED downtime (breakdowns) in this production line."]
[]
["System Capacity - Where there is no value to enter in each field, enter a 0."]
["Time allocated for other customers: input the total time (in minutes) allocated for other customers on this production line."]
["The definition of \"other customers\" includes all production for other products designated for Allison, which are not reflected in this Capacity Estimate."]
["Line Cycle Time Per Part:  input the cycle time of the line in SECONDS PER PART.  "]
["NOTE - If the final operation of the line produces more than one part per cycle, the Line Cycle time should be calculated by dividing the observed cycle time by the number of parts produced per cycle."]
["Buffer Before/After Operation"]
["% Scrap:  input the scrap rate for this production line (enter as percentage, not fraction. Example: enter a 5% scrap rate as 5 not 0.05)."]
["CONTRACTED parts/day:  input NEWLY contracted parts PER DAY which includes service parts requirement."]
["RESULT - Where the Utilization is greater than 90%, a red X will appear in the Result Column.  This identifies the Problem Constraint Operations."]
["RESULT - Where the Utilization is greater than 85%, a yellow triangle ▲ will appear in the Result Column.  This identifies the Concern Constraint Operations."]
[]
[]
["Actual Run at Rate Study Results"]
["Run at Rate Actual OK parts produced: input the number of OK parts produced during the run at rate study."]
["Available Capacity > Contracted Capacity: If the available capacity of the system is greater than the contracted capacity, input \"YES\", otherwise input \"NO\"."]
["Run at Rate Actual Scrap: input the number of parts scrapped during the run at rate study."]
["Run at Rate Actual Downtime: input the downtime in minutes during the run at rate study."]

{"sheet":"C2 System Level Capacity","index":1,"n_rows":37,"n_cols":33,"rows_kept":37,"cut":false,"hidden":true,"merged":[[31,0,31,27],[32,0,32,27],[33,0,33,27],[7,0,7,1],[7,2,7,10],[7,11,7,19],[7,23,7,27],[8,0,8,1],[30,2,30,27],[4,3,4,4],[4,17,4,19],[4,22,4,27],[5,3,5,4],[5,17,5,19],[5,22,5,27],[3,2,3,6],[3,17,3,19],[3,22,3,27],[0,2,0,6],[1,2,1,6],[2,2,2,6],[2,17,2,19],[2,22,2,27]]}
["Supplier Name"]
["Part(s) Name"]
["Part(s) Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete Date"]
["Working Days per Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed by"]
["Contracted Capacity ",null,"Annual",null,null,"Daily",null,null,null,null,null,null,null,null,null,null,null,"SQE Review Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▲"]
["Increased Contracted Capacity ",null,"Annual",null,null,"Daily",null,null,null,null,null,null,null,null,null,null,null,"SQE Reviewed"]
[]
["PRODUCTION SYSTEM",null,"SYSTEM AVAILABILITY (TIME)",null,null,null,null,null,null,null,null,"SYSTEM CAPACITY (UNITS)",null,null,null,null,null,null,null,null,"Post Process Buffer",null,null,"RUN at RATE STUDY RESULTS"]
["List each separate OPERATION in production line",null,"Shifts Per Week","Shifts per Day","Minutes Per Shift","Gross Min Avail/  day","Scheduled Break/Lunch (minutes per day)","Changeovers/Tool Changes (minutes per day)","Planned Maintenance (minutes per day)","Unscheduled Downtime (minutes per day)","Net Available Minutes/day","Time allocated for other customers (minutes)","Net Minutes Available/day for Study Parts","LINE Cycle Time Per Part (seconds)","% Scrap","% True Scrap (Total Loss)","Estimated Throughput for study parts per day","CONTRACTED parts per day","%   Utilization","Result       >85% Concern     >90 Problem","Minimum","Maximum",null,"Total \"All Customers\" Parts Produced","Run at Rate Actual OK parts produced","Available Capacity > Contracted Capacity?","Run at Rate Actual Scrap (part count)","Run at Rate Actual Downtime (minutes)"]
[1,null,null,null,null,{"$f":"D10*E10","v":0},null,null,null,null,{"$f":"F10-G10-H10-I10-J10","v":0},null,{"$f":"K10-L10","v":0},null,null,{"$f":"SUM(O10:O29)","v":0},{"$f":"IF(N10>0,(1-P10)*M10*60/N10,0)","v":0},null,{"$f":"IF(Q10<>0,R10/Q10,0)","v":0},{"$f":"IF(S10>0.8499,IF(S10>0.8999,\"X\",$AG$5),\"\")","v":""},null,null,null,null,null,"YES/NO"]
[2,null,null,null,null,0,null,null,null,null,0,null,0,null,null,{"$f":"P10-O11","v":0},{"$f":"IF(N11<>0,(1-P11)*M11*60/N11,0)","v":0},null,0,"",null,null,null,null,null,"YES/NO"]
[3,null,null,null,null,0,null,null,null,null,0,null,0,null,null,{"$f":"P11-O12","v":0},0,null,{"$f":"IF(Q12<>0,R12/Q12,0)","v":0},"",null,null,null,null,null,"YES/NO"]
[4,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[5,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[6,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[7,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[8,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[9,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[10,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[11,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[12,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[13,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[14,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[15,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[16,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[17,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[18,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[19,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,"",null,null,null,null,null,"YES/NO"]
[20,null,null,null,null,0,null,null,null,null,0,null,0,null,null,0,0,null,0,{"$f":"IF(S29>0.8499,IF(S29>0.8999,\"X\",AG24),\"\")","v":""},null,null,null,null,null,"YES/NO"]
[]
["Notes/Comments"]
[]
[]
[]
[]
[null,"Legend","▲","Concern constraint - please check operations"]
[null,null,"X","Problem constraint - requires C3 "]

{"sheet":"C2 Example","index":2,"n_rows":37,"n_cols":33,"rows_kept":37,"cut":false,"hidden":true,"merged":[[31,0,31,27],[32,0,32,27],[33,0,33,27],[7,0,7,1],[7,2,7,10],[7,11,7,19],[7,23,7,27],[8,0,8,1],[30,2,30,27],[4,3,4,4],[4,17,4,19],[4,22,4,27],[5,3,5,4],[5,17,5,19],[5,22,5,27],[3,2,3,6],[3,17,3,19],[3,22,3,27],[0,2,0,6],[1,2,1,6],[2,2,2,6],[2,17,2,19],[2,22,2,27]]}
["Supplier Name",null,"XYZ Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▲"]
["Part(s) Name",null,"XYZ Assembly"]
["Part(s) Number",null,"XYZ000123",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete Date",null,null,null,null,"2008-08-01"]
["Working Days per Year",null,235,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed by",null,null,null,null,"Bill the Supplier"]
["Contracted Capacity ",null,"Annual",258500,null,"Daily",1100,null,null,null,null,null,null,null,null,null,null,"SQE Review Date",null,null,null,null,"2008-08-25",null,null,null,null,null,null,null,null,null,"▲"]
["Increased Contracted Capacity ",null,"Annual",300000,null,"Daily",1277,null,null,null,null,null,null,null,null,null,null,"SQE Reviewed",null,null,null,null,"Joe the SQE"]
[]
["PRODUCTION SYSTEM",null,"SYSTEM AVAILABILITY (TIME)",null,null,null,null,null,null,null,null,"SYSTEM CAPACITY (UNITS)",null,null,null,null,null,null,null,null,null,"Post Process Buffer",null,"RUN at RATE STUDY RESULTS"]
["List each separate OPERATION in production line",null,"Shifts Per Week","Shifts per Day","Minutes Per Shift","Gross Min Avail/day","Scheduled Break/Lunch (minutes per day)","Changeovers/Tool Changes (minutes per day)","Planned Maintenance (minutes per day)","Unscheduled Downtime (minutes per day)","Net Available Minutes/day","Time allocated for other customers (minutes)","Net Minutes Available/day for Study Parts","LINE Cycle Time Per Part (seconds)","% Scrap","% True Scrap (Total Loss)","Estimated Throughput for study parts per day","NEW CONTRACTED parts per day","% Utilization","Result       >85% Concern     >90 Problem","RESULT: Mark X for possible constraint operation (>85%)","Minimum",null,"Total \"All Customers\" Parts Produced","Run at Rate Actual OK parts produced","Available Capacity > Contracted Capacity?","Run at Rate Actual Scrap (part count)","Run at Rate Actual Downtime (minutes)"]
[1,"OP C10",15,3,480,{"$f":"D10*E10","v":1440},150,45,0,70,{"$f":"F10-G10-H10-I10-J10","v":1175},367,{"$f":"K10-L10","v":808},11,0.04,{"$f":"SUM(O10:O29)","v":0.28000000000000003},{"$f":"IF(N10>0,(1-P10)*M10*60/N10,0)","v":3173.2363636363634},1277,{"$f":"IF(Q10<>0,R10/Q10,0)","v":0.4024282636596993},{"$f":"IF(S10>0.8499,IF(S10>0.8999,\"X\",$AG$5),\"\")","v":""},null,400,null,null,null,"YES/NO"]
[2,"OP C20",15,3,480,1440,150,45,0,75,1170,384,786,11.5,0.02,{"$f":"P10-O11","v":0.26},{"$f":"IF(N11<>0,(1-P11)*M11*60/N11,0)","v":3034.6434782608699},1277,{"$f":"IF(Q11<>0,R11/Q11,0)","v":0.42080725763931864},"",null,400,null,null,null,"YES/NO"]
[3,"SUB-ASSEMBLY C",15,3,480,1440,150,45,0,60,1185,567,618,31,0.01,{"$f":"P11-O12","v":0.25},897.09677419354841,1277,{"$f":"IF(Q12<>0,R12/Q12,0)","v":1.4234807623157137},"X","X",0,null,null,null,"YES/NO"]
[4,"OP A10",15,3,480,1440,150,45,0,90,1155,434,721,26,0.06,0.19,1347.7153846153847,1277,0.9475294372813251,"X",null,200,null,null,null,"YES/NO"]
[5,"OP A20",15,3,480,1440,150,45,0,215,1030,367,663,22,0.06,0.13,1573.1181818181817,1277,0.81176355010026413,"",null,200,null,null,null,"YES/NO"]
[6,"SUB-ASSEMBLY A",15,3,480,1440,150,45,0,80,1165,450,715,26,0.02,0.11,1468.5,1277,0.86959482465100446,"▲",null,500,null,null,null,"YES/NO"]
[7,"OP B10",15,3,480,1440,150,45,45,15,1185,484,701,29,0.01,0.1,1305.3103448275863,1277,0.97831140698473074,"X",null,500,null,null,null,"YES/NO"]
[8,"OP B20",15,3,480,1440,150,45,0,150,1095,384,711,26,1.4999999999999999E-2,8.5000000000000006E-2,1501.3038461538463,1277,0.85059397088172073,"▲",null,400,null,null,null,"YES/NO"]
[9,"OP B30",5,1,480,480,150,45,0,30,255,100,155,3,0.01,7.5000000000000011E-2,2867.5,1277,0.44533565823888405,"",null,4000,null,null,null,"YES/NO"]
[10,"OP B40",15,3,480,1440,150,45,0,100,1145,467,678,28,0.01,6.5000000000000016E-2,1358.4214285714284,1277,0.94006173131628634,"X",null,350,null,null,null,"YES/NO"]
[11,"SUB-ASSEMBLY B",15,3,480,1440,150,45,0,105,1140,384,756,29,0,6.5000000000000016E-2,1462.468965517241,1277,0.87318092220053023,"▲",null,600,null,null,null,"YES/NO"]
[12,"OP D10",15,3,480,1440,150,45,0,110,1135,484,651,14.5,2.5000000000000001E-2,4.0000000000000015E-2,2586.0413793103448,1277,0.49380493684929166,"",null,450,null,null,null,"YES/NO"]
[13,"FINAL ASSEMBLY",15,3,480,1440,150,45,0,30,1215,517,698,27,0,4.0000000000000015E-2,1489.0666666666666,1277,0.85758416905444135,"▲",null,2100,null,null,null,"YES/NO"]
[14,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[15,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[16,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[17,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[18,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[19,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,"",null,null,null,null,null,"YES/NO"]
[20,null,null,null,null,0,null,null,null,null,0,null,0,null,null,4.0000000000000015E-2,0,null,0,{"$f":"IF(S29>0.8499,IF(S29>0.8999,\"X\",AG24),\"\")","v":""},null,null,null,null,null,"YES/NO"]
[]
["Notes/Comments"]
[]
[]
[]
[]
[null,"Legend","▲","Concern constraint - please check operations"]
[null,null,"X","Problem constraint - requires C3 "]

{"sheet":"Instructions","index":3,"n_rows":192,"n_cols":5,"rows_kept":192,"cut":false,"hidden":false,"merged":[]}
["The purpose of this sheet is to analyze the operations and determine any Constraints within the System Level Analysis."]
["A Constraint is defined as the operation with highest utilization in the Production Line.  "]
["A Concern Constraint is any operation where the utilization is over 85%"]
["A Problem Constraint is any operation where the utilization is over 90%. "]
["Operation Availability"]
["Enter the process steps [Column A]"]
["Enter the number shifts per week that are normally operated (count of shifts) [Column B]  ****This is for reference only****"]
["Enter the total production available per day in minutes - this should equal raw time with breaks and any other downtime included [Column C]"]
["Enter scheduled breaks in minutes for the whole day - all shifts added together [Column D]"]
["Enter Average changeover time per day [Column E]"]
["Enter planned maintenance time that is during the normal production time [Column F]"]
["Enter average unscheduled downtime for that process step [Column G]"]
["Net Available Minutes is calculated [Column H]"]
["Enter average time per day for other parts - any part that is not being studied ATI used or other customer [Column I]"]
["Net Minutes Available/day for ATI PN is calculated [Column J]"]
["Cycle Time"]
["Enter average cycle time (stop watch time, recorded PLC times, etc.) [Column K]"]
["Operation Output (Parts)"]
["Enter average % scrap (count discrepant material, look at data) [Column L]"]
["% True Scrap is calculated (cumulative scrap affect assuming no scrap is reentered into process [Column M]"]
["Estimated Throughput for study parts per day is calculated using the data that has been input [Column N]"]
["Enter Parts required per day - Use the highest LCR value known or the contracted LCR [Column O]"]
["% Utilization is calculated comparing required parts and estimated parts [Column P]"]
["Result >85% Concern >90 Problem is calculated and shows up to visualize impacts [Column Q]"]
["Run@Rate ATI Validation - Separate Tab"]
["Enter Total \"All Customers\" Parts Produced [Column A]"]
["Enter Run at Rate Actual ATI parts produced [Column B]"]
["Circle Available Capacity > Contracted Capacity? [Column C]"]
["Enter Run at Rate Actual Scrap (part count) [Column D]"]
["Enter Run at Rate Actual Downtime (minutes) [Column E]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2P1"]

{"sheet":"Constraint Capacity","index":4,"n_rows":46,"n_cols":31,"rows_kept":46,"cut":false,"hidden":false,"merged":[[39,0,39,1],[40,0,42,19],[9,16,9,19],[11,0,11,1],[5,3,5,4],[6,3,6,4],[9,0,9,1],[9,2,9,10],[9,12,9,15],[3,2,3,6],[3,11,3,13],[3,14,3,17],[4,2,4,6],[4,11,4,13],[4,14,4,17],[1,2,1,6],[1,11,1,13],[1,14,1,17],[2,2,2,6],[2,11,2,13],[2,14,2,17]]}
[]
["Supplier Name",null,null,null,null,null,null,null,null,null,null,"Complete Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▲"]
["Part(s) Name",null,null,null,null,null,null,null,null,null,null,"Completed by"]
["Part(s) Number",null,null,null,null,null,null,null,null,null,null,"SQE Review Date"]
["Working Days per Year",null,null,null,null,null,null,null,null,null,null,"SQE Reviewed"]
["Contracted Capacity ",null,"Annual",null,null,"Daily",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"▲"]
["Increased Contracted Capacity ",null,"Annual",null,null,"Daily"]
[null,"CONSTRAINT PROCESS : "]
[]
["OPERATIONS",null,"OPERATION AVAILABILITY (TIME)",null,null,null,null,null,null,null,null,"Cycle Time","Operation Output (Parts)",null,null,null,"Utilization (%)"]
["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R ","S","T"]
["List each separate PROCESS STEP",null,"Shifts Per Week","Total Production Available (minutes/Day)","Scheduled Break / Lunch (minutes/Day)","Change-overs / Tool Changes (minutes/Day)","Planned Maintenance (minutes/Day)","Unscheduled Downtime (minutes/Day)","Net Available (minutes/day)","Average Time allocated for other parts (minutes/day)","Net Minutes Available/day for ATI PN","Average Operation Cycle Time Per Part (seconds/part)","% Scrap for operation","% True Scrap\n(Total Loss)","Estimated Throughput for study parts per day","Parts required per day","% Part Utilization","Result       >85% Concern     >90 Problem","% Process Utilization","Result       >85% Concern     >90 Problem"]
[1,null,null,null,null,null,null,null,{"$f":"D13-E13-F13-G13-H13","v":0},null,{"$f":"I13-J13","v":0},null,null,{"$f":"SUM(M13:M39)","v":0},{"$f":"IF(L13<>0,(1-N13)*K13*60/L13,0)","v":0},null,{"$f":"IF(O13<>0,P13/O13,0)","v":0},{"$f":"IF(Q13>0.8499,IF(Q13>0.8999,\"X\",$AE$6),\"\")","v":""},{"$f":"IF(L13<>0,(J13+((L13*(P13*(1+N13)))/60))/I13,0)","v":0},{"$f":"IF(S13>0.8499,IF(S13>0.8999,\"X\",$AE$6),\"\")","v":""}]
[2,null,null,null,null,null,null,null,0,null,{"$f":"I14-J14","v":0},null,null,0,{"$f":"IF(L14<>0,(1-N14)*K14*60/L14,0)","v":0},null,{"$f":"IF(O14<>0,P14/O14,0)","v":0},"",{"$f":"IF(L14<>0,(J14+((L14*(P14*(1+N14)))/60))/I14,0)","v":0},""]
[3,null,null,null,null,null,null,null,0,null,0,null,null,{"$f":"SUM(M15:M40)","v":0},0,null,0,"",0,""]
[4,null,null,null,null,null,null,null,0,null,0,null,null,{"$f":"SUM(M16:M43)","v":0},0,null,0,"",0,""]
[5,null,null,null,null,null,null,null,0,null,0,null,null,{"$f":"SUM(M17:M43)","v":0},0,null,0,"",0,""]
[6,null,null,null,null,null,null,null,0,null,0,null,null,{"$f":"SUM(M18:M43)","v":0},0,null,0,"",0,""]
[7,null,null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[8,null,null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[9,null,null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[10,null,null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[11," ",null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[12," ",null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[13," ",null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[14," ",null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[15," ",null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[16," ",null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[17," ",null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[18," ",null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[19," ",null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,"",0,""]
[20," ",null,null,null,null,null,null,0,null,0,null,null,0,0,null,0,{"$f":"IF(Q32>0.8499,IF(Q32>0.8999,\"X\",AE27),\"\")","v":""},0,{"$f":"IF(S32>0.8499,IF(S32>0.8999,\"X\",$AE$6),\"\")","v":""}]
[]
[]
[null,null,"Cell to be input from supplier information"]
[null,null,"Calculation"]
[null,null,"Comparison data"]
[]
[]
["Notes/Comments"]
[]
[]
[]
[]
[null,"Column R Legend","▲","Concern constraint - please check operations"]
[null,null,"X","Problem constraint "]

{"sheet":"Run@Rate ATI Validation","index":5,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,0,5,4]]}
[]
[]
[]
[]
["RUN AT RATE STUDY RESULTS"]
[]
["Total \"All Customers\" Parts Produced","Run at Rate Actual OK parts produced","Available Capacity > Contracted Capacity?","Run at Rate Actual Scrap (part count)","Run at Rate Actual Downtime (minutes)"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]
[null,null,"YES/NO"]