{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Capacity Planning","Process 1 Shared Loading Plan","Process 2 Shared Loading Plan","Process 3 Shared Loading Plan","Process 4 Shared Loading Plan","Process 5 Shared Loading Plan","Process 6 Shared Loading Plan","Process 7 Shared Loading Plan"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Instructions","index":0,"n_rows":286,"n_cols":24,"rows_kept":286,"cut":false,"hidden":false,"merged":[[0,1,0,12],[8,1,8,12],[17,1,19,12],[21,1,21,12],[4,1,7,12],[10,4,12,9],[13,1,13,3],[13,4,13,11],[14,8,14,9],[15,1,15,3],[15,4,15,11],[264,1,264,4],[277,8,283,11],[279,1,279,3],[279,4,279,6],[281,1,281,3],[281,4,281,6],[2,1,2,12],[246,1,246,4],[247,1,247,4],[248,1,255,3],[256,1,263,3],[206,1,206,4],[207,1,207,4],[208,1,208,4],[243,1,243,4],[82,1,112,12],[67,1,67,4],[68,1,68,4],[69,1,69,4],[72,1,72,4],[73,1,73,4],[74,1,74,4],[39,8,39,9],[65,1,65,4],[52,1,52,4],[53,1,53,4],[54,1,54,4],[55,1,55,4],[56,1,56,4],[57,1,57,4],[42,1,45,12],[47,1,47,12],[58,1,58,4],[61,1,61,4],[62,1,62,4],[63,1,63,4],[64,1,64,4],[40,1,40,3],[27,1,27,3],[27,4,27,6],[27,7,27,8],[27,9,27,11],[38,1,38,3],[38,4,38,6],[38,7,38,8],[38,9,38,11],[29,1,32,12],[34,1,34,12],[25,1,25,3],[25,4,25,6],[25,7,25,8],[25,9,25,11],[26,8,26,9],[40,4,40,6],[40,7,40,8],[40,9,40,11],[191,1,191,4],[75,1,75,4],[76,1,76,4],[77,1,77,4],[80,1,80,4],[182,1,182,4],[183,1,183,4],[177,1,177,12],[184,1,184,4],[185,1,185,4],[186,1,186,4],[187,1,187,4],[151,1,175,12],[114,1,114,12],[266,1,272,12],[285,1,291,12],[274,1,274,12],[190,1,190,4],[244,1,244,4],[245,1,245,4],[210,1,236,12],[192,1,192,4],[193,1,193,4],[196,1,196,4],[202,1,202,4],[204,1,204,4],[205,1,205,4],[238,1,238,12],[283,4,283,6]]}
[null,"General Information KSPQP - PRODUCTION CAPACITY PLAN REPORT"]
[null,"Macros must be enable to use this document."]
[null,"Objective: The KSPQP Production Capacity Plan Report is used to demonstrate the supplier's production system can support the required customer volume per week .\nShared Loading Plans are used to demonstrated all production streams, including internal sub-assembly and sub-tier components can also achieve the required customer volume."]
[]
[null,"Capacity Verification:\nThe KSPQP Production Capacity Plan Report consists of three elements, Capacity Planning (verification of production readiness), Shared Loading Plans (verification of production stream readiness) and  Run at Rate (verification of production performance). \nThe Capacity Analysis Report is divided into 7 areas for ease of use.  Each area has a heading at the top of the box.  The headings are:\n\n1· Supplier Details\n2· Supplier Contact Details\n3· Part Information\n4 a· Capacity Planning\n4 b. Shared loading Plan\n5· Run at Rate\n6· Capacity Confirmation\n7· Kasai Approval\n\nData input:\nThe KSPQP Production Capacity Plan Report worksheet has been divided into a number of easy to identify information boxes.  Each box has a main heading to allow easy recognition. Within each box the user is required to input a variety of data.  This document will explain how to complete each section in turn. \n\nInput & Calculation Cells:\nData can only be input into the workbook in the cells on each sheet that require data.  This ensures that the headings or other information cannot be accidentally erased or modified. These cells (input cells) are clearly identified as white in colour. \nCells that are green in colour are calculation cells.  The user cannot enter data into these cells. They calculate values according to specific formulae using data entered into the input cells. "]
[]
[]
[]
[null,"1 Supplier Details."]
[]
[null,null,null,null,"KSPQP - PRODUCTION CAPACITY PLAN"]
[null,"1 Supplier Details",null,null,null,null,null,null,null,null,"Date completed:","2023-10-06"]
[]
[null,"Supplier Company Name:",null,null,"Example (A Company LTD)"]
[]
[null,"Supplier Address:",null,null,"Example (Stephenson Industrial Estate, Washington, Tyne and Wear, NE37 3HR)"]
[]
[null,"Supplier Company Name: Enter your company name.\nSupplier Address: Enter your company address.\nDate Completed: The date you completed the study."]
[]
[]
[]
[null,"2 Supplier Contact Details."]
[]
[null,"2 Supplier Contact Details"]
[]
[null,"Supplier Representative Name:",null,null,"Example (A Person)",null,null,"Supplier Representative Role:",null,"Example (Capacity Planner)"]
[]
[null,"Supplier Email Address:",null,null,"Example (aperson@acompanyltd.com)",null,null,"Supplier Phone Number:",null,"07700000000"]
[]
[null,"Supplier Representative Name: Enter the name of the person who completed the document.\nSupplier Representative Role: Enter the role within your company of the person who completed the document.\nSupplier Email Address: Enter the email address of the person that completed the document.\nSupplier Phone Number: Enter the phone number of the person that completed the document."]
[]
[]
[]
[]
[null,"3 Part Information."]
[]
[null,"3 Part Information"]
[]
[null,"Part Name:",null,null,"Example (A part name)",null,null,"Part Number:",null,"Example (1234 KUK123)"]
[]
[null,"Model:",null,null,"Example (Car model)",null,null,"Capacity Study Volume:",null,2904]
[]
[null,"Part Name: Enter the name of part that the study is based on.\nPart Number: Enter the part number that the study is based on.\nModel: Enter the vehicle model that the study is based on.\nCapacity Study Volume: Enter the capacity study volume supplied by Kasai."]
[]
[]
[]
[]
[null,"4 a Capacity Planning."]
[]
[null,"4 a Capacity Planning",null,null,null,"Shared",2,1,2,2,2,2]
[null,null,null,null,null,"Dedicated",2,1,2,2,2,2]
[null,"Total Production Hours",null,null,null,"Process 1","Process 2","Process 3","Process 4","Process 5","Process 6","Process 7"]
[null,"Process Description:",null,null,null,"Example 1","Example 2","Example 3","Example 4","Example 5","Example 6","Example 7"]
[null,"Shared or Dedicated process:",null,null,null,1,2,1,2,2,2,2]
[null,"Shifts per day:",null,null,null,3,3,3]
[null,"Total hours per shift:",null,null,null,8,8,8]
[null,"Breaks per shift (Minutes):",null,null,null,50,50,50]
[null,"Days per week:",null,null,null,5,5,5]
[null,"Net available time per week (Minutes):",null,null,null,6450,6450,6450,0,0,0,0]
[]
[null,"Projected Downtime"]
[null,"Planned maintenance per week (Minutes):",null,null,null,120,120,120]
[null,"Inspection of facility per week (Minutes):",null,null,null,25,25,25]
[null,"Planned changeovers (per Week):",null,null,null,1,1,1]
[null,"Time per changeover  (Minutes):",null,null,null,30,30,30]
[null,"Total planned downtime per week (Minutes):",null,null,null,175,175,175,0,0,0,0]
[]
[null,"Required Number of Parts"]
[null,"Projected parts rejected and reworked (%):",null,null,null,0.03,0.03,0.03]
[null,"Required number of parts per week:",null,null,null,2991.12,2991.12,2991.12,2904,2904,2904,2904]
[]
[null,"Planned Cycle Time / Capacity"]
[null,"Ideal planned cycle time per tool (Seconds):",null,null,null,65,100,100]
[null,"Number of tools in parallel:",null,null,null,1,1,1]
[null,"Number of parts produced per tool:",null,null,null,1,1,1]
[null,"Calculated allocation % to meet demand (%):",null,null,null,0.51639521912350594,0.79445418326693229,0.79445418326693229,{"$f":"IFERROR(I77/(((I59)-I66)),\"-\")","v":"-"},"-","-","-"]
[null,"Calculated time required to meet demand (Minutes):",null,null,null,3240.3799999999997,4985.2,4985.2,{"$f":"IFERROR(((I70/I74)/I75)/(60/I73),\"-\")","v":"-"},"-","-","-"]
[null,"Capacity planning confirmation:",null,null,null,"Capacity OK","Capacity OK","Capacity OK",{"$f":"IF(I76 = \"-\",\"-\",IF(I76 < 1,\"Capacity OK\",IF(I76 > 1,\"Over Capacity\",\"Next\")))","v":"-"},"-","-","-",null,null,{"$f":"IF(F76 = \"-\",\"-\",IF(F76 > 100%,\"Over Capacity\",\"\"))","v":""}]
[]
[null,"Actual Planned Production"]
[null,"Planned production per week:",null,null,null,2991.12,2991.12,2991.12,{"$f":"IFERROR(((((((I59)-I66)*60)*I76)/I73)*I74)*I75,\"-\")","v":"-"},"-","-","-"]
[]
[null,"Total Production Hours\nProcess Description: Enter a description for the process being studied.\nShared or Dedicated process: Select shared or dedicated depending on if the equipment / process is used for the production of other parts.\nIf shared is selected an associated shared loading plan tab will appear, this  shared loading plan must be populated with all the production that is planned on the shared resource.\nShifts per day: Enter the number of shifts worked on this process.\nTotal hours per shift: Enter the hours worked per shift.\nBreaks per shift (Minutes): Enter the total breaks per shift in minutes.\nDays per week: Enter the total number of day's per week worked.\nNet available time per week (Minutes): Shows the net available time per week for this process.\n\nProjected Downtime\nPlanned maintenance per week (Minutes): Enter the total time used for planned maintenance per week in minutes.\nInspection of facility per week (Minutes): Enter the total time used for inspection of the facility per week in minutes.\nPlanned changeovers (per Week): Enter the total number of planned change overs per week.\nTime per changeover  (Minutes): Enter the time that is taken to do one changeover in minutes.\nTotal planned downtime per week (Minutes): Shows the total amount of planned downtime for this process per week.\n\nRequired Number of Parts\nProjected parts rejected and reworked (%): Enter the project percentage of rework and reject parts.\nRequired number of parts per week: Shows the total number of parts including rejects that is required per week to cover the customers demand.\n\nPlanned Cycle Time / Capacity\nIdeal planned cycle time per tool (Seconds): Enter the ideal planned cycle time for the process in seconds.\nNumber of tools in parallel: Enter the number of tools that run in parallel.\nNumber of parts produced per tool: Enter the number of parts that are produced each cycle per tool.\nCalculated allocation % to meet demand (%): Shows the percentage of available production time for this process that is required to cover the customers demand.\nCalculated time required to meet demand (Minutes): Shows the calculated time required to meet the customer demand in minutes.\nCapacity planning confirmation: When capacity is OK cell is highlighted green and shows 'Capacity OK', when over capacity cell is highlight in red and shows 'Over Capacity'\n\nActual Planned Production\nPlanned production per week: Shows the planned production per week."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4 b Shared loading Plan."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(((R141*60)/R145)*R147,\"-\")","v":"-"}]
[]
[null,"Supplier Company Name: Auto populated from 'KSPQP - PRODUCTION CAPACITY PLAN'.\nSupplier Address: Auto populated from 'KSPQP - PRODUCTION CAPACITY PLAN'.\nShared Process Name: Auto populated from 'KSPQP - PRODUCTION CAPACITY PLAN'.\nDate Completed: Auto populated from 'KSPQP - PRODUCTION CAPACITY PLAN'.\nSupplier Representative Name: Auto populated from 'KSPQP - PRODUCTION CAPACITY PLAN'.\nSupplier Email Address: Auto populated from 'KSPQP - PRODUCTION CAPACITY PLAN'.\nSupplier Representative Role: Auto populated from 'KSPQP - PRODUCTION CAPACITY PLAN'.\nSupplier Phone Number: Auto populated from 'KSPQP - PRODUCTION CAPACITY PLAN'.\n\nThe 'Shared Loading Plan' is divided into seven columns allowing seven different part numbers to be shown. The first column is auto populated from the 'KSPQP - PRODUCTION CAPACITY PLAN'. The final column is reserved for production of other customers parts. The remaining columns are for any other Kasai parts that share the same process.\n\nPart Name: Enter the part name.\nPart Number: Enter the Part Number.\nCapacity Study Volume: Enter the required capacity study volume for the part.\nNet Available Time for Process: Enter the net available time for the part.\nTotal planned downtime per week: Enter the total amount of planned downtime per week for the part.\nOperation Time: Shows the Operation Time available for this part.\nProjected parts rejected and reworked: Enter the projected percentage of rejected and reworked parts.\nIdeal planned cycle time: Enter the ideal planned cycle time for the part.\nCalculated allocation % to meet demand: Enter the percentage of this process that is dedicated to the part.\nPlanned production per week: Shows the planned number of parts that could be produce based on above entered data.\n\nThe total percentage should not exceed 100%.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5 Run at Rate."]
[]
[null,"5 Run at Rate"]
[]
[null,"Availability"]
[null,"Total duration of production run (Minutes):",null,null,null,3330,6275,6275]
[null,"Total planned downtime (Minutes):",null,null,null,60,60,60]
[null,"Loading Time (Minutes):",null,null,null,3270,6215,6215,0,0,0,0]
[null,"Total unplanned downtime (Minutes):",null,null,null,30,30,30]
[null,"Operation Time (Minutes):",null,null,null,3240,6185,6185,0,0,0,0]
[null,"Availability (%):",null,null,null,0.99082568807339455,0.99517296862429605,0.99517296862429605,"-","-","-","-"]
[]
[null,"Quality (Right First Time)"]
[null,"Total parts produced:",null,null,null,2991,3500,3500]
[null,"Total scrap and reject parts produced:",null,null,null,87.1,87.1,87]
[null,"Quality RFT (%):",null,null,null,0.97087930458040794,0.97511428571428571,0.97514285714285709,"-","-","-","-"]
[]
[]
[null,"Productivity"]
[null,"Ideal planned cycle time (Seconds):",null,null,null,65,100,100,0,0,0,0]
[null,null,null,null,"Actual cycle time (Seconds):",65,100,100]
[null,null,null,null,"Operating speed rate (%):",1,1,1,"-","-","-","-"]
[null,null,null,null,"Required Manufacturing time (Minutes):",3240.25,5833.333333333333,5833.333333333333,0,0,0,0]
[null,null,null,null,"Operation Time (Minutes):",3240,6185,6185,0,0,0,0]
[null,null,null,null,"Net operating rate (%):",1.0000771604938272,0.94314201023982747,0.94314201023982747,"-","-","-","-"]
[null,"Productivity (%):",null,null,null,1.0000771604938272,0.94314201023982747,0.94314201023982747,"-","-","-","-"]
[]
[null,"OEE"]
[null,{"$f":"B188","v":"Availability (%):"},null,null,null,0.99082568807339455,0.99517296862429605,0.99517296862429605,"-","-","-","-"]
[null,{"$f":"B193","v":"Quality RFT (%):"},null,null,null,0.97087930458040794,0.97511428571428571,0.97514285714285709,"-","-","-","-"]
[null,{"$f":"B203","v":"Productivity (%):"},null,null,null,1.0000771604938272,0.94314201023982747,0.94314201023982747,"-","-","-","-"]
[null,"OEE (%):",null,null,null,0.96204638124362918,0.91523196567444343,0.91525878251541948,"-","-","-","-"]
[]
[null,"Availability\nTotal duration of production run (Minutes): Enter the total time taken for the production run in minutes.\nTotal planned downtime (Minutes): Enter the total amount of planned downtime during the production run in minutes.\nLoading Time (Minutes): Shows the total amount of loading time available in minutes.\nTotal unplanned downtime (Minutes): Enter the total amount of unplanned downtime that occurred during the production run in minutes.\nOperation Time (Minutes): Shows the operation time available for the production run.\nAvailability (%): Shows the availability percentage during the production run.\n\nQuality (Right First Time)\nTotal parts produced: Enter the total number of parts that were produced during the production run.\nTotal scrap and reject parts produced: Enter the total number of scrap and reject parts that were produced during the production run.\nQuality RFT (%): Shows the Right First Time percentage achieved during the production run.\n\nProductivity\nIdeal planned cycle time (Seconds): Shows the ideal planned cycle time for this process taken from the capacity planning stage.\nActual cycle time (Seconds): Enter the actual cycle time achieved during the production run.\nOperating speed rate (%): Shows the operating speed rate that was achieved during the production run.\nRequired Manufacturing time (Minutes): Shows the required manufacturing time for the production run in minutes. \nOperation Time (Minutes): Shows the operation time for the production run minutes.\nNet operating rate (%): Shows the net operating rate percentage that was achieved during the production run.\nProductivity (%): Shows the productivity percentage that was achieved during the production run.\n\nOEE\nAvailability (%): Shows the availability percentage achieved during the production run.\nQuality RFT (%): Shows the right first time percentage achieved during the production run.\nProductivity (%): Shows the productivity percentage achieved during the production run.\nOEE (%): Shows the OEE percentage achieved during the production run. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6 Capacity Confirmation."]
[]
[null,"6 Capacity Confirmation"]
[]
[null,"Projected Available Parts"]
[null,"Actual shared allocation percentage (%):",null,null,null,0.51639999999999997,1,0.6]
[null,"Number of parts available to ship per week:",null,null,null,2904.2674688271604,3462.5622473726758,2077.5982215036379,"-","-","-","-"]
[null,"Number of parts required per week:",null,null,null,2904,2904,2904,2904,2904,2904,2904]
[null,"Percentage  above / below required  parts per week:",null,null,null,1.0000921035906201,1.1923423716848056,0.7154263848153023,"-","-","-","-"]
[]
[null,null,null,null,null,"Example 1","Example 2","Example 3","Example 4","Example 5","Example 6","Example 7"]
[null,null,null,null,"Number of parts available to ship per week:",2904.2674688271604,3462.5622473726758,2077.5982215036379,"-","-","-","-"]
[null,null,null,null,"Number of parts required per week:",2904,2904,2904,2904,2904,2904,2904]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Projected Available Parts\nActual shared allocation percentage (%): Enter the actual percentage of the total production time that will be allocated to this process.\nNumber of parts available to ship per week: Shows the number of parts that would be available to ship based on information from the 'Capacity Planning' and 'Run at Rate' stages.\nNumber of parts required per week: Shows the required capacity planning volume that should be achieved.\nPercentage  above / below required  parts per week: Shows what percentage of the required number of parts will be available to ship.\n\nThe graph titled 'Bottleneck Processes' visual shows where any bottle neck process are that could stop the 'Capacity Planning Volume' being achieved."]
[]
[]
[]
[]
[]
[]
[]
[null,"7 Kasai Approval."]
[]
[]
[null,"7 Kasai Approval",null,"Approval:",1,null,null,"Comments:"]
[]
[null,"Kasai Representative Name:",null,null,"Example (A Person)"]
[]
[null,"Kasai Representative Role:",null,null,"Example (aperson@kasai-group.com)",null,null,"Please select"]
[null,null,null,null,null,null,null,"Approved"]
[null,null,null,"Date completed:","2023-10-06",null,null,"Rejected"]
[]
[null,"This section should be completed by a Kasai representative.\n\nApproval: Select 'Approved' or 'Rejected' from the drop down list.\nKasai Representative Name: Enter your name.\nKasai Representative Role: Enter your role within Kasai.\nDate completed: Enter the date the study was reviewed.\nComments: Enter any comments you would like to make."]

