{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Organizational Data","QA System Survey","Scores","Summary","Supplier Rating Calculator","SRS algorithm"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":16,"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":"Organizational Data","index":0,"n_rows":73,"n_cols":17,"rows_kept":73,"cut":false,"hidden":false,"merged":[[20,0,20,1],[20,4,20,5],[66,0,66,5],[46,0,46,5],[48,4,48,5],[49,4,49,5],[59,0,59,5],[53,0,53,5],[54,0,54,5],[55,0,55,5],[56,0,56,5],[57,0,57,5],[58,0,58,5],[62,0,62,5],[63,0,63,5],[64,0,64,5],[0,0,0,1],[0,2,0,3],[0,4,0,5],[29,0,29,5],[31,0,31,5],[18,0,18,5],[2,1,2,5],[1,1,1,5],[16,0,16,2],[16,3,16,5],[17,2,17,4],[4,1,4,5],[3,1,3,5],[15,0,15,5],[5,4,5,5],[30,0,30,5],[71,1,71,2],[72,1,72,2],[60,0,60,5],[35,0,35,5],[36,0,36,5],[37,0,37,5],[38,0,38,5],[41,0,41,5],[65,0,65,5],[61,0,61,5],[9,0,9,5],[70,3,70,4],[68,0,68,1],[69,1,69,2],[70,1,70,2],[33,0,33,5],[34,0,34,5],[24,0,24,5],[25,0,25,5],[26,0,26,5],[27,0,27,5],[28,0,28,5],[32,0,32,5],[21,0,21,1],[21,4,21,5],[19,0,19,1]]}
["SUPPLIER INFORMATION",null,"(Please complete and return to):",null,"MTC Engineering",null,null,"Company","Address","State","Phone","Fax","Email","Web","Cage","Logo","<-Company Select Drop-Down List"]
["Supplier Name:",null,null,null,null,null,null,"MTC Engineering","747 Carle Ave.","Lewis Center, OH 43035","614-657-8666","614-540-7442","mtcengineering@att.net","www.mtcengco.com","3BTS1","Picture 1"]
["Street Address:",null,null,null,null,null,null,"Industrial Welding & Engineering","747 Carle Ave.","Lewis Center, OH 43035","614-883-6109","614-737-9320","iwe@columbus.rr.com","www.iweohio.com","3NBK9","Picture2"]
[null,null,null,null,null,null,null,"MTC Engineering, LLC","747 Carle Ave.","Lewis Center, OH 43035","614-657-8666","614-540-7442","mtcengllc@att.net","www.mtcengco.com","5TVD6","Picture 1"]
["City & State:",null,null,null,null,null,null,"Lewis Center Mfg.","747 Carle Ave.","Lewis Center, OH 43035","614-560-6122","614-737-9320","Lewiscentermfg@gmail.com",null,"6QCA7"]
["Phone No.:",null,null,"Fax No.:",null,null,null,"Fourply Design House","747 Carle Ave.","Lewis Center, OH 43035","910-381-3110","614-737-9320","Njsanna@fourplydesign.com","www.fourplydesign.com","6Q2Z8"]
["Supplier Classification:",null,null,null,null,"CAGE",null,"Alannas Engineer","9710-A Owensmouth Ave.","Chatsworth, CA 91311","818-701-1522","818-701-0316","alannasengineer@yahoo.com",null,"5KBD7","Picture4"]
[null,null,null,null,null,null,null,"A. D.J. Finishing, Inc.","7845 Gloria Ave.","Van Nuys, CA 91406","818-786-5131","818-786-6165","adjfinishing@hotmail.com","www.adjfinishing.com","6NVY2","Picture6"]
[null,null,null,null,null,null,null,"RC Industries, Inc.","7755 Alabama Ave., Ste 6/8","Canoga Park, CA 91304","818-883-0855","818-883-2537","rcind@sbcglobal.net",null,"6CH54","Picture8"]
["SUPPLIER KEY CONTRACT DATA",null,null,null,null,null,null,"Westerville Mfg","771-P Dearborn Park Ln","Worthington, OH 43085","614-888-9088","614-888-9188","wmfginc@sbcglobal.net","www.wmfginc.com","7Y162","Picture5"]
["Contact Name:","Tony Casillas",null,"Title:",null,null,null,"LCG Machine & Tool","2923 Grasemere Ave.","Columbus, OH 43224","614-261-1651","614-447-8051","sales@lcgmachine.com","www.lcgmachine.com","4HYL7","Picture3"]
["Contact Name:",null,null,"Title:",null,null,null,"Boehm Machine","1297 Memory Lane, N","Columbus, OH 43209","614-252-3778","614-237-5262","gkboehm@wideopenwest.com",null,"1P723","Picture7"]
["Contact Name:",null,null,"Title:"]
[]
[]
["SUPPLIER QUALITY SYSTEM INFORMATION"]
["Does your company have and maintain an established quality system?"]
[null,"If yes, to which standard?"]
["*NOTE: Pages 3 and 4 need not be filled out if your system has a certification. Attach copy of your certification with this letter."]
[]
[null,null,null,"Certification Body:"]
[null,null,null,"Last Audit Date:"]
[]
[]
["SUPPLIER COMMENTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note:  Use additional sheets if needed to complete all comments."]
[]
["SURVEY COMPLETION"]
["Completed By:",null,null,"Title:"]
["Email:",null,null,"Date:"]
[]
[]
[{"$f":"UPPER(Customer&\"  ASSESSMENT SUMMARY\")","v":"MTC ENGINEERING  ASSESSMENT SUMMARY"}]
[]
["Reviewed By:",null,null,"Risk Assessment:","        Risk Performance Level"]
["Title:"]
["Date:"]
[]
[]
["INTERVIEWERS CLOSING COMMENTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Please return complete to the following address:"]
[null,{"$f":"VLOOKUP(Customer, CompanyTable, 1, FALSE)","v":"MTC Engineering"},null,"Cage Code:",{"$f":"VLOOKUP(Customer, CompanyTable, 8, FALSE)","v":"3BTS1"}]
[null,"Attn: QA Manager",null,{"$f":"VLOOKUP(Customer, CompanyTable, 6, FALSE)","v":"mtcengineering@att.net"}]
[null,{"$f":"VLOOKUP(Customer, CompanyTable, 2, FALSE)","v":"747 Carle Ave."},null,{"$f":"VLOOKUP(Customer, CompanyTable, 4, FALSE)&\" PH\"","v":"614-657-8666 PH"},{"$f":"VLOOKUP(Customer, CompanyTable, 5, FALSE)&\" Fax\"","v":"614-540-7442 Fax"}]
[null,{"$f":"VLOOKUP(Customer, CompanyTable, 3, FALSE)","v":"Lewis Center, OH 43035"}]

