BE$12\mathrm{.}4-$ Using Excel to Calculate Direct Materials Variances PROBLEM

Sprague Company's uses a standard cost system and has provided the following information for its direct materials during Julv.

Standand materials cost per unit of output

Standard materials price per $kg$

Cost of materials purchased

Standard materials quantity

Purchased and used during July

Units of finished products produced

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area with mathematical formulas in the input cells. In the last input field, input an IF function with cell references to your work area.

Calculate the total, price, and quantity materials variances. Designate if the variance is favourable or unfayourable using Excel's IF function.

Material Price Variance $,$ Actual Cost

$\backslash$table$[[$Actual Quantity at$],[$Standard Price$]]$

Please calculate all the yellow higlighted quantity