45 8 8 Problem #3: MultiFactor Productivity and Normal Distribution (20 Joints). I'm changing some of the numbers to #2 and assuming that each worker also uses company supplies to do their job. The Supply Cost should be included as part of the inputs. Orders Work Supplies Cost MultiFactor Processed Hours Salary/hr: per 4 Hours Productivity: Orders/$ Jordan 80 8 $15 $30.00 Hector 4 $13 $30.00 DeAndre 100 $16 $15.00 Susan 90 $13 $30.00 Selena 55 $11 $10.00 Erin 40 4 $12 $10.00 For this one, I want you to use Excel (see "Homework 2" file in Brightspace). a) Calculate the MultiFactor Productivity for each worker, using total dollars as the input. You can use Excel to do this. Write down for me what Excel formula you would use to calculate Susan's productivity. You are welcome to improve on my formula. b) Suppose that the company has determined that Orders/$1 is normally distributed for the workers. The Average is .60 orders/$1. If the Standard Deviation is .05, is any worker more productive than 95% of all workers? Is any worker less productive than 95% of all workers? Example as a hint: a worker whose productivity was .62 orders/$1 would have a Z = 4: that is, (.62-60)/.05 - .4. Using Normal Table, that worker was better than 65,542% of all other workers and worse than 1-.65542 of all other workers. 8