Scenario Let's assume that a small business created an app that is sold for use on mobile
Question:
Scenario Let's assume that a small business created an app that is sold for use on mobile devices. Each year, the product has increased in functionality and price each year. The original business case for the product estimated that product revenue would be $75,000 by the Q1 - Analyze the Data Scenario Let's assume that a small business created an app that is sold for use on mobile devices. Each year, the product has increased in functionality and price each year. The original business case for the product estimated that product revenue would be $75,000 by the year 2021 based on their forecast of at least a 3% per year increase. However, the actual results have not matched expectations. Using the data set in the table below, enter the values in an excel spreadsheet.
Figure 1: Revenue by Year
Year | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 |
Revenue | $60K | $62K | $64K | $65K | $66K | $67.5K | $68K | $68.4K |
Change | ||||||||
Change % | ||||||||
a) In your Excel spreadsheet calculate the missing two rows of numbers. b) Identify the two years with the steepest monetary increases. c) Explain how you determined this: for example, did you use actual revenue increase or the percentage increase? Why did you choose that method? d) Paste your spreadsheet (or a copy of it) here.