LA D E A 1 Direct materials variances 2 3 The following data is provided for Bellingham Company: 4 5 DATA 6 Resources' requirements, standard pounds per un 23 7 Resources standard price, per pound $3.35 B Units produced 16,200 9 Resources used for production, pounds 36,800 10 Resources' actual price, per pound $3.55 11 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 calls D15:D17. Transfer the numeric results for the green entry cells (C15:C17) into the appropriate fields in CNOWV2 for grading, 12 13 14 Amount Formulas 15 a. Direct materials price variance 16. Direct materials quantity variance 17 C Direct materials cost variance 18 19 20 21 AD Direct materiais variances Bellingham Company producen a product that requires 2.3 staridard pounds per unit. The standard price is $335 per pound 15.200 units used 36,000 pounds, which were purchased at $3.55 per pound. This information has been collected in the Microsoft Excel Online file Open the spreadsheet, perform the requres anatron, and nout your newers in the questions below HHHH Donat What is the direct materials (a) pace, (b) quantity variance, and (c) van Round your answers to the restarter a favorite variance negative number using a mission and a lavorable variance as a positive number a. Direct materials price variance Unfavorable . Direct materiais quantity vonance $ Favorable Direct materials cost variance $ Unable My Wors Untevole lances can be out of sings Franco Crancestu Force between the actual and strato re Net Check My Work