{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Part A Obsolete","Part A Process Flow","Part B Un-Obsolete Instructions","Part B Un-Obsolete","Part B Process Flow"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Part A Obsolete","index":0,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":false,"merged":[[21,1,21,6],[8,0,9,9],[6,8,6,9],[16,1,16,6],[17,1,17,6],[18,1,18,6],[19,1,19,6],[20,1,20,6],[4,0,4,1],[4,2,4,8],[6,1,6,6],[11,7,11,9],[15,1,15,6],[65,0,66,9],[23,6,23,9],[27,0,27,9],[40,4,40,6],[42,0,42,9],[63,0,64,9],[32,8,32,9],[32,4,32,5],[33,0,34,9],[25,1,25,5],[25,8,25,9],[40,8,40,9],[29,0,29,1],[29,2,29,3],[30,0,30,9],[32,2,32,3]]}
["Obsolete Product Form (SM026) Part A – Set Product to Obsolete"]
[]
["Section 1 – Initiate Process - To be completed by Initiator (Forward SM026 to Planning when complete.)"]
[]
["Model Number to Obsolete:"]
[]
["Initiated by:",null,null,null,null,null,null,"Date:"]
[]
["Section 2 – Cost of Goods - To be completed by Planning (Forward SM026 to the Division Sales Manager based on business unit/ market ownership when complete.)"]
[]
[]
["Finished Goods:  ","Quantity on Hand =",null,null,"Unit Cost:",null,"Cost:",{"$f":"IF(F12=\"\",\"\",D12*F12)","v":""}]
[]
["List all in-stock parts that are exclusively associated with the assembly of this product in the table below.  "]
[]
["Part Number","Description",null,null,null,null,null,"QOH","Unit Cost","Total Cost"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I17=\"\",\"\",H17*I17)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I18=\"\",\"\",H18*I18)","v":""}]
[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,null,null,null,null,null,null,null,""]
[]
["Total cost of finished goods and parts that will be scrapped:",null,null,null,null,null,{"$f":"IF(H12=\"\",\"\",SUM(H12,J17,J18,J19,J20,J21,J22))","v":""}]
[]
["Signature:",null,null,null,null,null,null,"Date: "]
[]
["Section 3 – Approve/ Reject - To be completed by the Division Sales Manager"]
[]
["Reject requested action: "]
["*If Request Rejected: Sign below, save a scanned copy of the form and Doc-Trak to Model in Syteline.\nCompleted form to be saved in \"R:\\Engineering\\Obsolete SM026 records” named Model_MMDDYYYY."]
[]
["Approve requested action:",null,null,null,"Disposition Stock:"]
["*If Request Approved: Sign below, save a scanned copy of the form, Forward to Planning and Doc-Trak from network drive to Model in Syteline. Completed form to be saved in \"R:\\Engineering\\Obsolete SM026 records” named Model_MMDDYYYY."]
[]
[]
["If APPROVED and site completing this form is NOT Depew, the Division Sales Manager should copy:"]
["1. The appropriate Depew Division Sales Manager in order that marketing, web or other updates are initiated."]
["2. The Depew PPIC Manager in order that actions in Section 4 are synced in Depew Item Master."]
[]
["Division Sales Manager/ Designee Signature:",null,null,null,null,null,null,"Date: "]
[]
["Section 4 – Obsolete Product in BSD – To be completed by Planning or Purchasing"]
[]
["If the action in Section 3 is Sell to depletion, Planning/ Purchasing does the following in BSD for Items in Section 2:"]
["1. Change the Material Status to \"Slow Moving\"."]
["2. Change the Reason to \"SLL\" (Slow Moving Limited Sale)."]
["3. Change the Finished Good Type to “Special”."]
["4. Change Safety Stock to \"0\"."]
["5. Ensure Forecast is set to \"0\"."]
["6. Ensure there are no open jobs, PO's or TO's that are needed for a CO."]
[]
["If the action in Section 3 is Scrap product, Planning/ Purchasing does the following in BSD for Items in Section 2:"]
["1. Change the Material Status to \"Obsolete\"."]
["2. Change the Reason to \"OBS\" (Obsolete)."]
["3. Turn off (uncheck) “Accept Requirements”."]
["4. Turn off (uncheck) “Pass Requirements”."]
["5. Change the Finished Good Type to “Special”."]
["6. Change Safety Stock to \"0\"."]
["7. Ensure Forecast is set to \"0\"."]
["8. Ensure there are no open jobs, PO's or TO's that are needed for a CO."]
[]
["If the action in Section 3 is Scrap product, Planning/ Purchasing does the following in BSD for Items in Section 2:"]
["1. Purchasing: For purchased items, send a request to supplier to take purchased product back. If Rejected, send request to Inventory Control to execute transactions in BSD and remove physical material from perpetual inventory."]
[]
["2. Planning: For manufactured items, send a request to Inventory Control to execute transactions in BSD and remove physical material from perpetual inventory."]

