Problem #2: Let's return to our warehouse problem from the video with the same six workers as before, same day, but with financial data as well, showing how much they get paid. (20 points) Productivity Jordan Hector DeAndre Susan Selena Erin Orders Processed 80 45 50 90 55 40 Customer Type Blue Red Red Red Blue Blue Hours Worked 8 4 4 8 8 4 Salary/hr: $15 $13 $15 $13 $11 $12 a) Compute the productivity of each worker, in terms of capital (Orders per $1 of wages paid to the worker). Hint: Your answers should be in the form of "Joe's productivity is.85 orders for every $1 Joe earns." Show answer in table, and do a few of your calculations in this space so I can see them. Suppose that there are two managers, one who manages workers who serve Blue-type customers, the other Red-type customers. Suppose that a careless manager left a filled out print-out of the above table on the printer, where workers found it. Which group will feel most underpaid, Blue or Red? Explain why those workers would be angry, based on part a) results. Your answer should be 3-4 sentences. Orders Processed Work Hours Salary/hr: Supplies Cost per 4 Hours 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 #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