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. Overall multiple$-$factor productivity $($picks per $$)$ fill in the blank $4$ with robot

fill in the blank $5$ without robot