Question regarding Index, Unit 31

coin99
coin99 Registered Posts: 16 New contributor 🐸
Dear all, I met a question which i'm not sure whether my caculation is correct could anyone give me a hand, thanks.:001_smile:

Question:
Caculate each quarter's sales figure for 2005 and 2006 in terms of their value based on the index for quarter 4 of 2006

Data:
Year compay's sale Index
2005 Q1 920 112.4
Q2 976 113.3
Q3 1017 114.1
Q4 1022 114.7
2006 Q1 1012 115.4
Q2 989 116.8
Q3 1092 117.6
Q4 1124 118.7

My caculation is :
For example: adjusted sales value for Q1 2005 = (112.4/118.7) x 920= 871, is it correct?

Comments

  • sdv
    sdv Registered Posts: 585 Epic contributor 🐘
    no the answer is 118.7/112.4 x 920 = 972

    if the index has grown from 112.4 to 118.7 (increased)
    should the 920 figure increase or decrease?
  • AK002
    AK002 Registered Posts: 2,492 Beyond epic contributor 🧙‍♂️
    Or you could do..

    (920/112.4) * 118.7 = 972.
  • coin99
    coin99 Registered Posts: 16 New contributor 🐸
    Thanks for your help!
Privacy Policy