cash managerment assessment practice / revision
Lee
Registered Posts: 29 ? ? ?
hi there, can someone please help answer question 1.3 (b) practice assessment on trends. I have not really mastered how to workout the forecast trend/variations.
Is there a book that I can get that gives step by step calculations? I am finding BPP book difficult to follow.
Is there a book that I can get that gives step by step calculations? I am finding BPP book difficult to follow.
0
Comments

Hi, what book or exam is this from? The trending questions are ok once you get your head around them, let me know what book or exam it's from and il work through it with you.
I have my exam tommorow so cramming today!0 
Ah sorry lee just saw you put practice assessment so I take it it's the paper one not the cba?
Right, first of all see what the moving average is. If its 3 point which it usually is, then that means you work in 3s to find the trend.
In the sales volume column, you add the first 3 volumes and divide by 3 by to the trend for September. Eg 9360+5940+5220/3=6840. Now to get the next trend you move down the next lot of 3, so 5940+5220+9900/3=7020. Now do the last 3 figures to get the last trend figure for November so 5220+9900+6480/3=7200.
Now you have that column filled in, all you do to find the Monthly variation is take the Sales volume less trend. So for September it is 59406840=900. Do this for the rest of the monthly variations and you have your answers!
For the monthly sales volume trend is just the difference between the trend figures.
I'm really bad at explaining things so if this makes no sense then sorry :) but feel free to pm me if you need anymore help.0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 247 NEW! Qualifications 2022
 137 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 33 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
 136 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