Place link in search box or excel

https://fiu.instructure.com/courses/78856/files/11384545/download?wrap=1

• Accurate identification of the most profitable price point
• Accurate identification of the price point that maximizes dollar sales to retail
• Accurate identification of the price point that maximizes unit sales
• Explanation of channel trends as a result of each price point
• Giving your recommendation and providing a sound and thoughtful strategy for the recommendation

Omnichannel Analytic Exercise

You work for a perfume company that is looking to implement a consistent pricing strategy across all of its channels. Recent research conducted by the marketing department has revealed that consumers are not only likely to check prices online when purchasing in stores, but due to inconsistent pricing across different channels, consumers have been unable to determine the exact position of the product which has led to confusion. Based on this information the CMO has insisted on the company implementing an omnichannel pricing strategy that maintains a consistent pricing approach across all channels.

In this multibillion dollar industry, there are several channels that drive the majority of the consumer spend. These are Department stores, Specialty stores, Discount stores, Drug stores, Supercenters and Online. The share of unit sales in each of these channels for the fragrance category is represented in the attached excel file. Each of these channels has a different type of price sensitivity which will result in different levels of distribution in each channel, and therefore different levels of sales resulting from this distribution.

Your fixed costs are fairly consistent as your company operates a large plant with a great amount of capacity. For the sake of this exercise no changes to fixed costs are possible in the near future so all decisions much be made with your fixed costs remaining as is.

Your variable costs are also fairly consistent for the category of your product. For purpose of this exercise, all products will be discussed in equivalized volume of 100 mL units. Each bottle of perfume, at this average size, has $6.25 of variable cost to produce.

There are additional costs to factor in. Each channel requires a specific margin off the selling price (which is the factor that will allow us to control consistent pricing) and due to the difference in volume purchasing along with value added. For simplicity sake, we will assume an additional $2 variable cost for the intermediary/distributor used in each channel.

Using the information provided in the excel file, determine three price points in this business. The most profitable price point, the price point that maximizes dollar sales to retail, and the price point that maximizes unit sales. Provide your answers for each of these questions along with the relevant information that reinforces that point (i.e. $34.99 is the most profitable price point because it delivers a total profit of $100 million). You must include the 3 price points and the relevant information (maximized profit, maximized sales to retail, and maximizes unit sales) in order to receive credit.