table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl21 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; background:white; mso-pattern:black none;} .xl22 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; background:white; mso-pattern:black none;} .xl23 {color:black; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; vertical-align:middle; background:white; mso-pattern:black none;} .xl24 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:#F4B084; mso-pattern:black none;} .xl25 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl27 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;} .xl28 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none;} .xl29 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none;} .xl30 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; background:white; mso-pattern:black none; white-space:normal;} .xl32 {font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl37 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; background:white; mso-pattern:black none; white-space:normal;} .xl38 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; background:white; mso-pattern:black none;} .xl40 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none;} .xl41 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl44 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl45 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; background:white; mso-pattern:black none;} .xl47 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;} .xl50 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; background:#DDEBF7; mso-pattern:black none;} .xl51 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; background:#DDEBF7; mso-pattern:black none;} .xl52 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; background:#DDEBF7; mso-pattern:black none; white-space:normal;} .xl56 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; background:#A9D08E; mso-pattern:black none;} .xl57 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; background:#A9D08E; mso-pattern:black none;} .xl62 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; background:white; mso-pattern:black none;} .xl64 {font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#DDEBF7; mso-pattern:black none; white-space:normal;}

Direct Materials Variances
The following data is provided for Alvarado Company:
DATA
Resources' requirements, standard pounds per unit	2.3
Resources' standard price, per pound	$3.75
Units produced	16,500
Resources used for production, pounds	36,600
Resources' actual price, per pound	$3.90
REQUIRED:
What is the direct materials (a) price variance, (b) quantity variance, and (c) cost variance?
Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Select the corresponding type of variance in the dropdowns in cells D15:D17. Transfer amounts to CNOWv2 for grading.
	Amount		Formulas
Direct materials price variance
Direct materials quantity variance
Direct materials cost variance