Cash Management CBT 2 Task 2  Sales forecasting and trend
Smiller94
Registered Posts: 12
Hi All,
There is one question out of the two Cash Management (2013) assesments that I cannot for the life of me get to the bottom of.
It is task 2 part c) & d) calculating forecasted sales. All of the scripts I have read have a pattern of variation and can be worked out easily whereas with this question we don't.
If anybody could help I would be SO SO grateful. I can do part a) & b) no problem but c) and d) not so promising.
Thanks so much in advance.
There is one question out of the two Cash Management (2013) assesments that I cannot for the life of me get to the bottom of.
It is task 2 part c) & d) calculating forecasted sales. All of the scripts I have read have a pattern of variation and can be worked out easily whereas with this question we don't.
If anybody could help I would be SO SO grateful. I can do part a) & b) no problem but c) and d) not so promising.
Thanks so much in advance.
0
Comments

(c) So for period 13 = 2065 units
The monthly trend is 35, so all you do is keep adding 35 for the next period, so would be the following:
Period 14  2065 + 35= 2100 (take the 2065 from what is given in the question)
Period 15  2100 +35 = 2135 units
Period 16  2135 + 35 = 2170 units
(d) This covers the mark up/margin section and indexing  I would suggest you learn this as these are easy marks to get in the exam.
From the question, you can tell this is a markup, as the selling price is based on cost PLUS 40%, which is equivalent to 140%.
As the index equation goes, it is current year/base year for indexing 
(1)180/145 = 1.241737931
(2) 1.24 x 435 = £540
As this only represents only 100%, we need to add the 40%, so you simply multiply by 140 =
(3) 540 x 1.4 = £756
Hope this makes sense1 
Aww, Sabina!
Thank you so so so so much for coming back to me, that was very kind of you. Since writing the post I managed to work out part c) but I really appreciate it and your explanation of part d) was so helpful, I understand markup and margin but agree that I need to remind myself how to work out indexing, it all makes perfect sense and I will remeber this for my exam.
Thanks again!
0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 318 NEW! Qualifications 2022
 161 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 87 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 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 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