construct an excel spreadhseet

An app developer is trying to determine how much advertising to include in the free version of an app and how much to charge monthly for the ad-free version. Customers appreciate the app and find it useful; but too much advertising in the free version decreases the perceived value and utilization of the free version. However, heavily advertising in the free version increases the number of customers willing to pay for the ad-free version. Obviously, charging more for the ad-free version decreases demand for the ad-free version. Equations describing the demand for the two products are shown below: Free version users = 500000 - 5000. Kad + 2000. Ppro Free version utilization = 30 - 0.5 - Xad Pro version subscriptions = 100000 + 200 - Xad -2000. Ppro The ad presence is given by the symbol Xad and is measured in the number of advertisements per hour. The "Free version users" represents the number of users that use the free version. The "Free version utilization represents the number of hours that a single user spends on the free version of the app each month. "Pro version subscriptions" represents the number of users that use the ad-free version of the app. The ad click rate is 5%. In other words, 5% of all ads shown get clicked on. The average monthly utilization for pro-version (ad-free) users is 60 hours per month Every time a customer views an ad, the developer gets $0.015. Every time a customer clicks on an ad, the developer gets an additional $0.135 for a total of $0.15 (for the view and the click). The company's existing IT infrastructure has found that total monthly utilization needs to stay below 17000000 user-hours to maintain steady uninterrupted operation. Question 6 5 pts Problem 3 (Spreadsheet Construction): For an ad presence of 25 ads/hr and a pro subscription price of $30/month, what is the total utilization from pro subscribers? Question 7 5 pts Problem 3 (Spreadsheet Construction); For an ad presence of 25 ads/hr and a pro subscription price of $30/month, what is the total monthly revenue from ad clicks? Question 8 6 pts Problem 3 (Spreadsheet Construction): For an ad presence of 25 ads/hr and a pro subscription price of $30/month, what is the total monthly utilization from all users? D Question 9 10 pts Problem 3 (Spreadsheet Construction): For an ad presence of 25 ads/hr and a pro subscription price of $30/month, what is the total monthly revenue? An app developer is trying to determine how much advertising to include in the free version of an app and how much to charge monthly for the ad-free version. Customers appreciate the app and find it useful; but too much advertising in the free version decreases the perceived value and utilization of the free version. However, heavily advertising in the free version increases the number of customers willing to pay for the ad-free version. Obviously, charging more for the ad-free version decreases demand for the ad-free version. Equations describing the demand for the two products are shown below: Free version users = 500000 - 5000. Kad + 2000. Ppro Free version utilization = 30 - 0.5 - Xad Pro version subscriptions = 100000 + 200 - Xad -2000. Ppro The ad presence is given by the symbol Xad and is measured in the number of advertisements per hour. The "Free version users" represents the number of users that use the free version. The "Free version utilization represents the number of hours that a single user spends on the free version of the app each month. "Pro version subscriptions" represents the number of users that use the ad-free version of the app. The ad click rate is 5%. In other words, 5% of all ads shown get clicked on. The average monthly utilization for pro-version (ad-free) users is 60 hours per month Every time a customer views an ad, the developer gets $0.015. Every time a customer clicks on an ad, the developer gets an additional $0.135 for a total of $0.15 (for the view and the click). The company's existing IT infrastructure has found that total monthly utilization needs to stay below 17000000 user-hours to maintain steady uninterrupted operation. Question 6 5 pts Problem 3 (Spreadsheet Construction): For an ad presence of 25 ads/hr and a pro subscription price of $30/month, what is the total utilization from pro subscribers? Question 7 5 pts Problem 3 (Spreadsheet Construction); For an ad presence of 25 ads/hr and a pro subscription price of $30/month, what is the total monthly revenue from ad clicks? Question 8 6 pts Problem 3 (Spreadsheet Construction): For an ad presence of 25 ads/hr and a pro subscription price of $30/month, what is the total monthly utilization from all users? D Question 9 10 pts Problem 3 (Spreadsheet Construction): For an ad presence of 25 ads/hr and a pro subscription price of $30/month, what is the total monthly revenue