Excel Exercise CVP Analysis for multiple products Shine Alloys Ltd is a retailer of Alloy wheels for Hotrods imported from Southern California. There are a vast number of different types of Alloy wheels imported and retailed by Shine becausecustomers want their Hotrod to look unique. For the purpose ofcost control and planning Shine classifies its stock according to whether it is acustom design (high price) or limited edition (low price) alloy. Information concerning each category is provided below Note each category refers to a set of four alloys Sales commission on sale 5% Cost Product Custom design set 3,900 2,900 2,400 1,900 If you successfully calculated the Variable cost (sales commission" the same type of multiplication formula can be used for cells 117 & 118 below. imited edition set To calculate Custom design set Total variable cost enter the following formula in cell F17 D17+E17 In a normal month, the Management of Shine expects that 30% of total sales will be custom design sets and the remaining Limited edition sets. Fixed costs per month: 57,000 REQUIRED: All cellsin yellow need to be completed. Orange arrows provide guidance on completing the relevant formulas using excel. Requirement 1 Calculate the variable cost (sales commission), total variablecost, contribution margin and weight average contribution margin (Contribution margin) Variablecost (salesTotal variable ContributionWeighted sales Weighted average contribution margin Product Custom design set Limited edition set Sale price Variable cost (allay set mission cost 2,595.00 1,958.00 0.3 1,900 942.00 0.7 60 To calculate Custom design set To calculate Custom design set "Variable cost (sale commision)" enter the following formula in cell E17:-c7.E7 Margin" enter the following formula in cell G17:C17-F17