Please note:

In general, when they are areas highlighted, they indicate they should be filled

Part of this exercise is not only to help you better understand the material but to use excel skills. To that end, please use excel formulas $($e$.$g$.,"$@SUM$($B$1$:G$4)")$ to complete this. This is essentially showing your work and a chance to use your excel skills. Points will be deducted for not using excel formulas.The following table shows data on the average number of customers processed by several bank ser vice units each day. The hourly wage rate is $$25,$

the overhead rate is $1\mathrm{.}0$ times labor cost, and mate rial cost is $$5$ per customer.

a$.$ Compute the labor productivity and the multifactor productivity for each unit. Use an eight$-$hour

day for multifactor productivity.

b$.$ What conclusion do you make from part a$.?$

c$.$ Suppose a new, more standardized procedure is to be introduced that will enable each employee

to process one additional customer per day. Compute the expected labor and multifactor produc tivity rates for each unit.