The following information is provided.

Single

$-$

factor productivity assumptions:

# of workers

$=$

$1$

$2$

$0$

$($

$6$

$0$

$$dedicated pickers,

$3$

$0$

$$material handlers,

$3$

$0$

$$crew leaders and utility associates

$)$

Pay rate

$=$

$6$

$0$

$$at $

$1$

$8$

$/$

hour and

$6$

$0$

$$at $

$2$

$8$

$/$

hour

# of picks

$=$

$$avg$.$

$1$

$0$

$0$

$$picks per hour per worker

Multiple

$-$

factor productivity assumptions:

# of workers

$=$

$1$

$2$

$0$

Pay rate

$=$

$6$

$0$

$$at $

$1$

$8$

$/$

hour and

$6$

$0$

$$at $

$2$

$8$

$/$

hour

# of picks

$=$

$$avg$.$

$1$

$0$

$0$

$$picks per hour per worker

Errors per hour

$/$

chargeback

$($

return freight and reship cost

$)$

$=$

$1$

$1$

$\%$

$$error rate per hour and the chargeback calculation is $

$1$

$1$

$$per picked error.

$($

Note:

$1$

$1$

$\%$

$\backslash$

times

$1$

$0$

$0$

$$picks

$\backslash$

times $

$1$

$1$

$$per picked error

$\backslash$

times

$8$

$$hours per shift

$\backslash$

times

$2$

$0$

$$shifts per month

$\backslash$

times

$6$

$0$

$$pickers

$=$

$$$

$1$

$,$

$1$

$6$

$1$

$,$

$6$

$0$

$0$

$$per month

$)$

Damage and theft

$=$

$$$

$5$

$,$

$5$

$0$

$0$

$/$

month

Single

$-$

factor productivity assumptions with robots:

# of workers

$=$

$6$

$0$

Pay rate

$=$

$$avg$.$ $

$3$

$2$

$/$

hour

# of picks

$=$

$$avg$.$

$3$

$6$

$0$

$$picks per hour per worker

Multiple

$-$

factor productivity assumptions with robots:

# of workers

$=$

$6$

$0$

Pay rate

$=$

$$avg$.$ $

$3$

$2$

$/$

hour

# of picks

$=$

$$avg$.$

$3$

$6$

$0$

$$picks per hour per worker

Errors per hour

$/$

chargeback

$=$

$0$

$$errors

Lease per robot

$=$

$$$

$2$

$,$

$4$

$0$

$0$

$/$

month

# of robots

$=$

$3$

$5$

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.