20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for March and June 2025 exams.
Get your discount code >>

Forecasting

This topic has 1 reply, 2 voices, and was last updated 3 years ago by John Moffat.

Viewing 2 posts - 1 through 2 (of 2 total)

Author
Posts
December 17, 2021 at 6:02 pm #644473
dingdong02
Participant
- Topics: 14
- Replies: 1
Almond Ltd. had sales of $500,000 in January of 2000. It has an increasing trend in sales of $10000 per month and uses an additive model for seasonal variation. Seasonal variation is as follows.
January- March +$1000
April- June -$1000
July-September +$2000
October-December -$2000
Calculate forecasted sales for the month of December of the year 2002.
Ans) 848000
Sir, I’m getting 789000 can you explain this question?
December 18, 2021 at 8:09 am #644494
John Moffat
Keymaster
- Topics: 57
- Replies: 54655
By December 2002, there will have been 11+12+12 = 35 months of growth
Therefore the trend will have grown to 500,000 + (35 x 10,000) = 850,000.
The seasonal variation is – 2,000, therefore the forecast will be 850,000 – 2,000 = 848,000.
Author
Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.