Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following information is provided. Single - factor productivity assumptions: # of workers = 1 2 0 ( 6 0 dedicated pickers, 3 0 material
The following information is provided. Single factor productivity assumptions: # of workers dedicated pickers, material handlers, crew leaders and utility associates Pay rate at $ hour and at $ hour # of picks avg picks per hour per worker Multiple factor productivity assumptions: # of workers Pay rate at $ hour and at $ hour # of picks avg picks per hour per worker Errors per hour chargeback return freight and reship cost error rate per hour and the chargeback calculation is $ per picked error. Note: times picks times $ per picked error times hours per shift times shifts per month times pickers $ per month Damage and theft $ month Single factor productivity assumptions with robots: # of workers Pay rate avg $ hour # of picks avg picks per hour per worker Multiple factor productivity assumptions with robots: # of workers Pay rate avg $ hour # of picks avg picks per hour per worker Errors per hour chargeback errors Lease per robot $ month # of robots 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.
The following information is provided.
Single
factor productivity assumptions:
# of workers
dedicated pickers,
material handlers,
crew leaders and utility associates
Pay rate
at $
hour and
at $
hour
# of picks
avg
picks per hour per worker
Multiple
factor productivity assumptions:
# of workers
Pay rate
at $
hour and
at $
hour
# of picks
avg
picks per hour per worker
Errors per hour
chargeback
return freight and reship cost
error rate per hour and the chargeback calculation is $
per picked error.
Note:
times
picks
times $
per picked error
times
hours per shift
times
shifts per month
times
pickers
$
per month
Damage and theft
$
month
Single
factor productivity assumptions with robots:
# of workers
Pay rate
avg $
hour
# of picks
avg
picks per hour per worker
Multiple
factor productivity assumptions with robots:
# of workers
Pay rate
avg $
hour
# of picks
avg
picks per hour per worker
Errors per hour
chargeback
errors
Lease per robot
$
month
# of robots
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started