Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA FM Exams › XYZ Co – budgeted cash receipt from customer
- This topic has 6 replies, 3 voices, and was last updated 10 years ago by John Moffat.
- AuthorPosts
- December 4, 2014 at 11:53 am #217301
XYZ Co has forecast sales in Jan of $200,000 and that they will increase by 5% each month.
All sales are on credit, and 60% of customers pay after 1 month and the rest paying after 2 months.What cash receipt from customers will be budgeted for in May?
Please could you show me the workings for this, answer is £227,115. Thanks
December 4, 2014 at 12:29 pm #217310Think i can help with this one. What is asked is the money we are going to receive from rec in may ( not the rec value for may!) therefore all rec from jan & feb are already received and in may you are going to receive the 40% of MAR sales (200 x (1.05^2) x40%) = $88,200 and the 60% of APR sales (200 x (1.05^3) x 60%)= $138,915. Therefore the cash collected from rec in May= 88200+139915=$227,115
December 4, 2014 at 3:21 pm #217396Alua’s answer is correct.
December 4, 2014 at 4:58 pm #217504I don’t understand how in April its 60% of the customers, and March 40%??? Thanks
December 4, 2014 at 5:09 pm #217527The question says that 60% pay after 1 month, and 40% pay after 2 months.
December 4, 2014 at 5:20 pm #217537oh ye of course! I completely misread it. Thanks for that
December 4, 2014 at 7:36 pm #217645You are welcome 🙂
- AuthorPosts
- You must be logged in to reply to this topic.