Index factor, Index Total , Please HELP
elenmarkova
Registered Posts: 17 Dedicated contributor 🦉
Can somebody please tell me how you work out the INDEX Factor and Index Totals, I am struggling with this calculation for a while and my head is really messed up.
These are the sales made during 2003 and alongside are the index values, I need to calculate the indexed value of the monthly sales in December 2003 terms.
Month2003 Unadjusted totals Cumulative totals Industrial index
January 295 295 111
February 311 606 115
March 350 956 119
April 342 1,298 121
............
November 459 4,023 147
December 440 4,463 151
And two additional columns for Index Factor to be calculated and Index Totals
I will really appreciate any help
Thanks
These are the sales made during 2003 and alongside are the index values, I need to calculate the indexed value of the monthly sales in December 2003 terms.
Month2003 Unadjusted totals Cumulative totals Industrial index
January 295 295 111
February 311 606 115
March 350 956 119
April 342 1,298 121
............
November 459 4,023 147
December 440 4,463 151
And two additional columns for Index Factor to be calculated and Index Totals
I will really appreciate any help
Thanks
0
Comments

Hello,
To restate figures in Dec 2003 terms this must mean the index figure for Dec will be 1.00.
Therefore, for Jan you would use 151/111 = 1.36 index factor, to adjust Jan figures 295 * 1.36 = 401. The sales figure for Jan 03 has now been restated in terms for Dec 03.0 
index
thanks for the reply
following you , that means the index factor for February in terms of December 2003 would be
151/115 = 1.31 , and the index total will be 1,31*311 = 408
Am I right
It seems pretty simple ...0 
Yes, that looks right to me. Obviously as you get to Dec 03 the factor will be 151/151 = 1.00.0

thanks
great , thanks a lot crispy0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 319 NEW! Qualifications 2022
 157 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 92 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 92 Software
 274 Tax
 136 Bookkeeping
 7.2K General accounting discussion
 201 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 582 Job postings
 16 Who can benefit from AAT?
 36 Where can AAT take me?
 42 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 66 AAT membership