FNPF question
Terdoo
Registered Posts: 144 Dedicated contributor 🦉
Can someone help with index question pls, I have being struggling with this price index and can't seem to get the answer
jan feb mar
Total 64500 71500 92050
Qty 5000kg 5500kg 7000
price Index
insert the price index for jan and march
How do you calculate this? Thanks in advance
jan feb mar
Total 64500 71500 92050
Qty 5000kg 5500kg 7000
price Index
insert the price index for jan and march
How do you calculate this? Thanks in advance
0
Comments
-
Hiya,
As you need to add Jan and March, I'm assuming that Feb is 100.
To get there, calculate for each one the price per kg/ unit/ whatever small amount. (Total/ no of kgs)
Jan...... 12.90
Feb...... 13.00
Mar...... 13.15
Now in order to create yourself index figures from these, you need to know the base period or price and set this to 100%. The other years will be indexed based on this one, by dividing the unit price through the base price times 100%.
The calculation is "unit price of year you want to calculate" divided by "the unit price of the base year" times "the index figure of the base year".
You can calculate any year this way, and based on any index figure, so you don't have to worry about finding that 100% if you don't know it.
If February's index is the base, we set that to be 100.
January would then be 12.90 / 13.00 * 100 = 99.23
March would then be 13.15 / 13.00 *100 = 101.15
If you get given that February has an index of say, 123.0 in the question, you would do the same calculations, only you replace the 100 with the given percentage of 123.0.
Does that help?
Cheers,
Rinske0 -
Re Retail Price Index
Hi all
I have calculated it the way you did it but the answer is wrong, the answer they want is as below;
Jan Feb Mar
Total 64500 71500 92050
Qty 5000 5500 7000
Price index 258 260 263
Could anyone show calculation pls
Thanks in advance0 -
Same calculations as above, but possibly just a different index number somewhere.
Does it say in the question what the 100 index was or what the latest index figure with a unit price was?
12.90 / 13.00 * 260 = 258
13.15 / 13.00 * 260 = 2630 -
Re;price index
Thank you so very much Rinske!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 324 NEW! Qualifications 2022
- 160 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 94 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 274 Tax
- 138 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 off-topic 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