The weekly output of a production process is shown below, together with the data for labor and material input. The standard inventory value of the output is $125 per unit. Overhead is charged weekly at the rate of $1500 PLUS 0.5 times direct labor cost. Assume a 40-hour week and an hourly wage of $16. Material cost is $10 per running foot.

Week Output # of Workers Material (ft.)

1 412 6 2840

2 364 5 2550

3 392 5 2720

4 408 6 2790

a. Using Excel determine the total productivity for each of the week.

b. Using Excel Compute the productivity growth from week to week.