Multiple$-$factor productivity assumptions:

# of workers $=120$

Pay rate $=60$ at $$18/$hour and $60$ at $$28/$hour

# of picks $=$ avg. $100$ picks per hour per worker

Errors per hour$/$chargeback $($return freight and reship cost$)=11\%$ error rate per hour and the chargeback calculation is $$11$ per picked error.

$($Note: $11\%\backslash$times $100$ picks $\backslash$times $$11$ per picked error $\backslash$times $8$ hours per shift $\backslash$times $20$ shifts per month $\backslash$times $60$ pickers $=$ $$1,161,600$ per month$)$

Multiple$-$factor productivity assumptions with robots:

# of workers $=60$

Pay rate $=$ avg. $$32/$hour

# of picks $=$ avg. $360$ picks per hour per worker

Errors per hour$/$chargeback $=0$ errors

Lease per robot $=$ $$2,400/$month

# of robots $=35$

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations.

Questions

Calculate productivity for the private warehouse comparing existing productivity and productivity if robots were leased. Round your answers to two decimal places.