New Jersey Valve Company manufactured 7,800 units during January of a control valve used by milk processors in its Camden plant. Records indicated the following:

Direct labor ............................................................................................................................... 40,100 hr. at $14.60 per hr.
Direct material purchased ....................................................................................................... 25,000 lb. at $2.60 per lb.
Direct material used ................................................................................................................. 23,100 lb.

The control valve has the following standard prime costs:

Required:
1. Prepare a schedule of standard production costs for January, based on actual production of 7,800 units.
2. For the month of January, compute the following variances, indicating whether each is favorable or unfavorable.

a. Direct-material price variance.

b. Direct-material quantity variance.

c. Direct-material purchase price variance.

d. Direct-labor rate variance.

e. Direct-labor efficiency variance.
3. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements.
Show how the solution will change if the following information changes: the standard direct-labor rate is $16 per hour, and the standard direct-material price is $2.60 per pound

Transcribed Image Text:

Direct material: Direct labor: 3 lb. at $2.50 per lb. 5 hr. at $15.00 per hr Standard prime cost per unit $ 7.50 75.00 $82.50