{"sheet":"Capacity Planning","index":1,"n_rows":124,"n_cols":12,"rows_kept":124,"cut":false,"hidden":false,"merged":[[95,1,95,4],[96,1,96,4],[97,1,104,3],[105,1,112,3],[113,1,113,4],[94,1,94,4],[70,1,70,4],[71,1,71,4],[74,1,74,4],[80,1,80,4],[82,1,82,4],[83,1,83,4],[84,1,84,4],[85,1,85,4],[86,1,86,4],[92,1,92,4],[93,1,93,4],[69,1,69,4],[49,1,49,4],[50,1,50,4],[51,1,51,4],[54,1,54,4],[60,1,60,4],[61,1,61,4],[62,1,62,4],[63,1,63,4],[64,1,64,4],[65,1,65,4],[68,1,68,4],[48,1,48,4],[32,1,32,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[41,1,41,4],[42,1,42,4],[43,1,43,4],[46,1,46,4],[47,1,47,4],[31,1,31,4],[18,1,18,3],[18,4,18,6],[18,7,18,8],[18,9,18,11],[19,8,19,9],[20,1,20,3],[20,4,20,6],[20,7,20,8],[20,9,20,11],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[13,1,13,3],[13,4,13,6],[13,7,13,8],[13,9,13,11],[1,4,3,9],[4,1,4,3],[4,4,4,11],[5,8,5,9],[6,1,6,3],[6,4,6,11],[11,1,11,3],[11,4,11,6],[11,7,11,8],[11,9,11,11],[12,8,12,9],[123,4,123,6],[117,8,123,11],[121,1,121,3],[121,4,121,6],[119,1,119,3],[119,4,119,6]]}
[]
[null,null,null,null,"KSPQP - PRODUCTION CAPACITY PLAN"]
[null,"1 Supplier Details",null,null,null,null,null,null,null,null,"Date completed:","2023-11-08"]
[]
[null,"Supplier Company Name:",null,null,"Example (A Company LTD)"]
[]
[null,"Supplier Address:",null,null,"Example (Stephenson Industrial Estate, Washington, Tyne and Wear, NE37 3HR)"]
[]
[]
[null,"2 Supplier Contact Details"]
[]
[null,"Supplier Representative Name:",null,null,"Example (A Person)",null,null,"Supplier Representative Role:",null,"Example (Capacity Planner)"]
[]
[null,"Supplier Email Address:",null,null,"Example (aperson@acompanyltd.com)",null,null,"Supplier Phone Number:",null,"07700000000"]
[]
[]
[null,"3 Part Information"]
[]
[null,"Part Name:",null,null,"Example (A part name)",null,null,"Part Number:",null,"Example (1234 KUK123)"]
[]
[null,"Model:",null,null,"Example (Car model)",null,null,"Capacity Study Volume:",null,2904]
[]
[]
[null,"4 Capacity Planning",null,null,null,"Shared"]
[null,null,null,null,null,"Dedicated"]
[null,"Total Production Hours",null,null,null,"Process 1","Process 2","Process 3","Process 4","Process 5","Process 6","Process 7"]
[null,"Process Description:",null,null,null,"Injection Moulding 2003","Example 2","Example 3","Example 4","Example 5","Example 6","Example 7"]
[null,"Shared or Dedicated process:",null,null,null,1,2,1,2,2,2,2]
[null,"Shifts per day:",null,null,null,3,3,3]
[null,"Total hours per shift:",null,null,null,8,8,8]
[null,"Breaks per shift (Minutes):",null,null,null,50,50,50]
[null,"Days per week:",null,null,null,5,5,5]
[null,"Net available time per week (Minutes):",null,null,null,{"$f":"(((F29*F30)*F32)*60)-((F29*F32)*F31)","v":6450},{"$f":"(((G29*G30)*G32)*60)-((G29*G32)*G31)","v":6450},6450,0,0,0,0]
[]
[null,"Projected Downtime"]
[null,"Planned maintenance per week (Minutes):",null,null,null,135,135,135]
[null,"Inspection of facility per week (Minutes):",null,null,null,0,0,0]
[null,"Planned changeovers (per Week):",null,null,null,3,3,3]
[null,"Time per changeover  (Minutes):",null,null,null,30,30,30]
[null,"Total planned downtime per week (Minutes):",null,null,null,{"$f":"(F38*F39)+F36+F37","v":225},{"$f":"(G38*G39)+G36+G37","v":225},225,0,0,0,0]
[]
[null,"Required Number of Parts"]
[null,"Projected parts rejected and reworked (%):",null,null,null,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2]
[null,"Required number of parts per week:",null,null,null,{"$f":"($J$21*F43)+$J$21","v":2975.1480000000001},{"$f":"($J$21*G43)+$J$21","v":2975.1480000000001},{"$f":"($J$21*H43)+$J$21","v":2975.1480000000001},2904,2904,2904,2904]
[]
[null,"Planned Cycle Time / Capacity"]
[null,"Ideal planned cycle time per tool (Seconds):",null,null,null,65,100,100]
[null,"Number of tools in parallel:",null,null,null,1,1,1]
[null,"Number of parts produced per tool:",null,null,null,1,1,1]
[null,"Calculated allocation % to meet demand (%):",null,null,null,{"$f":"IFERROR((F51/60)/(F33/60),\"-\")","v":0.53458558139534884},{"$f":"IFERROR((G51/60)/(G33/60),\"-\")","v":0.8036558139534884},{"$f":"IFERROR((H51/60)/(H33/60),\"-\")","v":0.8036558139534884},"-","-","-","-"]
[null,"Calculated time required to meet demand (Minutes):",null,null,null,{"$f":"IFERROR(((((F44*((F47/F48)/F49))/3600))+(F40/60))*60,\"-\")","v":3448.0770000000002},{"$f":"IFERROR(((((G44*((G47/G48)/G49))/3600))+(G40/60))*60,\"-\")","v":5183.58},{"$f":"IFERROR(((((H44*((H47/H48)/H49))/3600))+(H40/60))*60,\"-\")","v":5183.58},"-","-","-","-"]
[null,"Capacity planning confirmation:",null,null,null,{"$f":"IF(F50 = \"-\",\"-\",IF(F50 < 1,\"Capacity OK\",IF(F50 > 1,\"Over Capacity\",\"Next\")))","v":"Capacity OK"},{"$f":"IF(G50 = \"-\",\"-\",IF(G50 < 1,\"Capacity OK\",IF(G50 > 1,\"Over Capacity\",\"Next\")))","v":"Capacity OK"},"Capacity OK","-","-","-","-"]
[]
[null,"Actual Planned Production"]
[null,"Planned production per week:",null,null,null,{"$f":"IFERROR((((F33*F50)-F40)*60)/F47,\"-\")","v":2975.1480000000006},{"$f":"IFERROR((((G33*G50)-G40)*60)/G47,\"-\")","v":2975.1479999999997},{"$f":"IFERROR((((H33*H50)-H40)*60)/H47,\"-\")","v":2975.1479999999997},"-","-","-","-"]
[]
[]
[null,"5 Run at Rate"]
[]
[null,"Availability"]
[null,"Total duration of production run (Minutes):",null,null,null,1258,6275,6275]
[null,"Total planned downtime (Minutes):",null,null,null,240,60,60]
[null,"Loading Time (Minutes):",null,null,null,{"$f":"F61-F62","v":1018},{"$f":"G61-G62","v":6215},6215,0,0,0,0]
[null,"Total unplanned downtime (Minutes):",null,null,null,107,30,30]
[null,"Operation Time (Minutes):",null,null,null,{"$f":"F63-F64","v":911},{"$f":"G63-G64","v":6185},6185,0,0,0,0]
[null,"Availability (%):",null,null,null,{"$f":"IFERROR(F65/F63,\"-\")","v":0.89489194499017677},{"$f":"IFERROR(G65/G63,\"-\")","v":0.99517296862429605},0.99517296862429605,"-","-","-","-"]
[]
[null,"Quality (Right First Time)"]
[null,"Total parts produced:",null,null,null,822,3500,3500]
[null,"Total scrap and reject parts produced:",null,null,null,24,87.1,87]
[null,"Quality RFT (%):",null,null,null,{"$f":"IFERROR((F69-F70)/F69,\"-\")","v":0.97080291970802923},{"$f":"IFERROR((G69-G70)/G69,\"-\")","v":0.97511428571428571},0.97514285714285709,"-","-","-","-"]
[]
[]
[null,"Productivity"]
[null,"Ideal planned cycle time (Seconds):",null,null,null,{"$f":"F47","v":65},100,100,0,0,0,0]
[null,null,null,null,"Actual cycle time (Seconds):",66.5,100,100]
[null,null,null,null,"Operating speed rate (%):",{"$f":"IFERROR(F75/F76,\"-\")","v":0.97744360902255634},{"$f":"IFERROR(G75/G76,\"-\")","v":1},1,"-","-","-","-"]
[null,null,null,null,"Required Manufacturing time (Minutes):",{"$f":"IFERROR((F69*F76)/60,\"-\")","v":911.05},{"$f":"IFERROR((G69*G76)/60,\"-\")","v":5833.333333333333},5833.333333333333,0,0,0,0]
[null,null,null,null,"Operation Time (Minutes):",{"$f":"F65","v":911},{"$f":"G65","v":6185},6185,0,0,0,0]
[null,null,null,null,"Net operating rate (%):",{"$f":"IFERROR(F78/F79,\"-\")","v":1.0000548847420416},{"$f":"IFERROR(G78/G79,\"-\")","v":0.94314201023982747},0.94314201023982747,"-","-","-","-"]
[null,"Productivity (%):",null,null,null,{"$f":"IFERROR(F77*F80,\"-\")","v":0.97749725576289781},{"$f":"IFERROR(G77*G80,\"-\")","v":0.94314201023982747},0.94314201023982747,"-","-","-","-"]
[]
[null,"OEE"]
[null,{"$f":"B66","v":"Availability (%):"},null,null,null,{"$f":"F66","v":0.89489194499017677},{"$f":"G66","v":0.99517296862429605},0.99517296862429605,"-","-","-","-"]
[null,{"$f":"B71","v":"Quality RFT (%):"},null,null,null,{"$f":"F71","v":0.97080291970802923},{"$f":"G71","v":0.97511428571428571},0.97514285714285709,"-","-","-","-"]
[null,{"$f":"B81","v":"Productivity (%):"},null,null,null,{"$f":"F81","v":0.97749725576289781},{"$f":"G81","v":0.94314201023982747},0.94314201023982747,"-","-","-","-"]
[null,"OEE (%):",null,null,null,{"$f":"IFERROR(F84*F85*F86,\"-\")","v":0.84921414538310402},{"$f":"IFERROR(G84*G85*G86,\"-\")","v":0.91523196567444343},0.91525878251541948,"-","-","-","-"]
[]
[]
[null,"6 Capacity Confirmation"]
[]
[null,"Projected Available Parts"]
[null,"Actual shared allocation percentage (%):",null,null,null,0.53459999999999996,1,0.6]
[null,"Number of parts available to ship per week:",null,null,null,{"$f":"IFERROR(((F33-F40)*F93)/(F65/(F69-F70)),\"-\")","v":2915.095751920966},{"$f":"IFERROR(((G33-G40)*G93)/(G65/(G69-G70)),\"-\")","v":3434.9721099434119},2061.0436540016167,"-","-","-","-"]
[null,"Number of parts required per week:",null,null,null,{"$f":"$J$21","v":2904},{"$f":"$J$21","v":2904},2904,2904,2904,2904,2904]
[null,"Percentage  above / below required  parts per week:",null,null,null,{"$f":"IFERROR(F94/F95,\"-\")","v":1.0038208512124538},{"$f":"IFERROR(G94/G95,\"-\")","v":1.1828416356554448},0.70972577617135557,"-","-","-","-"]
[]
[null,null,null,null,null,{"$f":"F27","v":"Injection Moulding 2003"},"Example 2","Example 3","Example 4","Example 5","Example 6","Example 7"]
[null,null,null,null,{"$f":"B94","v":"Number of parts available to ship per week:"},{"$f":"F94","v":2915.095751920966},{"$f":"G94","v":3434.9721099434119},2061.0436540016167,"-","-","-","-"]
[null,null,null,null,{"$f":"B95","v":"Number of parts required per week:"},{"$f":"F95","v":2904},2904,2904,2904,2904,2904,2904]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7 Kasai Approval",null,"Approval:",1,null,null,"Comments:"]
[]
[null,"Kasai Representative Name:",null,null,"Example (A Person)"]
[]
[null,"Kasai Representative Role:",null,null,"Example (aperson@kasai-group.com)",null,null,"Please select"]
[null,null,null,null,null,null,null,"Approved"]
[null,null,null,"Date completed:","2023-10-06",null,null,"Rejected"]

{"sheet":"Process 1 Shared Loading Plan","index":2,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,4,3,15],[27,5,27,6],[29,5,29,6],[31,5,31,6],[15,7,15,8],[15,9,15,10],[19,7,19,8],[19,9,19,10],[23,7,23,8],[23,9,23,10],[19,5,19,6],[21,5,21,6],[23,5,23,6],[25,5,25,6],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[19,11,19,12],[19,13,19,14],[19,15,19,16],[19,17,19,18],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[23,11,23,12],[23,13,23,14],[23,15,23,16],[23,17,23,18],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,17,25,18],[29,13,29,14],[29,15,29,16],[29,17,29,18],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[27,15,27,16],[27,17,27,18],[29,7,29,8],[29,9,29,10],[29,11,29,12],[33,13,33,14],[33,15,33,16],[33,17,33,18],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[31,15,31,16],[31,17,31,18],[33,7,33,8],[33,9,33,10],[33,11,33,12],[25,1,25,4],[27,1,27,4],[29,1,29,4],[31,1,31,4],[33,5,33,6],[5,4,5,11],[11,4,11,11],[3,18,3,19],[33,1,33,4],[5,1,5,3],[7,1,7,3],[11,1,11,3],[5,12,5,15],[7,12,7,15],[9,12,9,15],[11,12,11,15],[15,1,15,4],[17,1,17,4],[19,1,19,4],[21,1,21,4],[23,1,23,4]]}
[]
[]
[null,null,null,null,"KSPQP - SHARED LOADING PLAN PROCESS 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date completed:",{"$f":"'Capacity Planning'!L3","v":"2023-11-08"}]
[]
[null,"Supplier Company Name:",null,null,{"$f":"'Capacity Planning'!E5:L5","v":"Example (A Company LTD)"},null,null,null,null,null,null,null,"Supplier Representative Name:",null,null,null,{"$f":"'Capacity Planning'!E12","v":"Example (A Person)"}]
[]
[null,"Supplier Address:",null,null,{"$f":"'Capacity Planning'!E7:L7","v":"Example (Stephenson Industrial Estate, Washington, Tyne and Wear, NE37 3HR)"},null,null,null,null,null,null,null,"Supplier Email Address:",null,null,null,{"$f":"'Capacity Planning'!E14","v":"Example (aperson@acompanyltd.com)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Representative Role:",null,null,null,{"$f":"'Capacity Planning'!J12","v":"Example (Capacity Planner)"}]
[]
[null,"Shared Process Name:",null,null,{"$f":"'Capacity Planning'!F27","v":"Injection Moulding 2003"},null,null,null,null,null,null,null,"Supplier Phone Number:",null,null,null,{"$f":"'Capacity Planning'!J14","v":"07700000000"}]
[]
[]
[]
[null,"Part Name:",null,null,null,{"$f":"'Capacity Planning'!E19","v":"Example (A part name)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Part Number:",null,null,null,{"$f":"'Capacity Planning'!J19","v":"Example (1234 KUK123)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Capacity Study Volume:",null,null,null,{"$f":"'Capacity Planning'!J21","v":2904}]
[]
[null,"Net Available Time for Process:",null,null,null,{"$f":"'Capacity Planning'!F33","v":6450}]
[]
[null,"Total planned downtime per week (Minutes):",null,null,null,{"$f":"'Capacity Planning'!F40","v":225}]
[]
[null,"Operation Time (Minutes):",null,null,null,{"$f":"F22-F24","v":6225},null,{"$f":"H22-H24","v":0},null,{"$f":"J22-J24","v":0},null,{"$f":"L22-L24","v":0},null,{"$f":"N22-N24","v":0},null,{"$f":"P22-P24","v":0},null,{"$f":"R22-R24","v":0}]
[]
[null,"Projected parts rejected and reworked (%):",null,null,null,{"$f":"'Capacity Planning'!F43","v":2.4500000000000001E-2}]
[]
[null,"Ideal planned cycle time (Seconds):",null,null,null,{"$f":"'Capacity Planning'!F47","v":65}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Calculated allocation % to meet demand (%):",null,null,null,{"$f":"'Capacity Planning'!F50","v":0.53458558139534884},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:R32)","v":0.53458558139534884}]
[]
[null,"Planned production per week (Parts):",null,null,null,{"$f":"IFERROR((((F22*F32)-F24))*(60/F30),\"-\")","v":2975.1480000000006},null,{"$f":"IFERROR((((H22*H32)-H24))*(60/H30),\"-\")","v":"-"},null,{"$f":"IFERROR((((J22*J32)-J24))*(60/J30),\"-\")","v":"-"},null,{"$f":"IFERROR((((L22*L32)-L24))*(60/L30),\"-\")","v":"-"},null,{"$f":"IFERROR((((N22*N32)-N24))*(60/N30),\"-\")","v":"-"},null,{"$f":"IFERROR((((P22*P32)-P24))*(60/P30),\"-\")","v":"-"},null,{"$f":"IFERROR((((R22*R32)-R24))*(60/R30),\"-\")","v":"-"}]

{"sheet":"Process 2 Shared Loading Plan","index":3,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":true,"merged":[[7,1,7,3],[7,12,7,15],[2,4,3,15],[3,18,3,19],[5,1,5,3],[5,4,5,11],[5,12,5,15],[9,12,9,15],[11,1,11,3],[11,4,11,11],[11,12,11,15],[15,1,15,4],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[17,1,17,4],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[19,15,19,16],[19,17,19,18],[21,1,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[19,1,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[23,15,23,16],[23,17,23,18],[25,1,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,17,25,18],[23,1,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[27,15,27,16],[27,17,27,18],[29,1,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[27,1,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[31,15,31,16],[31,17,31,18],[33,1,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,15,33,16],[33,17,33,18],[31,1,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14]]}
[]
[]
[null,null,null,null,"KSPQP - SHARED LOADING PLAN PROCESS 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date completed:",{"$f":"'Capacity Planning'!L3","v":"2023-11-08"}]
[]
[null,"Supplier Company Name:",null,null,{"$f":"'Capacity Planning'!E5:L5","v":"Example (A Company LTD)"},null,null,null,null,null,null,null,"Supplier Representative Name:",null,null,null,{"$f":"'Capacity Planning'!E12","v":"Example (A Person)"}]
[]
[null,"Supplier Address:",null,null,{"$f":"'Capacity Planning'!E7:L7","v":"Example (Stephenson Industrial Estate, Washington, Tyne and Wear, NE37 3HR)"},null,null,null,null,null,null,null,"Supplier Email Address:",null,null,null,{"$f":"'Capacity Planning'!E14","v":"Example (aperson@acompanyltd.com)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Representative Role:",null,null,null,{"$f":"'Capacity Planning'!J12","v":"Example (Capacity Planner)"}]
[]
[null,"Shared Process Name:",null,null,{"$f":"'Capacity Planning'!G27","v":"Example 2"},null,null,null,null,null,null,null,"Supplier Phone Number:",null,null,null,{"$f":"'Capacity Planning'!J14","v":"07700000000"}]
[]
[]
[]
[null,"Part Name:",null,null,null,{"$f":"'Capacity Planning'!E19","v":"Example (A part name)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Part Number:",null,null,null,{"$f":"'Capacity Planning'!J19","v":"Example (1234 KUK123)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Capacity Study Volume:",null,null,null,{"$f":"'Capacity Planning'!J21","v":2904}]
[]
[null,"Net Available Time for Process:",null,null,null,{"$f":"'Capacity Planning'!G33","v":6450}]
[]
[null,"Total planned downtime per week (Minutes):",null,null,null,{"$f":"'Capacity Planning'!G40","v":225}]
[]
[null,"Operation Time (Minutes):",null,null,null,{"$f":"F22-F24","v":6225},null,{"$f":"H22-H24","v":0},null,{"$f":"J22-J24","v":0},null,{"$f":"L22-L24","v":0},null,{"$f":"N22-N24","v":0},null,{"$f":"P22-P24","v":0},null,{"$f":"R22-R24","v":0}]
[]
[null,"Projected parts rejected and reworked (%):",null,null,null,{"$f":"'Capacity Planning'!G43","v":2.4500000000000001E-2}]
[]
[null,"Ideal planned cycle time (Seconds):",null,null,null,{"$f":"'Capacity Planning'!G47","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Calculated allocation % to meet demand (%):",null,null,null,{"$f":"'Capacity Planning'!G50","v":0.8036558139534884},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:R32)","v":0.8036558139534884}]
[]
[null,"Planned production per week (Parts):",null,null,null,{"$f":"IFERROR((((F22*F32)-F24))*(60/F30),\"-\")","v":2975.1479999999997},null,{"$f":"IFERROR((((H22*H32)-H24))*(60/H30),\"-\")","v":"-"},null,{"$f":"IFERROR((((J22*J32)-J24))*(60/J30),\"-\")","v":"-"},null,{"$f":"IFERROR((((L22*L32)-L24))*(60/L30),\"-\")","v":"-"},null,{"$f":"IFERROR((((N22*N32)-N24))*(60/N30),\"-\")","v":"-"},null,{"$f":"IFERROR((((P22*P32)-P24))*(60/P30),\"-\")","v":"-"},null,{"$f":"IFERROR((((R22*R32)-R24))*(60/R30),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(((R26*60)/R30)*R32,\"-\")","v":"-"}]

{"sheet":"Process 3 Shared Loading Plan","index":4,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,1,7,3],[7,12,7,15],[2,4,3,15],[3,18,3,19],[5,1,5,3],[5,4,5,11],[5,12,5,15],[9,12,9,15],[11,1,11,3],[11,4,11,11],[11,12,11,15],[15,1,15,4],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[17,1,17,4],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[19,15,19,16],[19,17,19,18],[21,1,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[19,1,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[23,15,23,16],[23,17,23,18],[25,1,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,17,25,18],[23,1,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[27,15,27,16],[27,17,27,18],[29,1,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[27,1,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[31,15,31,16],[31,17,31,18],[33,1,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,15,33,16],[33,17,33,18],[31,1,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14]]}
[]
[]
[null,null,null,null,"KSPQP - SHARED LOADING PLAN PROCESS 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date completed:",{"$f":"'Capacity Planning'!L3","v":"2023-11-08"}]
[]
[null,"Supplier Company Name:",null,null,{"$f":"'Capacity Planning'!E5:L5","v":"Example (A Company LTD)"},null,null,null,null,null,null,null,"Supplier Representative Name:",null,null,null,{"$f":"'Capacity Planning'!E12","v":"Example (A Person)"}]
[]
[null,"Supplier Address:",null,null,{"$f":"'Capacity Planning'!E7:L7","v":"Example (Stephenson Industrial Estate, Washington, Tyne and Wear, NE37 3HR)"},null,null,null,null,null,null,null,"Supplier Email Address:",null,null,null,{"$f":"'Capacity Planning'!E14","v":"Example (aperson@acompanyltd.com)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Representative Role:",null,null,null,{"$f":"'Capacity Planning'!J12","v":"Example (Capacity Planner)"}]
[]
[null,"Shared Process Name:",null,null,{"$f":"'Capacity Planning'!H27","v":"Example 3"},null,null,null,null,null,null,null,"Supplier Phone Number:",null,null,null,{"$f":"'Capacity Planning'!J14","v":"07700000000"}]
[]
[]
[]
[null,"Part Name:",null,null,null,{"$f":"'Capacity Planning'!E19","v":"Example (A part name)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Part Number:",null,null,null,{"$f":"'Capacity Planning'!J19","v":"Example (1234 KUK123)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Capacity Study Volume:",null,null,null,{"$f":"'Capacity Planning'!J21","v":2904}]
[]
[null,"Net Available Time for Process:",null,null,null,{"$f":"'Capacity Planning'!H33","v":6450}]
[]
[null,"Total planned downtime per week (Minutes):",null,null,null,{"$f":"'Capacity Planning'!H40","v":225}]
[]
[null,"Operation Time (Minutes):",null,null,null,{"$f":"F22-F24","v":6225},null,{"$f":"H22-H24","v":0},null,{"$f":"J22-J24","v":0},null,{"$f":"L22-L24","v":0},null,{"$f":"N22-N24","v":0},null,{"$f":"P22-P24","v":0},null,{"$f":"R22-R24","v":0}]
[]
[null,"Projected parts rejected and reworked (%):",null,null,null,{"$f":"'Capacity Planning'!H43","v":2.4500000000000001E-2}]
[]
[null,"Ideal planned cycle time (Seconds):",null,null,null,{"$f":"'Capacity Planning'!H47","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Calculated allocation % to meet demand (%):",null,null,null,{"$f":"'Capacity Planning'!H50","v":0.8036558139534884},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:R32)","v":0.8036558139534884}]
[]
[null,"Planned production per week (Parts):",null,null,null,{"$f":"IFERROR((((F22*F32)-F24))*(60/F30),\"-\")","v":2975.1479999999997},null,{"$f":"IFERROR((((H22*H32)-H24))*(60/H30),\"-\")","v":"-"},null,{"$f":"IFERROR((((J22*J32)-J24))*(60/J30),\"-\")","v":"-"},null,{"$f":"IFERROR((((L22*L32)-L24))*(60/L30),\"-\")","v":"-"},null,{"$f":"IFERROR((((N22*N32)-N24))*(60/N30),\"-\")","v":"-"},null,{"$f":"IFERROR((((P22*P32)-P24))*(60/P30),\"-\")","v":"-"},null,{"$f":"IFERROR((((R22*R32)-R24))*(60/R30),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(((R26*60)/R30)*R32,\"-\")","v":"-"}]

{"sheet":"Process 4 Shared Loading Plan","index":5,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":true,"merged":[[7,1,7,3],[7,12,7,15],[2,4,3,15],[3,18,3,19],[5,1,5,3],[5,4,5,11],[5,12,5,15],[9,12,9,15],[11,1,11,3],[11,4,11,11],[11,12,11,15],[15,1,15,4],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[17,1,17,4],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[19,15,19,16],[19,17,19,18],[21,1,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[19,1,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[23,15,23,16],[23,17,23,18],[25,1,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,17,25,18],[23,1,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[27,15,27,16],[27,17,27,18],[29,1,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[27,1,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[31,15,31,16],[31,17,31,18],[33,1,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,15,33,16],[33,17,33,18],[31,1,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14]]}
[]
[]
[null,null,null,null,"KSPQP - SHARED LOADING PLAN PROCESS 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date completed:",{"$f":"'Capacity Planning'!L3","v":"2023-11-08"}]
[]
[null,"Supplier Company Name:",null,null,{"$f":"'Capacity Planning'!E5:L5","v":"Example (A Company LTD)"},null,null,null,null,null,null,null,"Supplier Representative Name:",null,null,null,{"$f":"'Capacity Planning'!E12","v":"Example (A Person)"}]
[]
[null,"Supplier Address:",null,null,{"$f":"'Capacity Planning'!E7:L7","v":"Example (Stephenson Industrial Estate, Washington, Tyne and Wear, NE37 3HR)"},null,null,null,null,null,null,null,"Supplier Email Address:",null,null,null,{"$f":"'Capacity Planning'!E14","v":"Example (aperson@acompanyltd.com)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Representative Role:",null,null,null,{"$f":"'Capacity Planning'!J12","v":"Example (Capacity Planner)"}]
[]
[null,"Shared Process Name:",null,null,{"$f":"'Capacity Planning'!I27","v":"Example 4"},null,null,null,null,null,null,null,"Supplier Phone Number:",null,null,null,{"$f":"'Capacity Planning'!J14","v":"07700000000"}]
[]
[]
[]
[null,"Part Name:",null,null,null,{"$f":"'Capacity Planning'!E19","v":"Example (A part name)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Part Number:",null,null,null,{"$f":"'Capacity Planning'!J19","v":"Example (1234 KUK123)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Capacity Study Volume:",null,null,null,{"$f":"'Capacity Planning'!J21","v":2904}]
[]
[null,"Net Available Time for Process:",null,null,null,{"$f":"'Capacity Planning'!I33","v":0}]
[]
[null,"Total planned downtime per week (Minutes):",null,null,null,{"$f":"'Capacity Planning'!I40","v":0}]
[]
[null,"Operation Time (Minutes):",null,null,null,{"$f":"F22-F24","v":0},null,{"$f":"H22-H24","v":0},null,{"$f":"J22-J24","v":0},null,{"$f":"L22-L24","v":0},null,{"$f":"N22-N24","v":0},null,{"$f":"P22-P24","v":0},null,{"$f":"R22-R24","v":0}]
[]
[null,"Projected parts rejected and reworked (%):",null,null,null,{"$f":"'Capacity Planning'!I43","v":0}]
[]
[null,"Ideal planned cycle time (Seconds):",null,null,null,{"$f":"'Capacity Planning'!I47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Calculated allocation % to meet demand (%):",null,null,null,{"$f":"'Capacity Planning'!I50","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:R32)","v":0}]
[]
[null,"Planned production per week (Parts):",null,null,null,{"$f":"IFERROR((((F22*F32)-F24))*(60/F30),\"-\")","v":"-"},null,{"$f":"IFERROR((((H22*H32)-H24))*(60/H30),\"-\")","v":"-"},null,{"$f":"IFERROR((((J22*J32)-J24))*(60/J30),\"-\")","v":"-"},null,{"$f":"IFERROR((((L22*L32)-L24))*(60/L30),\"-\")","v":"-"},null,{"$f":"IFERROR((((N22*N32)-N24))*(60/N30),\"-\")","v":"-"},null,{"$f":"IFERROR((((P22*P32)-P24))*(60/P30),\"-\")","v":"-"},null,{"$f":"IFERROR((((R22*R32)-R24))*(60/R30),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(((R26*60)/R30)*R32,\"-\")","v":"-"}]

{"sheet":"Process 5 Shared Loading Plan","index":6,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":true,"merged":[[7,1,7,3],[7,12,7,15],[2,4,3,15],[3,18,3,19],[5,1,5,3],[5,4,5,11],[5,12,5,15],[9,12,9,15],[11,1,11,3],[11,4,11,11],[11,12,11,15],[15,1,15,4],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[17,1,17,4],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[19,15,19,16],[19,17,19,18],[21,1,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[19,1,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[23,15,23,16],[23,17,23,18],[25,1,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,17,25,18],[23,1,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[27,15,27,16],[27,17,27,18],[29,1,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[27,1,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[31,15,31,16],[31,17,31,18],[33,1,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,15,33,16],[33,17,33,18],[31,1,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14]]}
[]
[]
[null,null,null,null,"KSPQP - SHARED LOADING PLAN PROCESS 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date completed:",{"$f":"'Capacity Planning'!L3","v":"2023-11-08"}]
[]
[null,"Supplier Company Name:",null,null,{"$f":"'Capacity Planning'!E5:L5","v":"Example (A Company LTD)"},null,null,null,null,null,null,null,"Supplier Representative Name:",null,null,null,{"$f":"'Capacity Planning'!E12","v":"Example (A Person)"}]
[]
[null,"Supplier Address:",null,null,{"$f":"'Capacity Planning'!E7:L7","v":"Example (Stephenson Industrial Estate, Washington, Tyne and Wear, NE37 3HR)"},null,null,null,null,null,null,null,"Supplier Email Address:",null,null,null,{"$f":"'Capacity Planning'!E14","v":"Example (aperson@acompanyltd.com)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Representative Role:",null,null,null,{"$f":"'Capacity Planning'!J12","v":"Example (Capacity Planner)"}]
[]
[null,"Shared Process Name:",null,null,{"$f":"'Capacity Planning'!J27","v":"Example 5"},null,null,null,null,null,null,null,"Supplier Phone Number:",null,null,null,{"$f":"'Capacity Planning'!J14","v":"07700000000"}]
[]
[]
[]
[null,"Part Name:",null,null,null,{"$f":"'Capacity Planning'!E19","v":"Example (A part name)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Part Number:",null,null,null,{"$f":"'Capacity Planning'!J19","v":"Example (1234 KUK123)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Capacity Study Volume:",null,null,null,{"$f":"'Capacity Planning'!J21","v":2904}]
[]
[null,"Net Available Time for Process:",null,null,null,{"$f":"'Capacity Planning'!J33","v":0}]
[]
[null,"Total planned downtime per week (Minutes):",null,null,null,{"$f":"'Capacity Planning'!J40","v":0}]
[]
[null,"Operation Time (Minutes):",null,null,null,{"$f":"F22-F24","v":0},null,{"$f":"H22-H24","v":0},null,{"$f":"J22-J24","v":0},null,{"$f":"L22-L24","v":0},null,{"$f":"N22-N24","v":0},null,{"$f":"P22-P24","v":0},null,{"$f":"R22-R24","v":0}]
[]
[null,"Projected parts rejected and reworked (%):",null,null,null,{"$f":"'Capacity Planning'!J43","v":0}]
[]
[null,"Ideal planned cycle time (Seconds):",null,null,null,{"$f":"'Capacity Planning'!J47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Calculated allocation % to meet demand (%):",null,null,null,{"$f":"'Capacity Planning'!J50","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:R32)","v":0}]
[]
[null,"Planned production per week (Parts):",null,null,null,{"$f":"IFERROR((((F22*F32)-F24))*(60/F30),\"-\")","v":"-"},null,{"$f":"IFERROR((((H22*H32)-H24))*(60/H30),\"-\")","v":"-"},null,{"$f":"IFERROR((((J22*J32)-J24))*(60/J30),\"-\")","v":"-"},null,{"$f":"IFERROR((((L22*L32)-L24))*(60/L30),\"-\")","v":"-"},null,{"$f":"IFERROR((((N22*N32)-N24))*(60/N30),\"-\")","v":"-"},null,{"$f":"IFERROR((((P22*P32)-P24))*(60/P30),\"-\")","v":"-"},null,{"$f":"IFERROR((((R22*R32)-R24))*(60/R30),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(((R26*60)/R30)*R32,\"-\")","v":"-"}]

{"sheet":"Process 6 Shared Loading Plan","index":7,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":true,"merged":[[7,1,7,3],[7,12,7,15],[2,4,3,15],[3,18,3,19],[5,1,5,3],[5,4,5,11],[5,12,5,15],[9,12,9,15],[11,1,11,3],[11,4,11,11],[11,12,11,15],[15,1,15,4],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[17,1,17,4],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[19,15,19,16],[19,17,19,18],[21,1,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[19,1,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[23,15,23,16],[23,17,23,18],[25,1,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,17,25,18],[23,1,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[27,15,27,16],[27,17,27,18],[29,1,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[27,1,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[31,15,31,16],[31,17,31,18],[33,1,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,15,33,16],[33,17,33,18],[31,1,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14]]}
[]
[]
[null,null,null,null,"KSPQP - SHARED LOADING PLAN PROCESS 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date completed:",{"$f":"'Capacity Planning'!L3","v":"2023-11-08"}]
[]
[null,"Supplier Company Name:",null,null,{"$f":"'Capacity Planning'!E5:L5","v":"Example (A Company LTD)"},null,null,null,null,null,null,null,"Supplier Representative Name:",null,null,null,{"$f":"'Capacity Planning'!E12","v":"Example (A Person)"}]
[]
[null,"Supplier Address:",null,null,{"$f":"'Capacity Planning'!E7:L7","v":"Example (Stephenson Industrial Estate, Washington, Tyne and Wear, NE37 3HR)"},null,null,null,null,null,null,null,"Supplier Email Address:",null,null,null,{"$f":"'Capacity Planning'!E14","v":"Example (aperson@acompanyltd.com)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Representative Role:",null,null,null,{"$f":"'Capacity Planning'!J12","v":"Example (Capacity Planner)"}]
[]
[null,"Shared Process Name:",null,null,{"$f":"'Capacity Planning'!K27","v":"Example 6"},null,null,null,null,null,null,null,"Supplier Phone Number:",null,null,null,{"$f":"'Capacity Planning'!J14","v":"07700000000"}]
[]
[]
[]
[null,"Part Name:",null,null,null,{"$f":"'Capacity Planning'!E19","v":"Example (A part name)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Part Number:",null,null,null,{"$f":"'Capacity Planning'!J19","v":"Example (1234 KUK123)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Capacity Study Volume:",null,null,null,{"$f":"'Capacity Planning'!J21","v":2904}]
[]
[null,"Net Available Time for Process:",null,null,null,{"$f":"'Capacity Planning'!K33","v":0}]
[]
[null,"Total planned downtime per week (Minutes):",null,null,null,{"$f":"'Capacity Planning'!K40","v":0}]
[]
[null,"Operation Time (Minutes):",null,null,null,{"$f":"F22-F24","v":0},null,{"$f":"H22-H24","v":0},null,{"$f":"J22-J24","v":0},null,{"$f":"L22-L24","v":0},null,{"$f":"N22-N24","v":0},null,{"$f":"P22-P24","v":0},null,{"$f":"R22-R24","v":0}]
[]
[null,"Projected parts rejected and reworked (%):",null,null,null,{"$f":"'Capacity Planning'!K43","v":0}]
[]
[null,"Ideal planned cycle time (Seconds):",null,null,null,{"$f":"'Capacity Planning'!K47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Calculated allocation % to meet demand (%):",null,null,null,{"$f":"'Capacity Planning'!K50","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:R32)","v":0}]
[]
[null,"Planned production per week (Parts):",null,null,null,{"$f":"IFERROR((((F22*F32)-F24))*(60/F30),\"-\")","v":"-"},null,{"$f":"IFERROR((((H22*H32)-H24))*(60/H30),\"-\")","v":"-"},null,{"$f":"IFERROR((((J22*J32)-J24))*(60/J30),\"-\")","v":"-"},null,{"$f":"IFERROR((((L22*L32)-L24))*(60/L30),\"-\")","v":"-"},null,{"$f":"IFERROR((((N22*N32)-N24))*(60/N30),\"-\")","v":"-"},null,{"$f":"IFERROR((((P22*P32)-P24))*(60/P30),\"-\")","v":"-"},null,{"$f":"IFERROR((((R22*R32)-R24))*(60/R30),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(((R26*60)/R30)*R32,\"-\")","v":"-"}]

{"sheet":"Process 7 Shared Loading Plan","index":8,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":true,"merged":[[7,1,7,3],[7,12,7,15],[2,4,3,15],[3,18,3,19],[5,1,5,3],[5,4,5,11],[5,12,5,15],[9,12,9,15],[11,1,11,3],[11,4,11,11],[11,12,11,15],[15,1,15,4],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[17,1,17,4],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[19,15,19,16],[19,17,19,18],[21,1,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[19,1,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[23,15,23,16],[23,17,23,18],[25,1,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,17,25,18],[23,1,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[27,15,27,16],[27,17,27,18],[29,1,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[27,1,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[31,15,31,16],[31,17,31,18],[33,1,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,15,33,16],[33,17,33,18],[31,1,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14]]}
[]
[]
[null,null,null,null,"KSPQP - SHARED LOADING PLAN PROCESS 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date completed:",{"$f":"'Capacity Planning'!L3","v":"2023-11-08"}]
[]
[null,"Supplier Company Name:",null,null,{"$f":"'Capacity Planning'!E5:L5","v":"Example (A Company LTD)"},null,null,null,null,null,null,null,"Supplier Representative Name:",null,null,null,{"$f":"'Capacity Planning'!E12","v":"Example (A Person)"}]
[]
[null,"Supplier Address:",null,null,{"$f":"'Capacity Planning'!E7:L7","v":"Example (Stephenson Industrial Estate, Washington, Tyne and Wear, NE37 3HR)"},null,null,null,null,null,null,null,"Supplier Email Address:",null,null,null,{"$f":"'Capacity Planning'!E14","v":"Example (aperson@acompanyltd.com)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Representative Role:",null,null,null,{"$f":"'Capacity Planning'!J12","v":"Example (Capacity Planner)"}]
[]
[null,"Shared Process Name:",null,null,{"$f":"'Capacity Planning'!L27","v":"Example 7"},null,null,null,null,null,null,null,"Supplier Phone Number:",null,null,null,{"$f":"'Capacity Planning'!J14","v":"07700000000"}]
[]
[]
[]
[null,"Part Name:",null,null,null,{"$f":"'Capacity Planning'!E19","v":"Example (A part name)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Part Number:",null,null,null,{"$f":"'Capacity Planning'!J19","v":"Example (1234 KUK123)"},null,null,null,null,null,null,null,null,null,null,null,"Other Customer Parts"]
[]
[null,"Capacity Study Volume:",null,null,null,{"$f":"'Capacity Planning'!J21","v":2904}]
[]
[null,"Net Available Time for Process:",null,null,null,{"$f":"'Capacity Planning'!L33","v":0}]
[]
[null,"Total planned downtime per week (Minutes):",null,null,null,{"$f":"'Capacity Planning'!L40","v":0}]
[]
[null,"Operation Time (Minutes):",null,null,null,{"$f":"F22-F24","v":0},null,{"$f":"H22-H24","v":0},null,{"$f":"J22-J24","v":0},null,{"$f":"L22-L24","v":0},null,{"$f":"N22-N24","v":0},null,{"$f":"P22-P24","v":0},null,{"$f":"R22-R24","v":0}]
[]
[null,"Projected parts rejected and reworked (%):",null,null,null,{"$f":"'Capacity Planning'!L43","v":0}]
[]
[null,"Ideal planned cycle time (Seconds):",null,null,null,{"$f":"'Capacity Planning'!L47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Calculated allocation % to meet demand (%):",null,null,null,{"$f":"'Capacity Planning'!L50","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:R32)","v":0}]
[]
[null,"Planned production per week (Parts):",null,null,null,{"$f":"IFERROR((((F22*F32)-F24))*(60/F30),\"-\")","v":"-"},null,{"$f":"IFERROR((((H22*H32)-H24))*(60/H30),\"-\")","v":"-"},null,{"$f":"IFERROR((((J22*J32)-J24))*(60/J30),\"-\")","v":"-"},null,{"$f":"IFERROR((((L22*L32)-L24))*(60/L30),\"-\")","v":"-"},null,{"$f":"IFERROR((((N22*N32)-N24))*(60/N30),\"-\")","v":"-"},null,{"$f":"IFERROR((((P22*P32)-P24))*(60/P30),\"-\")","v":"-"},null,{"$f":"IFERROR((((R22*R32)-R24))*(60/R30),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(((R26*60)/R30)*R32,\"-\")","v":"-"}]