{"sheet":"Part A Process Flow","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Part B Un-Obsolete Instructions","index":2,"n_rows":55,"n_cols":2,"rows_kept":55,"cut":false,"hidden":false,"merged":[[40,0,41,9],[44,0,45,9],[0,0,0,9],[5,0,5,9],[8,0,8,9],[11,0,11,9],[14,0,14,9],[1,0,1,9],[3,0,4,9],[6,0,7,9],[2,0,2,9],[9,0,10,9],[12,0,13,9],[15,0,17,9],[38,0,38,9],[39,1,39,9],[52,0,52,9],[53,1,53,9],[54,1,54,9],[42,0,42,9],[43,1,43,9],[46,0,46,9],[50,0,51,9],[47,0,48,9],[49,0,49,9],[18,0,18,9],[33,0,34,9],[36,0,37,9],[32,0,32,9],[35,0,35,9],[19,0,21,9],[23,0,24,9],[26,0,26,9],[28,0,29,9],[22,0,22,9],[25,0,25,9],[27,0,27,9],[30,0,30,9],[31,0,31,9]]}
["Part B – Quote or Sell an Obsolete Product"]
[]
["The SM026 form is a macro-enabled document; macros must be enabled in Excel settings. It is recommended not to print the SM026 form so that distribution to the necessary assignees can be maintained electronically. Upon completion of each section, the assignee will press the corresponding COMPLETE button which will save the form and send e-mails to the distribution list for the next group. Multiple people in each group will receive an email informing them of the awaiting task. This should be completed by the person responsible for the product line affected or an assignee in that person's absence. Initiator will complete their section of the form and enter their email address into the proper field. All other signatures will be done electronically using your User ID Name; format for signature must not include spaces or punctuation, not cap-sensitive, ex. JDoe or JLDoe. If any assignee rejects the request, it is their responsibility to save the document AND inform the Initiator by email.\nForm to be saved in \"R:\\Engineering\\Obsolete SM026 records” named Model_MMDDYYYY."]
[]
[]
["Section 1 – Sales Initiate Process - To be completed by Sales. Upon Sales completion, the lead Design Engineers will be informed of their current task. "]
[]
[]
["Section 2 – Design Engineering Review - To be completed by Lead Design Engineer. Determine BOM readiness. Upon completion, task will be created for Lead Manufacturing Engineer."]
[]
[]
["Section 3 – Manufacturing Engineering Review - To be completed by Lead Manufacturing Engineer. Determine process readiness. Upon completion, task will be created for Operations Manager."]
[]
[]
["Section 4 – Operations Manager Review - To be completed by Operations Manager. Determine work center readiness. Upon completion, task will be created for Planning."]
[]
[]
[]
["Section 5 – Planning Review - To be completed by Planner. Determine component availability for all parts (manufactured and purchased). Upon completion, task will be created for Costing."]
[]
[]
[]
["Section 6 – Costing Review - To be completed by the Costing Department. Determine new cost of product based on New Shrink Factor provided by Manufacturing Engineer using Costing Quick Cost form. Upon completion, Sales Product Manager will be informed of task completions."]
[]
[]
["Section 7 – Product Manager Review - To be completed by the Division Sales Manager. Upon completion, Manager should save form as a PDF in “R:\\Engineering\\Obsolete SM026 records” named Model_MMDDYYYY. The Product Manager will instruct the Initiator in Sales to generate quote/ order request or inform if request is rejected."]
[]
["Section 8 – Quote or Order Entry"]
[]
[]
["1. Sales - Verify a PDF copy of SM026  is saved in  “R:\\Engineering\\Obsolete SM026 records” named Model_MMDDYYYY then Doc Trak it to the model in Syteline from that location. "]
[]
["A. Sales - If the requested action is rejected, contact the customer and inform them that the product is obsolete.  Sales Manager contacts Planning with reason code for rejection."]
[]
[]
["B. Sales - If the requested action is approved and a quote is required, prepare the quote. The scanned version stored in Syteline will be valid for three months from the date the Product Manager/ Designee signed the form."]
[]
[]
["C. Sales - If the requested action is approved and an order is received:"]
[null,"a. Contact Planner informing them that request was approved by Product Manager."]
[]
[]
["2. Planner - Verify a PDF copy of SM026 is Doc Tracked to the model in Syteline prior to proceeding. If one is not present, reject request back to Sales to complete prior to continuing. Change Status to Slow Moving and Reason to CF9 to trigger the ECO flag for Engineering review. An auto e-mail will be sent to Sales and the Lead Engineer upon product status change."]
[null,"*Engineering will enter the item as a project in Projectplace if additional work is required. A Design Review Approval or review with a DRA will be required.  The ECO flag will be turned on when auto e-mail is sent and will remain on until ENG completes all changes (The flag will prevent MRP from driving materials)."]
[]
[]
["3. Sales - Upon receipt of email regarding product status change, Sales is to enter an order in BSD. In addition, Sales to verify a PDF copy of SM026 is saved in “R:\\Engineering\\Obsolete SM026 records” named Model_MMDDYYYY then Doc Trak it to the model in Syteline from that location."]
[]
[]
["4. Planner - Upon creation of the order, a job can now be created."]
[]
[]
["5. Engineer - Upon creation of the job, Engineer to perform a DRA, enter the item in Projectplace and change the Status of the product in Syteline as follows:"]
[null,"a. If product is to permanently remain Active (as noted on SM026 form) change Status to Active with a Reason of REL (released by ENG after update)."]
[null,"b. If product is to go Obsolete following the order, then leave the Status as Slow Moving and change Reason to TMP (for temporarily reactivated product). The job can now be released for the model but the model will go back to Obsolete with the original Reason upon order completion."]

