Question: please include excel formats so that I understand how to work the problem. A time study was conducted on a job that contains four elements.

please include excel formats so that I understandplease include excel formats so that I understand how to work the problem.

A time study was conducted on a job that contains four elements. The observed times and performance ratings for five cycles are shown in the following table. Note: Some of the elements occur only periodically. Observations (minutes/cycle) 1 2 4 Element 1 2 Performance Rating (%) 95 80 105 100 3 0.44 1.47 0.51 1.52 0.83 1.20 0.48 1.55 0.88 1.27 1.50 0.90 1.10 5 0.50 1.49 0.94 1.16 3 4 1.08 a. Determine the average cycle time for each element (OT). b. Find the normal time for each element. c. Assuming an allowance factor of 12 percent of job time, compute the standard time for this job. * Round your final answers to two decimal places

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!