please use excel so i can see the work :)

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.) Show results for each product in your computations.

2. what inferences can you draw from the variances computed in requirement 1?

4-27 Variance analysis, multiple products. Emcee Inc. manufactures and sells two fruit drinks: Kostor idt timba. Budgeted and actual results for 2017 are as follows: Compute the tctal sales-volume varianca, the total oaloomix variarse, aHd the rotal safes-quantity variance. (Calculate all variances in terms of contribution margin.) Show results for each product in your computatins. - What inferences can you draw from the variances computed in requirement 1