The following data is provided for Bellingham Company DATA Resources' requirements, standard pounds per un Resources'...

Transcribed Image Text:

The following data is provided for Bellingham Company DATA Resources' requirements, standard pounds per un Resources' standard price, per pound Units produced Resources used for production, pounds Resources actual price, per pound 2.3 $3.50 15,400 35,300 $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 a. Direct materials price variance b. Direct materials quantity variance c Direct materials cost variance Amount Formulas The following data is provided for Bellingham Company DATA Resources' requirements, standard pounds per un Resources' standard price, per pound Units produced Resources used for production, pounds Resources actual price, per pound 2.3 $3.50 15,400 35,300 $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 a. Direct materials price variance b. Direct materials quantity variance c Direct materials cost variance Amount Formulas