The tools practiced in this workshop are: Descriptive statistics Histograms NOTE: Complete the Histogram...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The tools practiced in this workshop are: • Descriptive statistics • Histograms NOTE: Complete the Histogram and descriptive statistics in MS Excel and cut and paste the results into this document. Submit the MS Word Workshop 2 into the Dropbox in Week 4 module. Situation: Consider that you are interning for a prominent attorney in Houston. You are working on a project to reduce the client intake process time. This data is needed to establish a baseline measurement at the beginning of your Lean Six Sigma project so that you will have a measurement to compare against later once the process has been improved. NOTE: The raw data that you will use is at the bottom of this workshop. Instructions: Use information from your training manual in Measure Phase - Lessons 9-11 to assist you with the activities that follow. Be sure to follow the "best practices for each tool you use in this workshop. To create a baseline measurement, you have collected a random sample of times for the client intake process (data is at the bottom of this Workshop). You recorded your time measurements in a table (see the data at the end of this Workshop). Use Microsoft Excel to calculate your descriptive statistics, create a histogram of your data, and provide answers to the questions below. Activities: (also see next page) 1. For the client intake process times, what is the a. Mean time in hours? b. Standard deviation in hours? c. Minimum in hours? d. Maximum in hours? e. Range in hours? 2. Create a histogram that summarizes your data set (i.e., client intake process time). 3. Near the end of your Lean Six Sigma project, after you have implemented solutions to improve your client intake process, you measure the process performance again and get the following results: Intake process time - Mean: 235 hours; standard deviation: 45 hours; minimum: 100 hours - Maximum - 300 hours. a. Have you improved the process? Yes or no and why. Hint: Perform a before and after comparison by comparing the baseline measurements in Activity #la-e of this Workshop with the measurements given in this question. The firm partners' specifications for the client intake process cycle time are: Target: 200 hours + 75 hours (lower specification limit: 125 hours and upper specification limit: 275 hours) b. How well does the improved process fulfill customer requirements/specifications? Hint: Perform another comparison by comparing the measurements given in this question to the customer specifications given in the "Situation" part of this Workshop. Histogram Data for Excel: Client Intake Time (Hours) - 50 values. 101 103 130 125 132 146 113 128 148 139 214 227 235 249 206 231 247 233 218 220 153 168 173 191 187 160 288 266 259 267 253 298 284 261 275 273 265 271 283 286 251 272 287 297 291 268 303 333 348 329 The tools practiced in this workshop are: • Descriptive statistics • Histograms NOTE: Complete the Histogram and descriptive statistics in MS Excel and cut and paste the results into this document. Submit the MS Word Workshop 2 into the Dropbox in Week 4 module. Situation: Consider that you are interning for a prominent attorney in Houston. You are working on a project to reduce the client intake process time. This data is needed to establish a baseline measurement at the beginning of your Lean Six Sigma project so that you will have a measurement to compare against later once the process has been improved. NOTE: The raw data that you will use is at the bottom of this workshop. Instructions: Use information from your training manual in Measure Phase - Lessons 9-11 to assist you with the activities that follow. Be sure to follow the "best practices for each tool you use in this workshop. To create a baseline measurement, you have collected a random sample of times for the client intake process (data is at the bottom of this Workshop). You recorded your time measurements in a table (see the data at the end of this Workshop). Use Microsoft Excel to calculate your descriptive statistics, create a histogram of your data, and provide answers to the questions below. Activities: (also see next page) 1. For the client intake process times, what is the a. Mean time in hours? b. Standard deviation in hours? c. Minimum in hours? d. Maximum in hours? e. Range in hours? 2. Create a histogram that summarizes your data set (i.e., client intake process time). 3. Near the end of your Lean Six Sigma project, after you have implemented solutions to improve your client intake process, you measure the process performance again and get the following results: Intake process time - Mean: 235 hours; standard deviation: 45 hours; minimum: 100 hours - Maximum - 300 hours. a. Have you improved the process? Yes or no and why. Hint: Perform a before and after comparison by comparing the baseline measurements in Activity #la-e of this Workshop with the measurements given in this question. The firm partners' specifications for the client intake process cycle time are: Target: 200 hours + 75 hours (lower specification limit: 125 hours and upper specification limit: 275 hours) b. How well does the improved process fulfill customer requirements/specifications? Hint: Perform another comparison by comparing the measurements given in this question to the customer specifications given in the "Situation" part of this Workshop. Histogram Data for Excel: Client Intake Time (Hours) - 50 values. 101 103 130 125 132 146 113 128 148 139 214 227 235 249 206 231 247 233 218 220 153 168 173 191 187 160 288 266 259 267 253 298 284 261 275 273 265 271 283 286 251 272 287 297 291 268 303 333 348 329
Expert Answer:
Related Book For
An Introduction To Six Sigma And Process Improvement
ISBN: 9781133604587
2nd Edition
Authors: James R. Evans, William M. Lindsay
Posted Date:
Students also viewed these general management questions
-
The following selected liquidity and solvency ratios are available for two companies operating in the fast food industry: Instructions Assume that you are the credit manager of the local bank. Answer...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Given a risk-adjusted discount rate of 14%, calculate the discounted payback period for the following cash flow of a project. If the maximum target discounted payback period is 3 years, comment on...
-
Maccoa Soft, a division of Zayer Software Company, produces and distributes an automated payroll software system. A contribution margin format income statement for Maccoa Soft for the past year...
-
Twelve board members are voting on after-meeting activities, and they are asked to check any that they might like. The outcome of their choices is shown here: What is the outcome using approval...
-
After the positrons were annihilated, the energy density of the universe was dominated by the photons and the neutrinos. Show that the energy density in that era was given by \(u_{\text {total...
-
Complete the balance sheet of Flying Roos Corporation. You have the following information: Debt ratio = 40% DSO = 39 days Current ratio = 1.5 Inventory turnover ratio = 3.375 Sales = $2.25 million...
-
Let G = (N,A) be an undirected graph. (a) Suppose the arcs of G have with nonnegative weights. Explain how you could modify Dijkstra's algorithm (not G) to find a shortest path from a designated node...
-
A 0.7812-g sample of impure Al 2 (CO 3 ) 3 decomposed with HCl; the liberated CO 2 was collected on calcium oxide and found to weigh 0.04380 g. Calculate the percentage of aluminum in the sample.
-
solve b -c The probability that a randomly selected voter voted for either Candidate 3 o (Type an integer or a decimal. Round to three decimal places as needed.) c. Find the probability that a...
-
Automatic round the clock tellers are the newest thing in the banking industry. Several companies have developed these computerized money machines and are bombarding bank managers with sales people...
-
MCI Board Analysis This time, you are on the internal side of the board meeting. As the CFO of MCI, and you must prepare a proposal for discussion at the next meeting of the board of directors. Based...
-
If a product costs $1500 for the first unit and there is a 10% discount starting on the second unit, a 15% discount (from the original price) starting on the 5th unit, what would be the cost for 6...
-
PLEASE WRITE CREATE AN ANNOTATION FROM THE FOLLOWING: RELIGIONS HELP US FORM THE BASIC ASSUMPTIONS ABOUT WHO WE ARE AND HOW WE SHOULD ACT IN THE WORLD. PRESENTLY, TWO WORLDVIEWS WITH ACCOMPANYING...
-
Determine the target direct costs per person for your event, using the target costing pricing strategy, using the information below Event Financial Information Maximum Ticket Price $80 Target gross...
-
Sefo Co. purchased some bonds as a long-term investment for a total of $1,200,000. up will sell the bonds if the price increases at least 10%. on December 31, 2019, their bonds had a fair value of...
-
Annual dividends of ATTA Corp grew from $0.96 in 2005 to $1.76 in 2017. What was the annual growth rate?
-
Explain the application of Six Sigma in service organizations. How does it differ from manufacturing? How is it similar?
-
In the 1990s, General Electrics CEO, Jack Welch, sent a memo to his senior managers telling them that to be promoted, they would have to require every employee to have started Six Sigma training....
-
What does the acronym SMART stand for, and how can these characteristics be used to develop good process measures and indicators?
-
Explain the structure, current trends, and future prospects of the banking industry.
-
Banks face several types of risk in day-to-day business. They include: a. Liquidity riskthe risk that customers will demand cash immediately. i. Liability-side liquidity risk arises from deposit...
-
Define the term quality .
Study smarter with the SolutionInn App