ACC 202 BE.09.01.EXCEL.ALGO EXCEL SPREADSHEET Direct Materials Variance

LU Direct materials variances The following data is provided for Bellingham Company: DATA Resources' requirements, standard pounds per un 2.3 Resources' standard price, per pound $3.55 Units produced 15,500 Resources used for production, pounds 35,500 Resources' actual price, per pound $3.70 Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the Amount column. Select the corresponding type of variance in the dropdowns in cells D15:D17. Transfer the numeric results for the green entry cells (C15:C17) into the appropriate fields in CNOWv2 for grading. Amount Formulas un Direct materials price variance Direct materials quantity variance Direct materials cost variance