Question

In: Accounting

Calculating the Direct Materials Price Variance and the Direct Materials Usage Variance 9.1: Guillermo has found...

Calculating the Direct Materials Price Variance and the Direct Materials Usage Variance

9.1: Guillermo has found a typical oil change takes 24 minutes and 6.2 quarts of oil are used. In June, Guillermo had 980 oil changes.

Refer to Exercise 9.1. Guillermo's Oil and Lube Company provided the following information for the production of oil changes during the month of June:

Actual number of oil changes performed: 980

Actual number of quarts of oil used: 6020 quarts

Actual price paid per quart of oil: $5.1

Standard price per quart of oil: $5.05

Required:

1. Calculate the direct materials price variance (MPV) and the direct materials usage variance (MUV) for June using the formula approach.

2. Calculate the direct materials price variance (MPV) and the direct materials usage variance (MUV) for June using the graphical approach.

3. Calculate the total direct materials variance for oil for June.

4. What if the actual number of quarts of oil purchased in June had been 6100 quarts, and the materials price variance was calculated at the time of purchase? What would be the materials price variance (MPV)? The materials usage variance (MUV)?

Solutions

Expert Solution

Part 1

Materials price variance (MPV)= (AP – SP)*AQ

= ($5.10– $5.05)*6,020

= $0.05 × 6,020

= $301 U

Materials usage variance (MUV)= (AQ– SQ)*SP

=(6,020 – 6,076)*$5.05

= (56 × $5.05)

= $282.80 F

Part 2

Labor rate variance (LRV) = (AR – SR)*AH

= ($14.50– $14.00)*386

= $193 U

Labor efficiency variance (LEV)= (AH– SH)*SR

=(386 – 392)*$14.00

=6 × $14.00

= $84 F

Part 3

Total direct materials variance= (AP× AQ) × (SP× SQ)

= ($5.10 × 6,020) – ($5.05 × 6,076)

= $30,702.00 – $30,683.80

= $18.20 U

Total direct labor variance= (AR× AH) – (SR× SH)

= ($14.50 × 386) – ($14.00 × 392)

= $5,597 – $5,488

= $109 U

Part 4

If the actual quantity purchased was 6,100 quarts, the materials price variancewould be calculated at the time of purchase.

Materials price variance (MPV)= (AP – SP)*AQ

= ($5.10– $5.05)*6,100

=$0.05 × 6,100= $305 U

There would be no impact on the materials usage variance because the actual quantity purchased is not used in that computation; the actual quantity used in production is part of the materials usage variance.


Related Solutions

