Index factor, Index Total , Please HELP
Options
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
 18.9K For AAT students
 268 NEW! Qualifications 2022
 147 General Qualifications 2022 discussion
 9 AAT Level 2 Certificate in Accounting
 44 AAT Level 3 Diploma in Accounting
 65 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 138 Bookkeeping
 7.3K General accounting discussion
 195 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 590 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership