Appendices
Appendix A – Organizational Chart
Organizational Chart
[Image description for organizational chart.]
Appendix B – Late PO Data
| Reasons for Late (PO Lines) | Month 1 | Month 2 |
|---|---|---|
| Incorrect Data Entry | 12 | 13 |
| Documentation Issue | 4 | 3 |
| Expedite Request – Could not be executed | 1 | 3 |
| Vendor – Over Capacity | 5 | 5 |
| Quality Issue – Reject | 4 | 1 |
| Wrong Shipment Method | 1 | 2 |
| Incorrect Item Shipped | 0 | 0 |
A follow-up study on Incorrect Data Entry was conducted to gain further insights.
| Incorrect Data Entry | Month 1 | Month 2 |
|---|---|---|
| Receipt Incorrect | 1 | 1 |
| Receipt not Entered on Time | 4 | 6 |
| Incorrect or Missing Promise Date | 6 | 5 |
| Unknown | 1 | 1 |
Appendix C – Purchase Order
Accessible purchase order [downloads a Word document].
Appendix D – Key Supplier Performance Report
(Jan. 1 – Dec. 31, 2022)
| Supplier | Location | Part/Material | # of Purchase Orders (PO) | Purchase Order Value | % PO Delivered on Time | Average Order Lead Time | % of PO with Confirmation Dates | % of PO Delivered Complete * |
|---|---|---|---|---|---|---|---|---|
| Orillia Components LTD. | Orillia, ON, Canada | Power distribution cable harness | [empty cell] | [empty cell] | [empty cell] | [empty cell] | [empty cell] | [empty cell] |
| TSMC | Hsinchu, Taiwan | Programmable controller | [empty cell] | [empty cell] | [empty cell] | [empty cell] | [empty cell] | [empty cell] |
| Precision Gear Corp | Monterrey, Mexico | Hydraulic gear subassembly | [empty cell] | [empty cell] | [empty cell] | [empty cell] | [empty cell] | [empty cell] |
| Adams Machine Co. | Edmonton AB Canada | Feeder tray | [empty cell] | [empty cell] | [empty cell] | [empty cell] | [empty cell] | [empty cell] |
| Lakeshore Robotics | Belleville, ON, Canada | Motor control drive system | [empty cell] | [empty cell] | [empty cell] | [empty cell] | [empty cell] | [empty cell] |
- Notes: For the purposes of analysis you will need create formulae and use logical and summary spreadsheet functions to calculate the measures for the Key Supplier Performance Report.
- # of Purchase Orders: The # of Purchase Orders placed with each supplier.
- Purchase Order Value: The total value of Purchase Orders for each vendor
- % of PO Delivered on Time: This calculation requires logic. If there is no promise/confirmation date then a on-time order is when the Date Delivered = Promise/Confirmation Date. When the confirmation date is missing then an on-time order is when the Date Delivered = Date Required
- Average Order Lead Time – Lead Time = days difference between Date Ordered and Date Required
- % of PO with Confirmations – The % of purchase orders that had confirmation dates, summarize for each supplier
- % of PO Delivered Complete – A complete order is defined when the # of lines delivered = # of lines ordered
Appendix E – Packing Slip
Accessible packing slip [downloads a Word document].
Appendix F – Ishikawa Diagram
Completed by the Process Improvement Team
[Image description for Ishikawa Diagram]
Appendix F1 – Ishikawa Top 3 Analysis
[Image description for Ishikawa Top Three Analysis]
Appendix G – The Five Whys Template
The Five Whys Template
This Five Whys template is used to systematically identify the root causes of problems observed in the workplace. It is in table form and allows users to document the observed effects of three different problems and then focus on the root cause by documenting the Gemba evidence found in answer to the question “Why?”.
[Image description for Five Why analysis template.]
Accessible Five Whys analysis template [downloads a Word document].
[Return to Activity Step 3 Continued]
