Question: The service manager for a bicycle sales and service shop wants to study the length of time required to replace the gears on road bikes.

The service manager for a bicycle sales and service shop wants to study the length of time required to replace the gears on road bikes. The manager has implemented a quality improvement program to standardize the process for replacing bike gears. As a part of the improvement program, four bikes needing gear replacements are randomly selected each day for 20 days. The time required, in minutes, to replace the gears for each bike is measured. The results are as follows:

Use Excel to develop an R chart to determine if the range of the process is stable or not.

Day Bike BikeBikeBike 16.26 22.95 26.12 10.92 33.97 18.8020.6720.04 17.74 28.60 9.96 10.98 27.22 22.02 25.3221.93 30.67 14.65 18.2921.70 20.44 9.48 32.8717.69 19.88 16.961.7927.61 18.1322.06 21.2220.33 21.82 32.2516.5020.11 1025.18 23.24 19.97 17.83 1118.49 13.66 27.44 20.87 12 23.22 17.36 22.25 24.19 13 23.97 21.79 23.14 35.88 14 18.53 25.38 13.31 29.83 15 20.66 26.50 20.42 18.76 16 2132 28.41 29.75 19.91 17 22.92 18.58 18.16 15.60 18 20.5 20.85 23.50 22.74 19 22.15 21.73 21.28 24.94 20 20.17 19.15 22.87 25.89

Step by Step Solution

★★★★★

3.44 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Day Bike 1 Bike 2 Bike 3 Bike 4 x Max Min R 1 1626 2295 2612 1092 1906 2612 1092 152 2 3397 188 2067 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

629-B-M-L-S-C-M (4282).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

The owner of a specialty coffee shop wants to study coffee purchasing habits of customers at her shop. She selects a random sample of 60 customers during a certain week, with the following results: ...

Determine the length of time required to double the value of an investment, given the following rates of return. a. 4% b. 10% c. 30% d. 100%

You are the customer service manager for a company that sells a software package used by not-for-profit organizations to plan and manage fundraising campaigns. The powerful software is complicated...

The service manager for a bicycle sales and service shop wants to study the length of time required to replace the gears on road bikes. The manager has implemented a quality improvement program to...

I was wondering if someone could help me with this assignment with several things. 1. I need a Structured/Activity Flow Chart 2. Detailed Recommendations for the client 3. Cover Letter/Title...

IFSM 300 Final Assessment Exam NOTE: As for all work in this class, the final exam must be original work developed by the student solely for use in this class and must conform to UMUC's academic...

Cycling Soars: The Case of Sprockets Bike Shop Damien Mercer Florida Institute of Technology INTRODUCTION After a long 10-hour day at Sprockets Bike Shop, Mike Roberts is exhausted and excited. He is...

IFSM 300 Final Assessment Exam NOTE: As for all work in this class, the final exam must be original work developed by the student solely for use in this class and must conform to UMUC's academic...

Introduction Herbert owns and manages a bicycle shop called 'TopBike' which is undergoing significant expansion. Since you are a friend of his and run a professional systems consultancy, he has taken...

This question is finance-related and taken from the 2015 film The Big Short: As described in the movie, Burry tried to call BoA, Goldman, and Morgan Stanley, but the call was only returned a week...

You have the following information: return Variance cov(A,B) stock A 3% 6% 2.59% stock B 13% 20% risk-free 3% 0 The optimal risky portfolio has a weight of -75.93% in A and 175.93 % in B. Compute the...

e generally accepted accounting principles used in the financial statements of U . S . corporations are esearched and developed by which organization? American Accounting Association ( AAA )...

Explain the significance of testing and storing the DNA of incarcerated felons.

Sterling, inc. operates 52 weeks per year, and its cost of goods sold last year was $6,500,000. The firm carries eight items in inventory four raw materials, two work-in- process items, and two...

A large global automobile manufacturer is considering outsourcing the manufacturing of a solenoid used in the transmission of its SUVs. The company estimates that annual fixed costs of manufacturing...

Black Bear Outfitters is an international supplier of outdoor gear for families. Currently, the company uses a logistical provider to provide warehouse services and handle packages destined for...

The experimental probability that a customer at a restaurant qualified for a senior 2 discount was found to be . The restaurant recorded 16 senior discounts on a given day. What was the number of...

What is the present value of the following set of cash flows, discounted at 1 4 . 1 % per year? \ table [ [ Year , 1 , 2 , 3 , 4

Consider the single factor APT. Portfolio A has a beta of 1 . 4 and an expected return of 2 4 % . Portfolio B has a beta of 0 . 8 and an expected return or 2 0 8 . The risk - free rate of return is 5...