Question: asap please . please do both A and B please . thank you excel data file The following table shows data on the average number

asap please .
please do both A and B please .
thank you  asap please . please do both A and B please .
thank you excel data file The following table shows data on the
average number of customers processed by several bank service units each day.excel data file

The following table shows data on the average number of customers processed by several bank service units each day. The hourly wage rate is $20, the overhead rate is 1.25 times labor cost, and materlal cost is $4 per customer. Click here for the Excel Data File a. Compute the labor productivity and the multifactor productivity for each unit. Use an eight-hour day for multifactor productivity. (Round your "Labor Productivity" answers to 1 decimal place and "Multifactor Productivity" answers to 3 decimal places.) b. 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 productivity rates for each unit. (Round your "Labor Productivity" answers to 1 decimal place and "Multifactor Productivity" answers to 3 decimal places.) \begin{tabular}{|c|c|c|} \hline Unit & Employees & \begin{tabular}{c} Customers/ \\ Process Per \\ day \end{tabular} \\ \hline A & 3 & 38 \\ \hline B & 6 & 45 \\ \hline C & 6 & 58 \\ \hline D & 4 & 32 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!