In: Accounting
Direct Materials, Direct Labor, and Factory Overhead Cost Variance Analysis
Mackinaw Inc. processes a base chemical into plastic. Standard costs and actual costs for direct materials, direct labor, and factory overhead incurred for the manufacture of 78,000 units of product were as follows:
Standard Costs | Actual Costs | ||
Direct materials | 226,200 lbs. at $5.30 | 223,900 lbs. at $5.10 | |
Direct labor | 19,500 hrs. at $16.60 | 19,950 hrs. at $17.00 | |
Factory overhead | Rates per direct labor hr., | ||
based on 100% of normal | |||
capacity of 20,350 direct | |||
labor hrs.: | |||
Variable cost, $4.30 | $83,010 variable cost | ||
Fixed cost, $6.80 | $138,380 fixed cost |
Each unit requires 0.25 hour of direct labor.
Required:
a. Determine the direct materials price variance, direct materials quantity variance, and total direct materials cost variance. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.
Direct Material Price Variance | $ | |
Direct Materials Quantity Variance | $ | |
Total Direct Materials Cost Variance | $ |
b. Determine the direct labor rate variance, direct labor time variance, and total direct labor cost variance. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.
Direct Labor Rate Variance | $ | |
Direct Labor Time Variance | $ | |
Total Direct Labor Cost Variance | $ |
c. Determine variable factory overhead controllable variance, the fixed factory overhead volume variance, and total factory overhead cost variance. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.
Variable factory overhead controllable variance | $ | |
Fixed factory overhead volume variance | $ | |
Total factory overhead cost variance | $ |
a) | ||
D.mat price variance= | AQ*SP-AQ*AP | |
D.mat price variance= | 223900*5.30-223900*5.10 | |
D.mat price variance= | $ (44,780) | Favourable |
D.mat quantity variance= | SQ*SP-AQ*SP | |
D.mat quantity variance= | 226,200*5.30-223900*5.30 | |
D.mat quantity variance= | $ (12,190.00) | Favourable |
Total Direct Materials Cost Variance= | SQ*SP-AQ*AP | |
Total Direct Materials Cost Variance= | 226,200*5.30-223900*5.10 | |
Total Direct Materials Cost Variance= | $ (56,970.00) | Favourable |
b) | ||
D.LABOR RATE variance= | AH*SR-AH*AR | |
D.LABOR RATE variance= | 19,950*16.60-19,950*17.00 | |
D.LABOR RATE variance= | $ 7,980 | UnFavourable |
D.LABOR TIME variance= | SH*SR-AH*SR | |
D.LABOR TIME variance= | 19,500*16.60-19,950*16.60 | |
D.LABOR TIME variance= | $ 7,470 | UnFavourable |
Total Direct LABOR Cost Variance= | SH*SR-AH*AR | |
Total Direct LABOR Cost Variance= | 19,500*16.60-19,950*17.00 | |
Total Direct LABOR Cost Variance= | $ 15,450 | UnFavourable |
c) | ||
Variable factory OH controllable variance= | Actual VOH-Budgeted VOH | |
Variable factory OH controllable variance= | 83,010-19,500*4.30 | |
Variable factory OH controllable variance= | $ (840) | Favourable |
Fixed OH volume variance= | Absorbed Fixed OH-Budgeted Fixed OH | |
Fixed OH volume variance= | Actual units*Absorbtion rate-Budgeted units*absorbtion rate | |
Absorbtion rate= | Fixed cost per hour*0.25 | |
Absorbtion rate= | 6.80*0.25= $ 1.70 | |
Fixed OH volume variance= | 78000*1.70-78000*1.70 | |
Fixed OH volume variance= | 0 | |
No Fixed OH volume variance exists because actual output = budgeted output | ||
Total factory overhead cost variance= | Total Variable OH variance + Total Fixed OH variance | |
Total Variable OH variance= | Actual Variable OH - budgeted Variable OH | |
Total Variable OH variance= | 83010-19,500*4.30 | |
Total Variable OH variance= | $ (840) | Favourable |
Total Fixed OH variance= | Actual Fixed OH-Absorbed Fixed OH | |
Total Fixed OH variance= | 138380-78000*1.70 | |
Total Fixed OH variance= | $ 5,780 | UnFavourable |
Total factory overhead cost variance= | $ 4,940 | UnFavourable |