9:59 PM @ 8%D ...13 X a Analysis for Business - Assessment Question 4 (a) Outline the construction and applications of ONE of the following indices: - FTSE 100 Index . Consumer Prices Index (CPI) (b) Retail sales are an important source of income for airports. The spreadsheet below shows the price () of Calvin Klein fragrances in 2020: IA BC 1 Item Small Large 2 CK One Gold 19.95 32.95 3 CK Women 42.80 62.40 ACK Eternity 40.00 55.20 SICK One Platinum 36.00 49.40 Using the table above, explain how the Excel VLOOKUP function could be used in cell B8, to identify 2020 prices for the Large size if any of the four fragrances were entered in cell A8. c.) The airport increased the prices of all of its Gucci fragrances by 5 from 2019 to 2020. In your answer book, complete the table below and calculate a combined weighted price index number for Gucci. Item 2019 price 2020 price Weight Bloom 79 20 Guilty 55.20 Bamboo Premiere Total C) Prices of Calvin Klein fragrances for 2019 and 2020 are shown in the table below. Calculate a combined price index number for Calvin Klein for 2020 based on 2019. Item CK One Gold 2019 Price (E) 2020 Price (E) Weight 31.95 32.95 30 Open With Print 9:59 PM @8%D ...13 X 52708 - Data Analysis for Business -... C) The airport increased the prices of all of its Gucci fragrances by 5 from 2019 to 2020. In your answer book, complete the table below and calculate a combined weighted price index number for Gucci. Item 2019 price 2020 price Weight Bloom 79.20 Guilty 55 20 Bamboo 71.90 Premiere 58.40 Total cm) Prices of Calvin Klein fragrances for 2019 and 2020 are shown in the table below. Calculate a combined price index number for Calvin Klein for 2020 based on 2019. Item 12019 Price (2020 Price ( Weight CK One Gold 31.95 32.95 CK Women 55.40 62.40 CK Eternity 49.95 55 20 CK One Platinum 55.40 49.40 Question 4 continues on the next page (iv) The spreadsheet table below summarises the overall prices of Calvin Klein and Gucci combined since 2015. Rebase the series provided on 2019 = 100 and present a completed table. TABCDEFG 1 Year 2015 2016 2017 2018 2019 2020 2 2015 = 100 100.0 105 S 108,4 110.5 116.8 Part 3 2019 100 (v) Calvin Klein sales are three times higher than sales of Gucci. Use this information, and your answers to parts (ii) and (iii), to produce a combined index number (based on 2015 = 100) to fit into the table in part (iv). Include all your workings and a full explanation. Open With Print
