You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?
You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions.
a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up.
b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up.
Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 3 images
