| Key in the information as needed and review the highlighted variances |
| Variance Analysis |
| | Materials |
| Actual Price |
| Standard Price |
| Actual Quantity (for all devices) |
| Standard Quantity (for all devices) |
| | Labor |
| Actual Rate |
| Standard Rate |
| Actual Hours (for all devices) |
| Standard Hours (for all devices) |
| (1) | Total Materials Variance |
| Actual Quantity | | Standard Quantity | | Variance | Favorable/ Unfavorable |
| Actual Price | | Standard Price |
| Total (Quant * Price) | | Total (Quant * Price) |
| (a) | Materials Price Variance |
| Actual Quantity | | Actual Quantity | | Variance | Favorable/ Unfavorable |
| Actual Price | | Standard Price |
| Total (Quant * Price) | | Total (Quant * Price) |
| (b) | Materials Quantity Variance |
| Actual Quantity | | Standard Quantity | | Variance | Favorable/ Unfavorable |
| Standard Price | | Standard Price |
| Total (Quant * Price) | | Total (Quant * Price) |
| (2) | Total Labor Variance |
| Actual Hours | | Standard Hours | | Variance | Favorable/ Unfavorable |
| Actual Rate | | Standard Rate |
| Total (Hr * Rate) | | Total (Hr * Rate) |
| (a) | Labor Price Variance |
| Actual Hours | | Actual Hours | | Variance | Favorable/ Unfavorable |
| Actual Rate | | Standard Rate |
| Total (Hr * Rate) | | Total (Hr * Rate) |
| (b) | Labor Quantity Variance |
| Actual Hours | | Standard Hours | | Variance | Favorable/ Unfavorable |
| Standard Rate | | Standard Rate |
| Total (Hr * Rate) | | Total (Hr * Rate) |
dhriase
Week6CaseExceltemplate.xlsx
