The Top Soda manufactures and sells three soft drinks: Kola, Lima, and Oranga. Budgeted and actual...

Transcribed Image Text:

The Top Soda manufactures and sells three soft drinks: Kola, Lima, and Oranga. Budgeted and actual results for 2022 are as follows: (Click the icon to view the budgeted data.) Required (Click the icon to view the actual data.) 1. Compute the total sales-volume variance, the total sales-mix variance, and the total sales-quantity variance. (Calculate all variances in terms of contribution margin.) S 2. What inferences can you draw from the variances computed in requirement 1? Budgeted data Selling Price Budget for 2022 Variable Cost Cases per Case Sold Requirement 1. Compute the total sales-volume variance, the total sales-mix variance, and the total sales-quantity variance. (Calculate all variances in terms of contribu Begin by computing the actual contribution margins (CM). Then, compute the budgeted contribution margins in dollars for each product and in total for 2022. Kola Lima Oranga $ 6.50 $ 4.20 420,000 $ 4.50 $ 3.60 $ 7.90 $ 5.40 700,000 1,850,000 Actual CM Budgeted CM Kola Lima $ 1,120,000 $ 966,000 1,164,000 Oranga 3,696,000 630,000 4,625,000 $ 5,980,000 $ 6,221,000 Total Calculate total sales-volume, sales-mix, and sales-quantity variances for 2022. (Calculate all variances in terms of contribution margins.) Let's first determine the formula for the sales-volume variance, and then calculate the variance for each product for 2022. Label each variance as favourable (F) or unfav ( Actual qty. of units sold Budgeted qty. of units sold ) x Budgeted CM per unit = Sales-volume variance Kola ( 560,000 420,000 ) x $ 2.30 = $ 322,000 F Lima ( 970,000 Oranga ( 1,680,000 700,000 1,850,000 ) x $ 0.90 = $243,000 F ) x $ 2.50 = $425,000 U The total sales-volume variance is $ 140000 F. Next, determine the formula for the sales-quantity variance, and then calculate the variance for each product for 2022. (Calculate all variances in terms of contribution ma rounded to one decimal place, "X.X%".) Actual Budgeted ( quantity of units sold quantity of units sold ) x Budgeted sales-mix Budgeted % x CM per unit Sales-quantity variance Kola ( 3,210,000 2,970,000 ) x 14.1 % x 2.30 = $ 77,832 F Lima )x % x Actual data Print Done Actual for 2022 Selling Price Variable Cost per Case Cases Sold Kola $ 6.70 $ 4.70 560,000 Lima $ 4.75 $ 3.55 970,000 Oranga $ 7.70 $ 5.50 1,680,000 Print Done - The Top Soda manufactures and sells three soft drinks: Kola, Lima, and Oranga. Budgeted and actual results for 2022 are as follows: (Click the icon to view the budgeted data.) Required (Click the icon to view the actual data.) 1. Compute the total sales-volume variance, the total sales-mix variance, and the total sales-quantity variance. (Calculate all variances in terms of contribution margin.) S 2. What inferences can you draw from the variances computed in requirement 1? Budgeted data Selling Price Budget for 2022 Variable Cost Cases per Case Sold Requirement 1. Compute the total sales-volume variance, the total sales-mix variance, and the total sales-quantity variance. (Calculate all variances in terms of contribu Begin by computing the actual contribution margins (CM). Then, compute the budgeted contribution margins in dollars for each product and in total for 2022. Kola Lima Oranga $ 6.50 $ 4.20 420,000 $ 4.50 $ 3.60 $ 7.90 $ 5.40 700,000 1,850,000 Actual CM Budgeted CM Kola Lima $ 1,120,000 $ 966,000 1,164,000 Oranga 3,696,000 630,000 4,625,000 $ 5,980,000 $ 6,221,000 Total Calculate total sales-volume, sales-mix, and sales-quantity variances for 2022. (Calculate all variances in terms of contribution margins.) Let's first determine the formula for the sales-volume variance, and then calculate the variance for each product for 2022. Label each variance as favourable (F) or unfav ( Actual qty. of units sold Budgeted qty. of units sold ) x Budgeted CM per unit = Sales-volume variance Kola ( 560,000 420,000 ) x $ 2.30 = $ 322,000 F Lima ( 970,000 Oranga ( 1,680,000 700,000 1,850,000 ) x $ 0.90 = $243,000 F ) x $ 2.50 = $425,000 U The total sales-volume variance is $ 140000 F. Next, determine the formula for the sales-quantity variance, and then calculate the variance for each product for 2022. (Calculate all variances in terms of contribution ma rounded to one decimal place, "X.X%".) Actual Budgeted ( quantity of units sold quantity of units sold ) x Budgeted sales-mix Budgeted % x CM per unit Sales-quantity variance Kola ( 3,210,000 2,970,000 ) x 14.1 % x 2.30 = $ 77,832 F Lima )x % x Actual data Print Done Actual for 2022 Selling Price Variable Cost per Case Cases Sold Kola $ 6.70 $ 4.70 560,000 Lima $ 4.75 $ 3.55 970,000 Oranga $ 7.70 $ 5.50 1,680,000 Print Done -