Instructions

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.

2. 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. On the basis of your calculations, what can you conclude about crew size and productivity?

3. Compute the multifactor productivity measure for each of the weeks shown for production of chocolate bars. What do the productivity figures suggest? Assume 40-hours work in a week and an hourly wage of $12. Overhead is 1.5 times weekly labor cost. Material cost is $6 per pound.

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

5. Page 66An operation has a 10 percent 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?

7. 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.

Unit

Employees

Customers Processed/Day

A

4

36

B

5

40

C

8

60

D

3

20

a. Compute the labor productivity and the multifactor productivity for each unit. Use an eight-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.