City Guilds Model Questions Vol1 2025 Information Technology Question 3

A spreadsheet records monthly sales (in thousands) for three products A, B, C over six months (Jan-Jun) in the range B2:D7 (rows = months, columns = products). The company defines a monthly performance index as\n\[ Performance = \bigl(0.5\times\frac{A}{\text{total}} + 0.3\times\frac{B}{\text{total}} + 0.2\times\frac{C}{\text{total}}\bigr)\times100 \]\nwhere "total" is the sum of A, B and C for that month.\n\n(a) Write a single Excel formula that can be entered in cell E2 and copied down to compute the performance index for each month without using helper columns.\n(b) Using the data below, calculate the performance index for March (row 4) and give the result rounded to two decimal places.\n\nData (in thousands):\nJan - A=120, B=80, C=50\nFeb - A=150, B=90, C=60\nMar - A=130, B=110, C=70\nApr - A=140, B=100, C=80\nMay - A=160, B=120, C=90\nJun - A=170, B=130, C=100