Calculating the Direct Materials Price Variance and the Direct Materials Usage Variance Guillermo's Oil and Lube...
Calculating the Direct Materials Price Variance and the Direct Materials Usage Variance Guillermo's Oil and Lube Company is a service company that offers oil changes and lubrication for automobiles and light trucks. On average, Guillermo has found that a typical oil change takes 22 minutes and 6.6 quarts of oil are used. In June, Guillermo's Oil and Lube had 900 oil changes. Guillermo's Oil and Lube Company provided the following information for the production of oil changes during the month...
Calculating the Direct Materials Price Variance and the Direct Materials Usage Variance Guillermo's Oil and Lube...
Calculating the Direct Materials Price Variance and the Direct Materials Usage Variance Guillermo's Oil and Lube Company is a service company that offers oil changes and lubrication for automobiles and light trucks. On average, Guillermo has found that a typical oil change takes 30 minutes and 6.4 quarts of oil are used. In June, Guillermo's Oil and Lube had 920 oil changes. Guillermo's Oil and Lube Company provided the following information for the production of oil changes during the month...
Calculating the Direct Materials Price Variance and the Direct Materials Usage Variance Guillermo's Oil and Lube...
Calculating the Direct Materials Price Variance and the Direct Materials Usage Variance Guillermo's Oil and Lube Company is a service company that offers oil changes and lubrication for automobiles and light trucks. On average, Guillermo has found that a typical oil change takes 23 minutes and 6.8 quarts of oil are used. In June, Guillermo's Oil and Lube had 920 oil changes. Guillermo's Oil and Lube Company provided the following information for the production of oil changes during the month...
ornerstone Exercise 9.2 (Algorithmic) Calculating the Direct Materials Price Variance and the Direct Materials Usage Variance...
ornerstone Exercise 9.2 (Algorithmic) Calculating the Direct Materials Price Variance and the Direct Materials Usage Variance Guillermo's Oil and Lube Company is a service company that offers oil changes and lubrication for automobiles and light trucks. On average, Guillermo has found that a typical oil change takes 22 minutes and 6.6 quarts of oil are used. In June, Guillermo's Oil and Lube had 900 oil changes. Guillermo's Oil and Lube Company provided the following information for the production of oil...
Calculating the Direct Labor Rate Variance and the Direct Labor Efficiency Variance 9.1: Guillermo has found...
Calculating the Direct Labor Rate Variance and the Direct Labor Efficiency Variance 9.1: Guillermo has found a typical oil change takes 24 minutes and 6.2 quarts of oil are used. In June, Guillermo had 980 oil changes. Refer to Cornerstone Exercise 9.1. Guillermo's Oil and Lube Company provided the following information for the production of oil changes during the month of June: Actual number of oil changes performed: 980 Actual number of direct labor hours worked: 386 hours Actual rate...
Calculate total sales mix variance, Direct Materials Variance Price, Direct Materials Variance Efficiency, Dircet Labor Variance...
Calculate total sales mix variance, Direct Materials Variance Price, Direct Materials Variance Efficiency, Dircet Labor Variance Rate & Efficiency, Variable overhead variance spending, and Selling and General Admin Variance. Scooter's Inc Summary of Standard Costs Summary of Standard Costs Deluxe Beginner Assembly kit per scooter $               400 $         200 Direct labor hours per scooter                       3                 1 Direct labor rate per hour $                  25 $           15 Variable overhead rate per scooter $                  35 $           35 Sales Price 2017 2018...
Give citations for the following that can be used: Direct materials price variance (based on materials...
Give citations for the following that can be used: Direct materials price variance (based on materials used) Direct materials usage variance Direct labor variance Direct labor efficiency variance
Franklin Inc. reported the following variances: Direct materials price variance $ 0 Favorable Direct materials quantity...
Franklin Inc. reported the following variances: Direct materials price variance $ 0 Favorable Direct materials quantity variance $18,500 Unfavorable Direct labor rate variance $22,000 Favorable Direct labor efficiency variance $25,000 Unfavorable Which of the following explanations is the most likely cause? Group of answer choices The economy slowed, causing a decrease in demand, lower sales, and an increase in inventory. The sales manager decreased the selling price of the product, causing an increase in demand, a need to purchase raw...
Franklin Inc. reported the following variances: Direct materials price variance                $ 0 Favorable Direct materials quantity...
Franklin Inc. reported the following variances: Direct materials price variance                $ 0 Favorable Direct materials quantity variance         $2,000 Unfavorable Direct labor rate variance                             $6,000 Favorable Direct labor efficiency variance                $7,000 Unfavorable Which of the following explanations is the most likely cause? Group of answer choices The sales manager decreased the selling price of the product, causing an increase in demand, a need to purchase raw material from new vendors, and the need for workers to work overtime. Human Resources hired...
Calculating the Direct Materials Mix Variance Mangia Pizza Company makes frozen pizzas that are sold through...
Calculating the Direct Materials Mix Variance Mangia Pizza Company makes frozen pizzas that are sold through grocery stores. Mangia developed the following standard mix for spreading on premade pizza shells to produce 16 giant-size sausage pizzas. Direct Material Mix Mix Proportion SP Standard Cost Tomato sauce 16.00 lbs 0.320 $1.50 $24.00 Cheese 18.50      0.370 2.80 51.80 Sausage 15.50      0.310 2.10 32.55     Total 50.00 lbs $108.35 Mangia put a batch of 2,000 pounds of direct materials (enough for 640 frozen sausage...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT