Please show work

2. Sales Mix/Product/Cost Analysis

a. In the Excel template, sheet Ex2 SalesMix, complete all of the highlighted cells.

b. Explain sales mix and how it can affect a companys profitability.

c. Study the data you computed in 2.a. and comment on any additional insights you have about the factors that contributed to EntertainmentNow.coms financial results for the past year.

EntertainmentNow.com Schedule of Planned versus Actual Volumes and Prices Plan vs. Actual Rev per unit Actual Sales Plan Revenue Plan vs. Actual Volume Variance Plan Sales ix Actual Revenue per Unit Change in Plan Volume Actual Volume per Unit Sales Mix Variance Mix Books S 10,000,000 Books 9,000,000 18.00 17.50 Music S 11,000,000 S 14.00 Music 12,000,000 13.00 DVD/Video S S 14.00 DVD/Video 7,980,000 16.00 8,300,000 Toys S 600,000 34.00 750,000 29.00 Toys Electronics Electronics 180,000 S 210,000 S 43.00 40.00 Total 29,760,000 Total 30,260,000