1. Your dataset is the annual sales figures for a company from 2005 to 2020. However, you would like to see the pattern of sales growth (or decline) month on month for this period. How can you do this with the data you have been given. A. Divide the yearly growth in $ by 12 for each month in a year B. Assume the % growth per month is the same rate for each month in a year then use a WHAT IF calculation C. Use a TARDIS function D. You cannot reliably infer these figures from the data provided 024 Company Sales Data Bikeworld FY 2021 Average 2 Month Units Sold Unit Price Dollars 3 January 161 $1,398 $225,100 4 February 169 $1,418 $239,600 5 March 151 $1,431 $216,100 6 April 158 $1,420 $224,400 7 May 167 $1,422 $237,400 8 June 175 $1,397 $244,400 9 July 176 51,406 $247,500 10 August 165 $1,436 $237,000 11 September 168 $1,416 $237,900 12 October 167 $1,429 $238,700 13 November 172 $1,397 $240,300 14 December 161 $1,426 $229,600 15 Totals 1990 $1,416 $2,818,000 In the above we see monthly sales figures for a company. Average Unit Price changes slightly from month to month. Why? A. Supply chain issues make units more or less expensive in a given month B. A unit may be one of several different items C. The company changed unit prices during promotional campaigns P. We cannot tell from the supplied data