Nine observations from a work measurement study using continuous timing are shown below. Allowances are determined as: personal, five percent; fatigue, seven percent; delay, six percent. Use the Work Measurement Excel template to determine the standard time for this operation. Work Element 1 A B C D E F Observation 2 3 4 5 6 0.11 0.14 0.08 0.06 0.13 0.11 0.25 0.21 0.23 0.20 0.24 0.25 0.28 0.26 0.26 0.46 0.50 0.46 0.45 0.47 0.47 0.50 0.46 0.50 0.61 0.67 0.65 0.62 0.69 0.70 0.70 0.67 0.70 0.73 0.75 0.72 0.70 0.82 0.81 0.77 0.79 0.84 1.03 1.02 0.98 1.01 1.10 1.11 1.02 1.07 1.10 Round your answer to two decimal places. minutes 789 Performance Rating 0.15 0.14 0.15 110% 115% 100% 85% 100% 95%

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
5.
6.
O
Spreadsheet
Nine observations from a work measurement study using continuous timing are shown below. Allowances are determined as: personal, five percent; fatigue, seven
percent; delay, six percent. Use the Work Measurement Excel template to determine the standard time for this operation.
Work
Element
A
B
C
D
E
F
Round your answer to two decimal places.
minutes
Observation.
1 2 3 4 5 6
0.11 0.14 0.08 0.06 0.13 0.11
0.25 0.21 0.23 0.20
0.46 0.50 0.46 0.45 0.47
0.61 0.67 0.65 0.62 0.69
0.73 0.75 0.72 0.70
1.03 1.02 0.98 1.01 1.10
8
7
9
0.15 0.14 0.15
0.24 0.25 0.28 0.26 0.26
0.47 0.50 0.46 0.50
0.70 0.70 0.67 0.70
0.82 0.81 0.77 0.79 0.84
1.11 1.02 1.07 1.10
Performance Rating
110 %
115%
100%
85%
Hint(s) Check My Work
100%
95%
Hint(s) Check My Work
C
Transcribed Image Text:5. 6. O Spreadsheet Nine observations from a work measurement study using continuous timing are shown below. Allowances are determined as: personal, five percent; fatigue, seven percent; delay, six percent. Use the Work Measurement Excel template to determine the standard time for this operation. Work Element A B C D E F Round your answer to two decimal places. minutes Observation. 1 2 3 4 5 6 0.11 0.14 0.08 0.06 0.13 0.11 0.25 0.21 0.23 0.20 0.46 0.50 0.46 0.45 0.47 0.61 0.67 0.65 0.62 0.69 0.73 0.75 0.72 0.70 1.03 1.02 0.98 1.01 1.10 8 7 9 0.15 0.14 0.15 0.24 0.25 0.28 0.26 0.26 0.47 0.50 0.46 0.50 0.70 0.70 0.67 0.70 0.82 0.81 0.77 0.79 0.84 1.11 1.02 1.07 1.10 Performance Rating 110 % 115% 100% 85% Hint(s) Check My Work 100% 95% Hint(s) Check My Work C
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.