Question: 1. For the data in Problem 51, use a computer spreadsheet to find the average efficiency for each worker over the first four work centers.
1. For the data in Problem 51, use a computer spreadsheet to find the average efficiency for each worker over the first four work centers. Which worker is the least efficient? Where does this worker perform best?
2. For the data in Problem 51, use a computer spreadsheet to find the average efficiency for each work center over the first five workers. Which work center is the most efficient? Which work center should be studied for improvement?
Data in problem 51,
Work Center
.png)
1.00 0.95 0.95 0.95 0.95 0.85 0.85 0.85 0.85 0.85 1.00 0.95 0.95 0.95 0.95 0.85 0.85 0.85 W 0.85 0.85 1.00 0.95 0.95 0.95 0.95 0.85 0.85 0.85 0.85 0.85 1.00 0.95 0.95 0.95 0.95 0.85 0.85 0.85 0.85 0.85 1.00 0.95 0.95 0.95 0.95 k 0.95 0.85 0.85 0.85 0.85 1.00 0.95 0.95 0.95 0.95 0.95 0.85 0.85 0.85 0.85 1.00 0.95 0.95 0.95 0.95 0.95 0.85 0.85 0.85 0.85 1.00 0.95 0.95 0.95 0.95 0.95 0.85 0.85 0.85 0.85 1.00
Step by Step Solution
3.30 Rating (156 Votes )
There are 3 Steps involved in it
1 For each row C1 C2 C3 C4 4 average efficiency W1 09625 W2 09375 W3 0... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1386-M-C-L-A-D(2674).docx
120 KBs Word File
