ZuoTi.Pro
Question

Please solve in MS Excel only Installing a muffler at Barut Garage, Inc. involves a five...

Please solve in MS Excel only

Installing a muffler at Barut Garage, Inc. involves a five work tasks. Azra has timed workers performing these tasks seven times, with the results (in minutes) shown in the following table.

No

Tasks

1

2

3

4

5

6

7

PR

1

Select correct mufflers

3

3

6

3

5

3

3

85

2

Remove old muffler

8

5

7

5

7

5

8

120

3

Install new muffler

13

11

11

12

14

13

14

110

4

Inspect the work

4

3

4

3

4

4

3

110

5

Complete paperwork

9

8

9

10

9

10

8

85


  
      
Given that Azra does not want an error of more than 0.08 and a confidence level less than 0.90 answer the following:
  
Provide the z-score: ____ Round to the nearest hundredth, for example 4.22
  
Does the number of observations for the following tasks warrant such confidence level?  
Enter YES or NO.  ____
  
Task # 3 Install new muffler      :  ____
Task # 5 Complete paperwork   :  ____
  
What are the required numbers of observations for these tasks? Enter the number.
  
Task # 3 Install new muffler      :  ____
Task # 5 Complete paperwork   :  ____
  
Assume that the number of observations for the following tasks justifies the confidence level and accuracy mentioned above. Also note that Azra factors in a total of fatigue and personal allowance of 0.15 applied to job time. Provide the following results from your solution:

Task

Normal Time*

Standard Time*

# 2 Remove old muffler

____min

____min

# 4 Inspect the work

____min

____min


  
Provide the total standard time* for the whole job:  ____ minutes.
*Round to the nearest hundredth, for example 8.45 minutes

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Provide the Z-score: 1.65

Does the number of observations for the following tasks warrant such confidence level?  

Task # 3 Install new muffler: YES
Task # 5 Complete paperwork: YES

What are the required numbers of observations for these tasks? Enter the number.
  
Task # 3 Install new muffler: 5
Task # 5 Complete paperwork: 4

Task

Normal Time*

Standard Time*

# 2 Remove old muffler

7.71 min

9.08 min

# 4 Inspect the work

3.93 min

4.62 min

The total standard time* for the whole job:  42.68 minutes.

EFGH! Observed time Tasks Select correct mufflers 3 Remove old muffler Install new muffler Inspect the work Complete paperwor

ObservedStd Normal time 1.254853.16 0.15 3.71 1.397 120 7.71 0.15 9.08 1.272 110 13.83 0.15 16.27 0.535 110 3.93 0.154.62 0.8

Note: For Std time, the formula used is Std time = Normal time / (1-AF): Some books use an alternative formula which is Std.t