{"sheet":"Part B Un-Obsolete","index":3,"n_rows":200,"n_cols":18,"rows_kept":200,"cut":false,"hidden":false,"merged":[[0,0,0,13],[3,5,3,7],[4,6,4,7],[4,2,4,4],[3,11,3,12],[3,8,3,9],[4,11,4,13],[4,8,4,10],[3,2,3,3],[17,4,17,7],[32,6,32,13],[24,8,24,9],[32,3,32,5],[33,3,33,5],[26,3,26,6],[26,9,26,10],[31,2,31,13],[20,1,20,13],[5,9,5,12],[9,8,9,9],[5,2,5,7],[15,2,15,13],[10,9,10,10],[14,9,14,13],[10,3,10,6],[6,2,6,5],[11,0,11,13],[6,9,6,12],[34,10,34,11],[21,0,21,13],[22,0,22,13],[34,8,34,9],[34,3,34,5],[84,3,84,6],[66,5,66,7],[71,6,71,7],[30,9,30,13],[35,2,35,13],[36,2,36,13],[37,2,37,13],[41,1,41,13],[42,0,42,13],[43,0,43,13],[84,9,84,10],[54,2,54,13],[55,2,55,13],[56,2,56,13],[66,8,66,13],[67,6,67,13],[76,4,76,5],[77,9,77,10],[62,3,62,6],[69,3,69,6],[77,3,77,6],[62,9,62,10],[0,14,11,14],[72,6,72,7],[82,2,82,3],[59,0,59,13],[60,0,60,13],[47,9,47,10],[47,3,47,6],[69,9,69,10],[51,8,51,13],[52,9,53,13],[51,5,51,7],[53,7,53,8],[58,1,58,13],[39,5,39,8],[45,8,45,9],[81,4,81,13]]}
["Obsolete Product Form (SM026) - Part B - Quote or Sell an Obsolete Product",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D11=\"\",\"\",IF(ISNUMBER(SEARCH(\"@\",D11)),\"\",\"INVALID EMAIL ADDRESS ENTERED IN CELL D11\"))","v":""}]
[]
["Section 1 - Initiate Process - Sales:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","Obsolete","Quote"]
["Request to (Select One):",null,null,null,null,"Last Sold Date:",null,null,null,null,"Qty:",null,null,null,null,"No","Active","Order"]
["Model Number:",null,null,null,null,"Qty:",null,null,"Requested Delivery Date:"]
["Customer Name:",null,null,null,null,null,null,null,"Quote #:"]
["Initiated by:",null,null,null,null,null,null,null,"Date:"]
[]
["Model in Stock (Select One):",null,null,null,"*Verify Stock with Planner"]
["Will Model Remain Active or Go Obsolete After Order (Select One)?"]
["Initiator's Full Email Address:",null,null,null,null,null,null,null,"Date:"]
["---------Press COMPLETE then save file in R:\\Engineering\\Obsolete SM026 Records. File name: MODEL_MMDDYYYY-------------"]
["Section 2 - Lead Design Engineering"]
[]
["Reactivate:",null,{"$f":"IF(B15=\"no\",\"STOP! Inform Initiator\",\"\")","v":""},null,null,"Recommend Alternative Model:",null,null,null,null,null,null,null,null,{"$f":"IF(J15=\"\",\"\",\"A\")","v":""}]
["Reason for Rejection:"]
[]
["BOM % Complete:",null,null,null,"Component Prints Available?"]
["Engineering Lead Time:",null,null,"Days",null,null,"Engineering Hours:",null,"Hours"]
[]
["Comments:"]
[]
[]
[]
["Will Model Remain Active or Go Obsolete After Order (Select One)?"]
["*NOTE: If product Will Not Remain ACTIVE after CO is Filled, Set to Slow Moving TMP upon Job Creation."]
["Des. Eng. Signature (User Name):",null,null,null,null,null,null,null,"Date:"]
[]
["Section 3 - Lead Manufacturing Engineering"]
[]
["Reactivate:",null,{"$f":"IF(B31=\"no\",\"STOP! Inform Initiator\",\"\")","v":""},null,null,"Recommend Alternative Model:"]
["Reason for Rejection:"]
["Historical Yield (%)",null,null,"Failure Modes:"]
["Current Shrink Factor",null,null,"New Shrink Factor:"]
["Router % Complete",null,null,"Procedure % Complete:",null,null,null,null,"BOM % Complete:"]
["Router Issues:"]
["Procedure Issues:"]
["BOM Issues:"]
["Engineering Lead Time:",null,null,"Days",null,null,null,"Engineering Hours:",null,"Hours"]
["Recommended Manufacturing Cell to be Built in:"]
[]
["Comments:"]
[]
[]
[]
["Will Model Remain Active or Go Obsolete After Order (Select One)?"]
["*NOTE: If product Will Not Remain ACTIVE after CO is Filled, Set to Slow Moving TMP upon Job Creation."]
["Man. Eng. Signature (User Name):",null,null,null,null,null,null,null,"Date:"]
[]
["Section 4 - Operations Manager"]
[]
["Reactivate:",null,{"$f":"IF(B52=\"no\",\"STOP! Inform Initiator\",\"\")","v":""},null,null,"Reason for Rejection:"]
["Operations Lead Time:",null,null,null,"Days",null,null,null,null,{"$f":"IF(H54=\"no\",\"*Must see Man. Eng. and decide upon the manufacturing cell\",\"\")","v":""}]
["Agree with Recommended Manufacturing Cell from Engineering?"]
["Router Issues:"]
["Procedure Issues:"]
["BOM Issues:"]
[]
["Comments:"]
[]
[]
[]
["Operations Signature (User Name):",null,null,null,null,null,null,null,"Date:"]
[]
["Section 5 - Planning"]
[]
["Reactivate:",null,{"$f":"IF(B67=\"no\",\"STOP! Inform Initiator\",\"\")","v":""},null,null,"Reason for Rejection:"]
["Material Lead Time:",null,null,null,"Days","Risks:"]
["Review/Update Planner Code"]
["Planning Signature (User Name):",null,null,null,null,null,null,null,"Date:"]
[]
["One Time Engineering Cost to Reactivate Model:",null,null,null,null,null,{"$f":"IF(N77=\"\",0,(H19+I39)*N77)","v":0}]
["Total Lead Time (business days)",null,null,null,null,null,{"$f":"SUM(C19,C39,D53,D68)","v":0}]
[]
["Section 6 - Costing"]
[]
["Quick Cost with Shrink Factor:",null,null,null,null,null,null,null,null,null,null,null,"Engineering Burden Rate:",100]
["Costing Signature (User Name):",null,null,null,null,null,null,null,"Date:"]
[]
["Section 7 - Product Manager"]
[]
["Approved:",null,null,"Action:"]
["New Selling Price:"]
[]
["Product Manager (User Name):",null,null,null,null,null,null,null,"Date:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Unobsolete Form is Ready"]

{"sheet":"Part B Process Flow","index":4,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,"No"]
[]
[]
[null,null,null,"Yes"]
[null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,"No"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,"No"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,"No"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"No",null,"Yes"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Yes"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,"No"]
[]
[null,null,null,null,null,null,null,null,"Yes"]