please solve using excel

Step 3. Calculating total contribution with and without cannlbalization In the final step of your analysis, you will determine what the total contribution will be with and without cannibalization. You have discussed the issue of cannibalization with others in the company and based on this input you think the cannibalization rate will be somewhere between 5 to 30 percent. For the final analysis you need to decide on a specific cannibalization rate within that range and explain your decision (1-2 sentences will be sufficient). The table below presents a model you can use for the cannibalization analysis. You will use the information from the steps above about the existing product as well as the price, contribution margin and sales forecast you calculated for the new product. * a cannibaliration rate of SOW means that 50% of the sales of the new product, or 30 units in this case, will be taken from the existing brand. Based on your calculations you will comment on whether you think cannibalization will be a significant problem in this situation or not (23 sentences). Step 3. Calculating total contribution with and without cannlbalization In the final step of your analysis, you will determine what the total contribution will be with and without cannibalization. You have discussed the issue of cannibalization with others in the company and based on this input you think the cannibalization rate will be somewhere between 5 to 30 percent. For the final analysis you need to decide on a specific cannibalization rate within that range and explain your decision (1-2 sentences will be sufficient). The table below presents a model you can use for the cannibalization analysis. You will use the information from the steps above about the existing product as well as the price, contribution margin and sales forecast you calculated for the new product. * a cannibaliration rate of SOW means that 50% of the sales of the new product, or 30 units in this case, will be taken from the existing brand. Based on your calculations you will comment on whether you think cannibalization will be a significant problem in this situation or not (23 sentences)