Problem

The following data pertain to Colgate Palmolive’s liquid tilling line during the first 10...

The following data pertain to Colgate Palmolive’s liquid tilling line during the first 10 months of a particular year. The standard ratio of direct-labor hours to machine hours is 4:1. The standard direct-labor rate is $15.08.

Colgate Palmolive: Direct-Labor Efficiency Variance Data*

 

Units Produced

Machine Hours

Standard Direct Hours

Actual Director Hours

Direct-Labour Efficiency Variance

January

50,478

165.5

662.00

374.00

$ 4,343

February

31,943

100.3

401.20

214.00

2,823

March

185,179

552.0

2,208.00

1,068.00

17,191

April

212,274

713.8

2,855.20

1,495.75

20,501

May

48,390

160.0

640.00

364.00

4,162

June

82,436

232.0

928.00

536.50

5,904

July

36,208

104.0

416.00

283.00

1,003

August

33,483

96.0

384.00

317.50

837

September

31,560

96.0

384.00

328.50

837

October

28,191

72.0

288.00

158.00

1,960

*Source of data: AlanS.Levitanand SidneyJ, Baxendale, “Analyzlng the Labor Efficiency Variance to Signal Process Engineering Problems,” Journal of Cost Management 6, no.2.p.70.

Required:

1. Show how the following amounts were calculated for the month of January:

a. Standard direct-labor hours.

b. Direct-labor efficiency variance.

2. Calculate the following amounts.

a. The standard direct-labor cost for each of the 10 months.

b. For each month. 20 percent of the standard direct-labor cost.

3. Suppose management investigates all variances in excess of 20 percent of standard cost. Which variances will be investigated?

4. Suppose the standard deviation for the direct-labor efficiency variance is $5.000. Draw a statistical control chart, and plot the variance data.

5. Using the chart developed in requirement (4), which variances will be investigated?

6. The variances for March, April, and June are much larger than the others. Suggest at least one reason for this.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search