Question regarding Index, Unit 31
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?
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?
0
Comments
-
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?0 -
Or you could do..
(920/112.4) * 118.7 = 972.0 -
Thanks for your help!0