Scenario Trusted Friends sells a subscription product that follows a peculiar, but predictable, pattern that determines how many units will sell over the life of a customer. This pattern is shown below for the average units purchased per customer by month: Unit Sales Product Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cohort #1 28 35 35 21 18 15 24 21 19 17 16 14 Cohort #2 35 44 44 26 23 19 30 27 24 22 Cohort #3 50 63 63 38 33 28 43 38 Cohort #4 45 56 56 34 29 25 38 Cohort #5 55 69 69 45 36 30 Cohort #6 60 75 75 45 39 Cohort #7 53 66 40 Cohort #8 45 56 Total 28 35 70 65 112 149 221 263 313 283 300 277 Questions A) How many total units will be sold in January of the following year? B) Which cohort will sell the most units in March of the next year and how many will it sell? C) What is a little peculiar and particular about this data? Why do you believe this happening? D) What is the projected 24-month total of units purchased for Cohort #3 assuming trends continue? Please show all your analysis, leave formulas in cells, and specify any assumptions you make