Questions
Work through the homework problems in Excel. Enter your answers in the following "quiz". Attach your Word file or Excel spreadsheet where indicated. YOU MUST SUBMIT YOUR EXCEL SPREADSHEET OR OTHER WORK IN ORDER TO RECEIVE CREDIT FOR THE ASSIGNMENT. FAILURE TO SUBMIT THE EXCEL SPREADSHEET OR OTHER WORK WILL RESULT IN A GRADE OF 0.
You will only have access to the "quiz" once. Therefore, complete all of the homework problems in Excel, and then enter your answers and upload your Excel file.
Top of Form
8 pts
The manager of a crew that installs carpeting has tracked the crew's output over the past several weeks, obtaining these figures:
|
Week |
Crew Size |
Yards Installed |
|
1 |
4 |
96 |
|
2 |
3 |
72 |
|
3 |
4 |
92 |
|
4 |
2 |
50 |
|
5 |
3 |
69 |
|
6 |
2 |
52 |
Compute the labor productivity for each of the weeks.
Week 1:
Week 2:
Week 3:
Week 4:
Week 5:
Week 6:
Bottom of Form
Question 2
2 pts
On the basis of your calculations, what can you conclude about crew size and productivity?
HTML Editor Keyboard Shortcuts
Question 3
8 pts
Compute the multifactor productivity measure for each of the weeks shown for production of chocolate bars. Assume 40-hour weeks and an hourly wage of $12. Overhead is 1.5 times the weekly labor cost. Material cost is $6 per pound. Round your final answer to two decimal places.
|
Week |
Output (units) |
Workers |
Material (lbs) |
|
1 |
30,000 |
6 |
450 |
|
2 |
33,600 |
7 |
470 |
|
3 |
32,200 |
7 |
460 |
|
4 |
35,400 |
8 |
480 |
Week 1:
Week 2:
Week 3:
Week 4:
Question 4
2 pts
What do the productivity figures suggest?
Question 5
10 pts
An operation has a 10% scrap rate. As a result 72 pieces per hour are produced. What is the potential increase in labor productivity that could be achieved by eliminating the scrap?
Round your answer to one decimal place.
Question 6
10 pts
The following table shows data on the average number of customers processed by several bank service units each day. The hourly wage rate is $25, the overhead rate is 1.0 times labor cost, and material cost is $5 per customer.
a. Compute the labor productivity and the multifactor productivity for each unit. Use an 8-hour day for multifactor productivity.
b. Suppose a new, more standardized procedure is to be introduced that will enable each employee to process one additional customer per day. compute the expected labor and multifactor productivity rates for each unit.
Round to two decimal places for the labor productivity rates. Round to three decimal places for the multifactor productivity rates.
|
Unit |
Employees |
Customers Processed/Day |
Labor Productivity |
Multifactor Productivity |
New Labor Productivity |
New Multifactor Productivity |
|
A |
4 |
36 |
|
|
|
|
|
B |
5 |
40 |
|
|
|
|
|
C |
8 |
60 |
|
|
|
|
|
D |
3 |
20 |
|
|
|
|