Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA MA – FIA FMA › Cash budgets
- This topic has 8 replies, 2 voices, and was last updated 9 years ago by
John Moffat.
- AuthorPosts
- June 22, 2015 at 4:20 pm #258492
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,000Forecast the amount of cash that will be received in the month of April.
June 22, 2015 at 5:08 pm #258508In 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.
June 22, 2015 at 5:29 pm #258511Ok 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,800This question came from the previous mock exam made by Kaplan.
June 22, 2015 at 5:37 pm #258512I am confused because I don’t know where the 60% came from.
June 23, 2015 at 10:44 am #258568Ooops – 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 🙁
June 23, 2015 at 11:09 am #258571Sir repeat again why do we multiply the 60% with 50% and 40%?
June 23, 2015 at 11:13 am #258573The 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.
June 23, 2015 at 11:19 am #258575Ah ok sir now i get it! Thank u so much sir! 🙂
June 24, 2015 at 8:26 am #258680You are welcome 🙂
- AuthorPosts
- You must be logged in to reply to this topic.