Standard material price and usage

	Kg	Std. price	$
Material A	5	6	30.00
Material B	9	10	90.00
Material C	8	9	72.00
	22		192.00

The budget and actual units produced for last month was 10,000

Actual materials used and prices for last month were as follows:

	Kg Used	Actual price	Total $
Material A	45,000	5.34	240300.00
Material B	108,000	8.90	961200.00
Material C	64,000	8.01	512640.00
	217,000

a)

Based on the data given above, complete the table below to calculate the materials price and usage variance for each of material A, B and C and the total materials price variance.

Price variance

	Actual price	Std. price	Actual KG used	Variance $
Material A
Material B
Material C
Total

Usage variance

	Actual Qty	Std. Qty.	Std. Price	Variance $
Material A
Material B
Material C
Total

b)

Based on the data given above, complete the table below to calculate the materials mix variance for each of material A, B and C and the total materials mix variance.

Materials Mix variance

	Actual Qty	Actual Qty. Standard Mix	Std. Price	Variance $
Material A
Material B
Material C
Total

c)

Based on the data given above, complete the table below to calculate the materials yield variance.

Materials Yield variance

Std. material cost per Product
Actual Yield of product for Kg input
Standard Yield of product for Kg input
Materials Yield variance