Assume you are a manager at ACME Co. and you have three direct reports. It's time...

  

Transcribed Image Text:

Assume you are a manager at ACME Co. and you have three direct reports. It's time for the 6 month review and you have to decide how well your employees are doing. Because ACME Co is a systematic place, your boss will want to see some data to back up your views. To help you assess your employees, ACME Co provides you with a report of monthly productivity results (units of production) for each of your reports. Calculate the productivity growth over the semi-annual review periods for each of the three employees. Explain how and why you chose the calculation you did. Some things you may want to consider: • What is the nature of the data you are dealing with? • How do you think through the period over which to calculate the growth? • What are the potential drawbacks to your chosen calculation? Next, your boss asks you to forecast productivity forward for the next 24 months for each of three employees. Explain how and why you chose the calculation you did. Some intermediary questions you will want to consider: • What do you think is true about the typical productivity profile for an employee over the course of his/her career? • How would you incorporate this understanding into your forecast and its implementation? 1/31/08 2/29/08 3/31/08 4/30/08 5/31/08 6/30/08 7/31/08 8/31/08 9/30/08 10/31/08 11/30/08 12/31/08 1/31/09 2/28/09 3/31/09 4/30/09 5/31/09 6/30/09 7/31/09 8/31/09 9/30/09 10/31/09 11/30/09 12/31/09 1/31/10 2/28/10 3/31/10 4/30/10 5/31/10 6/30/10 7/31/10 8/31/10 9/30/10 10/31/10 11/30/10 12/31/10 1/31/11 2/28/11 3/31/11 4/30/11 5/31/11 6/30/11 7/31/11 8/31/11 9/30/11 10/31/11 11/30/11 12/31/11 1/31/12 Employee 1 Units Per Month 45.68 46.13 40.25 38.34 38.55 38.49 40.53 40.92 48.39 45.50 44.61 50.10 59.40 48.15 37.57 55.98 62.98 60.26 62.55 62.88 55.29 52.74 52.83 52.60 54.97 55.30 64.27 60.59 59.35 65.84 76.87 63.19 50.41 72.25 80.42 77.02 79.56 79.79 70.72 67.61 67.60 67.23 69.87 70.15 80.42 76.04 77.07 78.20 #N/A Employee 2 Units Per Month 10.89 13.70 14.84 18.17 19.43 19.02 20.99 24.95 26.87 29.03 19.97 34.32 34.80 33.61 39.30 39.11 44.00 45.69 42.63 45.12 51.74 49.50 42.32 58.52 49.53 54.75 59.58 63.76 67.97 65.45 70.64 70.27 70.08 75.05 75.36 76.98 68.91 83.84 84.31 67.09 77.39 77.42 80.93 80.93 73.35 74.46 75.05 74.80 #N/A Employee 3 Units Per Month 0.00 10.02 14.85 20.88 22.09 27.53 28.32 30.96 32.52 32.57 34.92 36.61 36.37 38.59 40.37 41.14 42.38 42.52 45.14 47.17 44.70 44.88 45.43 48.61 46.50 49.77 49.57 48.82 51.40 50.33 51.94 51.95 51.12 55.84 54.61 54.77 56.01 56.98 55.17 62.55 59.05 60.54 62.41 60.33 61.93 60.23 60.00 62.65 #N/A Assume you are a manager at ACME Co. and you have three direct reports. It's time for the 6 month review and you have to decide how well your employees are doing. Because ACME Co is a systematic place, your boss will want to see some data to back up your views. To help you assess your employees, ACME Co provides you with a report of monthly productivity results (units of production) for each of your reports. Calculate the productivity growth over the semi-annual review periods for each of the three employees. Explain how and why you chose the calculation you did. Some things you may want to consider: • What is the nature of the data you are dealing with? • How do you think through the period over which to calculate the growth? • What are the potential drawbacks to your chosen calculation? Next, your boss asks you to forecast productivity forward for the next 24 months for each of three employees. Explain how and why you chose the calculation you did. Some intermediary questions you will want to consider: • What do you think is true about the typical productivity profile for an employee over the course of his/her career? • How would you incorporate this understanding into your forecast and its implementation? 1/31/08 2/29/08 3/31/08 4/30/08 5/31/08 6/30/08 7/31/08 8/31/08 9/30/08 10/31/08 11/30/08 12/31/08 1/31/09 2/28/09 3/31/09 4/30/09 5/31/09 6/30/09 7/31/09 8/31/09 9/30/09 10/31/09 11/30/09 12/31/09 1/31/10 2/28/10 3/31/10 4/30/10 5/31/10 6/30/10 7/31/10 8/31/10 9/30/10 10/31/10 11/30/10 12/31/10 1/31/11 2/28/11 3/31/11 4/30/11 5/31/11 6/30/11 7/31/11 8/31/11 9/30/11 10/31/11 11/30/11 12/31/11 1/31/12 Employee 1 Units Per Month 45.68 46.13 40.25 38.34 38.55 38.49 40.53 40.92 48.39 45.50 44.61 50.10 59.40 48.15 37.57 55.98 62.98 60.26 62.55 62.88 55.29 52.74 52.83 52.60 54.97 55.30 64.27 60.59 59.35 65.84 76.87 63.19 50.41 72.25 80.42 77.02 79.56 79.79 70.72 67.61 67.60 67.23 69.87 70.15 80.42 76.04 77.07 78.20 #N/A Employee 2 Units Per Month 10.89 13.70 14.84 18.17 19.43 19.02 20.99 24.95 26.87 29.03 19.97 34.32 34.80 33.61 39.30 39.11 44.00 45.69 42.63 45.12 51.74 49.50 42.32 58.52 49.53 54.75 59.58 63.76 67.97 65.45 70.64 70.27 70.08 75.05 75.36 76.98 68.91 83.84 84.31 67.09 77.39 77.42 80.93 80.93 73.35 74.46 75.05 74.80 #N/A Employee 3 Units Per Month 0.00 10.02 14.85 20.88 22.09 27.53 28.32 30.96 32.52 32.57 34.92 36.61 36.37 38.59 40.37 41.14 42.38 42.52 45.14 47.17 44.70 44.88 45.43 48.61 46.50 49.77 49.57 48.82 51.40 50.33 51.94 51.95 51.12 55.84 54.61 54.77 56.01 56.98 55.17 62.55 59.05 60.54 62.41 60.33 61.93 60.23 60.00 62.65 #N/A

Answer rating: 100% (QA)

Here is my analysis of the employee productivity data To calculate productivity growth for the semiannual review I chose to look at the percentage cha... View the full answer