(Excel) In the Laspeyre index, the quantities used for the weights are those of the base year. If these are replaced by quantities for the current year, then the index is called the Paasche index. In Problem 21, suppose that the numbers of employees of types $A, B, C$ and $D$ in year 1 are $30,240,115$ and 8 respectively. For year 2 the corresponding figures are $28,220,125$ and 20 . By adding two extra columns for the products $P_{1} Q_{1}$ and $P_{2} Q_{2}$ to the spreadsheet of Problem 21, calculate the Paasche index for years 1 and 2 . Compare with the Laspeyre index calculated in Problem $21 .$
State one advantage and one disadvantage of using the Laspeyre and Paasche methods for the calculation of combined index numbers.