Cash Management L4 AQ2013 PA2 Help?
Lisa_Carroll
Registered Posts: 10
Hi
I am doing the Cash Management practice assessment 2 2013 and I'm stuck (again) on how some of the balances are calculated. I have tried to work it out myself, and I'll write down what it is I'm doing so hopefully someone can tell me what it is I'm doing wrong.
Task 5b) Link to task question: https://flickr.com/photos/124836893@N07/15825413136/
End of period 4: Original and revised forecast trade receivables balances.
My calculation of original TR balance:
58% of P3 [2,740,000] = £1,589,200
62% of P2 [2,700,000] = £1,674,000
80% of P1 [2,500,000] = £2,000,000
Total = £5,263,200
The answer should be = £4,969,200
My calculation of revised [10% inc] TR balance:
40% of P2 [2,970,000] = £1,080,000
60% of P1 [2,750,000] = £1,500,000
Total = £2,580,000
The answer should be = £7,326,000
What am I doing wrong?
Task 5c)
"A company is considering a marketing campaign to increase demandd for it's product. The marketing campaign will cost £2 million over a two month period. The sales are expected to increase by £300,000 per month from month 3 onwards. In anticipation of the demand increase the company will increase inventory levels in months 13 by £200,000 per month. Inventory will be paid for in the month following purchase, the marketing caampaign will be paid for in month 2 and the sales are received in the month following sale."
The answer is: The cumulative cash flow will reduce by £2,400,000
How would you even attempt this?
Thank you in advance!
I am doing the Cash Management practice assessment 2 2013 and I'm stuck (again) on how some of the balances are calculated. I have tried to work it out myself, and I'll write down what it is I'm doing so hopefully someone can tell me what it is I'm doing wrong.
Task 5b) Link to task question: https://flickr.com/photos/124836893@N07/15825413136/
End of period 4: Original and revised forecast trade receivables balances.
My calculation of original TR balance:
58% of P3 [2,740,000] = £1,589,200
62% of P2 [2,700,000] = £1,674,000
80% of P1 [2,500,000] = £2,000,000
Total = £5,263,200
The answer should be = £4,969,200
My calculation of revised [10% inc] TR balance:
40% of P2 [2,970,000] = £1,080,000
60% of P1 [2,750,000] = £1,500,000
Total = £2,580,000
The answer should be = £7,326,000
What am I doing wrong?
Task 5c)
"A company is considering a marketing campaign to increase demandd for it's product. The marketing campaign will cost £2 million over a two month period. The sales are expected to increase by £300,000 per month from month 3 onwards. In anticipation of the demand increase the company will increase inventory levels in months 13 by £200,000 per month. Inventory will be paid for in the month following purchase, the marketing caampaign will be paid for in month 2 and the sales are received in the month following sale."
The answer is: The cumulative cash flow will reduce by £2,400,000
How would you even attempt this?
Thank you in advance!
1
Comments

5B) the answer would be
20% of P2 + 38% and 20% of P3 + P4 Balance
540,000 + 1,589,200 + 2,840,000= 4,969,200.
40% of P2 + P3 balance + P4 Balance
1,080,000 + 2,740,000 + 2,840,000 x 10% increase (x1.10)= 7,362, 200.
5C) This means the revenue/cost that will have a positive/negative impact on the cash flow.
Costs=
Cost of Marketing = £2,000,000 paid in month 2
Cost of Inventory = month 13 £200,000 per month= 200,000 x 3= 600,000
Inventory paid month after purchase therefore month 3 inventory will be paid in month 4. Therefore only 2 months inventory will be paid from the £600,000 which equals to £400,000.
The answer is
Cost of Marketing paid in P2 £2,000,000
Cost of Inventory paid £4,000,000
= £2,400,000.
This will reduce the cashflow by £2,400,0000 
Hi Shannq1
Could you explain in more detail how you got the figures for 5b?
If the 20% is left to pay from Period 1 then why is the calculation of £540000 based on 20% of P2??
Also how did you get the £1589000?
thanks
sam0 
In part C is 4,000,000 a mistake? I think it's meant to say 400,000?0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 248 NEW! Qualifications 2022
 138 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