lean six sigma

lbxf
timer Asked: Dec 10th, 2018

Question Description

solve the questions in full details . there is excel files for the data for each questions except questions 2, and 5 . do not do it in just excel . show work details ,and provide formula

Unformatted Attachment Preview

CITY BANK RETIREMENTPACKAGE PROCESSING FORM Current State Time Study Ref DEPT. TASK 1 INITIATION Receive Information from Customer 2 INITIATION Gather Personal Information 3 INITIATION Dtermine action required 4 INITIATION Assign proper action code 5 INITIATION Print information, verify with customer 6 INITIATION Attach supporting documentation 7 INITIATION Pass information to Processing 8 PROCESSING Receive paperwork from Initiation 9 PROCESSING Perform Quality Check to ensure all information is filled out 10 PROCESSING Open HRIS 11 PROCESSING Access Employee record in HRIS and enter data 12 PROCESSING Verify Employee information 13 PROCESSING Verify validity of supporting documentation 14 PROCESSING Enter transaction information into HRIS 15 PROCESSING Pass information to Certification Official 16 CERTIFICATION Receive paperwork from Processing 17 CERTIFICATION Perform Quality Check to ensure all information is filled out 18 CERTIFICATION Open HRIS 19 CERTIFICATION Access Employee record in HRIS 20 CERTIFICATION Review supporting documentation 21 CERTIFICATION Approve/Disapprove transaction 22 CERTIFICATION Pass package to Submission 23 SUBMISSION Retrieve customer file from Certification 24 SUBMISSION Perform Quality Check to ensure all information is filled out 25 SUBMISSION Submission transaction to Payroll 26 SUBMISSION Print Retirement Benefits Form 27 SUBMISSION Ensure copy is maitained in Employee files 28 SUBMISSION Forward copy to Employee Avg CVA Avg BVA 2 4 4 4 0 0 0 0 0 0 0 0 4 1 0 0 0 0 1 0 9 0 0 0 1 0 0 8 Avg NVA 1 1 1 1 0 1 0 0 0 3 3 2 1 0 0 0 0 3 2 0 1 0 0 0 1 4 4 0 0 0 0 0 4 3 4 5 10 3 4 0 0 0 5 4 4 3 2 16 1 2 6 4 0 0 2 0 Nber of Staff 10 12 12 16 OPERATORS MATERIALS TEPERATURES Quality Good Bad Willie Pass/Fail Good Bad Lot1 Pass_Fail Good Bad Temp1 Billy 69 31 Tilly 75 25 Lot2 45 21 Lot3 67 11 Temp2 64 11 81 19 Lot4 49 23 Temp3 79 22 54 11 64 12 New 1 New 2 New 3 Existing 80.3 88.6 77.5 85.8 84.1 80.5 76.6 83.2 81.5 81.8 78.7 84.4 85.5 82.5 81.7 83.4 83.7 84.1 79.5 86 85.2 81.2 79.5 80.6 81.3 80.5 77.7 83.1 88.2 82.6 78.5 88 79.6 84.4 79.5 86.9 84.7 83.3 81.3 84.3 Unloading Time 25 33 28 30 31 27 25 33 28 33 27 28 29 30 29 28 35 25 30 30 31 25 28 25 30 33 25 32 28 28 27 29 34 29 27 28 29 31 28 29 30 28 32 28 24 28 27 27 26 32 25 33 30 31 26 27 30 27 30 24 32 29 32 30 31 30 34 25 24 28 27 34 30 27 29 28 29 24 29 33 29 25 32 28 25 34 29 28 24 28 30 27 25 28 29 27 30 30 30 31 24 30 26 30 29 27 29 25 29 34 31 27 29 28 34 24 26 31 33 32 31 30 26 28 30 27 32 35 27 30 28 33 29 31 35 26 30 28 27 28 35 30 30 30 29 33 29 32 35 29 26 29 30 32 24 26 32 35 32 29 27 26 32 27 32 31 30 30 27 30 30 26 28 31 30 31 32 29 26 28 27 30 26 25 29 29 33 31 26 27 29 27 31 30 27 28 28 32 28 26 32 29 29 31 29 27 28 25 27 31 31 34 28 28 31 26 33 29 29 27 34 26 26 35 28 31 32 35 29 27 29 26 33 34 26 29 33 24 31 29 28 30 33 30 29 29 25 35 30 32 30 30 31 29 32 26 31 28 29 29 29 29 30 28 25 27 SIX SIGMA GREEN BELTS Question 1 (20 points) Data in EXCEL File Question 1 The current state of City Bank Retirement Package processing Form 2050S has to go through the following phases: Initiation: Personnel office is notified of a pending CTB Form 2050S Processing: Data is entered into the HRIS Certification: Authorized personnel certify CTB Form 2050S before submission to payroll Submission: Certified actions are sent into the payroll system for action. 1) Provide a SIPOC for this process There are 600 CTB Form 2050S submitted to HRIS per week. The working hours are: 5 days per week, 1 shift per day, 9 hours per shift Each shift receives a 30 minute lunch Each shift receives 2 - 15 minute breaks The average process uptime is 95% (due to network failures and system downtime). The capacity of each step in the process is: Process step Initiation: Processing: Certification: Submission: gross capacity 2 forms/hour/person 1.5 forms/hour/person 1.25 forms/hour/person 2 forms/hour/person # people 10 12 12 16 2) Create a task time chart of the current state - include the customer demand (takt time and/or takt rate) ▪ Perform a 1st cut task re-balancing to immediately improve output ▪ No initial reduction in NVA, no initial additional skills training ▪ Note: all employees can perform all of the tasks of the department PRIOR to theirs in the flow, as well as certain tasks of the department subsequent to theirs (this is how you are promoted) 3) Suggest any improvements to the 1st cut re-balancing and create a “Future State” process, including: - Ways to reduce NVA and additional cross-training - Personnel re-alignment, if any Solution Question 2 (10 points) The following chart represents your sandwich prep time IMR control charts set of your sandwich process. You are the Lead Green Belt of a Quality Assurance Team that will report the findings to the management. Interpret the charts for Ms. Nguyen, your district manager. Answer Question 3 (15 points) Use EXCEL File Question 3 Analyze this data to find out on which of the three Key Process Input Variables - KPIVs (OPERATORS, MATERIALS, TEMPERATURE) defect count is most dependent. Solution Question 4 (20 points) Excel File Question 4 The following data represent the performance of new machines under consideration vs. the existing equipment. You are the Lead Green Belt of a Production Line Team that will report the findings to the management. Interpret the data for Ms. Nguyen, your district manager and suggest your recommendations based on your statistical skills as GB. Ms. Nguyen wants all analyses to be performed at 5% significance level Solution Question 5 (15 points) The following data represent the value of a certain quality characteristic of interest during a LSS improvement project. Using your knowledge in SPC as Green Belt, please interpret the data and statistically state your case for Ms. Nguyen your district Manager. # 1 2 3 4 5 6 7 8 9 10 11 Date Stage 4/13/2015 Baseline 4/20/2015 Baseline 4/27/2015 Baseline 5/4/2015 Baseline 5/11/2015 Baseline 5/18/2015 Baseline 5/25/2015 Baseline 6/1/2015 Baseline 6/8/2015 Baseline 6/15/2015 Baseline 6/22/2015 Baseline Project Metric 85 78 86 81 82 88 83 86 85 88 82 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 6/29/2015 Baseline 7/6/2015 During Project 7/13/2015 During Project 7/20/2015 During Project 7/27/2015 During Project 8/3/2015 During Project 8/10/2015 During Project 8/17/2015 During Project 8/24/2015 During Project 8/31/2015 During Project 9/7/2015 During Project 9/14/2015 During Project 9/21/2015 During Project 9/28/2015 During Project 10/5/2015 During Project 10/12/2015 Post Project 10/19/2015 Post Project 10/26/2015 Post Project 11/2/2015 Post Project 11/9/2015 Post Project 11/16/2015 Post Project 11/23/2015 Post Project 11/30/2015 Post Project 12/7/2015 Post Project 12/14/2015 Post Project 12/21/2015 Post Project 12/28/2015 Post Project 1/4/2016 Post Project 78 81 85 83 88 86 89 87 85 90 89 92 90 93 89 94 97 96 91 97 98 99 94 95 97 97 96 97 Solution Question 6 (20 points) Excel File Question 6 Assess the unloading process at your facility using SPC approach. Provide all descriptive and inferential statistics. The upper specification limit for the customer (Your processing plant) is 30 minutes. Since the data is non-normal, you have consulted your MBB who conducted a more thorough analysis that indicated you were still OK using a normal probability analysis tools and approaches you have learned during your certification as LSS GB. Solution
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors