Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 May Jun Jul Aug Sep Oct Nov Dec Cohort #1 28 24 21 19 17 16 14 Cohort #2 23 19 30 27 24 22 Cohort #3 63 38 33 28 43 38 Cohort #4 56 56 34 29 25 38 Cohort #5 55 69 59 41 36 30 Cohort #6 60 75 75 45 39 Cohort #7 53 66 56 40 Cohort #8 45 56 Total 28 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Marketing

Authors: Louis E Boone, David L Kurtz

14th Edition

032458203X, 978-0324582031

More Books

Students also viewed these Marketing questions

Question

Tell the merits and demerits of Mendeleev's periodic table.

Answered: 1 week ago