Paste Copy In wrap text General FILE V3ESZ2MTIYT... XOBtOsgeh9... Yg6PFkZcp... Format Painter BIU - - a - 135 Merge & Center - $ - % -% Conditional Formatas YKXBKEMDjo... 25JDFil4Pa+... Normal Clipboard Formatting Table Font Alignment 5 Number Styles A4 (a) Write a formula in cell E15 to compute mobile website visitors' CAGR from 2014 to 2017 A B D E G 1 Based on a survey, in 2017, the IT Strategy team decided to develop a mobile application for the e-commerce store, and the firm launched the mobile app on 1st Jan 2018 JK M N 2 Before 2018, smartphone visitors accessed the e-commerce store using the mobile website. 3 Table 5 shows the average monthly visitors to the mobile website and mobile app from 2014 to 2019. (a) Write a formula in cell E15 to compute mobile website visitors' CAGR from 2014 to 2017. 4 5 6 Table 5 7 Year Mobile Website Mobile App 8 2014 23085 NA 9 2015 28001 NA 10 2016 35430 NA 11 2017 45122 NA 12 2018 48219 13500 Sample Answer 13 2019 49000 28000 14 Mobile Website visitor CAGR during the period 2014 to 2017 25.03296 15 Mobile Website Visitor CAGR during the period 2014 to 2017 16 17 Superficially, it looks like the mobile app has not cannibalized the mobile website, this is because the monthly mobile website visitor has grown in 2018 and 2019. 18 However, the comparison of actual visitors in 2018 to 2017 actual visitors is not correct. To find cannibalization, we should compare the actual visitors to the expected visitors. 19 Assume that if the firm did not launch the app, the mobile website user base would have grown at the CAGR rate: 20 (b) Using CAGR computed in E15, write the formula in cells D26 and 27 to calculate the expected Mobile website visitor in 2018 and 2019, respectively. 21. (c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell E26 and copy to cell E27. (d) In cell F26. Use the IF Function to create a formula to print "Yes" if there is cannibalization; else, the formula should print "No Copy the formula to cell F27. 22 Hint: If the percent increase is negative then there is cannibalization, else there is no cannibalization. 23 24 Table 6 Sample Answer Expected Mobile Percentage Is there Expected Mobile Percentage is there 25 Year Mobile Website Website visitor Increase cannibalization? Year Mobile Website Website visitor Increase cannibalization? 36 2018 48219 2018 48219 56417 14.5307%/Yes 27 2019 49000 2019 49000 20539 -30.5346%/Yes 28 29 Strategy Team is interested in knowing whether the app launch helped increase visitors' number to the e-commerce store 30 e) in cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38. 21 ) Compute the percent increase in the Total Actual Visitors as compared to Enacted mobile.com 30417 -14.53079 Yes - 2019 49000 70539 -30.5346% Yes 29 Strategy Team is interested in knowing whether the app launch helped increase visitors' number to the e-commerce store, 30 (e) In cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38. 31 (1) Compute the percent increase in the Total Actual Visitors as compared to Expected mobile website visitors, write the formula in cell G37 and copy to cell G38. (g) in cell H37, Use the IF Function to create a formula to print "Yes" if the App Launch was beneficial to the firm; else, the formula should print "No". Copy the formula to cell 438. 32 Hint: If the Percent increase is positive, then the launch is beneficial; else, it is not beneficial. 34 35 Table 7 Actual Mobile Mobile App Actual Total Actual Expected Mobile Percentage Was Launch of App 36 Year Website visitor Visitors Visitors Visitors Increase beneficial to the firm? 37 2018 48219 13500 0 38 2019 49000 28000 0 39 40 Sample Answer 41 42 Actual Mobile Mobile App Actual Total Actual Expected Mobile Percentage Was Launch of App 43 Year Website visitor Visitors Visitors Visitors Increase beneficial to the firm? 44 2018 48219 13500 61719 56417 9.40%/Yes 45 2019 49000 28000 77000 70539 9.1696 Yes 46 47 48 49 50 51 52 Paste Copy In wrap text General FILE V3ESZ2MTIYT... XOBtOsgeh9... Yg6PFkZcp... Format Painter BIU - - a - 135 Merge & Center - $ - % -% Conditional Formatas YKXBKEMDjo... 25JDFil4Pa+... Normal Clipboard Formatting Table Font Alignment 5 Number Styles A4 (a) Write a formula in cell E15 to compute mobile website visitors' CAGR from 2014 to 2017 A B D E G 1 Based on a survey, in 2017, the IT Strategy team decided to develop a mobile application for the e-commerce store, and the firm launched the mobile app on 1st Jan 2018 JK M N 2 Before 2018, smartphone visitors accessed the e-commerce store using the mobile website. 3 Table 5 shows the average monthly visitors to the mobile website and mobile app from 2014 to 2019. (a) Write a formula in cell E15 to compute mobile website visitors' CAGR from 2014 to 2017. 4 5 6 Table 5 7 Year Mobile Website Mobile App 8 2014 23085 NA 9 2015 28001 NA 10 2016 35430 NA 11 2017 45122 NA 12 2018 48219 13500 Sample Answer 13 2019 49000 28000 14 Mobile Website visitor CAGR during the period 2014 to 2017 25.03296 15 Mobile Website Visitor CAGR during the period 2014 to 2017 16 17 Superficially, it looks like the mobile app has not cannibalized the mobile website, this is because the monthly mobile website visitor has grown in 2018 and 2019. 18 However, the comparison of actual visitors in 2018 to 2017 actual visitors is not correct. To find cannibalization, we should compare the actual visitors to the expected visitors. 19 Assume that if the firm did not launch the app, the mobile website user base would have grown at the CAGR rate: 20 (b) Using CAGR computed in E15, write the formula in cells D26 and 27 to calculate the expected Mobile website visitor in 2018 and 2019, respectively. 21. (c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell E26 and copy to cell E27. (d) In cell F26. Use the IF Function to create a formula to print "Yes" if there is cannibalization; else, the formula should print "No Copy the formula to cell F27. 22 Hint: If the percent increase is negative then there is cannibalization, else there is no cannibalization. 23 24 Table 6 Sample Answer Expected Mobile Percentage Is there Expected Mobile Percentage is there 25 Year Mobile Website Website visitor Increase cannibalization? Year Mobile Website Website visitor Increase cannibalization? 36 2018 48219 2018 48219 56417 14.5307%/Yes 27 2019 49000 2019 49000 20539 -30.5346%/Yes 28 29 Strategy Team is interested in knowing whether the app launch helped increase visitors' number to the e-commerce store 30 e) in cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38. 21 ) Compute the percent increase in the Total Actual Visitors as compared to Enacted mobile.com 30417 -14.53079 Yes - 2019 49000 70539 -30.5346% Yes 29 Strategy Team is interested in knowing whether the app launch helped increase visitors' number to the e-commerce store, 30 (e) In cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38. 31 (1) Compute the percent increase in the Total Actual Visitors as compared to Expected mobile website visitors, write the formula in cell G37 and copy to cell G38. (g) in cell H37, Use the IF Function to create a formula to print "Yes" if the App Launch was beneficial to the firm; else, the formula should print "No". Copy the formula to cell 438. 32 Hint: If the Percent increase is positive, then the launch is beneficial; else, it is not beneficial. 34 35 Table 7 Actual Mobile Mobile App Actual Total Actual Expected Mobile Percentage Was Launch of App 36 Year Website visitor Visitors Visitors Visitors Increase beneficial to the firm? 37 2018 48219 13500 0 38 2019 49000 28000 0 39 40 Sample Answer 41 42 Actual Mobile Mobile App Actual Total Actual Expected Mobile Percentage Was Launch of App 43 Year Website visitor Visitors Visitors Visitors Increase beneficial to the firm? 44 2018 48219 13500 61719 56417 9.40%/Yes 45 2019 49000 28000 77000 70539 9.1696 Yes 46 47 48 49 50 51 52