Skip to content
ACCA exam results — Are you ready?Chat about it >>

Ask the Tutor ACCA MA

Cash budgets

DDan11y ago
ABC Ltd sells to both cash and credit customers. Its expects that 40% of its sales will be paid in for cash and of the remainder, 50% will be paid the month after sale, 40% two months after sale and the rest will remain unpaid. JAN- 100,000 FEB- 120,000 MAR- 140,000 APRIL- 150,000 Forecast the amount of cash that will be received in the month of April.
John MoffatJohn MoffatTutor11y ago#1
In future, please do not simply set me a test question - you must have an answer in the same book in which you found the question. You must tell me what problem you have with the answer, and then I will try and explain. In April you will receive 40% of the sales made in April - 40% x 150,000 = 60,000. Also, you will receive 50% of what was sold in March - 50% x 140,000 = 70,000. Also you will receive 40% of what was sold in Februaru - 40% x 120,000 = 48,000 So you just need to add together the three amounts.
DDan11y ago#2
Ok sir, I did same thing what you did but according to the answer sheet its April receipts: April sales 150,000×40% in cash 60,000 March sales 140,000×60%×50% 42000 February sales 120,000×60%×40% 28,800 This question came from the previous mock exam made by Kaplan.
DDan11y ago#3
I am confused because I don't know where the 60% came from.
John MoffatJohn MoffatTutor11y ago#4
Ooops - my mistake There is a trick in the question :-) It says 40% is paid in cash, and "of the remainder" 50% is one month after sale and 40% is two months after sale. So if 40% is paid in case, then the remainder is the other 60%. 50% of those 60% are paid one month later. Sorry :-(
DDan11y ago#5
Sir repeat again why do we multiply the 60% with 50% and 40%?
John MoffatJohn MoffatTutor11y ago#6
The auto-correct changed what I typed :-) What it should say is: It says 40% is paid in cash, and “of the remainder” 50% is one month after sale and 40% is two months after sale. So if 40% is paid in cash, then the remainder is the other 60%. 50% of those 60% are paid one month later and 40% of those 60% are paid two months later.
DDan11y ago#7
Ah ok sir now i get it! Thank u so much sir! :)
John MoffatJohn MoffatTutor11y ago#8
You are welcome :-)
Sign in to reply to this topic.