Cash Management - Forcasting
Alex301286
Registered Posts: 6 New contributor 🐸
Hi,
I am currently working on moving averages and would like some assistance with the second part of the question. I am fine with working out the trend and monthly variation.. but coming unstuck with the future forcasting.
Heres what I have...
3 point moving average and figures are...
Sales Vol Trend Monthly Var.
Aug 72,100 - -
Sept 49,600 62,500 (12,900)
Oct 65,800 66,000 (200)
Nov 82,600 69,500 13,100
Dec 60,100 - -
monthly variation for october is (200) units.
The selling price has been set at 14.50
Monthly purchases are estimated to be 30% of the value of the forcast sales
Forcast Trend Variation Forcast Sal Vol. Forcast Sal. Forcast Pur.
Jan
i'm reading through the BPP books and my understanding is that you take the last trend and subtract from the first and divide by the number of trend months you have...
69,500-62,500/3 = 2,333.33
Then add this on to the last sales figure you have from December. But of those of you who know the answer you can tell i'm waaaaayyy off!! If anyone could please give me an idea of what i need to do it would be much appreciated.
Thank you,
I am currently working on moving averages and would like some assistance with the second part of the question. I am fine with working out the trend and monthly variation.. but coming unstuck with the future forcasting.
Heres what I have...
3 point moving average and figures are...
Sales Vol Trend Monthly Var.
Aug 72,100 - -
Sept 49,600 62,500 (12,900)
Oct 65,800 66,000 (200)
Nov 82,600 69,500 13,100
Dec 60,100 - -
monthly variation for october is (200) units.
The selling price has been set at 14.50
Monthly purchases are estimated to be 30% of the value of the forcast sales
Forcast Trend Variation Forcast Sal Vol. Forcast Sal. Forcast Pur.
Jan
i'm reading through the BPP books and my understanding is that you take the last trend and subtract from the first and divide by the number of trend months you have...
69,500-62,500/3 = 2,333.33
Then add this on to the last sales figure you have from December. But of those of you who know the answer you can tell i'm waaaaayyy off!! If anyone could please give me an idea of what i need to do it would be much appreciated.
Thank you,
0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 323 NEW! Qualifications 2022
- 165 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 88 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 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