{"sheet":"QA System Survey","index":1,"n_rows":72,"n_cols":5,"rows_kept":72,"cut":false,"hidden":false,"merged":[[37,0,37,1],[43,0,43,1],[48,0,48,1],[53,0,53,1],[57,0,57,1],[32,0,32,1],[7,0,7,1],[11,0,11,1],[15,0,15,1],[21,0,21,1],[26,0,26,1]]}
["1.0 General Requirements","Yes/No/NA"]
["Do you have a documented and maintained quality management system?",null,null,"Yes","<--Answer Drop-Down List"]
["Are all the relevant elements of this survey included in the quality system documentation?",null,null,"No"]
["2.0 Documentation Requirements",null,null,"N/A"]
["Does Organization have documented statements of a quality policy and quality objectives?"]
["Does the quality manual outline the documentation structure of the quality management system?"]
["Is there a procedure defining quality records and retention period?"]
[]
["3.0 Management Commitment"]
["Does top management conduct management reviews?"]
["Does top management ensure that customer requirements are determined and met?"]
[]
["4.0 Management Planning, Responsibility and Review"]
["Is an organizational chart of the company available?"]
["Is the responsibility, authority, organizational freedom and interfaces of personnel who manage, perform and verify work affecting quality defined and documented?"]
[]
["5.0 Resource Management"]
["Do documented training requirements exist for everyone affecting quality? "]
["Are qualification and training records maintained for personnel?"]
["Are the buildings, workspace, and utilities appropriate to meet product requirements? "]
["Is there a preventative maintenance program machines and processes?"]
[]
["6.0 Customer-Related Processes"]
["Are reviews conducted to ensure that the organization has the ability to meet requirements before committing to supply product?"]
["Does the quality management system define how relevant documents are changed and relevant personnel are made aware of the changes when product requirements change?"]
["Are changes to the accepted order properly documented and reviewed?"]
[]
["7.0 Design Control "]
["Do all design changes require review and approval?"]
["Do you have a plan/system for assessing risk?"]
["Are design reviews held with a cross-functional team and records of the results of the reviews and any required actions maintained?"]
["Is there drawing and specification control?"]
[]
["8.0 Purchasing Process"]
["Are there documented procedures to ensure that purchased product conforms to specified requirements?"]
["Do you formally evaluate/re-evaluate and select suppliers?  "]
["Do the inspection documents contain the necessary requirements? Such as quality characteristics, acceptance/rejection criteria, inspection records and inspection equipment? "]
[]
["9.0 Control of Production and Service Provision"]
["Are production procedures documented?"]
["Is suitable equipment used for carrying out production?"]
["Are final inspections and testing performed in accordance with documented procedures?"]
["Are packaging and labeling operations defined and implemented?"]
[]
["10.0 Identification and Traceability"]
["Do you identify product throughout your processes (production, storage, segregation areas, etc.)?"]
["Are in-process and rejected items adequately identified and/or segregated to prevent mix-ups?"]
["Is product inspection status identified (in production, storage, segregation areas, etc.)?"]
[]
["11.0 Property and Preservation of Product"]
["Do you ensure that property is identified, verified, protected, and safeguarded?"]
["Is there a procedure to account for customer-supplied material rejected due to yield loss during the manufacturing process?"]
["Is there a procedure for the control of product with a limited shelf life or requiring special storage?"]
[]
["12.0 Control of Monitoring and Measuring Devices"]
["Is measuring and test equipment calibrated or verified at proper frequencies in accordance with NIST traceable standards and is this procedure documented?  "]
["Do you maintain calibration records for inspection, measuring and test equipment"]
[]
["13.0 Monitoring and Measurement"]
["Are procedures and responsibilities defined for the performance of in process inspection?"]
["Do you ensure that product is not released until the all requirements have been met? "]
["Are internal audits being conducted at planned intervals?  "]
["Is there a documented procedure that ensures actions are taken to eliminate detected nonconformities and their causes?"]
["14.0 Control of Non-Conforming Product"]
["Do you ensure that nonconforming products are identified and controlled to prevent unintended use or delivery?"]
["Do you maintain a returned goods procedure?"]
["Is there a documented procedure for dispositioning nonconforming product?"]
["Is there a documented customer complaint system?"]
["15.0 Corrective and Preventative Action"]
["Is there a documented procedure to review non-conformities, determine root cause, determine and implement action needed and to review the corrective action and determine effectiveness?"]
["Do you determine potential nonconformities to take action on?"]
[{"$f":"Supplier_Name&\" - \"&Supplier_Address&\", \"&Supplier_State&\" - (\"&Supplier_Phone&\")\"","v":" - ,  - ()"}]

