The following information is provided.

Single$-$factor productivity assumptions:

# of workers $=120(60$ dedicated pickers, $30$ material handlers, $30$ crew leaders and utility associates$)$

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

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

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$)$

Damage and theft $=$ $$5,500/$month

Single$-$factor productivity assumptions with robots:

# of workers $=60$

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

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

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.

Open spreadsheet

Questions

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

Without robots and With robots

Single$-$factor productivity $($picks per $$)$ fill in the blank $2$

fill in the blank $3$

Overall multiple$-$factor productivity $($picks per $$)$ fill in the blank $4$

fill in the blank $5$