A job was timed for 60 cycles

Problems

Work through the problems in Excel. Enter your answers in the following

Attach your Word file and Excel spreadsheet where indicated. YOU MUST SUBMIT YOUR EXCEL SPREADSHEET OR OTHER WORK IN ORDER TO RECEIVE CREDIT FOR THE ASSIGNMENT. FAILURE TO SUBMIT THE EXCEL SPREADSHEET OR OTHER WORK WILL RESULT IN A GRADE OF 0.

Therefore, complete all of the problems in Excel, and then enter your answers and upload your Excel file. Allow excel to work the problems and include formulas in the excel spreadsheet.

Top of Form

Flag this Question

Question 1 10 pts

A job was timed for 60 cycles and had an average of 1.2 minutes per piece. The performance rating was 95 percent, and workday allowances are 10 percent. Determine each of the following:

1. Observed time: minutes (round to one decimal place)

2. Normal time: minutes (round to two decimal places)

3. Standard time: minutes (round to two decimal places)

Flag this Question

Question 2 10 pts

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.

OBSERVATIONS (minutes per cycle)

Element

Performance Rating

1

2

3

4

5

6

1

90%

0.44

0.50

0.43

0.45

0.48

0.46

2

85

1.50

1.54

1.47

1.51

1.49

1.52

3

110

0.84

0.89

0.77

0.83

0.85

0.80

4

100

1.10

1.14

1.08

1.20

1.16

1.26

1. Determine the average cycle time for each element. Round to two decimal places.

Element 1 minutes

Element 2 minutes

Element 3 minutes

Element 4 minutes

2. Find the normal time for each element.

Element 1 minutes

Element 2 minutes

Element 3 minutes

Element 4 minutes

3. Assuming an allowance factor of 15 percent of job time, compute the standard time for this job. Round to two decimal places.

Standard time minutes

Flag this Question

Question 3 10 pts

Given these observed times (in minutes) for four elements of a job, determine the observed time (OT) for each element. Note: The second element only occurs every other cycle. Round to two decimal places.

Cycle

Element

1

2

3

4

5

6

1

4.1

4.0

4.2

4.1

4.1

4.1

2

-

1.5

-

1.6

-

1.4

3

3.2

3.2

3.3

3.2

3.3

3.3

4

2.7

2.8

2.7

2.8

2.8

2.8

Element 1 minutes

Element 2 minutes

Element 3 minutes

Element 4 minutes

Flag this Question

Question 4 10 pts

A worker-machine operation was found to involve 3.3 minutes of machine time per cycle in the course of 40 cycles of stopwatch study. The worker’s time averaged 1.9 minutes per cycle, and the worker was given a rating of 120 percent (machine rating is 100 percent). Midway through the study, the worker took a 10-minute rest break. Assuming an allowance factor of 12 percent of work time, determine the standard time for this job. Round to two decimal places.

Flag this Question

Question 5 10 pts

The following data were obtained by observing a three-step job of a financial manager’s assistant.

1. Using the data and an allowance of 10 percent of job time, determine a standard time for the operation. minutes (Round to two decimal places.)

2. Determine the number of observations that would be required to estimate the mean time for the first element within 4 percent of the true value with a confidence of 98 percent.

3. How many observations would be needed to estimate the mean time for element C to within 0.10 minutes of its actual value with a confidence of 90 percent?

OBSERVATIONS (minutes per cycle)

Element

Performance Rating

1

2

3

4

5

A

90%

1.40

1.42

1.39

1.38

1.41

B

120

2.10

2.05

2.00

1.85

1.80

C

110

1.60

1.40

1.50

1.45

1.55

Flag this Question

Question 6 10 pts

How many observations should a time study analyst plan for in an operation that has a standard deviation of 1.5 minutes per piece if the goal is to estimate the mean time per piece to within 0.4 minute with a confidence of 95.5 percent?

Flag this Question

Question 7 0 pts

Upload your work here as one file. You must include your work in order to receive credit for this assignment. Thank you!

Upload