You are currently evaluating the launch of a new chocolate bar that meets keto diet standards. Your goal is to evaluate the financial impact of launching this new brand. To make this evaluation you need to decide on a retail price for the new product, estimate how many units you will sell of the new product, and estimate the effect of cannibalization. The financials for the old and the new product that you start with are the following: Unit Sales Volume in 2021 Unit Sales Forecast 2022 COGS per unit Your Selling Price Retail Selling Price /Bar Your Channel Partner's Margin 40% 40% ChocoHealth New brand 900,000 n/a 1,000,000 TBD $1.19 $1.39 $2.70 TBD $4.50 TBD Step 1. Calculating your selling price and unit contribution Your first need to decide on the retail selling price for your new product. It can be the same as, or higher or lower than the price for your existing brand. Keep in mind that the new product will be slightly more expensive to make due to more expensive ingredients. Please add an explanation for your decision (1-2 sentences will be sufficient). Once you have decided on your retail price, you can calculate the price at which you will sell it to your retailer using the channel partner's margin, and your unit contribution based on your selling price and the COGS per unit. You will complete the analysis in Excel and turn in your spreadsheet (if you do not have access to Excel, please reach out to discuss options). Please use textboxes for comments and explanations (these "float" on top of your spreadsheet so will not affect the spacing of your cells). You can organize the spreadsheet with or without tabs