QUESTION 4 Paul Bhd is estimating its needs for funds for the fourth quarter of the year 2019. The following table presents the forecasted monthly sales from July 2019 to January 2020: July 2019 Oct Aug 2019 Sept 2019 2019 Nov 2019 Dec 2019 Jan 2020 Sales revenue (RM) 120,000 100,000 110,000 120,000 130,000 140,000 150,000 Additional information: 1) 20% of sales are collected in the month of sales, 50% one month after the month of sales and 30% two months following the month of sales. 2) Purchases amounted to 60% of sales revenue and are made one month prior to anticipate sales. 3) Payments for the purchase are as follows: 50% in the month of purchases, 35% one month after purchases and 15% two month after purchases. 4) Wages and other expenses are 20% of the month's sales and the payment are made in the month which they are incurred. 5) A new machine with a cost of RM5,000 will be installed in September 2019 but the payment will be made in December 2019. 6) Opening cash balance on 1 October 2019 is expected to be RM20,000. Required: i) Prepare separate schedules for expected collections from customers and expected payments for purchases. (11 marks) ii) Prepare a cash budget for the month of October, November and December 2019. (14 marks) (Total: 25 Marks)