please answer in 200-400 words

You have just been hired as manager of the marketing department for a medium-size manufacturing company. On day one, you have a meeting with the management team of the company. The executives have assured you that the company is doing quite well, and they have supplied you with sales figures for the past five years which, in fact, have been steadily increasing Your first task for the company is to analyze the information and make recommendations. You are given the following data: Table 1: Annual Sales Annual Sales (in thousands of U.S. Dollars) 2016 2017 2018 2019 2015 Product Profit Margin A 10% $120,000 $120,000 $96,000 $80,000 $40,000 B 6% 80,000 104,000 136,000 176,000 240,000 7% 56,000 80,000 104,000 144,000 160,000 D 10% N/A N/A N/A 56,000 120,000 E 9% 160,000 152,000 176,000 112,000 80,000 Total $416,000 $456,000 $512,000 $568,000 $640,000 The new product, Product D, was introduced in 2018. All of the products, A, B, C, D, and E, are related. Please submit a memo to the CEO of the company (200-400 words, single-spaced), answering the following questions: 1. Over the five-year period, how has the company done in sales and in profits? Why have these changes occurred? 2. What has been the impact of introducing the new product D? 3. What recommendations would you make (i.e., hold, invest, discontinue)? HOLD INVEST DISCONTINUE (Explain) A B D E Table 6: Percentage Return on Sales 2015 8.44% Percentage Return on Sales 2016 2017 2018 8.23% 7.98% 7.80% 2019 7.63% Table 2: Annual Profit Product A B D E Total 8,160 Annual Profit (in thousands of dollars) 2016 2017 2018 $ 12,000 $ 9,600 $8,000 6,240 10,560 5,600 7,280 10,080 N/A N/A 5,600 13,680 15,840 10,080 $37,520 $40,880 $44,320 2015 $ 12,000 4,800 3,920 N/A 14,400 $35,120 2019 $4,000 14,400 11,200 12,000 7,200 $48,800 Table 3: Change in Sales Product A B D E 2015 N/A N/A N/A N/A N/A Percentage Change in Sales 2016 2017 2018 0.00% -20.00% -16.67% 30.00% 30.77% 29.41% 42.86% 30.00% 38.46% N/A N/A N/A -5.00% 15.79% -36.36% 2019 -50.00% 36.36% 11.11% 114.29% -28.57% Table 4: Product Contribution to Sales Product B D E 2015 28.85% 19.23% 13.46% N/A 38.46% 100.00% Percentage of Product Contribution to Sales 2016 2017 2018 2019 26.32% 18.75 14.08% 6.25% 22.81% 26.56% 30.99% 37.50% 17.54% 20.31% 25.35% 25.00% N/A N/A 9.86% 18.75% 33.33% 34.38% 19.72% 12.50% 100.00% 100.00% 100.00% 100.00% Table 5: Product Contribution to Profit Product A B C D E 2015 34.17% 13.67% 11.16% N/A 41.00% 100.00% Percentage of Product Contribution to Profits 2016 2017 2018 2019 31.98% 23.48% 18.05% 8.20% 16.63% 19.96% 23.83% 29.51% 14.93% 17.81% 22.74% 22.95% N/A N/A 12.64% 24.59% 36.46% 38.75% 22.74% 14.75% 100.00% 100.00% 100.00% 100.00%