{"sheet":"Scores","index":2,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":true,"merged":[[12,2,12,3],[13,2,13,3],[14,2,14,3],[0,1,0,2],[9,2,9,3],[10,2,10,3],[11,2,11,3],[0,4,0,6],[3,2,3,3],[52,4,52,5],[3,0,11,1],[12,0,17,1],[18,0,19,1],[7,2,7,3],[6,2,6,3],[5,2,5,3],[4,2,4,3],[8,2,8,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[22,0,29,1],[29,2,29,3],[35,2,35,3],[30,0,35,1],[38,0,44,1],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[44,2,44,3],[52,0,52,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[51,2,51,3],[47,0,51,1],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3]]}
["Supplier:",{"$f":"Supplier_Name","v":0},null,"Rating Period End Date:","00:00:00",null,null,"<---Enter Date of Survey here."]
[]
["Quality (35 points)",null,null,null,"Points"]
["PPM Commodity Performance",null,"75%  to  100%",null,25,"Score:"]
[null,null,"50%  to  74%",null,22]
[null,null,"25%  to  49%",null,20]
[null,null,"0%  to   24%",null,15]
[null,null,"-1%  to  -24%",null,10]
[null,null,"-25%  to -49%",null,8]
[null,null,"-50%  to -74%",null,5]
[null,null,"-75%  to  -100%",null,3]
[null,null,"> -100%",null,0]
["6 Month PPM Performance",null,"0 PPM - 100 PPM",null,5,"Score:"]
[null,null,"101 PPM     to    250 PPM",null,4]
[null,null,"251 PPM     to    500 PPM",null,3]
[null,null,"501 PPM    to     1000 PPM",null,2]
[null,null,"1001 PPM     to     1500 PPM",null,1]
[null,null,"1501 PPM or higher",null,0]
["Quality System",null,"ISO 9001:2000 Certified. Attach copy of latest certificate.",null,5,"Score:"]
[null,null,"Other Certified QMS (5). NOTE:",null,0]
[]
["Delivery (20 points)"]
["PPM Commodity Performance",null,"75%  to  100%",null,15,"Score:"]
[null,null,"50%  to  74%",null,12]
[null,null,"25%  to  49%",null,10]
[null,null,"0%  to   24%",null,8]
[null,null,"-1%  to  -24%",null,6]
[null,null,"-25%  to -49%",null,4]
[null,null,"-50%  to -74%",null,2]
[null,null,"-75%  to  -100%",null,0]
["6 Month PPM Performance",null,"0 - 1000 PPM",null,5,"Score:"]
[null,null,"1001 - 2500 PPM",null,4]
[null,null,"2501 - 5000 PPM",null,3]
[null,null,"5001 - 7500 PPM",null,2]
[null,null,"7501 - 10,000 PPM",null,1]
[null,null,"> 10,000 PPM",null,0]
[]
["Commercial (35 points)"]
["Cost Reduction",null,"5% or greater",null,35,"Score:"]
[null,null,"4.0% - 4.9%",null,30]
[null,null,"3% - 3.9%",null,25]
[null,null,"2% - 2.9%",null,20]
[null,null,"1% - 1.9%",null,15]
[null,null,".1% - .9%",null,10]
[null,null,0,null,0]
[]
["Service (10 points)"]
["Responsiveness",null,"Supplier is consistently communicates proactively about issues that could impact Shape.  Requests for information are always accurate and on time (PPAPs, CARs, RFQs).",null,10,"Score:"]
[null,null,"Supplier is usually proactive with communication. Requests for information are typically complete and on time.",null,8]
[null,null,"Supplier is not consistently proactive with communication.  Requests for information are intermittently complete and on time.",null,5]
[null,null,"Supplier does not proactively communicate to Shape about issues.  Requests for information are typically incomplete and late.",null,2]
[null,null,"Supplier does not demonstrate customer service as a priority.  Communication and information requests are a significant issue.",null,0]
[{"$f":"Supplier_Name&\" - \"&Supplier_Address&\", \"&Supplier_State&\" - (\"&Supplier_Phone&\")\"","v":" - ,  - ()"},null,null,null,"TOTAL SCORE:",null,{"$f":"G48+G39+G31+G23+G19+G13+G4","v":0}]

{"sheet":"Summary","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[29,1,29,4],[30,1,30,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[18,3,18,4],[25,1,25,4],[14,3,14,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[35,1,35,4],[36,1,36,4]]}
[null,"Supplier:",{"$f":"Supplier_Name","v":0},null,{"$f":"VLOOKUP(Customer, CompanyTable, 1, FALSE)","v":"MTC Engineering"}]
[null,"Rating Period Start:",{"$f":"Rating_Period_End-180","v":-180},null,"Attn: QA Manager"]
[null,"Rating Period End:",{"$f":"Rating_Period_End","v":"00:00:00"},null,{"$f":"VLOOKUP(Customer, CompanyTable, 2, FALSE)","v":"747 Carle Ave."}]
[null,"Cage Code:",{"$f":"Supplier_Cage","v":0},null,{"$f":"VLOOKUP(Customer, CompanyTable, 3, FALSE)","v":"Lewis Center, OH 43035"}]
[null,null,null,null,{"$f":"VLOOKUP(Customer, CompanyTable, 6, FALSE)","v":"mtcengineering@att.net"}]
[]
[null,"Section","Total Points Available","Points Earned"]
[null,"Quality",35,{"$f":"Scores!G4+Scores!G13+Scores!G19","v":0}]
[null,"Delivery",20,{"$f":"Scores!G23+Scores!G31","v":0}]
[null,"Commercial",35,{"$f":"Scores!G39","v":0}]
[null,"Service",10,{"$f":"Scores!G48","v":0}]
[null,null,{"$f":"SUM(C8:C11)","v":100},{"$f":"SUM(D8:D11)","v":0}]
[]
[null,"Supplier Performance Levels"]
[null,"Level ","Score Range","Description"]
[null,"Level One","80 - 100","Shape will seek out areas to grow with supplier.  Supplier has opportunity to quote all new opportunities within capability."]
[null,"Level Two","70 - 79","Supplier in good standing with Shape.  Potential for growth opportunities."]
[null,"Level Three","60 - 69","Performance improvement needed.  Limited opportunity for growth with Shape."]
[null,"Level Four","< 60","Improvement required to sustain current business."]
[]
[null,"Summary Comments"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NOTE: File in ASL with Supplier Data Sheet"]
[null,{"$f":"Supplier_Name&\" - \"&Supplier_Address&\", \"&Supplier_State&\" - (PH: \"&Supplier_Phone&\" / FX: \"&Supplier_Fax&\")\"","v":" - ,  - (PH:  / FX: )"}]

{"sheet":"Supplier Rating Calculator","index":4,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":true,"merged":[[14,1,14,6],[15,1,15,6],[16,1,16,6],[10,1,10,6],[12,1,13,1],[12,2,13,2],[12,5,12,6],[12,7,13,7],[13,5,13,6],[4,8,5,8],[6,2,7,2],[6,5,6,6],[6,7,7,7],[6,8,7,8],[7,5,7,6],[0,1,0,7],[2,1,2,2],[3,1,3,6],[4,1,9,1],[4,2,5,2],[4,7,5,7],[8,2,9,2],[8,3,8,4],[8,5,8,6],[8,7,9,7],[9,3,9,4],[9,5,9,6]]}
[null,"SUPPLIER RATING SYSTEM QUANTITATIVE RATING CALCULATOR"]
[]
[null,"Fill in Yellow fields with your values"]
[null,null,null,null,null,null,null,"Element Score"," "]
[null,"Quality Rating Elements","PPM","Total Failures (Past 12 months)","Total Parts Received (Past 12 months)","Calculated PPM","Calculated Process Sigma Score",{"$f":"G6*D22","v":0}," "]
[null,null,null,1,1,{"$f":"IF(D6 = 0,0,D6/E6*1000000)","v":1000000},{"$f":"IF(D6=0,1,IF(F6>500000,0,0.8406+SQRT(29.37-2.221*(LN(F6))))/6.03001)","v":0}]
[null,null,"LAR","Lots Accepted (Past 12 months)","Total Lots Received (Past 12 months)","Calculated LAR",null,{"$f":"F8*D23","v":0.27300000000000002}," "]
[null,null,null,1,1,{"$f":"D8/E8","v":1}]
[null,null,"Quantity Supplier Corrective Action Requests (SCAR)","Number of SCARs dispositioned as \"punitive\" over the last 12 months",null,"Calculated SCAR Score",null,{"$f":"F10*D24","v":0.12012}," "]
[null,null,null,1,null,{"$f":"IF(D10=0,1,IF(D10=1,0.66,IF(D10=2,0.33,0)))","v":0.66},null,null," "]
[null,"Quality Rating = ",null,null,null,null,null,{"$f":"SUM(H5:H9)","v":0.39312000000000002}," "]
[]
[null,"Delivery Rating Elements","On-time delivery rating","12 month delivery rating sum","Total Lots received past 12 months","Calculated Delivery Rating",null,{"$f":"F14*D27","v":1}]
[null,null,null,1,1,{"$f":"D14/E14","v":1},null,null," "]
[null,"  Delivery Rating = ",null,null,null,null,null,{"$f":"H13","v":1}]
[null,"Quantitative Rating = ",null,null,null,null,null,{"$f":"0.6*H11+0.4*H15","v":0.63587199999999999}," "]
[null,"Supplier Performance Index Multiplier =",null,null,null,null,null,{"$f":"1/H16","v":1.5726435509033265}," "]
[]
[null,null,"Scoring elements and their weights"]
[]
[null,"Quality",0.6]
[null,null,"     Source, Incoming, Floor failures",0.54500000000000004]
[null,null,"     Incoming lot Acceptance",0.27300000000000002]
[null,null,"     SCAR",0.182]
[null,null,null," "," "]
[null,"Delivery",0.4]
[null,null,"     On-time Delivery Rating",1]

{"sheet":"SRS algorithm","index":5,"n_rows":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["Supplier Rating System (SRS) Algorithm"]
[]
["Let:"]
["1. R = SRS Quantitative Rating"]
["2. QR = SRS Quality Rating"]
["3. DR = SRS Delivery Rating"]
["4. PSS = Process Sigma Score"]
["5. SCAR = SCAR Score"]
["6. RS = Receipt score for an individual lot received"]
["7. TL = Total number of lots received over the past 12 months"]
["8. PPM = Parts Per Million"]
["9. LAR = Lot Acceptance Rate"]
[]
["Supplier ratings are calculated as follows:"]
[]
["R = 0.60 * (QR) + 0.40 * (DR)",null,"EXAMPLE"]
[]
["QR = 0.545 * (PSS) + 0.273 * (LAR) + (SCAR)"]
[]
[]
[]
[]
[]
[]
["If calculated PPM ³ > 500,000:","PSS = 0     "]
[]
[]
["If calculated PPM < 500,000:"]
[]
[]
[]
[]
[]
[]
[]
["SCAR = 0.182 if 0 non-responses to a SCAR during past 12 months"]
["SCAR = 0.12 if 1 non-response to a SCAR during past 12 months"]
["SCAR = 0.06 if 2 non-responses to a SCAR during past 12 months"]
["SCAR = 0.00 if > 2 non-responses to a SCAR during past 12 months"]
[]
[]
[]
[]
["; for n lots received over the last 12 months"]
[]
[]
[]
[]
["For an individual receipt, RS is equal to the following:"]
["RS = 1.00 if shipment received 5 days early to 0 days late, "]
["RS = 1.00 if early shipment indicator is set to Y and shipment received infinite days early to 0 days late"]
["RS = 0.80 if early shipment indicator is set to N and shipment received >5 and ≤ 10 days early"]
["RS = 0.60 if early shipment indicator is set to N and shipment received > 10 and ≤ 15 days early"]
["RS = 0.40 if early shipment indicator is set to N and shipment received > 15 and ≤ 20 days early"]
["RS = 0.20 if early shipment indicator is set to N and shipment received > 20 and ≤ 25 days early"]
["RS = 0.00 if early shipment indicator is set to N and shipment received > 25 days early"]