REQUIRED Use the information given below to prepare the following for July. August and September 2023: 4.1 Debtors Collection Schedule 4.2 Cash Budget (6 marks) (14 marks) INFORMATION Brentford Limited supplied the following budgeted information for 2023 : 1. The expected sales figures for the second and third quarters of 2023 are as follows: 2. Expenence has shown that sales 60% of the sales is for cash and the balance is on credit. Seventy percent ( 70% ) of the credit sales is collected in the month after the sale The balance is collected fwo months atter the sale. 3. Purchases of inventory are estimated to equai 50% of the sales. Forty paicert (40\%) of the purchases will be on credit and creditors are paid two months after the purchase: Tha rest wil be tor cash, pubject to a 10% cash discount. 4. Salaries and wages are budgeted at R80 000 per morth fram June to August 2029 . On 01 Saptember 2023 employees will receive an increase of 9.5% in their remuneration. 5. Marketing expenses are estimated at 10% of the total sales and payment is delayed by one month. 6. Administration expenses are expected to be R20 000 per month, peyabie monthly. 7. An investment of R100 000 wil be made in a fixed deposit account on 31 July 2023 interast ai 9% per year will be received monthly from August 2023. 8. Brentford limited expects to pay an interim dividend of 6 cents pet share on 31. August 2023. The issued share capital of the company consists of 300600 crdinary shares 9. The bank balande on 30 June 2023 is expected to be R40 000 (favourable)