Problem 17-31 Sales Mix and Quantity Variances (LO 17-3) Mattie\'s Vineyards is
ID: 2589498 • Letter: P
Question
Problem 17-31 Sales Mix and Quantity Variances (LO 17-3) Mattie's Vineyards is a producer and wholesaler of three varieties of white wine. Sales data for November are given below: Sauvignon Blanc Chardonnay RieslingTotal Budgeted selling price Budgeted variable cost Budgeted selling quantity Actual selling price Actual variable cost Actual selling quantity $ 7.25 8.10 $ 7.10 s 5.10 6.10 S 5.10 0,000 3,75011,250 25,000 $ 7.00 8256.76 S 5.00 6.00 $4.75 8,320 6,240 ,440 26,000 Required: (a) Compute the sales price variance for all three wines. (Indicate the offect of each variance by selecting "F for favorable, "U" for unfavorable, and "None" for no effect (i.e, zero variance).) Variety Price Variance Sauvignon Blanc Chardonnay Riesling (b) Compute the activity variance for Mattie's Vineyards for the year. (Indicate the offect of the variance by selecting "F for favorable, "U" for unfavorable, and "None" for no effect (i.o,, zero variance). Do not round your intermediate calculations. Round your answer to 2 decimal places.)Explanation / Answer
a) Sales price variance=(Budgeted price-Actual price)*Actual quantity Sauvigon blanc=(7.25-7)*8320=2080 U Chardonnay=(8.10-8.25)*6240=936 F Riesling=(7.10-6.75)*11440=4004 U Sales price variance=2080-936+4004=5148 U b and C. Activity variance=Mix variance+Quantity variance Mix variance=(Budgeted price-Budgeted variable cost)*[Actual standard quantity-Actual quantity] Sauvigon blanc=(7.25-5.10)*[26000*(10000/25000)-8320]=4472 U Chardonnay=(8.10-6.10)*[26000*(3750/25000)-6240]=4680 F Riesling=(7.10-5.10)*[26000*(11250/25000)-11440]=520 U Mix variance=4472+520-4680=312 U Quantity variance=(Budgeted price-Budgeted variable cost)*[Budgeted quantity-Actual standard quantity] Sauvigon blanc=(7.25-5.10)*[10000-26000*(10000/25000)]=860 F Chardonnay=(8.10-6.10)*[3750-26000*(3750/25000)]=300 F Riesling=(7.10-5.10)*[11250-26000*(11250/25000)]=900 F Quantity variance=860+300+900=2060 F Activity variance=2060-312=1748 F