How do I calculate the other cost variances such as Variance in COGs % in relation to this entertainmentnow.com case? I am not following what needs to go into the variance line or the profit reconciliation tab for this part.

Entertainmentnow.com Profit Reconciliation Instructions: The goal of this worksheet is to reconcile planned profit to actual profit in accordance with the third requirement in the case study. Each variance that requires a calculation should be calculated in the tabs that follow this worksheet. Planned Profit Change in planned profit due to: ### Volume Variance Mix Variance Price Variance Variance in COGS % Variance in fullfillment cost/unit $ Variance in marketing cost/unit $ Increase in Technology and content Decrease in General and administra Actual Profit (228,387) (2,032,413) (3,292,800) (15,000.00) (25,000.00) 350,000 (250,000) ### $ ### (399,100) Dawn Reed: Start here, this willl help you complete the reconcilation so you will know when you have everthng correct. illl help you oncilation so en you have Entertainmentnow.com Volume Variance Calculation Instructions: The goal of this worksheet is to ultimately determine the total profit variance due to volume in cell E19 using this template and the information provided in the case study. The revenue variance in cell E12 is derived from the final calculation of the revenue variance in cell H30. The actual volume with planned mix in cells C24 to C28 is calculated using the mix % calculated in the planed product mix section. Hint: The math doesn't work out perfectly when calculating the "actual volume with planned mix" based on the "original planned volume mix %" that is calculated. Round the percentages for books, music, dvd and toys to 2 decimal places and plug the actual volume with planned mix for electronics so that your total in cell C30 is the actual volume stated in the case study. Profit Impact Due to Additional Unit Sales (assuming planned mix of unit sales) Revenue Costs that vary based on additional units sold: Cost of goods sold Fullfillment Marketing Total Profit Variance $ 7,951,613 $ $ $ $ $ 6,043,226 1,265,000 $2.53 = actual cost/unit 415,000 $0.83 = actual cost/unit 7,723,226 228,387 Calculation of Revenue Variance Books Music DVD Toys Electronics Actual Volume with Planned Mix 9,151,210 12,201,613 8,114,073 610,081 183,024 Original Plan Unit Sales 9,000,000 12,000,000 7,980,000 600,000 180,000 151,210 201,613 134,073 10,081 3,024 29,760,000 1,871,698.11 500,000 30,260,000 30,260,000 Planned Product Mix Books Music DVD Toys Electronics Original Planned Original Planned Sales Volume Mix % $ 162,000,000 30.24% $ 156,000,000 40.32% $ 127,680,000 26.81% $ 20,400,000 2.02% $ 7,200,000 0.60% Planned Price Variance X X X X X $ $ $ $ $ 18.00 13.00 16.00 34.00 40.00 $ 473,280,000 e due to volume in cell E19 in cell E12 is derived from mix in cells C24 to C28 is doesn't work out perfectly volume mix %" that is nd plug the actual volume d in the case study. ctual cost/unit ctual cost/unit Revenue Variance Due to Volume Increase $ $ $ $ $ 2,721,774 2,620,968 2,145,161 342,742 120,968 $ $ $ $ $ 164,721,774 158,620,968 129,825,161 20,742,742 7,320,968 Actual Volume 10,000,000 11,000,000 8,300,000 750,000 210,000 $ 7,951,613 $ 481,231,613 $ 475,980,000 1,000,000 Entertainmentnow.com Mix Variance Calculation Instructions: The goal of this worksheet is to ultimately determine the total profit variance due to mix variance in cell G17 using this template and the information provided in the case study. The revenue variance in cell G11 is derived from the final calculation of the revenue variance in cell G28. Profit Impact Due to Change in Mix of Unit Sales (assumes actual sales volume and planned prices): Revenue $ 8,468,387 Costs that vary based on additional units sold: Cost of goods sold 6,435,974 Total Profit Variance $ 2,032,413 Calculation of Revenue Variance Books Music DVD Toys Electronics Actual Actual Volume with Volume Planned Mix 10,000,000 9,151,210 11,000,000 12,201,613 8,300,000 8,114,073 750,000 610,081 210,000 183,024 30,260,000 30,260,000 Variance 848,790 (1,201,613) 185,927 139,919 26,976 X X X X X $ $ $ $ $ Planned Price Revenue Change 18.00 $ 15,278,226 13.00 (15,620,968) 16.00 2,974,839 34.00 4,757,258 40.00 1,079,032 $ 8,468,387 due to mix variance in riance in cell G11 is