Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Using the average revenue per subscriber for 2017 and Excel's Solver add-in function, estimate the percentage of subscribers who purchased entry, standard, and premium
3. Using the average revenue per subscriber for 2017 and Excel's Solver add-in function, estimate the percentage of subscribers who purchased entry, standard, and premium subscriptions in 2017. Default percentages have been provided as starting points. Note: Your three percentages must sum to 100%, all three percentages must be greater than or equal to 10%, and there must be at least twice as many standard subscribers as each entry and premium subscribers. [3 points] Use $117/subscriber 2017 Subscriber Mix: (Question 3) Ratio Level Entry Standard Premium Price $7.99 $9.99 $11.99 Percentage 25.00% 50.00% 25.00% 100.00% 2017 Revenue per Subscriber (in $, based on weights) 2017 Revenue per Subscriber (in $, from Q1) Difference $117 3. Using the average revenue per subscriber for 2017 and Excel's Solver add-in function, estimate the percentage of subscribers who purchased entry, standard, and premium subscriptions in 2017. Default percentages have been provided as starting points. Note: Your three percentages must sum to 100%, all three percentages must be greater than or equal to 10%, and there must be at least twice as many standard subscribers as each entry and premium subscribers. [3 points] Use $117/subscriber 2017 Subscriber Mix: (Question 3) Ratio Level Entry Standard Premium Price $7.99 $9.99 $11.99 Percentage 25.00% 50.00% 25.00% 100.00% 2017 Revenue per Subscriber (in $, based on weights) 2017 Revenue per Subscriber (in $, from Q1) Difference $117
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started