Diploma Unit 34  Help needed with RPI
uknitty
Registered Posts: 591 Epic contributor 🐘
I'm just about tearing my hair out with a question regarding RPI in the Osbourne AWS Workbook. (For those of you that have the book the question is number 4.5).
"Adjust the sales figures for the changing price levels shown by the retail price index"
This is how my workings look, with the book answer in the final column. Clearly a massive difference !
Sales Index RPI Adjusted Sales Answer as per Book
800 100% 155 800 975
890 111% 163 846 1032
920 115% 169 844 1029
950 119% 176 837 1020
990 124% 189 959 990
I arrived at my adjusted sales figures using sales for year in question * RPI year 1 / RPI Year in question. I can't even see how the figures quoted in the answer have been arrived at  please could someone help ?
Thanks very much all for taking a look ( and hopefully for explaining where I am going wrong!)
"Adjust the sales figures for the changing price levels shown by the retail price index"
This is how my workings look, with the book answer in the final column. Clearly a massive difference !
Sales Index RPI Adjusted Sales Answer as per Book
800 100% 155 800 975
890 111% 163 846 1032
920 115% 169 844 1029
950 119% 176 837 1020
990 124% 189 959 990
I arrived at my adjusted sales figures using sales for year in question * RPI year 1 / RPI Year in question. I can't even see how the figures quoted in the answer have been arrived at  please could someone help ?
Thanks very much all for taking a look ( and hopefully for explaining where I am going wrong!)
0
Comments

Hi,
The answers in the book use the adjusted RPI points (using the 155, 163, 169, 176 and 189). The book also works it out from year 5 as a base, so getting the number to the current value of year 5, instead of back to the year 1 figures.
I haven't got this book, so I can't check what the exact question is or why they do this. But the calculations used as I make it out is as follows:
(sales year in question x RPI year 5 / RPI year in question)
For year 1:
800 times 189 divided by 155 = 975
For year 2:
890 x 189 / 163 = 1032
For year 3:
920 x 189 / 169 = 1029
For year 4:
950 x 189 / 176 = 1020
Does this help?
Cheers,
Rinske0 
Thanks Rinske
Thank you very much ! I can see exactly what I was doing wrong now
All of the practice questions I have attempted have used year 1 as the base, so I fell in to the trap of thinking that this was the only way to do things.
Thanks for giving me a "lightbulb moment"0
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