Materials cost variance scenario: Multiple DMs

Scenario 2: Multiple DMs

ChocoDelight Cookies produces gourmet chocolate chip cookies. The production process uses two types of direct materials: premium chocolate chips (Material A) and organic flour (Material B). The company’s production standards and actual results for a recent batch are outlined below.

To produce 1,000 cookies, the following usage and cost standards apply:

• Material A: 5 kilograms per 1,000 cookies at $10 per kilogram
• Material B: 8 kilograms per 1,000 cookies at $5 per kilogram

Actual results for the recent batch were 1,500 cookies were produced:

• Material A: 6 kilograms at $12 per kilogram
• Material B: 15 kilograms at $6 per kilogram

Calculate the Direct Materials variances:

1. Materials price variance
2. Materials usage variance
3. Materials mix variance
4. Materials yield variance
5. Materials cost variance

If you would like to check the over-all solution, you can skip to the Scenario summary section at the end of this page.

As discussed previously, the expected production in the master budget of 1,000 cookies will not be very relevant in the computation of the variances as we will focus on the actual production.

Scenario 2.1. Materials price variance

We need to get the total of the price variances of each direct material.

$$\begin{array}{rl}\text{Materials Price Variance Material A}& =(\text{SP}\times \text{AQ})-(\text{AP}\times \text{AQ})\\ & =(10\times 6)-(12\times 6)\\ & =60-72\\ & =12(\text{U})\end{array}$$

Alternative computation:

$$\begin{array}{rl}\text{Materials Price Variance Material A}& =(\text{SP}-\text{AP})\times \text{AQ}\\ & =(10-12)\times 6\\ & =-2\times 6\\ & =12(\text{U})\end{array}$$

The variance is unfavorable because the actual price per unit of Material A ($12) is higher than standard price ($10). $\text{Actual Quantity (AQ)}$ of Material A is already available at 6 kilograms and does not need further computations.

$$\begin{array}{rl}\text{Materials Price Variance Material B}& =(\text{SP}\times \text{AQ})-(\text{AP}\times \text{AQ})\\ & =(5\times 15)-(6\times 15)\\ & =75-90\\ & =15(\text{U})\end{array}$$

Alternative computation:

$$\begin{array}{rl}\text{Materials Price Variance Material B}& =(\text{SP}-\text{AP})\times \text{AQ}\\ & =(5-6)\times 15\\ & =-1\times 15\\ & =15(\text{U})\end{array}$$

The variance is unfavorable because the actual price per unit of Material B ($6) is higher than standard price ($5). $\text{Actual Quantity (AQ)}$ of Material B is already available at 15 kilograms and does not need further computations.

$$\begin{array}{rl}\text{Materials Price Variance}& =\text{Materials Price Variance Material A}+\text{Materials Price Variance Material B}\\ & =12(\text{U})+15(\text{U})\\ & =27(\text{U})\end{array}$$

Scenario 2.2. Materials usage variance

The $\text{Standard Quantity (SQ)}$ to be used here is not the one in the master budget but the standard quantity that would have been used by the actual production of 1,500 cookies. The following are the $\text{SQ}$ for both Material A and B:

$$\text{SQ Material A}=5\text{ kg}\times (1,500\text{ cookies}/1,000\text{ cookies})=7.5\text{ kg}$$

$$\text{SQ Material B}=8\text{ kg}\times (1,500\text{ cookies}/1,000\text{ cookies})=12\text{ kg}$$

$$\text{SQ}=\text{SQ Material A}+\text{SQ Material B}=19.5\text{ kg}$$

After the $\text{Standard Quantity (SQ)}$ is determined, we need to get the total of the usage variances of each direct material.

$$\begin{array}{rl}\text{Materials Usage Variance Material A}& =(\text{SP}\times \text{SQ})-(\text{SP}\times \text{AQ})\\ & =(10\times 7.5)-(10\times 6)\\ & =75-60\\ & =15(\text{F})\end{array}$$

Alternative computation:

$$\begin{array}{rl}\text{Materials Usage Variance Material A}& =(\text{SQ}-\text{AQ})\times \text{SP}\\ & =(7.5-6)\times 10\\ & =1.5\times 10\\ & =15(\text{F})\end{array}$$

The variance is favorable because the actual Material A used by production (6 kg) is lower than standard (7.5 kg).

$$\begin{array}{rl}\text{Materials Usage Variance Material B}& =(\text{SP}\times \text{SQ})-(\text{SP}\times \text{AQ})\\ & =(5\times 12)-(5\times 15)\\ & =60-75\\ & =15(\text{U})\end{array}$$

Alternative computation:

$$\begin{array}{rl}\text{Materials Usage Variance Material B}& =(\text{SQ}-\text{AQ})\times \text{SP}\\ & =(12-15)\times 5\\ & =-3\times 5\\ & =15(\text{U})\end{array}$$

The variance is unfavorable because the actual Material B used by production (15 kg) is higher than standard (12 kg).

$$\begin{array}{rl}\text{Materials Usage Variance}& =\text{Materials Usage Variance Material A}+\text{Materials Usage Variance Material B}\\ & =15(\text{F})+15(\text{U})\\ & =0\end{array}$$

The favorable usage variance of Material A was offset by the unfavorable variance of Material B. This total usage variance can be verified by the computation of the Materials Mix and Materials Yield Variances which will be shown below.

Scenario 2.3. Materials mix variance

When faced with such problems, candidates need to determine the inputs that will be needed in the computations of the variances. Most notably for mix variances, we need to determine the following for each material used in production:

