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,000lb. at $ 2.60 per lb. |
Direct material used | 23,100 lb. |
The control valve has the following standard prime costs:
Direct material: | 3lb.at $2.50 per lb | $ 7.50 |
Direct labor: | 5 hr at$15.00 per hr. | 75.00 |
Standard prime cost per unit |
| $82.50 |
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-labor rate variance.
d. 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 52.60 per pound.
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.