0 0
Add a comment
Know the answer?
Add Answer to:
Please solve in MS Excel only Installing a muffler at Barut Garage, Inc. involves a five...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Installing a muffler at Barut Garage, Inc. involves a five work tasks. Azra has timed workers...

    Installing a muffler at Barut Garage, Inc. involves a five work tasks. Azra has timed workers performing these tasks seven times, with the results (in minutes) shown in the following table. No Tasks 1 2 3 4 5 6 7 PR 1 Select correct mufflers 5 4 6 3 4 5 5 120 2 Remove old muffler 8 8 8 6 8 7 6 85 3 Install new muffler 15 13 15 14 12 15 13 85 4 Inspect the...

  • John is installing a production line in the kitchen of his successful restaurant “Light of the...

    John is installing a production line in the kitchen of his successful restaurant “Light of the World” to make vanilla soufflé with caramel sauce. He figures his layout can be broken down into the following tasks: A. Egg separation – 8.5 min. B. Flour, milk, vanilla, egg yolk and sugar blend – 6.5 min. C. Fold egg whites into blend – 2.0 min. D. Bake – 8.9 min. E. Remove from oven, apply topping, garnish, stage, deliver – 8.0 min....

  • I want the soloution without excel 2. In a hospital the task done by the staff...

    I want the soloution without excel 2. In a hospital the task done by the staff to discharge the patient from the hospital is studied to determine the standard time. The detailed timing for discharging the each patient is given below. Tasks Observations (Minutes) 2 3 Take the details of the patients 14 16 17 Prepare a report 17 18 20 Consultation with the doctor 20 25 23 Handle the payment 19 22 20 4 15 19 30* 18 5...

  • What is a Therblig? Please specify and give exampie. 3) A time study was conducted on a job that ...

    What is a Therblig? Please specify and give exampie. 3) A time study was conducted on a job that contains four elements. The observed times and performance ratings for six cycles are shown in the following table. Note that all units are in minutes 15 Element Performance 1 13 4 6 rating 85% 100% 110% 95% 0.5 258* 0.89 1.14 0.46 1.52 0.8 0.44 1.5 0.84 1.1 0.43 1.47 0.48 1.49 0.85 0.45 1.51 0.83 1.081.21.161.26 4 * Machine broke...

  • Based on a careful work study in the Hofstetter? Corp., the results shown in the following...

    Based on a careful work study in the Hofstetter? Corp., the results shown in the following table have been? observed: a) The normal time for the "prepare daily reports" operation = ___ minutes (round your response to two decimal places). The normal time for the "photocopy results" operation = ___ minutes (round your response to two decimal places). The normal time for the "label and package reports" operation = ___ minutes (round your response to two decimal places). The normal...

  • Problems 5 through 9 only please C. Regression Analysis In this section, you will analyze the effects of weather conditi...

    Problems 5 through 9 only please C. Regression Analysis In this section, you will analyze the effects of weather conditions on workers' productivity. You collect a random sample of 500 workers. Your data includes the average time it takes each worker to complete the same task (minutes), the temperature that day (measured in Farenheit), the natural log of temperature that day, whether it was raining that day (dummy variable), and the workers' age (years). An extract of the data is...

  • Please Implement this code using Java Eclipse. CIS 1068 Assignment 8 Warm Up with Objects Due:...

    Please Implement this code using Java Eclipse. CIS 1068 Assignment 8 Warm Up with Objects Due: Wednesday, March 25 70 points (+ up to 15 extra credit) The purpose of this assignment is to give you practice implementing your own classes. It also provides extra practice with arrays. Task Implement a class Task, which is used to represent a job that should be done. It should contain the following private fields: .name text description of what job should be done...

  • 3. Illinois Furniture, Inc., produces all types of office furniture. The "Executive Secretary” is a chair...

    3. Illinois Furniture, Inc., produces all types of office furniture. The "Executive Secretary” is a chair that has been designed using ergonomics to provide comfort during long work hours. The chair sells for $130. There are 480 minutes available during the day, and the average daily demand has been 48 chairs. the eight tasks required to produce the chair and the precedence diagram are shown below TASK PERFORMANCE TIME (min) ULUI Precedence diagram a. What is the cycle time for...

  • The following are three observations collected from treatment 1, five observations collected from treatment 2, and...

    The following are three observations collected from treatment 1, five observations collected from treatment 2, and four observations collected from treatment 3. Test the hypothesis that are equal at the 0.05 significance level. Treatment 1__ Treatment 2__ Treatment 3 8 __________ 3________ 3 11__________ 2________ 4 10__________ 1________ 5 0___________3_________ 4 0___________ 2________ 0 a-1. State the null hypothesis and the alternate hypothesis. b. What is the decision rule? c. Compute SST, SSE, and SS total. d. Complete an ANOVA...

  • Case Studies Jackson Manufacturing Company Kathleen McFadden, vice president of operations at Jackson Manufacturing Company, has...

    Case Studies Jackson Manufacturing Company Kathleen McFadden, vice president of operations at Jackson Manufacturing Company, has just received a request for quote (RFQ) from DeKalb Electric Supply for 400 units per week of a motor armature. The components are standard and either easy to work into the existing production schedule or readily available from established suppliers on a JIT basis. But there is some difference in assembly. Ms. McFadden has identified eight tasks that Jackson must perform to assemble the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT