
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
thumb_up100%
CAN SOMEONE PLEASE EXPLAIN HOW TO CALCULATE THE UPPER/LOWER LIMITS USING EXCEL? THANK YOU!!
This is the question I'm trying to solve.

Transcribed Image Text:Sampling 4 pieces of precision-cut wire (to be used in computer assembly) every hour for the past 24 hours has produced the following results:
X
R
3.25" 0.76"
Hour
7
3.00 1.23 8
3.22 1.43 9
3.29 1.26 10
3.07 1.12 11
2.96 0.37 12
Hour
1
2
3
4
5
6
R Hour Xx
Upper Control Limit (UCL) - inches (round your response to three decimal places).
=
X
2.95" 0.48"
2.75 1.13
2.92 0.76
2.85
2.73
1.38
2.97
1.22
0.35
131415167 18
R
3.11" 0.80"
2.73 1.36 20
3.12 1.01
2.84 0.50
2.76 1.43
2.74 1.24
Hour
227221
19
23
24
X
R
3.31" 1.56"
2.99
1.09
2.55
1.13
3.28 0.41
2.94
2.74
Based on the sampling done, the control limits for 3-sigma x chart are (round all intermediate calculations to three decimal places before proceeding with further calculations):
1.63
0.97

Transcribed Image Text:Sample
Size, n
2
SS WN
3
4
56
7
80912
Mean Factor,
A2
1.880
1.023
0.729
0.577
0.483
0.419
0.373
0.337
0.308
0.266
Upper Range,
D4
3.268
2.574
2.282
2.115
2.004
1.924
1.864
1.816
1.777
1.716
Lower Range,
D3
0
0
0
0
0
0.076
0.136
0.184
0.223
0.284
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps with 9 images

Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
How would I calculate the R-chart upper and lower ranges? what numbers should I substitute in the formula?
Solution
by Bartleby Expert
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
How would I calculate the R-chart upper and lower ranges? what numbers should I substitute in the formula?
Solution
by Bartleby Expert
Knowledge Booster
Similar questions
- The purpose of a Business Impact Analysis (BIA) is to determine: Choose the correct answer? The cost to repair a failed system The extent of a disaster's damage Critical business processes that must be maintained How often an incident will occurarrow_forwardA good CRM system must include these four features.arrow_forwardList the tradeoffs you would consider for taking decision of buying a new car versus buying a used car?arrow_forward
- $4.00 in 1911 would be equivalent to ~$125.00 in 2023. If a person in 2023 earned $125 per week (52 weeks in a year), then how much would they earn for their annual income?arrow_forwardtyping clear no chatgpt used i will give 5 upvotesarrow_forwardHelmets & Helmet Fitting What are the standards for fitting football helmets? Explain. What are the standards for fitting a bicycle helmet? Explain. What are the standards for other types of sport helmets? Explain. Explain the purpose of helmets in the sport you've chosen (#1-3). What are the recommendations for reconditioning & replacing helmets for various sports? What organization is responsible for testing helmets for safety? What organization oversees standards for reconditioning helmets? Don't forget to cite reliable & scholarly sources of information!arrow_forward
- Correct complete solutions need only 100% sure experts solve it correct complete solutions with final answers and drawing okarrow_forwardCan you assist me with this problem. If possible can you write it out it is easirer to follow along. Thank youarrow_forwardCalculate how much you would have in 20 years if you saved $3,000 a year at an annual rate of 8 percent with the company contributing $750 a year. Use (Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D).arrow_forward
- Danny Meyer Leads His Company through the Challenges of Eliminating Tips What happens when your CEO wants to remove the tip structure from your restaurant? Do you complain about the new prices as a customer? Do you worry about your paychecks as a server? Danny Meyer, CEO of Union Square Hospitality (home to some of the most successful New York restaurants), discovered these answers when he began eliminating the tip structure in most of his restaurants. He had seen firsthand the largest negative impact of a tipping culture: employees stuck in front-line positions with no chance to advance to management without taking significant pay cuts. Meyer began by first involving the affected employees in town-hall talks. These town halls happened months before any publicity was released. Meyer then hosted town halls with customers to explain the importance of fair wages for all his employees at the restaurant, not just the few who served the food. The transition period for each restaurant to…arrow_forwardJohn Dewey describes a 6-stage process for efficient and effective problem solving. List the six stages in order. Explain what happens in each stage. Please do fast ASAParrow_forwardWhat is a BFOQ? Why is it used in the workplace? Provide 3 examples of when it might be necessary to have a BFOQ.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.

Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,

Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education


Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning

Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.