• Standard Mix (SM)
• Actual Mix (AM)
• Actual Materials Used (AMU)

$\text{Standard Mixes (SM)}$, the total of which should be 100%:

$$\text{SM Material A}=5\text{ kg}/(5\text{ kg}+8\text{ kg})=38.46\%$$

$$\text{SM Material B}=8\text{ kg}/(5\text{ kg}+8\text{ kg})=61.54\%$$

$\text{Actual Mixes (AM)}$, the total of which should be 100%:

$$\text{AM Material A}=6\text{ kg}/(6\text{ kg}+15\text{ kg})=28.57\%$$

$$\text{AM Material B}=15\text{ kg}/(6\text{ kg}+15\text{ kg})=71.43\%$$

$\text{Actual Materials Used (AMU)}$ will be total of the actual of Material A (6 kg) and Material B (15 kg), or $21\text{ kg}$, used in producing the 1,500 cookies.

Once all the above are determined, we can continue calculating the variances for separately for each direct material.

$$\begin{array}{rl}\text{Materials Mix Variance Material A}& =((\text{AMU}\times \text{SM})-(\text{AMU}\times \text{AM}))\times \text{SP}\\ & =((21\times 38.46\%)-(21\times 28.57\%))\times 10\\ & =(8.08-6)\times 10\\ & =2.08\times 10\\ & =20.8(\text{F})\end{array}$$

The favorable variance of $20.8 indicates that less Material A was used than expected in the standard mix, resulting in cost savings.

$$\begin{array}{rl}\text{Materials Mix Variance Material B}& =((\text{AMU}\times \text{SM})-(\text{AMU}\times \text{AM}))\times \text{SP}\\ & =((21\times 61.54\%)-(21\times 71.53\%))\times 5\\ & =(12.92-15)\times 5\\ & =-2.08\times 5\\ & =10.4(\text{U})\end{array}$$

The unfavorable variance of $10.4 shows that more Material B was used than expected in the standard mix, leading to higher costs.

$$\begin{array}{rl}\text{Materials Mix Variance}& =\text{Materials Mix Variance Material A}+\text{Materials Mix Variance Material B}\\ & =20.8(\text{F})+10.4(\text{U})\\ & =10.4(\text{F})\end{array}$$

Scenario 2.4. Materials yield variance

We will use the same mixes ($\text{SM}$ and $\text{AM}$) computed before.

The $\text{Standard Material Used (SMU)}$ is the total $\text{Standard Quantities (SQ)}$ for both materials: $Material A (7.5 kg) + Material B (12 kg) = $19.5\text{ kg}$. Please refer to the Materials Usage Variance for explanation of how this was determined.

$$\begin{array}{rl}\text{Materials Yield Variance Material A}& =((\text{SMU}\times \text{SM})-(\text{AMU}\times \text{SM}))\times \text{SP}\\ & =((19.5\times 38.46\%)-(21\times 38.46\%))\times 10\\ & =(7.5-8.08)\times 10\\ & =-0.58\times 10\\ & =5.8(\text{U})\end{array}$$

The unfavorable variance of $5.8 indicates that the overall production process required more input than expected, and Material A’s portion of the excess input increased costs.

$$\begin{array}{rl}\text{Materials Yield Variance Material B}& =((\text{SMU}\times \text{SM})-(\text{AMU}\times \text{SM}))\times \text{SP}\\ & =((19.5\times 61.54\%)-(21\times 61.54\%))\times 5\\ & =(12.92-12.92)\times 5\\ & =-0.92\times 5\\ & =4.6(\text{U})\end{array}$$

The unfavorable variance of $4.6 reflects that additional input was used in production, with Material B’s share contributing to higher costs.

$$\begin{array}{rl}\text{Materials Yield Variance}& =\text{Materials Yield Variance Material A}+\text{Materials Yield Variance Material B}\\ & =5.8(\text{U})+4.6(\text{U})\\ & =10.4(\text{U})\end{array}$$

We can also verify the Materials Usage Variance computed in 2.2:

$$\begin{array}{rl}\text{Materials Usage Variance}& =\text{Material Mix Variance}+\text{Material Yield Variance}\\ & =10.4(\text{F})+10.4(\text{U})\\ & =0\end{array}$$

Scenario 2.5. Direct Material cost variance

The material cost variance can be computed by adding up the price and the usage variances:

$$\begin{array}{rl}\text{Material Cost Variance}& =\text{Material Price Variance}+\text{Material Usage Variance}\\ & =27(\text{U})+0\\ & =27(\text{U})\end{array}$$

Alternatively, we can also use the cost variances per type of DM and we should get the same answer:

$$\begin{array}{rl}\text{Material Cost Variance Material A}& =(\text{SQ}\times \text{SP})-(\text{AQ}\times \text{AP})\\ & =(7.5\times 10)-(6\times 12)\\ & =75-72\\ & =3(\text{F})\end{array}$$

$$\begin{array}{rl}\text{Material Cost Variance Material B}& =(\text{SQ}\times \text{SP})-(\text{AQ}\times \text{AP})\\ & =(12\times 5)-(15\times 6)\\ & =60-90\\ & =30(\text{U})\end{array}$$

$$\begin{array}{rl}\text{Material Cost Variance}& =\text{Material Cost Variance Material A}+\text{Material Cost Variance Material B}\\ & =3(\text{F})+30(\text{U})\\ & =27(\text{U})\end{array}$$

Scenario summary

The following illustration shows the summary of the variances for Scenario 2: