Budgeting  indexed sales question
AATchick
Registered Posts: 89 ? ? ?
Hi All, I wonder if any of you can help me please? I have a question that I simply cannot get my head around and I've checked the answers and have no idea how they have been calculated!!
So the basic principle of index numbers that I have been taught is
Historical price x (index of time converting to / index of time converting from)
So here are the details
Q; calculate the value of sales for each year at 2009 prices to the nearest £.
YEAR RPI SALES INDEXED SALES
2000 170.3 2013000
2001 173.3 2015500
2002 176.2 2102700
2003 181.3 2240000
2004 186.7 2235000
2005 192.0 2555000
2006 198.1 2850000
2007 206.6 2880000
2008 214.8 2901000
2009 213.7 2902500
The answers are telling me;
2000 = 0
2001 = 2151005
2002 = 2137887
2003 = 2304835
2004 = 2301569
2005 = 2627531
2006 = 2940547
2007 = 3003574
2008 = 3016141
2009 = 2887636
Can anyone help me understand these answers or are they wrong? I have been using 2013000 * (213.7 / 170.3) to get the answer of 2526002 for 2000 but apparently it's not right.
If anyone could help me understand this is be really really grateful :) x
Thank you :) xxx
So the basic principle of index numbers that I have been taught is
Historical price x (index of time converting to / index of time converting from)
So here are the details
Q; calculate the value of sales for each year at 2009 prices to the nearest £.
YEAR RPI SALES INDEXED SALES
2000 170.3 2013000
2001 173.3 2015500
2002 176.2 2102700
2003 181.3 2240000
2004 186.7 2235000
2005 192.0 2555000
2006 198.1 2850000
2007 206.6 2880000
2008 214.8 2901000
2009 213.7 2902500
The answers are telling me;
2000 = 0
2001 = 2151005
2002 = 2137887
2003 = 2304835
2004 = 2301569
2005 = 2627531
2006 = 2940547
2007 = 3003574
2008 = 3016141
2009 = 2887636
Can anyone help me understand these answers or are they wrong? I have been using 2013000 * (213.7 / 170.3) to get the answer of 2526002 for 2000 but apparently it's not right.
If anyone could help me understand this is be really really grateful :) x
Thank you :) xxx
0
Comments

hi AATchick
Without delving too deeply, the answers look dubious to me. The 2009 figure should be identical in both case as you should be dividing and multiplying by the same index number. And how can the value for 2000 be zero? It doesn't make sense. What is the source  textbook, web site?0 
Thanks for replying wabisabi, the answers are from my aat training provider, which is what worries me!!
Can you advise how you would work out one of them and perhaps I could go back and explain why the answer is different to theirs?
Thank you for your time :)0 
I agree with your calculation and workings. I was taught the same method
0 
Thank you for confirming, I'll submit my answers and go from there if they come back incorrect. Thanks for your help :)0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 251 NEW! Qualifications 2022
 139 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 35 AAT Level 3 Diploma in Accounting
 59 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 137 Bookkeeping
 7.3K General accounting discussion
 193 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 589 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