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. Singlefactor 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 Multiplefactor productivity assumptions: # of workers Pay rate at $hour and at $hour # of picks avg. picks per hour per worker Errors per hourchargeback 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 Singlefactor productivity assumptions with robots: # of workers Pay rate avg. $hour # of picks avg. picks per hour per worker Multiplefactor productivity assumptions with robots: # of workers Pay rate avg. $hour # of picks avg. picks per hour per worker Errors per hourchargeback 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. 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 With robots Singlefactor productivity picks per $ fill in the blank fill in the blank Overall multiplefactor productivity picks per $ fill in the blank fill in the blank What can you conclude? If robots were leased, the singlefactor productivity and the overall multiplefactor productivity
The following information is provided.
Singlefactor 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
Multiplefactor productivity assumptions:
# of workers
Pay rate at $hour and at $hour
# of picks avg. picks per hour per worker
Errors per hourchargeback 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
Singlefactor productivity assumptions with robots:
# of workers
Pay rate avg. $hour
# of picks avg. picks per hour per worker
Multiplefactor productivity assumptions with robots:
# of workers
Pay rate avg. $hour
# of picks avg. picks per hour per worker
Errors per hourchargeback 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.
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 With robots
Singlefactor productivity picks per $ fill in the blank
fill in the blank
Overall multiplefactor productivity picks per $ fill in the blank
fill in the blank
What can you conclude?
If robots were leased, the singlefactor productivity
and the overall multiplefactor productivity
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started