#3: MultiFactor Productivity and Normal Distribution (20 points). I'm adding onto #2 by assuming that each worker also uses company supplies to do their job, which 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 45 4 $13 $30.00 DeAndre 100 8 $16 $15.00 Susan 45 4 $13 $30.00 Selena 55 8 $11 $10.00 Serena 40 4 $12 $10.00 For this one, I want you to use Excel (see "Homework 2" file in Blackboard). a) Calculate the MultiFactor Productivity for each worker, using total dollars as the input. Write down for me what Excel formula you would use to calculate Jordan's productivity. 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