Calculating an alternative forecast for Netflix

The ratio between the subscribers is 1 subscriber to 0.46 USD sales, set to variable sales_subs_ratio. The variables for success, subscribers, and our prior calculation of forecast1 have also been set.

The original assumptions are as follows: the total amount of subscribers at 78% success rate results in 39,000 subscribers used to build the forecast numbers.

However, the success rate for 2019 has been recalculated to have a probability of 65%, and the management has asked to make an adjusted forecast based on this value.

Set the percentage of successes to 65%.
Calculate the new number of subscribers in the dependency as the product of the number of subscribers per percentage point times the percentage of successes.
Calculate the new forecast, forecast2, as the new number of subscribers times the sales to subscriptions ratio.

Take Hint (-15 XP)

Exercise

Calculating an alternative forecast for Netflix

Instructions 1/2